PREVIEW / etf_30min / 2005-05-25
file: by_date/etf_30min/2005/2005-05-25.parquet size: 43 KB rows: 1,462
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-05-25 07:00:00 | SPY | ETF | 119.33 | 119.33 | 119.3 | 119.3 | 71900.0 |
| 2005-05-25 07:30:00 | SPY | ETF | 119.32 | 119.32 | 119.29 | 119.29 | 54000.0 |
| 2005-05-25 08:00:00 | SPY | ETF | 119.3 | 119.35 | 119.27 | 119.35 | 176800.0 |
| 2005-05-25 08:30:00 | SPY | ETF | 119.26 | 119.46 | 119.24 | 119.33 | 90000.0 |
| 2005-05-25 09:00:00 | SPY | ETF | 119.35 | 119.43 | 119.35 | 119.38 | 31200.0 |
| 2005-05-25 09:30:00 | SPY | ETF | 119.35 | 119.39 | 119.23 | 119.29 | 3935400.0 |
| 2005-05-25 10:00:00 | SPY | ETF | 119.29 | 119.34 | 118.98 | 119.12 | 6660900.0 |
| 2005-05-25 10:30:00 | SPY | ETF | 119.12 | 119.13 | 118.95 | 119.05 | 5593300.0 |
| 2005-05-25 11:00:00 | SPY | ETF | 119.06 | 119.3 | 118.91 | 119.05 | 3058900.0 |
| 2005-05-25 11:30:00 | SPY | ETF | 119.04 | 119.16 | 118.98 | 119.02 | 2521100.0 |
| 2005-05-25 12:00:00 | SPY | ETF | 119.03 | 119.16 | 119.01 | 119.0401 | 1308400.0 |
| 2005-05-25 12:30:00 | SPY | ETF | 119.05 | 119.16 | 119.04 | 119.05 | 1793600.0 |
| 2005-05-25 13:00:00 | SPY | ETF | 119.05 | 119.14 | 118.83 | 118.85 | 2584000.0 |
| 2005-05-25 13:30:00 | SPY | ETF | 118.84 | 119.05 | 118.84 | 119.0 | 2698000.0 |
| 2005-05-25 14:00:00 | SPY | ETF | 119.0 | 119.29 | 118.98 | 119.29 | 2378000.0 |
| 2005-05-25 14:30:00 | SPY | ETF | 119.29 | 119.47 | 119.17 | 119.3201 | 5510400.0 |
| 2005-05-25 15:00:00 | SPY | ETF | 119.32 | 119.42 | 119.19 | 119.27 | 2642200.0 |
| 2005-05-25 15:30:00 | SPY | ETF | 119.27 | 119.87 | 119.25 | 119.32 | 3500500.0 |
| 2005-05-25 16:00:00 | SPY | ETF | 119.36 | 119.45 | 119.13 | 119.42 | 609500.0 |
| 2005-05-25 16:30:00 | SPY | ETF | 119.42 | 119.51 | 119.41 | 119.44 | 159700.0 |
| 2005-05-25 17:00:00 | SPY | ETF | 119.51 | 119.52 | 119.44 | 119.49 | 80500.0 |
| 2005-05-25 17:30:00 | SPY | ETF | 119.48 | 119.49 | 119.48 | 119.49 | 500.0 |
| 2005-05-25 18:00:00 | SPY | ETF | 119.46 | 119.46 | 119.44 | 119.46 | 8100.0 |
| 2005-05-25 18:30:00 | SPY | ETF | 119.45 | 119.45 | 119.43 | 119.43 | 2100.0 |
| 2005-05-25 19:30:00 | SPY | ETF | 119.46 | 119.46 | 119.42 | 119.42 | 1700.0 |
| 2005-05-25 09:30:00 | QQQ | ETF | 37.84 | 37.87 | 37.81 | 37.86 | 9888600.0 |
| 2005-05-25 10:00:00 | QQQ | ETF | 37.86 | 37.88 | 37.72 | 37.79 | 8678300.0 |
| 2005-05-25 10:30:00 | QQQ | ETF | 37.79 | 37.79 | 37.66 | 37.71 | 10205100.0 |
| 2005-05-25 11:00:00 | QQQ | ETF | 37.7 | 37.72 | 37.65 | 37.72 | 4553000.0 |
| 2005-05-25 11:30:00 | QQQ | ETF | 37.71 | 37.75 | 37.66 | 37.69 | 2376700.0 |
| 2005-05-25 12:00:00 | QQQ | ETF | 37.69 | 37.74 | 37.69 | 37.7 | 2227500.0 |
| 2005-05-25 12:30:00 | QQQ | ETF | 37.7 | 37.72 | 37.68 | 37.69 | 1419800.0 |
| 2005-05-25 13:00:00 | QQQ | ETF | 37.69 | 37.7 | 37.62 | 37.62 | 2444400.0 |
| 2005-05-25 13:30:00 | QQQ | ETF | 37.62 | 37.67 | 37.59 | 37.65 | 4775900.0 |
| 2005-05-25 14:00:00 | QQQ | ETF | 37.64 | 37.71 | 37.64 | 37.71 | 4222800.0 |
| 2005-05-25 14:30:00 | QQQ | ETF | 37.72 | 37.75 | 37.68 | 37.73 | 5247900.0 |
| 2005-05-25 15:00:00 | QQQ | ETF | 37.72 | 37.82 | 37.71 | 37.78 | 6287900.0 |
| 2005-05-25 15:30:00 | QQQ | ETF | 37.78 | 37.85 | 37.77 | 37.81 | 8254400.0 |
| 2005-05-25 08:30:00 | IWM | ETF | 60.795 | 60.795 | 60.795 | 60.795 | 2000.0 |
| 2005-05-25 09:00:00 | IWM | ETF | 60.7 | 60.72 | 60.7 | 60.705 | 13200.0 |
| 2005-05-25 09:30:00 | IWM | ETF | 60.77 | 60.8 | 60.535 | 60.575 | 1739000.0 |
| 2005-05-25 10:00:00 | IWM | ETF | 60.575 | 60.575 | 60.245 | 60.26 | 4262400.0 |
| 2005-05-25 10:30:00 | IWM | ETF | 60.265 | 60.265 | 60.15 | 60.225 | 1700600.0 |
| 2005-05-25 11:00:00 | IWM | ETF | 60.225 | 60.29 | 60.2 | 60.255 | 1255000.0 |
| 2005-05-25 11:30:00 | IWM | ETF | 60.25 | 60.33 | 60.24 | 60.28 | 796000.0 |
| 2005-05-25 12:00:00 | IWM | ETF | 60.28 | 60.37 | 60.275 | 60.34 | 363600.0 |
| 2005-05-25 12:30:00 | IWM | ETF | 60.345 | 60.455 | 60.33 | 60.4 | 2174200.0 |
| 2005-05-25 13:00:00 | IWM | ETF | 60.4 | 60.45 | 60.255 | 60.255 | 1260400.0 |
| 2005-05-25 13:30:00 | IWM | ETF | 60.26 | 60.375 | 60.235 | 60.34 | 1037000.0 |
| 2005-05-25 14:00:00 | IWM | ETF | 60.345 | 60.525 | 60.335 | 60.525 | 768600.0 |
> showing 50 of 1,462 rows — these rows as CSV