PREVIEW / etf_5min / 2006-11-28
file: by_date/etf_5min/2006/2006-11-28.parquet size: 257 KB rows: 11,940
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-28 06:20:00 | SPY | ETF | 138.44 | 138.44 | 138.44 | 138.44 | 5000.0 |
| 2006-11-28 06:25:00 | SPY | ETF | 138.44 | 138.44 | 138.44 | 138.44 | 5000.0 |
| 2006-11-28 06:35:00 | SPY | ETF | 138.39 | 138.39 | 138.39 | 138.39 | 100.0 |
| 2006-11-28 06:40:00 | SPY | ETF | 138.42 | 138.42 | 138.42 | 138.42 | 1000.0 |
| 2006-11-28 07:00:00 | SPY | ETF | 138.51 | 138.51 | 138.47 | 138.47 | 10000.0 |
| 2006-11-28 07:20:00 | SPY | ETF | 138.53 | 138.53 | 138.5 | 138.5 | 1900.0 |
| 2006-11-28 07:25:00 | SPY | ETF | 138.5 | 138.5 | 138.45 | 138.45 | 7500.0 |
| 2006-11-28 07:30:00 | SPY | ETF | 138.45 | 138.52 | 138.45 | 138.51 | 3200.0 |
| 2006-11-28 07:35:00 | SPY | ETF | 138.47 | 138.47 | 138.47 | 138.47 | 100.0 |
| 2006-11-28 07:40:00 | SPY | ETF | 138.45 | 138.45 | 138.45 | 138.45 | 3000.0 |
| 2006-11-28 07:45:00 | SPY | ETF | 138.46 | 138.46 | 138.46 | 138.46 | 200.0 |
| 2006-11-28 07:50:00 | SPY | ETF | 138.48 | 138.48 | 138.45 | 138.45 | 25300.0 |
| 2006-11-28 07:55:00 | SPY | ETF | 138.49 | 138.49 | 138.49 | 138.49 | 300.0 |
| 2006-11-28 08:00:00 | SPY | ETF | 138.49 | 138.53 | 138.42 | 138.45 | 34700.0 |
| 2006-11-28 08:05:00 | SPY | ETF | 138.47 | 138.48 | 138.47 | 138.48 | 9600.0 |
| 2006-11-28 08:10:00 | SPY | ETF | 138.45 | 138.45 | 138.42 | 138.42 | 18800.0 |
| 2006-11-28 08:15:00 | SPY | ETF | 138.4 | 138.42 | 138.34 | 138.4 | 1034900.0 |
| 2006-11-28 08:25:00 | SPY | ETF | 138.42 | 138.45 | 138.4 | 138.42 | 8500.0 |
| 2006-11-28 08:30:00 | SPY | ETF | 138.42 | 138.42 | 138.2 | 138.26 | 1108900.0 |
| 2006-11-28 08:35:00 | SPY | ETF | 138.27 | 138.27 | 137.96 | 138.03 | 2035300.0 |
| 2006-11-28 08:40:00 | SPY | ETF | 138.04 | 138.09 | 138.03 | 138.05 | 134600.0 |
| 2006-11-28 08:45:00 | SPY | ETF | 138.09 | 138.13 | 138.07 | 138.1 | 66600.0 |
| 2006-11-28 08:50:00 | SPY | ETF | 138.15 | 138.16 | 138.09 | 138.09 | 108400.0 |
| 2006-11-28 08:55:00 | SPY | ETF | 138.52 | 138.52 | 138.05 | 138.05 | 72300.0 |
| 2006-11-28 09:00:00 | SPY | ETF | 138.06 | 138.07 | 138.02 | 138.06 | 62400.0 |
| 2006-11-28 09:05:00 | SPY | ETF | 138.07 | 138.18 | 138.07 | 138.18 | 42000.0 |
| 2006-11-28 09:10:00 | SPY | ETF | 138.18 | 138.21 | 138.16 | 138.16 | 80000.0 |
| 2006-11-28 09:15:00 | SPY | ETF | 138.14 | 138.2 | 138.14 | 138.16 | 578100.0 |
| 2006-11-28 09:20:00 | SPY | ETF | 138.18 | 138.24 | 138.16 | 138.24 | 57900.0 |
| 2006-11-28 09:25:00 | SPY | ETF | 138.24 | 138.26 | 138.19 | 138.26 | 135100.0 |
| 2006-11-28 09:30:00 | SPY | ETF | 138.24 | 138.43 | 138.2 | 138.42 | 4110600.0 |
| 2006-11-28 09:35:00 | SPY | ETF | 138.42 | 138.45 | 138.25 | 138.27 | 1844900.0 |
| 2006-11-28 09:40:00 | SPY | ETF | 138.26 | 138.28 | 138.11 | 138.16 | 3468300.0 |
| 2006-11-28 09:45:00 | SPY | ETF | 138.15 | 138.25 | 138.14 | 138.21 | 1144700.0 |
| 2006-11-28 09:50:00 | SPY | ETF | 138.21 | 138.39 | 138.2 | 138.29 | 2951300.0 |
| 2006-11-28 09:55:00 | SPY | ETF | 138.28 | 138.41 | 138.27 | 138.37 | 748600.0 |
| 2006-11-28 10:00:00 | SPY | ETF | 138.38 | 138.73 | 138.29 | 138.68 | 6724700.0 |
| 2006-11-28 10:05:00 | SPY | ETF | 138.68 | 138.71 | 138.39 | 138.47 | 2364800.0 |
| 2006-11-28 10:10:00 | SPY | ETF | 138.47 | 138.48 | 138.17 | 138.29 | 3076100.0 |
| 2006-11-28 10:15:00 | SPY | ETF | 138.29 | 138.4 | 138.24 | 138.36 | 1087100.0 |
| 2006-11-28 10:20:00 | SPY | ETF | 138.36 | 138.72 | 138.32 | 138.67 | 1364500.0 |
| 2006-11-28 10:25:00 | SPY | ETF | 138.67 | 138.89 | 138.64 | 138.85 | 2959100.0 |
| 2006-11-28 10:30:00 | SPY | ETF | 138.84 | 138.98 | 138.77 | 138.94 | 4076500.0 |
| 2006-11-28 10:35:00 | SPY | ETF | 138.96 | 139.1 | 138.94 | 138.99 | 1561100.0 |
| 2006-11-28 10:40:00 | SPY | ETF | 138.98 | 139.0 | 138.9 | 138.94 | 868500.0 |
| 2006-11-28 10:45:00 | SPY | ETF | 138.94 | 139.05 | 138.91 | 138.99 | 1390400.0 |
| 2006-11-28 10:50:00 | SPY | ETF | 138.99 | 139.02 | 138.85 | 138.87 | 1023500.0 |
| 2006-11-28 10:55:00 | SPY | ETF | 138.87 | 138.91 | 138.82 | 138.89 | 1353800.0 |
| 2006-11-28 11:00:00 | SPY | ETF | 138.89 | 138.98 | 138.88 | 138.94 | 769400.0 |
| 2006-11-28 11:05:00 | SPY | ETF | 138.93 | 138.93 | 138.8 | 138.87 | 819400.0 |
> showing 50 of 11,940 rows — these rows as CSV