PREVIEW / etf_30min / 2005-08-03
file: by_date/etf_30min/2005/2005-08-03.parquet size: 45 KB rows: 1,623
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-03 06:30:00 | SPY | ETF | 124.31 | 124.31 | 124.31 | 124.31 | 500.0 |
| 2005-08-03 07:00:00 | SPY | ETF | 124.32 | 124.32 | 124.32 | 124.32 | 25500.0 |
| 2005-08-03 07:30:00 | SPY | ETF | 124.3 | 124.34 | 124.3 | 124.34 | 1900.0 |
| 2005-08-03 08:00:00 | SPY | ETF | 124.33 | 124.35 | 124.32 | 124.32 | 88000.0 |
| 2005-08-03 08:30:00 | SPY | ETF | 124.33 | 124.33 | 124.16 | 124.17 | 290800.0 |
| 2005-08-03 09:00:00 | SPY | ETF | 124.18 | 124.25 | 124.14 | 124.24 | 82700.0 |
| 2005-08-03 09:30:00 | SPY | ETF | 124.25 | 124.35 | 124.16 | 124.18 | 3562400.0 |
| 2005-08-03 10:00:00 | SPY | ETF | 124.17 | 124.33 | 124.12 | 124.28 | 2698500.0 |
| 2005-08-03 10:30:00 | SPY | ETF | 124.27 | 124.5 | 124.18 | 124.4 | 3952500.0 |
| 2005-08-03 11:00:00 | SPY | ETF | 124.41 | 124.55 | 124.33 | 124.5 | 1710100.0 |
| 2005-08-03 11:30:00 | SPY | ETF | 124.51 | 124.58 | 124.42 | 124.49 | 1304500.0 |
| 2005-08-03 12:00:00 | SPY | ETF | 124.48 | 124.7 | 124.44 | 124.66 | 1680900.0 |
| 2005-08-03 12:30:00 | SPY | ETF | 124.66 | 124.74 | 124.52 | 124.54 | 2215200.0 |
| 2005-08-03 13:00:00 | SPY | ETF | 124.54 | 124.59 | 124.46 | 124.59 | 1294400.0 |
| 2005-08-03 13:30:00 | SPY | ETF | 124.59 | 124.66 | 124.51 | 124.55 | 917600.0 |
| 2005-08-03 14:00:00 | SPY | ETF | 124.55 | 124.63 | 124.35 | 124.37 | 3315800.0 |
| 2005-08-03 14:30:00 | SPY | ETF | 124.39 | 124.45 | 124.26 | 124.36 | 4309800.0 |
| 2005-08-03 15:00:00 | SPY | ETF | 124.35 | 124.5 | 124.24 | 124.46 | 2718100.0 |
| 2005-08-03 15:30:00 | SPY | ETF | 124.46 | 124.7 | 124.43 | 124.64 | 3979100.0 |
| 2005-08-03 16:00:00 | SPY | ETF | 124.65 | 124.74 | 124.6 | 124.69 | 1027400.0 |
| 2005-08-03 16:30:00 | SPY | ETF | 124.68 | 124.72 | 124.65 | 124.7 | 397600.0 |
| 2005-08-03 17:00:00 | SPY | ETF | 124.7 | 124.72 | 124.7 | 124.72 | 2000.0 |
| 2005-08-03 17:30:00 | SPY | ETF | 124.75 | 124.77 | 124.71 | 124.71 | 9900.0 |
| 2005-08-03 18:00:00 | SPY | ETF | 124.73 | 124.73 | 124.73 | 124.73 | 8700.0 |
| 2005-08-03 19:00:00 | SPY | ETF | 124.73 | 124.73 | 124.73 | 124.73 | 500.0 |
| 2005-08-03 19:30:00 | SPY | ETF | 124.74 | 124.74 | 124.73 | 124.73 | 900.0 |
| 2005-08-03 09:30:00 | QQQ | ETF | 39.91 | 39.95 | 39.88 | 39.89 | 7641700.0 |
| 2005-08-03 10:00:00 | QQQ | ETF | 39.89 | 39.97 | 39.88 | 39.95 | 8301700.0 |
| 2005-08-03 10:30:00 | QQQ | ETF | 39.94 | 40.04 | 39.89 | 39.97 | 6364500.0 |
| 2005-08-03 11:00:00 | QQQ | ETF | 39.97 | 40.01 | 39.92 | 39.98 | 3797400.0 |
| 2005-08-03 11:30:00 | QQQ | ETF | 39.98 | 40.0 | 39.94 | 39.98 | 2173400.0 |
| 2005-08-03 12:00:00 | QQQ | ETF | 39.98 | 40.11 | 39.97 | 40.1 | 4424900.0 |
| 2005-08-03 12:30:00 | QQQ | ETF | 40.1 | 40.13 | 40.05 | 40.06 | 4811600.0 |
| 2005-08-03 13:00:00 | QQQ | ETF | 40.06 | 40.09 | 40.04 | 40.08 | 1337600.0 |
| 2005-08-03 13:30:00 | QQQ | ETF | 40.08 | 40.11 | 40.03 | 40.08 | 2031600.0 |
| 2005-08-03 14:00:00 | QQQ | ETF | 40.08 | 40.11 | 39.96 | 39.97 | 3653200.0 |
| 2005-08-03 14:30:00 | QQQ | ETF | 39.98 | 40.03 | 39.94 | 39.99 | 5240000.0 |
| 2005-08-03 15:00:00 | QQQ | ETF | 40.0 | 40.04 | 39.94 | 40.01 | 3626700.0 |
| 2005-08-03 15:30:00 | QQQ | ETF | 40.01 | 40.07 | 39.99 | 40.06 | 4506500.0 |
| 2005-08-03 08:00:00 | IWM | ETF | 68.35 | 68.35 | 68.35 | 68.35 | 900.0 |
| 2005-08-03 08:30:00 | IWM | ETF | 68.29 | 68.29 | 68.29 | 68.29 | 1100.0 |
| 2005-08-03 09:00:00 | IWM | ETF | 68.24 | 68.25 | 68.2 | 68.24 | 25100.0 |
| 2005-08-03 09:30:00 | IWM | ETF | 68.15 | 68.25 | 68.07 | 68.08 | 1560000.0 |
| 2005-08-03 10:00:00 | IWM | ETF | 68.08 | 68.15 | 67.93 | 67.99 | 2615900.0 |
| 2005-08-03 10:30:00 | IWM | ETF | 67.98 | 68.08 | 67.87 | 67.98 | 2257900.0 |
| 2005-08-03 11:00:00 | IWM | ETF | 67.98 | 68.15 | 67.94 | 68.12 | 770900.0 |
| 2005-08-03 11:30:00 | IWM | ETF | 68.12 | 68.14 | 68.06 | 68.11 | 377900.0 |
| 2005-08-03 12:00:00 | IWM | ETF | 68.11 | 68.31 | 68.08 | 68.27 | 680300.0 |
| 2005-08-03 12:30:00 | IWM | ETF | 68.27 | 68.31 | 68.17 | 68.2 | 751600.0 |
| 2005-08-03 13:00:00 | IWM | ETF | 68.2 | 68.24 | 68.12 | 68.19 | 824700.0 |
> showing 50 of 1,623 rows — these rows as CSV