PREVIEW / etf_30min / 2005-03-23
file: by_date/etf_30min/2005/2005-03-23.parquet size: 45 KB rows: 1,516
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-23 08:00:00 | SPY | ETF | 117.13 | 117.14 | 117.0 | 117.08 | 82400.0 |
| 2005-03-23 08:30:00 | SPY | ETF | 117.08 | 117.08 | 116.49 | 116.85 | 1535200.0 |
| 2005-03-23 09:00:00 | SPY | ETF | 116.79 | 116.96 | 116.79 | 116.95 | 199900.0 |
| 2005-03-23 09:30:00 | SPY | ETF | 116.945 | 117.1 | 116.83 | 116.87 | 10439800.0 |
| 2005-03-23 10:00:00 | SPY | ETF | 116.87 | 117.26 | 116.81 | 116.98 | 10182900.0 |
| 2005-03-23 10:30:00 | SPY | ETF | 116.98 | 117.2 | 116.75 | 117.13 | 8629300.0 |
| 2005-03-23 11:00:00 | SPY | ETF | 117.13 | 117.37 | 117.02 | 117.28 | 6074300.0 |
| 2005-03-23 11:30:00 | SPY | ETF | 117.28 | 117.3 | 117.01 | 117.12 | 3679800.0 |
| 2005-03-23 12:00:00 | SPY | ETF | 117.12 | 117.47 | 117.1 | 117.3 | 4771000.0 |
| 2005-03-23 12:30:00 | SPY | ETF | 117.3 | 117.39 | 117.2 | 117.31 | 3080700.0 |
| 2005-03-23 13:00:00 | SPY | ETF | 117.32 | 117.44 | 117.18 | 117.2 | 1926300.0 |
| 2005-03-23 13:30:00 | SPY | ETF | 117.2 | 117.51 | 117.19 | 117.44 | 2388900.0 |
| 2005-03-23 14:00:00 | SPY | ETF | 117.45 | 117.59 | 117.39 | 117.52 | 3528600.0 |
| 2005-03-23 14:30:00 | SPY | ETF | 117.52 | 117.55 | 117.22 | 117.27 | 3148600.0 |
| 2005-03-23 15:00:00 | SPY | ETF | 117.27 | 117.43 | 117.06 | 117.37 | 3987500.0 |
| 2005-03-23 15:30:00 | SPY | ETF | 117.38 | 117.72 | 117.06 | 117.06 | 3646600.0 |
| 2005-03-23 16:00:00 | SPY | ETF | 117.07 | 117.11 | 117.0 | 117.05 | 1829900.0 |
| 2005-03-23 16:30:00 | SPY | ETF | 117.05 | 117.08 | 117.03 | 117.08 | 139300.0 |
| 2005-03-23 17:00:00 | SPY | ETF | 117.05 | 117.08 | 117.04 | 117.08 | 2000.0 |
| 2005-03-23 17:30:00 | SPY | ETF | 117.08 | 117.08 | 117.0 | 117.0 | 19900.0 |
| 2005-03-23 18:00:00 | SPY | ETF | 117.07 | 117.17 | 117.01 | 117.11 | 961500.0 |
| 2005-03-23 18:30:00 | SPY | ETF | 117.11 | 117.11 | 117.07 | 117.07 | 300.0 |
| 2005-03-23 19:30:00 | SPY | ETF | 117.15 | 117.16 | 117.13 | 117.15 | 1700.0 |
| 2005-03-23 09:30:00 | QQQ | ETF | 36.09 | 36.26 | 36.07 | 36.2 | 17073400.0 |
| 2005-03-23 10:00:00 | QQQ | ETF | 36.19 | 36.41 | 36.19 | 36.32 | 13628400.0 |
| 2005-03-23 10:30:00 | QQQ | ETF | 36.32 | 36.36 | 36.2 | 36.33 | 8373000.0 |
| 2005-03-23 11:00:00 | QQQ | ETF | 36.33 | 36.4 | 36.29 | 36.33 | 5335500.0 |
| 2005-03-23 11:30:00 | QQQ | ETF | 36.32 | 36.35 | 36.23 | 36.29 | 3199600.0 |
| 2005-03-23 12:00:00 | QQQ | ETF | 36.29 | 36.46 | 36.29 | 36.4 | 5528700.0 |
| 2005-03-23 12:30:00 | QQQ | ETF | 36.4 | 36.44 | 36.31 | 36.39 | 3394400.0 |
| 2005-03-23 13:00:00 | QQQ | ETF | 36.38 | 36.42 | 36.3 | 36.31 | 3353600.0 |
| 2005-03-23 13:30:00 | QQQ | ETF | 36.31 | 36.47 | 36.3 | 36.43 | 3959900.0 |
| 2005-03-23 14:00:00 | QQQ | ETF | 36.43 | 36.49 | 36.42 | 36.46 | 3923800.0 |
| 2005-03-23 14:30:00 | QQQ | ETF | 36.45 | 36.46 | 36.34 | 36.36 | 3999800.0 |
| 2005-03-23 15:00:00 | QQQ | ETF | 36.36 | 36.45 | 36.29 | 36.43 | 5297100.0 |
| 2005-03-23 15:30:00 | QQQ | ETF | 36.42 | 36.44 | 36.25 | 36.26 | 7933800.0 |
| 2005-03-23 08:00:00 | IWM | ETF | 61.675 | 61.675 | 61.675 | 61.675 | 400.0 |
| 2005-03-23 08:30:00 | IWM | ETF | 61.39 | 61.39 | 61.335 | 61.335 | 6600.0 |
| 2005-03-23 09:00:00 | IWM | ETF | 61.5 | 61.5 | 61.5 | 61.5 | 400.0 |
| 2005-03-23 09:30:00 | IWM | ETF | 61.5 | 61.5 | 61.26 | 61.32 | 2765800.0 |
| 2005-03-23 10:00:00 | IWM | ETF | 61.32 | 61.515 | 61.23 | 61.355 | 2422000.0 |
| 2005-03-23 10:30:00 | IWM | ETF | 61.355 | 61.39 | 61.13 | 61.345 | 2342200.0 |
| 2005-03-23 11:00:00 | IWM | ETF | 61.35 | 61.41 | 61.285 | 61.375 | 1943000.0 |
| 2005-03-23 11:30:00 | IWM | ETF | 61.375 | 61.375 | 61.21 | 61.26 | 574800.0 |
| 2005-03-23 12:00:00 | IWM | ETF | 61.265 | 61.4 | 61.235 | 61.35 | 663000.0 |
| 2005-03-23 12:30:00 | IWM | ETF | 61.35 | 61.4 | 61.3 | 61.315 | 400600.0 |
| 2005-03-23 13:00:00 | IWM | ETF | 61.32 | 61.375 | 61.255 | 61.265 | 766000.0 |
| 2005-03-23 13:30:00 | IWM | ETF | 61.275 | 61.41 | 61.275 | 61.365 | 684600.0 |
| 2005-03-23 14:00:00 | IWM | ETF | 61.365 | 61.475 | 61.32 | 61.36 | 1124800.0 |
| 2005-03-23 14:30:00 | IWM | ETF | 61.36 | 61.36 | 61.175 | 61.19 | 1253200.0 |
> showing 50 of 1,516 rows — these rows as CSV