PREVIEW / etf_30min / 2003-12-18
file: by_date/etf_30min/2003/2003-12-18.parquet size: 29 KB rows: 910
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 |
|---|---|---|---|---|---|---|---|
| 2003-12-18 08:00:00 | SPY | ETF | 108.53 | 108.53 | 108.5 | 108.51 | 15300.0 |
| 2003-12-18 08:30:00 | SPY | ETF | 108.58 | 108.64 | 108.55 | 108.55 | 30800.0 |
| 2003-12-18 09:00:00 | SPY | ETF | 108.56 | 108.56 | 108.53 | 108.53 | 29700.0 |
| 2003-12-18 09:30:00 | SPY | ETF | 108.55 | 108.98 | 108.39 | 108.96 | 3255700.0 |
| 2003-12-18 10:00:00 | SPY | ETF | 108.96 | 109.04 | 108.82 | 108.94 | 2870300.0 |
| 2003-12-18 10:30:00 | SPY | ETF | 108.93 | 109.11 | 108.87 | 109.06 | 2141400.0 |
| 2003-12-18 11:00:00 | SPY | ETF | 109.07 | 109.09 | 108.92 | 108.98 | 1431500.0 |
| 2003-12-18 11:30:00 | SPY | ETF | 108.99 | 109.13 | 108.92 | 109.03 | 982100.0 |
| 2003-12-18 12:00:00 | SPY | ETF | 109.02 | 109.14 | 108.9 | 108.99 | 1290300.0 |
| 2003-12-18 12:30:00 | SPY | ETF | 109.0 | 109.1 | 108.98 | 109.08 | 627100.0 |
| 2003-12-18 13:00:00 | SPY | ETF | 109.07 | 109.23 | 109.06 | 109.13 | 2163100.0 |
| 2003-12-18 13:30:00 | SPY | ETF | 109.13 | 109.22 | 109.09 | 109.13 | 1356700.0 |
| 2003-12-18 14:00:00 | SPY | ETF | 109.13 | 109.36 | 109.1 | 109.32 | 1435000.0 |
| 2003-12-18 14:30:00 | SPY | ETF | 109.32 | 109.63 | 109.3 | 109.57 | 3019700.0 |
| 2003-12-18 15:00:00 | SPY | ETF | 109.57 | 109.72 | 109.52 | 109.65 | 1761900.0 |
| 2003-12-18 15:30:00 | SPY | ETF | 109.65 | 109.69 | 109.48 | 109.6 | 2635100.0 |
| 2003-12-18 16:00:00 | SPY | ETF | 109.59 | 109.73 | 109.57 | 109.64 | 1648500.0 |
| 2003-12-18 16:30:00 | SPY | ETF | 109.64 | 109.69 | 109.59 | 109.69 | 39000.0 |
| 2003-12-18 17:00:00 | SPY | ETF | 109.577 | 109.7 | 109.577 | 109.62 | 414100.0 |
| 2003-12-18 17:30:00 | SPY | ETF | 109.61 | 109.69 | 109.57 | 109.63 | 175600.0 |
| 2003-12-18 18:00:00 | SPY | ETF | 109.63 | 109.67 | 107.64 | 109.61 | 181600.0 |
| 2003-12-18 18:30:00 | SPY | ETF | 109.64 | 109.64 | 109.64 | 109.64 | 200.0 |
| 2003-12-18 19:00:00 | SPY | ETF | 109.6 | 109.63 | 109.6 | 109.63 | 400.0 |
| 2003-12-18 19:30:00 | SPY | ETF | 109.62 | 109.62 | 109.62 | 109.62 | 1000.0 |
| 2003-12-18 08:00:00 | QQQ | ETF | 34.95 | 34.97 | 34.92 | 34.93 | 99500.0 |
| 2003-12-18 08:30:00 | QQQ | ETF | 34.93 | 35.0 | 34.93 | 34.95 | 41200.0 |
| 2003-12-18 09:00:00 | QQQ | ETF | 34.96 | 34.96 | 34.94 | 34.95 | 56400.0 |
| 2003-12-18 09:30:00 | QQQ | ETF | 34.95 | 35.3 | 34.949 | 35.26 | 14241900.0 |
| 2003-12-18 10:00:00 | QQQ | ETF | 35.26 | 35.32 | 35.18 | 35.273 | 7494400.0 |
| 2003-12-18 10:30:00 | QQQ | ETF | 35.29 | 35.4 | 35.255 | 35.375 | 7718200.0 |
| 2003-12-18 11:00:00 | QQQ | ETF | 35.375 | 35.413 | 35.32 | 35.38 | 6273000.0 |
| 2003-12-18 11:30:00 | QQQ | ETF | 35.38 | 35.42 | 35.3 | 35.37 | 3729200.0 |
| 2003-12-18 12:00:00 | QQQ | ETF | 35.39 | 35.43 | 35.3 | 35.36 | 4386200.0 |
| 2003-12-18 12:30:00 | QQQ | ETF | 35.36 | 35.41 | 35.35 | 35.36 | 2545200.0 |
| 2003-12-18 13:00:00 | QQQ | ETF | 35.38 | 35.5 | 35.37 | 35.46 | 4671000.0 |
| 2003-12-18 13:30:00 | QQQ | ETF | 35.464 | 35.49 | 35.39 | 35.4 | 3608600.0 |
| 2003-12-18 14:00:00 | QQQ | ETF | 35.4 | 35.49 | 35.39 | 35.48 | 5403600.0 |
| 2003-12-18 14:30:00 | QQQ | ETF | 35.48 | 35.59 | 35.44 | 35.56 | 6838300.0 |
| 2003-12-18 15:00:00 | QQQ | ETF | 35.56 | 35.64 | 35.54 | 35.579 | 5375200.0 |
| 2003-12-18 15:30:00 | QQQ | ETF | 35.58 | 35.601 | 35.47 | 35.57 | 9277900.0 |
| 2003-12-18 16:00:00 | QQQ | ETF | 35.56 | 35.6 | 35.52 | 35.54 | 2779200.0 |
| 2003-12-18 16:30:00 | QQQ | ETF | 35.545 | 35.55 | 35.52 | 35.55 | 136000.0 |
| 2003-12-18 17:00:00 | QQQ | ETF | 35.558 | 35.56 | 35.51 | 35.512 | 42800.0 |
| 2003-12-18 17:30:00 | QQQ | ETF | 35.49 | 35.54 | 35.49 | 35.52 | 178500.0 |
| 2003-12-18 18:00:00 | QQQ | ETF | 35.5 | 35.52 | 35.5 | 35.5 | 18300.0 |
| 2003-12-18 18:30:00 | QQQ | ETF | 35.5 | 35.5 | 35.5 | 35.5 | 900.0 |
| 2003-12-18 19:00:00 | QQQ | ETF | 35.53 | 35.55 | 35.53 | 35.54 | 4600.0 |
| 2003-12-18 19:30:00 | QQQ | ETF | 35.53 | 35.55 | 35.53 | 35.54 | 3300.0 |
| 2003-12-18 09:00:00 | IWM | ETF | 53.525 | 53.595 | 53.525 | 53.595 | 25400.0 |
| 2003-12-18 09:30:00 | IWM | ETF | 53.585 | 54.07 | 53.46 | 54.05 | 1205000.0 |
> showing 50 of 910 rows — these rows as CSV