PREVIEW / etf_30min / 2004-07-08
file: by_date/etf_30min/2004/2004-07-08.parquet size: 36 KB rows: 1,188
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-07-08 08:00:00 | SPY | ETF | 111.63 | 111.64 | 111.59 | 111.64 | 39900.0 |
| 2004-07-08 08:30:00 | SPY | ETF | 111.68 | 111.76 | 111.68 | 111.72 | 44600.0 |
| 2004-07-08 09:00:00 | SPY | ETF | 111.73 | 111.84 | 111.73 | 111.82 | 45900.0 |
| 2004-07-08 09:30:00 | SPY | ETF | 111.81 | 112.05 | 111.61 | 111.83 | 4758800.0 |
| 2004-07-08 10:00:00 | SPY | ETF | 111.79 | 112.0 | 111.54 | 111.87 | 4963300.0 |
| 2004-07-08 10:30:00 | SPY | ETF | 111.87 | 112.05 | 111.75 | 111.84 | 2091200.0 |
| 2004-07-08 11:00:00 | SPY | ETF | 111.84 | 112.18 | 111.79 | 112.1 | 3519600.0 |
| 2004-07-08 11:30:00 | SPY | ETF | 112.11 | 112.32 | 112.1 | 112.13 | 1721100.0 |
| 2004-07-08 12:00:00 | SPY | ETF | 112.13 | 112.17 | 112.0 | 112.06 | 1296200.0 |
| 2004-07-08 12:30:00 | SPY | ETF | 112.07 | 112.17 | 111.9 | 111.93 | 1289300.0 |
| 2004-07-08 13:00:00 | SPY | ETF | 111.93 | 111.98 | 111.75 | 111.9 | 1794600.0 |
| 2004-07-08 13:30:00 | SPY | ETF | 111.91 | 111.97 | 111.67 | 111.71 | 1666700.0 |
| 2004-07-08 14:00:00 | SPY | ETF | 111.72 | 111.73 | 111.33 | 111.42 | 6439300.0 |
| 2004-07-08 14:30:00 | SPY | ETF | 111.43 | 111.72 | 111.38 | 111.7 | 2161900.0 |
| 2004-07-08 15:00:00 | SPY | ETF | 111.7 | 111.83 | 111.5 | 111.7 | 2432600.0 |
| 2004-07-08 15:30:00 | SPY | ETF | 111.7 | 111.78 | 111.2 | 111.22 | 3914200.0 |
| 2004-07-08 16:00:00 | SPY | ETF | 111.2 | 111.49 | 111.2 | 111.48 | 1306200.0 |
| 2004-07-08 16:30:00 | SPY | ETF | 111.45 | 111.51 | 111.25 | 111.42 | 371800.0 |
| 2004-07-08 17:00:00 | SPY | ETF | 111.43 | 111.48 | 111.41 | 111.45 | 142100.0 |
| 2004-07-08 17:30:00 | SPY | ETF | 111.5 | 111.54 | 111.45 | 111.5 | 11100.0 |
| 2004-07-08 18:00:00 | SPY | ETF | 111.5 | 111.5 | 111.43 | 111.45 | 48100.0 |
| 2004-07-08 08:00:00 | QQQ | ETF | 35.68 | 35.72 | 35.64 | 35.7 | 95600.0 |
| 2004-07-08 08:30:00 | QQQ | ETF | 35.71 | 35.77 | 35.7 | 35.76 | 187100.0 |
| 2004-07-08 09:00:00 | QQQ | ETF | 35.77 | 35.83 | 35.77 | 35.82 | 497100.0 |
| 2004-07-08 09:30:00 | QQQ | ETF | 35.81 | 35.93 | 35.73 | 35.864 | 15922400.0 |
| 2004-07-08 10:00:00 | QQQ | ETF | 35.864 | 35.965 | 35.78 | 35.869 | 8398000.0 |
| 2004-07-08 10:30:00 | QQQ | ETF | 35.869 | 35.921 | 35.8 | 35.84 | 5250600.0 |
| 2004-07-08 11:00:00 | QQQ | ETF | 35.859 | 36.03 | 35.81 | 36.01 | 8612500.0 |
| 2004-07-08 11:30:00 | QQQ | ETF | 36.018 | 36.13 | 36.01 | 36.02 | 7435300.0 |
| 2004-07-08 12:00:00 | QQQ | ETF | 36.02 | 36.05 | 35.94 | 36.01 | 4386200.0 |
| 2004-07-08 12:30:00 | QQQ | ETF | 36.01 | 36.06 | 35.867 | 35.89 | 4118900.0 |
| 2004-07-08 13:00:00 | QQQ | ETF | 35.89 | 35.93 | 35.83 | 35.9 | 3738800.0 |
| 2004-07-08 13:30:00 | QQQ | ETF | 35.9 | 35.94 | 35.77 | 35.79 | 4144000.0 |
| 2004-07-08 14:00:00 | QQQ | ETF | 35.79 | 35.8 | 35.64 | 35.7185 | 9077700.0 |
| 2004-07-08 14:30:00 | QQQ | ETF | 35.72 | 35.78 | 35.65 | 35.77 | 6107100.0 |
| 2004-07-08 15:00:00 | QQQ | ETF | 35.77 | 35.81 | 35.672 | 35.763 | 6520800.0 |
| 2004-07-08 15:30:00 | QQQ | ETF | 35.76 | 35.8 | 35.55 | 35.57 | 11191000.0 |
| 2004-07-08 16:00:00 | QQQ | ETF | 35.58 | 35.73 | 35.55 | 35.69 | 4067400.0 |
| 2004-07-08 16:30:00 | QQQ | ETF | 35.69 | 35.75 | 35.57 | 35.69 | 726700.0 |
| 2004-07-08 17:00:00 | QQQ | ETF | 35.68 | 35.69 | 35.65 | 35.68 | 869500.0 |
| 2004-07-08 17:30:00 | QQQ | ETF | 35.68 | 35.71 | 35.67 | 35.69 | 80300.0 |
| 2004-07-08 18:00:00 | QQQ | ETF | 35.68 | 35.73 | 35.68 | 35.73 | 60800.0 |
| 2004-07-08 18:30:00 | QQQ | ETF | 35.73 | 35.73 | 35.7 | 35.73 | 6900.0 |
| 2004-07-08 19:00:00 | QQQ | ETF | 35.7 | 35.7 | 35.66 | 35.66 | 5900.0 |
| 2004-07-08 19:30:00 | QQQ | ETF | 35.7 | 35.74 | 35.7 | 35.74 | 5000.0 |
| 2004-07-08 08:30:00 | IWM | ETF | 56.66 | 56.66 | 56.66 | 56.66 | 4600.0 |
| 2004-07-08 09:00:00 | IWM | ETF | 56.71 | 56.725 | 56.705 | 56.725 | 5600.0 |
| 2004-07-08 09:30:00 | IWM | ETF | 56.635 | 56.815 | 56.445 | 56.63 | 1398600.0 |
| 2004-07-08 10:00:00 | IWM | ETF | 56.61 | 56.75 | 56.455 | 56.545 | 895400.0 |
| 2004-07-08 10:30:00 | IWM | ETF | 56.535 | 56.73 | 56.53 | 56.605 | 303800.0 |
> showing 50 of 1,188 rows — these rows as CSV