PREVIEW / etf_30min / 2003-05-20
file: by_date/etf_30min/2003/2003-05-20.parquet size: 23 KB rows: 685
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-05-20 08:00:00 | SPY | ETF | 92.93 | 92.93 | 92.82 | 92.83 | 11500.0 |
| 2003-05-20 08:30:00 | SPY | ETF | 92.83 | 92.9 | 92.81 | 92.86 | 19000.0 |
| 2003-05-20 09:00:00 | SPY | ETF | 92.88 | 92.89 | 92.8 | 92.84 | 24900.0 |
| 2003-05-20 09:30:00 | SPY | ETF | 92.82 | 93.01 | 92.63 | 92.66 | 6809100.0 |
| 2003-05-20 10:00:00 | SPY | ETF | 92.7 | 93.03 | 92.54 | 92.56 | 3429500.0 |
| 2003-05-20 10:30:00 | SPY | ETF | 92.58 | 92.94 | 92.5 | 92.8 | 1845100.0 |
| 2003-05-20 11:00:00 | SPY | ETF | 92.81 | 92.95 | 92.5 | 92.58 | 4043400.0 |
| 2003-05-20 11:30:00 | SPY | ETF | 92.63 | 92.7 | 92.38 | 92.69 | 1336700.0 |
| 2003-05-20 12:00:00 | SPY | ETF | 92.7 | 92.93 | 92.68 | 92.85 | 2352700.0 |
| 2003-05-20 12:30:00 | SPY | ETF | 92.89 | 92.94 | 92.61 | 92.73 | 1001100.0 |
| 2003-05-20 13:00:00 | SPY | ETF | 92.72 | 92.8 | 92.27 | 92.32 | 883900.0 |
| 2003-05-20 13:30:00 | SPY | ETF | 92.32 | 92.58 | 92.25 | 92.53 | 1853800.0 |
| 2003-05-20 14:00:00 | SPY | ETF | 92.52 | 92.57 | 92.13 | 92.15 | 2043600.0 |
| 2003-05-20 14:30:00 | SPY | ETF | 92.14 | 92.29 | 91.72 | 91.76 | 7893800.0 |
| 2003-05-20 15:00:00 | SPY | ETF | 91.75 | 92.03 | 91.59 | 92.0 | 5426100.0 |
| 2003-05-20 15:30:00 | SPY | ETF | 92.03 | 92.6 | 91.91 | 92.44 | 6627900.0 |
| 2003-05-20 16:00:00 | SPY | ETF | 92.44 | 92.56 | 92.32 | 92.54 | 1369700.0 |
| 2003-05-20 16:30:00 | SPY | ETF | 92.54 | 92.56 | 92.47 | 92.47 | 128000.0 |
| 2003-05-20 17:00:00 | SPY | ETF | 92.53 | 92.56 | 92.5 | 92.5 | 58300.0 |
| 2003-05-20 17:30:00 | SPY | ETF | 92.51 | 92.51 | 92.45 | 92.49 | 22600.0 |
| 2003-05-20 18:00:00 | SPY | ETF | 92.5 | 92.55 | 92.5 | 92.55 | 5400.0 |
| 2003-05-20 18:30:00 | SPY | ETF | 92.53 | 92.55 | 92.43 | 92.47 | 6400.0 |
| 2003-05-20 19:00:00 | SPY | ETF | 92.44 | 92.44 | 92.44 | 92.44 | 200.0 |
| 2003-05-20 19:30:00 | SPY | ETF | 92.52 | 92.56 | 92.5 | 92.5 | 2200.0 |
| 2003-05-20 08:00:00 | QQQ | ETF | 27.77 | 27.77 | 27.75 | 27.75 | 66400.0 |
| 2003-05-20 08:30:00 | QQQ | ETF | 27.77 | 27.8 | 27.76 | 27.78 | 85600.0 |
| 2003-05-20 09:00:00 | QQQ | ETF | 27.77 | 27.8 | 27.76 | 27.76 | 79200.0 |
| 2003-05-20 09:30:00 | QQQ | ETF | 27.77 | 27.92 | 27.72 | 27.79 | 10336700.0 |
| 2003-05-20 10:00:00 | QQQ | ETF | 27.79 | 27.96 | 27.77 | 27.77 | 6230100.0 |
| 2003-05-20 10:30:00 | QQQ | ETF | 27.77 | 27.9 | 27.73 | 27.85 | 4234100.0 |
| 2003-05-20 11:00:00 | QQQ | ETF | 27.85 | 27.9 | 27.71 | 27.81 | 3253800.0 |
| 2003-05-20 11:30:00 | QQQ | ETF | 27.82 | 27.86 | 27.7 | 27.84 | 2072500.0 |
| 2003-05-20 12:00:00 | QQQ | ETF | 27.82 | 27.89 | 27.8 | 27.83 | 3291500.0 |
| 2003-05-20 12:30:00 | QQQ | ETF | 27.84 | 27.9 | 27.74 | 27.8 | 3583200.0 |
| 2003-05-20 13:00:00 | QQQ | ETF | 27.8 | 27.82 | 27.61 | 27.62 | 3488000.0 |
| 2003-05-20 13:30:00 | QQQ | ETF | 27.63 | 27.72 | 27.59 | 27.7 | 2164100.0 |
| 2003-05-20 14:00:00 | QQQ | ETF | 27.7 | 27.74 | 27.57 | 27.59 | 3014500.0 |
| 2003-05-20 14:30:00 | QQQ | ETF | 27.6 | 27.66 | 27.43 | 27.49 | 5399900.0 |
| 2003-05-20 15:00:00 | QQQ | ETF | 27.43 | 27.61 | 27.41 | 27.58 | 3643400.0 |
| 2003-05-20 15:30:00 | QQQ | ETF | 27.58 | 27.78 | 27.54 | 27.7 | 5552100.0 |
| 2003-05-20 16:00:00 | QQQ | ETF | 27.7 | 27.85 | 27.66 | 27.81 | 3071000.0 |
| 2003-05-20 16:30:00 | QQQ | ETF | 27.81 | 27.84 | 27.78 | 27.82 | 556200.0 |
| 2003-05-20 17:00:00 | QQQ | ETF | 27.82 | 27.87 | 27.81 | 27.82 | 465000.0 |
| 2003-05-20 17:30:00 | QQQ | ETF | 27.82 | 27.83 | 27.77 | 27.79 | 415400.0 |
| 2003-05-20 18:00:00 | QQQ | ETF | 27.8 | 27.85 | 27.8 | 27.85 | 9300.0 |
| 2003-05-20 18:30:00 | QQQ | ETF | 27.85 | 27.85 | 27.84 | 27.84 | 5400.0 |
| 2003-05-20 19:00:00 | QQQ | ETF | 27.85 | 27.86 | 27.81 | 27.81 | 13600.0 |
| 2003-05-20 19:30:00 | QQQ | ETF | 27.82 | 27.86 | 27.82 | 27.85 | 12000.0 |
| 2003-05-20 09:30:00 | IWM | ETF | 40.87 | 41.045 | 40.87 | 40.96 | 371600.0 |
| 2003-05-20 10:00:00 | IWM | ETF | 40.975 | 41.055 | 40.935 | 40.94 | 397000.0 |
> showing 50 of 685 rows — these rows as CSV