PREVIEW / etf_30min / 2001-02-06
file: by_date/etf_30min/2001/2001-02-06.parquet size: 13 KB rows: 322
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-02-06 09:30:00 | SPY | ETF | 135.3 | 135.99 | 135.3 | 135.72 | 955200.0 |
| 2001-02-06 10:00:00 | SPY | ETF | 135.85 | 135.98 | 135.41 | 135.94 | 334300.0 |
| 2001-02-06 10:30:00 | SPY | ETF | 135.98 | 136.19 | 135.9 | 136.0 | 365600.0 |
| 2001-02-06 11:00:00 | SPY | ETF | 136.0 | 136.31 | 135.93 | 136.3 | 2549400.0 |
| 2001-02-06 11:30:00 | SPY | ETF | 136.25 | 136.59 | 136.16 | 136.58 | 222900.0 |
| 2001-02-06 12:00:00 | SPY | ETF | 136.55 | 136.7 | 136.3 | 136.49 | 413000.0 |
| 2001-02-06 12:30:00 | SPY | ETF | 136.49 | 136.57 | 136.35 | 136.42 | 149900.0 |
| 2001-02-06 13:00:00 | SPY | ETF | 136.51 | 136.51 | 136.25 | 136.39 | 276000.0 |
| 2001-02-06 13:30:00 | SPY | ETF | 136.3 | 136.33 | 135.92 | 136.0 | 151600.0 |
| 2001-02-06 14:00:00 | SPY | ETF | 136.0 | 136.06 | 135.6 | 135.97 | 396900.0 |
| 2001-02-06 14:30:00 | SPY | ETF | 135.97 | 136.15 | 135.64 | 135.79 | 268800.0 |
| 2001-02-06 15:00:00 | SPY | ETF | 135.8 | 135.89 | 135.5 | 135.6 | 163500.0 |
| 2001-02-06 15:30:00 | SPY | ETF | 135.6 | 135.6 | 135.22 | 135.42 | 491800.0 |
| 2001-02-06 16:00:00 | SPY | ETF | 135.55 | 135.55 | 135.24 | 135.39 | 311300.0 |
| 2001-02-06 17:30:00 | SPY | ETF | 135.25 | 135.25 | 135.2 | 135.2 | 600.0 |
| 2001-02-06 09:30:00 | QQQ | ETF | 61.49 | 62.43 | 61.4 | 62.23 | 5333300.0 |
| 2001-02-06 10:00:00 | QQQ | ETF | 62.3 | 62.45 | 61.79 | 62.4 | 3036800.0 |
| 2001-02-06 10:30:00 | QQQ | ETF | 62.4 | 63.0 | 62.35 | 62.64 | 5814000.0 |
| 2001-02-06 11:00:00 | QQQ | ETF | 62.63 | 62.96 | 62.55 | 62.78 | 2044700.0 |
| 2001-02-06 11:30:00 | QQQ | ETF | 62.75 | 62.94 | 62.48 | 62.85 | 2106800.0 |
| 2001-02-06 12:00:00 | QQQ | ETF | 62.93 | 63.12 | 62.7 | 62.77 | 3291400.0 |
| 2001-02-06 12:30:00 | QQQ | ETF | 62.8 | 62.9 | 62.65 | 62.73 | 1449400.0 |
| 2001-02-06 13:00:00 | QQQ | ETF | 62.73 | 62.8 | 62.3 | 62.43 | 2826700.0 |
| 2001-02-06 13:30:00 | QQQ | ETF | 62.42 | 62.44 | 61.95 | 62.09 | 2522000.0 |
| 2001-02-06 14:00:00 | QQQ | ETF | 62.05 | 62.15 | 61.56 | 62.1 | 3011800.0 |
| 2001-02-06 14:30:00 | QQQ | ETF | 62.12 | 62.44 | 61.85 | 61.95 | 3236300.0 |
| 2001-02-06 15:00:00 | QQQ | ETF | 62.05 | 62.1 | 61.61 | 61.61 | 1975700.0 |
| 2001-02-06 15:30:00 | QQQ | ETF | 61.61 | 61.78 | 61.16 | 61.7 | 3543700.0 |
| 2001-02-06 16:00:00 | QQQ | ETF | 61.65 | 61.9 | 60.75 | 61.13 | 1071900.0 |
| 2001-02-06 16:30:00 | QQQ | ETF | 61.07 | 61.75 | 60.0 | 60.55 | 518600.0 |
| 2001-02-06 17:00:00 | QQQ | ETF | 60.6 | 60.77 | 60.5 | 60.75 | 96800.0 |
| 2001-02-06 17:30:00 | QQQ | ETF | 60.69 | 60.9 | 60.5 | 60.81 | 97200.0 |
| 2001-02-06 18:00:00 | QQQ | ETF | 60.8 | 60.81 | 60.61 | 60.66 | 26000.0 |
| 2001-02-06 09:30:00 | IWM | ETF | 49.875 | 50.15 | 49.875 | 50.15 | 36800.0 |
| 2001-02-06 10:00:00 | IWM | ETF | 50.15 | 50.225 | 50.135 | 50.225 | 3000.0 |
| 2001-02-06 10:30:00 | IWM | ETF | 50.275 | 50.475 | 50.275 | 50.475 | 153800.0 |
| 2001-02-06 11:00:00 | IWM | ETF | 50.575 | 50.705 | 50.575 | 50.665 | 139000.0 |
| 2001-02-06 11:30:00 | IWM | ETF | 50.555 | 50.65 | 50.555 | 50.65 | 26800.0 |
| 2001-02-06 12:00:00 | IWM | ETF | 50.725 | 50.745 | 50.63 | 50.745 | 3600.0 |
| 2001-02-06 12:30:00 | IWM | ETF | 50.72 | 50.725 | 50.72 | 50.725 | 3200.0 |
| 2001-02-06 13:00:00 | IWM | ETF | 50.745 | 50.745 | 50.625 | 50.635 | 9000.0 |
| 2001-02-06 13:30:00 | IWM | ETF | 50.65 | 50.65 | 50.65 | 50.65 | 7400.0 |
| 2001-02-06 14:00:00 | IWM | ETF | 50.65 | 50.65 | 50.375 | 50.4 | 5200.0 |
| 2001-02-06 15:00:00 | IWM | ETF | 50.5 | 50.5 | 50.25 | 50.275 | 5400.0 |
| 2001-02-06 15:30:00 | IWM | ETF | 50.45 | 50.5 | 50.2 | 50.5 | 18800.0 |
| 2001-02-06 16:00:00 | IWM | ETF | 50.575 | 50.575 | 50.575 | 50.575 | 12800.0 |
| 2001-02-06 09:30:00 | DIA | ETF | 109.3 | 109.8 | 109.3 | 109.48 | 111900.0 |
| 2001-02-06 10:00:00 | DIA | ETF | 109.55 | 109.92 | 109.34 | 109.79 | 64800.0 |
| 2001-02-06 10:30:00 | DIA | ETF | 109.92 | 110.09 | 109.79 | 109.86 | 133300.0 |
| 2001-02-06 11:00:00 | DIA | ETF | 109.86 | 110.18 | 109.8 | 110.1 | 41400.0 |
> showing 50 of 322 rows — these rows as CSV