PREVIEW / etf_5min / 2006-12-19
file: by_date/etf_5min/2006/2006-12-19.parquet size: 270 KB rows: 12,664
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-19 06:10:00 | SPY | ETF | 141.62 | 141.62 | 141.62 | 141.62 | 24800.0 |
| 2006-12-19 07:05:00 | SPY | ETF | 141.62 | 141.62 | 141.6 | 141.6 | 5000.0 |
| 2006-12-19 07:10:00 | SPY | ETF | 141.6 | 141.6 | 141.6 | 141.6 | 17000.0 |
| 2006-12-19 07:20:00 | SPY | ETF | 141.58 | 141.58 | 141.58 | 141.58 | 10500.0 |
| 2006-12-19 07:25:00 | SPY | ETF | 141.55 | 141.55 | 141.47 | 141.47 | 10800.0 |
| 2006-12-19 07:30:00 | SPY | ETF | 141.47 | 141.56 | 141.47 | 141.55 | 22400.0 |
| 2006-12-19 07:35:00 | SPY | ETF | 141.55 | 141.6 | 141.55 | 141.6 | 22300.0 |
| 2006-12-19 07:40:00 | SPY | ETF | 141.6 | 141.65 | 141.53 | 141.53 | 23000.0 |
| 2006-12-19 07:50:00 | SPY | ETF | 141.56 | 141.69 | 141.56 | 141.69 | 5300.0 |
| 2006-12-19 07:55:00 | SPY | ETF | 141.7 | 141.77 | 141.65 | 141.75 | 89000.0 |
| 2006-12-19 08:00:00 | SPY | ETF | 141.58 | 141.8 | 141.438 | 141.76 | 530700.0 |
| 2006-12-19 08:05:00 | SPY | ETF | 141.76 | 141.79 | 141.74 | 141.75 | 37100.0 |
| 2006-12-19 08:10:00 | SPY | ETF | 141.76 | 141.76 | 141.7 | 141.7 | 155500.0 |
| 2006-12-19 08:15:00 | SPY | ETF | 141.71 | 141.71 | 141.68 | 141.68 | 118400.0 |
| 2006-12-19 08:20:00 | SPY | ETF | 141.68 | 141.7 | 141.65 | 141.7 | 204100.0 |
| 2006-12-19 08:25:00 | SPY | ETF | 141.69 | 141.77 | 141.66 | 141.77 | 99100.0 |
| 2006-12-19 08:30:00 | SPY | ETF | 141.63 | 141.69 | 141.37 | 141.61 | 1049000.0 |
| 2006-12-19 08:35:00 | SPY | ETF | 141.59 | 141.62 | 141.55 | 141.58 | 253500.0 |
| 2006-12-19 08:40:00 | SPY | ETF | 141.57 | 141.64 | 141.52 | 141.64 | 341000.0 |
| 2006-12-19 08:45:00 | SPY | ETF | 141.62 | 141.69 | 141.6 | 141.62 | 116900.0 |
| 2006-12-19 08:50:00 | SPY | ETF | 141.6 | 141.65 | 141.58 | 141.65 | 192000.0 |
| 2006-12-19 08:55:00 | SPY | ETF | 141.66 | 141.66 | 141.59 | 141.59 | 53800.0 |
| 2006-12-19 09:00:00 | SPY | ETF | 141.59 | 141.62 | 141.58 | 141.6 | 39600.0 |
| 2006-12-19 09:05:00 | SPY | ETF | 141.61 | 141.61 | 141.49 | 141.51 | 213400.0 |
| 2006-12-19 09:10:00 | SPY | ETF | 141.52 | 141.58 | 141.45 | 141.52 | 190400.0 |
| 2006-12-19 09:15:00 | SPY | ETF | 141.53 | 141.62 | 141.5 | 141.53 | 462700.0 |
| 2006-12-19 09:20:00 | SPY | ETF | 141.52 | 141.58 | 141.5 | 141.56 | 34800.0 |
| 2006-12-19 09:25:00 | SPY | ETF | 141.56 | 141.56 | 141.46 | 141.53 | 107000.0 |
| 2006-12-19 09:30:00 | SPY | ETF | 141.55 | 141.58 | 141.43 | 141.46 | 1665600.0 |
| 2006-12-19 09:35:00 | SPY | ETF | 141.47 | 141.52 | 141.23 | 141.24 | 3056300.0 |
| 2006-12-19 09:40:00 | SPY | ETF | 141.24 | 141.38 | 141.19 | 141.33 | 4208100.0 |
| 2006-12-19 09:45:00 | SPY | ETF | 141.33 | 141.45 | 141.31 | 141.41 | 1369100.0 |
| 2006-12-19 09:50:00 | SPY | ETF | 141.41 | 141.62 | 141.38 | 141.61 | 1776200.0 |
| 2006-12-19 09:55:00 | SPY | ETF | 141.61 | 141.68 | 141.5 | 141.51 | 2901500.0 |
| 2006-12-19 10:00:00 | SPY | ETF | 141.51 | 141.56 | 141.48 | 141.53 | 772600.0 |
| 2006-12-19 10:05:00 | SPY | ETF | 141.53 | 141.64 | 141.51 | 141.57 | 579200.0 |
| 2006-12-19 10:10:00 | SPY | ETF | 141.57 | 141.75 | 141.53 | 141.71 | 1164100.0 |
| 2006-12-19 10:15:00 | SPY | ETF | 141.71 | 141.83 | 141.7 | 141.74 | 1448300.0 |
| 2006-12-19 10:20:00 | SPY | ETF | 141.73 | 141.77 | 141.69 | 141.71 | 614800.0 |
| 2006-12-19 10:25:00 | SPY | ETF | 141.7 | 141.8 | 141.64 | 141.71 | 959100.0 |
| 2006-12-19 10:30:00 | SPY | ETF | 141.71 | 141.75 | 141.68 | 141.73 | 808800.0 |
| 2006-12-19 10:35:00 | SPY | ETF | 141.73 | 141.84 | 141.71 | 141.76 | 843100.0 |
| 2006-12-19 10:40:00 | SPY | ETF | 141.77 | 141.78 | 141.67 | 141.7 | 605700.0 |
| 2006-12-19 10:45:00 | SPY | ETF | 141.7 | 141.76 | 141.68 | 141.73 | 507900.0 |
| 2006-12-19 10:50:00 | SPY | ETF | 141.72 | 141.85 | 141.72 | 141.82 | 578500.0 |
| 2006-12-19 10:55:00 | SPY | ETF | 141.82 | 141.93 | 141.81 | 141.88 | 763200.0 |
| 2006-12-19 11:00:00 | SPY | ETF | 141.9 | 142.01 | 141.89 | 141.93 | 1352800.0 |
| 2006-12-19 11:05:00 | SPY | ETF | 141.95 | 141.95 | 141.88 | 141.9 | 352700.0 |
| 2006-12-19 11:10:00 | SPY | ETF | 141.9 | 141.94 | 141.85 | 141.87 | 390000.0 |
| 2006-12-19 11:15:00 | SPY | ETF | 141.87 | 141.87 | 141.72 | 141.73 | 569100.0 |
> showing 50 of 12,664 rows — these rows as CSV