PREVIEW / etf_5min / 2005-12-14
file: by_date/etf_5min/2005/2005-12-14.parquet size: 157 KB rows: 8,368
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-14 04:15:00 | SPY | ETF | 127.05 | 127.05 | 127.03 | 127.03 | 900.0 |
| 2005-12-14 04:55:00 | SPY | ETF | 127.03 | 127.03 | 127.03 | 127.03 | 1000.0 |
| 2005-12-14 05:55:00 | SPY | ETF | 127.07 | 127.07 | 127.07 | 127.07 | 25000.0 |
| 2005-12-14 06:45:00 | SPY | ETF | 127.08 | 127.08 | 127.08 | 127.08 | 25000.0 |
| 2005-12-14 07:05:00 | SPY | ETF | 127.04 | 127.04 | 127.04 | 127.04 | 100.0 |
| 2005-12-14 07:10:00 | SPY | ETF | 127.03 | 127.03 | 127.03 | 127.03 | 100.0 |
| 2005-12-14 07:15:00 | SPY | ETF | 127.05 | 127.05 | 127.0 | 127.0 | 34500.0 |
| 2005-12-14 07:20:00 | SPY | ETF | 127.06 | 127.06 | 127.06 | 127.06 | 500.0 |
| 2005-12-14 07:25:00 | SPY | ETF | 127.04 | 127.04 | 127.02 | 127.02 | 1200.0 |
| 2005-12-14 07:30:00 | SPY | ETF | 127.03 | 127.03 | 127.0 | 127.0 | 5000.0 |
| 2005-12-14 07:40:00 | SPY | ETF | 127.04 | 127.04 | 127.04 | 127.04 | 100.0 |
| 2005-12-14 07:45:00 | SPY | ETF | 127.07 | 127.07 | 127.06 | 127.06 | 5100.0 |
| 2005-12-14 07:50:00 | SPY | ETF | 127.07 | 127.07 | 127.07 | 127.07 | 200.0 |
| 2005-12-14 08:00:00 | SPY | ETF | 127.07 | 127.07 | 127.02 | 127.07 | 76000.0 |
| 2005-12-14 08:05:00 | SPY | ETF | 127.06 | 127.1 | 127.06 | 127.1 | 207500.0 |
| 2005-12-14 08:10:00 | SPY | ETF | 127.1 | 127.1 | 127.1 | 127.1 | 200.0 |
| 2005-12-14 08:15:00 | SPY | ETF | 127.12 | 127.13 | 127.11 | 127.11 | 15800.0 |
| 2005-12-14 08:20:00 | SPY | ETF | 127.13 | 127.13 | 127.13 | 127.13 | 2900.0 |
| 2005-12-14 08:25:00 | SPY | ETF | 127.11 | 127.2 | 127.11 | 127.2 | 15400.0 |
| 2005-12-14 08:30:00 | SPY | ETF | 127.1 | 127.19 | 127.1 | 127.19 | 264600.0 |
| 2005-12-14 08:35:00 | SPY | ETF | 127.17 | 127.18 | 127.17 | 127.17 | 337400.0 |
| 2005-12-14 08:40:00 | SPY | ETF | 127.18 | 127.18 | 127.15 | 127.17 | 23900.0 |
| 2005-12-14 08:45:00 | SPY | ETF | 127.15 | 127.18 | 127.12 | 127.18 | 6500.0 |
| 2005-12-14 08:50:00 | SPY | ETF | 127.18 | 127.21 | 127.17 | 127.21 | 108400.0 |
| 2005-12-14 08:55:00 | SPY | ETF | 127.21 | 127.23 | 127.2 | 127.23 | 1400.0 |
| 2005-12-14 09:00:00 | SPY | ETF | 127.23 | 127.27 | 127.23 | 127.25 | 54400.0 |
| 2005-12-14 09:05:00 | SPY | ETF | 127.26 | 127.28 | 127.26 | 127.28 | 12600.0 |
| 2005-12-14 09:10:00 | SPY | ETF | 127.27 | 127.3 | 127.24 | 127.27 | 36300.0 |
| 2005-12-14 09:15:00 | SPY | ETF | 127.26 | 127.29 | 127.24 | 127.29 | 66800.0 |
| 2005-12-14 09:20:00 | SPY | ETF | 127.22 | 127.26 | 127.22 | 127.25 | 161200.0 |
| 2005-12-14 09:25:00 | SPY | ETF | 127.25 | 127.27 | 127.19 | 127.19 | 16600.0 |
| 2005-12-14 09:30:00 | SPY | ETF | 127.19 | 127.28 | 127.14 | 127.23 | 651600.0 |
| 2005-12-14 09:35:00 | SPY | ETF | 127.23 | 127.51 | 127.21 | 127.5 | 1723500.0 |
| 2005-12-14 09:40:00 | SPY | ETF | 127.5 | 127.63 | 127.39 | 127.56 | 3995200.0 |
| 2005-12-14 09:45:00 | SPY | ETF | 127.56 | 127.65 | 127.52 | 127.54 | 2170300.0 |
| 2005-12-14 09:50:00 | SPY | ETF | 127.54 | 127.59 | 127.42 | 127.49 | 3822200.0 |
| 2005-12-14 09:55:00 | SPY | ETF | 127.49 | 127.6 | 127.45 | 127.54 | 917200.0 |
| 2005-12-14 10:00:00 | SPY | ETF | 127.53 | 127.56 | 127.37 | 127.46 | 507300.0 |
| 2005-12-14 10:05:00 | SPY | ETF | 127.47 | 127.47 | 127.38 | 127.43 | 557600.0 |
| 2005-12-14 10:10:00 | SPY | ETF | 127.43 | 127.57 | 127.41 | 127.45 | 646400.0 |
| 2005-12-14 10:15:00 | SPY | ETF | 127.47 | 127.56 | 127.43 | 127.44 | 588100.0 |
| 2005-12-14 10:20:00 | SPY | ETF | 127.43 | 127.59 | 127.43 | 127.54 | 558500.0 |
| 2005-12-14 10:25:00 | SPY | ETF | 127.55 | 127.59 | 127.53 | 127.55 | 645500.0 |
| 2005-12-14 10:30:00 | SPY | ETF | 127.55 | 127.7 | 127.49 | 127.67 | 1655000.0 |
| 2005-12-14 10:35:00 | SPY | ETF | 127.68 | 127.77 | 127.58 | 127.58 | 1620500.0 |
| 2005-12-14 10:40:00 | SPY | ETF | 127.58 | 127.74 | 127.5424 | 127.6 | 540000.0 |
| 2005-12-14 10:45:00 | SPY | ETF | 127.62 | 127.64 | 127.49 | 127.52 | 591200.0 |
| 2005-12-14 10:50:00 | SPY | ETF | 127.52 | 127.55 | 127.44 | 127.51 | 491300.0 |
| 2005-12-14 10:55:00 | SPY | ETF | 127.5 | 127.57 | 127.39 | 127.4 | 725300.0 |
| 2005-12-14 11:00:00 | SPY | ETF | 127.4 | 127.44 | 127.3 | 127.35 | 1313600.0 |
> showing 50 of 8,368 rows — these rows as CSV