PREVIEW / etf_5min / 2006-11-30
file: by_date/etf_5min/2006/2006-11-30.parquet size: 267 KB rows: 12,531
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-11-30 07:00:00 | SPY | ETF | 140.65 | 140.65 | 140.65 | 140.65 | 100.0 |
| 2006-11-30 07:05:00 | SPY | ETF | 140.66 | 140.69 | 140.66 | 140.69 | 12500.0 |
| 2006-11-30 07:10:00 | SPY | ETF | 140.66 | 140.66 | 140.66 | 140.66 | 1000.0 |
| 2006-11-30 07:25:00 | SPY | ETF | 140.69 | 140.69 | 140.67 | 140.67 | 2100.0 |
| 2006-11-30 07:30:00 | SPY | ETF | 140.69 | 140.71 | 140.69 | 140.71 | 800.0 |
| 2006-11-30 07:35:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 2400.0 |
| 2006-11-30 07:40:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 6700.0 |
| 2006-11-30 07:45:00 | SPY | ETF | 140.7 | 140.71 | 140.68 | 140.68 | 1500.0 |
| 2006-11-30 07:55:00 | SPY | ETF | 140.7 | 140.7 | 140.7 | 140.7 | 1300.0 |
| 2006-11-30 08:00:00 | SPY | ETF | 140.7 | 140.71 | 140.66 | 140.7 | 29300.0 |
| 2006-11-30 08:05:00 | SPY | ETF | 140.71 | 140.71 | 140.7 | 140.7 | 8600.0 |
| 2006-11-30 08:10:00 | SPY | ETF | 140.7 | 140.73 | 140.7 | 140.73 | 39400.0 |
| 2006-11-30 08:15:00 | SPY | ETF | 140.73 | 140.76 | 140.73 | 140.76 | 17700.0 |
| 2006-11-30 08:20:00 | SPY | ETF | 140.76 | 140.78 | 140.73 | 140.76 | 58100.0 |
| 2006-11-30 08:25:00 | SPY | ETF | 140.77 | 140.82 | 140.74 | 140.74 | 64500.0 |
| 2006-11-30 08:30:00 | SPY | ETF | 140.74 | 140.74 | 140.61 | 140.64 | 434600.0 |
| 2006-11-30 08:35:00 | SPY | ETF | 140.64 | 140.66 | 140.54 | 140.58 | 503400.0 |
| 2006-11-30 08:40:00 | SPY | ETF | 140.59 | 140.59 | 140.53 | 140.53 | 260400.0 |
| 2006-11-30 08:45:00 | SPY | ETF | 140.52 | 140.57 | 140.43 | 140.53 | 510500.0 |
| 2006-11-30 08:50:00 | SPY | ETF | 140.54 | 140.55 | 140.47 | 140.49 | 85600.0 |
| 2006-11-30 08:55:00 | SPY | ETF | 140.49 | 140.52 | 140.49 | 140.51 | 12000.0 |
| 2006-11-30 09:00:00 | SPY | ETF | 140.52 | 140.53 | 140.51 | 140.52 | 40400.0 |
| 2006-11-30 09:05:00 | SPY | ETF | 140.5 | 140.5 | 140.45 | 140.48 | 138800.0 |
| 2006-11-30 09:10:00 | SPY | ETF | 140.46 | 140.46 | 140.41 | 140.41 | 75500.0 |
| 2006-11-30 09:15:00 | SPY | ETF | 140.43 | 140.5 | 140.4 | 140.5 | 53200.0 |
| 2006-11-30 09:20:00 | SPY | ETF | 140.51 | 140.52 | 140.44 | 140.46 | 37900.0 |
| 2006-11-30 09:25:00 | SPY | ETF | 140.46 | 140.47 | 140.41 | 140.43 | 25800.0 |
| 2006-11-30 09:30:00 | SPY | ETF | 140.44 | 140.59 | 140.4 | 140.57 | 847700.0 |
| 2006-11-30 09:35:00 | SPY | ETF | 140.57 | 140.58 | 140.44 | 140.44 | 905800.0 |
| 2006-11-30 09:40:00 | SPY | ETF | 140.44 | 140.5 | 140.27 | 140.28 | 1471100.0 |
| 2006-11-30 09:45:00 | SPY | ETF | 140.28 | 140.5 | 140.25 | 140.5 | 1315800.0 |
| 2006-11-30 09:50:00 | SPY | ETF | 140.49 | 140.56 | 140.45 | 140.53 | 1288300.0 |
| 2006-11-30 09:55:00 | SPY | ETF | 140.54 | 140.69 | 140.28 | 140.49 | 3105300.0 |
| 2006-11-30 10:00:00 | SPY | ETF | 140.49 | 140.67 | 139.81 | 139.88 | 3101700.0 |
| 2006-11-30 10:05:00 | SPY | ETF | 139.89 | 140.57 | 139.82 | 139.99 | 1670400.0 |
| 2006-11-30 10:10:00 | SPY | ETF | 140.0 | 140.24 | 139.88 | 139.93 | 1745100.0 |
| 2006-11-30 10:15:00 | SPY | ETF | 139.93 | 140.15 | 139.84 | 139.94 | 2008500.0 |
| 2006-11-30 10:20:00 | SPY | ETF | 139.94 | 140.03 | 139.76 | 139.83 | 2633100.0 |
| 2006-11-30 10:25:00 | SPY | ETF | 139.83 | 140.03 | 139.82 | 139.99 | 2123500.0 |
| 2006-11-30 10:30:00 | SPY | ETF | 140.02 | 140.12 | 139.9 | 139.98 | 1072400.0 |
| 2006-11-30 10:35:00 | SPY | ETF | 139.99 | 140.11 | 139.9 | 140.06 | 675500.0 |
| 2006-11-30 10:40:00 | SPY | ETF | 140.06 | 140.2 | 140.0 | 140.1301 | 821800.0 |
| 2006-11-30 10:45:00 | SPY | ETF | 140.13 | 140.21 | 140.02 | 140.06 | 1070100.0 |
| 2006-11-30 10:50:00 | SPY | ETF | 140.06 | 140.29 | 140.06 | 140.23 | 924600.0 |
| 2006-11-30 10:55:00 | SPY | ETF | 140.23 | 140.32 | 140.12 | 140.15 | 1862000.0 |
| 2006-11-30 11:00:00 | SPY | ETF | 140.14 | 140.24 | 140.05 | 140.08 | 758200.0 |
| 2006-11-30 11:05:00 | SPY | ETF | 140.09 | 140.22 | 140.07 | 140.12 | 747100.0 |
| 2006-11-30 11:10:00 | SPY | ETF | 140.13 | 140.17 | 140.0 | 140.05 | 1087900.0 |
| 2006-11-30 11:15:00 | SPY | ETF | 140.04 | 140.07 | 139.96 | 140.0 | 744400.0 |
| 2006-11-30 11:20:00 | SPY | ETF | 140.0 | 140.0 | 139.82 | 139.9 | 1060400.0 |
> showing 50 of 12,531 rows — these rows as CSV