PREVIEW / etf_5min / 2008-12-08
file: by_date/etf_5min/2008/2008-12-08.parquet size: 588 KB rows: 28,573
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-12-08 04:15:00 | SPY | ETF | 89.96 | 89.99 | 89.96 | 89.99 | 1200.0 |
| 2008-12-08 04:20:00 | SPY | ETF | 89.91 | 89.91 | 89.9 | 89.9 | 1200.0 |
| 2008-12-08 04:25:00 | SPY | ETF | 89.91 | 89.96 | 89.91 | 89.96 | 300.0 |
| 2008-12-08 04:30:00 | SPY | ETF | 89.99 | 90.01 | 89.9 | 89.9 | 1596.0 |
| 2008-12-08 04:35:00 | SPY | ETF | 89.73 | 89.73 | 89.73 | 89.73 | 200.0 |
| 2008-12-08 04:40:00 | SPY | ETF | 89.71 | 89.71 | 89.71 | 89.71 | 100.0 |
| 2008-12-08 04:45:00 | SPY | ETF | 89.66 | 89.66 | 89.66 | 89.66 | 100.0 |
| 2008-12-08 05:00:00 | SPY | ETF | 89.68 | 89.69 | 89.68 | 89.69 | 12500.0 |
| 2008-12-08 05:05:00 | SPY | ETF | 89.69 | 89.69 | 89.69 | 89.69 | 7500.0 |
| 2008-12-08 05:15:00 | SPY | ETF | 89.33 | 89.33 | 89.33 | 89.33 | 100.0 |
| 2008-12-08 05:20:00 | SPY | ETF | 89.44 | 89.44 | 89.44 | 89.44 | 100.0 |
| 2008-12-08 05:25:00 | SPY | ETF | 89.48 | 89.48 | 89.48 | 89.48 | 400.0 |
| 2008-12-08 05:35:00 | SPY | ETF | 89.39 | 89.45 | 89.39 | 89.45 | 200.0 |
| 2008-12-08 05:40:00 | SPY | ETF | 89.62 | 89.66 | 89.62 | 89.62 | 800.0 |
| 2008-12-08 05:45:00 | SPY | ETF | 89.79 | 89.79 | 89.64 | 89.65 | 3688.0 |
| 2008-12-08 05:50:00 | SPY | ETF | 89.72 | 89.72 | 89.72 | 89.72 | 1294.0 |
| 2008-12-08 05:55:00 | SPY | ETF | 89.86 | 89.86 | 89.86 | 89.86 | 200.0 |
| 2008-12-08 06:00:00 | SPY | ETF | 89.88 | 90.25 | 89.88 | 90.25 | 1800.0 |
| 2008-12-08 06:05:00 | SPY | ETF | 89.98 | 89.98 | 89.88 | 89.88 | 300.0 |
| 2008-12-08 06:10:00 | SPY | ETF | 89.81 | 89.91 | 89.81 | 89.91 | 12200.0 |
| 2008-12-08 06:25:00 | SPY | ETF | 89.95 | 89.95 | 89.95 | 89.95 | 1000.0 |
| 2008-12-08 06:30:00 | SPY | ETF | 89.9 | 89.95 | 89.9 | 89.95 | 7500.0 |
| 2008-12-08 06:35:00 | SPY | ETF | 89.9 | 90.11 | 89.9 | 90.11 | 2844.0 |
| 2008-12-08 06:40:00 | SPY | ETF | 90.05 | 90.1 | 90.04 | 90.04 | 6100.0 |
| 2008-12-08 06:45:00 | SPY | ETF | 90.03 | 90.2 | 90.01 | 90.2 | 7800.0 |
| 2008-12-08 06:50:00 | SPY | ETF | 90.13 | 90.25 | 90.13 | 90.25 | 6370.0 |
| 2008-12-08 06:55:00 | SPY | ETF | 90.21 | 90.35 | 90.21 | 90.35 | 61218.0 |
| 2008-12-08 07:00:00 | SPY | ETF | 90.39 | 90.43 | 90.22 | 90.22 | 160033.0 |
| 2008-12-08 07:05:00 | SPY | ETF | 90.25 | 90.3 | 90.2 | 90.25 | 59807.0 |
| 2008-12-08 07:10:00 | SPY | ETF | 90.23 | 90.26 | 90.13 | 90.16 | 59000.0 |
| 2008-12-08 07:15:00 | SPY | ETF | 90.16 | 90.23 | 90.0 | 90.08 | 100413.0 |
| 2008-12-08 07:20:00 | SPY | ETF | 90.1 | 90.24 | 90.07 | 90.24 | 37495.0 |
| 2008-12-08 07:25:00 | SPY | ETF | 90.25 | 90.25 | 90.08 | 90.1 | 75350.0 |
| 2008-12-08 07:30:00 | SPY | ETF | 90.1 | 90.1 | 89.9 | 90.02 | 173661.0 |
| 2008-12-08 07:35:00 | SPY | ETF | 90.0 | 90.17 | 90.0 | 90.1 | 217077.0 |
| 2008-12-08 07:40:00 | SPY | ETF | 90.11 | 90.11 | 89.98 | 90.03 | 51509.0 |
| 2008-12-08 07:45:00 | SPY | ETF | 90.02 | 90.26 | 90.0 | 90.26 | 78999.0 |
| 2008-12-08 07:50:00 | SPY | ETF | 90.26 | 90.41 | 90.22 | 90.4 | 223463.0 |
| 2008-12-08 07:55:00 | SPY | ETF | 90.39 | 90.53 | 90.34 | 90.34 | 110945.0 |
| 2008-12-08 08:00:00 | SPY | ETF | 90.35 | 90.35 | 90.15 | 90.18 | 350353.0 |
| 2008-12-08 08:05:00 | SPY | ETF | 90.18 | 90.76 | 90.17 | 90.69 | 542039.0 |
| 2008-12-08 08:10:00 | SPY | ETF | 90.68 | 90.94 | 89.85 | 90.6 | 841216.0 |
| 2008-12-08 08:15:00 | SPY | ETF | 90.58 | 90.7 | 90.56 | 90.6 | 176117.0 |
| 2008-12-08 08:20:00 | SPY | ETF | 90.6 | 90.66 | 90.55 | 90.66 | 273471.0 |
| 2008-12-08 08:25:00 | SPY | ETF | 90.62 | 90.75 | 89.55 | 90.72 | 146871.0 |
| 2008-12-08 08:30:00 | SPY | ETF | 90.73 | 90.85 | 90.64 | 90.8 | 271190.0 |
| 2008-12-08 08:35:00 | SPY | ETF | 90.8 | 91.04 | 90.76 | 91.0 | 599311.0 |
| 2008-12-08 08:40:00 | SPY | ETF | 91.0 | 91.01 | 90.81 | 90.82 | 338796.0 |
| 2008-12-08 08:45:00 | SPY | ETF | 90.82 | 90.83 | 90.7 | 90.8 | 936937.0 |
| 2008-12-08 08:50:00 | SPY | ETF | 90.81 | 90.87 | 90.64 | 90.66 | 329965.0 |
> showing 50 of 28,573 rows — these rows as CSV