PREVIEW / etf_30min / 2002-05-08
file: by_date/etf_30min/2002/2002-05-08.parquet size: 19 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-05-08 09:30:00 | SPY | ETF | 107.05 | 107.8 | 106.79 | 107.36 | 4619000.0 |
| 2002-05-08 10:00:00 | SPY | ETF | 107.33 | 107.76 | 107.33 | 107.52 | 1765000.0 |
| 2002-05-08 10:30:00 | SPY | ETF | 107.49 | 108.0 | 107.43 | 107.8 | 1410500.0 |
| 2002-05-08 11:00:00 | SPY | ETF | 107.83 | 108.61 | 107.77 | 108.46 | 2809800.0 |
| 2002-05-08 11:30:00 | SPY | ETF | 108.48 | 108.76 | 108.32 | 108.5 | 2940000.0 |
| 2002-05-08 12:00:00 | SPY | ETF | 108.5 | 108.96 | 108.49 | 108.75 | 1794700.0 |
| 2002-05-08 12:30:00 | SPY | ETF | 108.76 | 108.98 | 108.68 | 108.69 | 1004300.0 |
| 2002-05-08 13:00:00 | SPY | ETF | 108.7 | 108.82 | 108.6 | 108.77 | 1937300.0 |
| 2002-05-08 13:30:00 | SPY | ETF | 108.74 | 108.86 | 108.64 | 108.68 | 607600.0 |
| 2002-05-08 14:00:00 | SPY | ETF | 108.73 | 108.84 | 108.51 | 108.79 | 898200.0 |
| 2002-05-08 14:30:00 | SPY | ETF | 108.72 | 109.15 | 108.62 | 108.98 | 1504400.0 |
| 2002-05-08 15:00:00 | SPY | ETF | 109.0 | 109.22 | 108.85 | 109.22 | 1689100.0 |
| 2002-05-08 15:30:00 | SPY | ETF | 109.18 | 109.36 | 109.14 | 109.19 | 2433600.0 |
| 2002-05-08 16:00:00 | SPY | ETF | 109.16 | 109.3 | 108.96 | 109.3 | 1271100.0 |
| 2002-05-08 16:30:00 | SPY | ETF | 108.61 | 109.18 | 108.61 | 109.0 | 380200.0 |
| 2002-05-08 17:00:00 | SPY | ETF | 108.98 | 109.0 | 108.96 | 108.96 | 49800.0 |
| 2002-05-08 17:30:00 | SPY | ETF | 109.11 | 109.15 | 109.11 | 109.15 | 1100.0 |
| 2002-05-08 18:00:00 | SPY | ETF | 109.17 | 109.17 | 109.17 | 109.17 | 100.0 |
| 2002-05-08 09:30:00 | QQQ | ETF | 30.13 | 30.44 | 30.02 | 30.23 | 22045200.0 |
| 2002-05-08 10:00:00 | QQQ | ETF | 30.23 | 30.59 | 30.22 | 30.55 | 12733700.0 |
| 2002-05-08 10:30:00 | QQQ | ETF | 30.55 | 31.0 | 30.52 | 30.84 | 14321900.0 |
| 2002-05-08 11:00:00 | QQQ | ETF | 30.84 | 31.19 | 30.79 | 31.1 | 8429400.0 |
| 2002-05-08 11:30:00 | QQQ | ETF | 31.1 | 31.26 | 31.02 | 31.14 | 9355200.0 |
| 2002-05-08 12:00:00 | QQQ | ETF | 31.11 | 31.42 | 31.1 | 31.32 | 8520200.0 |
| 2002-05-08 12:30:00 | QQQ | ETF | 31.31 | 31.51 | 31.26 | 31.3 | 6073200.0 |
| 2002-05-08 13:00:00 | QQQ | ETF | 31.3 | 31.35 | 31.2 | 31.3 | 4634900.0 |
| 2002-05-08 13:30:00 | QQQ | ETF | 31.3 | 31.41 | 31.25 | 31.38 | 3157300.0 |
| 2002-05-08 14:00:00 | QQQ | ETF | 31.41 | 31.47 | 31.21 | 31.45 | 6289400.0 |
| 2002-05-08 14:30:00 | QQQ | ETF | 31.42 | 31.7 | 31.36 | 31.54 | 7485600.0 |
| 2002-05-08 15:00:00 | QQQ | ETF | 31.53 | 31.72 | 31.46 | 31.72 | 7114400.0 |
| 2002-05-08 15:30:00 | QQQ | ETF | 31.63 | 31.87 | 31.63 | 31.86 | 12897900.0 |
| 2002-05-08 16:00:00 | QQQ | ETF | 31.86 | 31.88 | 31.7 | 31.82 | 4197600.0 |
| 2002-05-08 16:30:00 | QQQ | ETF | 31.84 | 31.84 | 30.18 | 31.79 | 177300.0 |
| 2002-05-08 17:00:00 | QQQ | ETF | 31.8 | 31.81 | 31.75 | 31.8 | 69500.0 |
| 2002-05-08 17:30:00 | QQQ | ETF | 31.81 | 31.83 | 31.78 | 31.81 | 46700.0 |
| 2002-05-08 18:00:00 | QQQ | ETF | 31.8 | 31.82 | 31.78 | 31.78 | 28000.0 |
| 2002-05-08 09:30:00 | IWM | ETF | 50.45 | 50.575 | 50.3 | 50.35 | 129200.0 |
| 2002-05-08 10:00:00 | IWM | ETF | 50.35 | 50.51 | 50.3 | 50.405 | 515000.0 |
| 2002-05-08 10:30:00 | IWM | ETF | 50.4 | 50.45 | 50.275 | 50.35 | 433400.0 |
| 2002-05-08 11:00:00 | IWM | ETF | 50.32 | 50.445 | 50.3 | 50.39 | 191600.0 |
| 2002-05-08 11:30:00 | IWM | ETF | 50.35 | 50.45 | 50.295 | 50.335 | 241000.0 |
| 2002-05-08 12:00:00 | IWM | ETF | 50.42 | 50.44 | 50.34 | 50.385 | 126000.0 |
| 2002-05-08 12:30:00 | IWM | ETF | 50.4 | 50.45 | 50.325 | 50.325 | 40600.0 |
| 2002-05-08 13:00:00 | IWM | ETF | 50.325 | 50.36 | 50.28 | 50.285 | 61400.0 |
| 2002-05-08 13:30:00 | IWM | ETF | 50.35 | 50.37 | 50.29 | 50.34 | 30200.0 |
| 2002-05-08 14:00:00 | IWM | ETF | 50.34 | 50.37 | 50.24 | 50.315 | 57800.0 |
| 2002-05-08 14:30:00 | IWM | ETF | 50.325 | 50.4 | 50.255 | 50.385 | 56800.0 |
| 2002-05-08 15:00:00 | IWM | ETF | 50.385 | 50.52 | 50.32 | 50.52 | 130400.0 |
| 2002-05-08 15:30:00 | IWM | ETF | 50.56 | 50.81 | 50.535 | 50.665 | 202000.0 |
| 2002-05-08 16:00:00 | IWM | ETF | 50.7 | 50.8 | 50.7 | 50.8 | 7400.0 |
> showing 50 of 524 rows — these rows as CSV