PREVIEW / etf_5min / 2006-02-27
file: by_date/etf_5min/2006/2006-02-27.parquet size: 165 KB rows: 9,160
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-27 05:50:00 | SPY | ETF | 129.49 | 129.49 | 129.49 | 129.49 | 25000.0 |
| 2006-02-27 06:55:00 | SPY | ETF | 129.41 | 129.41 | 129.39 | 129.39 | 50000.0 |
| 2006-02-27 07:00:00 | SPY | ETF | 129.36 | 129.36 | 129.36 | 129.36 | 2000.0 |
| 2006-02-27 07:40:00 | SPY | ETF | 129.38 | 129.38 | 129.37 | 129.37 | 8000.0 |
| 2006-02-27 07:45:00 | SPY | ETF | 129.35 | 129.35 | 129.33 | 129.33 | 4600.0 |
| 2006-02-27 07:50:00 | SPY | ETF | 129.36 | 129.36 | 129.36 | 129.36 | 300.0 |
| 2006-02-27 07:55:00 | SPY | ETF | 129.32 | 129.32 | 129.32 | 129.32 | 100.0 |
| 2006-02-27 08:00:00 | SPY | ETF | 129.35 | 129.39 | 129.33 | 129.35 | 39100.0 |
| 2006-02-27 08:05:00 | SPY | ETF | 129.38 | 129.39 | 129.35 | 129.38 | 2900.0 |
| 2006-02-27 08:10:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 300.0 |
| 2006-02-27 08:20:00 | SPY | ETF | 129.39 | 129.39 | 129.39 | 129.39 | 5000.0 |
| 2006-02-27 08:25:00 | SPY | ETF | 129.41 | 129.41 | 129.41 | 129.41 | 500.0 |
| 2006-02-27 08:30:00 | SPY | ETF | 129.41 | 129.42 | 129.41 | 129.42 | 5100.0 |
| 2006-02-27 08:35:00 | SPY | ETF | 129.41 | 129.48 | 129.41 | 129.45 | 71700.0 |
| 2006-02-27 08:40:00 | SPY | ETF | 129.47 | 129.47 | 129.45 | 129.47 | 4700.0 |
| 2006-02-27 08:45:00 | SPY | ETF | 129.47 | 129.47 | 129.47 | 129.47 | 4500.0 |
| 2006-02-27 08:50:00 | SPY | ETF | 129.47 | 129.51 | 129.47 | 129.5 | 56400.0 |
| 2006-02-27 08:55:00 | SPY | ETF | 129.47 | 129.5 | 129.47 | 129.49 | 8900.0 |
| 2006-02-27 09:00:00 | SPY | ETF | 129.48 | 129.49 | 129.47 | 129.47 | 6600.0 |
| 2006-02-27 09:05:00 | SPY | ETF | 129.48 | 129.49 | 129.48 | 129.49 | 156600.0 |
| 2006-02-27 09:10:00 | SPY | ETF | 129.46 | 129.47 | 129.44 | 129.44 | 105200.0 |
| 2006-02-27 09:15:00 | SPY | ETF | 129.44 | 129.46 | 129.44 | 129.46 | 2700.0 |
| 2006-02-27 09:20:00 | SPY | ETF | 129.46 | 129.46 | 129.44 | 129.44 | 4800.0 |
| 2006-02-27 09:25:00 | SPY | ETF | 129.43 | 129.44 | 129.25 | 129.41 | 259700.0 |
| 2006-02-27 09:30:00 | SPY | ETF | 129.4 | 129.42 | 129.28 | 129.38 | 1161600.0 |
| 2006-02-27 09:35:00 | SPY | ETF | 129.38 | 129.52 | 129.37 | 129.46 | 1219700.0 |
| 2006-02-27 09:40:00 | SPY | ETF | 129.46 | 129.62 | 129.4 | 129.61 | 639400.0 |
| 2006-02-27 09:45:00 | SPY | ETF | 129.61 | 129.69 | 129.59 | 129.65 | 2536400.0 |
| 2006-02-27 09:50:00 | SPY | ETF | 129.65 | 129.67 | 129.56 | 129.62 | 484300.0 |
| 2006-02-27 09:55:00 | SPY | ETF | 129.62 | 129.71 | 129.59 | 129.68 | 362700.0 |
| 2006-02-27 10:00:00 | SPY | ETF | 129.67 | 129.85 | 129.66 | 129.7 | 1399500.0 |
| 2006-02-27 10:05:00 | SPY | ETF | 129.7 | 129.72 | 129.6 | 129.62 | 605800.0 |
| 2006-02-27 10:10:00 | SPY | ETF | 129.63 | 129.64 | 129.53 | 129.58 | 730500.0 |
| 2006-02-27 10:15:00 | SPY | ETF | 129.59 | 129.61 | 129.41 | 129.45 | 565200.0 |
| 2006-02-27 10:20:00 | SPY | ETF | 129.45 | 129.61 | 129.44 | 129.57 | 819400.0 |
| 2006-02-27 10:25:00 | SPY | ETF | 129.58 | 129.59 | 129.53 | 129.57 | 209700.0 |
| 2006-02-27 10:30:00 | SPY | ETF | 129.57 | 129.6 | 129.54 | 129.56 | 126900.0 |
| 2006-02-27 10:35:00 | SPY | ETF | 129.57 | 129.58 | 129.51 | 129.56 | 200500.0 |
| 2006-02-27 10:40:00 | SPY | ETF | 129.52 | 129.6 | 129.51 | 129.6 | 145600.0 |
| 2006-02-27 10:45:00 | SPY | ETF | 129.6 | 129.61 | 129.55 | 129.57 | 233500.0 |
| 2006-02-27 10:50:00 | SPY | ETF | 129.58 | 129.59 | 129.54 | 129.56 | 96700.0 |
| 2006-02-27 10:55:00 | SPY | ETF | 129.6 | 129.61 | 129.48 | 129.55 | 288600.0 |
| 2006-02-27 11:00:00 | SPY | ETF | 129.55 | 129.63 | 129.52 | 129.61 | 276100.0 |
| 2006-02-27 11:05:00 | SPY | ETF | 129.61 | 129.63 | 129.57 | 129.62 | 198300.0 |
| 2006-02-27 11:10:00 | SPY | ETF | 129.62 | 129.82 | 129.61 | 129.8 | 811800.0 |
| 2006-02-27 11:15:00 | SPY | ETF | 129.81 | 129.87 | 129.72 | 129.82 | 1406500.0 |
| 2006-02-27 11:20:00 | SPY | ETF | 129.83 | 129.83 | 129.77 | 129.78 | 630400.0 |
| 2006-02-27 11:25:00 | SPY | ETF | 129.79 | 129.93 | 129.79 | 129.9 | 650000.0 |
| 2006-02-27 11:30:00 | SPY | ETF | 129.89 | 129.94 | 129.85 | 129.88 | 655900.0 |
| 2006-02-27 11:35:00 | SPY | ETF | 129.88 | 129.94 | 129.85 | 129.89 | 233500.0 |
> showing 50 of 9,160 rows — these rows as CSV