PREVIEW / etf_5min / 2006-11-14
file: by_date/etf_5min/2006/2006-11-14.parquet size: 261 KB rows: 12,059
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-14 04:15:00 | SPY | ETF | 138.86 | 138.86 | 138.86 | 138.86 | 500.0 |
| 2006-11-14 06:15:00 | SPY | ETF | 138.7 | 138.7 | 138.7 | 138.7 | 10000.0 |
| 2006-11-14 06:35:00 | SPY | ETF | 138.66 | 138.66 | 138.66 | 138.66 | 10000.0 |
| 2006-11-14 07:00:00 | SPY | ETF | 138.7 | 138.7 | 138.7 | 138.7 | 500.0 |
| 2006-11-14 07:05:00 | SPY | ETF | 138.7 | 138.75 | 138.7 | 138.75 | 9200.0 |
| 2006-11-14 07:10:00 | SPY | ETF | 138.75 | 138.75 | 138.75 | 138.75 | 2000.0 |
| 2006-11-14 07:20:00 | SPY | ETF | 138.75 | 138.75 | 138.75 | 138.75 | 100.0 |
| 2006-11-14 07:30:00 | SPY | ETF | 138.75 | 138.75 | 138.75 | 138.75 | 4600.0 |
| 2006-11-14 07:35:00 | SPY | ETF | 138.68 | 138.68 | 138.68 | 138.68 | 700.0 |
| 2006-11-14 07:45:00 | SPY | ETF | 138.67 | 138.67 | 138.67 | 138.67 | 1000.0 |
| 2006-11-14 07:55:00 | SPY | ETF | 138.65 | 138.65 | 138.65 | 138.65 | 500.0 |
| 2006-11-14 08:00:00 | SPY | ETF | 138.67 | 138.75 | 138.65 | 138.66 | 636200.0 |
| 2006-11-14 08:05:00 | SPY | ETF | 138.71 | 138.71 | 138.69 | 138.7 | 13200.0 |
| 2006-11-14 08:10:00 | SPY | ETF | 138.7 | 138.7 | 138.67 | 138.67 | 7600.0 |
| 2006-11-14 08:15:00 | SPY | ETF | 138.65 | 138.73 | 138.65 | 138.72 | 13000.0 |
| 2006-11-14 08:20:00 | SPY | ETF | 138.73 | 138.84 | 138.68 | 138.79 | 287500.0 |
| 2006-11-14 08:25:00 | SPY | ETF | 138.8 | 138.93 | 138.77 | 138.9 | 242500.0 |
| 2006-11-14 08:30:00 | SPY | ETF | 138.93 | 139.1 | 138.9 | 139.02 | 994400.0 |
| 2006-11-14 08:35:00 | SPY | ETF | 139.02 | 139.32 | 139.01 | 139.22 | 1554900.0 |
| 2006-11-14 08:40:00 | SPY | ETF | 139.24 | 139.24 | 139.08 | 139.19 | 1471500.0 |
| 2006-11-14 08:45:00 | SPY | ETF | 139.19 | 139.24 | 139.15 | 139.17 | 283900.0 |
| 2006-11-14 08:50:00 | SPY | ETF | 139.17 | 139.21 | 139.11 | 139.12 | 195700.0 |
| 2006-11-14 08:55:00 | SPY | ETF | 139.12 | 139.16 | 139.1 | 139.11 | 247100.0 |
| 2006-11-14 09:00:00 | SPY | ETF | 139.12 | 139.2 | 139.08 | 139.19 | 107500.0 |
| 2006-11-14 09:05:00 | SPY | ETF | 139.19 | 139.23 | 139.16 | 139.16 | 89800.0 |
| 2006-11-14 09:10:00 | SPY | ETF | 139.16 | 139.21 | 139.14 | 139.15 | 542200.0 |
| 2006-11-14 09:15:00 | SPY | ETF | 139.14 | 139.14 | 139.1 | 139.11 | 362100.0 |
| 2006-11-14 09:20:00 | SPY | ETF | 139.1 | 139.11 | 139.0 | 139.01 | 935100.0 |
| 2006-11-14 09:25:00 | SPY | ETF | 139.02 | 139.02 | 138.96 | 138.98 | 200600.0 |
| 2006-11-14 09:30:00 | SPY | ETF | 138.97 | 139.09 | 138.92 | 139.04 | 1653400.0 |
| 2006-11-14 09:35:00 | SPY | ETF | 139.01 | 139.07 | 138.84 | 138.86 | 3869700.0 |
| 2006-11-14 09:40:00 | SPY | ETF | 138.84 | 138.92 | 138.79 | 138.91 | 2492800.0 |
| 2006-11-14 09:45:00 | SPY | ETF | 138.91 | 138.92 | 138.71 | 138.78 | 801600.0 |
| 2006-11-14 09:50:00 | SPY | ETF | 138.78 | 138.78 | 138.65 | 138.67 | 1025000.0 |
| 2006-11-14 09:55:00 | SPY | ETF | 138.67 | 138.68 | 138.56 | 138.64 | 787700.0 |
| 2006-11-14 10:00:00 | SPY | ETF | 138.64 | 138.77 | 138.62 | 138.72 | 1488900.0 |
| 2006-11-14 10:05:00 | SPY | ETF | 138.72 | 138.96 | 138.68 | 138.7 | 1061800.0 |
| 2006-11-14 10:10:00 | SPY | ETF | 138.7 | 138.74 | 138.42 | 138.45 | 2029700.0 |
| 2006-11-14 10:15:00 | SPY | ETF | 138.46 | 138.5 | 138.39 | 138.44 | 1513900.0 |
| 2006-11-14 10:20:00 | SPY | ETF | 138.44 | 138.45 | 138.31 | 138.33 | 1379900.0 |
| 2006-11-14 10:25:00 | SPY | ETF | 138.33 | 138.33 | 138.17 | 138.19 | 1517100.0 |
| 2006-11-14 10:30:00 | SPY | ETF | 138.1901 | 138.25 | 138.12 | 138.23 | 1517500.0 |
| 2006-11-14 10:35:00 | SPY | ETF | 138.24 | 138.31 | 138.23 | 138.26 | 950800.0 |
| 2006-11-14 10:40:00 | SPY | ETF | 138.26 | 138.32 | 138.21 | 138.22 | 744100.0 |
| 2006-11-14 10:45:00 | SPY | ETF | 138.24 | 138.26 | 138.16 | 138.26 | 871300.0 |
| 2006-11-14 10:50:00 | SPY | ETF | 138.27 | 138.36 | 138.26 | 138.31 | 901500.0 |
| 2006-11-14 10:55:00 | SPY | ETF | 138.31 | 138.37 | 138.29 | 138.33 | 1513200.0 |
| 2006-11-14 11:00:00 | SPY | ETF | 138.33 | 138.36 | 138.21 | 138.25 | 526300.0 |
| 2006-11-14 11:05:00 | SPY | ETF | 138.25 | 138.6292 | 138.23 | 138.27 | 3421400.0 |
| 2006-11-14 11:10:00 | SPY | ETF | 138.26 | 138.28 | 138.21 | 138.24 | 344000.0 |
> showing 50 of 12,059 rows — these rows as CSV