PREVIEW / etf_30min / 2002-06-14
file: by_date/etf_30min/2002/2002-06-14.parquet size: 19 KB rows: 528
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-06-14 09:30:00 | SPY | ETF | 100.31 | 100.4 | 98.5 | 98.61 | 6637700.0 |
| 2002-06-14 10:00:00 | SPY | ETF | 98.65 | 100.0 | 98.5 | 99.87 | 8276000.0 |
| 2002-06-14 10:30:00 | SPY | ETF | 99.86 | 100.45 | 99.53 | 100.26 | 3026800.0 |
| 2002-06-14 11:00:00 | SPY | ETF | 100.26 | 100.45 | 99.8 | 100.1 | 2172800.0 |
| 2002-06-14 11:30:00 | SPY | ETF | 100.11 | 100.99 | 100.07 | 100.6 | 3717300.0 |
| 2002-06-14 12:00:00 | SPY | ETF | 100.53 | 100.91 | 100.4 | 100.51 | 1029500.0 |
| 2002-06-14 12:30:00 | SPY | ETF | 100.52 | 100.55 | 99.95 | 100.26 | 1282000.0 |
| 2002-06-14 13:00:00 | SPY | ETF | 100.3 | 100.48 | 100.14 | 100.2 | 539500.0 |
| 2002-06-14 13:30:00 | SPY | ETF | 100.18 | 100.56 | 100.05 | 100.54 | 549800.0 |
| 2002-06-14 14:00:00 | SPY | ETF | 100.54 | 101.4 | 100.42 | 101.37 | 2634800.0 |
| 2002-06-14 14:30:00 | SPY | ETF | 101.37 | 101.56 | 101.06 | 101.26 | 3266400.0 |
| 2002-06-14 15:00:00 | SPY | ETF | 101.22 | 101.29 | 100.74 | 101.27 | 1266300.0 |
| 2002-06-14 15:30:00 | SPY | ETF | 101.17 | 101.49 | 101.05 | 101.29 | 1747600.0 |
| 2002-06-14 16:00:00 | SPY | ETF | 101.27 | 101.49 | 100.75 | 101.4 | 2254300.0 |
| 2002-06-14 16:30:00 | SPY | ETF | 101.4 | 101.5 | 101.4 | 101.4 | 20000.0 |
| 2002-06-14 17:00:00 | SPY | ETF | 101.4 | 101.52 | 101.4 | 101.49 | 7300.0 |
| 2002-06-14 17:30:00 | SPY | ETF | 101.45 | 101.53 | 101.45 | 101.53 | 1800.0 |
| 2002-06-14 09:30:00 | QQQ | ETF | 26.86 | 26.94 | 26.25 | 26.27 | 18971400.0 |
| 2002-06-14 10:00:00 | QQQ | ETF | 26.26 | 26.9 | 26.2 | 26.81 | 20023300.0 |
| 2002-06-14 10:30:00 | QQQ | ETF | 26.82 | 27.23 | 26.64 | 27.13 | 13529300.0 |
| 2002-06-14 11:00:00 | QQQ | ETF | 27.13 | 27.2 | 26.91 | 27.06 | 6277900.0 |
| 2002-06-14 11:30:00 | QQQ | ETF | 27.05 | 27.44 | 27.03 | 27.26 | 9224200.0 |
| 2002-06-14 12:00:00 | QQQ | ETF | 27.28 | 27.46 | 27.15 | 27.24 | 4714600.0 |
| 2002-06-14 12:30:00 | QQQ | ETF | 27.24 | 27.29 | 27.0 | 27.19 | 6024600.0 |
| 2002-06-14 13:00:00 | QQQ | ETF | 27.2 | 27.28 | 27.1 | 27.13 | 2443200.0 |
| 2002-06-14 13:30:00 | QQQ | ETF | 27.13 | 27.26 | 27.02 | 27.26 | 3712800.0 |
| 2002-06-14 14:00:00 | QQQ | ETF | 27.24 | 27.65 | 27.18 | 27.62 | 6286900.0 |
| 2002-06-14 14:30:00 | QQQ | ETF | 27.6 | 27.7 | 27.45 | 27.57 | 9159500.0 |
| 2002-06-14 15:00:00 | QQQ | ETF | 27.57 | 27.59 | 27.31 | 27.5 | 5169100.0 |
| 2002-06-14 15:30:00 | QQQ | ETF | 27.49 | 27.72 | 27.45 | 27.62 | 10795600.0 |
| 2002-06-14 16:00:00 | QQQ | ETF | 27.57 | 27.7 | 27.53 | 27.6 | 2034100.0 |
| 2002-06-14 16:30:00 | QQQ | ETF | 27.6 | 27.66 | 27.53 | 27.62 | 237300.0 |
| 2002-06-14 17:00:00 | QQQ | ETF | 27.63 | 27.7 | 27.63 | 27.7 | 24100.0 |
| 2002-06-14 17:30:00 | QQQ | ETF | 27.69 | 27.75 | 27.68 | 27.7 | 23900.0 |
| 2002-06-14 18:00:00 | QQQ | ETF | 27.68 | 27.7 | 27.66 | 27.69 | 20500.0 |
| 2002-06-14 09:30:00 | IWM | ETF | 44.8 | 45.01 | 44.445 | 44.495 | 136600.0 |
| 2002-06-14 10:00:00 | IWM | ETF | 44.495 | 44.7 | 44.255 | 44.7 | 210200.0 |
| 2002-06-14 10:30:00 | IWM | ETF | 44.675 | 44.875 | 44.53 | 44.875 | 302400.0 |
| 2002-06-14 11:00:00 | IWM | ETF | 44.875 | 44.955 | 44.875 | 44.95 | 54000.0 |
| 2002-06-14 11:30:00 | IWM | ETF | 44.97 | 45.5 | 44.96 | 45.485 | 439600.0 |
| 2002-06-14 12:00:00 | IWM | ETF | 45.415 | 45.625 | 45.39 | 45.5 | 242400.0 |
| 2002-06-14 12:30:00 | IWM | ETF | 45.45 | 45.45 | 45.23 | 45.245 | 352600.0 |
| 2002-06-14 13:00:00 | IWM | ETF | 45.33 | 45.39 | 45.265 | 45.37 | 67400.0 |
| 2002-06-14 13:30:00 | IWM | ETF | 45.32 | 45.415 | 45.245 | 45.4 | 152200.0 |
| 2002-06-14 14:00:00 | IWM | ETF | 45.405 | 45.565 | 45.405 | 45.565 | 224400.0 |
| 2002-06-14 14:30:00 | IWM | ETF | 45.56 | 45.6 | 45.515 | 45.575 | 257200.0 |
| 2002-06-14 15:00:00 | IWM | ETF | 45.595 | 45.595 | 45.25 | 45.45 | 205400.0 |
| 2002-06-14 15:30:00 | IWM | ETF | 45.44 | 45.75 | 45.44 | 45.75 | 253600.0 |
| 2002-06-14 16:00:00 | IWM | ETF | 45.8 | 45.8 | 45.55 | 45.55 | 379200.0 |
| 2002-06-14 09:30:00 | DIA | ETF | 94.01 | 94.31 | 92.75 | 93.0 | 1104200.0 |
> showing 50 of 528 rows — these rows as CSV