PREVIEW / etf_5min / 2006-08-25
file: by_date/etf_5min/2006/2006-08-25.parquet size: 194 KB rows: 9,964
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-08-25 07:00:00 | SPY | ETF | 129.77 | 129.77 | 129.77 | 129.77 | 500.0 |
| 2006-08-25 07:20:00 | SPY | ETF | 129.82 | 129.85 | 129.8 | 129.8 | 4000.0 |
| 2006-08-25 07:45:00 | SPY | ETF | 129.78 | 129.78 | 129.73 | 129.78 | 87900.0 |
| 2006-08-25 07:50:00 | SPY | ETF | 129.74 | 129.74 | 129.69 | 129.74 | 49000.0 |
| 2006-08-25 07:55:00 | SPY | ETF | 129.73 | 129.73 | 129.73 | 129.73 | 5000.0 |
| 2006-08-25 08:00:00 | SPY | ETF | 129.74 | 129.82 | 129.71 | 129.73 | 69600.0 |
| 2006-08-25 08:05:00 | SPY | ETF | 129.76 | 129.76 | 129.76 | 129.76 | 2000.0 |
| 2006-08-25 08:10:00 | SPY | ETF | 129.74 | 129.74 | 129.73 | 129.73 | 30500.0 |
| 2006-08-25 08:15:00 | SPY | ETF | 129.74 | 129.79 | 129.74 | 129.79 | 1100.0 |
| 2006-08-25 08:20:00 | SPY | ETF | 129.77 | 129.77 | 129.74 | 129.74 | 12100.0 |
| 2006-08-25 08:25:00 | SPY | ETF | 129.72 | 129.75 | 129.72 | 129.74 | 5600.0 |
| 2006-08-25 08:30:00 | SPY | ETF | 129.74 | 129.75 | 129.73 | 129.74 | 7300.0 |
| 2006-08-25 08:35:00 | SPY | ETF | 129.77 | 129.79 | 129.75 | 129.79 | 231500.0 |
| 2006-08-25 08:40:00 | SPY | ETF | 129.79 | 129.8 | 129.79 | 129.8 | 211000.0 |
| 2006-08-25 08:45:00 | SPY | ETF | 129.79 | 129.79 | 129.79 | 129.79 | 5500.0 |
| 2006-08-25 08:50:00 | SPY | ETF | 129.78 | 129.79 | 129.73 | 129.76 | 83200.0 |
| 2006-08-25 08:55:00 | SPY | ETF | 129.76 | 129.76 | 129.76 | 129.76 | 100.0 |
| 2006-08-25 09:00:00 | SPY | ETF | 129.74 | 129.74 | 129.64 | 129.64 | 120700.0 |
| 2006-08-25 09:05:00 | SPY | ETF | 129.63 | 129.66 | 129.6 | 129.62 | 51300.0 |
| 2006-08-25 09:10:00 | SPY | ETF | 129.6 | 129.63 | 129.6 | 129.63 | 8200.0 |
| 2006-08-25 09:15:00 | SPY | ETF | 129.63 | 129.63 | 129.62 | 129.62 | 1100.0 |
| 2006-08-25 09:20:00 | SPY | ETF | 129.62 | 129.62 | 129.61 | 129.61 | 1200.0 |
| 2006-08-25 09:25:00 | SPY | ETF | 129.65 | 129.66 | 129.64 | 129.64 | 15700.0 |
| 2006-08-25 09:30:00 | SPY | ETF | 129.64 | 129.73 | 129.55 | 129.6 | 837900.0 |
| 2006-08-25 09:35:00 | SPY | ETF | 129.59 | 129.65 | 129.58 | 129.61 | 857700.0 |
| 2006-08-25 09:40:00 | SPY | ETF | 129.61 | 129.7 | 129.55 | 129.69 | 920100.0 |
| 2006-08-25 09:45:00 | SPY | ETF | 129.7 | 129.75 | 129.67 | 129.73 | 565800.0 |
| 2006-08-25 09:50:00 | SPY | ETF | 129.73 | 129.8 | 129.67 | 129.8 | 698900.0 |
| 2006-08-25 09:55:00 | SPY | ETF | 129.8 | 129.94 | 129.78 | 129.88 | 2002400.0 |
| 2006-08-25 10:00:00 | SPY | ETF | 129.88 | 130.05 | 129.77 | 129.98 | 2581700.0 |
| 2006-08-25 10:05:00 | SPY | ETF | 129.98 | 130.25 | 129.95 | 130.07 | 2687900.0 |
| 2006-08-25 10:10:00 | SPY | ETF | 130.07 | 130.15 | 130.04 | 130.14 | 1056100.0 |
| 2006-08-25 10:15:00 | SPY | ETF | 130.13 | 130.23 | 130.06 | 130.07 | 977100.0 |
| 2006-08-25 10:20:00 | SPY | ETF | 130.07 | 130.12 | 130.01 | 130.03 | 765300.0 |
| 2006-08-25 10:25:00 | SPY | ETF | 130.03 | 130.04 | 129.95 | 130.01 | 1469400.0 |
| 2006-08-25 10:30:00 | SPY | ETF | 130.02 | 130.04 | 129.9 | 129.9 | 1276700.0 |
| 2006-08-25 10:35:00 | SPY | ETF | 129.9 | 129.98 | 129.88 | 129.91 | 1896300.0 |
| 2006-08-25 10:40:00 | SPY | ETF | 129.92 | 129.97 | 129.87 | 129.95 | 489100.0 |
| 2006-08-25 10:45:00 | SPY | ETF | 129.94 | 129.95 | 129.87 | 129.9 | 566000.0 |
| 2006-08-25 10:50:00 | SPY | ETF | 129.9 | 130.0 | 129.89 | 129.91 | 297500.0 |
| 2006-08-25 10:55:00 | SPY | ETF | 129.92 | 129.94 | 129.83 | 129.86 | 592000.0 |
| 2006-08-25 11:00:00 | SPY | ETF | 129.86 | 129.86 | 129.77 | 129.7995 | 1460100.0 |
| 2006-08-25 11:05:00 | SPY | ETF | 129.79 | 129.82 | 129.72 | 129.81 | 934800.0 |
| 2006-08-25 11:10:00 | SPY | ETF | 129.8 | 129.9 | 129.77 | 129.85 | 226500.0 |
| 2006-08-25 11:15:00 | SPY | ETF | 129.85 | 129.86 | 129.78 | 129.8 | 226800.0 |
| 2006-08-25 11:20:00 | SPY | ETF | 129.8 | 129.84 | 129.79 | 129.83 | 85000.0 |
| 2006-08-25 11:25:00 | SPY | ETF | 129.84 | 129.86 | 129.8 | 129.82 | 242900.0 |
| 2006-08-25 11:30:00 | SPY | ETF | 129.82 | 129.82 | 129.65 | 129.68 | 1084200.0 |
| 2006-08-25 11:35:00 | SPY | ETF | 129.68 | 129.6901 | 129.61 | 129.62 | 777300.0 |
| 2006-08-25 11:40:00 | SPY | ETF | 129.62 | 129.7 | 129.61 | 129.68 | 361500.0 |
> showing 50 of 9,964 rows — these rows as CSV