PREVIEW / etf_30min / 2001-06-08
file: by_date/etf_30min/2001/2001-06-08.parquet size: 13 KB rows: 319
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-06-08 09:30:00 | SPY | ETF | 127.7 | 127.87 | 127.5 | 127.69 | 1031600.0 |
| 2001-06-08 10:00:00 | SPY | ETF | 127.71 | 127.71 | 126.77 | 126.97 | 843300.0 |
| 2001-06-08 10:30:00 | SPY | ETF | 126.97 | 126.97 | 126.97 | 126.97 | 1000.0 |
| 2001-06-08 11:30:00 | SPY | ETF | 126.9 | 127.09 | 126.54 | 126.65 | 649100.0 |
| 2001-06-08 12:00:00 | SPY | ETF | 126.62 | 126.72 | 126.14 | 126.37 | 985100.0 |
| 2001-06-08 12:30:00 | SPY | ETF | 126.28 | 126.54 | 126.21 | 126.5 | 463900.0 |
| 2001-06-08 13:00:00 | SPY | ETF | 126.52 | 126.75 | 126.36 | 126.45 | 358200.0 |
| 2001-06-08 13:30:00 | SPY | ETF | 126.47 | 126.72 | 126.32 | 126.62 | 862700.0 |
| 2001-06-08 14:00:00 | SPY | ETF | 126.68 | 126.85 | 126.55 | 126.85 | 251100.0 |
| 2001-06-08 14:30:00 | SPY | ETF | 126.81 | 127.03 | 126.7 | 126.85 | 419400.0 |
| 2001-06-08 15:00:00 | SPY | ETF | 126.88 | 127.05 | 126.65 | 126.8 | 252800.0 |
| 2001-06-08 15:30:00 | SPY | ETF | 126.84 | 127.25 | 126.81 | 127.0 | 621900.0 |
| 2001-06-08 16:00:00 | SPY | ETF | 127.0 | 127.19 | 126.96 | 127.05 | 349800.0 |
| 2001-06-08 16:30:00 | SPY | ETF | 127.03 | 127.03 | 127.03 | 127.03 | 694900.0 |
| 2001-06-08 09:30:00 | QQQ | ETF | 48.72 | 48.77 | 47.9 | 48.21 | 10203400.0 |
| 2001-06-08 10:00:00 | QQQ | ETF | 48.21 | 48.26 | 47.54 | 47.81 | 7216400.0 |
| 2001-06-08 10:30:00 | QQQ | ETF | 47.79 | 47.95 | 47.63 | 47.8 | 2507000.0 |
| 2001-06-08 11:00:00 | QQQ | ETF | 47.8 | 47.83 | 47.4 | 47.53 | 2363600.0 |
| 2001-06-08 11:30:00 | QQQ | ETF | 47.55 | 47.78 | 47.35 | 47.37 | 5153700.0 |
| 2001-06-08 12:00:00 | QQQ | ETF | 47.35 | 47.46 | 46.95 | 47.19 | 5604300.0 |
| 2001-06-08 12:30:00 | QQQ | ETF | 47.22 | 47.4 | 47.01 | 47.37 | 2998200.0 |
| 2001-06-08 13:00:00 | QQQ | ETF | 47.3 | 47.49 | 47.15 | 47.17 | 2633900.0 |
| 2001-06-08 13:30:00 | QQQ | ETF | 47.16 | 47.33 | 47.07 | 47.33 | 3461600.0 |
| 2001-06-08 14:00:00 | QQQ | ETF | 47.33 | 47.45 | 47.2 | 47.39 | 1755900.0 |
| 2001-06-08 14:30:00 | QQQ | ETF | 47.38 | 47.7 | 47.31 | 47.43 | 2411100.0 |
| 2001-06-08 15:00:00 | QQQ | ETF | 47.45 | 47.54 | 47.18 | 47.2 | 2897200.0 |
| 2001-06-08 15:30:00 | QQQ | ETF | 47.19 | 47.5 | 47.17 | 47.27 | 3596000.0 |
| 2001-06-08 16:00:00 | QQQ | ETF | 47.27 | 47.36 | 47.23 | 47.26 | 984000.0 |
| 2001-06-08 16:30:00 | QQQ | ETF | 47.27 | 47.45 | 47.27 | 47.3 | 6400.0 |
| 2001-06-08 17:00:00 | QQQ | ETF | 47.27 | 47.35 | 47.25 | 47.31 | 11800.0 |
| 2001-06-08 17:30:00 | QQQ | ETF | 47.31 | 47.35 | 47.25 | 47.35 | 2700.0 |
| 2001-06-08 18:00:00 | QQQ | ETF | 47.28 | 47.28 | 47.28 | 47.28 | 4000.0 |
| 2001-06-08 09:30:00 | IWM | ETF | 51.25 | 51.3 | 51.15 | 51.175 | 50000.0 |
| 2001-06-08 10:00:00 | IWM | ETF | 51.165 | 51.275 | 51.025 | 51.11 | 49400.0 |
| 2001-06-08 10:30:00 | IWM | ETF | 51.15 | 51.17 | 51.145 | 51.17 | 26200.0 |
| 2001-06-08 11:00:00 | IWM | ETF | 51.075 | 51.075 | 51.075 | 51.075 | 200.0 |
| 2001-06-08 11:30:00 | IWM | ETF | 51.075 | 51.075 | 50.725 | 50.9 | 11000.0 |
| 2001-06-08 12:00:00 | IWM | ETF | 50.725 | 50.875 | 50.525 | 50.525 | 48600.0 |
| 2001-06-08 12:30:00 | IWM | ETF | 50.75 | 50.75 | 50.75 | 50.75 | 3800.0 |
| 2001-06-08 13:00:00 | IWM | ETF | 50.745 | 50.875 | 50.655 | 50.875 | 44000.0 |
| 2001-06-08 13:30:00 | IWM | ETF | 50.775 | 50.87 | 50.625 | 50.87 | 103600.0 |
| 2001-06-08 14:00:00 | IWM | ETF | 50.875 | 51.025 | 50.825 | 50.875 | 85600.0 |
| 2001-06-08 14:30:00 | IWM | ETF | 50.9 | 51.075 | 50.9 | 51.075 | 2200.0 |
| 2001-06-08 15:00:00 | IWM | ETF | 51.075 | 51.125 | 50.975 | 51.075 | 41800.0 |
| 2001-06-08 15:30:00 | IWM | ETF | 51.1 | 51.125 | 50.855 | 50.855 | 58000.0 |
| 2001-06-08 16:00:00 | IWM | ETF | 50.95 | 50.95 | 50.95 | 50.95 | 5000.0 |
| 2001-06-08 09:30:00 | DIA | ETF | 110.8 | 110.8 | 110.5 | 110.75 | 200600.0 |
| 2001-06-08 10:00:00 | DIA | ETF | 110.7 | 110.7 | 109.9 | 110.0 | 144500.0 |
| 2001-06-08 10:30:00 | DIA | ETF | 110.0 | 110.1 | 110.0 | 110.1 | 3000.0 |
| 2001-06-08 11:30:00 | DIA | ETF | 110.1 | 110.1 | 109.76 | 109.82 | 164700.0 |
> showing 50 of 319 rows — these rows as CSV