PREVIEW / etf_5min / 2019-06-11
file: by_date/etf_5min/2019/2019-06-11.parquet size: 1.4 MB rows: 60,942
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-06-11 04:00:00 | SPY | ETF | 289.82 | 290.0 | 289.82 | 290.0 | 2325.0 |
| 2019-06-11 04:05:00 | SPY | ETF | 289.95 | 289.95 | 289.85 | 289.85 | 1750.0 |
| 2019-06-11 04:10:00 | SPY | ETF | 289.9 | 289.9 | 289.9 | 289.9 | 513.0 |
| 2019-06-11 04:15:00 | SPY | ETF | 290.0 | 290.0 | 289.89 | 289.89 | 1100.0 |
| 2019-06-11 04:20:00 | SPY | ETF | 290.02 | 290.02 | 290.02 | 290.02 | 100.0 |
| 2019-06-11 04:35:00 | SPY | ETF | 290.1 | 290.1 | 290.1 | 290.1 | 150.0 |
| 2019-06-11 04:40:00 | SPY | ETF | 290.2 | 290.2 | 290.2 | 290.2 | 1600.0 |
| 2019-06-11 04:45:00 | SPY | ETF | 290.1 | 290.15 | 290.09 | 290.15 | 3600.0 |
| 2019-06-11 04:50:00 | SPY | ETF | 290.17 | 290.25 | 290.17 | 290.19 | 1150.0 |
| 2019-06-11 04:55:00 | SPY | ETF | 290.2 | 290.2 | 290.17 | 290.17 | 2000.0 |
| 2019-06-11 05:00:00 | SPY | ETF | 290.14 | 290.17 | 290.11 | 290.11 | 700.0 |
| 2019-06-11 05:05:00 | SPY | ETF | 290.11 | 290.11 | 290.11 | 290.11 | 850.0 |
| 2019-06-11 05:15:00 | SPY | ETF | 290.24 | 290.39 | 290.24 | 290.39 | 714.0 |
| 2019-06-11 05:20:00 | SPY | ETF | 290.36 | 290.5 | 290.36 | 290.5 | 2762.0 |
| 2019-06-11 05:25:00 | SPY | ETF | 290.48 | 290.51 | 290.48 | 290.51 | 2304.0 |
| 2019-06-11 05:30:00 | SPY | ETF | 290.54 | 290.6 | 290.52 | 290.6 | 2900.0 |
| 2019-06-11 05:35:00 | SPY | ETF | 290.49 | 290.52 | 290.39 | 290.39 | 2976.0 |
| 2019-06-11 05:40:00 | SPY | ETF | 290.47 | 290.47 | 290.47 | 290.47 | 350.0 |
| 2019-06-11 05:45:00 | SPY | ETF | 290.5 | 290.6 | 290.5 | 290.6 | 10100.0 |
| 2019-06-11 05:55:00 | SPY | ETF | 290.55 | 290.57 | 290.55 | 290.57 | 1700.0 |
| 2019-06-11 06:00:00 | SPY | ETF | 290.57 | 290.62 | 290.52 | 290.57 | 4165.0 |
| 2019-06-11 06:05:00 | SPY | ETF | 290.62 | 290.62 | 290.6 | 290.6 | 3593.0 |
| 2019-06-11 06:10:00 | SPY | ETF | 290.57 | 290.57 | 290.5 | 290.55 | 739.0 |
| 2019-06-11 06:20:00 | SPY | ETF | 290.6 | 290.6 | 290.6 | 290.6 | 200.0 |
| 2019-06-11 06:25:00 | SPY | ETF | 290.64 | 290.64 | 290.62 | 290.62 | 1277.0 |
| 2019-06-11 06:35:00 | SPY | ETF | 290.5 | 290.52 | 290.5 | 290.5 | 4500.0 |
| 2019-06-11 06:40:00 | SPY | ETF | 290.47 | 290.5 | 290.47 | 290.5 | 600.0 |
| 2019-06-11 06:45:00 | SPY | ETF | 290.49 | 290.49 | 290.42 | 290.42 | 850.0 |
| 2019-06-11 06:50:00 | SPY | ETF | 290.44 | 290.45 | 290.42 | 290.42 | 1403.0 |
| 2019-06-11 06:55:00 | SPY | ETF | 290.42 | 290.42 | 290.42 | 290.42 | 921.0 |
| 2019-06-11 07:00:00 | SPY | ETF | 290.37 | 290.41 | 290.35 | 290.35 | 5340.0 |
| 2019-06-11 07:05:00 | SPY | ETF | 290.31 | 290.36 | 290.26 | 290.3 | 17543.0 |
| 2019-06-11 07:10:00 | SPY | ETF | 290.34 | 290.36 | 290.29 | 290.31 | 31211.0 |
| 2019-06-11 07:15:00 | SPY | ETF | 290.31 | 290.43 | 290.3 | 290.41 | 14467.0 |
| 2019-06-11 07:20:00 | SPY | ETF | 290.43 | 290.43 | 290.37 | 290.41 | 7774.0 |
| 2019-06-11 07:25:00 | SPY | ETF | 290.4 | 290.44 | 290.38 | 290.41 | 5470.0 |
| 2019-06-11 07:30:00 | SPY | ETF | 290.38 | 290.45 | 290.38 | 290.45 | 9636.0 |
| 2019-06-11 07:35:00 | SPY | ETF | 290.44 | 290.52 | 290.43 | 290.51 | 21140.0 |
| 2019-06-11 07:40:00 | SPY | ETF | 290.49 | 290.52 | 290.48 | 290.51 | 8258.0 |
| 2019-06-11 07:45:00 | SPY | ETF | 290.51 | 290.56 | 290.51 | 290.56 | 6201.0 |
| 2019-06-11 07:50:00 | SPY | ETF | 290.47 | 290.47 | 290.4 | 290.44 | 33550.0 |
| 2019-06-11 07:55:00 | SPY | ETF | 290.46 | 290.49 | 290.43 | 290.46 | 3847.0 |
| 2019-06-11 08:00:00 | SPY | ETF | 290.54 | 290.63 | 289.5 | 290.6 | 702175.0 |
| 2019-06-11 08:05:00 | SPY | ETF | 290.6 | 290.72 | 290.58 | 290.72 | 75817.0 |
| 2019-06-11 08:10:00 | SPY | ETF | 290.73 | 290.74 | 290.65 | 290.6899 | 41948.0 |
| 2019-06-11 08:15:00 | SPY | ETF | 290.66 | 290.66 | 290.6 | 290.6 | 4693.0 |
| 2019-06-11 08:20:00 | SPY | ETF | 290.61 | 290.72 | 290.61 | 290.68 | 8411.0 |
| 2019-06-11 08:25:00 | SPY | ETF | 290.68 | 290.72 | 290.65 | 290.7 | 12452.0 |
| 2019-06-11 08:30:00 | SPY | ETF | 290.7 | 290.92 | 290.7 | 290.9 | 69153.0 |
| 2019-06-11 08:35:00 | SPY | ETF | 290.9 | 291.03 | 290.88 | 290.96 | 62029.0 |
> showing 50 of 60,942 rows — these rows as CSV