PREVIEW / etf_30min / 2005-08-04
file: by_date/etf_30min/2005/2005-08-04.parquet size: 45 KB rows: 1,622
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-04 07:00:00 | SPY | ETF | 124.42 | 124.42 | 124.4 | 124.41 | 6400.0 |
| 2005-08-04 07:30:00 | SPY | ETF | 124.35 | 124.35 | 124.32 | 124.32 | 93900.0 |
| 2005-08-04 08:00:00 | SPY | ETF | 124.37 | 124.4 | 124.24 | 124.24 | 1330800.0 |
| 2005-08-04 08:30:00 | SPY | ETF | 124.25 | 124.31 | 124.2 | 124.23 | 962800.0 |
| 2005-08-04 09:00:00 | SPY | ETF | 124.24 | 124.24 | 124.14 | 124.2 | 491500.0 |
| 2005-08-04 09:30:00 | SPY | ETF | 124.23 | 124.29 | 124.01 | 124.04 | 5569700.0 |
| 2005-08-04 10:00:00 | SPY | ETF | 124.03 | 124.2 | 123.97 | 124.16 | 4962300.0 |
| 2005-08-04 10:30:00 | SPY | ETF | 124.16 | 124.23 | 124.08 | 124.17 | 1297000.0 |
| 2005-08-04 11:00:00 | SPY | ETF | 124.17 | 124.31 | 124.17 | 124.24 | 3311100.0 |
| 2005-08-04 11:30:00 | SPY | ETF | 124.23 | 124.24 | 123.81 | 123.83 | 4384000.0 |
| 2005-08-04 12:00:00 | SPY | ETF | 123.83 | 123.9 | 123.66 | 123.76 | 6972400.0 |
| 2005-08-04 12:30:00 | SPY | ETF | 123.78 | 123.87 | 123.71 | 123.74 | 1869800.0 |
| 2005-08-04 13:00:00 | SPY | ETF | 123.75 | 123.84 | 123.63 | 123.73 | 1945900.0 |
| 2005-08-04 13:30:00 | SPY | ETF | 123.73 | 123.79 | 123.6 | 123.77 | 1686100.0 |
| 2005-08-04 14:00:00 | SPY | ETF | 123.77 | 123.9 | 123.61 | 123.81 | 2412200.0 |
| 2005-08-04 14:30:00 | SPY | ETF | 123.8 | 123.92 | 123.71 | 123.8 | 1596900.0 |
| 2005-08-04 15:00:00 | SPY | ETF | 123.79 | 123.96 | 123.72 | 123.93 | 2004700.0 |
| 2005-08-04 15:30:00 | SPY | ETF | 123.93 | 123.95 | 123.63 | 123.66 | 6681200.0 |
| 2005-08-04 16:00:00 | SPY | ETF | 123.68 | 123.77 | 123.57 | 123.74 | 1201800.0 |
| 2005-08-04 16:30:00 | SPY | ETF | 123.74 | 123.76 | 123.72 | 123.75 | 159100.0 |
| 2005-08-04 17:00:00 | SPY | ETF | 123.75 | 123.78 | 123.72 | 123.72 | 19100.0 |
| 2005-08-04 17:30:00 | SPY | ETF | 123.73 | 123.73 | 123.73 | 123.73 | 400.0 |
| 2005-08-04 18:30:00 | SPY | ETF | 123.7 | 123.78 | 123.7 | 123.78 | 3700.0 |
| 2005-08-04 09:30:00 | QQQ | ETF | 39.89 | 39.93 | 39.83 | 39.85 | 9649600.0 |
| 2005-08-04 10:00:00 | QQQ | ETF | 39.85 | 39.9 | 39.81 | 39.9 | 5401400.0 |
| 2005-08-04 10:30:00 | QQQ | ETF | 39.9 | 39.92 | 39.86 | 39.89 | 3569200.0 |
| 2005-08-04 11:00:00 | QQQ | ETF | 39.89 | 39.94 | 39.88 | 39.88 | 3624800.0 |
| 2005-08-04 11:30:00 | QQQ | ETF | 39.88 | 39.89 | 39.7 | 39.7 | 7780800.0 |
| 2005-08-04 12:00:00 | QQQ | ETF | 39.7 | 39.7 | 39.6 | 39.65 | 6180400.0 |
| 2005-08-04 12:30:00 | QQQ | ETF | 39.64 | 39.7 | 39.64 | 39.65 | 3486400.0 |
| 2005-08-04 13:00:00 | QQQ | ETF | 39.65 | 39.69 | 39.6 | 39.62 | 3494700.0 |
| 2005-08-04 13:30:00 | QQQ | ETF | 39.62 | 39.67 | 39.57 | 39.66 | 3658500.0 |
| 2005-08-04 14:00:00 | QQQ | ETF | 39.65 | 40.1 | 39.64 | 39.68 | 4297200.0 |
| 2005-08-04 14:30:00 | QQQ | ETF | 39.68 | 39.71 | 39.65 | 39.66 | 2725800.0 |
| 2005-08-04 15:00:00 | QQQ | ETF | 39.67 | 39.72 | 39.64 | 39.72 | 4079000.0 |
| 2005-08-04 15:30:00 | QQQ | ETF | 39.71 | 39.72 | 39.6 | 39.67 | 7054400.0 |
| 2005-08-04 07:30:00 | IWM | ETF | 67.79 | 67.79 | 67.71 | 67.76 | 63700.0 |
| 2005-08-04 08:00:00 | IWM | ETF | 67.76 | 67.76 | 67.7 | 67.7 | 19300.0 |
| 2005-08-04 08:30:00 | IWM | ETF | 67.74 | 67.78 | 67.7 | 67.7 | 116100.0 |
| 2005-08-04 09:00:00 | IWM | ETF | 67.66 | 67.69 | 67.53 | 67.58 | 110400.0 |
| 2005-08-04 09:30:00 | IWM | ETF | 67.56 | 67.8 | 67.35 | 67.37 | 1989200.0 |
| 2005-08-04 10:00:00 | IWM | ETF | 67.36 | 67.39 | 67.28 | 67.37 | 1309300.0 |
| 2005-08-04 10:30:00 | IWM | ETF | 67.37 | 67.39 | 67.24 | 67.34 | 1804200.0 |
| 2005-08-04 11:00:00 | IWM | ETF | 67.35 | 67.46 | 67.31 | 67.41 | 2104500.0 |
| 2005-08-04 11:30:00 | IWM | ETF | 67.4 | 67.4 | 67.07 | 67.09 | 2022700.0 |
| 2005-08-04 12:00:00 | IWM | ETF | 67.08 | 67.09 | 66.96 | 67.04 | 1148400.0 |
| 2005-08-04 12:30:00 | IWM | ETF | 67.05 | 67.13 | 67.01 | 67.02 | 969100.0 |
| 2005-08-04 13:00:00 | IWM | ETF | 67.02 | 67.1 | 67.01 | 67.04 | 464500.0 |
| 2005-08-04 13:30:00 | IWM | ETF | 67.03 | 67.08 | 66.92 | 67.0 | 1070100.0 |
| 2005-08-04 14:00:00 | IWM | ETF | 66.99 | 67.09 | 66.98 | 67.05 | 874000.0 |
> showing 50 of 1,622 rows — these rows as CSV