PREVIEW / etf_5min / 2020-06-16
file: by_date/etf_5min/2020/2020-06-16.parquet size: 1.7 MB rows: 79,944
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 |
|---|---|---|---|---|---|---|---|
| 2020-06-16 04:00:00 | SPY | ETF | 310.17 | 310.39 | 309.82 | 310.07 | 23860.0 |
| 2020-06-16 04:05:00 | SPY | ETF | 310.03 | 310.2 | 309.5 | 309.81 | 25179.0 |
| 2020-06-16 04:10:00 | SPY | ETF | 309.82 | 310.38 | 309.82 | 310.14 | 27393.0 |
| 2020-06-16 04:15:00 | SPY | ETF | 310.18 | 310.44 | 310.09 | 310.09 | 14642.0 |
| 2020-06-16 04:20:00 | SPY | ETF | 310.24 | 310.24 | 310.12 | 310.15 | 4001.0 |
| 2020-06-16 04:25:00 | SPY | ETF | 310.05 | 310.6 | 310.0 | 310.59 | 39330.0 |
| 2020-06-16 04:30:00 | SPY | ETF | 310.49 | 310.62 | 310.37 | 310.62 | 23823.0 |
| 2020-06-16 04:35:00 | SPY | ETF | 310.66 | 311.11 | 310.66 | 311.06 | 9441.0 |
| 2020-06-16 04:40:00 | SPY | ETF | 311.0 | 311.13 | 311.0 | 311.1 | 2950.0 |
| 2020-06-16 04:45:00 | SPY | ETF | 310.86 | 311.02 | 310.83 | 310.84 | 32043.0 |
| 2020-06-16 04:50:00 | SPY | ETF | 311.04 | 311.09 | 310.99 | 311.09 | 2086.0 |
| 2020-06-16 04:55:00 | SPY | ETF | 311.1 | 311.18 | 310.96 | 311.06 | 3035.0 |
| 2020-06-16 05:00:00 | SPY | ETF | 311.21 | 311.39 | 311.12 | 311.12 | 5305.0 |
| 2020-06-16 05:05:00 | SPY | ETF | 311.24 | 311.37 | 311.19 | 311.35 | 2265.0 |
| 2020-06-16 05:10:00 | SPY | ETF | 311.28 | 311.28 | 310.81 | 310.89 | 7884.0 |
| 2020-06-16 05:15:00 | SPY | ETF | 310.99 | 311.02 | 310.91 | 310.91 | 550.0 |
| 2020-06-16 05:20:00 | SPY | ETF | 310.96 | 311.09 | 310.89 | 311.07 | 5927.0 |
| 2020-06-16 05:25:00 | SPY | ETF | 311.14 | 311.25 | 311.13 | 311.13 | 2688.0 |
| 2020-06-16 05:30:00 | SPY | ETF | 311.18 | 311.18 | 311.0 | 311.03 | 3061.0 |
| 2020-06-16 05:35:00 | SPY | ETF | 310.98 | 311.03 | 310.68 | 310.75 | 6928.0 |
| 2020-06-16 05:40:00 | SPY | ETF | 311.07 | 311.2 | 310.96 | 311.2 | 7021.0 |
| 2020-06-16 05:45:00 | SPY | ETF | 311.09 | 311.25 | 310.79 | 311.25 | 6100.0 |
| 2020-06-16 05:50:00 | SPY | ETF | 311.29 | 311.29 | 311.0 | 311.19 | 5604.0 |
| 2020-06-16 05:55:00 | SPY | ETF | 311.17 | 311.18 | 310.98 | 311.1 | 2983.0 |
| 2020-06-16 06:00:00 | SPY | ETF | 311.2 | 311.2 | 310.88 | 310.88 | 11386.0 |
| 2020-06-16 06:05:00 | SPY | ETF | 310.92 | 311.22 | 310.92 | 311.22 | 5813.0 |
| 2020-06-16 06:10:00 | SPY | ETF | 311.39 | 311.54 | 311.28 | 311.54 | 26756.0 |
| 2020-06-16 06:15:00 | SPY | ETF | 311.56 | 311.6 | 311.46 | 311.46 | 19617.0 |
| 2020-06-16 06:20:00 | SPY | ETF | 311.54 | 311.67 | 311.54 | 311.67 | 2077.0 |
| 2020-06-16 06:25:00 | SPY | ETF | 311.7 | 311.99 | 311.7 | 311.99 | 15865.0 |
| 2020-06-16 06:30:00 | SPY | ETF | 311.99 | 312.1 | 311.9 | 311.93 | 26565.0 |
| 2020-06-16 06:35:00 | SPY | ETF | 311.97 | 312.02 | 311.78 | 311.8 | 47337.0 |
| 2020-06-16 06:40:00 | SPY | ETF | 311.79 | 311.82 | 311.72 | 311.76 | 57641.0 |
| 2020-06-16 06:45:00 | SPY | ETF | 311.74 | 311.79 | 311.51 | 311.59 | 83184.0 |
| 2020-06-16 06:50:00 | SPY | ETF | 311.54 | 311.65 | 311.54 | 311.58 | 38070.0 |
| 2020-06-16 06:55:00 | SPY | ETF | 311.57 | 311.69 | 311.54 | 311.69 | 25885.0 |
| 2020-06-16 07:00:00 | SPY | ETF | 311.75 | 311.81 | 311.6 | 311.63 | 60777.0 |
| 2020-06-16 07:05:00 | SPY | ETF | 311.65 | 311.65 | 311.43 | 311.43 | 85175.0 |
| 2020-06-16 07:10:00 | SPY | ETF | 311.42 | 311.45 | 311.13 | 311.2 | 152813.0 |
| 2020-06-16 07:15:00 | SPY | ETF | 311.15 | 311.23 | 311.1 | 311.17 | 119335.0 |
| 2020-06-16 07:20:00 | SPY | ETF | 311.19 | 311.43 | 311.12 | 311.379 | 42089.0 |
| 2020-06-16 07:25:00 | SPY | ETF | 311.32 | 311.55 | 311.3 | 311.5 | 34450.0 |
| 2020-06-16 07:30:00 | SPY | ETF | 311.5 | 311.51 | 311.2 | 311.31 | 81936.0 |
| 2020-06-16 07:35:00 | SPY | ETF | 311.3 | 311.45 | 311.25 | 311.42 | 44912.0 |
| 2020-06-16 07:40:00 | SPY | ETF | 311.42 | 311.46 | 311.29 | 311.37 | 81592.0 |
| 2020-06-16 07:45:00 | SPY | ETF | 311.38 | 311.7 | 311.36 | 311.7 | 52380.0 |
| 2020-06-16 07:50:00 | SPY | ETF | 311.7 | 312.05 | 311.65 | 312.0 | 66404.0 |
| 2020-06-16 07:55:00 | SPY | ETF | 312.05 | 312.1 | 311.97 | 312.05 | 32053.0 |
| 2020-06-16 08:00:00 | SPY | ETF | 312.8 | 312.8 | 310.36 | 312.2 | 421657.0 |
| 2020-06-16 08:05:00 | SPY | ETF | 312.2 | 312.39 | 312.07 | 312.3499 | 71416.0 |
> showing 50 of 79,944 rows — these rows as CSV