PREVIEW / etf_30min / 2004-10-25
file: by_date/etf_30min/2004/2004-10-25.parquet size: 37 KB rows: 1,282
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-25 08:00:00 | SPY | ETF | 109.58 | 109.59 | 109.48 | 109.54 | 38600.0 |
| 2004-10-25 08:30:00 | SPY | ETF | 109.57 | 109.67 | 109.57 | 109.66 | 71200.0 |
| 2004-10-25 09:00:00 | SPY | ETF | 109.71 | 109.75 | 109.65 | 109.74 | 269400.0 |
| 2004-10-25 09:30:00 | SPY | ETF | 109.75 | 109.8 | 109.43 | 109.47 | 6586100.0 |
| 2004-10-25 10:00:00 | SPY | ETF | 109.48 | 109.89 | 109.35 | 109.87 | 4328500.0 |
| 2004-10-25 10:30:00 | SPY | ETF | 109.89 | 109.89 | 109.53 | 109.81 | 3510300.0 |
| 2004-10-25 11:00:00 | SPY | ETF | 109.79 | 109.82 | 109.47 | 109.78 | 2363500.0 |
| 2004-10-25 11:30:00 | SPY | ETF | 109.78 | 109.8 | 109.48 | 109.56 | 1876500.0 |
| 2004-10-25 12:00:00 | SPY | ETF | 109.55 | 109.7 | 109.43 | 109.66 | 2202100.0 |
| 2004-10-25 12:30:00 | SPY | ETF | 109.66 | 109.75 | 109.45 | 109.74 | 1725800.0 |
| 2004-10-25 13:00:00 | SPY | ETF | 109.74 | 110.12 | 109.7 | 109.92 | 3861600.0 |
| 2004-10-25 13:30:00 | SPY | ETF | 109.93 | 109.98 | 109.8 | 109.94 | 1443200.0 |
| 2004-10-25 14:00:00 | SPY | ETF | 109.95 | 110.07 | 109.73 | 109.87 | 2151000.0 |
| 2004-10-25 14:30:00 | SPY | ETF | 109.86 | 110.07 | 109.77 | 109.8 | 2521500.0 |
| 2004-10-25 15:00:00 | SPY | ETF | 109.8 | 110.01 | 109.72 | 109.87 | 3139000.0 |
| 2004-10-25 15:30:00 | SPY | ETF | 109.88 | 110.12 | 109.84 | 109.87 | 3607200.0 |
| 2004-10-25 16:00:00 | SPY | ETF | 109.87 | 109.95 | 109.81 | 109.94 | 1714000.0 |
| 2004-10-25 16:30:00 | SPY | ETF | 109.95 | 110.21 | 109.95 | 110.14 | 598000.0 |
| 2004-10-25 17:00:00 | SPY | ETF | 110.14 | 110.18 | 110.09 | 110.15 | 181400.0 |
| 2004-10-25 17:30:00 | SPY | ETF | 110.11 | 110.14 | 110.0 | 110.01 | 44100.0 |
| 2004-10-25 18:00:00 | SPY | ETF | 110.09 | 110.15 | 110.09 | 110.15 | 6000.0 |
| 2004-10-25 18:30:00 | SPY | ETF | 110.13 | 110.19 | 110.13 | 110.19 | 500.0 |
| 2004-10-25 19:00:00 | SPY | ETF | 110.19 | 110.19 | 110.19 | 110.19 | 1300.0 |
| 2004-10-25 19:30:00 | SPY | ETF | 110.14 | 110.14 | 110.14 | 110.14 | 100.0 |
| 2004-10-25 08:00:00 | QQQ | ETF | 35.75 | 35.75 | 35.61 | 35.65 | 102500.0 |
| 2004-10-25 08:30:00 | QQQ | ETF | 35.64 | 35.73 | 35.64 | 35.72 | 198000.0 |
| 2004-10-25 09:00:00 | QQQ | ETF | 35.72 | 35.75 | 35.7 | 35.74 | 160300.0 |
| 2004-10-25 09:30:00 | QQQ | ETF | 35.73 | 35.787 | 35.57 | 35.6 | 16461200.0 |
| 2004-10-25 10:00:00 | QQQ | ETF | 35.61 | 35.79 | 35.53 | 35.77 | 13001200.0 |
| 2004-10-25 10:30:00 | QQQ | ETF | 35.77 | 35.78 | 35.565 | 35.683 | 11970000.0 |
| 2004-10-25 11:00:00 | QQQ | ETF | 35.67 | 35.7 | 35.51 | 35.63 | 9332800.0 |
| 2004-10-25 11:30:00 | QQQ | ETF | 35.64 | 35.67 | 35.51 | 35.58 | 4438800.0 |
| 2004-10-25 12:00:00 | QQQ | ETF | 35.574 | 35.61 | 35.49 | 35.595 | 5836500.0 |
| 2004-10-25 12:30:00 | QQQ | ETF | 35.591 | 35.642 | 35.51 | 35.64 | 2836900.0 |
| 2004-10-25 13:00:00 | QQQ | ETF | 35.64 | 35.8 | 35.63 | 35.72 | 6597600.0 |
| 2004-10-25 13:30:00 | QQQ | ETF | 35.72 | 35.74 | 35.66 | 35.71 | 3744200.0 |
| 2004-10-25 14:00:00 | QQQ | ETF | 35.71 | 35.74 | 35.55 | 35.6 | 4722400.0 |
| 2004-10-25 14:30:00 | QQQ | ETF | 35.595 | 35.71 | 35.57 | 35.618 | 6860000.0 |
| 2004-10-25 15:00:00 | QQQ | ETF | 35.61 | 35.68 | 35.57 | 35.631 | 3660300.0 |
| 2004-10-25 15:30:00 | QQQ | ETF | 35.63 | 35.73 | 35.6 | 35.62 | 8457200.0 |
| 2004-10-25 16:00:00 | QQQ | ETF | 35.62 | 35.66 | 35.586 | 35.648 | 2091100.0 |
| 2004-10-25 16:30:00 | QQQ | ETF | 35.64 | 35.7 | 35.63 | 35.65 | 266100.0 |
| 2004-10-25 17:00:00 | QQQ | ETF | 35.68 | 35.68 | 35.646 | 35.65 | 305200.0 |
| 2004-10-25 17:30:00 | QQQ | ETF | 35.68 | 35.68 | 35.642 | 35.65 | 16800.0 |
| 2004-10-25 18:00:00 | QQQ | ETF | 35.65 | 35.66 | 35.62 | 35.62 | 61000.0 |
| 2004-10-25 18:30:00 | QQQ | ETF | 35.66 | 35.66 | 35.66 | 35.66 | 2600.0 |
| 2004-10-25 19:00:00 | QQQ | ETF | 35.66 | 35.66 | 35.66 | 35.66 | 200.0 |
| 2004-10-25 19:30:00 | QQQ | ETF | 35.65 | 35.67 | 35.65 | 35.65 | 28200.0 |
| 2004-10-25 08:00:00 | IWM | ETF | 56.17 | 56.17 | 56.17 | 56.17 | 1400.0 |
| 2004-10-25 08:30:00 | IWM | ETF | 56.14 | 56.14 | 56.14 | 56.14 | 1000.0 |
> showing 50 of 1,282 rows — these rows as CSV