PREVIEW / etf_30min / 2003-01-24
file: by_date/etf_30min/2003/2003-01-24.parquet size: 23 KB rows: 678
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-24 08:00:00 | SPY | ETF | 88.65 | 88.74 | 88.59 | 88.62 | 19700.0 |
| 2003-01-24 08:30:00 | SPY | ETF | 88.62 | 88.64 | 88.6 | 88.64 | 5700.0 |
| 2003-01-24 09:00:00 | SPY | ETF | 88.67 | 88.7 | 88.61 | 88.61 | 20800.0 |
| 2003-01-24 09:30:00 | SPY | ETF | 88.59 | 88.68 | 87.66 | 87.82 | 6720900.0 |
| 2003-01-24 10:00:00 | SPY | ETF | 87.83 | 87.84 | 87.04 | 87.25 | 7988000.0 |
| 2003-01-24 10:30:00 | SPY | ETF | 87.27 | 87.49 | 87.09 | 87.4 | 5065500.0 |
| 2003-01-24 11:00:00 | SPY | ETF | 87.38 | 87.5 | 87.14 | 87.24 | 2861600.0 |
| 2003-01-24 11:30:00 | SPY | ETF | 87.24 | 87.28 | 86.67 | 86.85 | 6343200.0 |
| 2003-01-24 12:00:00 | SPY | ETF | 86.86 | 86.88 | 86.5 | 86.78 | 4378000.0 |
| 2003-01-24 12:30:00 | SPY | ETF | 86.81 | 86.85 | 86.51 | 86.56 | 2075100.0 |
| 2003-01-24 13:00:00 | SPY | ETF | 86.57 | 86.6 | 86.26 | 86.44 | 3946100.0 |
| 2003-01-24 13:30:00 | SPY | ETF | 86.44 | 86.77 | 86.41 | 86.67 | 2726100.0 |
| 2003-01-24 14:00:00 | SPY | ETF | 86.65 | 86.83 | 86.55 | 86.82 | 2334000.0 |
| 2003-01-24 14:30:00 | SPY | ETF | 86.81 | 86.83 | 86.38 | 86.41 | 3855400.0 |
| 2003-01-24 15:00:00 | SPY | ETF | 86.42 | 86.47 | 86.17 | 86.47 | 3372600.0 |
| 2003-01-24 15:30:00 | SPY | ETF | 86.45 | 86.74 | 86.33 | 86.33 | 4762500.0 |
| 2003-01-24 16:00:00 | SPY | ETF | 86.33 | 86.48 | 86.28 | 86.4 | 2112600.0 |
| 2003-01-24 16:30:00 | SPY | ETF | 86.4 | 86.6 | 86.25 | 86.29 | 1137900.0 |
| 2003-01-24 17:00:00 | SPY | ETF | 86.32 | 86.34 | 86.29 | 86.33 | 11400.0 |
| 2003-01-24 17:30:00 | SPY | ETF | 86.65 | 86.65 | 86.32 | 86.35 | 61000.0 |
| 2003-01-24 18:00:00 | SPY | ETF | 86.35 | 86.35 | 86.35 | 86.35 | 400.0 |
| 2003-01-24 18:30:00 | SPY | ETF | 86.39 | 86.39 | 86.39 | 86.39 | 1100.0 |
| 2003-01-24 19:00:00 | SPY | ETF | 86.36 | 86.36 | 86.3 | 86.3 | 800.0 |
| 2003-01-24 19:30:00 | SPY | ETF | 86.33 | 86.35 | 86.33 | 86.35 | 300.0 |
| 2003-01-24 08:00:00 | QQQ | ETF | 25.6 | 25.6 | 25.5 | 25.52 | 17100.0 |
| 2003-01-24 08:30:00 | QQQ | ETF | 25.52 | 25.54 | 25.5 | 25.52 | 14400.0 |
| 2003-01-24 09:00:00 | QQQ | ETF | 25.52 | 25.55 | 25.51 | 25.53 | 11400.0 |
| 2003-01-24 09:30:00 | QQQ | ETF | 25.53 | 25.53 | 25.2 | 25.25 | 9036700.0 |
| 2003-01-24 10:00:00 | QQQ | ETF | 25.25 | 25.29 | 24.86 | 24.96 | 13259900.0 |
| 2003-01-24 10:30:00 | QQQ | ETF | 24.96 | 25.07 | 24.86 | 25.01 | 5768600.0 |
| 2003-01-24 11:00:00 | QQQ | ETF | 25.02 | 25.04 | 24.87 | 24.92 | 3543700.0 |
| 2003-01-24 11:30:00 | QQQ | ETF | 24.93 | 24.98 | 24.78 | 24.87 | 5278900.0 |
| 2003-01-24 12:00:00 | QQQ | ETF | 24.87 | 24.89 | 24.73 | 24.85 | 3161400.0 |
| 2003-01-24 12:30:00 | QQQ | ETF | 24.85 | 24.9 | 24.75 | 24.76 | 2956500.0 |
| 2003-01-24 13:00:00 | QQQ | ETF | 24.76 | 24.8 | 24.69 | 24.77 | 3203300.0 |
| 2003-01-24 13:30:00 | QQQ | ETF | 24.77 | 24.9 | 24.75 | 24.86 | 3467000.0 |
| 2003-01-24 14:00:00 | QQQ | ETF | 24.86 | 24.88 | 24.8 | 24.87 | 1599500.0 |
| 2003-01-24 14:30:00 | QQQ | ETF | 24.88 | 24.88 | 24.69 | 24.73 | 3307400.0 |
| 2003-01-24 15:00:00 | QQQ | ETF | 24.72 | 24.75 | 24.65 | 24.75 | 4288700.0 |
| 2003-01-24 15:30:00 | QQQ | ETF | 24.73 | 24.86 | 24.7 | 24.75 | 6748800.0 |
| 2003-01-24 16:00:00 | QQQ | ETF | 24.75 | 24.85 | 24.72 | 24.78 | 2794400.0 |
| 2003-01-24 16:30:00 | QQQ | ETF | 24.79 | 24.81 | 24.78 | 24.79 | 90300.0 |
| 2003-01-24 17:00:00 | QQQ | ETF | 24.78 | 24.79 | 24.77 | 24.79 | 28600.0 |
| 2003-01-24 17:30:00 | QQQ | ETF | 24.79 | 24.81 | 24.78 | 24.8 | 35100.0 |
| 2003-01-24 18:00:00 | QQQ | ETF | 24.8 | 24.83 | 24.77 | 24.77 | 17900.0 |
| 2003-01-24 18:30:00 | QQQ | ETF | 24.81 | 24.84 | 24.81 | 24.83 | 12000.0 |
| 2003-01-24 19:00:00 | QQQ | ETF | 24.84 | 24.84 | 24.83 | 24.83 | 5400.0 |
| 2003-01-24 19:30:00 | QQQ | ETF | 24.81 | 24.83 | 24.81 | 24.81 | 4300.0 |
| 2003-01-24 09:30:00 | IWM | ETF | 38.0 | 38.0 | 37.64 | 37.695 | 255000.0 |
| 2003-01-24 10:00:00 | IWM | ETF | 37.695 | 37.695 | 37.39 | 37.47 | 601200.0 |
> showing 50 of 678 rows — these rows as CSV