PREVIEW / etf_30min / 2004-10-11
file: by_date/etf_30min/2004/2004-10-11.parquet size: 32 KB rows: 1,159
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-10-11 08:00:00 | SPY | ETF | 112.65 | 112.65 | 112.64 | 112.65 | 10600.0 |
| 2004-10-11 08:30:00 | SPY | ETF | 112.62 | 112.62 | 112.57 | 112.6 | 37300.0 |
| 2004-10-11 09:00:00 | SPY | ETF | 112.6 | 112.83 | 112.6 | 112.8 | 209800.0 |
| 2004-10-11 09:30:00 | SPY | ETF | 112.78 | 112.96 | 112.74 | 112.8 | 3254300.0 |
| 2004-10-11 10:00:00 | SPY | ETF | 112.82 | 112.85 | 112.67 | 112.84 | 2621700.0 |
| 2004-10-11 10:30:00 | SPY | ETF | 112.85 | 112.86 | 112.67 | 112.76 | 1710200.0 |
| 2004-10-11 11:00:00 | SPY | ETF | 112.76 | 112.88 | 112.74 | 112.77 | 979700.0 |
| 2004-10-11 11:30:00 | SPY | ETF | 112.77 | 112.79 | 112.67 | 112.7 | 1074900.0 |
| 2004-10-11 12:00:00 | SPY | ETF | 112.71 | 112.77 | 112.64 | 112.66 | 931200.0 |
| 2004-10-11 12:30:00 | SPY | ETF | 112.67 | 112.83 | 112.65 | 112.79 | 1060000.0 |
| 2004-10-11 13:00:00 | SPY | ETF | 112.79 | 112.87 | 112.7 | 112.8 | 801500.0 |
| 2004-10-11 13:30:00 | SPY | ETF | 112.8 | 112.88 | 112.79 | 112.85 | 568700.0 |
| 2004-10-11 14:00:00 | SPY | ETF | 112.85 | 112.94 | 112.85 | 112.88 | 750200.0 |
| 2004-10-11 14:30:00 | SPY | ETF | 112.91 | 112.98 | 112.84 | 112.86 | 850700.0 |
| 2004-10-11 15:00:00 | SPY | ETF | 112.85 | 113.02 | 112.79 | 112.8 | 1873200.0 |
| 2004-10-11 15:30:00 | SPY | ETF | 112.8 | 112.87 | 112.74 | 112.87 | 2036400.0 |
| 2004-10-11 16:00:00 | SPY | ETF | 112.86 | 112.99 | 112.84 | 112.96 | 884200.0 |
| 2004-10-11 16:30:00 | SPY | ETF | 112.96 | 112.97 | 112.91 | 112.95 | 134300.0 |
| 2004-10-11 17:00:00 | SPY | ETF | 112.95 | 112.95 | 112.9 | 112.9 | 23000.0 |
| 2004-10-11 17:30:00 | SPY | ETF | 112.92 | 112.95 | 112.92 | 112.95 | 500.0 |
| 2004-10-11 18:00:00 | SPY | ETF | 112.92 | 112.93 | 112.9 | 112.9 | 1900.0 |
| 2004-10-11 19:00:00 | SPY | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 2500.0 |
| 2004-10-11 19:30:00 | SPY | ETF | 112.95 | 112.95 | 112.95 | 112.95 | 100.0 |
| 2004-10-11 08:00:00 | QQQ | ETF | 35.66 | 35.66 | 35.62 | 35.62 | 35700.0 |
| 2004-10-11 08:30:00 | QQQ | ETF | 35.61 | 35.63 | 35.61 | 35.62 | 15300.0 |
| 2004-10-11 09:00:00 | QQQ | ETF | 35.61 | 35.72 | 35.61 | 35.72 | 138000.0 |
| 2004-10-11 09:30:00 | QQQ | ETF | 35.718 | 35.81 | 35.64 | 35.68 | 10636600.0 |
| 2004-10-11 10:00:00 | QQQ | ETF | 35.68 | 35.69 | 35.61 | 35.684 | 4810600.0 |
| 2004-10-11 10:30:00 | QQQ | ETF | 35.69 | 35.7 | 35.62 | 35.667 | 3210500.0 |
| 2004-10-11 11:00:00 | QQQ | ETF | 35.66 | 35.735 | 35.65 | 35.67 | 2855000.0 |
| 2004-10-11 11:30:00 | QQQ | ETF | 35.67 | 35.68 | 35.6 | 35.65 | 3002100.0 |
| 2004-10-11 12:00:00 | QQQ | ETF | 35.65 | 35.72 | 35.64 | 35.66 | 1967300.0 |
| 2004-10-11 12:30:00 | QQQ | ETF | 35.67 | 35.73 | 35.65 | 35.707 | 1497800.0 |
| 2004-10-11 13:00:00 | QQQ | ETF | 35.7 | 35.71 | 35.64 | 35.68 | 1343900.0 |
| 2004-10-11 13:30:00 | QQQ | ETF | 35.67 | 35.74 | 35.6408 | 35.72 | 2596700.0 |
| 2004-10-11 14:00:00 | QQQ | ETF | 35.72 | 35.76 | 35.7 | 35.72 | 3113900.0 |
| 2004-10-11 14:30:00 | QQQ | ETF | 35.72 | 35.78 | 35.72 | 35.74 | 2860100.0 |
| 2004-10-11 15:00:00 | QQQ | ETF | 35.74 | 35.86 | 35.72 | 35.73 | 6397500.0 |
| 2004-10-11 15:30:00 | QQQ | ETF | 35.73 | 35.77 | 35.71 | 35.75 | 4714500.0 |
| 2004-10-11 16:00:00 | QQQ | ETF | 35.74 | 35.79 | 35.72 | 35.768 | 992800.0 |
| 2004-10-11 16:30:00 | QQQ | ETF | 35.77 | 35.775 | 35.75 | 35.75 | 37700.0 |
| 2004-10-11 17:00:00 | QQQ | ETF | 35.76 | 35.76 | 35.73 | 35.73 | 23700.0 |
| 2004-10-11 17:30:00 | QQQ | ETF | 35.75 | 35.75 | 35.75 | 35.75 | 2600.0 |
| 2004-10-11 18:00:00 | QQQ | ETF | 35.75 | 35.76 | 35.74 | 35.75 | 14400.0 |
| 2004-10-11 18:30:00 | QQQ | ETF | 35.75 | 35.75 | 35.75 | 35.75 | 800.0 |
| 2004-10-11 19:30:00 | QQQ | ETF | 35.77 | 35.77 | 35.77 | 35.77 | 500.0 |
| 2004-10-11 08:30:00 | IWM | ETF | 57.335 | 57.335 | 57.335 | 57.335 | 1000.0 |
| 2004-10-11 09:00:00 | IWM | ETF | 57.45 | 57.45 | 57.45 | 57.45 | 1800.0 |
| 2004-10-11 09:30:00 | IWM | ETF | 57.495 | 57.57 | 57.31 | 57.31 | 1395600.0 |
| 2004-10-11 10:00:00 | IWM | ETF | 57.32 | 57.33 | 57.205 | 57.31 | 1576000.0 |
> showing 50 of 1,159 rows — these rows as CSV