PREVIEW / etf_5min / 2008-12-19
file: by_date/etf_5min/2008/2008-12-19.parquet size: 570 KB rows: 27,682
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-19 04:15:00 | SPY | ETF | 88.89 | 88.9 | 88.8 | 88.8 | 1020.0 |
| 2008-12-19 04:20:00 | SPY | ETF | 88.82 | 88.82 | 88.82 | 88.82 | 100.0 |
| 2008-12-19 04:25:00 | SPY | ETF | 88.87 | 88.87 | 88.87 | 88.87 | 100.0 |
| 2008-12-19 04:30:00 | SPY | ETF | 88.85 | 88.85 | 88.85 | 88.85 | 100.0 |
| 2008-12-19 04:35:00 | SPY | ETF | 88.92 | 88.92 | 88.89 | 88.89 | 600.0 |
| 2008-12-19 04:50:00 | SPY | ETF | 88.87 | 88.87 | 88.87 | 88.87 | 100.0 |
| 2008-12-19 04:55:00 | SPY | ETF | 88.81 | 88.82 | 88.77 | 88.77 | 885.0 |
| 2008-12-19 05:00:00 | SPY | ETF | 88.71 | 88.72 | 88.7 | 88.72 | 300.0 |
| 2008-12-19 05:05:00 | SPY | ETF | 89.0 | 89.0 | 89.0 | 89.0 | 100.0 |
| 2008-12-19 05:10:00 | SPY | ETF | 88.92 | 88.92 | 88.7 | 88.7 | 1060.0 |
| 2008-12-19 05:15:00 | SPY | ETF | 88.72 | 88.72 | 88.72 | 88.72 | 400.0 |
| 2008-12-19 05:20:00 | SPY | ETF | 88.66 | 88.66 | 88.48 | 88.48 | 850.0 |
| 2008-12-19 05:25:00 | SPY | ETF | 88.5 | 88.55 | 88.45 | 88.45 | 990.0 |
| 2008-12-19 05:30:00 | SPY | ETF | 88.44 | 88.44 | 88.35 | 88.35 | 700.0 |
| 2008-12-19 05:35:00 | SPY | ETF | 88.38 | 88.38 | 88.35 | 88.35 | 680.0 |
| 2008-12-19 05:45:00 | SPY | ETF | 88.45 | 88.45 | 88.45 | 88.45 | 180.0 |
| 2008-12-19 05:50:00 | SPY | ETF | 88.63 | 88.88 | 88.63 | 88.88 | 400.0 |
| 2008-12-19 05:55:00 | SPY | ETF | 88.88 | 88.88 | 88.81 | 88.81 | 1325.0 |
| 2008-12-19 06:00:00 | SPY | ETF | 88.74 | 88.74 | 88.74 | 88.74 | 100.0 |
| 2008-12-19 06:05:00 | SPY | ETF | 88.65 | 88.65 | 88.58 | 88.58 | 1750.0 |
| 2008-12-19 06:10:00 | SPY | ETF | 88.64 | 88.66 | 88.64 | 88.66 | 240.0 |
| 2008-12-19 06:15:00 | SPY | ETF | 88.71 | 88.76 | 88.67 | 88.67 | 900.0 |
| 2008-12-19 06:20:00 | SPY | ETF | 88.75 | 88.75 | 88.71 | 88.71 | 400.0 |
| 2008-12-19 06:25:00 | SPY | ETF | 88.51 | 88.55 | 88.51 | 88.55 | 1300.0 |
| 2008-12-19 06:30:00 | SPY | ETF | 88.5 | 88.5 | 88.5 | 88.5 | 500.0 |
| 2008-12-19 06:35:00 | SPY | ETF | 88.55 | 88.55 | 88.44 | 88.44 | 200.0 |
| 2008-12-19 06:40:00 | SPY | ETF | 88.4 | 88.4 | 88.38 | 88.38 | 1700.0 |
| 2008-12-19 06:45:00 | SPY | ETF | 88.38 | 88.38 | 88.37 | 88.37 | 26700.0 |
| 2008-12-19 06:50:00 | SPY | ETF | 88.33 | 88.57 | 88.33 | 88.53 | 4200.0 |
| 2008-12-19 06:55:00 | SPY | ETF | 88.49 | 88.7 | 88.49 | 88.7 | 11300.0 |
| 2008-12-19 07:00:00 | SPY | ETF | 88.7 | 88.72 | 88.47 | 88.49 | 51566.0 |
| 2008-12-19 07:05:00 | SPY | ETF | 88.5 | 88.67 | 88.45 | 88.45 | 49170.0 |
| 2008-12-19 07:10:00 | SPY | ETF | 88.46 | 88.55 | 88.38 | 88.55 | 25753.0 |
| 2008-12-19 07:15:00 | SPY | ETF | 88.52 | 88.52 | 88.42 | 88.5 | 38631.0 |
| 2008-12-19 07:20:00 | SPY | ETF | 88.49 | 88.5 | 88.39 | 88.44 | 71325.0 |
| 2008-12-19 07:25:00 | SPY | ETF | 88.4 | 88.57 | 88.4 | 88.53 | 53684.0 |
| 2008-12-19 07:30:00 | SPY | ETF | 88.53 | 88.64 | 88.51 | 88.55 | 85590.0 |
| 2008-12-19 07:35:00 | SPY | ETF | 88.53 | 88.58 | 88.53 | 88.55 | 82285.0 |
| 2008-12-19 07:40:00 | SPY | ETF | 88.56 | 88.58 | 88.54 | 88.54 | 124775.0 |
| 2008-12-19 07:45:00 | SPY | ETF | 88.56 | 88.63 | 88.55 | 88.59 | 248006.0 |
| 2008-12-19 07:50:00 | SPY | ETF | 88.59 | 88.69 | 88.59 | 88.67 | 54549.0 |
| 2008-12-19 07:55:00 | SPY | ETF | 88.67 | 88.8 | 88.65 | 88.77 | 218631.0 |
| 2008-12-19 08:00:00 | SPY | ETF | 88.75 | 88.79 | 88.2 | 88.7 | 249006.0 |
| 2008-12-19 08:05:00 | SPY | ETF | 88.69 | 88.78 | 88.69 | 88.77 | 213932.0 |
| 2008-12-19 08:10:00 | SPY | ETF | 88.77 | 89.42 | 88.76 | 89.24 | 792952.0 |
| 2008-12-19 08:15:00 | SPY | ETF | 89.25 | 89.38 | 89.2 | 89.27 | 763836.0 |
| 2008-12-19 08:20:00 | SPY | ETF | 89.27 | 89.29 | 89.13 | 89.16 | 259654.0 |
| 2008-12-19 08:25:00 | SPY | ETF | 89.16 | 89.2 | 89.0 | 89.05 | 233383.0 |
| 2008-12-19 08:30:00 | SPY | ETF | 89.05 | 89.26 | 89.01 | 89.24 | 392391.0 |
| 2008-12-19 08:35:00 | SPY | ETF | 89.24 | 89.28 | 89.16 | 89.23 | 363635.0 |
> showing 50 of 27,682 rows — these rows as CSV