PREVIEW / etf_30min / 2001-03-06
file: by_date/etf_30min/2001/2001-03-06.parquet size: 14 KB rows: 356
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-06 09:30:00 | SPY | ETF | 126.35 | 126.5 | 126.05 | 126.39 | 1300600.0 |
| 2001-03-06 10:00:00 | SPY | ETF | 126.4 | 127.19 | 126.26 | 127.06 | 727800.0 |
| 2001-03-06 10:30:00 | SPY | ETF | 126.92 | 127.3 | 126.77 | 127.0 | 326900.0 |
| 2001-03-06 11:00:00 | SPY | ETF | 127.0 | 127.09 | 126.61 | 126.61 | 546800.0 |
| 2001-03-06 11:30:00 | SPY | ETF | 126.59 | 126.94 | 126.59 | 126.74 | 162600.0 |
| 2001-03-06 12:00:00 | SPY | ETF | 126.71 | 126.84 | 126.2 | 126.25 | 226700.0 |
| 2001-03-06 12:30:00 | SPY | ETF | 126.22 | 126.41 | 125.86 | 126.27 | 977100.0 |
| 2001-03-06 13:00:00 | SPY | ETF | 126.39 | 126.6 | 126.14 | 126.5 | 113300.0 |
| 2001-03-06 13:30:00 | SPY | ETF | 126.55 | 126.84 | 126.31 | 126.54 | 330800.0 |
| 2001-03-06 14:00:00 | SPY | ETF | 126.51 | 126.65 | 125.96 | 126.15 | 261600.0 |
| 2001-03-06 14:30:00 | SPY | ETF | 126.25 | 126.38 | 125.75 | 126.09 | 456200.0 |
| 2001-03-06 15:00:00 | SPY | ETF | 126.16 | 126.42 | 125.82 | 126.1 | 214500.0 |
| 2001-03-06 15:30:00 | SPY | ETF | 126.02 | 126.02 | 125.6 | 125.87 | 766800.0 |
| 2001-03-06 16:00:00 | SPY | ETF | 125.74 | 126.12 | 125.74 | 126.05 | 325000.0 |
| 2001-03-06 16:30:00 | SPY | ETF | 126.0 | 126.0 | 126.0 | 126.0 | 600.0 |
| 2001-03-06 17:30:00 | SPY | ETF | 126.0 | 126.0 | 125.93 | 125.93 | 800.0 |
| 2001-03-06 09:30:00 | QQQ | ETF | 49.3 | 50.02 | 49.25 | 49.72 | 9246900.0 |
| 2001-03-06 10:00:00 | QQQ | ETF | 49.77 | 50.44 | 49.7 | 50.26 | 6960300.0 |
| 2001-03-06 10:30:00 | QQQ | ETF | 50.29 | 50.6 | 50.04 | 50.26 | 5262600.0 |
| 2001-03-06 11:00:00 | QQQ | ETF | 50.27 | 50.35 | 49.98 | 50.01 | 4215300.0 |
| 2001-03-06 11:30:00 | QQQ | ETF | 50.0 | 50.39 | 50.0 | 50.25 | 2943600.0 |
| 2001-03-06 12:00:00 | QQQ | ETF | 50.3 | 50.37 | 49.9 | 50.01 | 2495700.0 |
| 2001-03-06 12:30:00 | QQQ | ETF | 50.0 | 50.1 | 49.74 | 50.05 | 2491600.0 |
| 2001-03-06 13:00:00 | QQQ | ETF | 50.05 | 50.42 | 49.9 | 50.3 | 2853500.0 |
| 2001-03-06 13:30:00 | QQQ | ETF | 50.32 | 50.66 | 50.17 | 50.45 | 3508500.0 |
| 2001-03-06 14:00:00 | QQQ | ETF | 50.46 | 50.55 | 49.9 | 50.05 | 3009600.0 |
| 2001-03-06 14:30:00 | QQQ | ETF | 50.04 | 50.23 | 49.54 | 49.94 | 3856300.0 |
| 2001-03-06 15:00:00 | QQQ | ETF | 49.9 | 50.1 | 49.56 | 49.73 | 4777800.0 |
| 2001-03-06 15:30:00 | QQQ | ETF | 49.66 | 49.75 | 49.1 | 49.27 | 5833700.0 |
| 2001-03-06 16:00:00 | QQQ | ETF | 49.32 | 49.5 | 48.65 | 49.39 | 1108900.0 |
| 2001-03-06 16:30:00 | QQQ | ETF | 49.35 | 49.65 | 49.35 | 49.5 | 42100.0 |
| 2001-03-06 17:00:00 | QQQ | ETF | 49.51 | 49.75 | 49.1 | 49.28 | 155300.0 |
| 2001-03-06 17:30:00 | QQQ | ETF | 49.3 | 49.4 | 49.0 | 49.03 | 57600.0 |
| 2001-03-06 18:00:00 | QQQ | ETF | 49.15 | 49.2 | 49.0 | 49.1 | 12600.0 |
| 2001-03-06 09:30:00 | IWM | ETF | 48.0 | 48.1 | 47.9 | 48.0 | 63600.0 |
| 2001-03-06 10:00:00 | IWM | ETF | 48.175 | 48.175 | 48.0 | 48.125 | 127000.0 |
| 2001-03-06 10:30:00 | IWM | ETF | 48.14 | 48.15 | 48.0 | 48.15 | 31400.0 |
| 2001-03-06 11:00:00 | IWM | ETF | 48.19 | 48.195 | 48.05 | 48.05 | 69000.0 |
| 2001-03-06 11:30:00 | IWM | ETF | 48.025 | 48.125 | 47.975 | 48.095 | 49800.0 |
| 2001-03-06 12:00:00 | IWM | ETF | 48.08 | 48.095 | 47.97 | 48.075 | 29200.0 |
| 2001-03-06 12:30:00 | IWM | ETF | 48.075 | 48.075 | 47.815 | 47.815 | 20600.0 |
| 2001-03-06 13:00:00 | IWM | ETF | 48.125 | 48.15 | 48.1 | 48.15 | 2400.0 |
| 2001-03-06 13:30:00 | IWM | ETF | 48.15 | 48.175 | 48.15 | 48.175 | 4600.0 |
| 2001-03-06 14:00:00 | IWM | ETF | 48.0 | 48.175 | 48.0 | 48.025 | 61800.0 |
| 2001-03-06 14:30:00 | IWM | ETF | 47.905 | 48.125 | 47.825 | 48.0 | 6000.0 |
| 2001-03-06 15:00:00 | IWM | ETF | 48.025 | 48.075 | 48.0 | 48.0 | 17000.0 |
| 2001-03-06 15:30:00 | IWM | ETF | 48.0 | 48.05 | 47.95 | 48.0 | 6000.0 |
| 2001-03-06 16:00:00 | IWM | ETF | 48.075 | 48.075 | 48.05 | 48.05 | 6200.0 |
| 2001-03-06 09:30:00 | DIA | ETF | 106.5 | 106.8 | 106.45 | 106.65 | 456700.0 |
| 2001-03-06 10:00:00 | DIA | ETF | 106.55 | 107.14 | 106.51 | 106.86 | 164800.0 |
> showing 50 of 356 rows — these rows as CSV