PREVIEW / etf_30min / 2003-01-09
file: by_date/etf_30min/2003/2003-01-09.parquet size: 21 KB rows: 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 |
|---|---|---|---|---|---|---|---|
| 2003-01-09 08:00:00 | SPY | ETF | 91.53 | 91.79 | 91.52 | 91.75 | 66900.0 |
| 2003-01-09 08:30:00 | SPY | ETF | 91.72 | 91.86 | 91.72 | 91.75 | 32000.0 |
| 2003-01-09 09:00:00 | SPY | ETF | 91.74 | 91.84 | 91.74 | 91.83 | 21600.0 |
| 2003-01-09 09:30:00 | SPY | ETF | 91.79 | 92.3 | 91.79 | 92.25 | 4203100.0 |
| 2003-01-09 10:00:00 | SPY | ETF | 92.3 | 92.77 | 92.26 | 92.73 | 5201600.0 |
| 2003-01-09 10:30:00 | SPY | ETF | 92.72 | 92.98 | 92.64 | 92.94 | 2633200.0 |
| 2003-01-09 11:00:00 | SPY | ETF | 92.93 | 93.04 | 92.79 | 92.92 | 1861900.0 |
| 2003-01-09 11:30:00 | SPY | ETF | 92.95 | 93.05 | 92.86 | 92.95 | 982000.0 |
| 2003-01-09 12:00:00 | SPY | ETF | 92.94 | 93.01 | 92.74 | 92.83 | 1105200.0 |
| 2003-01-09 12:30:00 | SPY | ETF | 92.81 | 92.84 | 92.67 | 92.76 | 1703600.0 |
| 2003-01-09 13:00:00 | SPY | ETF | 92.74 | 92.87 | 92.53 | 92.63 | 1299200.0 |
| 2003-01-09 13:30:00 | SPY | ETF | 92.66 | 92.72 | 92.37 | 92.46 | 1567300.0 |
| 2003-01-09 14:00:00 | SPY | ETF | 92.48 | 92.8 | 92.4 | 92.63 | 1567400.0 |
| 2003-01-09 14:30:00 | SPY | ETF | 92.64 | 92.9 | 92.58 | 92.76 | 1366100.0 |
| 2003-01-09 15:00:00 | SPY | ETF | 92.8 | 93.05 | 92.75 | 92.79 | 2189400.0 |
| 2003-01-09 15:30:00 | SPY | ETF | 92.77 | 93.18 | 92.65 | 92.99 | 3453200.0 |
| 2003-01-09 16:00:00 | SPY | ETF | 93.0 | 93.04 | 92.79 | 92.79 | 2029300.0 |
| 2003-01-09 16:30:00 | SPY | ETF | 92.77 | 93.03 | 92.72 | 92.89 | 122000.0 |
| 2003-01-09 17:00:00 | SPY | ETF | 92.89 | 92.97 | 92.85 | 92.97 | 52800.0 |
| 2003-01-09 17:30:00 | SPY | ETF | 92.91 | 92.98 | 92.91 | 92.97 | 12800.0 |
| 2003-01-09 18:00:00 | SPY | ETF | 92.91 | 93.02 | 92.89 | 93.02 | 3200.0 |
| 2003-01-09 18:30:00 | SPY | ETF | 92.99 | 93.0 | 92.93 | 93.0 | 1500.0 |
| 2003-01-09 19:00:00 | SPY | ETF | 93.0 | 93.0 | 93.0 | 93.0 | 200.0 |
| 2003-01-09 19:30:00 | SPY | ETF | 93.0 | 93.02 | 93.0 | 93.0 | 5900.0 |
| 2003-01-09 08:00:00 | QQQ | ETF | 26.03 | 26.23 | 26.03 | 26.17 | 66200.0 |
| 2003-01-09 08:30:00 | QQQ | ETF | 26.17 | 26.28 | 26.17 | 26.2 | 103600.0 |
| 2003-01-09 09:00:00 | QQQ | ETF | 26.2 | 26.24 | 26.19 | 26.24 | 37000.0 |
| 2003-01-09 09:30:00 | QQQ | ETF | 26.24 | 26.93 | 26.22 | 26.56 | 10382600.0 |
| 2003-01-09 10:00:00 | QQQ | ETF | 26.54 | 26.74 | 26.54 | 26.74 | 8551800.0 |
| 2003-01-09 10:30:00 | QQQ | ETF | 26.72 | 26.93 | 26.68 | 26.87 | 8972400.0 |
| 2003-01-09 11:00:00 | QQQ | ETF | 26.88 | 26.96 | 26.78 | 26.92 | 6694400.0 |
| 2003-01-09 11:30:00 | QQQ | ETF | 26.92 | 26.98 | 26.86 | 26.92 | 4084100.0 |
| 2003-01-09 12:00:00 | QQQ | ETF | 26.92 | 26.95 | 26.8 | 26.84 | 1899300.0 |
| 2003-01-09 12:30:00 | QQQ | ETF | 26.84 | 26.87 | 26.76 | 26.8 | 2790300.0 |
| 2003-01-09 13:00:00 | QQQ | ETF | 26.8 | 26.88 | 26.69 | 26.75 | 3232800.0 |
| 2003-01-09 13:30:00 | QQQ | ETF | 26.76 | 26.79 | 26.64 | 26.72 | 4447400.0 |
| 2003-01-09 14:00:00 | QQQ | ETF | 26.71 | 26.84 | 26.66 | 26.72 | 3765200.0 |
| 2003-01-09 14:30:00 | QQQ | ETF | 26.73 | 26.85 | 26.71 | 26.78 | 2560600.0 |
| 2003-01-09 15:00:00 | QQQ | ETF | 26.78 | 26.89 | 26.71 | 26.71 | 2716600.0 |
| 2003-01-09 15:30:00 | QQQ | ETF | 26.7 | 26.84 | 26.65 | 26.73 | 5862400.0 |
| 2003-01-09 16:00:00 | QQQ | ETF | 26.71 | 26.75 | 26.66 | 26.71 | 2701100.0 |
| 2003-01-09 16:30:00 | QQQ | ETF | 26.73 | 26.75 | 26.67 | 26.72 | 583900.0 |
| 2003-01-09 17:00:00 | QQQ | ETF | 26.73 | 26.76 | 26.73 | 26.74 | 108300.0 |
| 2003-01-09 17:30:00 | QQQ | ETF | 26.73 | 26.77 | 26.73 | 26.75 | 14700.0 |
| 2003-01-09 18:00:00 | QQQ | ETF | 26.77 | 26.79 | 26.73 | 26.79 | 19500.0 |
| 2003-01-09 18:30:00 | QQQ | ETF | 26.79 | 26.79 | 26.75 | 26.75 | 4700.0 |
| 2003-01-09 19:00:00 | QQQ | ETF | 26.78 | 26.78 | 26.78 | 26.78 | 5100.0 |
| 2003-01-09 19:30:00 | QQQ | ETF | 26.78 | 26.78 | 26.74 | 26.76 | 17900.0 |
| 2003-01-09 09:30:00 | IWM | ETF | 38.99 | 39.21 | 38.99 | 39.2 | 418800.0 |
| 2003-01-09 10:00:00 | IWM | ETF | 39.26 | 39.46 | 39.22 | 39.46 | 319600.0 |
> showing 50 of 622 rows — these rows as CSV