PREVIEW / etf_30min / 2003-12-08
file: by_date/etf_30min/2003/2003-12-08.parquet size: 27 KB rows: 865
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-08 08:00:00 | SPY | ETF | 106.65 | 106.65 | 106.55 | 106.55 | 1200.0 |
| 2003-12-08 08:30:00 | SPY | ETF | 106.55 | 106.63 | 106.55 | 106.63 | 6100.0 |
| 2003-12-08 09:00:00 | SPY | ETF | 106.64 | 106.72 | 106.64 | 106.71 | 12800.0 |
| 2003-12-08 09:30:00 | SPY | ETF | 106.74 | 107.1 | 106.68 | 107.03 | 3583700.0 |
| 2003-12-08 10:00:00 | SPY | ETF | 107.02 | 107.11 | 106.88 | 106.94 | 2578400.0 |
| 2003-12-08 10:30:00 | SPY | ETF | 106.94 | 107.0 | 106.79 | 106.9 | 1856200.0 |
| 2003-12-08 11:00:00 | SPY | ETF | 106.9 | 106.99 | 106.73 | 106.92 | 1705300.0 |
| 2003-12-08 11:30:00 | SPY | ETF | 106.93 | 106.99 | 106.83 | 106.96 | 982100.0 |
| 2003-12-08 12:00:00 | SPY | ETF | 106.96 | 106.96 | 106.74 | 106.81 | 816600.0 |
| 2003-12-08 12:30:00 | SPY | ETF | 106.8 | 106.91 | 106.72 | 106.85 | 867200.0 |
| 2003-12-08 13:00:00 | SPY | ETF | 106.87 | 107.14 | 106.78 | 107.08 | 1568600.0 |
| 2003-12-08 13:30:00 | SPY | ETF | 107.09 | 107.14 | 107.01 | 107.07 | 1651500.0 |
| 2003-12-08 14:00:00 | SPY | ETF | 107.07 | 107.11 | 106.8 | 106.88 | 1629600.0 |
| 2003-12-08 14:30:00 | SPY | ETF | 106.89 | 107.16 | 106.8 | 107.13 | 1445900.0 |
| 2003-12-08 15:00:00 | SPY | ETF | 107.13 | 107.51 | 107.09 | 107.45 | 3058300.0 |
| 2003-12-08 15:30:00 | SPY | ETF | 107.44 | 107.64 | 107.43 | 107.52 | 3140300.0 |
| 2003-12-08 16:00:00 | SPY | ETF | 107.52 | 107.62 | 107.49 | 107.58 | 2571400.0 |
| 2003-12-08 16:30:00 | SPY | ETF | 107.59 | 107.65 | 107.57 | 107.64 | 1602400.0 |
| 2003-12-08 17:00:00 | SPY | ETF | 107.64 | 107.66 | 107.64 | 107.65 | 2300.0 |
| 2003-12-08 17:30:00 | SPY | ETF | 107.65 | 107.7 | 107.62 | 107.7 | 6000.0 |
| 2003-12-08 18:00:00 | SPY | ETF | 107.67 | 107.7 | 107.66 | 107.66 | 3000.0 |
| 2003-12-08 18:30:00 | SPY | ETF | 107.68 | 107.7 | 107.68 | 107.7 | 1100.0 |
| 2003-12-08 19:00:00 | SPY | ETF | 107.71 | 107.71 | 107.7 | 107.7 | 2100.0 |
| 2003-12-08 19:30:00 | SPY | ETF | 107.71 | 107.71 | 107.71 | 107.71 | 3900.0 |
| 2003-12-08 08:00:00 | QQQ | ETF | 34.96 | 34.97 | 34.95 | 34.95 | 16200.0 |
| 2003-12-08 08:30:00 | QQQ | ETF | 34.95 | 34.95 | 34.91 | 34.94 | 55500.0 |
| 2003-12-08 09:00:00 | QQQ | ETF | 34.94 | 35.01 | 34.94 | 35.01 | 56100.0 |
| 2003-12-08 09:30:00 | QQQ | ETF | 35.02 | 35.188 | 34.96 | 35.12 | 10854800.0 |
| 2003-12-08 10:00:00 | QQQ | ETF | 35.118 | 35.2 | 35.049 | 35.06 | 6663100.0 |
| 2003-12-08 10:30:00 | QQQ | ETF | 35.05 | 35.07 | 34.91 | 34.95 | 7247500.0 |
| 2003-12-08 11:00:00 | QQQ | ETF | 34.96 | 35.01 | 34.86 | 34.965 | 7482000.0 |
| 2003-12-08 11:30:00 | QQQ | ETF | 34.963 | 35.01 | 34.89 | 34.99 | 4035700.0 |
| 2003-12-08 12:00:00 | QQQ | ETF | 34.98 | 34.99 | 34.87 | 34.905 | 2810500.0 |
| 2003-12-08 12:30:00 | QQQ | ETF | 34.9 | 34.94 | 34.835 | 34.914 | 4020800.0 |
| 2003-12-08 13:00:00 | QQQ | ETF | 34.92 | 35.06 | 34.85 | 35.04 | 5038000.0 |
| 2003-12-08 13:30:00 | QQQ | ETF | 35.035 | 35.05 | 34.97 | 35.003 | 2631100.0 |
| 2003-12-08 14:00:00 | QQQ | ETF | 35.0 | 35.01 | 34.78 | 34.83 | 4688500.0 |
| 2003-12-08 14:30:00 | QQQ | ETF | 34.82 | 35.01 | 34.8 | 34.95 | 4729000.0 |
| 2003-12-08 15:00:00 | QQQ | ETF | 34.96 | 35.16 | 34.951 | 35.12 | 6895000.0 |
| 2003-12-08 15:30:00 | QQQ | ETF | 35.116 | 35.33 | 35.11 | 35.25 | 11408300.0 |
| 2003-12-08 16:00:00 | QQQ | ETF | 35.25 | 35.27 | 35.22 | 35.258 | 2209400.0 |
| 2003-12-08 16:30:00 | QQQ | ETF | 35.25 | 35.345 | 35.25 | 35.281 | 735100.0 |
| 2003-12-08 17:00:00 | QQQ | ETF | 35.29 | 35.304 | 35.28 | 35.28 | 19400.0 |
| 2003-12-08 17:30:00 | QQQ | ETF | 35.3 | 35.3 | 35.25 | 35.27 | 56100.0 |
| 2003-12-08 18:00:00 | QQQ | ETF | 35.27 | 35.31 | 35.27 | 35.3 | 107800.0 |
| 2003-12-08 18:30:00 | QQQ | ETF | 35.29 | 35.31 | 35.29 | 35.31 | 13500.0 |
| 2003-12-08 19:00:00 | QQQ | ETF | 35.3 | 35.31 | 35.3 | 35.3 | 10500.0 |
| 2003-12-08 19:30:00 | QQQ | ETF | 35.31 | 35.32 | 35.3 | 35.32 | 14000.0 |
| 2003-12-08 09:00:00 | IWM | ETF | 53.73 | 53.73 | 53.73 | 53.73 | 1000.0 |
| 2003-12-08 09:30:00 | IWM | ETF | 53.7 | 54.275 | 53.7 | 54.175 | 717800.0 |
> showing 50 of 865 rows — these rows as CSV