PREVIEW / etf_30min / 2001-10-24
file: by_date/etf_30min/2001/2001-10-24.parquet size: 15 KB rows: 385
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-24 09:30:00 | SPY | ETF | 108.98 | 109.0 | 108.22 | 108.62 | 2235000.0 |
| 2001-10-24 10:00:00 | SPY | ETF | 108.61 | 109.13 | 108.55 | 108.7 | 1998300.0 |
| 2001-10-24 10:30:00 | SPY | ETF | 108.74 | 109.39 | 108.55 | 108.95 | 1879100.0 |
| 2001-10-24 11:00:00 | SPY | ETF | 108.94 | 109.11 | 108.57 | 108.7 | 945600.0 |
| 2001-10-24 11:30:00 | SPY | ETF | 108.65 | 108.88 | 108.47 | 108.84 | 808300.0 |
| 2001-10-24 12:00:00 | SPY | ETF | 108.82 | 108.93 | 108.51 | 108.6 | 632200.0 |
| 2001-10-24 12:30:00 | SPY | ETF | 108.66 | 109.11 | 108.58 | 109.11 | 785200.0 |
| 2001-10-24 13:00:00 | SPY | ETF | 109.11 | 109.45 | 108.95 | 109.15 | 1102500.0 |
| 2001-10-24 13:30:00 | SPY | ETF | 109.08 | 109.16 | 108.76 | 108.77 | 728400.0 |
| 2001-10-24 14:00:00 | SPY | ETF | 108.75 | 109.2 | 108.65 | 108.75 | 1057800.0 |
| 2001-10-24 14:30:00 | SPY | ETF | 108.7 | 108.88 | 108.5 | 108.88 | 1064800.0 |
| 2001-10-24 15:00:00 | SPY | ETF | 108.79 | 109.02 | 108.6 | 108.75 | 840200.0 |
| 2001-10-24 15:30:00 | SPY | ETF | 108.72 | 108.88 | 108.6 | 108.85 | 795100.0 |
| 2001-10-24 16:00:00 | SPY | ETF | 108.77 | 108.88 | 107.6 | 107.6 | 1110100.0 |
| 2001-10-24 16:30:00 | SPY | ETF | 108.67 | 108.7 | 108.67 | 108.7 | 1600.0 |
| 2001-10-24 17:00:00 | SPY | ETF | 108.75 | 108.75 | 108.7 | 108.75 | 51000.0 |
| 2001-10-24 18:00:00 | SPY | ETF | 108.7 | 108.7 | 108.7 | 108.7 | 200.0 |
| 2001-10-24 09:30:00 | QQQ | ETF | 34.6 | 34.8 | 34.32 | 34.7 | 9454000.0 |
| 2001-10-24 10:00:00 | QQQ | ETF | 34.73 | 35.05 | 34.66 | 34.87 | 9773900.0 |
| 2001-10-24 10:30:00 | QQQ | ETF | 34.86 | 35.38 | 34.74 | 35.12 | 10734600.0 |
| 2001-10-24 11:00:00 | QQQ | ETF | 35.1 | 35.22 | 34.9 | 35.05 | 4640500.0 |
| 2001-10-24 11:30:00 | QQQ | ETF | 35.02 | 35.24 | 34.86 | 35.18 | 3295700.0 |
| 2001-10-24 12:00:00 | QQQ | ETF | 35.18 | 35.34 | 34.96 | 35.05 | 4513600.0 |
| 2001-10-24 12:30:00 | QQQ | ETF | 35.08 | 35.48 | 35.03 | 35.45 | 5130600.0 |
| 2001-10-24 13:00:00 | QQQ | ETF | 35.44 | 35.68 | 35.35 | 35.48 | 7268200.0 |
| 2001-10-24 13:30:00 | QQQ | ETF | 35.48 | 35.54 | 35.15 | 35.25 | 5942500.0 |
| 2001-10-24 14:00:00 | QQQ | ETF | 35.3 | 35.55 | 35.12 | 35.19 | 7679100.0 |
| 2001-10-24 14:30:00 | QQQ | ETF | 35.2 | 35.32 | 34.97 | 35.29 | 7782200.0 |
| 2001-10-24 15:00:00 | QQQ | ETF | 35.29 | 35.39 | 35.15 | 35.32 | 4583800.0 |
| 2001-10-24 15:30:00 | QQQ | ETF | 35.31 | 35.49 | 35.17 | 35.45 | 5789600.0 |
| 2001-10-24 16:00:00 | QQQ | ETF | 35.44 | 35.48 | 34.98 | 35.32 | 2784900.0 |
| 2001-10-24 16:30:00 | QQQ | ETF | 35.36 | 35.43 | 35.31 | 35.39 | 152800.0 |
| 2001-10-24 17:00:00 | QQQ | ETF | 35.4 | 35.43 | 35.3 | 35.35 | 42000.0 |
| 2001-10-24 17:30:00 | QQQ | ETF | 35.34 | 35.38 | 35.31 | 35.38 | 168100.0 |
| 2001-10-24 18:00:00 | QQQ | ETF | 35.33 | 35.4 | 35.33 | 35.37 | 14200.0 |
| 2001-10-24 09:30:00 | IWM | ETF | 42.5 | 42.565 | 42.41 | 42.5 | 23000.0 |
| 2001-10-24 10:00:00 | IWM | ETF | 42.535 | 42.58 | 42.515 | 42.525 | 800.0 |
| 2001-10-24 10:30:00 | IWM | ETF | 42.52 | 42.63 | 42.52 | 42.61 | 4800.0 |
| 2001-10-24 11:00:00 | IWM | ETF | 42.6 | 42.625 | 42.5 | 42.5 | 134600.0 |
| 2001-10-24 11:30:00 | IWM | ETF | 42.475 | 42.51 | 42.385 | 42.435 | 79000.0 |
| 2001-10-24 12:00:00 | IWM | ETF | 42.49 | 42.49 | 42.43 | 42.43 | 4800.0 |
| 2001-10-24 12:30:00 | IWM | ETF | 42.405 | 42.545 | 42.3 | 42.545 | 15000.0 |
| 2001-10-24 13:00:00 | IWM | ETF | 42.54 | 42.62 | 42.54 | 42.62 | 6200.0 |
| 2001-10-24 13:30:00 | IWM | ETF | 42.605 | 42.605 | 42.51 | 42.57 | 53000.0 |
| 2001-10-24 14:00:00 | IWM | ETF | 42.495 | 42.6 | 42.495 | 42.6 | 92200.0 |
| 2001-10-24 14:30:00 | IWM | ETF | 42.58 | 42.58 | 42.485 | 42.485 | 9400.0 |
| 2001-10-24 15:00:00 | IWM | ETF | 42.555 | 42.555 | 42.5 | 42.505 | 92400.0 |
| 2001-10-24 15:30:00 | IWM | ETF | 42.525 | 42.69 | 42.525 | 42.69 | 7400.0 |
| 2001-10-24 16:00:00 | IWM | ETF | 42.675 | 42.675 | 42.675 | 42.675 | 5000.0 |
| 2001-10-24 09:30:00 | DIA | ETF | 93.65 | 93.65 | 92.85 | 93.11 | 639200.0 |
> showing 50 of 385 rows — these rows as CSV