PREVIEW / etf_5min / 2006-01-13
file: by_date/etf_5min/2006/2006-01-13.parquet size: 159 KB rows: 8,797
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-01-13 07:10:00 | SPY | ETF | 128.65 | 128.65 | 128.65 | 128.65 | 4800.0 |
| 2006-01-13 07:15:00 | SPY | ETF | 128.66 | 128.66 | 128.65 | 128.65 | 5000.0 |
| 2006-01-13 07:35:00 | SPY | ETF | 128.66 | 128.66 | 128.64 | 128.65 | 72000.0 |
| 2006-01-13 07:40:00 | SPY | ETF | 128.65 | 128.65 | 128.62 | 128.62 | 15400.0 |
| 2006-01-13 07:45:00 | SPY | ETF | 128.62 | 128.64 | 128.62 | 128.64 | 18500.0 |
| 2006-01-13 07:50:00 | SPY | ETF | 128.64 | 128.64 | 128.64 | 128.64 | 100.0 |
| 2006-01-13 07:55:00 | SPY | ETF | 128.67 | 128.67 | 128.65 | 128.65 | 49900.0 |
| 2006-01-13 08:00:00 | SPY | ETF | 128.65 | 128.69 | 128.61 | 128.63 | 171600.0 |
| 2006-01-13 08:05:00 | SPY | ETF | 128.65 | 128.65 | 128.64 | 128.64 | 7000.0 |
| 2006-01-13 08:10:00 | SPY | ETF | 128.65 | 128.65 | 128.61 | 128.61 | 2800.0 |
| 2006-01-13 08:20:00 | SPY | ETF | 128.64 | 128.67 | 128.64 | 128.67 | 150000.0 |
| 2006-01-13 08:25:00 | SPY | ETF | 128.69 | 128.71 | 128.69 | 128.71 | 1500.0 |
| 2006-01-13 08:30:00 | SPY | ETF | 128.61 | 128.74 | 128.55 | 128.7 | 762300.0 |
| 2006-01-13 08:35:00 | SPY | ETF | 128.7 | 128.76 | 128.7 | 128.73 | 16700.0 |
| 2006-01-13 08:40:00 | SPY | ETF | 128.73 | 128.73 | 128.7 | 128.7 | 4000.0 |
| 2006-01-13 08:45:00 | SPY | ETF | 128.68 | 128.68 | 128.65 | 128.66 | 51200.0 |
| 2006-01-13 08:50:00 | SPY | ETF | 128.67 | 128.67 | 128.65 | 128.65 | 28400.0 |
| 2006-01-13 08:55:00 | SPY | ETF | 128.66 | 128.66 | 128.65 | 128.65 | 48500.0 |
| 2006-01-13 09:00:00 | SPY | ETF | 128.65 | 128.66 | 128.64 | 128.64 | 56400.0 |
| 2006-01-13 09:05:00 | SPY | ETF | 128.64 | 128.64 | 128.62 | 128.62 | 500.0 |
| 2006-01-13 09:10:00 | SPY | ETF | 128.64 | 128.64 | 128.61 | 128.62 | 97500.0 |
| 2006-01-13 09:15:00 | SPY | ETF | 128.61 | 128.61 | 128.58 | 128.6 | 130600.0 |
| 2006-01-13 09:20:00 | SPY | ETF | 128.6 | 128.63 | 128.6 | 128.61 | 26600.0 |
| 2006-01-13 09:25:00 | SPY | ETF | 128.61 | 128.61 | 128.55 | 128.55 | 1700.0 |
| 2006-01-13 09:30:00 | SPY | ETF | 128.57 | 128.73 | 128.57 | 128.69 | 766400.0 |
| 2006-01-13 09:35:00 | SPY | ETF | 128.69 | 128.8 | 128.69 | 128.75 | 388100.0 |
| 2006-01-13 09:40:00 | SPY | ETF | 128.75 | 128.81 | 128.66 | 128.68 | 437300.0 |
| 2006-01-13 09:45:00 | SPY | ETF | 128.68 | 128.74 | 128.64 | 128.66 | 589200.0 |
| 2006-01-13 09:50:00 | SPY | ETF | 128.66 | 128.76 | 128.59 | 128.72 | 369900.0 |
| 2006-01-13 09:55:00 | SPY | ETF | 128.73 | 128.8 | 128.68 | 128.71 | 334200.0 |
| 2006-01-13 10:00:00 | SPY | ETF | 128.71 | 128.79 | 128.57 | 128.64 | 933200.0 |
| 2006-01-13 10:05:00 | SPY | ETF | 128.64 | 128.7 | 128.61 | 128.66 | 290300.0 |
| 2006-01-13 10:10:00 | SPY | ETF | 128.65 | 128.67 | 128.55 | 128.55 | 649800.0 |
| 2006-01-13 10:15:00 | SPY | ETF | 128.54 | 128.57 | 128.48 | 128.52 | 1731500.0 |
| 2006-01-13 10:20:00 | SPY | ETF | 128.52 | 128.57 | 128.48 | 128.53 | 829400.0 |
| 2006-01-13 10:25:00 | SPY | ETF | 128.53 | 128.6 | 128.48 | 128.59 | 563500.0 |
| 2006-01-13 10:30:00 | SPY | ETF | 128.59 | 128.63 | 128.49 | 128.54 | 809900.0 |
| 2006-01-13 10:35:00 | SPY | ETF | 128.54 | 128.6 | 128.52 | 128.58 | 267500.0 |
| 2006-01-13 10:40:00 | SPY | ETF | 128.58 | 128.59 | 128.48 | 128.5 | 316000.0 |
| 2006-01-13 10:45:00 | SPY | ETF | 128.5 | 128.5 | 128.41 | 128.46 | 855200.0 |
| 2006-01-13 10:50:00 | SPY | ETF | 128.46 | 128.61 | 128.43 | 128.56 | 487400.0 |
| 2006-01-13 10:55:00 | SPY | ETF | 128.55 | 128.69 | 128.54 | 128.64 | 445900.0 |
| 2006-01-13 11:00:00 | SPY | ETF | 128.64 | 128.65 | 128.58 | 128.59 | 275900.0 |
| 2006-01-13 11:05:00 | SPY | ETF | 128.6 | 128.65 | 128.58 | 128.62 | 317500.0 |
| 2006-01-13 11:10:00 | SPY | ETF | 128.62 | 128.77 | 128.6 | 128.74 | 709300.0 |
| 2006-01-13 11:15:00 | SPY | ETF | 128.74 | 128.81 | 128.72 | 128.73 | 1040100.0 |
| 2006-01-13 11:20:00 | SPY | ETF | 128.72 | 128.8 | 128.71 | 128.77 | 238900.0 |
| 2006-01-13 11:25:00 | SPY | ETF | 128.76 | 128.82 | 128.74 | 128.77 | 504600.0 |
| 2006-01-13 11:30:00 | SPY | ETF | 128.78 | 128.9 | 128.77 | 128.86 | 1358500.0 |
| 2006-01-13 11:35:00 | SPY | ETF | 128.86 | 128.87 | 128.79 | 128.82 | 501600.0 |
> showing 50 of 8,797 rows — these rows as CSV