PREVIEW / etf_30min / 2002-07-03
file: by_date/etf_30min/2002/2002-07-03.parquet size: 19 KB rows: 514
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-03 09:30:00 | SPY | ETF | 94.62 | 95.61 | 94.6 | 95.53 | 3756300.0 |
| 2002-07-03 10:00:00 | SPY | ETF | 95.58 | 95.7 | 94.51 | 94.62 | 2979800.0 |
| 2002-07-03 10:30:00 | SPY | ETF | 94.62 | 94.82 | 94.11 | 94.22 | 2226200.0 |
| 2002-07-03 11:00:00 | SPY | ETF | 94.21 | 94.34 | 93.72 | 93.78 | 2775100.0 |
| 2002-07-03 11:30:00 | SPY | ETF | 93.81 | 94.65 | 93.8 | 94.62 | 2243200.0 |
| 2002-07-03 12:00:00 | SPY | ETF | 94.64 | 94.83 | 94.1 | 94.14 | 1737300.0 |
| 2002-07-03 12:30:00 | SPY | ETF | 94.12 | 94.5 | 93.84 | 94.35 | 1218400.0 |
| 2002-07-03 13:00:00 | SPY | ETF | 94.35 | 94.54 | 94.06 | 94.37 | 927400.0 |
| 2002-07-03 13:30:00 | SPY | ETF | 94.37 | 94.6 | 94.14 | 94.59 | 1032000.0 |
| 2002-07-03 14:00:00 | SPY | ETF | 94.51 | 94.78 | 94.26 | 94.77 | 1607400.0 |
| 2002-07-03 14:30:00 | SPY | ETF | 94.77 | 95.5 | 94.74 | 95.5 | 2873100.0 |
| 2002-07-03 15:00:00 | SPY | ETF | 95.5 | 95.69 | 95.06 | 95.3 | 2457800.0 |
| 2002-07-03 15:30:00 | SPY | ETF | 95.3 | 95.78 | 95.1 | 95.69 | 2868000.0 |
| 2002-07-03 16:00:00 | SPY | ETF | 95.69 | 95.74 | 94.82 | 95.6 | 1244500.0 |
| 2002-07-03 16:30:00 | SPY | ETF | 95.56 | 95.65 | 95.49 | 95.53 | 7600.0 |
| 2002-07-03 17:00:00 | SPY | ETF | 95.59 | 95.6 | 95.5 | 95.6 | 3400.0 |
| 2002-07-03 17:30:00 | SPY | ETF | 95.55 | 95.6 | 95.53 | 95.6 | 900.0 |
| 2002-07-03 18:00:00 | SPY | ETF | 95.53 | 95.55 | 95.52 | 95.52 | 5000.0 |
| 2002-07-03 09:30:00 | QQQ | ETF | 23.85 | 24.34 | 23.83 | 24.23 | 12973100.0 |
| 2002-07-03 10:00:00 | QQQ | ETF | 24.23 | 24.32 | 23.78 | 23.91 | 8788900.0 |
| 2002-07-03 10:30:00 | QQQ | ETF | 23.91 | 24.04 | 23.62 | 23.7 | 11231200.0 |
| 2002-07-03 11:00:00 | QQQ | ETF | 23.7 | 23.87 | 23.63 | 23.73 | 6308400.0 |
| 2002-07-03 11:30:00 | QQQ | ETF | 23.73 | 24.22 | 23.72 | 24.19 | 9577000.0 |
| 2002-07-03 12:00:00 | QQQ | ETF | 24.22 | 24.25 | 23.92 | 23.95 | 4574200.0 |
| 2002-07-03 12:30:00 | QQQ | ETF | 23.95 | 24.2 | 23.85 | 24.1 | 4090600.0 |
| 2002-07-03 13:00:00 | QQQ | ETF | 24.11 | 24.17 | 23.96 | 24.14 | 3129000.0 |
| 2002-07-03 13:30:00 | QQQ | ETF | 24.15 | 24.31 | 24.06 | 24.24 | 4928700.0 |
| 2002-07-03 14:00:00 | QQQ | ETF | 24.23 | 24.46 | 24.15 | 24.43 | 7282400.0 |
| 2002-07-03 14:30:00 | QQQ | ETF | 24.42 | 24.65 | 24.42 | 24.64 | 9806300.0 |
| 2002-07-03 15:00:00 | QQQ | ETF | 24.64 | 24.69 | 24.4 | 24.47 | 6821700.0 |
| 2002-07-03 15:30:00 | QQQ | ETF | 24.47 | 24.75 | 24.4 | 24.72 | 6632700.0 |
| 2002-07-03 16:00:00 | QQQ | ETF | 24.73 | 24.77 | 24.68 | 24.75 | 2345700.0 |
| 2002-07-03 16:30:00 | QQQ | ETF | 24.75 | 24.77 | 24.7 | 24.74 | 27000.0 |
| 2002-07-03 17:00:00 | QQQ | ETF | 24.74 | 24.76 | 24.74 | 24.76 | 37200.0 |
| 2002-07-03 17:30:00 | QQQ | ETF | 24.76 | 24.76 | 24.71 | 24.75 | 6600.0 |
| 2002-07-03 18:00:00 | QQQ | ETF | 24.75 | 24.76 | 24.72 | 24.73 | 17600.0 |
| 2002-07-03 09:30:00 | IWM | ETF | 42.9 | 43.0 | 42.635 | 43.0 | 73200.0 |
| 2002-07-03 10:00:00 | IWM | ETF | 42.975 | 42.975 | 42.45 | 42.49 | 260200.0 |
| 2002-07-03 10:30:00 | IWM | ETF | 42.5 | 42.555 | 42.14 | 42.18 | 399200.0 |
| 2002-07-03 11:00:00 | IWM | ETF | 42.1 | 42.245 | 42.0 | 42.09 | 234200.0 |
| 2002-07-03 11:30:00 | IWM | ETF | 42.09 | 42.2 | 42.09 | 42.175 | 343400.0 |
| 2002-07-03 12:00:00 | IWM | ETF | 42.165 | 42.275 | 42.065 | 42.065 | 519600.0 |
| 2002-07-03 12:30:00 | IWM | ETF | 42.12 | 42.15 | 42.065 | 42.135 | 91800.0 |
| 2002-07-03 13:00:00 | IWM | ETF | 42.135 | 42.145 | 42.065 | 42.11 | 35000.0 |
| 2002-07-03 13:30:00 | IWM | ETF | 42.1 | 42.16 | 42.07 | 42.16 | 31400.0 |
| 2002-07-03 14:00:00 | IWM | ETF | 42.175 | 42.28 | 42.175 | 42.28 | 119000.0 |
| 2002-07-03 14:30:00 | IWM | ETF | 42.295 | 42.645 | 42.295 | 42.6 | 283000.0 |
| 2002-07-03 15:00:00 | IWM | ETF | 42.6 | 42.795 | 42.535 | 42.535 | 186400.0 |
| 2002-07-03 15:30:00 | IWM | ETF | 42.645 | 42.865 | 42.55 | 42.775 | 235200.0 |
| 2002-07-03 16:00:00 | IWM | ETF | 42.825 | 42.825 | 42.55 | 42.55 | 83600.0 |
> showing 50 of 514 rows — these rows as CSV