PREVIEW / etf_5min / 2019-12-04
file: by_date/etf_5min/2019/2019-12-04.parquet size: 1.4 MB rows: 62,643
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 |
|---|---|---|---|---|---|---|---|
| 2019-12-04 04:00:00 | SPY | ETF | 309.14 | 309.14 | 309.14 | 309.14 | 240.0 |
| 2019-12-04 04:05:00 | SPY | ETF | 309.31 | 310.98 | 309.31 | 310.19 | 11121.0 |
| 2019-12-04 04:10:00 | SPY | ETF | 310.28 | 310.66 | 310.28 | 310.59 | 4250.0 |
| 2019-12-04 04:15:00 | SPY | ETF | 310.82 | 310.82 | 310.64 | 310.64 | 2092.0 |
| 2019-12-04 04:20:00 | SPY | ETF | 310.69 | 310.76 | 310.69 | 310.74 | 625.0 |
| 2019-12-04 04:25:00 | SPY | ETF | 310.67 | 310.67 | 310.67 | 310.67 | 400.0 |
| 2019-12-04 04:30:00 | SPY | ETF | 310.75 | 310.84 | 310.45 | 310.45 | 17825.0 |
| 2019-12-04 04:35:00 | SPY | ETF | 310.46 | 310.46 | 310.27 | 310.28 | 1960.0 |
| 2019-12-04 04:40:00 | SPY | ETF | 310.17 | 310.22 | 310.16 | 310.22 | 12080.0 |
| 2019-12-04 04:45:00 | SPY | ETF | 310.2 | 310.39 | 310.14 | 310.24 | 14795.0 |
| 2019-12-04 04:50:00 | SPY | ETF | 310.31 | 310.35 | 310.31 | 310.35 | 1100.0 |
| 2019-12-04 04:55:00 | SPY | ETF | 310.43 | 310.85 | 310.4 | 310.85 | 16759.0 |
| 2019-12-04 05:00:00 | SPY | ETF | 310.74 | 310.74 | 310.61 | 310.61 | 5350.0 |
| 2019-12-04 05:05:00 | SPY | ETF | 310.58 | 310.58 | 310.5 | 310.56 | 3500.0 |
| 2019-12-04 05:10:00 | SPY | ETF | 310.5 | 310.53 | 310.5 | 310.53 | 1350.0 |
| 2019-12-04 05:15:00 | SPY | ETF | 310.66 | 310.66 | 310.66 | 310.66 | 605.0 |
| 2019-12-04 05:20:00 | SPY | ETF | 310.56 | 310.61 | 310.56 | 310.61 | 2900.0 |
| 2019-12-04 05:25:00 | SPY | ETF | 310.62 | 310.64 | 310.59 | 310.61 | 1405.0 |
| 2019-12-04 05:30:00 | SPY | ETF | 310.66 | 310.76 | 310.59 | 310.59 | 6354.0 |
| 2019-12-04 05:35:00 | SPY | ETF | 310.59 | 310.59 | 310.56 | 310.56 | 2620.0 |
| 2019-12-04 05:40:00 | SPY | ETF | 310.54 | 310.61 | 310.54 | 310.59 | 1225.0 |
| 2019-12-04 05:45:00 | SPY | ETF | 310.58 | 310.58 | 310.48 | 310.48 | 2221.0 |
| 2019-12-04 05:50:00 | SPY | ETF | 310.46 | 310.46 | 310.42 | 310.46 | 1400.0 |
| 2019-12-04 05:55:00 | SPY | ETF | 310.49 | 310.49 | 310.46 | 310.46 | 550.0 |
| 2019-12-04 06:00:00 | SPY | ETF | 310.4 | 310.4 | 310.4 | 310.4 | 350.0 |
| 2019-12-04 06:05:00 | SPY | ETF | 310.51 | 310.51 | 310.51 | 310.51 | 2790.0 |
| 2019-12-04 06:10:00 | SPY | ETF | 310.51 | 310.66 | 310.5 | 310.66 | 2120.0 |
| 2019-12-04 06:15:00 | SPY | ETF | 310.64 | 310.68 | 310.6 | 310.6 | 12222.0 |
| 2019-12-04 06:20:00 | SPY | ETF | 310.61 | 310.61 | 310.6 | 310.6 | 2900.0 |
| 2019-12-04 06:25:00 | SPY | ETF | 310.61 | 310.61 | 310.59 | 310.59 | 1800.0 |
| 2019-12-04 06:30:00 | SPY | ETF | 310.6 | 310.62 | 310.55 | 310.62 | 5240.0 |
| 2019-12-04 06:35:00 | SPY | ETF | 310.61 | 310.61 | 310.58 | 310.58 | 2419.0 |
| 2019-12-04 06:40:00 | SPY | ETF | 310.57 | 310.8 | 310.57 | 310.76 | 5774.0 |
| 2019-12-04 06:45:00 | SPY | ETF | 310.75 | 310.75 | 310.69 | 310.69 | 3040.0 |
| 2019-12-04 06:50:00 | SPY | ETF | 310.69 | 310.7 | 310.68 | 310.7 | 13385.0 |
| 2019-12-04 06:55:00 | SPY | ETF | 310.82 | 310.82 | 310.79 | 310.79 | 800.0 |
| 2019-12-04 07:00:00 | SPY | ETF | 310.82 | 310.82 | 310.67 | 310.7 | 9602.0 |
| 2019-12-04 07:05:00 | SPY | ETF | 310.7 | 310.78 | 310.7 | 310.78 | 11440.0 |
| 2019-12-04 07:10:00 | SPY | ETF | 310.75 | 310.84 | 310.74 | 310.84 | 58165.0 |
| 2019-12-04 07:15:00 | SPY | ETF | 310.84 | 310.89 | 310.84 | 310.84 | 7499.0 |
| 2019-12-04 07:20:00 | SPY | ETF | 310.84 | 310.85 | 310.77 | 310.8 | 42910.0 |
| 2019-12-04 07:25:00 | SPY | ETF | 310.8 | 310.95 | 310.8 | 310.93 | 7907.0 |
| 2019-12-04 07:30:00 | SPY | ETF | 310.879 | 310.88 | 310.85 | 310.85 | 1161.0 |
| 2019-12-04 07:35:00 | SPY | ETF | 310.81 | 310.88 | 310.81 | 310.88 | 11765.0 |
| 2019-12-04 07:40:00 | SPY | ETF | 310.82 | 310.85 | 310.8 | 310.83 | 6415.0 |
| 2019-12-04 07:45:00 | SPY | ETF | 310.82 | 310.85 | 310.65 | 310.65 | 11267.0 |
| 2019-12-04 07:50:00 | SPY | ETF | 310.67 | 310.75 | 310.67 | 310.75 | 13175.0 |
| 2019-12-04 07:55:00 | SPY | ETF | 310.73 | 310.75 | 310.73 | 310.75 | 4932.0 |
| 2019-12-04 08:00:00 | SPY | ETF | 308.74 | 310.9 | 308.48 | 310.82 | 357484.0 |
| 2019-12-04 08:05:00 | SPY | ETF | 310.8 | 310.82 | 310.57 | 310.76 | 22070.0 |
> showing 50 of 62,643 rows — these rows as CSV