PREVIEW / etf_30min / 2006-02-17
file: by_date/etf_30min/2006/2006-02-17.parquet size: 57 KB rows: 2,119
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2006-02-17 07:00:00 | SPY | ETF | 129.03 | 129.06 | 128.99 | 129.06 | 15400.0 |
| 2006-02-17 07:30:00 | SPY | ETF | 129.07 | 129.11 | 129.05 | 129.11 | 47500.0 |
| 2006-02-17 08:00:00 | SPY | ETF | 129.03 | 129.13 | 128.99 | 129.12 | 589700.0 |
| 2006-02-17 08:30:00 | SPY | ETF | 129.11 | 129.16 | 128.98 | 129.09 | 667200.0 |
| 2006-02-17 09:00:00 | SPY | ETF | 129.09 | 129.2 | 129.05 | 129.08 | 827500.0 |
| 2006-02-17 09:30:00 | SPY | ETF | 129.09 | 129.16 | 128.8 | 128.9 | 6883000.0 |
| 2006-02-17 10:00:00 | SPY | ETF | 128.91 | 128.93 | 128.58 | 128.65 | 4853300.0 |
| 2006-02-17 10:30:00 | SPY | ETF | 128.66 | 128.81 | 128.64 | 128.72 | 2891000.0 |
| 2006-02-17 11:00:00 | SPY | ETF | 128.72 | 128.99 | 128.63 | 128.81 | 4294300.0 |
| 2006-02-17 11:30:00 | SPY | ETF | 128.8 | 128.93 | 128.73 | 128.89 | 1769500.0 |
| 2006-02-17 12:00:00 | SPY | ETF | 128.89 | 129.05 | 128.88 | 128.94 | 2186100.0 |
| 2006-02-17 12:30:00 | SPY | ETF | 128.93 | 129.01 | 128.84 | 128.97 | 1403400.0 |
| 2006-02-17 13:00:00 | SPY | ETF | 128.98 | 129.05 | 128.88 | 128.96 | 1513600.0 |
| 2006-02-17 13:30:00 | SPY | ETF | 128.95 | 129.14 | 128.93 | 129.02 | 972700.0 |
| 2006-02-17 14:00:00 | SPY | ETF | 129.03 | 129.1 | 128.96 | 129.07 | 1090700.0 |
| 2006-02-17 14:30:00 | SPY | ETF | 129.06 | 129.15 | 129.01 | 129.12 | 1110900.0 |
| 2006-02-17 15:00:00 | SPY | ETF | 129.1 | 129.14 | 128.76 | 128.81 | 2707100.0 |
| 2006-02-17 15:30:00 | SPY | ETF | 128.81 | 129.1 | 128.76 | 128.8888 | 5107800.0 |
| 2006-02-17 16:00:00 | SPY | ETF | 128.88 | 128.9 | 128.81 | 128.82 | 694900.0 |
| 2006-02-17 16:30:00 | SPY | ETF | 128.83 | 128.83 | 128.81 | 128.81 | 3900.0 |
| 2006-02-17 17:00:00 | SPY | ETF | 128.8 | 128.82 | 128.7 | 128.73 | 12800.0 |
| 2006-02-17 18:00:00 | SPY | ETF | 128.78 | 128.8 | 128.78 | 128.8 | 1800.0 |
| 2006-02-17 18:30:00 | SPY | ETF | 128.83 | 128.86 | 128.83 | 128.86 | 1300.0 |
| 2006-02-17 19:00:00 | SPY | ETF | 128.86 | 128.86 | 128.86 | 128.86 | 200.0 |
| 2006-02-17 09:30:00 | QQQ | ETF | 41.45 | 41.46 | 41.26 | 41.35 | 16453200.0 |
| 2006-02-17 10:00:00 | QQQ | ETF | 41.34 | 41.36 | 41.26 | 41.29 | 8177700.0 |
| 2006-02-17 10:30:00 | QQQ | ETF | 41.29 | 41.37 | 41.28 | 41.32 | 5240400.0 |
| 2006-02-17 11:00:00 | QQQ | ETF | 41.32 | 41.43 | 41.3 | 41.38 | 4855600.0 |
| 2006-02-17 11:30:00 | QQQ | ETF | 41.38 | 41.39 | 41.32 | 41.36 | 2478800.0 |
| 2006-02-17 12:00:00 | QQQ | ETF | 41.36 | 41.43 | 41.36 | 41.39 | 3550200.0 |
| 2006-02-17 12:30:00 | QQQ | ETF | 41.39 | 41.41 | 41.36 | 41.38 | 2652700.0 |
| 2006-02-17 13:00:00 | QQQ | ETF | 41.38 | 41.42 | 41.38 | 41.39 | 1687000.0 |
| 2006-02-17 13:30:00 | QQQ | ETF | 41.39 | 41.45 | 41.39 | 41.43 | 4141200.0 |
| 2006-02-17 14:00:00 | QQQ | ETF | 41.43 | 41.44 | 41.4 | 41.44 | 1479400.0 |
| 2006-02-17 14:30:00 | QQQ | ETF | 41.44 | 41.44 | 41.38 | 41.4 | 2946500.0 |
| 2006-02-17 15:00:00 | QQQ | ETF | 41.4 | 41.43 | 41.2 | 41.23 | 10599100.0 |
| 2006-02-17 15:30:00 | QQQ | ETF | 41.23 | 41.27 | 41.2 | 41.22 | 9789500.0 |
| 2006-02-17 08:00:00 | IWM | ETF | 72.83 | 72.84 | 72.83 | 72.83 | 16200.0 |
| 2006-02-17 08:30:00 | IWM | ETF | 72.8 | 72.8 | 72.74 | 72.79 | 54000.0 |
| 2006-02-17 09:00:00 | IWM | ETF | 72.78 | 72.83 | 72.74 | 72.83 | 95500.0 |
| 2006-02-17 09:30:00 | IWM | ETF | 72.83 | 72.83 | 72.44 | 72.51 | 1618200.0 |
| 2006-02-17 10:00:00 | IWM | ETF | 72.52 | 72.58 | 72.3 | 72.4 | 1484900.0 |
| 2006-02-17 10:30:00 | IWM | ETF | 72.39 | 72.55 | 72.39 | 72.5 | 1621000.0 |
| 2006-02-17 11:00:00 | IWM | ETF | 72.5 | 72.61 | 72.44 | 72.58 | 1076900.0 |
| 2006-02-17 11:30:00 | IWM | ETF | 72.59 | 72.73 | 72.55 | 72.7 | 1199600.0 |
| 2006-02-17 12:00:00 | IWM | ETF | 72.71 | 72.86 | 72.71 | 72.73 | 1228600.0 |
| 2006-02-17 12:30:00 | IWM | ETF | 72.72 | 72.79 | 72.66 | 72.74 | 984700.0 |
| 2006-02-17 13:00:00 | IWM | ETF | 72.74 | 72.79 | 72.66 | 72.67 | 728300.0 |
| 2006-02-17 13:30:00 | IWM | ETF | 72.68 | 72.85 | 72.67 | 72.8 | 1016100.0 |
| 2006-02-17 14:00:00 | IWM | ETF | 72.79 | 72.83 | 72.73 | 72.82 | 742300.0 |
> showing 50 of 2,119 rows — these rows as CSV