PREVIEW / etf_30min / 2001-03-30
file: by_date/etf_30min/2001/2001-03-30.parquet size: 14 KB rows: 332
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-03-30 09:30:00 | SPY | ETF | 115.55 | 115.9 | 115.12 | 115.64 | 1002900.0 |
| 2001-03-30 10:00:00 | SPY | ETF | 115.5 | 115.95 | 114.8 | 115.44 | 1314000.0 |
| 2001-03-30 10:30:00 | SPY | ETF | 115.44 | 115.72 | 114.85 | 115.09 | 536700.0 |
| 2001-03-30 11:00:00 | SPY | ETF | 114.99 | 115.1 | 114.5 | 114.61 | 392500.0 |
| 2001-03-30 11:30:00 | SPY | ETF | 114.56 | 115.6 | 114.56 | 115.34 | 498600.0 |
| 2001-03-30 12:00:00 | SPY | ETF | 115.46 | 115.82 | 115.2 | 115.68 | 350800.0 |
| 2001-03-30 12:30:00 | SPY | ETF | 115.77 | 115.78 | 115.22 | 115.47 | 210700.0 |
| 2001-03-30 13:00:00 | SPY | ETF | 115.47 | 115.49 | 114.94 | 115.3 | 256500.0 |
| 2001-03-30 13:30:00 | SPY | ETF | 115.33 | 115.86 | 115.31 | 115.86 | 433200.0 |
| 2001-03-30 14:00:00 | SPY | ETF | 115.78 | 116.2 | 115.7 | 116.12 | 651300.0 |
| 2001-03-30 14:30:00 | SPY | ETF | 116.16 | 116.65 | 115.9 | 116.28 | 999300.0 |
| 2001-03-30 15:00:00 | SPY | ETF | 116.1 | 116.44 | 115.6 | 115.7 | 321100.0 |
| 2001-03-30 15:30:00 | SPY | ETF | 115.71 | 116.4 | 115.43 | 116.12 | 1082600.0 |
| 2001-03-30 16:00:00 | SPY | ETF | 116.19 | 116.75 | 116.0 | 116.69 | 761900.0 |
| 2001-03-30 16:30:00 | SPY | ETF | 116.63 | 116.69 | 116.4 | 116.69 | 17800.0 |
| 2001-03-30 17:00:00 | SPY | ETF | 116.68 | 116.69 | 116.68 | 116.69 | 3900.0 |
| 2001-03-30 17:30:00 | SPY | ETF | 116.72 | 116.75 | 116.69 | 116.75 | 3300.0 |
| 2001-03-30 09:30:00 | QQQ | ETF | 39.3 | 39.43 | 38.62 | 39.05 | 8042200.0 |
| 2001-03-30 10:00:00 | QQQ | ETF | 39.05 | 39.28 | 38.39 | 38.78 | 6452700.0 |
| 2001-03-30 10:30:00 | QQQ | ETF | 38.78 | 38.95 | 38.23 | 38.35 | 4040700.0 |
| 2001-03-30 11:00:00 | QQQ | ETF | 38.33 | 38.42 | 38.08 | 38.23 | 3870800.0 |
| 2001-03-30 11:30:00 | QQQ | ETF | 38.23 | 38.9 | 38.23 | 38.79 | 4038700.0 |
| 2001-03-30 12:00:00 | QQQ | ETF | 38.79 | 39.15 | 38.6 | 39.05 | 4410500.0 |
| 2001-03-30 12:30:00 | QQQ | ETF | 39.1 | 39.11 | 38.7 | 38.86 | 2188200.0 |
| 2001-03-30 13:00:00 | QQQ | ETF | 38.87 | 38.95 | 38.55 | 38.81 | 1172500.0 |
| 2001-03-30 13:30:00 | QQQ | ETF | 38.81 | 39.5 | 38.81 | 39.48 | 4027900.0 |
| 2001-03-30 14:00:00 | QQQ | ETF | 39.48 | 39.81 | 39.4 | 39.65 | 5420900.0 |
| 2001-03-30 14:30:00 | QQQ | ETF | 39.64 | 39.98 | 39.31 | 39.45 | 4618200.0 |
| 2001-03-30 15:00:00 | QQQ | ETF | 39.45 | 39.5 | 39.02 | 39.05 | 4691500.0 |
| 2001-03-30 15:30:00 | QQQ | ETF | 39.05 | 39.53 | 38.85 | 39.13 | 5414000.0 |
| 2001-03-30 16:00:00 | QQQ | ETF | 39.12 | 39.4 | 39.05 | 39.2 | 947900.0 |
| 2001-03-30 16:30:00 | QQQ | ETF | 39.25 | 39.35 | 39.2 | 39.26 | 16500.0 |
| 2001-03-30 17:00:00 | QQQ | ETF | 39.26 | 39.3 | 39.2 | 39.28 | 18700.0 |
| 2001-03-30 17:30:00 | QQQ | ETF | 39.28 | 39.28 | 39.2 | 39.2 | 7200.0 |
| 2001-03-30 18:00:00 | QQQ | ETF | 39.2 | 39.35 | 39.2 | 39.3 | 5000.0 |
| 2001-03-30 18:30:00 | QQQ | ETF | 39.2 | 39.24 | 39.1 | 39.1 | 2500.0 |
| 2001-03-30 09:30:00 | IWM | ETF | 44.225 | 44.225 | 44.2 | 44.2 | 1000.0 |
| 2001-03-30 10:00:00 | IWM | ETF | 44.19 | 44.3 | 44.025 | 44.025 | 10600.0 |
| 2001-03-30 10:30:00 | IWM | ETF | 44.1 | 44.3 | 44.1 | 44.3 | 25400.0 |
| 2001-03-30 11:00:00 | IWM | ETF | 43.95 | 43.95 | 43.95 | 43.95 | 200.0 |
| 2001-03-30 12:00:00 | IWM | ETF | 44.25 | 44.45 | 44.25 | 44.375 | 20800.0 |
| 2001-03-30 12:30:00 | IWM | ETF | 44.475 | 44.475 | 44.435 | 44.435 | 2000.0 |
| 2001-03-30 13:00:00 | IWM | ETF | 44.25 | 44.25 | 44.25 | 44.25 | 200.0 |
| 2001-03-30 13:30:00 | IWM | ETF | 44.21 | 44.44 | 44.21 | 44.35 | 17200.0 |
| 2001-03-30 14:00:00 | IWM | ETF | 44.575 | 44.775 | 44.575 | 44.775 | 12600.0 |
| 2001-03-30 14:30:00 | IWM | ETF | 44.75 | 44.925 | 44.65 | 44.65 | 14200.0 |
| 2001-03-30 15:00:00 | IWM | ETF | 44.6 | 44.775 | 44.55 | 44.625 | 67200.0 |
| 2001-03-30 15:30:00 | IWM | ETF | 44.625 | 44.9 | 44.575 | 44.85 | 29400.0 |
| 2001-03-30 16:00:00 | IWM | ETF | 44.8 | 44.8 | 44.8 | 44.8 | 10000.0 |
| 2001-03-30 09:30:00 | DIA | ETF | 98.32 | 98.65 | 97.95 | 98.19 | 553300.0 |
> showing 50 of 332 rows — these rows as CSV