PREVIEW / etf_30min / 2001-10-22
file: by_date/etf_30min/2001/2001-10-22.parquet size: 16 KB rows: 394
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-22 09:30:00 | SPY | ETF | 107.3 | 108.18 | 107.21 | 108.1 | 3061500.0 |
| 2001-10-22 10:00:00 | SPY | ETF | 108.09 | 108.19 | 107.72 | 107.81 | 1101600.0 |
| 2001-10-22 10:30:00 | SPY | ETF | 107.87 | 108.25 | 107.75 | 108.01 | 933500.0 |
| 2001-10-22 11:00:00 | SPY | ETF | 108.0 | 108.25 | 107.91 | 108.13 | 641600.0 |
| 2001-10-22 11:30:00 | SPY | ETF | 108.13 | 108.35 | 107.9 | 108.05 | 568500.0 |
| 2001-10-22 12:00:00 | SPY | ETF | 108.05 | 108.5 | 107.95 | 108.38 | 720000.0 |
| 2001-10-22 12:30:00 | SPY | ETF | 108.42 | 108.62 | 108.37 | 108.48 | 935700.0 |
| 2001-10-22 13:00:00 | SPY | ETF | 108.46 | 108.63 | 108.1 | 108.4 | 778100.0 |
| 2001-10-22 13:30:00 | SPY | ETF | 108.34 | 108.35 | 107.91 | 108.15 | 919500.0 |
| 2001-10-22 14:00:00 | SPY | ETF | 108.11 | 108.62 | 107.95 | 108.55 | 531900.0 |
| 2001-10-22 14:30:00 | SPY | ETF | 108.55 | 109.23 | 108.45 | 109.1 | 1880500.0 |
| 2001-10-22 15:00:00 | SPY | ETF | 109.09 | 109.28 | 108.98 | 109.06 | 936400.0 |
| 2001-10-22 15:30:00 | SPY | ETF | 109.07 | 109.49 | 109.06 | 109.26 | 2743300.0 |
| 2001-10-22 16:00:00 | SPY | ETF | 109.3 | 109.57 | 109.25 | 109.41 | 853300.0 |
| 2001-10-22 16:30:00 | SPY | ETF | 109.45 | 109.54 | 108.05 | 109.5 | 36500.0 |
| 2001-10-22 17:30:00 | SPY | ETF | 109.69 | 109.69 | 109.69 | 109.69 | 100.0 |
| 2001-10-22 18:00:00 | SPY | ETF | 109.49 | 109.49 | 109.49 | 109.49 | 300.0 |
| 2001-10-22 09:30:00 | QQQ | ETF | 33.44 | 34.24 | 33.22 | 34.12 | 11272700.0 |
| 2001-10-22 10:00:00 | QQQ | ETF | 34.18 | 34.22 | 33.9 | 34.02 | 7207500.0 |
| 2001-10-22 10:30:00 | QQQ | ETF | 34.02 | 34.38 | 33.95 | 34.1 | 5287600.0 |
| 2001-10-22 11:00:00 | QQQ | ETF | 34.15 | 34.27 | 33.95 | 34.04 | 4579300.0 |
| 2001-10-22 11:30:00 | QQQ | ETF | 34.04 | 34.15 | 33.83 | 33.9 | 3972900.0 |
| 2001-10-22 12:00:00 | QQQ | ETF | 33.92 | 34.16 | 33.89 | 34.1 | 2409300.0 |
| 2001-10-22 12:30:00 | QQQ | ETF | 34.1 | 34.15 | 33.91 | 33.95 | 1880900.0 |
| 2001-10-22 13:00:00 | QQQ | ETF | 33.95 | 34.04 | 33.7 | 33.87 | 5345000.0 |
| 2001-10-22 13:30:00 | QQQ | ETF | 33.87 | 33.89 | 33.51 | 33.73 | 3948900.0 |
| 2001-10-22 14:00:00 | QQQ | ETF | 33.71 | 34.06 | 33.6 | 34.01 | 3603400.0 |
| 2001-10-22 14:30:00 | QQQ | ETF | 34.02 | 34.31 | 33.85 | 34.21 | 4513200.0 |
| 2001-10-22 15:00:00 | QQQ | ETF | 34.2 | 34.33 | 34.06 | 34.14 | 4855000.0 |
| 2001-10-22 15:30:00 | QQQ | ETF | 34.14 | 34.43 | 34.12 | 34.43 | 8091700.0 |
| 2001-10-22 16:00:00 | QQQ | ETF | 34.43 | 34.55 | 34.37 | 34.52 | 3867700.0 |
| 2001-10-22 16:30:00 | QQQ | ETF | 34.49 | 34.58 | 34.49 | 34.56 | 80600.0 |
| 2001-10-22 17:00:00 | QQQ | ETF | 34.55 | 34.62 | 34.5 | 34.56 | 56200.0 |
| 2001-10-22 17:30:00 | QQQ | ETF | 34.54 | 34.63 | 34.53 | 34.55 | 23800.0 |
| 2001-10-22 18:00:00 | QQQ | ETF | 34.53 | 34.6 | 34.53 | 34.53 | 4500.0 |
| 2001-10-22 09:30:00 | IWM | ETF | 42.375 | 42.5 | 42.34 | 42.49 | 21800.0 |
| 2001-10-22 10:00:00 | IWM | ETF | 42.55 | 42.55 | 42.375 | 42.41 | 34800.0 |
| 2001-10-22 10:30:00 | IWM | ETF | 42.455 | 42.575 | 42.41 | 42.535 | 56200.0 |
| 2001-10-22 11:00:00 | IWM | ETF | 42.525 | 42.575 | 42.44 | 42.44 | 39200.0 |
| 2001-10-22 11:30:00 | IWM | ETF | 42.46 | 42.525 | 42.455 | 42.455 | 46000.0 |
| 2001-10-22 12:00:00 | IWM | ETF | 42.53 | 42.575 | 42.53 | 42.555 | 23600.0 |
| 2001-10-22 12:30:00 | IWM | ETF | 42.62 | 42.65 | 42.575 | 42.575 | 15800.0 |
| 2001-10-22 13:00:00 | IWM | ETF | 42.66 | 42.7 | 42.59 | 42.64 | 4800.0 |
| 2001-10-22 13:30:00 | IWM | ETF | 42.55 | 42.6 | 42.505 | 42.6 | 28400.0 |
| 2001-10-22 14:00:00 | IWM | ETF | 42.605 | 42.625 | 42.585 | 42.59 | 24200.0 |
| 2001-10-22 14:30:00 | IWM | ETF | 42.685 | 42.85 | 42.68 | 42.82 | 14800.0 |
| 2001-10-22 15:00:00 | IWM | ETF | 42.735 | 42.83 | 42.705 | 42.76 | 10600.0 |
| 2001-10-22 15:30:00 | IWM | ETF | 42.775 | 42.875 | 42.68 | 42.68 | 34200.0 |
| 2001-10-22 09:30:00 | DIA | ETF | 91.9 | 92.69 | 91.7 | 92.57 | 728800.0 |
| 2001-10-22 10:00:00 | DIA | ETF | 92.58 | 92.7 | 92.39 | 92.46 | 140900.0 |
> showing 50 of 394 rows — these rows as CSV