PREVIEW / etf_5min / 2008-10-14
file: by_date/etf_5min/2008/2008-10-14.parquet size: 592 KB rows: 27,516
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-14 04:05:00 | SPY | ETF | 102.78 | 102.78 | 102.78 | 102.78 | 2000.0 |
| 2008-10-14 04:15:00 | SPY | ETF | 103.29 | 103.29 | 103.29 | 103.29 | 100.0 |
| 2008-10-14 04:35:00 | SPY | ETF | 103.02 | 103.02 | 103.02 | 103.02 | 100.0 |
| 2008-10-14 04:40:00 | SPY | ETF | 102.85 | 102.85 | 102.82 | 102.82 | 400.0 |
| 2008-10-14 04:50:00 | SPY | ETF | 102.25 | 102.32 | 102.25 | 102.32 | 400.0 |
| 2008-10-14 04:55:00 | SPY | ETF | 102.32 | 102.32 | 102.09 | 102.11 | 9500.0 |
| 2008-10-14 05:00:00 | SPY | ETF | 102.2 | 102.48 | 102.1 | 102.48 | 2600.0 |
| 2008-10-14 05:05:00 | SPY | ETF | 102.49 | 102.67 | 102.49 | 102.67 | 2000.0 |
| 2008-10-14 05:15:00 | SPY | ETF | 102.46 | 102.46 | 102.46 | 102.46 | 100.0 |
| 2008-10-14 05:20:00 | SPY | ETF | 102.6 | 102.6 | 102.6 | 102.6 | 100.0 |
| 2008-10-14 05:30:00 | SPY | ETF | 102.67 | 102.67 | 102.67 | 102.67 | 2000.0 |
| 2008-10-14 05:35:00 | SPY | ETF | 102.41 | 102.41 | 102.41 | 102.41 | 2000.0 |
| 2008-10-14 05:40:00 | SPY | ETF | 102.44 | 102.61 | 102.44 | 102.61 | 4000.0 |
| 2008-10-14 05:45:00 | SPY | ETF | 102.49 | 102.49 | 102.49 | 102.49 | 400.0 |
| 2008-10-14 05:55:00 | SPY | ETF | 102.81 | 102.81 | 102.8 | 102.8 | 1300.0 |
| 2008-10-14 06:00:00 | SPY | ETF | 102.8 | 102.8 | 102.77 | 102.77 | 800.0 |
| 2008-10-14 06:20:00 | SPY | ETF | 103.1 | 103.27 | 103.1 | 103.27 | 5000.0 |
| 2008-10-14 06:25:00 | SPY | ETF | 103.2 | 103.6 | 103.2 | 103.52 | 52800.0 |
| 2008-10-14 06:30:00 | SPY | ETF | 103.55 | 103.85 | 103.55 | 103.85 | 57000.0 |
| 2008-10-14 06:35:00 | SPY | ETF | 103.88 | 103.88 | 103.65 | 103.85 | 34920.0 |
| 2008-10-14 06:40:00 | SPY | ETF | 103.66 | 103.86 | 103.66 | 103.85 | 18800.0 |
| 2008-10-14 06:45:00 | SPY | ETF | 103.91 | 104.13 | 103.87 | 104.07 | 30350.0 |
| 2008-10-14 06:50:00 | SPY | ETF | 104.07 | 104.27 | 104.04 | 104.04 | 32200.0 |
| 2008-10-14 06:55:00 | SPY | ETF | 104.1 | 104.38 | 104.08 | 104.1 | 67278.0 |
| 2008-10-14 07:00:00 | SPY | ETF | 104.06 | 104.25 | 103.96 | 104.25 | 176252.0 |
| 2008-10-14 07:05:00 | SPY | ETF | 104.25 | 104.25 | 104.08 | 104.18 | 82940.0 |
| 2008-10-14 07:10:00 | SPY | ETF | 104.18 | 104.35 | 104.09 | 104.35 | 155700.0 |
| 2008-10-14 07:15:00 | SPY | ETF | 104.3 | 104.47 | 104.22 | 104.22 | 68200.0 |
| 2008-10-14 07:20:00 | SPY | ETF | 104.14 | 104.14 | 103.95 | 104.09 | 69759.0 |
| 2008-10-14 07:25:00 | SPY | ETF | 104.0 | 104.2 | 104.0 | 104.15 | 44934.0 |
| 2008-10-14 07:30:00 | SPY | ETF | 104.2 | 104.25 | 104.12 | 104.22 | 73811.0 |
| 2008-10-14 07:35:00 | SPY | ETF | 104.16 | 104.22 | 104.05 | 104.08 | 85585.0 |
| 2008-10-14 07:40:00 | SPY | ETF | 104.06 | 104.16 | 103.91 | 104.0 | 50825.0 |
| 2008-10-14 07:45:00 | SPY | ETF | 104.05 | 104.1 | 103.98 | 104.05 | 106350.0 |
| 2008-10-14 07:50:00 | SPY | ETF | 103.99 | 104.01 | 103.87 | 103.93 | 93240.0 |
| 2008-10-14 07:55:00 | SPY | ETF | 103.94 | 104.15 | 103.9 | 104.03 | 154020.0 |
| 2008-10-14 08:00:00 | SPY | ETF | 103.579 | 104.2 | 101.35 | 103.98 | 3590636.0 |
| 2008-10-14 08:05:00 | SPY | ETF | 103.96 | 104.58 | 103.96 | 104.53 | 956862.0 |
| 2008-10-14 08:10:00 | SPY | ETF | 104.55 | 104.72 | 104.02 | 104.54 | 781955.0 |
| 2008-10-14 08:15:00 | SPY | ETF | 104.54 | 104.83 | 104.51 | 104.78 | 491079.0 |
| 2008-10-14 08:20:00 | SPY | ETF | 104.82 | 105.29 | 104.81 | 105.16 | 810732.0 |
| 2008-10-14 08:25:00 | SPY | ETF | 105.15 | 105.18 | 104.93 | 105.05 | 1309670.0 |
| 2008-10-14 08:30:00 | SPY | ETF | 105.05 | 105.38 | 104.99 | 105.27 | 834796.0 |
| 2008-10-14 08:35:00 | SPY | ETF | 105.26 | 105.89 | 105.22 | 105.87 | 979166.0 |
| 2008-10-14 08:40:00 | SPY | ETF | 105.85 | 106.18 | 105.7 | 105.72 | 1802294.0 |
| 2008-10-14 08:45:00 | SPY | ETF | 105.72 | 105.72 | 102.25 | 105.15 | 1996368.0 |
| 2008-10-14 08:50:00 | SPY | ETF | 105.15 | 105.16 | 104.95 | 105.06 | 1882612.0 |
| 2008-10-14 08:55:00 | SPY | ETF | 105.04 | 105.31 | 104.95 | 104.96 | 1749442.0 |
| 2008-10-14 09:00:00 | SPY | ETF | 105.01 | 105.04 | 104.68 | 104.8 | 975953.0 |
| 2008-10-14 09:05:00 | SPY | ETF | 104.78 | 104.85 | 104.57 | 104.62 | 1871094.0 |
> showing 50 of 27,516 rows — these rows as CSV