PREVIEW / etf_5min / 2005-12-09
file: by_date/etf_5min/2005/2005-12-09.parquet size: 145 KB rows: 7,340
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-09 06:55:00 | SPY | ETF | 126.06 | 126.06 | 126.06 | 126.06 | 100.0 |
| 2005-12-09 07:00:00 | SPY | ETF | 126.06 | 126.06 | 126.04 | 126.04 | 17400.0 |
| 2005-12-09 07:10:00 | SPY | ETF | 126.04 | 126.05 | 126.04 | 126.05 | 2500.0 |
| 2005-12-09 07:15:00 | SPY | ETF | 126.05 | 126.05 | 126.05 | 126.05 | 2000.0 |
| 2005-12-09 07:35:00 | SPY | ETF | 126.09 | 126.09 | 126.09 | 126.09 | 300.0 |
| 2005-12-09 07:40:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 100.0 |
| 2005-12-09 07:55:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 1500.0 |
| 2005-12-09 08:00:00 | SPY | ETF | 126.11 | 126.15 | 126.05 | 126.15 | 199800.0 |
| 2005-12-09 08:05:00 | SPY | ETF | 126.12 | 126.12 | 126.12 | 126.12 | 600.0 |
| 2005-12-09 08:10:00 | SPY | ETF | 126.11 | 126.11 | 126.11 | 126.11 | 100.0 |
| 2005-12-09 08:15:00 | SPY | ETF | 126.11 | 126.12 | 126.11 | 126.12 | 1200.0 |
| 2005-12-09 08:20:00 | SPY | ETF | 126.17 | 126.2 | 126.12 | 126.2 | 554400.0 |
| 2005-12-09 08:25:00 | SPY | ETF | 126.2 | 126.23 | 126.19 | 126.23 | 16700.0 |
| 2005-12-09 08:30:00 | SPY | ETF | 126.2 | 126.29 | 126.2 | 126.26 | 29500.0 |
| 2005-12-09 08:35:00 | SPY | ETF | 126.28 | 126.33 | 126.12 | 126.31 | 634200.0 |
| 2005-12-09 08:40:00 | SPY | ETF | 126.26 | 126.3 | 126.25 | 126.26 | 21400.0 |
| 2005-12-09 08:45:00 | SPY | ETF | 126.26 | 126.26 | 126.26 | 126.26 | 500.0 |
| 2005-12-09 08:50:00 | SPY | ETF | 126.3 | 126.31 | 126.25 | 126.26 | 60100.0 |
| 2005-12-09 08:55:00 | SPY | ETF | 126.25 | 126.28 | 126.25 | 126.28 | 17000.0 |
| 2005-12-09 09:00:00 | SPY | ETF | 126.23 | 126.25 | 126.23 | 126.24 | 2200.0 |
| 2005-12-09 09:05:00 | SPY | ETF | 126.23 | 126.25 | 126.21 | 126.21 | 34600.0 |
| 2005-12-09 09:10:00 | SPY | ETF | 126.22 | 126.25 | 126.21 | 126.22 | 4500.0 |
| 2005-12-09 09:15:00 | SPY | ETF | 126.24 | 126.24 | 126.24 | 126.24 | 500.0 |
| 2005-12-09 09:20:00 | SPY | ETF | 126.2 | 126.22 | 126.2 | 126.22 | 3300.0 |
| 2005-12-09 09:25:00 | SPY | ETF | 126.22 | 126.22 | 126.18 | 126.18 | 10400.0 |
| 2005-12-09 09:30:00 | SPY | ETF | 126.16 | 126.27 | 126.11 | 126.22 | 1480800.0 |
| 2005-12-09 09:35:00 | SPY | ETF | 126.21 | 126.3 | 126.19 | 126.21 | 1106400.0 |
| 2005-12-09 09:40:00 | SPY | ETF | 126.22 | 126.27 | 126.16 | 126.2 | 916000.0 |
| 2005-12-09 09:45:00 | SPY | ETF | 126.2 | 126.33 | 126.16 | 126.24 | 1197400.0 |
| 2005-12-09 09:50:00 | SPY | ETF | 126.24 | 126.27 | 126.13 | 126.21 | 836100.0 |
| 2005-12-09 09:55:00 | SPY | ETF | 126.22 | 126.24 | 126.11 | 126.16 | 660800.0 |
| 2005-12-09 10:00:00 | SPY | ETF | 126.16 | 126.22 | 126.04 | 126.08 | 918900.0 |
| 2005-12-09 10:05:00 | SPY | ETF | 126.1 | 126.16 | 126.03 | 126.09 | 1178700.0 |
| 2005-12-09 10:10:00 | SPY | ETF | 126.09 | 126.13 | 126.03 | 126.05 | 497200.0 |
| 2005-12-09 10:15:00 | SPY | ETF | 126.07 | 126.16 | 126.01 | 126.05 | 759100.0 |
| 2005-12-09 10:20:00 | SPY | ETF | 126.05 | 126.09 | 125.89 | 125.93 | 1026300.0 |
| 2005-12-09 10:25:00 | SPY | ETF | 125.93 | 125.96 | 125.84 | 125.9 | 1278300.0 |
| 2005-12-09 10:30:00 | SPY | ETF | 125.88 | 125.93 | 125.82 | 125.91 | 887500.0 |
| 2005-12-09 10:35:00 | SPY | ETF | 125.91 | 125.97 | 125.83 | 125.95 | 955900.0 |
| 2005-12-09 10:40:00 | SPY | ETF | 125.96 | 125.97 | 125.89 | 125.9 | 1171600.0 |
| 2005-12-09 10:45:00 | SPY | ETF | 125.9 | 126.06 | 125.89 | 126.04 | 697600.0 |
| 2005-12-09 10:50:00 | SPY | ETF | 126.04 | 126.09 | 126.02 | 126.04 | 279100.0 |
| 2005-12-09 10:55:00 | SPY | ETF | 126.04 | 126.11 | 126.02 | 126.06 | 301300.0 |
| 2005-12-09 11:00:00 | SPY | ETF | 126.06 | 126.12 | 126.05 | 126.09 | 283300.0 |
| 2005-12-09 11:05:00 | SPY | ETF | 126.1 | 126.31 | 126.08 | 126.26 | 1532000.0 |
| 2005-12-09 11:10:00 | SPY | ETF | 126.26 | 126.36 | 126.23 | 126.25 | 886400.0 |
| 2005-12-09 11:15:00 | SPY | ETF | 126.25 | 126.28 | 126.13 | 126.13 | 508700.0 |
| 2005-12-09 11:20:00 | SPY | ETF | 126.12 | 126.2 | 126.09 | 126.13 | 529600.0 |
| 2005-12-09 11:25:00 | SPY | ETF | 126.13 | 126.18 | 126.09 | 126.1 | 110200.0 |
| 2005-12-09 11:30:00 | SPY | ETF | 126.11 | 126.15 | 126.09 | 126.14 | 86400.0 |
> showing 50 of 7,340 rows — these rows as CSV