PREVIEW / etf_30min / 2002-03-25
file: by_date/etf_30min/2002/2002-03-25.parquet size: 18 KB rows: 486
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-25 09:30:00 | SPY | ETF | 115.09 | 115.36 | 114.96 | 115.06 | 1594900.0 |
| 2002-03-25 10:00:00 | SPY | ETF | 115.09 | 115.16 | 114.82 | 115.05 | 1204900.0 |
| 2002-03-25 10:30:00 | SPY | ETF | 115.03 | 115.04 | 114.3 | 114.3 | 2154200.0 |
| 2002-03-25 11:00:00 | SPY | ETF | 114.32 | 114.5 | 114.2 | 114.39 | 820300.0 |
| 2002-03-25 11:30:00 | SPY | ETF | 114.36 | 114.46 | 114.23 | 114.36 | 794000.0 |
| 2002-03-25 12:00:00 | SPY | ETF | 114.36 | 114.4 | 114.06 | 114.19 | 594900.0 |
| 2002-03-25 12:30:00 | SPY | ETF | 114.16 | 114.27 | 114.03 | 114.19 | 456200.0 |
| 2002-03-25 13:00:00 | SPY | ETF | 114.14 | 114.53 | 114.07 | 114.4 | 1731800.0 |
| 2002-03-25 13:30:00 | SPY | ETF | 114.4 | 114.45 | 114.09 | 114.28 | 464500.0 |
| 2002-03-25 14:00:00 | SPY | ETF | 114.27 | 114.5 | 114.19 | 114.42 | 924300.0 |
| 2002-03-25 14:30:00 | SPY | ETF | 114.46 | 114.54 | 114.21 | 114.31 | 521000.0 |
| 2002-03-25 15:00:00 | SPY | ETF | 114.33 | 114.33 | 113.65 | 113.65 | 3128400.0 |
| 2002-03-25 15:30:00 | SPY | ETF | 113.67 | 113.8 | 113.38 | 113.42 | 1897800.0 |
| 2002-03-25 16:00:00 | SPY | ETF | 113.43 | 114.42 | 113.3 | 113.69 | 1037900.0 |
| 2002-03-25 16:30:00 | SPY | ETF | 113.55 | 113.65 | 113.55 | 113.65 | 4100.0 |
| 2002-03-25 17:00:00 | SPY | ETF | 113.63 | 113.65 | 113.63 | 113.65 | 1500.0 |
| 2002-03-25 18:00:00 | SPY | ETF | 113.7 | 114.42 | 113.64 | 113.64 | 7600.0 |
| 2002-03-25 09:30:00 | QQQ | ETF | 36.69 | 36.9 | 36.55 | 36.63 | 7016500.0 |
| 2002-03-25 10:00:00 | QQQ | ETF | 36.63 | 36.75 | 36.34 | 36.39 | 6250000.0 |
| 2002-03-25 10:30:00 | QQQ | ETF | 36.46 | 36.46 | 36.01 | 36.02 | 6825200.0 |
| 2002-03-25 11:00:00 | QQQ | ETF | 36.02 | 36.13 | 35.9 | 36.03 | 6442500.0 |
| 2002-03-25 11:30:00 | QQQ | ETF | 36.03 | 36.12 | 35.95 | 36.0 | 4421400.0 |
| 2002-03-25 12:00:00 | QQQ | ETF | 36.0 | 36.05 | 35.77 | 35.84 | 5908900.0 |
| 2002-03-25 12:30:00 | QQQ | ETF | 35.81 | 35.93 | 35.75 | 35.87 | 3517100.0 |
| 2002-03-25 13:00:00 | QQQ | ETF | 35.85 | 36.04 | 35.8 | 35.97 | 4448100.0 |
| 2002-03-25 13:30:00 | QQQ | ETF | 35.97 | 35.99 | 35.76 | 35.92 | 3530300.0 |
| 2002-03-25 14:00:00 | QQQ | ETF | 35.92 | 36.15 | 35.89 | 36.06 | 3215700.0 |
| 2002-03-25 14:30:00 | QQQ | ETF | 36.08 | 36.2 | 35.92 | 36.02 | 4097100.0 |
| 2002-03-25 15:00:00 | QQQ | ETF | 35.98 | 36.02 | 35.64 | 35.68 | 8948700.0 |
| 2002-03-25 15:30:00 | QQQ | ETF | 35.69 | 35.75 | 35.53 | 35.58 | 17408100.0 |
| 2002-03-25 16:00:00 | QQQ | ETF | 35.55 | 35.7 | 35.52 | 35.56 | 4034100.0 |
| 2002-03-25 16:30:00 | QQQ | ETF | 35.62 | 35.67 | 35.56 | 35.65 | 188600.0 |
| 2002-03-25 17:00:00 | QQQ | ETF | 35.65 | 35.66 | 35.6 | 35.64 | 24900.0 |
| 2002-03-25 17:30:00 | QQQ | ETF | 35.64 | 35.65 | 35.62 | 35.64 | 23100.0 |
| 2002-03-25 18:00:00 | QQQ | ETF | 35.63 | 35.64 | 35.62 | 35.63 | 5600.0 |
| 2002-03-25 09:30:00 | IWM | ETF | 50.025 | 50.07 | 49.85 | 49.86 | 166800.0 |
| 2002-03-25 10:00:00 | IWM | ETF | 49.875 | 49.94 | 49.76 | 49.82 | 27000.0 |
| 2002-03-25 10:30:00 | IWM | ETF | 49.8 | 49.8 | 49.59 | 49.59 | 228400.0 |
| 2002-03-25 11:00:00 | IWM | ETF | 49.59 | 49.605 | 49.41 | 49.525 | 56000.0 |
| 2002-03-25 11:30:00 | IWM | ETF | 49.475 | 49.54 | 49.435 | 49.465 | 17400.0 |
| 2002-03-25 12:00:00 | IWM | ETF | 49.48 | 49.5 | 49.325 | 49.365 | 28200.0 |
| 2002-03-25 12:30:00 | IWM | ETF | 49.32 | 49.395 | 49.32 | 49.355 | 524400.0 |
| 2002-03-25 13:00:00 | IWM | ETF | 49.36 | 49.505 | 49.34 | 49.42 | 23600.0 |
| 2002-03-25 13:30:00 | IWM | ETF | 49.435 | 49.5 | 49.42 | 49.48 | 40000.0 |
| 2002-03-25 14:00:00 | IWM | ETF | 49.41 | 49.56 | 49.41 | 49.525 | 132200.0 |
| 2002-03-25 14:30:00 | IWM | ETF | 49.56 | 49.56 | 49.5 | 49.56 | 26000.0 |
| 2002-03-25 15:00:00 | IWM | ETF | 49.525 | 49.56 | 49.35 | 49.35 | 165600.0 |
| 2002-03-25 15:30:00 | IWM | ETF | 49.43 | 49.43 | 49.225 | 49.295 | 404200.0 |
| 2002-03-25 16:00:00 | IWM | ETF | 49.285 | 49.36 | 49.255 | 49.295 | 32400.0 |
| 2002-03-25 09:30:00 | DIA | ETF | 104.19 | 104.59 | 104.19 | 104.39 | 486800.0 |
> showing 50 of 486 rows — these rows as CSV