PREVIEW / etf_5min / 2006-08-03
file: by_date/etf_5min/2006/2006-08-03.parquet size: 220 KB rows: 10,381
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-03 04:15:00 | SPY | ETF | 127.74 | 127.74 | 127.74 | 127.74 | 1200.0 |
| 2006-08-03 05:15:00 | SPY | ETF | 127.75 | 127.75 | 127.75 | 127.75 | 100.0 |
| 2006-08-03 07:00:00 | SPY | ETF | 127.66 | 127.66 | 127.66 | 127.66 | 10300.0 |
| 2006-08-03 07:10:00 | SPY | ETF | 127.62 | 127.62 | 127.62 | 127.62 | 1500.0 |
| 2006-08-03 07:15:00 | SPY | ETF | 127.61 | 127.64 | 127.56 | 127.59 | 57600.0 |
| 2006-08-03 07:20:00 | SPY | ETF | 127.56 | 127.59 | 127.47 | 127.47 | 14900.0 |
| 2006-08-03 07:25:00 | SPY | ETF | 127.57 | 127.57 | 127.57 | 127.57 | 26000.0 |
| 2006-08-03 07:30:00 | SPY | ETF | 127.5 | 127.5 | 127.44 | 127.47 | 63100.0 |
| 2006-08-03 07:35:00 | SPY | ETF | 127.5 | 127.5 | 127.5 | 127.5 | 3500.0 |
| 2006-08-03 07:40:00 | SPY | ETF | 127.55 | 127.55 | 127.52 | 127.55 | 3800.0 |
| 2006-08-03 07:45:00 | SPY | ETF | 127.54 | 127.57 | 127.54 | 127.57 | 2500.0 |
| 2006-08-03 07:50:00 | SPY | ETF | 127.57 | 127.57 | 127.57 | 127.57 | 400.0 |
| 2006-08-03 08:00:00 | SPY | ETF | 127.58 | 127.69 | 127.44 | 127.57 | 343800.0 |
| 2006-08-03 08:05:00 | SPY | ETF | 127.57 | 127.59 | 127.56 | 127.57 | 76500.0 |
| 2006-08-03 08:10:00 | SPY | ETF | 127.57 | 127.57 | 127.52 | 127.52 | 28500.0 |
| 2006-08-03 08:15:00 | SPY | ETF | 127.52 | 127.57 | 127.5 | 127.51 | 53000.0 |
| 2006-08-03 08:20:00 | SPY | ETF | 127.5 | 127.52 | 127.49 | 127.52 | 29400.0 |
| 2006-08-03 08:25:00 | SPY | ETF | 127.53 | 127.54 | 127.47 | 127.48 | 55900.0 |
| 2006-08-03 08:30:00 | SPY | ETF | 127.47 | 127.49 | 127.43 | 127.43 | 88800.0 |
| 2006-08-03 08:35:00 | SPY | ETF | 127.42 | 127.42 | 127.37 | 127.4 | 176500.0 |
| 2006-08-03 08:40:00 | SPY | ETF | 127.38 | 127.38 | 127.25 | 127.25 | 207400.0 |
| 2006-08-03 08:45:00 | SPY | ETF | 127.27 | 127.32 | 127.23 | 127.3 | 505900.0 |
| 2006-08-03 08:50:00 | SPY | ETF | 127.3 | 127.38 | 127.29 | 127.38 | 463200.0 |
| 2006-08-03 08:55:00 | SPY | ETF | 127.38 | 127.4 | 127.37 | 127.38 | 149000.0 |
| 2006-08-03 09:00:00 | SPY | ETF | 127.38 | 127.4 | 127.37 | 127.39 | 87500.0 |
| 2006-08-03 09:05:00 | SPY | ETF | 127.38 | 127.38 | 127.3 | 127.33 | 76200.0 |
| 2006-08-03 09:10:00 | SPY | ETF | 127.33 | 127.35 | 127.32 | 127.35 | 345600.0 |
| 2006-08-03 09:15:00 | SPY | ETF | 127.38 | 127.4 | 127.32 | 127.32 | 306100.0 |
| 2006-08-03 09:20:00 | SPY | ETF | 127.33 | 127.36 | 127.32 | 127.34 | 88000.0 |
| 2006-08-03 09:25:00 | SPY | ETF | 127.34 | 127.35 | 127.26 | 127.33 | 106400.0 |
| 2006-08-03 09:30:00 | SPY | ETF | 127.33 | 127.36 | 127.15 | 127.26 | 1340600.0 |
| 2006-08-03 09:35:00 | SPY | ETF | 127.28 | 127.36 | 127.2 | 127.32 | 1245100.0 |
| 2006-08-03 09:40:00 | SPY | ETF | 127.32 | 127.44 | 127.29 | 127.41 | 2136500.0 |
| 2006-08-03 09:45:00 | SPY | ETF | 127.41 | 127.51 | 127.4 | 127.42 | 995500.0 |
| 2006-08-03 09:50:00 | SPY | ETF | 127.43 | 127.46 | 127.37 | 127.42 | 976900.0 |
| 2006-08-03 09:55:00 | SPY | ETF | 127.42 | 127.47 | 127.4 | 127.44 | 845000.0 |
| 2006-08-03 10:00:00 | SPY | ETF | 127.4495 | 127.55 | 127.36 | 127.51 | 1723600.0 |
| 2006-08-03 10:05:00 | SPY | ETF | 127.48 | 127.54 | 127.36 | 127.42 | 762800.0 |
| 2006-08-03 10:10:00 | SPY | ETF | 127.42 | 127.5 | 127.36 | 127.47 | 493100.0 |
| 2006-08-03 10:15:00 | SPY | ETF | 127.47 | 127.68 | 127.39 | 127.68 | 991900.0 |
| 2006-08-03 10:20:00 | SPY | ETF | 127.63 | 127.74 | 127.61 | 127.69 | 1255100.0 |
| 2006-08-03 10:25:00 | SPY | ETF | 127.69 | 127.73 | 127.6 | 127.66 | 835900.0 |
| 2006-08-03 10:30:00 | SPY | ETF | 127.6605 | 127.6605 | 127.53 | 127.58 | 739600.0 |
| 2006-08-03 10:35:00 | SPY | ETF | 127.57 | 127.62 | 127.48 | 127.53 | 639800.0 |
| 2006-08-03 10:40:00 | SPY | ETF | 127.52 | 127.71 | 127.51 | 127.63 | 1311700.0 |
| 2006-08-03 10:45:00 | SPY | ETF | 127.65 | 127.66 | 127.55 | 127.59 | 363700.0 |
| 2006-08-03 10:50:00 | SPY | ETF | 127.6 | 127.72 | 127.56 | 127.63 | 425100.0 |
| 2006-08-03 10:55:00 | SPY | ETF | 127.63 | 127.83 | 127.6 | 127.81 | 1445800.0 |
| 2006-08-03 11:00:00 | SPY | ETF | 127.81 | 127.94 | 127.78 | 127.89 | 1287400.0 |
| 2006-08-03 11:05:00 | SPY | ETF | 127.89 | 127.9 | 127.77 | 127.79 | 709000.0 |
> showing 50 of 10,381 rows — these rows as CSV