PREVIEW / etf_30min / 2001-12-11
file: by_date/etf_30min/2001/2001-12-11.parquet size: 17 KB rows: 473
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-12-11 09:30:00 | SPY | ETF | 114.9 | 115.0 | 114.61 | 114.9 | 1408700.0 |
| 2001-12-11 10:00:00 | SPY | ETF | 114.91 | 115.09 | 114.67 | 114.94 | 908200.0 |
| 2001-12-11 10:30:00 | SPY | ETF | 114.95 | 115.12 | 114.85 | 114.98 | 885200.0 |
| 2001-12-11 11:00:00 | SPY | ETF | 114.99 | 115.05 | 114.81 | 114.9 | 545300.0 |
| 2001-12-11 11:30:00 | SPY | ETF | 114.87 | 115.05 | 114.86 | 114.91 | 439900.0 |
| 2001-12-11 12:00:00 | SPY | ETF | 114.93 | 114.96 | 114.82 | 114.87 | 320000.0 |
| 2001-12-11 12:30:00 | SPY | ETF | 114.88 | 115.03 | 114.82 | 114.98 | 420700.0 |
| 2001-12-11 13:00:00 | SPY | ETF | 114.98 | 114.98 | 114.88 | 114.96 | 189000.0 |
| 2001-12-11 13:30:00 | SPY | ETF | 114.93 | 115.02 | 114.78 | 114.99 | 245400.0 |
| 2001-12-11 14:00:00 | SPY | ETF | 115.0 | 115.38 | 114.66 | 115.33 | 3625600.0 |
| 2001-12-11 14:30:00 | SPY | ETF | 115.3 | 115.72 | 115.2 | 115.56 | 3505100.0 |
| 2001-12-11 15:00:00 | SPY | ETF | 115.53 | 115.58 | 114.48 | 114.77 | 3869900.0 |
| 2001-12-11 15:30:00 | SPY | ETF | 114.72 | 114.83 | 113.9 | 114.19 | 2776700.0 |
| 2001-12-11 16:00:00 | SPY | ETF | 114.22 | 114.74 | 114.05 | 114.3 | 1319800.0 |
| 2001-12-11 16:30:00 | SPY | ETF | 114.84 | 114.88 | 114.2 | 114.27 | 95400.0 |
| 2001-12-11 17:00:00 | SPY | ETF | 114.27 | 114.32 | 114.27 | 114.32 | 1700.0 |
| 2001-12-11 18:00:00 | SPY | ETF | 114.3 | 114.3 | 114.3 | 114.3 | 200.0 |
| 2001-12-11 09:30:00 | QQQ | ETF | 41.46 | 41.65 | 41.35 | 41.61 | 7310500.0 |
| 2001-12-11 10:00:00 | QQQ | ETF | 41.6 | 41.7 | 41.45 | 41.62 | 3787900.0 |
| 2001-12-11 10:30:00 | QQQ | ETF | 41.61 | 41.85 | 41.53 | 41.78 | 4408200.0 |
| 2001-12-11 11:00:00 | QQQ | ETF | 41.77 | 41.84 | 41.65 | 41.74 | 2208800.0 |
| 2001-12-11 11:30:00 | QQQ | ETF | 41.73 | 41.93 | 41.7 | 41.77 | 2874900.0 |
| 2001-12-11 12:00:00 | QQQ | ETF | 41.75 | 41.8 | 41.65 | 41.68 | 1773900.0 |
| 2001-12-11 12:30:00 | QQQ | ETF | 41.67 | 41.8 | 41.63 | 41.77 | 1694300.0 |
| 2001-12-11 13:00:00 | QQQ | ETF | 41.74 | 41.79 | 41.66 | 41.72 | 779100.0 |
| 2001-12-11 13:30:00 | QQQ | ETF | 41.72 | 41.85 | 41.7 | 41.84 | 1196300.0 |
| 2001-12-11 14:00:00 | QQQ | ETF | 41.83 | 42.12 | 41.6 | 42.09 | 7483400.0 |
| 2001-12-11 14:30:00 | QQQ | ETF | 42.08 | 42.26 | 41.91 | 42.15 | 9037700.0 |
| 2001-12-11 15:00:00 | QQQ | ETF | 42.14 | 42.16 | 41.65 | 41.84 | 8411800.0 |
| 2001-12-11 15:30:00 | QQQ | ETF | 41.83 | 41.89 | 41.15 | 41.36 | 11849400.0 |
| 2001-12-11 16:00:00 | QQQ | ETF | 41.37 | 41.4 | 41.13 | 41.25 | 2906700.0 |
| 2001-12-11 16:30:00 | QQQ | ETF | 41.23 | 41.93 | 41.2 | 41.37 | 58900.0 |
| 2001-12-11 17:00:00 | QQQ | ETF | 41.35 | 41.41 | 41.32 | 41.35 | 19000.0 |
| 2001-12-11 17:30:00 | QQQ | ETF | 41.38 | 41.38 | 41.35 | 41.35 | 6900.0 |
| 2001-12-11 18:00:00 | QQQ | ETF | 41.37 | 41.44 | 41.36 | 41.42 | 15100.0 |
| 2001-12-11 09:30:00 | IWM | ETF | 47.425 | 47.425 | 47.34 | 47.36 | 21200.0 |
| 2001-12-11 10:00:00 | IWM | ETF | 47.34 | 47.425 | 47.25 | 47.4 | 23400.0 |
| 2001-12-11 10:30:00 | IWM | ETF | 47.415 | 47.425 | 47.375 | 47.415 | 27800.0 |
| 2001-12-11 11:00:00 | IWM | ETF | 47.37 | 47.425 | 47.33 | 47.335 | 9800.0 |
| 2001-12-11 11:30:00 | IWM | ETF | 47.405 | 47.435 | 47.335 | 47.395 | 8600.0 |
| 2001-12-11 12:00:00 | IWM | ETF | 47.4 | 47.41 | 47.355 | 47.39 | 24000.0 |
| 2001-12-11 12:30:00 | IWM | ETF | 47.385 | 47.385 | 47.3 | 47.385 | 5400.0 |
| 2001-12-11 13:00:00 | IWM | ETF | 47.31 | 47.42 | 47.31 | 47.385 | 13000.0 |
| 2001-12-11 13:30:00 | IWM | ETF | 47.39 | 47.4 | 47.375 | 47.4 | 10600.0 |
| 2001-12-11 14:00:00 | IWM | ETF | 47.395 | 47.57 | 47.3 | 47.57 | 134600.0 |
| 2001-12-11 14:30:00 | IWM | ETF | 47.55 | 47.7 | 47.5 | 47.6 | 38800.0 |
| 2001-12-11 15:00:00 | IWM | ETF | 47.6 | 47.645 | 47.375 | 47.475 | 37800.0 |
| 2001-12-11 15:30:00 | IWM | ETF | 47.475 | 47.475 | 47.03 | 47.32 | 69200.0 |
| 2001-12-11 16:00:00 | IWM | ETF | 47.28 | 47.325 | 47.28 | 47.325 | 2600.0 |
| 2001-12-11 09:30:00 | DIA | ETF | 99.79 | 99.8 | 99.4 | 99.68 | 280900.0 |
> showing 50 of 473 rows — these rows as CSV