PREVIEW / etf_5min / 2005-01-03
file: by_date/etf_5min/2005/2005-01-03.parquet size: 131 KB rows: 6,565
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-01-03 08:00:00 | SPY | ETF | 121.6 | 121.6 | 121.54 | 121.55 | 24600.0 |
| 2005-01-03 08:05:00 | SPY | ETF | 121.55 | 121.55 | 121.53 | 121.53 | 12900.0 |
| 2005-01-03 08:10:00 | SPY | ETF | 121.52 | 121.52 | 121.52 | 121.52 | 5000.0 |
| 2005-01-03 08:15:00 | SPY | ETF | 121.53 | 121.53 | 121.53 | 121.53 | 2200.0 |
| 2005-01-03 08:20:00 | SPY | ETF | 121.53 | 121.54 | 121.53 | 121.54 | 6200.0 |
| 2005-01-03 08:25:00 | SPY | ETF | 121.55 | 121.57 | 121.55 | 121.56 | 92300.0 |
| 2005-01-03 08:30:00 | SPY | ETF | 121.57 | 121.6 | 121.57 | 121.58 | 277000.0 |
| 2005-01-03 08:35:00 | SPY | ETF | 121.54 | 121.54 | 121.54 | 121.54 | 2000.0 |
| 2005-01-03 08:40:00 | SPY | ETF | 121.54 | 121.54 | 121.53 | 121.53 | 1600.0 |
| 2005-01-03 08:45:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 100.0 |
| 2005-01-03 08:50:00 | SPY | ETF | 121.55 | 121.58 | 121.55 | 121.57 | 3000.0 |
| 2005-01-03 08:55:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 500.0 |
| 2005-01-03 09:00:00 | SPY | ETF | 121.54 | 121.62 | 121.54 | 121.61 | 15200.0 |
| 2005-01-03 09:05:00 | SPY | ETF | 121.6 | 121.6 | 121.58 | 121.59 | 1400.0 |
| 2005-01-03 09:10:00 | SPY | ETF | 121.57 | 121.57 | 121.56 | 121.57 | 3800.0 |
| 2005-01-03 09:15:00 | SPY | ETF | 121.57 | 121.57 | 121.5 | 121.5 | 175600.0 |
| 2005-01-03 09:20:00 | SPY | ETF | 121.51 | 121.51 | 121.45 | 121.45 | 25400.0 |
| 2005-01-03 09:25:00 | SPY | ETF | 121.47 | 121.56 | 121.47 | 121.56 | 26500.0 |
| 2005-01-03 09:30:00 | SPY | ETF | 121.56 | 121.66 | 121.49 | 121.63 | 1251700.0 |
| 2005-01-03 09:35:00 | SPY | ETF | 121.63 | 121.76 | 121.61 | 121.73 | 934900.0 |
| 2005-01-03 09:40:00 | SPY | ETF | 121.69 | 121.71 | 121.61 | 121.66 | 865500.0 |
| 2005-01-03 09:45:00 | SPY | ETF | 121.66 | 121.71 | 121.58 | 121.61 | 584700.0 |
| 2005-01-03 09:50:00 | SPY | ETF | 121.66 | 121.66 | 121.5 | 121.5 | 621600.0 |
| 2005-01-03 09:55:00 | SPY | ETF | 121.5 | 121.56 | 121.47 | 121.52 | 1715700.0 |
| 2005-01-03 10:00:00 | SPY | ETF | 121.53 | 121.64 | 121.28 | 121.29 | 1905400.0 |
| 2005-01-03 10:05:00 | SPY | ETF | 121.29 | 121.38 | 121.09 | 121.18 | 1276000.0 |
| 2005-01-03 10:10:00 | SPY | ETF | 121.18 | 121.53 | 121.15 | 121.18 | 1080400.0 |
| 2005-01-03 10:15:00 | SPY | ETF | 121.18 | 121.2 | 120.94 | 121.01 | 1332000.0 |
| 2005-01-03 10:20:00 | SPY | ETF | 121.01 | 121.11 | 120.96 | 120.98 | 1020500.0 |
| 2005-01-03 10:25:00 | SPY | ETF | 120.98 | 121.04 | 120.88 | 120.98 | 2129500.0 |
| 2005-01-03 10:30:00 | SPY | ETF | 120.98 | 121.06 | 120.87 | 120.91 | 1887300.0 |
| 2005-01-03 10:35:00 | SPY | ETF | 120.92 | 120.92 | 120.7 | 120.81 | 1667900.0 |
| 2005-01-03 10:40:00 | SPY | ETF | 120.81 | 120.85 | 120.79 | 120.8 | 843700.0 |
| 2005-01-03 10:45:00 | SPY | ETF | 120.8 | 120.85 | 120.73 | 120.83 | 768200.0 |
| 2005-01-03 10:50:00 | SPY | ETF | 120.84 | 120.9 | 120.8 | 120.86 | 766300.0 |
| 2005-01-03 10:55:00 | SPY | ETF | 120.87 | 121.2 | 120.79 | 120.84 | 1227600.0 |
| 2005-01-03 11:00:00 | SPY | ETF | 120.84 | 120.84 | 120.51 | 120.51 | 733900.0 |
| 2005-01-03 11:05:00 | SPY | ETF | 120.5 | 120.63 | 120.49 | 120.61 | 1126100.0 |
| 2005-01-03 11:10:00 | SPY | ETF | 120.61 | 120.67 | 120.6 | 120.65 | 995000.0 |
| 2005-01-03 11:15:00 | SPY | ETF | 120.65 | 120.67 | 120.6 | 120.65 | 213200.0 |
| 2005-01-03 11:20:00 | SPY | ETF | 120.65 | 120.72 | 120.54 | 120.68 | 488900.0 |
| 2005-01-03 11:25:00 | SPY | ETF | 120.69 | 120.73 | 120.66 | 120.71 | 212200.0 |
| 2005-01-03 11:30:00 | SPY | ETF | 120.71 | 120.79 | 120.68 | 120.78 | 359400.0 |
| 2005-01-03 11:35:00 | SPY | ETF | 120.78 | 120.83 | 120.69 | 120.77 | 303100.0 |
| 2005-01-03 11:40:00 | SPY | ETF | 120.77 | 121.56 | 120.77 | 120.86 | 454900.0 |
| 2005-01-03 11:45:00 | SPY | ETF | 120.86 | 120.9 | 120.85 | 120.87 | 374700.0 |
| 2005-01-03 11:50:00 | SPY | ETF | 120.86 | 120.9 | 120.83 | 120.89 | 421300.0 |
| 2005-01-03 11:55:00 | SPY | ETF | 120.89 | 120.89 | 120.82 | 120.83 | 218100.0 |
| 2005-01-03 12:00:00 | SPY | ETF | 120.83 | 120.84 | 120.74 | 120.74 | 328100.0 |
| 2005-01-03 12:05:00 | SPY | ETF | 120.74 | 120.8 | 120.71 | 120.79 | 270400.0 |
> showing 50 of 6,565 rows — these rows as CSV