PREVIEW / etf_5min / 2006-10-04
file: by_date/etf_5min/2006/2006-10-04.parquet size: 270 KB rows: 12,345
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-10-04 06:40:00 | SPY | ETF | 133.35 | 133.35 | 133.35 | 133.35 | 5000.0 |
| 2006-10-04 07:05:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 100.0 |
| 2006-10-04 07:10:00 | SPY | ETF | 133.65 | 133.67 | 133.65 | 133.67 | 2400.0 |
| 2006-10-04 07:15:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 500.0 |
| 2006-10-04 07:20:00 | SPY | ETF | 133.61 | 133.61 | 133.61 | 133.61 | 2000.0 |
| 2006-10-04 07:25:00 | SPY | ETF | 133.61 | 133.61 | 133.61 | 133.61 | 2400.0 |
| 2006-10-04 07:35:00 | SPY | ETF | 133.6 | 133.6 | 133.6 | 133.6 | 15500.0 |
| 2006-10-04 07:45:00 | SPY | ETF | 133.55 | 133.55 | 133.55 | 133.55 | 1000.0 |
| 2006-10-04 07:50:00 | SPY | ETF | 133.55 | 133.55 | 133.55 | 133.55 | 4900.0 |
| 2006-10-04 07:55:00 | SPY | ETF | 133.58 | 133.58 | 133.58 | 133.58 | 1100.0 |
| 2006-10-04 08:00:00 | SPY | ETF | 133.58 | 133.66 | 133.52 | 133.57 | 381500.0 |
| 2006-10-04 08:05:00 | SPY | ETF | 133.56 | 133.56 | 133.56 | 133.56 | 5000.0 |
| 2006-10-04 08:10:00 | SPY | ETF | 133.59 | 133.59 | 133.43 | 133.585 | 501600.0 |
| 2006-10-04 08:15:00 | SPY | ETF | 133.46 | 133.46 | 133.32 | 133.35 | 367600.0 |
| 2006-10-04 08:20:00 | SPY | ETF | 133.37 | 133.38 | 133.31 | 133.37 | 306700.0 |
| 2006-10-04 08:25:00 | SPY | ETF | 133.37 | 133.37 | 133.32 | 133.34 | 57100.0 |
| 2006-10-04 08:30:00 | SPY | ETF | 133.33 | 133.34 | 133.24 | 133.25 | 34300.0 |
| 2006-10-04 08:35:00 | SPY | ETF | 133.28 | 133.31 | 133.28 | 133.31 | 29000.0 |
| 2006-10-04 08:40:00 | SPY | ETF | 133.29 | 133.29 | 133.2 | 133.22 | 91600.0 |
| 2006-10-04 08:45:00 | SPY | ETF | 133.22 | 133.27 | 133.2 | 133.23 | 125600.0 |
| 2006-10-04 08:50:00 | SPY | ETF | 133.27 | 133.35 | 133.27 | 133.3 | 188700.0 |
| 2006-10-04 08:55:00 | SPY | ETF | 133.35 | 133.35 | 133.28 | 133.31 | 24900.0 |
| 2006-10-04 09:00:00 | SPY | ETF | 133.32 | 133.32 | 133.28 | 133.3 | 24000.0 |
| 2006-10-04 09:05:00 | SPY | ETF | 133.3 | 133.31 | 133.24 | 133.28 | 68200.0 |
| 2006-10-04 09:10:00 | SPY | ETF | 133.28 | 133.28 | 133.22 | 133.24 | 66100.0 |
| 2006-10-04 09:15:00 | SPY | ETF | 133.22 | 133.25 | 133.19 | 133.25 | 38800.0 |
| 2006-10-04 09:20:00 | SPY | ETF | 133.26 | 133.3 | 133.26 | 133.3 | 42200.0 |
| 2006-10-04 09:25:00 | SPY | ETF | 133.28 | 133.28 | 133.21 | 133.22 | 74800.0 |
| 2006-10-04 09:30:00 | SPY | ETF | 133.23 | 133.34 | 133.16 | 133.29 | 981500.0 |
| 2006-10-04 09:35:00 | SPY | ETF | 133.29 | 133.38 | 133.23 | 133.37 | 904800.0 |
| 2006-10-04 09:40:00 | SPY | ETF | 133.37 | 133.38 | 133.29 | 133.35 | 1291400.0 |
| 2006-10-04 09:45:00 | SPY | ETF | 133.35 | 133.41 | 133.28 | 133.3 | 1007000.0 |
| 2006-10-04 09:50:00 | SPY | ETF | 133.3 | 133.33 | 133.17 | 133.21 | 1084900.0 |
| 2006-10-04 09:55:00 | SPY | ETF | 133.2 | 133.27 | 133.15 | 133.26 | 447700.0 |
| 2006-10-04 10:00:00 | SPY | ETF | 133.26 | 133.28 | 133.08 | 133.19 | 1473300.0 |
| 2006-10-04 10:05:00 | SPY | ETF | 133.21 | 133.35 | 133.15 | 133.35 | 870200.0 |
| 2006-10-04 10:10:00 | SPY | ETF | 133.35 | 133.58 | 133.31 | 133.53 | 1477000.0 |
| 2006-10-04 10:15:00 | SPY | ETF | 133.51 | 133.63 | 133.51 | 133.55 | 1556300.0 |
| 2006-10-04 10:20:00 | SPY | ETF | 133.55 | 133.72 | 133.55 | 133.65 | 1491200.0 |
| 2006-10-04 10:25:00 | SPY | ETF | 133.65 | 133.75 | 133.65 | 133.67 | 1024400.0 |
| 2006-10-04 10:30:00 | SPY | ETF | 133.67 | 133.82 | 133.67 | 133.74 | 1515600.0 |
| 2006-10-04 10:35:00 | SPY | ETF | 133.74 | 133.76 | 133.64 | 133.66 | 601300.0 |
| 2006-10-04 10:40:00 | SPY | ETF | 133.67 | 133.73 | 133.6 | 133.63 | 395900.0 |
| 2006-10-04 10:45:00 | SPY | ETF | 133.63 | 133.74 | 133.62 | 133.67 | 628700.0 |
| 2006-10-04 10:50:00 | SPY | ETF | 133.67 | 133.7 | 133.6 | 133.61 | 337900.0 |
| 2006-10-04 10:55:00 | SPY | ETF | 133.6 | 133.7 | 133.59 | 133.66 | 560000.0 |
| 2006-10-04 11:00:00 | SPY | ETF | 133.65 | 133.69 | 133.57 | 133.58 | 361200.0 |
| 2006-10-04 11:05:00 | SPY | ETF | 133.58 | 133.62 | 133.54 | 133.59 | 509900.0 |
| 2006-10-04 11:10:00 | SPY | ETF | 133.59 | 133.65 | 133.53 | 133.54 | 401000.0 |
| 2006-10-04 11:15:00 | SPY | ETF | 133.55 | 133.7 | 133.53 | 133.64 | 264500.0 |
> showing 50 of 12,345 rows — these rows as CSV