PREVIEW / etf_30min / 2002-03-15
file: by_date/etf_30min/2002/2002-03-15.parquet size: 17 KB rows: 480
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 |
|---|---|---|---|---|---|---|---|
| 2002-03-15 09:30:00 | SPY | ETF | 115.97 | 116.37 | 115.92 | 116.13 | 3924600.0 |
| 2002-03-15 10:00:00 | SPY | ETF | 116.11 | 116.33 | 115.9 | 116.21 | 2992800.0 |
| 2002-03-15 10:30:00 | SPY | ETF | 116.22 | 116.54 | 115.99 | 116.5 | 1732800.0 |
| 2002-03-15 11:00:00 | SPY | ETF | 116.51 | 116.87 | 116.48 | 116.8 | 2972200.0 |
| 2002-03-15 11:30:00 | SPY | ETF | 116.8 | 116.83 | 116.61 | 116.7 | 666000.0 |
| 2002-03-15 12:00:00 | SPY | ETF | 116.69 | 116.79 | 116.32 | 116.54 | 1846800.0 |
| 2002-03-15 12:30:00 | SPY | ETF | 116.53 | 116.7 | 116.44 | 116.69 | 699000.0 |
| 2002-03-15 13:00:00 | SPY | ETF | 116.7 | 116.7 | 116.43 | 116.47 | 453700.0 |
| 2002-03-15 13:30:00 | SPY | ETF | 116.48 | 116.63 | 116.46 | 116.55 | 662700.0 |
| 2002-03-15 14:00:00 | SPY | ETF | 116.57 | 116.8 | 116.56 | 116.79 | 393500.0 |
| 2002-03-15 14:30:00 | SPY | ETF | 116.78 | 116.94 | 116.71 | 116.94 | 853900.0 |
| 2002-03-15 15:00:00 | SPY | ETF | 116.92 | 116.95 | 116.55 | 116.6 | 1303700.0 |
| 2002-03-15 15:30:00 | SPY | ETF | 116.62 | 116.85 | 116.6 | 116.79 | 903700.0 |
| 2002-03-15 16:00:00 | SPY | ETF | 116.85 | 116.94 | 116.64 | 116.7 | 1324800.0 |
| 2002-03-15 16:30:00 | SPY | ETF | 116.58 | 116.65 | 116.58 | 116.64 | 137500.0 |
| 2002-03-15 17:00:00 | SPY | ETF | 116.6 | 116.6 | 116.6 | 116.6 | 700.0 |
| 2002-03-15 18:00:00 | SPY | ETF | 116.66 | 116.66 | 116.66 | 116.66 | 200.0 |
| 2002-03-15 09:30:00 | QQQ | ETF | 36.89 | 36.99 | 36.67 | 36.75 | 10348100.0 |
| 2002-03-15 10:00:00 | QQQ | ETF | 36.75 | 37.05 | 36.59 | 36.96 | 6771300.0 |
| 2002-03-15 10:30:00 | QQQ | ETF | 36.96 | 37.13 | 36.84 | 37.08 | 6825800.0 |
| 2002-03-15 11:00:00 | QQQ | ETF | 37.09 | 37.22 | 37.06 | 37.12 | 5434000.0 |
| 2002-03-15 11:30:00 | QQQ | ETF | 37.1 | 37.15 | 37.04 | 37.08 | 2006500.0 |
| 2002-03-15 12:00:00 | QQQ | ETF | 37.07 | 37.16 | 36.81 | 36.97 | 5157200.0 |
| 2002-03-15 12:30:00 | QQQ | ETF | 36.96 | 37.1 | 36.9 | 37.1 | 1944800.0 |
| 2002-03-15 13:00:00 | QQQ | ETF | 37.08 | 37.11 | 36.94 | 36.97 | 1260800.0 |
| 2002-03-15 13:30:00 | QQQ | ETF | 36.96 | 37.07 | 36.95 | 37.02 | 1195900.0 |
| 2002-03-15 14:00:00 | QQQ | ETF | 37.02 | 37.17 | 37.02 | 37.15 | 1803000.0 |
| 2002-03-15 14:30:00 | QQQ | ETF | 37.15 | 37.33 | 37.14 | 37.25 | 5546500.0 |
| 2002-03-15 15:00:00 | QQQ | ETF | 37.24 | 37.25 | 36.96 | 37.0 | 3496900.0 |
| 2002-03-15 15:30:00 | QQQ | ETF | 37.0 | 37.21 | 36.99 | 37.15 | 5587000.0 |
| 2002-03-15 16:00:00 | QQQ | ETF | 37.2 | 37.26 | 37.15 | 37.21 | 3036100.0 |
| 2002-03-15 16:30:00 | QQQ | ETF | 37.22 | 37.25 | 37.2 | 37.2 | 30000.0 |
| 2002-03-15 17:00:00 | QQQ | ETF | 37.23 | 37.28 | 37.2 | 37.28 | 185400.0 |
| 2002-03-15 17:30:00 | QQQ | ETF | 37.23 | 37.29 | 37.23 | 37.29 | 549200.0 |
| 2002-03-15 18:00:00 | QQQ | ETF | 37.29 | 37.3 | 37.28 | 37.28 | 2400.0 |
| 2002-03-15 09:30:00 | IWM | ETF | 49.305 | 49.375 | 49.05 | 49.285 | 74200.0 |
| 2002-03-15 10:00:00 | IWM | ETF | 49.275 | 49.31 | 49.185 | 49.295 | 441000.0 |
| 2002-03-15 10:30:00 | IWM | ETF | 49.295 | 49.47 | 49.25 | 49.47 | 152600.0 |
| 2002-03-15 11:00:00 | IWM | ETF | 49.4 | 49.59 | 49.4 | 49.58 | 135200.0 |
| 2002-03-15 11:30:00 | IWM | ETF | 49.58 | 49.67 | 49.53 | 49.65 | 46600.0 |
| 2002-03-15 12:00:00 | IWM | ETF | 49.65 | 49.66 | 49.475 | 49.59 | 72200.0 |
| 2002-03-15 12:30:00 | IWM | ETF | 49.575 | 49.59 | 49.56 | 49.59 | 27200.0 |
| 2002-03-15 13:00:00 | IWM | ETF | 49.575 | 49.6 | 49.575 | 49.59 | 8000.0 |
| 2002-03-15 13:30:00 | IWM | ETF | 49.58 | 49.625 | 49.5 | 49.615 | 33800.0 |
| 2002-03-15 14:00:00 | IWM | ETF | 49.61 | 49.685 | 49.545 | 49.675 | 25600.0 |
| 2002-03-15 14:30:00 | IWM | ETF | 49.73 | 49.8 | 49.675 | 49.755 | 52000.0 |
| 2002-03-15 15:00:00 | IWM | ETF | 49.79 | 49.79 | 49.585 | 49.585 | 83600.0 |
| 2002-03-15 15:30:00 | IWM | ETF | 49.66 | 49.67 | 49.535 | 49.655 | 169200.0 |
| 2002-03-15 16:00:00 | IWM | ETF | 49.66 | 49.66 | 49.625 | 49.625 | 44400.0 |
| 2002-03-15 09:30:00 | DIA | ETF | 105.5 | 105.7 | 105.3 | 105.37 | 2054000.0 |
> showing 50 of 480 rows — these rows as CSV