PREVIEW / etf_30min / 2001-12-27
file: by_date/etf_30min/2001/2001-12-27.parquet size: 17 KB rows: 462
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-27 09:30:00 | SPY | ETF | 115.3 | 115.73 | 115.25 | 115.68 | 1413900.0 |
| 2001-12-27 10:00:00 | SPY | ETF | 115.65 | 115.93 | 115.65 | 115.74 | 782100.0 |
| 2001-12-27 10:30:00 | SPY | ETF | 115.76 | 115.86 | 115.58 | 115.68 | 1138200.0 |
| 2001-12-27 11:00:00 | SPY | ETF | 115.69 | 115.86 | 115.63 | 115.66 | 482200.0 |
| 2001-12-27 11:30:00 | SPY | ETF | 115.7 | 115.82 | 115.65 | 115.8 | 264400.0 |
| 2001-12-27 12:00:00 | SPY | ETF | 115.77 | 115.8 | 115.66 | 115.76 | 303500.0 |
| 2001-12-27 12:30:00 | SPY | ETF | 115.76 | 115.88 | 115.74 | 115.81 | 426200.0 |
| 2001-12-27 13:00:00 | SPY | ETF | 115.82 | 115.82 | 115.66 | 115.78 | 396600.0 |
| 2001-12-27 13:30:00 | SPY | ETF | 115.75 | 115.8 | 115.53 | 115.64 | 669900.0 |
| 2001-12-27 14:00:00 | SPY | ETF | 115.63 | 115.64 | 115.45 | 115.55 | 272800.0 |
| 2001-12-27 14:30:00 | SPY | ETF | 115.57 | 115.67 | 115.26 | 115.33 | 406100.0 |
| 2001-12-27 15:00:00 | SPY | ETF | 115.36 | 115.76 | 115.36 | 115.73 | 614800.0 |
| 2001-12-27 15:30:00 | SPY | ETF | 115.72 | 115.96 | 115.72 | 115.93 | 768400.0 |
| 2001-12-27 16:00:00 | SPY | ETF | 115.87 | 116.08 | 115.87 | 116.06 | 1390200.0 |
| 2001-12-27 16:30:00 | SPY | ETF | 115.98 | 116.01 | 115.88 | 115.91 | 3100.0 |
| 2001-12-27 17:00:00 | SPY | ETF | 116.0 | 116.0 | 115.93 | 115.93 | 3100.0 |
| 2001-12-27 09:30:00 | QQQ | ETF | 39.85 | 40.17 | 39.77 | 40.1 | 6752800.0 |
| 2001-12-27 10:00:00 | QQQ | ETF | 40.14 | 40.2 | 40.04 | 40.1 | 3368200.0 |
| 2001-12-27 10:30:00 | QQQ | ETF | 40.1 | 40.17 | 39.95 | 40.05 | 2709900.0 |
| 2001-12-27 11:00:00 | QQQ | ETF | 40.03 | 40.18 | 40.02 | 40.06 | 2300500.0 |
| 2001-12-27 11:30:00 | QQQ | ETF | 40.05 | 40.14 | 40.01 | 40.1 | 1021100.0 |
| 2001-12-27 12:00:00 | QQQ | ETF | 40.12 | 40.14 | 40.01 | 40.04 | 975700.0 |
| 2001-12-27 12:30:00 | QQQ | ETF | 40.04 | 40.1 | 39.98 | 40.0 | 1140200.0 |
| 2001-12-27 13:00:00 | QQQ | ETF | 40.01 | 40.02 | 39.89 | 39.98 | 1472400.0 |
| 2001-12-27 13:30:00 | QQQ | ETF | 39.97 | 39.99 | 39.76 | 39.85 | 1588100.0 |
| 2001-12-27 14:00:00 | QQQ | ETF | 39.84 | 39.86 | 39.68 | 39.79 | 1899100.0 |
| 2001-12-27 14:30:00 | QQQ | ETF | 39.79 | 39.87 | 39.6 | 39.67 | 2368700.0 |
| 2001-12-27 15:00:00 | QQQ | ETF | 39.68 | 39.96 | 39.66 | 39.94 | 3413000.0 |
| 2001-12-27 15:30:00 | QQQ | ETF | 39.95 | 40.02 | 39.9 | 39.95 | 4378100.0 |
| 2001-12-27 16:00:00 | QQQ | ETF | 39.97 | 40.05 | 39.93 | 40.0 | 776800.0 |
| 2001-12-27 16:30:00 | QQQ | ETF | 40.0 | 40.05 | 39.93 | 40.02 | 22000.0 |
| 2001-12-27 17:00:00 | QQQ | ETF | 40.02 | 40.05 | 40.01 | 40.01 | 1600.0 |
| 2001-12-27 17:30:00 | QQQ | ETF | 40.05 | 40.05 | 40.03 | 40.03 | 8600.0 |
| 2001-12-27 18:00:00 | QQQ | ETF | 40.04 | 40.05 | 40.01 | 40.05 | 9100.0 |
| 2001-12-27 09:30:00 | IWM | ETF | 48.75 | 49.0 | 48.75 | 48.985 | 114000.0 |
| 2001-12-27 10:00:00 | IWM | ETF | 49.0 | 49.045 | 48.94 | 48.99 | 102800.0 |
| 2001-12-27 10:30:00 | IWM | ETF | 48.98 | 49.0 | 48.87 | 48.885 | 83200.0 |
| 2001-12-27 11:00:00 | IWM | ETF | 48.87 | 48.95 | 48.8 | 48.935 | 104200.0 |
| 2001-12-27 11:30:00 | IWM | ETF | 48.91 | 48.93 | 48.88 | 48.91 | 130600.0 |
| 2001-12-27 12:00:00 | IWM | ETF | 48.91 | 48.91 | 48.835 | 48.905 | 106200.0 |
| 2001-12-27 12:30:00 | IWM | ETF | 48.915 | 48.985 | 48.9 | 48.95 | 41200.0 |
| 2001-12-27 13:00:00 | IWM | ETF | 48.935 | 48.94 | 48.9 | 48.905 | 79000.0 |
| 2001-12-27 13:30:00 | IWM | ETF | 48.86 | 48.915 | 48.8 | 48.815 | 131400.0 |
| 2001-12-27 14:00:00 | IWM | ETF | 48.82 | 48.89 | 48.785 | 48.89 | 131000.0 |
| 2001-12-27 14:30:00 | IWM | ETF | 48.885 | 48.89 | 48.81 | 48.81 | 132600.0 |
| 2001-12-27 15:00:00 | IWM | ETF | 48.815 | 48.995 | 48.73 | 48.995 | 20200.0 |
| 2001-12-27 15:30:00 | IWM | ETF | 48.99 | 49.075 | 48.9 | 48.95 | 473800.0 |
| 2001-12-27 16:00:00 | IWM | ETF | 49.0 | 49.0 | 48.925 | 48.95 | 52600.0 |
| 2001-12-27 09:30:00 | DIA | ETF | 101.12 | 101.39 | 100.9 | 101.38 | 215800.0 |
| 2001-12-27 10:00:00 | DIA | ETF | 101.37 | 101.55 | 101.3 | 101.4 | 78600.0 |
> showing 50 of 462 rows — these rows as CSV