PREVIEW / etf_5min / 2006-04-06
file: by_date/etf_5min/2006/2006-04-06.parquet size: 174 KB rows: 9,127
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-04-06 06:15:00 | SPY | ETF | 131.07 | 131.07 | 131.07 | 131.07 | 4000.0 |
| 2006-04-06 06:20:00 | SPY | ETF | 131.07 | 131.07 | 131.07 | 131.07 | 3000.0 |
| 2006-04-06 07:05:00 | SPY | ETF | 130.93 | 130.94 | 130.93 | 130.94 | 6500.0 |
| 2006-04-06 07:10:00 | SPY | ETF | 130.94 | 130.95 | 130.94 | 130.95 | 15500.0 |
| 2006-04-06 07:15:00 | SPY | ETF | 130.91 | 130.91 | 130.91 | 130.91 | 1000.0 |
| 2006-04-06 07:30:00 | SPY | ETF | 130.95 | 130.95 | 130.95 | 130.95 | 4000.0 |
| 2006-04-06 07:40:00 | SPY | ETF | 130.92 | 130.92 | 130.92 | 130.92 | 2000.0 |
| 2006-04-06 07:45:00 | SPY | ETF | 130.94 | 130.94 | 130.92 | 130.92 | 17500.0 |
| 2006-04-06 07:50:00 | SPY | ETF | 130.95 | 130.95 | 130.94 | 130.94 | 400.0 |
| 2006-04-06 08:00:00 | SPY | ETF | 130.96 | 131.0 | 130.92 | 130.97 | 530800.0 |
| 2006-04-06 08:05:00 | SPY | ETF | 130.97 | 130.97 | 130.92 | 130.92 | 1400.0 |
| 2006-04-06 08:10:00 | SPY | ETF | 130.92 | 130.95 | 130.92 | 130.94 | 1300.0 |
| 2006-04-06 08:15:00 | SPY | ETF | 130.94 | 130.95 | 130.94 | 130.95 | 25500.0 |
| 2006-04-06 08:20:00 | SPY | ETF | 130.94 | 130.94 | 130.9 | 130.93 | 54000.0 |
| 2006-04-06 08:25:00 | SPY | ETF | 130.94 | 130.96 | 130.91 | 130.91 | 8500.0 |
| 2006-04-06 08:30:00 | SPY | ETF | 130.95 | 130.98 | 130.94 | 130.95 | 218200.0 |
| 2006-04-06 08:35:00 | SPY | ETF | 130.91 | 130.92 | 130.87 | 130.92 | 164900.0 |
| 2006-04-06 08:40:00 | SPY | ETF | 130.92 | 130.96 | 130.92 | 130.96 | 53000.0 |
| 2006-04-06 08:45:00 | SPY | ETF | 130.96 | 131.03 | 130.96 | 130.96 | 6100.0 |
| 2006-04-06 08:50:00 | SPY | ETF | 130.95 | 130.95 | 130.95 | 130.95 | 600.0 |
| 2006-04-06 08:55:00 | SPY | ETF | 130.95 | 130.95 | 130.94 | 130.94 | 1500.0 |
| 2006-04-06 09:00:00 | SPY | ETF | 130.96 | 130.97 | 130.92 | 130.97 | 223500.0 |
| 2006-04-06 09:05:00 | SPY | ETF | 130.98 | 130.98 | 130.95 | 130.97 | 8700.0 |
| 2006-04-06 09:10:00 | SPY | ETF | 130.97 | 130.97 | 130.86 | 130.9 | 18400.0 |
| 2006-04-06 09:15:00 | SPY | ETF | 130.86 | 130.9 | 130.86 | 130.89 | 36600.0 |
| 2006-04-06 09:20:00 | SPY | ETF | 130.9 | 130.91 | 130.88 | 130.91 | 411700.0 |
| 2006-04-06 09:25:00 | SPY | ETF | 130.91 | 130.91 | 130.85 | 130.85 | 73100.0 |
| 2006-04-06 09:30:00 | SPY | ETF | 130.85 | 130.97 | 130.79 | 130.82 | 1525400.0 |
| 2006-04-06 09:35:00 | SPY | ETF | 130.81 | 130.95 | 130.75 | 130.9 | 486000.0 |
| 2006-04-06 09:40:00 | SPY | ETF | 130.89 | 130.99 | 130.86 | 130.96 | 774800.0 |
| 2006-04-06 09:45:00 | SPY | ETF | 130.95 | 131.01 | 130.93 | 130.97 | 785800.0 |
| 2006-04-06 09:50:00 | SPY | ETF | 130.95 | 131.0 | 130.87 | 130.88 | 746800.0 |
| 2006-04-06 09:55:00 | SPY | ETF | 130.89 | 130.92 | 130.81 | 130.89 | 549200.0 |
| 2006-04-06 10:00:00 | SPY | ETF | 130.89 | 130.98 | 130.83 | 130.93 | 464500.0 |
| 2006-04-06 10:05:00 | SPY | ETF | 130.94 | 130.95 | 130.8 | 130.9 | 644800.0 |
| 2006-04-06 10:10:00 | SPY | ETF | 130.9 | 130.94 | 130.84 | 130.9 | 568800.0 |
| 2006-04-06 10:15:00 | SPY | ETF | 130.9 | 130.95 | 130.88 | 130.9 | 309600.0 |
| 2006-04-06 10:20:00 | SPY | ETF | 130.9 | 130.91 | 130.74 | 130.75 | 560800.0 |
| 2006-04-06 10:25:00 | SPY | ETF | 130.75 | 130.8 | 130.71 | 130.72 | 664200.0 |
| 2006-04-06 10:30:00 | SPY | ETF | 130.72 | 130.77 | 130.62 | 130.65 | 700900.0 |
| 2006-04-06 10:35:00 | SPY | ETF | 130.64 | 130.7 | 130.57 | 130.68 | 1980900.0 |
| 2006-04-06 10:40:00 | SPY | ETF | 130.69 | 130.74 | 130.65 | 130.74 | 1631600.0 |
| 2006-04-06 10:45:00 | SPY | ETF | 130.74 | 130.77 | 130.7 | 130.76 | 970900.0 |
| 2006-04-06 10:50:00 | SPY | ETF | 130.76 | 130.82 | 130.69 | 130.76 | 550700.0 |
| 2006-04-06 10:55:00 | SPY | ETF | 130.76 | 130.8 | 130.69 | 130.75 | 629700.0 |
| 2006-04-06 11:00:00 | SPY | ETF | 130.75 | 130.79 | 130.71 | 130.71 | 349600.0 |
| 2006-04-06 11:05:00 | SPY | ETF | 130.71 | 130.83 | 130.71 | 130.8 | 308600.0 |
| 2006-04-06 11:10:00 | SPY | ETF | 130.8 | 130.93 | 130.8 | 130.86 | 486100.0 |
| 2006-04-06 11:15:00 | SPY | ETF | 130.86 | 130.87 | 130.76 | 130.81 | 215800.0 |
| 2006-04-06 11:20:00 | SPY | ETF | 130.82 | 130.82 | 130.73 | 130.75 | 776000.0 |
> showing 50 of 9,127 rows — these rows as CSV