PREVIEW / etf_30min / 2001-03-08
file: by_date/etf_30min/2001/2001-03-08.parquet size: 14 KB rows: 351
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 |
|---|---|---|---|---|---|---|---|
| 2001-03-08 09:30:00 | SPY | ETF | 126.6 | 127.21 | 126.45 | 127.0 | 949800.0 |
| 2001-03-08 10:00:00 | SPY | ETF | 127.08 | 127.08 | 126.41 | 126.41 | 650500.0 |
| 2001-03-08 10:30:00 | SPY | ETF | 126.42 | 126.5 | 126.21 | 126.44 | 366300.0 |
| 2001-03-08 11:00:00 | SPY | ETF | 126.43 | 126.92 | 126.14 | 126.8 | 566500.0 |
| 2001-03-08 11:30:00 | SPY | ETF | 126.85 | 127.22 | 126.59 | 127.05 | 336300.0 |
| 2001-03-08 12:00:00 | SPY | ETF | 127.07 | 127.07 | 126.66 | 126.79 | 275800.0 |
| 2001-03-08 12:30:00 | SPY | ETF | 126.7 | 126.89 | 126.47 | 126.57 | 382500.0 |
| 2001-03-08 13:00:00 | SPY | ETF | 126.56 | 126.84 | 126.31 | 126.55 | 217400.0 |
| 2001-03-08 13:30:00 | SPY | ETF | 126.52 | 126.79 | 126.42 | 126.64 | 176400.0 |
| 2001-03-08 14:00:00 | SPY | ETF | 126.54 | 126.61 | 126.31 | 126.54 | 85500.0 |
| 2001-03-08 14:30:00 | SPY | ETF | 126.41 | 126.66 | 126.2 | 126.5 | 160900.0 |
| 2001-03-08 15:00:00 | SPY | ETF | 126.5 | 126.97 | 126.25 | 126.83 | 338600.0 |
| 2001-03-08 15:30:00 | SPY | ETF | 126.76 | 127.06 | 126.62 | 126.9 | 878600.0 |
| 2001-03-08 16:00:00 | SPY | ETF | 126.85 | 127.19 | 126.78 | 127.0 | 420500.0 |
| 2001-03-08 17:00:00 | SPY | ETF | 126.52 | 126.52 | 126.12 | 126.12 | 50100.0 |
| 2001-03-08 09:30:00 | QQQ | ETF | 49.35 | 49.8 | 49.18 | 49.35 | 5731600.0 |
| 2001-03-08 10:00:00 | QQQ | ETF | 49.31 | 49.42 | 48.37 | 48.49 | 7342400.0 |
| 2001-03-08 10:30:00 | QQQ | ETF | 48.5 | 48.82 | 48.4 | 48.62 | 3811300.0 |
| 2001-03-08 11:00:00 | QQQ | ETF | 48.6 | 48.96 | 48.38 | 48.9 | 4384800.0 |
| 2001-03-08 11:30:00 | QQQ | ETF | 48.9 | 49.25 | 48.7 | 49.07 | 3106800.0 |
| 2001-03-08 12:00:00 | QQQ | ETF | 49.07 | 49.15 | 48.71 | 48.83 | 1445800.0 |
| 2001-03-08 12:30:00 | QQQ | ETF | 48.76 | 48.9 | 48.5 | 48.65 | 1855100.0 |
| 2001-03-08 13:00:00 | QQQ | ETF | 48.65 | 48.77 | 48.4 | 48.6 | 1862700.0 |
| 2001-03-08 13:30:00 | QQQ | ETF | 48.59 | 48.87 | 48.45 | 48.77 | 1787000.0 |
| 2001-03-08 14:00:00 | QQQ | ETF | 48.74 | 48.76 | 48.3 | 48.43 | 1985700.0 |
| 2001-03-08 14:30:00 | QQQ | ETF | 48.43 | 48.6 | 48.1 | 48.5 | 3067100.0 |
| 2001-03-08 15:00:00 | QQQ | ETF | 48.53 | 48.85 | 48.29 | 48.65 | 3197600.0 |
| 2001-03-08 15:30:00 | QQQ | ETF | 48.74 | 48.75 | 48.15 | 48.27 | 4190400.0 |
| 2001-03-08 16:00:00 | QQQ | ETF | 48.25 | 49.19 | 48.15 | 48.5 | 1489500.0 |
| 2001-03-08 16:30:00 | QQQ | ETF | 48.5 | 48.69 | 48.35 | 48.53 | 59600.0 |
| 2001-03-08 17:00:00 | QQQ | ETF | 48.51 | 48.53 | 47.19 | 47.38 | 1086300.0 |
| 2001-03-08 17:30:00 | QQQ | ETF | 47.4 | 47.6 | 47.3 | 47.55 | 97500.0 |
| 2001-03-08 18:00:00 | QQQ | ETF | 47.51 | 47.6 | 47.34 | 47.45 | 66700.0 |
| 2001-03-08 18:30:00 | QQQ | ETF | 47.5 | 47.5 | 47.5 | 47.5 | 400.0 |
| 2001-03-08 09:30:00 | IWM | ETF | 48.295 | 48.305 | 48.21 | 48.305 | 8800.0 |
| 2001-03-08 10:00:00 | IWM | ETF | 48.34 | 48.4 | 48.125 | 48.135 | 129200.0 |
| 2001-03-08 10:30:00 | IWM | ETF | 48.025 | 48.2 | 48.025 | 48.165 | 1200.0 |
| 2001-03-08 11:00:00 | IWM | ETF | 48.17 | 48.175 | 48.01 | 48.175 | 2200.0 |
| 2001-03-08 11:30:00 | IWM | ETF | 48.17 | 48.25 | 48.155 | 48.25 | 201400.0 |
| 2001-03-08 12:00:00 | IWM | ETF | 48.15 | 48.3 | 48.1 | 48.11 | 407400.0 |
| 2001-03-08 12:30:00 | IWM | ETF | 48.275 | 48.275 | 48.075 | 48.075 | 3000.0 |
| 2001-03-08 13:00:00 | IWM | ETF | 48.125 | 48.15 | 48.055 | 48.15 | 1400.0 |
| 2001-03-08 13:30:00 | IWM | ETF | 48.2 | 48.2 | 48.0 | 48.175 | 16600.0 |
| 2001-03-08 14:00:00 | IWM | ETF | 48.16 | 48.175 | 48.16 | 48.175 | 800.0 |
| 2001-03-08 14:30:00 | IWM | ETF | 48.12 | 48.12 | 47.975 | 47.975 | 2800.0 |
| 2001-03-08 15:00:00 | IWM | ETF | 48.115 | 48.12 | 47.925 | 48.12 | 3200.0 |
| 2001-03-08 15:30:00 | IWM | ETF | 48.05 | 48.15 | 47.915 | 47.95 | 48800.0 |
| 2001-03-08 16:00:00 | IWM | ETF | 48.0 | 48.0 | 47.9 | 47.9 | 2400.0 |
| 2001-03-08 09:30:00 | DIA | ETF | 107.01 | 107.89 | 107.01 | 107.85 | 474300.0 |
| 2001-03-08 10:00:00 | DIA | ETF | 107.9 | 107.9 | 107.4 | 107.5 | 158200.0 |
> showing 50 of 351 rows — these rows as CSV