PREVIEW / etf_5min / 2006-02-22
file: by_date/etf_5min/2006/2006-02-22.parquet size: 176 KB rows: 9,176
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-22 06:00:00 | SPY | ETF | 128.41 | 128.41 | 128.41 | 128.41 | 2000.0 |
| 2006-02-22 07:25:00 | SPY | ETF | 128.63 | 128.63 | 128.63 | 128.63 | 100.0 |
| 2006-02-22 07:30:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 1000.0 |
| 2006-02-22 07:35:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 300.0 |
| 2006-02-22 07:45:00 | SPY | ETF | 128.66 | 128.66 | 128.66 | 128.66 | 2500.0 |
| 2006-02-22 07:50:00 | SPY | ETF | 128.68 | 128.71 | 128.68 | 128.71 | 14400.0 |
| 2006-02-22 08:00:00 | SPY | ETF | 128.44 | 128.71 | 128.44 | 128.68 | 100600.0 |
| 2006-02-22 08:05:00 | SPY | ETF | 128.69 | 128.69 | 128.69 | 128.69 | 100.0 |
| 2006-02-22 08:10:00 | SPY | ETF | 128.62 | 128.63 | 128.6 | 128.6 | 100600.0 |
| 2006-02-22 08:15:00 | SPY | ETF | 128.64 | 128.67 | 128.61 | 128.61 | 201000.0 |
| 2006-02-22 08:20:00 | SPY | ETF | 128.6 | 128.71 | 128.6 | 128.71 | 205400.0 |
| 2006-02-22 08:25:00 | SPY | ETF | 128.59 | 128.6 | 128.57 | 128.57 | 31900.0 |
| 2006-02-22 08:30:00 | SPY | ETF | 128.57 | 128.75 | 128.5 | 128.7 | 558900.0 |
| 2006-02-22 08:35:00 | SPY | ETF | 128.69 | 128.78 | 128.69 | 128.76 | 234800.0 |
| 2006-02-22 08:40:00 | SPY | ETF | 128.77 | 128.79 | 128.69 | 128.77 | 33000.0 |
| 2006-02-22 08:45:00 | SPY | ETF | 128.77 | 128.81 | 128.77 | 128.78 | 333700.0 |
| 2006-02-22 08:50:00 | SPY | ETF | 128.78 | 128.82 | 128.78 | 128.81 | 60000.0 |
| 2006-02-22 08:55:00 | SPY | ETF | 128.8 | 128.835 | 128.8 | 128.8 | 47300.0 |
| 2006-02-22 09:00:00 | SPY | ETF | 128.8 | 128.81 | 128.77 | 128.77 | 36900.0 |
| 2006-02-22 09:05:00 | SPY | ETF | 128.76 | 128.76 | 128.73 | 128.73 | 5800.0 |
| 2006-02-22 09:10:00 | SPY | ETF | 128.73 | 128.8 | 128.73 | 128.8 | 10900.0 |
| 2006-02-22 09:15:00 | SPY | ETF | 128.79 | 128.79 | 128.77 | 128.77 | 10200.0 |
| 2006-02-22 09:20:00 | SPY | ETF | 128.79 | 128.81 | 128.77 | 128.79 | 67000.0 |
| 2006-02-22 09:25:00 | SPY | ETF | 128.79 | 128.8 | 128.77 | 128.78 | 7100.0 |
| 2006-02-22 09:30:00 | SPY | ETF | 128.77 | 128.8 | 128.7 | 128.76 | 562600.0 |
| 2006-02-22 09:35:00 | SPY | ETF | 128.76 | 128.89 | 128.67 | 128.87 | 788400.0 |
| 2006-02-22 09:40:00 | SPY | ETF | 128.88 | 128.91 | 128.84 | 128.86 | 789300.0 |
| 2006-02-22 09:45:00 | SPY | ETF | 128.89 | 128.96 | 128.8118 | 128.85 | 922400.0 |
| 2006-02-22 09:50:00 | SPY | ETF | 128.85 | 128.87 | 128.74 | 128.8 | 446700.0 |
| 2006-02-22 09:55:00 | SPY | ETF | 128.79 | 128.84 | 128.73 | 128.7612 | 1353400.0 |
| 2006-02-22 10:00:00 | SPY | ETF | 128.78 | 128.87 | 128.65 | 128.86 | 1141600.0 |
| 2006-02-22 10:05:00 | SPY | ETF | 128.87 | 129.01 | 128.82 | 128.89 | 820200.0 |
| 2006-02-22 10:10:00 | SPY | ETF | 128.88 | 128.95 | 128.84 | 128.91 | 432600.0 |
| 2006-02-22 10:15:00 | SPY | ETF | 128.9 | 128.98 | 128.84 | 128.93 | 738100.0 |
| 2006-02-22 10:20:00 | SPY | ETF | 128.94 | 129.1 | 128.93 | 129.02 | 1224400.0 |
| 2006-02-22 10:25:00 | SPY | ETF | 129.02 | 129.06 | 128.93 | 128.93 | 710600.0 |
| 2006-02-22 10:30:00 | SPY | ETF | 128.94 | 129.02 | 128.91 | 128.96 | 317300.0 |
| 2006-02-22 10:35:00 | SPY | ETF | 128.96 | 129.06 | 128.92 | 128.97 | 471800.0 |
| 2006-02-22 10:40:00 | SPY | ETF | 128.97 | 129.05 | 128.91 | 128.92 | 339600.0 |
| 2006-02-22 10:45:00 | SPY | ETF | 128.9193 | 128.99 | 128.89 | 128.9 | 125600.0 |
| 2006-02-22 10:50:00 | SPY | ETF | 128.9 | 129.02 | 128.9 | 129.0 | 336500.0 |
| 2006-02-22 10:55:00 | SPY | ETF | 129.0 | 129.1 | 128.99 | 129.08 | 449300.0 |
| 2006-02-22 11:00:00 | SPY | ETF | 129.08 | 129.16 | 129.07 | 129.11 | 381400.0 |
| 2006-02-22 11:05:00 | SPY | ETF | 129.09 | 129.11 | 129.04 | 129.07 | 207000.0 |
| 2006-02-22 11:10:00 | SPY | ETF | 129.07 | 129.13 | 129.06 | 129.06 | 200600.0 |
| 2006-02-22 11:15:00 | SPY | ETF | 129.07 | 129.12 | 129.05 | 129.07 | 291600.0 |
| 2006-02-22 11:20:00 | SPY | ETF | 129.07 | 129.37 | 129.06 | 129.31 | 1719700.0 |
| 2006-02-22 11:25:00 | SPY | ETF | 129.31 | 129.41 | 129.27 | 129.33 | 921800.0 |
| 2006-02-22 11:30:00 | SPY | ETF | 129.34 | 129.47 | 129.31 | 129.34 | 964400.0 |
| 2006-02-22 11:35:00 | SPY | ETF | 129.34 | 129.41 | 129.3 | 129.35 | 461000.0 |
> showing 50 of 9,176 rows — these rows as CSV