PREVIEW / etf_30min / 2002-07-12
file: by_date/etf_30min/2002/2002-07-12.parquet size: 20 KB rows: 524
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-07-12 09:30:00 | SPY | ETF | 93.33 | 93.54 | 91.55 | 92.29 | 5659400.0 |
| 2002-07-12 10:00:00 | SPY | ETF | 92.3 | 93.43 | 92.1 | 93.04 | 5612700.0 |
| 2002-07-12 10:30:00 | SPY | ETF | 93.0 | 93.89 | 92.98 | 93.56 | 3086900.0 |
| 2002-07-12 11:00:00 | SPY | ETF | 93.56 | 93.69 | 93.05 | 93.26 | 1837400.0 |
| 2002-07-12 11:30:00 | SPY | ETF | 93.27 | 93.52 | 92.83 | 93.02 | 1886000.0 |
| 2002-07-12 12:00:00 | SPY | ETF | 93.06 | 93.55 | 92.78 | 93.39 | 779700.0 |
| 2002-07-12 12:30:00 | SPY | ETF | 93.36 | 93.65 | 93.31 | 93.61 | 795100.0 |
| 2002-07-12 13:00:00 | SPY | ETF | 93.66 | 93.69 | 93.08 | 93.08 | 789700.0 |
| 2002-07-12 13:30:00 | SPY | ETF | 93.13 | 93.45 | 93.0 | 93.06 | 868800.0 |
| 2002-07-12 14:00:00 | SPY | ETF | 93.1 | 93.19 | 92.38 | 92.52 | 1861600.0 |
| 2002-07-12 14:30:00 | SPY | ETF | 92.53 | 92.59 | 91.52 | 92.07 | 3629900.0 |
| 2002-07-12 15:00:00 | SPY | ETF | 92.11 | 92.25 | 91.68 | 92.0 | 3531700.0 |
| 2002-07-12 15:30:00 | SPY | ETF | 92.03 | 92.69 | 91.95 | 92.46 | 2630200.0 |
| 2002-07-12 16:00:00 | SPY | ETF | 92.46 | 92.7 | 91.85 | 92.0 | 1914100.0 |
| 2002-07-12 16:30:00 | SPY | ETF | 92.0 | 93.06 | 91.81 | 91.99 | 1603400.0 |
| 2002-07-12 17:00:00 | SPY | ETF | 91.85 | 92.67 | 91.85 | 91.85 | 808300.0 |
| 2002-07-12 17:30:00 | SPY | ETF | 91.95 | 91.95 | 91.5 | 91.62 | 6600.0 |
| 2002-07-12 18:00:00 | SPY | ETF | 91.6 | 91.6 | 91.6 | 91.6 | 100.0 |
| 2002-07-12 09:30:00 | QQQ | ETF | 25.25 | 25.32 | 24.55 | 24.86 | 23561900.0 |
| 2002-07-12 10:00:00 | QQQ | ETF | 24.86 | 25.35 | 24.73 | 25.2 | 15704200.0 |
| 2002-07-12 10:30:00 | QQQ | ETF | 25.19 | 25.52 | 25.17 | 25.44 | 16443100.0 |
| 2002-07-12 11:00:00 | QQQ | ETF | 25.44 | 25.47 | 25.15 | 25.23 | 7207500.0 |
| 2002-07-12 11:30:00 | QQQ | ETF | 25.23 | 25.3 | 25.02 | 25.12 | 5935800.0 |
| 2002-07-12 12:00:00 | QQQ | ETF | 25.09 | 25.27 | 24.93 | 25.2 | 5209700.0 |
| 2002-07-12 12:30:00 | QQQ | ETF | 25.22 | 25.33 | 25.16 | 25.32 | 2081100.0 |
| 2002-07-12 13:00:00 | QQQ | ETF | 25.3 | 25.34 | 25.1 | 25.1 | 4204200.0 |
| 2002-07-12 13:30:00 | QQQ | ETF | 25.1 | 25.25 | 25.04 | 25.16 | 4191500.0 |
| 2002-07-12 14:00:00 | QQQ | ETF | 25.16 | 25.22 | 24.86 | 24.92 | 7225600.0 |
| 2002-07-12 14:30:00 | QQQ | ETF | 24.92 | 24.95 | 24.55 | 24.74 | 11773200.0 |
| 2002-07-12 15:00:00 | QQQ | ETF | 24.73 | 24.9 | 24.55 | 24.79 | 7897900.0 |
| 2002-07-12 15:30:00 | QQQ | ETF | 24.77 | 25.05 | 24.73 | 24.85 | 9474500.0 |
| 2002-07-12 16:00:00 | QQQ | ETF | 24.85 | 25.06 | 24.71 | 24.8 | 6307000.0 |
| 2002-07-12 16:30:00 | QQQ | ETF | 24.8 | 24.84 | 24.75 | 24.75 | 49800.0 |
| 2002-07-12 17:00:00 | QQQ | ETF | 24.75 | 24.8 | 24.71 | 24.75 | 25600.0 |
| 2002-07-12 17:30:00 | QQQ | ETF | 24.71 | 24.76 | 24.71 | 24.75 | 27200.0 |
| 2002-07-12 18:00:00 | QQQ | ETF | 24.73 | 24.75 | 24.73 | 24.75 | 2200.0 |
| 2002-07-12 09:00:00 | IWM | ETF | 41.3 | 41.3 | 41.3 | 41.3 | 2000.0 |
| 2002-07-12 09:30:00 | IWM | ETF | 41.5 | 41.75 | 41.285 | 41.4 | 274400.0 |
| 2002-07-12 10:00:00 | IWM | ETF | 41.435 | 41.815 | 41.415 | 41.78 | 256800.0 |
| 2002-07-12 10:30:00 | IWM | ETF | 41.705 | 41.975 | 41.705 | 41.93 | 243400.0 |
| 2002-07-12 11:00:00 | IWM | ETF | 41.925 | 42.09 | 41.81 | 41.845 | 166000.0 |
| 2002-07-12 11:30:00 | IWM | ETF | 41.835 | 41.91 | 41.75 | 41.775 | 156200.0 |
| 2002-07-12 12:00:00 | IWM | ETF | 41.8 | 41.815 | 41.625 | 41.71 | 572000.0 |
| 2002-07-12 12:30:00 | IWM | ETF | 41.775 | 41.95 | 41.675 | 41.79 | 28800.0 |
| 2002-07-12 13:00:00 | IWM | ETF | 41.8 | 41.875 | 41.675 | 41.675 | 6800.0 |
| 2002-07-12 13:30:00 | IWM | ETF | 41.7 | 41.76 | 41.63 | 41.64 | 430800.0 |
| 2002-07-12 14:00:00 | IWM | ETF | 41.625 | 41.68 | 41.375 | 41.425 | 326400.0 |
| 2002-07-12 14:30:00 | IWM | ETF | 41.43 | 41.515 | 40.95 | 40.95 | 159000.0 |
| 2002-07-12 15:00:00 | IWM | ETF | 41.025 | 41.175 | 40.96 | 41.13 | 164600.0 |
| 2002-07-12 15:30:00 | IWM | ETF | 41.13 | 41.305 | 41.1 | 41.2 | 176600.0 |
> showing 50 of 524 rows — these rows as CSV