PREVIEW / etf_30min / 2003-05-12
file: by_date/etf_30min/2003/2003-05-12.parquet size: 23 KB rows: 701
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-12 08:00:00 | SPY | ETF | 93.52 | 93.72 | 93.51 | 93.63 | 36800.0 |
| 2003-05-12 08:30:00 | SPY | ETF | 93.63 | 93.63 | 93.48 | 93.49 | 44900.0 |
| 2003-05-12 09:00:00 | SPY | ETF | 93.49 | 93.5 | 93.42 | 93.48 | 26400.0 |
| 2003-05-12 09:30:00 | SPY | ETF | 93.5 | 93.71 | 93.28 | 93.64 | 3466800.0 |
| 2003-05-12 10:00:00 | SPY | ETF | 93.65 | 94.09 | 93.55 | 93.93 | 3807000.0 |
| 2003-05-12 10:30:00 | SPY | ETF | 93.93 | 94.39 | 93.74 | 94.31 | 3476200.0 |
| 2003-05-12 11:00:00 | SPY | ETF | 94.32 | 94.39 | 94.17 | 94.35 | 2993900.0 |
| 2003-05-12 11:30:00 | SPY | ETF | 94.34 | 94.8 | 94.23 | 94.78 | 3898900.0 |
| 2003-05-12 12:00:00 | SPY | ETF | 94.76 | 94.85 | 94.67 | 94.8 | 1320900.0 |
| 2003-05-12 12:30:00 | SPY | ETF | 94.82 | 94.95 | 94.77 | 94.81 | 1698200.0 |
| 2003-05-12 13:00:00 | SPY | ETF | 94.82 | 94.95 | 94.65 | 94.75 | 1011800.0 |
| 2003-05-12 13:30:00 | SPY | ETF | 94.74 | 94.85 | 94.62 | 94.69 | 1494200.0 |
| 2003-05-12 14:00:00 | SPY | ETF | 94.7 | 94.99 | 94.67 | 94.88 | 1001600.0 |
| 2003-05-12 14:30:00 | SPY | ETF | 94.88 | 95.07 | 94.73 | 95.06 | 2117200.0 |
| 2003-05-12 15:00:00 | SPY | ETF | 95.05 | 95.12 | 94.92 | 94.95 | 1512900.0 |
| 2003-05-12 15:30:00 | SPY | ETF | 94.94 | 95.03 | 94.81 | 94.9 | 3042000.0 |
| 2003-05-12 16:00:00 | SPY | ETF | 94.9 | 94.96 | 94.82 | 94.84 | 1384100.0 |
| 2003-05-12 16:30:00 | SPY | ETF | 94.84 | 94.87 | 94.81 | 94.86 | 9500.0 |
| 2003-05-12 17:00:00 | SPY | ETF | 94.86 | 94.87 | 94.84 | 94.86 | 6700.0 |
| 2003-05-12 17:30:00 | SPY | ETF | 94.87 | 94.88 | 94.8 | 94.84 | 7600.0 |
| 2003-05-12 18:00:00 | SPY | ETF | 94.78 | 94.81 | 94.78 | 94.81 | 7100.0 |
| 2003-05-12 18:30:00 | SPY | ETF | 94.78 | 94.78 | 94.74 | 94.74 | 5000.0 |
| 2003-05-12 19:00:00 | SPY | ETF | 94.74 | 94.82 | 94.74 | 94.74 | 6300.0 |
| 2003-05-12 19:30:00 | SPY | ETF | 94.73 | 94.75 | 94.73 | 94.75 | 600.0 |
| 2003-05-12 08:00:00 | QQQ | ETF | 28.45 | 28.51 | 28.42 | 28.47 | 38900.0 |
| 2003-05-12 08:30:00 | QQQ | ETF | 28.47 | 28.5 | 28.37 | 28.37 | 67800.0 |
| 2003-05-12 09:00:00 | QQQ | ETF | 28.36 | 28.39 | 28.32 | 28.35 | 67200.0 |
| 2003-05-12 09:30:00 | QQQ | ETF | 28.36 | 28.42 | 28.17 | 28.31 | 8403700.0 |
| 2003-05-12 10:00:00 | QQQ | ETF | 28.33 | 28.59 | 28.28 | 28.51 | 8525800.0 |
| 2003-05-12 10:30:00 | QQQ | ETF | 28.5 | 28.75 | 28.43 | 28.71 | 5132600.0 |
| 2003-05-12 11:00:00 | QQQ | ETF | 28.7 | 28.74 | 28.63 | 28.69 | 4505600.0 |
| 2003-05-12 11:30:00 | QQQ | ETF | 28.68 | 28.9 | 28.65 | 28.85 | 7360100.0 |
| 2003-05-12 12:00:00 | QQQ | ETF | 28.86 | 28.89 | 28.81 | 28.87 | 3145000.0 |
| 2003-05-12 12:30:00 | QQQ | ETF | 28.87 | 28.9 | 28.78 | 28.82 | 2508000.0 |
| 2003-05-12 13:00:00 | QQQ | ETF | 28.8 | 28.88 | 28.74 | 28.79 | 3820000.0 |
| 2003-05-12 13:30:00 | QQQ | ETF | 28.79 | 28.84 | 28.75 | 28.8 | 2473100.0 |
| 2003-05-12 14:00:00 | QQQ | ETF | 28.79 | 28.91 | 28.76 | 28.85 | 2699300.0 |
| 2003-05-12 14:30:00 | QQQ | ETF | 28.85 | 28.94 | 28.78 | 28.93 | 3350400.0 |
| 2003-05-12 15:00:00 | QQQ | ETF | 28.92 | 28.96 | 28.85 | 28.87 | 4646400.0 |
| 2003-05-12 15:30:00 | QQQ | ETF | 28.86 | 28.94 | 28.82 | 28.85 | 4404100.0 |
| 2003-05-12 16:00:00 | QQQ | ETF | 28.84 | 28.89 | 28.77 | 28.88 | 1505300.0 |
| 2003-05-12 16:30:00 | QQQ | ETF | 28.88 | 28.88 | 28.82 | 28.83 | 106000.0 |
| 2003-05-12 17:00:00 | QQQ | ETF | 28.84 | 28.86 | 28.83 | 28.84 | 25600.0 |
| 2003-05-12 17:30:00 | QQQ | ETF | 28.85 | 28.86 | 28.82 | 28.84 | 70600.0 |
| 2003-05-12 18:00:00 | QQQ | ETF | 28.85 | 28.86 | 28.82 | 28.86 | 53400.0 |
| 2003-05-12 18:30:00 | QQQ | ETF | 28.85 | 28.86 | 28.79 | 28.8 | 28800.0 |
| 2003-05-12 19:00:00 | QQQ | ETF | 28.8 | 28.83 | 28.78 | 28.82 | 6000.0 |
| 2003-05-12 19:30:00 | QQQ | ETF | 28.85 | 28.87 | 28.82 | 28.86 | 7400.0 |
| 2003-05-12 09:30:00 | IWM | ETF | 41.18 | 41.275 | 41.15 | 41.26 | 319000.0 |
| 2003-05-12 10:00:00 | IWM | ETF | 41.23 | 41.445 | 41.23 | 41.41 | 189000.0 |
> showing 50 of 701 rows — these rows as CSV