PREVIEW / etf_5min / 2008-11-13
file: by_date/etf_5min/2008/2008-11-13.parquet size: 597 KB rows: 27,649
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-11-13 04:05:00 | SPY | ETF | 86.24 | 86.26 | 86.21 | 86.26 | 5500.0 |
| 2008-11-13 04:15:00 | SPY | ETF | 86.34 | 86.55 | 86.34 | 86.55 | 400.0 |
| 2008-11-13 04:20:00 | SPY | ETF | 86.65 | 86.69 | 86.65 | 86.69 | 200.0 |
| 2008-11-13 04:25:00 | SPY | ETF | 86.63 | 86.63 | 86.6 | 86.6 | 300.0 |
| 2008-11-13 04:30:00 | SPY | ETF | 86.55 | 86.55 | 86.55 | 86.55 | 100.0 |
| 2008-11-13 04:40:00 | SPY | ETF | 86.41 | 86.41 | 86.41 | 86.41 | 100.0 |
| 2008-11-13 04:50:00 | SPY | ETF | 86.52 | 86.52 | 86.52 | 86.52 | 300.0 |
| 2008-11-13 05:00:00 | SPY | ETF | 86.28 | 86.28 | 86.18 | 86.18 | 200.0 |
| 2008-11-13 05:05:00 | SPY | ETF | 86.04 | 86.04 | 86.04 | 86.04 | 200.0 |
| 2008-11-13 05:10:00 | SPY | ETF | 85.96 | 86.03 | 85.96 | 86.03 | 200.0 |
| 2008-11-13 05:15:00 | SPY | ETF | 85.7 | 85.7 | 85.54 | 85.54 | 200.0 |
| 2008-11-13 05:20:00 | SPY | ETF | 85.48 | 85.48 | 85.31 | 85.31 | 200.0 |
| 2008-11-13 05:25:00 | SPY | ETF | 85.52 | 85.52 | 85.52 | 85.52 | 300.0 |
| 2008-11-13 05:30:00 | SPY | ETF | 85.51 | 85.51 | 85.51 | 85.51 | 100.0 |
| 2008-11-13 05:35:00 | SPY | ETF | 85.12 | 85.12 | 85.12 | 85.12 | 100.0 |
| 2008-11-13 05:40:00 | SPY | ETF | 84.94 | 84.94 | 84.94 | 84.94 | 200.0 |
| 2008-11-13 05:45:00 | SPY | ETF | 85.22 | 85.22 | 85.22 | 85.22 | 200.0 |
| 2008-11-13 06:05:00 | SPY | ETF | 85.24 | 85.26 | 85.24 | 85.26 | 500.0 |
| 2008-11-13 06:10:00 | SPY | ETF | 85.05 | 85.05 | 85.05 | 85.05 | 500.0 |
| 2008-11-13 06:15:00 | SPY | ETF | 84.95 | 84.95 | 84.77 | 84.85 | 7500.0 |
| 2008-11-13 06:20:00 | SPY | ETF | 85.0 | 85.0 | 84.95 | 84.95 | 25300.0 |
| 2008-11-13 06:25:00 | SPY | ETF | 85.27 | 85.32 | 85.26 | 85.26 | 41900.0 |
| 2008-11-13 06:30:00 | SPY | ETF | 85.3 | 85.48 | 85.3 | 85.34 | 37000.0 |
| 2008-11-13 06:40:00 | SPY | ETF | 85.41 | 85.56 | 85.41 | 85.56 | 12300.0 |
| 2008-11-13 06:45:00 | SPY | ETF | 85.76 | 85.77 | 85.72 | 85.77 | 2500.0 |
| 2008-11-13 06:50:00 | SPY | ETF | 85.5 | 85.5 | 85.5 | 85.5 | 2500.0 |
| 2008-11-13 06:55:00 | SPY | ETF | 85.47 | 85.52 | 85.47 | 85.52 | 5200.0 |
| 2008-11-13 07:00:00 | SPY | ETF | 85.6 | 85.81 | 85.51 | 85.81 | 40800.0 |
| 2008-11-13 07:05:00 | SPY | ETF | 85.81 | 86.22 | 85.81 | 86.08 | 160200.0 |
| 2008-11-13 07:10:00 | SPY | ETF | 86.05 | 86.05 | 85.9 | 86.0 | 136450.0 |
| 2008-11-13 07:15:00 | SPY | ETF | 86.05 | 86.3 | 85.99 | 86.3 | 63646.0 |
| 2008-11-13 07:20:00 | SPY | ETF | 86.26 | 86.4 | 86.02 | 86.02 | 135700.0 |
| 2008-11-13 07:25:00 | SPY | ETF | 86.02 | 86.29 | 86.02 | 86.29 | 60624.0 |
| 2008-11-13 07:30:00 | SPY | ETF | 86.3 | 86.45 | 86.03 | 86.03 | 370910.0 |
| 2008-11-13 07:35:00 | SPY | ETF | 86.08 | 86.17 | 85.92 | 86.15 | 60600.0 |
| 2008-11-13 07:40:00 | SPY | ETF | 86.15 | 86.16 | 85.93 | 85.95 | 74987.0 |
| 2008-11-13 07:45:00 | SPY | ETF | 85.99 | 86.05 | 85.95 | 86.05 | 65220.0 |
| 2008-11-13 07:50:00 | SPY | ETF | 86.0 | 86.03 | 85.89 | 85.89 | 249551.0 |
| 2008-11-13 07:55:00 | SPY | ETF | 85.89 | 85.9 | 85.5 | 85.57 | 444363.0 |
| 2008-11-13 08:00:00 | SPY | ETF | 85.58 | 86.37 | 84.759 | 85.84 | 2042151.0 |
| 2008-11-13 08:05:00 | SPY | ETF | 85.83 | 86.01 | 85.58 | 85.65 | 400369.0 |
| 2008-11-13 08:10:00 | SPY | ETF | 85.66 | 85.8 | 85.54 | 85.63 | 217517.0 |
| 2008-11-13 08:15:00 | SPY | ETF | 85.63 | 85.65 | 85.35 | 85.35 | 175390.0 |
| 2008-11-13 08:20:00 | SPY | ETF | 85.35 | 85.61 | 85.34 | 85.5 | 170989.0 |
| 2008-11-13 08:25:00 | SPY | ETF | 85.49 | 85.58 | 85.33 | 85.33 | 205173.0 |
| 2008-11-13 08:30:00 | SPY | ETF | 85.33 | 85.51 | 85.12 | 85.33 | 1402772.0 |
| 2008-11-13 08:35:00 | SPY | ETF | 85.3 | 85.8 | 85.27 | 85.79 | 512819.0 |
| 2008-11-13 08:40:00 | SPY | ETF | 85.76 | 85.76 | 85.61 | 85.63 | 306625.0 |
| 2008-11-13 08:45:00 | SPY | ETF | 85.62 | 85.72 | 85.56 | 85.56 | 173349.0 |
| 2008-11-13 08:50:00 | SPY | ETF | 85.56 | 85.59 | 85.42 | 85.42 | 331260.0 |
> showing 50 of 27,649 rows — these rows as CSV