PREVIEW / etf_30min / 2004-12-23
file: by_date/etf_30min/2004/2004-12-23.parquet size: 37 KB rows: 1,348
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-12-23 08:00:00 | SPY | ETF | 120.79 | 120.83 | 120.78 | 120.82 | 66200.0 |
| 2004-12-23 08:30:00 | SPY | ETF | 120.82 | 120.97 | 120.77 | 120.89 | 95900.0 |
| 2004-12-23 09:00:00 | SPY | ETF | 120.91 | 120.94 | 120.85 | 120.87 | 9800.0 |
| 2004-12-23 09:30:00 | SPY | ETF | 120.87 | 121.09 | 120.83 | 120.98 | 3239900.0 |
| 2004-12-23 10:00:00 | SPY | ETF | 120.98 | 121.24 | 120.86 | 121.17 | 3429000.0 |
| 2004-12-23 10:30:00 | SPY | ETF | 121.16 | 121.28 | 121.01 | 121.1 | 2509600.0 |
| 2004-12-23 11:00:00 | SPY | ETF | 121.11 | 121.22 | 121.04 | 121.1 | 1375600.0 |
| 2004-12-23 11:30:00 | SPY | ETF | 121.1 | 121.14 | 121.05 | 121.06 | 2139400.0 |
| 2004-12-23 12:00:00 | SPY | ETF | 121.05 | 121.1 | 120.93 | 121.0 | 1964100.0 |
| 2004-12-23 12:30:00 | SPY | ETF | 121.0 | 121.05 | 120.92 | 120.96 | 691400.0 |
| 2004-12-23 13:00:00 | SPY | ETF | 120.95 | 121.01 | 120.87 | 120.99 | 1063900.0 |
| 2004-12-23 13:30:00 | SPY | ETF | 120.99 | 121.1 | 120.98 | 121.01 | 1338900.0 |
| 2004-12-23 14:00:00 | SPY | ETF | 121.01 | 121.1 | 120.92 | 120.95 | 1222600.0 |
| 2004-12-23 14:30:00 | SPY | ETF | 120.95 | 120.99 | 120.81 | 120.9 | 2146600.0 |
| 2004-12-23 15:00:00 | SPY | ETF | 120.89 | 121.04 | 120.82 | 120.85 | 1401400.0 |
| 2004-12-23 15:30:00 | SPY | ETF | 120.85 | 121.04 | 120.84 | 120.99 | 1499800.0 |
| 2004-12-23 16:00:00 | SPY | ETF | 121.0 | 121.02 | 120.66 | 120.84 | 1119500.0 |
| 2004-12-23 16:30:00 | SPY | ETF | 120.84 | 120.84 | 120.8 | 120.8 | 5800.0 |
| 2004-12-23 17:00:00 | SPY | ETF | 120.81 | 120.83 | 120.8 | 120.83 | 1600.0 |
| 2004-12-23 18:00:00 | SPY | ETF | 120.83 | 120.83 | 120.83 | 120.83 | 800.0 |
| 2004-12-23 08:00:00 | QQQ | ETF | 39.62 | 39.66 | 39.62 | 39.65 | 198800.0 |
| 2004-12-23 08:30:00 | QQQ | ETF | 39.657 | 39.691 | 39.6 | 39.68 | 180409.0 |
| 2004-12-23 09:00:00 | QQQ | ETF | 39.69 | 39.72 | 39.596 | 39.62 | 176255.0 |
| 2004-12-23 09:30:00 | QQQ | ETF | 39.61 | 39.77 | 39.54 | 39.73 | 6180791.0 |
| 2004-12-23 10:00:00 | QQQ | ETF | 39.728 | 39.821 | 39.67 | 39.803 | 5893525.0 |
| 2004-12-23 10:30:00 | QQQ | ETF | 39.81 | 39.862 | 39.74 | 39.82 | 6902916.0 |
| 2004-12-23 11:00:00 | QQQ | ETF | 39.82 | 39.9 | 39.81 | 39.83 | 3854862.0 |
| 2004-12-23 11:30:00 | QQQ | ETF | 39.83 | 39.84 | 39.779 | 39.8 | 2765272.0 |
| 2004-12-23 12:00:00 | QQQ | ETF | 39.8 | 39.821 | 39.77 | 39.808 | 1766701.0 |
| 2004-12-23 12:30:00 | QQQ | ETF | 39.8 | 39.83 | 39.77 | 39.79 | 1391798.0 |
| 2004-12-23 13:00:00 | QQQ | ETF | 39.78 | 39.81 | 39.735 | 39.8 | 2308529.0 |
| 2004-12-23 13:30:00 | QQQ | ETF | 39.8 | 39.83 | 39.79 | 39.8 | 1060528.0 |
| 2004-12-23 14:00:00 | QQQ | ETF | 39.804 | 39.828 | 39.76 | 39.77 | 1753598.0 |
| 2004-12-23 14:30:00 | QQQ | ETF | 39.77 | 39.78 | 39.72 | 39.74 | 2413541.0 |
| 2004-12-23 15:00:00 | QQQ | ETF | 39.74 | 39.78 | 39.73 | 39.75 | 2230466.0 |
| 2004-12-23 15:30:00 | QQQ | ETF | 39.74 | 39.81 | 39.74 | 39.781 | 3801366.0 |
| 2004-12-23 16:00:00 | QQQ | ETF | 39.78 | 39.8 | 39.65 | 39.74 | 1471713.0 |
| 2004-12-23 16:30:00 | QQQ | ETF | 39.74 | 39.75 | 39.73 | 39.75 | 39969.0 |
| 2004-12-23 17:00:00 | QQQ | ETF | 39.75 | 39.76 | 39.74 | 39.74 | 23200.0 |
| 2004-12-23 17:30:00 | QQQ | ETF | 39.75 | 39.75 | 39.74 | 39.74 | 31000.0 |
| 2004-12-23 18:00:00 | QQQ | ETF | 39.74 | 39.75 | 39.74 | 39.75 | 3300.0 |
| 2004-12-23 08:30:00 | IWM | ETF | 64.59 | 64.59 | 64.55 | 64.55 | 16000.0 |
| 2004-12-23 09:00:00 | IWM | ETF | 64.56 | 64.575 | 64.505 | 64.535 | 6400.0 |
| 2004-12-23 09:30:00 | IWM | ETF | 64.575 | 64.695 | 64.535 | 64.63 | 581800.0 |
| 2004-12-23 10:00:00 | IWM | ETF | 64.625 | 64.755 | 64.54 | 64.74 | 1328600.0 |
| 2004-12-23 10:30:00 | IWM | ETF | 64.725 | 64.8 | 64.725 | 64.76 | 611800.0 |
| 2004-12-23 11:00:00 | IWM | ETF | 64.755 | 64.85 | 64.7 | 64.725 | 979000.0 |
| 2004-12-23 11:30:00 | IWM | ETF | 64.72 | 64.73 | 64.6299 | 64.665 | 646400.0 |
| 2004-12-23 12:00:00 | IWM | ETF | 64.66 | 64.71 | 64.645 | 64.67 | 261600.0 |
| 2004-12-23 12:30:00 | IWM | ETF | 64.685 | 64.695 | 64.61 | 64.63 | 455600.0 |
> showing 50 of 1,348 rows — these rows as CSV