PREVIEW / etf_30min / 2003-05-05
file: by_date/etf_30min/2003/2003-05-05.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-05 08:00:00 | SPY | ETF | 93.57 | 93.6 | 93.51 | 93.55 | 11500.0 |
| 2003-05-05 08:30:00 | SPY | ETF | 93.6 | 93.63 | 93.6 | 93.61 | 48200.0 |
| 2003-05-05 09:00:00 | SPY | ETF | 93.62 | 93.7 | 93.5 | 93.5 | 35100.0 |
| 2003-05-05 09:30:00 | SPY | ETF | 93.47 | 93.7 | 93.13 | 93.42 | 5429400.0 |
| 2003-05-05 10:00:00 | SPY | ETF | 93.42 | 93.78 | 93.27 | 93.58 | 4580800.0 |
| 2003-05-05 10:30:00 | SPY | ETF | 93.59 | 93.72 | 92.87 | 92.89 | 3691200.0 |
| 2003-05-05 11:00:00 | SPY | ETF | 92.96 | 93.15 | 92.77 | 92.86 | 3458500.0 |
| 2003-05-05 11:30:00 | SPY | ETF | 92.86 | 93.23 | 92.82 | 93.16 | 1414300.0 |
| 2003-05-05 12:00:00 | SPY | ETF | 93.17 | 93.3 | 93.02 | 93.25 | 810400.0 |
| 2003-05-05 12:30:00 | SPY | ETF | 93.26 | 93.45 | 93.24 | 93.36 | 994400.0 |
| 2003-05-05 13:00:00 | SPY | ETF | 93.34 | 93.57 | 93.24 | 93.55 | 720400.0 |
| 2003-05-05 13:30:00 | SPY | ETF | 93.54 | 93.59 | 93.33 | 93.34 | 1291200.0 |
| 2003-05-05 14:00:00 | SPY | ETF | 93.32 | 93.35 | 93.05 | 93.1 | 1670100.0 |
| 2003-05-05 14:30:00 | SPY | ETF | 93.1 | 93.3 | 92.85 | 92.85 | 2059100.0 |
| 2003-05-05 15:00:00 | SPY | ETF | 92.86 | 93.12 | 92.82 | 93.0 | 1650000.0 |
| 2003-05-05 15:30:00 | SPY | ETF | 92.98 | 93.24 | 92.95 | 92.96 | 2088000.0 |
| 2003-05-05 16:00:00 | SPY | ETF | 92.94 | 93.09 | 92.92 | 93.03 | 1036500.0 |
| 2003-05-05 16:30:00 | SPY | ETF | 93.09 | 93.09 | 92.98 | 93.01 | 14800.0 |
| 2003-05-05 17:00:00 | SPY | ETF | 93.0 | 93.0 | 92.96 | 92.96 | 8200.0 |
| 2003-05-05 17:30:00 | SPY | ETF | 92.96 | 92.97 | 92.95 | 92.97 | 3700.0 |
| 2003-05-05 18:00:00 | SPY | ETF | 92.97 | 92.97 | 92.95 | 92.97 | 2600.0 |
| 2003-05-05 18:30:00 | SPY | ETF | 92.97 | 92.99 | 92.9 | 92.9 | 8200.0 |
| 2003-05-05 08:00:00 | QQQ | ETF | 28.41 | 28.44 | 28.39 | 28.42 | 40800.0 |
| 2003-05-05 08:30:00 | QQQ | ETF | 28.43 | 28.44 | 28.4 | 28.41 | 53000.0 |
| 2003-05-05 09:00:00 | QQQ | ETF | 28.4 | 28.45 | 28.35 | 28.35 | 86400.0 |
| 2003-05-05 09:30:00 | QQQ | ETF | 28.32 | 28.44 | 28.17 | 28.38 | 11571400.0 |
| 2003-05-05 10:00:00 | QQQ | ETF | 28.39 | 28.65 | 28.36 | 28.62 | 13926900.0 |
| 2003-05-05 10:30:00 | QQQ | ETF | 28.61 | 28.67 | 28.3 | 28.38 | 8757600.0 |
| 2003-05-05 11:00:00 | QQQ | ETF | 28.39 | 28.49 | 28.29 | 28.38 | 5018000.0 |
| 2003-05-05 11:30:00 | QQQ | ETF | 28.37 | 28.56 | 28.35 | 28.5 | 3376700.0 |
| 2003-05-05 12:00:00 | QQQ | ETF | 28.47 | 28.55 | 28.41 | 28.53 | 1603100.0 |
| 2003-05-05 12:30:00 | QQQ | ETF | 28.54 | 28.61 | 28.51 | 28.56 | 2347600.0 |
| 2003-05-05 13:00:00 | QQQ | ETF | 28.58 | 28.67 | 28.5 | 28.66 | 1881100.0 |
| 2003-05-05 13:30:00 | QQQ | ETF | 28.65 | 28.71 | 28.49 | 28.51 | 3839900.0 |
| 2003-05-05 14:00:00 | QQQ | ETF | 28.52 | 28.52 | 28.34 | 28.36 | 3162700.0 |
| 2003-05-05 14:30:00 | QQQ | ETF | 28.36 | 28.44 | 28.23 | 28.25 | 4205000.0 |
| 2003-05-05 15:00:00 | QQQ | ETF | 28.25 | 28.36 | 28.22 | 28.33 | 3916200.0 |
| 2003-05-05 15:30:00 | QQQ | ETF | 28.33 | 28.45 | 28.21 | 28.24 | 5005100.0 |
| 2003-05-05 16:00:00 | QQQ | ETF | 28.24 | 28.3 | 28.22 | 28.29 | 725600.0 |
| 2003-05-05 16:30:00 | QQQ | ETF | 28.29 | 28.39 | 28.24 | 28.24 | 158400.0 |
| 2003-05-05 17:00:00 | QQQ | ETF | 28.24 | 28.26 | 28.23 | 28.24 | 71600.0 |
| 2003-05-05 17:30:00 | QQQ | ETF | 28.23 | 28.25 | 28.23 | 28.24 | 78100.0 |
| 2003-05-05 18:00:00 | QQQ | ETF | 28.24 | 28.26 | 28.22 | 28.23 | 44900.0 |
| 2003-05-05 18:30:00 | QQQ | ETF | 28.25 | 28.26 | 28.23 | 28.24 | 11800.0 |
| 2003-05-05 19:00:00 | QQQ | ETF | 28.24 | 28.24 | 28.23 | 28.23 | 1600.0 |
| 2003-05-05 19:30:00 | QQQ | ETF | 28.23 | 28.26 | 28.23 | 28.25 | 8100.0 |
| 2003-05-05 09:30:00 | IWM | ETF | 40.765 | 40.92 | 40.725 | 40.885 | 295200.0 |
| 2003-05-05 10:00:00 | IWM | ETF | 40.8 | 40.915 | 40.8 | 40.84 | 221400.0 |
| 2003-05-05 10:30:00 | IWM | ETF | 40.84 | 40.87 | 40.65 | 40.65 | 385600.0 |
| 2003-05-05 11:00:00 | IWM | ETF | 40.685 | 40.72 | 40.63 | 40.67 | 147800.0 |
> showing 50 of 701 rows — these rows as CSV