PREVIEW / etf_30min / 2004-10-13
file: by_date/etf_30min/2004/2004-10-13.parquet size: 37 KB rows: 1,212
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-13 08:00:00 | SPY | ETF | 112.97 | 113.05 | 112.93 | 113.0 | 127100.0 |
| 2004-10-13 08:30:00 | SPY | ETF | 113.0 | 113.09 | 113.0 | 113.09 | 150900.0 |
| 2004-10-13 09:00:00 | SPY | ETF | 113.08 | 113.11 | 113.0 | 113.0 | 160000.0 |
| 2004-10-13 09:30:00 | SPY | ETF | 113.0 | 113.07 | 112.74 | 112.86 | 6995200.0 |
| 2004-10-13 10:00:00 | SPY | ETF | 112.83 | 112.85 | 112.35 | 112.39 | 5370300.0 |
| 2004-10-13 10:30:00 | SPY | ETF | 112.39 | 112.45 | 112.24 | 112.3 | 3914400.0 |
| 2004-10-13 11:00:00 | SPY | ETF | 112.3 | 112.34 | 112.05 | 112.21 | 4126200.0 |
| 2004-10-13 11:30:00 | SPY | ETF | 112.2 | 112.27 | 112.06 | 112.19 | 3164600.0 |
| 2004-10-13 12:00:00 | SPY | ETF | 112.19 | 112.25 | 112.06 | 112.21 | 1470900.0 |
| 2004-10-13 12:30:00 | SPY | ETF | 112.22 | 112.33 | 112.12 | 112.22 | 1451600.0 |
| 2004-10-13 13:00:00 | SPY | ETF | 112.22 | 112.27 | 111.69 | 111.69 | 3255300.0 |
| 2004-10-13 13:30:00 | SPY | ETF | 111.69 | 111.83 | 111.32 | 111.47 | 7183800.0 |
| 2004-10-13 14:00:00 | SPY | ETF | 111.47 | 111.62 | 111.39 | 111.47 | 4306600.0 |
| 2004-10-13 14:30:00 | SPY | ETF | 111.47 | 111.71 | 111.44 | 111.59 | 2171000.0 |
| 2004-10-13 15:00:00 | SPY | ETF | 111.6 | 111.75 | 111.42 | 111.5 | 2541400.0 |
| 2004-10-13 15:30:00 | SPY | ETF | 111.49 | 111.83 | 111.48 | 111.67 | 3955700.0 |
| 2004-10-13 16:00:00 | SPY | ETF | 111.68 | 111.74 | 111.41 | 111.52 | 1642600.0 |
| 2004-10-13 16:30:00 | SPY | ETF | 111.49 | 111.66 | 111.49 | 111.49 | 301700.0 |
| 2004-10-13 17:00:00 | SPY | ETF | 111.51 | 111.51 | 111.4 | 111.46 | 144400.0 |
| 2004-10-13 17:30:00 | SPY | ETF | 111.4 | 111.42 | 111.4 | 111.42 | 29100.0 |
| 2004-10-13 18:00:00 | SPY | ETF | 111.42 | 111.47 | 111.41 | 111.41 | 38400.0 |
| 2004-10-13 18:30:00 | SPY | ETF | 111.37 | 111.37 | 111.37 | 111.37 | 100.0 |
| 2004-10-13 19:00:00 | SPY | ETF | 111.44 | 111.44 | 111.44 | 111.44 | 500.0 |
| 2004-10-13 19:30:00 | SPY | ETF | 111.41 | 111.41 | 111.41 | 111.41 | 1000.0 |
| 2004-10-13 08:00:00 | QQQ | ETF | 36.01 | 36.06 | 35.99 | 36.04 | 266600.0 |
| 2004-10-13 08:30:00 | QQQ | ETF | 36.04 | 36.07 | 36.02 | 36.06 | 266800.0 |
| 2004-10-13 09:00:00 | QQQ | ETF | 36.07 | 36.07 | 36.04 | 36.05 | 556600.0 |
| 2004-10-13 09:30:00 | QQQ | ETF | 36.05 | 36.14 | 35.98 | 36.051 | 15738500.0 |
| 2004-10-13 10:00:00 | QQQ | ETF | 36.051 | 36.09 | 35.79 | 35.805 | 14524300.0 |
| 2004-10-13 10:30:00 | QQQ | ETF | 35.81 | 35.97 | 35.78 | 35.87 | 10357400.0 |
| 2004-10-13 11:00:00 | QQQ | ETF | 35.88 | 35.91 | 35.76 | 35.91 | 8728600.0 |
| 2004-10-13 11:30:00 | QQQ | ETF | 35.903 | 35.93 | 35.806 | 35.861 | 4994100.0 |
| 2004-10-13 12:00:00 | QQQ | ETF | 35.86 | 35.874 | 35.78 | 35.83 | 5396700.0 |
| 2004-10-13 12:30:00 | QQQ | ETF | 35.827 | 35.88 | 35.81 | 35.86 | 3214000.0 |
| 2004-10-13 13:00:00 | QQQ | ETF | 35.851 | 35.88 | 35.62 | 35.62 | 6514400.0 |
| 2004-10-13 13:30:00 | QQQ | ETF | 35.62 | 35.68 | 35.43 | 35.525 | 18195700.0 |
| 2004-10-13 14:00:00 | QQQ | ETF | 35.51 | 35.59 | 35.45 | 35.504 | 7877700.0 |
| 2004-10-13 14:30:00 | QQQ | ETF | 35.5 | 35.66 | 35.5 | 35.574 | 9482200.0 |
| 2004-10-13 15:00:00 | QQQ | ETF | 35.577 | 35.65 | 35.53 | 35.575 | 7894400.0 |
| 2004-10-13 15:30:00 | QQQ | ETF | 35.576 | 35.68 | 35.55 | 35.66 | 9453200.0 |
| 2004-10-13 16:00:00 | QQQ | ETF | 35.66 | 35.7 | 35.58 | 35.58 | 3992000.0 |
| 2004-10-13 16:30:00 | QQQ | ETF | 35.588 | 35.67 | 35.56 | 35.59 | 975300.0 |
| 2004-10-13 17:00:00 | QQQ | ETF | 35.58 | 35.59 | 35.51 | 35.52 | 166800.0 |
| 2004-10-13 17:30:00 | QQQ | ETF | 35.52 | 35.56 | 35.51 | 35.55 | 204700.0 |
| 2004-10-13 18:00:00 | QQQ | ETF | 35.525 | 35.54 | 35.5 | 35.51 | 32400.0 |
| 2004-10-13 18:30:00 | QQQ | ETF | 35.51 | 35.52 | 35.49 | 35.52 | 12800.0 |
| 2004-10-13 19:00:00 | QQQ | ETF | 35.51 | 35.51 | 35.51 | 35.51 | 6200.0 |
| 2004-10-13 19:30:00 | QQQ | ETF | 35.53 | 35.53 | 35.5 | 35.52 | 6700.0 |
| 2004-10-13 08:30:00 | IWM | ETF | 57.865 | 57.925 | 57.865 | 57.87 | 20000.0 |
| 2004-10-13 09:00:00 | IWM | ETF | 57.87 | 57.895 | 57.85 | 57.87 | 14600.0 |
> showing 50 of 1,212 rows — these rows as CSV