PREVIEW / etf_5min / 2006-12-18
file: by_date/etf_5min/2006/2006-12-18.parquet size: 268 KB rows: 12,406
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-12-18 07:10:00 | SPY | ETF | 142.7 | 142.72 | 142.65 | 142.65 | 6800.0 |
| 2006-12-18 07:15:00 | SPY | ETF | 142.65 | 142.69 | 142.65 | 142.69 | 400.0 |
| 2006-12-18 07:20:00 | SPY | ETF | 142.62 | 142.62 | 142.62 | 142.62 | 200.0 |
| 2006-12-18 07:25:00 | SPY | ETF | 142.62 | 142.64 | 142.61 | 142.61 | 8200.0 |
| 2006-12-18 07:40:00 | SPY | ETF | 142.67 | 142.67 | 142.67 | 142.67 | 300.0 |
| 2006-12-18 07:50:00 | SPY | ETF | 142.63 | 142.63 | 142.63 | 142.63 | 2500.0 |
| 2006-12-18 07:55:00 | SPY | ETF | 142.63 | 142.68 | 142.63 | 142.63 | 13100.0 |
| 2006-12-18 08:00:00 | SPY | ETF | 142.66 | 142.72 | 142.63 | 142.65 | 26100.0 |
| 2006-12-18 08:05:00 | SPY | ETF | 142.63 | 142.65 | 142.63 | 142.65 | 4400.0 |
| 2006-12-18 08:10:00 | SPY | ETF | 142.65 | 142.66 | 142.61 | 142.63 | 34200.0 |
| 2006-12-18 08:15:00 | SPY | ETF | 142.64 | 142.64 | 142.61 | 142.61 | 79200.0 |
| 2006-12-18 08:20:00 | SPY | ETF | 142.61 | 142.61 | 142.56 | 142.57 | 145100.0 |
| 2006-12-18 08:25:00 | SPY | ETF | 142.58 | 142.58 | 142.53 | 142.54 | 40700.0 |
| 2006-12-18 08:30:00 | SPY | ETF | 142.54 | 142.55 | 142.52 | 142.55 | 19400.0 |
| 2006-12-18 08:35:00 | SPY | ETF | 142.53 | 142.58 | 142.53 | 142.58 | 520600.0 |
| 2006-12-18 08:40:00 | SPY | ETF | 142.58 | 142.62 | 142.34 | 142.59 | 94400.0 |
| 2006-12-18 08:45:00 | SPY | ETF | 142.6 | 142.61 | 142.59 | 142.59 | 16600.0 |
| 2006-12-18 08:50:00 | SPY | ETF | 142.6 | 142.65 | 142.6 | 142.65 | 35500.0 |
| 2006-12-18 08:55:00 | SPY | ETF | 142.65 | 142.69 | 142.64 | 142.64 | 42400.0 |
| 2006-12-18 09:00:00 | SPY | ETF | 142.65 | 142.69 | 142.65 | 142.69 | 7900.0 |
| 2006-12-18 09:05:00 | SPY | ETF | 142.66 | 142.68 | 142.62 | 142.65 | 59100.0 |
| 2006-12-18 09:10:00 | SPY | ETF | 142.63 | 142.63 | 142.61 | 142.61 | 6800.0 |
| 2006-12-18 09:15:00 | SPY | ETF | 142.58 | 142.58 | 142.58 | 142.58 | 200.0 |
| 2006-12-18 09:20:00 | SPY | ETF | 142.58 | 142.63 | 142.57 | 142.63 | 34500.0 |
| 2006-12-18 09:25:00 | SPY | ETF | 142.59 | 142.6 | 142.56 | 142.56 | 12100.0 |
| 2006-12-18 09:30:00 | SPY | ETF | 142.54 | 142.6 | 142.53 | 142.56 | 752700.0 |
| 2006-12-18 09:35:00 | SPY | ETF | 142.56 | 142.56 | 142.47 | 142.55 | 1121500.0 |
| 2006-12-18 09:40:00 | SPY | ETF | 142.55 | 142.58 | 142.47 | 142.57 | 1381100.0 |
| 2006-12-18 09:45:00 | SPY | ETF | 142.58 | 142.62 | 142.5 | 142.55 | 788100.0 |
| 2006-12-18 09:50:00 | SPY | ETF | 142.55 | 142.77 | 142.55 | 142.74 | 1235600.0 |
| 2006-12-18 09:55:00 | SPY | ETF | 142.74 | 142.87 | 142.7095 | 142.81 | 1610700.0 |
| 2006-12-18 10:00:00 | SPY | ETF | 142.8 | 142.88 | 142.79 | 142.82 | 1110300.0 |
| 2006-12-18 10:05:00 | SPY | ETF | 142.83 | 142.83 | 142.75 | 142.77 | 460600.0 |
| 2006-12-18 10:10:00 | SPY | ETF | 142.78 | 142.8 | 142.74 | 142.78 | 440900.0 |
| 2006-12-18 10:15:00 | SPY | ETF | 142.78 | 142.83 | 142.72 | 142.78 | 536600.0 |
| 2006-12-18 10:20:00 | SPY | ETF | 142.78 | 142.79 | 142.69 | 142.72 | 524400.0 |
| 2006-12-18 10:25:00 | SPY | ETF | 142.73 | 142.74 | 142.69 | 142.7 | 304400.0 |
| 2006-12-18 10:30:00 | SPY | ETF | 142.7 | 142.7 | 142.63 | 142.7 | 653200.0 |
| 2006-12-18 10:35:00 | SPY | ETF | 142.7 | 142.71 | 142.66 | 142.68 | 201600.0 |
| 2006-12-18 10:40:00 | SPY | ETF | 142.68 | 142.71 | 142.58 | 142.58 | 153300.0 |
| 2006-12-18 10:45:00 | SPY | ETF | 142.58 | 142.64 | 142.51 | 142.56 | 305900.0 |
| 2006-12-18 10:50:00 | SPY | ETF | 142.55 | 142.6 | 142.53 | 142.57 | 334900.0 |
| 2006-12-18 10:55:00 | SPY | ETF | 142.58 | 142.63 | 142.56 | 142.56 | 244600.0 |
| 2006-12-18 11:00:00 | SPY | ETF | 142.57 | 142.6 | 142.43 | 142.45 | 641800.0 |
| 2006-12-18 11:05:00 | SPY | ETF | 142.44 | 142.5 | 142.42 | 142.46 | 427500.0 |
| 2006-12-18 11:10:00 | SPY | ETF | 142.46 | 142.51 | 142.44 | 142.5 | 356500.0 |
| 2006-12-18 11:15:00 | SPY | ETF | 142.52 | 142.54 | 142.49 | 142.52 | 327400.0 |
| 2006-12-18 11:20:00 | SPY | ETF | 142.51 | 142.57 | 142.49 | 142.57 | 231800.0 |
| 2006-12-18 11:25:00 | SPY | ETF | 142.57 | 142.57 | 142.5 | 142.51 | 299400.0 |
| 2006-12-18 11:30:00 | SPY | ETF | 142.51 | 142.57 | 142.49 | 142.55 | 227500.0 |
> showing 50 of 12,406 rows — these rows as CSV