PREVIEW / etf_30min / 2002-05-21
file: by_date/etf_30min/2002/2002-05-21.parquet size: 19 KB rows: 508
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-05-21 09:30:00 | SPY | ETF | 110.11 | 110.48 | 109.9 | 110.08 | 1961500.0 |
| 2002-05-21 10:00:00 | SPY | ETF | 110.06 | 110.19 | 109.83 | 110.09 | 993200.0 |
| 2002-05-21 10:30:00 | SPY | ETF | 110.09 | 110.18 | 109.61 | 109.64 | 881500.0 |
| 2002-05-21 11:00:00 | SPY | ETF | 109.63 | 109.65 | 109.15 | 109.24 | 3061200.0 |
| 2002-05-21 11:30:00 | SPY | ETF | 109.23 | 109.41 | 109.15 | 109.21 | 638400.0 |
| 2002-05-21 12:00:00 | SPY | ETF | 109.24 | 109.35 | 109.04 | 109.05 | 483700.0 |
| 2002-05-21 12:30:00 | SPY | ETF | 109.06 | 109.2 | 109.03 | 109.14 | 1056400.0 |
| 2002-05-21 13:00:00 | SPY | ETF | 109.15 | 109.34 | 109.1 | 109.3 | 410100.0 |
| 2002-05-21 13:30:00 | SPY | ETF | 109.25 | 109.32 | 109.05 | 109.24 | 503100.0 |
| 2002-05-21 14:00:00 | SPY | ETF | 109.24 | 109.29 | 109.03 | 109.15 | 444600.0 |
| 2002-05-21 14:30:00 | SPY | ETF | 109.14 | 109.16 | 108.61 | 108.73 | 1968500.0 |
| 2002-05-21 15:00:00 | SPY | ETF | 108.68 | 108.75 | 108.44 | 108.47 | 1219000.0 |
| 2002-05-21 15:30:00 | SPY | ETF | 108.46 | 108.65 | 108.32 | 108.48 | 1541100.0 |
| 2002-05-21 16:00:00 | SPY | ETF | 108.52 | 109.15 | 108.32 | 108.69 | 1006400.0 |
| 2002-05-21 16:30:00 | SPY | ETF | 108.67 | 108.75 | 108.6 | 108.67 | 10700.0 |
| 2002-05-21 17:00:00 | SPY | ETF | 108.6 | 108.68 | 108.6 | 108.6 | 21500.0 |
| 2002-05-21 17:30:00 | SPY | ETF | 108.61 | 108.7 | 108.61 | 108.65 | 19600.0 |
| 2002-05-21 18:00:00 | SPY | ETF | 108.72 | 108.73 | 108.6 | 108.61 | 800.0 |
| 2002-05-21 09:30:00 | QQQ | ETF | 32.36 | 32.59 | 32.12 | 32.21 | 11043200.0 |
| 2002-05-21 10:00:00 | QQQ | ETF | 32.21 | 32.3 | 31.94 | 32.06 | 11858000.0 |
| 2002-05-21 10:30:00 | QQQ | ETF | 32.06 | 32.12 | 31.6 | 31.62 | 7954200.0 |
| 2002-05-21 11:00:00 | QQQ | ETF | 31.62 | 31.67 | 31.38 | 31.47 | 13836400.0 |
| 2002-05-21 11:30:00 | QQQ | ETF | 31.49 | 31.6 | 31.43 | 31.5 | 4744600.0 |
| 2002-05-21 12:00:00 | QQQ | ETF | 31.52 | 31.6 | 31.37 | 31.4 | 3871700.0 |
| 2002-05-21 12:30:00 | QQQ | ETF | 31.4 | 31.48 | 31.25 | 31.37 | 6302200.0 |
| 2002-05-21 13:00:00 | QQQ | ETF | 31.38 | 31.54 | 31.35 | 31.49 | 2353500.0 |
| 2002-05-21 13:30:00 | QQQ | ETF | 31.48 | 31.51 | 31.31 | 31.47 | 3609200.0 |
| 2002-05-21 14:00:00 | QQQ | ETF | 31.47 | 31.55 | 31.37 | 31.45 | 5521700.0 |
| 2002-05-21 14:30:00 | QQQ | ETF | 31.44 | 31.48 | 31.12 | 31.16 | 12242500.0 |
| 2002-05-21 15:00:00 | QQQ | ETF | 31.17 | 31.29 | 31.09 | 31.19 | 5858500.0 |
| 2002-05-21 15:30:00 | QQQ | ETF | 31.2 | 31.4 | 31.17 | 31.3 | 7112800.0 |
| 2002-05-21 16:00:00 | QQQ | ETF | 31.28 | 32.15 | 31.23 | 31.37 | 3369200.0 |
| 2002-05-21 16:30:00 | QQQ | ETF | 31.36 | 31.39 | 31.31 | 31.32 | 28400.0 |
| 2002-05-21 17:00:00 | QQQ | ETF | 31.32 | 31.33 | 31.29 | 31.3 | 31100.0 |
| 2002-05-21 17:30:00 | QQQ | ETF | 31.3 | 31.32 | 31.3 | 31.3 | 13600.0 |
| 2002-05-21 18:00:00 | QQQ | ETF | 31.3 | 31.33 | 31.28 | 31.31 | 16700.0 |
| 2002-05-21 09:30:00 | IWM | ETF | 50.175 | 50.32 | 50.055 | 50.055 | 36400.0 |
| 2002-05-21 10:00:00 | IWM | ETF | 50.075 | 50.14 | 49.955 | 49.955 | 83200.0 |
| 2002-05-21 10:30:00 | IWM | ETF | 50.01 | 50.06 | 49.785 | 49.86 | 41800.0 |
| 2002-05-21 11:00:00 | IWM | ETF | 49.745 | 49.8 | 49.51 | 49.62 | 182600.0 |
| 2002-05-21 11:30:00 | IWM | ETF | 49.595 | 49.71 | 49.585 | 49.585 | 213200.0 |
| 2002-05-21 12:00:00 | IWM | ETF | 49.595 | 49.64 | 49.51 | 49.51 | 16600.0 |
| 2002-05-21 12:30:00 | IWM | ETF | 49.51 | 49.54 | 49.38 | 49.38 | 172600.0 |
| 2002-05-21 13:00:00 | IWM | ETF | 49.39 | 49.51 | 49.39 | 49.51 | 104000.0 |
| 2002-05-21 13:30:00 | IWM | ETF | 49.51 | 49.51 | 49.36 | 49.425 | 25000.0 |
| 2002-05-21 14:00:00 | IWM | ETF | 49.425 | 49.525 | 49.41 | 49.425 | 193000.0 |
| 2002-05-21 14:30:00 | IWM | ETF | 49.4 | 49.425 | 49.25 | 49.31 | 46000.0 |
| 2002-05-21 15:00:00 | IWM | ETF | 49.215 | 49.3 | 49.19 | 49.28 | 153800.0 |
| 2002-05-21 15:30:00 | IWM | ETF | 49.28 | 49.345 | 49.135 | 49.22 | 247600.0 |
| 2002-05-21 16:00:00 | IWM | ETF | 49.3 | 49.36 | 49.3 | 49.36 | 154800.0 |
> showing 50 of 508 rows — these rows as CSV