PREVIEW / etf_5min / 2019-08-16
file: by_date/etf_5min/2019/2019-08-16.parquet size: 1.4 MB rows: 62,457
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-08-16 04:00:00 | SPY | ETF | 286.48 | 286.77 | 286.48 | 286.77 | 4546.0 |
| 2019-08-16 04:05:00 | SPY | ETF | 286.81 | 286.81 | 286.79 | 286.79 | 700.0 |
| 2019-08-16 04:10:00 | SPY | ETF | 286.76 | 286.84 | 286.76 | 286.84 | 700.0 |
| 2019-08-16 04:15:00 | SPY | ETF | 286.83 | 286.85 | 286.56 | 286.73 | 1430.0 |
| 2019-08-16 04:20:00 | SPY | ETF | 286.78 | 286.8 | 286.73 | 286.8 | 2150.0 |
| 2019-08-16 04:25:00 | SPY | ETF | 286.78 | 286.86 | 286.7 | 286.7 | 1300.0 |
| 2019-08-16 04:30:00 | SPY | ETF | 286.73 | 287.04 | 286.73 | 287.04 | 3348.0 |
| 2019-08-16 04:35:00 | SPY | ETF | 287.1 | 287.43 | 287.1 | 287.4 | 23540.0 |
| 2019-08-16 04:40:00 | SPY | ETF | 287.43 | 287.55 | 287.36 | 287.36 | 3597.0 |
| 2019-08-16 04:45:00 | SPY | ETF | 287.39 | 287.39 | 287.34 | 287.34 | 14804.0 |
| 2019-08-16 04:50:00 | SPY | ETF | 287.25 | 287.34 | 287.25 | 287.29 | 12325.0 |
| 2019-08-16 04:55:00 | SPY | ETF | 287.3 | 287.54 | 287.3 | 287.44 | 2787.0 |
| 2019-08-16 05:00:00 | SPY | ETF | 287.47 | 287.56 | 287.4 | 287.51 | 4905.0 |
| 2019-08-16 05:05:00 | SPY | ETF | 287.49 | 287.69 | 287.49 | 287.57 | 1512.0 |
| 2019-08-16 05:10:00 | SPY | ETF | 287.61 | 287.71 | 287.54 | 287.56 | 4129.0 |
| 2019-08-16 05:15:00 | SPY | ETF | 287.55 | 287.66 | 287.52 | 287.56 | 6630.0 |
| 2019-08-16 05:20:00 | SPY | ETF | 287.5 | 287.61 | 287.39 | 287.57 | 6834.0 |
| 2019-08-16 05:25:00 | SPY | ETF | 287.54 | 287.54 | 287.37 | 287.46 | 3721.0 |
| 2019-08-16 05:30:00 | SPY | ETF | 287.41 | 287.41 | 287.32 | 287.32 | 1150.0 |
| 2019-08-16 05:35:00 | SPY | ETF | 287.36 | 287.44 | 287.33 | 287.36 | 2440.0 |
| 2019-08-16 05:40:00 | SPY | ETF | 287.35 | 287.41 | 287.22 | 287.22 | 5313.0 |
| 2019-08-16 05:45:00 | SPY | ETF | 287.2 | 287.28 | 287.2 | 287.28 | 2910.0 |
| 2019-08-16 05:50:00 | SPY | ETF | 287.23 | 287.33 | 287.06 | 287.33 | 6443.0 |
| 2019-08-16 05:55:00 | SPY | ETF | 287.38 | 287.48 | 287.3 | 287.41 | 40944.0 |
| 2019-08-16 06:00:00 | SPY | ETF | 287.44 | 287.44 | 287.31 | 287.31 | 2200.0 |
| 2019-08-16 06:05:00 | SPY | ETF | 287.28 | 287.45 | 287.21 | 287.45 | 1821.0 |
| 2019-08-16 06:10:00 | SPY | ETF | 287.45 | 287.45 | 287.35 | 287.4 | 5000.0 |
| 2019-08-16 06:15:00 | SPY | ETF | 287.46 | 287.53 | 287.32 | 287.53 | 3940.0 |
| 2019-08-16 06:20:00 | SPY | ETF | 287.46 | 287.63 | 287.4 | 287.48 | 4755.0 |
| 2019-08-16 06:25:00 | SPY | ETF | 287.42 | 287.47 | 287.42 | 287.47 | 1000.0 |
| 2019-08-16 06:30:00 | SPY | ETF | 287.4 | 287.4 | 287.24 | 287.24 | 3481.0 |
| 2019-08-16 06:35:00 | SPY | ETF | 287.22 | 287.28 | 287.22 | 287.28 | 1650.0 |
| 2019-08-16 06:40:00 | SPY | ETF | 287.34 | 287.39 | 287.34 | 287.39 | 2226.0 |
| 2019-08-16 06:45:00 | SPY | ETF | 287.43 | 287.43 | 287.36 | 287.43 | 1700.0 |
| 2019-08-16 06:50:00 | SPY | ETF | 287.5 | 287.58 | 287.44 | 287.53 | 3810.0 |
| 2019-08-16 07:00:00 | SPY | ETF | 287.49 | 287.6 | 287.48 | 287.6 | 26255.0 |
| 2019-08-16 07:05:00 | SPY | ETF | 287.62 | 287.66 | 287.5 | 287.5 | 20759.0 |
| 2019-08-16 07:10:00 | SPY | ETF | 287.5 | 287.59 | 287.32 | 287.35 | 24673.0 |
| 2019-08-16 07:15:00 | SPY | ETF | 287.33 | 287.41 | 287.28 | 287.39 | 13098.0 |
| 2019-08-16 07:20:00 | SPY | ETF | 287.26 | 287.36 | 287.23 | 287.3 | 10501.0 |
| 2019-08-16 07:25:00 | SPY | ETF | 287.37 | 287.48 | 287.33 | 287.41 | 9429.0 |
| 2019-08-16 07:30:00 | SPY | ETF | 287.34 | 287.36 | 287.15 | 287.22 | 22037.0 |
| 2019-08-16 07:35:00 | SPY | ETF | 287.26 | 287.27 | 287.16 | 287.18 | 14336.0 |
| 2019-08-16 07:40:00 | SPY | ETF | 287.2 | 287.3 | 287.16 | 287.24 | 64113.0 |
| 2019-08-16 07:45:00 | SPY | ETF | 287.25 | 287.31 | 287.25 | 287.31 | 12191.0 |
| 2019-08-16 07:50:00 | SPY | ETF | 287.31 | 287.32 | 287.21 | 287.32 | 47473.0 |
| 2019-08-16 07:55:00 | SPY | ETF | 287.3 | 287.3 | 287.06 | 287.11 | 28159.0 |
| 2019-08-16 08:00:00 | SPY | ETF | 287.12 | 287.64 | 286.15 | 287.09 | 74745.0 |
| 2019-08-16 08:05:00 | SPY | ETF | 287.15 | 287.25 | 287.15 | 287.25 | 34599.0 |
| 2019-08-16 08:10:00 | SPY | ETF | 287.3 | 287.33 | 287.08 | 287.15 | 12260.0 |
> showing 50 of 62,457 rows — these rows as CSV