PREVIEW / etf_30min / 2004-01-08
file: by_date/etf_30min/2004/2004-01-08.parquet size: 34 KB rows: 1,162
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-01-08 08:00:00 | SPY | ETF | 112.9 | 113.26 | 112.9 | 113.24 | 20200.0 |
| 2004-01-08 08:30:00 | SPY | ETF | 113.24 | 113.42 | 113.2 | 113.36 | 135600.0 |
| 2004-01-08 09:00:00 | SPY | ETF | 113.34 | 113.36 | 113.27 | 113.28 | 19300.0 |
| 2004-01-08 09:30:00 | SPY | ETF | 113.28 | 113.34 | 112.89 | 113.08 | 6371500.0 |
| 2004-01-08 10:00:00 | SPY | ETF | 113.07 | 113.17 | 112.77 | 112.83 | 4043700.0 |
| 2004-01-08 10:30:00 | SPY | ETF | 112.8 | 113.12 | 112.8 | 112.99 | 2486200.0 |
| 2004-01-08 11:00:00 | SPY | ETF | 112.99 | 113.04 | 112.84 | 113.0 | 1853700.0 |
| 2004-01-08 11:30:00 | SPY | ETF | 112.99 | 113.2 | 112.91 | 113.08 | 1424500.0 |
| 2004-01-08 12:00:00 | SPY | ETF | 113.08 | 113.16 | 112.97 | 113.13 | 811300.0 |
| 2004-01-08 12:30:00 | SPY | ETF | 113.1 | 113.19 | 113.01 | 113.19 | 645700.0 |
| 2004-01-08 13:00:00 | SPY | ETF | 113.16 | 113.19 | 112.91 | 113.15 | 1465100.0 |
| 2004-01-08 13:30:00 | SPY | ETF | 113.16 | 113.3 | 113.07 | 113.23 | 1578700.0 |
| 2004-01-08 14:00:00 | SPY | ETF | 113.23 | 113.31 | 112.97 | 113.0 | 3620900.0 |
| 2004-01-08 14:30:00 | SPY | ETF | 112.99 | 113.27 | 112.91 | 113.21 | 2097500.0 |
| 2004-01-08 15:00:00 | SPY | ETF | 113.23 | 113.4 | 113.13 | 113.4 | 2541400.0 |
| 2004-01-08 15:30:00 | SPY | ETF | 113.4 | 113.41 | 113.19 | 113.32 | 3095300.0 |
| 2004-01-08 16:00:00 | SPY | ETF | 113.32 | 113.48 | 113.24 | 113.33 | 2734100.0 |
| 2004-01-08 16:30:00 | SPY | ETF | 113.329 | 113.38 | 113.22 | 113.38 | 429400.0 |
| 2004-01-08 17:00:00 | SPY | ETF | 113.38 | 113.39 | 113.35 | 113.38 | 57600.0 |
| 2004-01-08 17:30:00 | SPY | ETF | 113.39 | 113.45 | 113.38 | 113.41 | 6000.0 |
| 2004-01-08 18:00:00 | SPY | ETF | 113.41 | 113.41 | 113.4 | 113.4 | 1400.0 |
| 2004-01-08 18:30:00 | SPY | ETF | 113.4 | 113.43 | 113.4 | 113.41 | 6000.0 |
| 2004-01-08 19:00:00 | SPY | ETF | 113.43 | 113.43 | 113.43 | 113.43 | 500.0 |
| 2004-01-08 19:30:00 | SPY | ETF | 113.4 | 113.4 | 113.38 | 113.38 | 1300.0 |
| 2004-01-08 08:00:00 | QQQ | ETF | 37.68 | 37.9 | 37.68 | 37.88 | 305900.0 |
| 2004-01-08 08:30:00 | QQQ | ETF | 37.86 | 37.96 | 37.86 | 37.91 | 148400.0 |
| 2004-01-08 09:00:00 | QQQ | ETF | 37.92 | 37.93 | 37.86 | 37.87 | 93400.0 |
| 2004-01-08 09:30:00 | QQQ | ETF | 37.85 | 37.93 | 37.68 | 37.781 | 13607700.0 |
| 2004-01-08 10:00:00 | QQQ | ETF | 37.8 | 37.84 | 37.6 | 37.66 | 6909400.0 |
| 2004-01-08 10:30:00 | QQQ | ETF | 37.66 | 37.79 | 37.65 | 37.72 | 5383300.0 |
| 2004-01-08 11:00:00 | QQQ | ETF | 37.73 | 37.771 | 37.65 | 37.75 | 2913600.0 |
| 2004-01-08 11:30:00 | QQQ | ETF | 37.749 | 37.87 | 37.709 | 37.8 | 4733700.0 |
| 2004-01-08 12:00:00 | QQQ | ETF | 37.81 | 37.9 | 37.78 | 37.857 | 2749200.0 |
| 2004-01-08 12:30:00 | QQQ | ETF | 37.857 | 37.89 | 37.818 | 37.87 | 2400300.0 |
| 2004-01-08 13:00:00 | QQQ | ETF | 37.87 | 37.9 | 37.75 | 37.886 | 3763500.0 |
| 2004-01-08 13:30:00 | QQQ | ETF | 37.89 | 37.97 | 37.85 | 37.94 | 6664000.0 |
| 2004-01-08 14:00:00 | QQQ | ETF | 37.933 | 37.97 | 37.81 | 37.84 | 2936100.0 |
| 2004-01-08 14:30:00 | QQQ | ETF | 37.83 | 37.95 | 37.762 | 37.922 | 4020800.0 |
| 2004-01-08 15:00:00 | QQQ | ETF | 37.93 | 37.961 | 37.84 | 37.95 | 5134700.0 |
| 2004-01-08 15:30:00 | QQQ | ETF | 37.96 | 37.98 | 37.88 | 37.94 | 6221300.0 |
| 2004-01-08 16:00:00 | QQQ | ETF | 37.95 | 38.0 | 37.91 | 37.99 | 3523900.0 |
| 2004-01-08 16:30:00 | QQQ | ETF | 37.97 | 38.0 | 37.92 | 37.98 | 1614400.0 |
| 2004-01-08 17:00:00 | QQQ | ETF | 37.98 | 38.0 | 37.7 | 38.0 | 356700.0 |
| 2004-01-08 17:30:00 | QQQ | ETF | 38.0 | 38.04 | 38.0 | 38.01 | 89700.0 |
| 2004-01-08 18:00:00 | QQQ | ETF | 38.0 | 38.02 | 38.0 | 38.0 | 21200.0 |
| 2004-01-08 18:30:00 | QQQ | ETF | 37.99 | 37.99 | 37.99 | 37.99 | 5700.0 |
| 2004-01-08 19:00:00 | QQQ | ETF | 38.01 | 38.01 | 38.0 | 38.0 | 1600.0 |
| 2004-01-08 19:30:00 | QQQ | ETF | 38.0 | 38.02 | 38.0 | 38.0 | 6600.0 |
| 2004-01-08 09:00:00 | IWM | ETF | 57.46 | 57.46 | 57.46 | 57.46 | 1000.0 |
| 2004-01-08 09:30:00 | IWM | ETF | 57.64 | 57.6415 | 57.29 | 57.44 | 1316200.0 |
> showing 50 of 1,162 rows — these rows as CSV