PREVIEW / etf_30min / 2004-03-09
file: by_date/etf_30min/2004/2004-03-09.parquet size: 35 KB rows: 1,164
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-09 08:00:00 | SPY | ETF | 114.99 | 114.99 | 114.88 | 114.92 | 113100.0 |
| 2004-03-09 08:30:00 | SPY | ETF | 114.94 | 115.1 | 114.94 | 115.05 | 44300.0 |
| 2004-03-09 09:00:00 | SPY | ETF | 115.05 | 115.08 | 115.04 | 115.08 | 77600.0 |
| 2004-03-09 09:30:00 | SPY | ETF | 115.07 | 115.15 | 114.85 | 115.11 | 3303100.0 |
| 2004-03-09 10:00:00 | SPY | ETF | 115.14 | 115.2 | 114.82 | 114.92 | 1084700.0 |
| 2004-03-09 10:30:00 | SPY | ETF | 114.92 | 114.98 | 114.65 | 114.93 | 1037500.0 |
| 2004-03-09 11:00:00 | SPY | ETF | 114.93 | 115.08 | 114.87 | 115.08 | 1463600.0 |
| 2004-03-09 11:30:00 | SPY | ETF | 115.06 | 115.09 | 114.81 | 114.83 | 813400.0 |
| 2004-03-09 12:00:00 | SPY | ETF | 114.83 | 114.89 | 114.55 | 114.8 | 2280000.0 |
| 2004-03-09 12:30:00 | SPY | ETF | 114.81 | 115.05 | 114.58 | 114.63 | 1392400.0 |
| 2004-03-09 13:00:00 | SPY | ETF | 114.62 | 114.79 | 114.47 | 114.74 | 2619600.0 |
| 2004-03-09 13:30:00 | SPY | ETF | 114.73 | 114.77 | 114.49 | 114.56 | 1501300.0 |
| 2004-03-09 14:00:00 | SPY | ETF | 114.57 | 114.85 | 114.36 | 114.45 | 1519000.0 |
| 2004-03-09 14:30:00 | SPY | ETF | 114.45 | 114.53 | 114.27 | 114.37 | 1447100.0 |
| 2004-03-09 15:00:00 | SPY | ETF | 114.37 | 114.59 | 114.24 | 114.42 | 3061500.0 |
| 2004-03-09 15:30:00 | SPY | ETF | 114.43 | 114.79 | 114.42 | 114.66 | 2459500.0 |
| 2004-03-09 16:00:00 | SPY | ETF | 114.67 | 114.68 | 114.49 | 114.54 | 1133600.0 |
| 2004-03-09 16:30:00 | SPY | ETF | 114.56 | 114.57 | 114.5 | 114.53 | 21200.0 |
| 2004-03-09 17:00:00 | SPY | ETF | 114.55 | 114.55 | 114.45 | 114.45 | 7200.0 |
| 2004-03-09 17:30:00 | SPY | ETF | 114.45 | 114.5 | 114.45 | 114.5 | 200.0 |
| 2004-03-09 18:00:00 | SPY | ETF | 114.5 | 114.51 | 114.5 | 114.51 | 700.0 |
| 2004-03-09 18:30:00 | SPY | ETF | 114.55 | 114.55 | 114.5 | 114.5 | 1100.0 |
| 2004-03-09 19:00:00 | SPY | ETF | 114.5 | 114.5 | 114.48 | 114.48 | 300.0 |
| 2004-03-09 19:30:00 | SPY | ETF | 114.54 | 114.54 | 114.53 | 114.53 | 700.0 |
| 2004-03-09 08:00:00 | QQQ | ETF | 35.75 | 35.8 | 35.69 | 35.72 | 179000.0 |
| 2004-03-09 08:30:00 | QQQ | ETF | 35.72 | 35.82 | 35.72 | 35.81 | 143500.0 |
| 2004-03-09 09:00:00 | QQQ | ETF | 35.8 | 35.83 | 35.8 | 35.81 | 615700.0 |
| 2004-03-09 09:30:00 | QQQ | ETF | 35.799 | 35.92 | 35.68 | 35.91 | 7971700.0 |
| 2004-03-09 10:00:00 | QQQ | ETF | 35.91 | 35.92 | 35.65 | 35.781 | 4339100.0 |
| 2004-03-09 10:30:00 | QQQ | ETF | 35.78 | 35.81 | 35.57 | 35.803 | 4971200.0 |
| 2004-03-09 11:00:00 | QQQ | ETF | 35.8 | 35.93 | 35.77 | 35.93 | 4741300.0 |
| 2004-03-09 11:30:00 | QQQ | ETF | 35.937 | 35.98 | 35.8 | 35.801 | 5551300.0 |
| 2004-03-09 12:00:00 | QQQ | ETF | 35.81 | 35.825 | 35.66 | 35.799 | 6573300.0 |
| 2004-03-09 12:30:00 | QQQ | ETF | 35.79 | 35.855 | 35.63 | 35.69 | 5693000.0 |
| 2004-03-09 13:00:00 | QQQ | ETF | 35.72 | 35.756 | 35.61 | 35.74 | 4700900.0 |
| 2004-03-09 13:30:00 | QQQ | ETF | 35.75 | 35.784 | 35.63 | 35.66 | 4001400.0 |
| 2004-03-09 14:00:00 | QQQ | ETF | 35.674 | 35.8 | 35.57 | 35.6 | 7648500.0 |
| 2004-03-09 14:30:00 | QQQ | ETF | 35.61 | 35.676 | 35.52 | 35.55 | 6867900.0 |
| 2004-03-09 15:00:00 | QQQ | ETF | 35.55 | 35.71 | 35.52 | 35.6519 | 8926200.0 |
| 2004-03-09 15:30:00 | QQQ | ETF | 35.652 | 35.89 | 35.62 | 35.8 | 8991400.0 |
| 2004-03-09 16:00:00 | QQQ | ETF | 35.786 | 35.82 | 35.65 | 35.69 | 2421800.0 |
| 2004-03-09 16:30:00 | QQQ | ETF | 35.69 | 35.69 | 35.67 | 35.68 | 135200.0 |
| 2004-03-09 17:00:00 | QQQ | ETF | 35.68 | 35.69 | 35.67 | 35.68 | 25800.0 |
| 2004-03-09 17:30:00 | QQQ | ETF | 35.67 | 35.671 | 35.65 | 35.65 | 69600.0 |
| 2004-03-09 18:00:00 | QQQ | ETF | 35.65 | 35.69 | 35.65 | 35.69 | 14500.0 |
| 2004-03-09 18:30:00 | QQQ | ETF | 35.69 | 35.7 | 35.68 | 35.68 | 8800.0 |
| 2004-03-09 19:00:00 | QQQ | ETF | 35.69 | 35.69 | 35.69 | 35.69 | 2700.0 |
| 2004-03-09 19:30:00 | QQQ | ETF | 35.68 | 35.69 | 35.66 | 35.66 | 14800.0 |
| 2004-03-09 09:00:00 | IWM | ETF | 58.945 | 58.945 | 58.945 | 58.945 | 4000.0 |
| 2004-03-09 09:30:00 | IWM | ETF | 58.95 | 59.15 | 58.785 | 59.125 | 324000.0 |
> showing 50 of 1,164 rows — these rows as CSV