PREVIEW / etf_5min / 2020-10-28
file: by_date/etf_5min/2020/2020-10-28.parquet size: 1.8 MB rows: 81,241
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-10-28 04:00:00 | SPY | ETF | 335.27 | 335.57 | 335.27 | 335.4 | 4713.0 |
| 2020-10-28 04:05:00 | SPY | ETF | 335.41 | 335.41 | 335.0 | 335.0 | 5139.0 |
| 2020-10-28 04:10:00 | SPY | ETF | 335.06 | 335.06 | 334.19 | 334.21 | 23489.0 |
| 2020-10-28 04:15:00 | SPY | ETF | 334.17 | 334.17 | 333.54 | 333.69 | 15830.0 |
| 2020-10-28 04:20:00 | SPY | ETF | 333.74 | 333.89 | 333.5 | 333.53 | 49144.0 |
| 2020-10-28 04:25:00 | SPY | ETF | 333.49 | 333.7 | 333.35 | 333.6 | 17312.0 |
| 2020-10-28 04:30:00 | SPY | ETF | 333.6 | 333.69 | 333.46 | 333.64 | 23321.0 |
| 2020-10-28 04:35:00 | SPY | ETF | 333.45 | 333.54 | 333.17 | 333.17 | 10182.0 |
| 2020-10-28 04:40:00 | SPY | ETF | 333.21 | 333.67 | 333.21 | 333.63 | 11251.0 |
| 2020-10-28 04:45:00 | SPY | ETF | 333.63 | 333.92 | 333.53 | 333.92 | 7698.0 |
| 2020-10-28 04:50:00 | SPY | ETF | 334.02 | 334.19 | 333.88 | 333.88 | 13304.0 |
| 2020-10-28 04:55:00 | SPY | ETF | 333.93 | 334.2 | 333.83 | 334.2 | 8639.0 |
| 2020-10-28 05:00:00 | SPY | ETF | 334.07 | 334.07 | 333.88 | 334.04 | 6807.0 |
| 2020-10-28 05:05:00 | SPY | ETF | 334.15 | 334.27 | 334.15 | 334.23 | 14763.0 |
| 2020-10-28 05:10:00 | SPY | ETF | 334.3 | 334.57 | 334.15 | 334.57 | 8424.0 |
| 2020-10-28 05:15:00 | SPY | ETF | 334.48 | 334.53 | 334.26 | 334.26 | 23352.0 |
| 2020-10-28 05:20:00 | SPY | ETF | 334.23 | 334.25 | 334.1 | 334.18 | 21290.0 |
| 2020-10-28 05:25:00 | SPY | ETF | 334.33 | 334.33 | 334.02 | 334.05 | 1980.0 |
| 2020-10-28 05:30:00 | SPY | ETF | 334.03 | 334.03 | 333.77 | 333.8 | 12856.0 |
| 2020-10-28 05:35:00 | SPY | ETF | 333.9 | 333.9 | 333.55 | 333.55 | 16611.0 |
| 2020-10-28 05:40:00 | SPY | ETF | 333.57 | 333.59 | 333.31 | 333.57 | 5504.0 |
| 2020-10-28 05:45:00 | SPY | ETF | 333.69 | 333.69 | 333.53 | 333.53 | 14548.0 |
| 2020-10-28 05:50:00 | SPY | ETF | 333.52 | 333.65 | 333.46 | 333.6 | 8198.0 |
| 2020-10-28 05:55:00 | SPY | ETF | 333.8 | 333.84 | 333.8 | 333.84 | 639.0 |
| 2020-10-28 06:00:00 | SPY | ETF | 333.89 | 334.05 | 333.87 | 334.01 | 2531.0 |
| 2020-10-28 06:05:00 | SPY | ETF | 334.0 | 334.07 | 333.97 | 334.02 | 2485.0 |
| 2020-10-28 06:10:00 | SPY | ETF | 334.02 | 334.07 | 333.94 | 334.07 | 730.0 |
| 2020-10-28 06:15:00 | SPY | ETF | 333.98 | 334.12 | 333.94 | 334.12 | 1650.0 |
| 2020-10-28 06:20:00 | SPY | ETF | 334.07 | 334.3 | 334.07 | 334.09 | 11484.0 |
| 2020-10-28 06:25:00 | SPY | ETF | 334.02 | 334.02 | 333.69 | 333.69 | 6083.0 |
| 2020-10-28 06:30:00 | SPY | ETF | 333.73 | 333.99 | 333.7 | 333.93 | 2113.0 |
| 2020-10-28 06:35:00 | SPY | ETF | 333.79 | 334.0 | 333.79 | 334.0 | 1166.0 |
| 2020-10-28 06:40:00 | SPY | ETF | 334.02 | 334.03 | 333.91 | 334.01 | 17432.0 |
| 2020-10-28 06:45:00 | SPY | ETF | 333.96 | 334.01 | 333.89 | 333.89 | 9161.0 |
| 2020-10-28 06:50:00 | SPY | ETF | 333.84 | 333.84 | 333.59 | 333.74 | 4014.0 |
| 2020-10-28 06:55:00 | SPY | ETF | 333.69 | 333.69 | 333.3 | 333.3 | 11031.0 |
| 2020-10-28 07:00:00 | SPY | ETF | 333.39 | 333.65 | 333.31 | 333.5 | 43793.0 |
| 2020-10-28 07:05:00 | SPY | ETF | 333.43 | 333.47 | 332.99 | 333.07 | 57613.0 |
| 2020-10-28 07:10:00 | SPY | ETF | 333.09 | 333.39 | 332.86 | 333.39 | 30240.0 |
| 2020-10-28 07:15:00 | SPY | ETF | 333.39 | 333.67 | 333.34 | 333.67 | 19642.0 |
| 2020-10-28 07:20:00 | SPY | ETF | 333.65 | 333.7 | 333.51 | 333.53 | 23064.0 |
| 2020-10-28 07:25:00 | SPY | ETF | 333.58 | 333.6 | 333.5 | 333.52 | 44100.0 |
| 2020-10-28 07:30:00 | SPY | ETF | 333.53 | 333.66 | 333.41 | 333.5 | 7038.0 |
| 2020-10-28 07:35:00 | SPY | ETF | 333.48 | 333.48 | 333.28 | 333.28 | 11201.0 |
| 2020-10-28 07:40:00 | SPY | ETF | 333.33 | 333.63 | 333.33 | 333.63 | 9514.0 |
| 2020-10-28 07:45:00 | SPY | ETF | 333.69 | 333.76 | 333.58 | 333.76 | 21209.0 |
| 2020-10-28 07:50:00 | SPY | ETF | 333.76 | 333.76 | 333.63 | 333.74 | 32311.0 |
| 2020-10-28 07:55:00 | SPY | ETF | 333.77 | 333.82 | 333.33 | 333.4 | 47262.0 |
| 2020-10-28 08:00:00 | SPY | ETF | 333.37 | 337.05 | 332.9 | 334.25 | 393629.0 |
| 2020-10-28 08:05:00 | SPY | ETF | 333.29 | 333.36 | 333.02 | 333.33 | 34594.0 |
> showing 50 of 81,241 rows — these rows as CSV