PREVIEW / etf_5min / 2020-10-15
file: by_date/etf_5min/2020/2020-10-15.parquet size: 1.6 MB rows: 71,952
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-15 04:00:00 | SPY | ETF | 346.34 | 346.34 | 345.88 | 345.88 | 12231.0 |
| 2020-10-15 04:05:00 | SPY | ETF | 345.77 | 345.87 | 345.73 | 345.76 | 6765.0 |
| 2020-10-15 04:10:00 | SPY | ETF | 345.87 | 346.0 | 345.87 | 345.93 | 2785.0 |
| 2020-10-15 04:15:00 | SPY | ETF | 345.78 | 345.78 | 345.58 | 345.65 | 5726.0 |
| 2020-10-15 04:20:00 | SPY | ETF | 345.49 | 345.53 | 345.34 | 345.35 | 8203.0 |
| 2020-10-15 04:25:00 | SPY | ETF | 345.4 | 345.57 | 345.35 | 345.5 | 2750.0 |
| 2020-10-15 04:30:00 | SPY | ETF | 345.42 | 345.42 | 344.53 | 344.75 | 18252.0 |
| 2020-10-15 04:35:00 | SPY | ETF | 344.8 | 344.96 | 344.73 | 344.73 | 7753.0 |
| 2020-10-15 04:40:00 | SPY | ETF | 344.8 | 344.8 | 344.25 | 344.3 | 15131.0 |
| 2020-10-15 04:45:00 | SPY | ETF | 344.4 | 344.68 | 344.4 | 344.47 | 14000.0 |
| 2020-10-15 04:50:00 | SPY | ETF | 344.5 | 344.5 | 344.15 | 344.28 | 7143.0 |
| 2020-10-15 04:55:00 | SPY | ETF | 344.26 | 344.43 | 344.17 | 344.43 | 1550.0 |
| 2020-10-15 05:00:00 | SPY | ETF | 344.33 | 344.33 | 344.08 | 344.16 | 3628.0 |
| 2020-10-15 05:05:00 | SPY | ETF | 344.16 | 344.58 | 343.98 | 344.52 | 15368.0 |
| 2020-10-15 05:10:00 | SPY | ETF | 344.51 | 344.51 | 344.31 | 344.41 | 5380.0 |
| 2020-10-15 05:15:00 | SPY | ETF | 344.41 | 344.43 | 344.21 | 344.21 | 6709.0 |
| 2020-10-15 05:20:00 | SPY | ETF | 344.17 | 344.33 | 343.96 | 344.0 | 12515.0 |
| 2020-10-15 05:25:00 | SPY | ETF | 344.0 | 344.45 | 343.94 | 344.28 | 34011.0 |
| 2020-10-15 05:30:00 | SPY | ETF | 344.29 | 344.29 | 344.01 | 344.06 | 5355.0 |
| 2020-10-15 05:35:00 | SPY | ETF | 344.08 | 344.08 | 343.91 | 343.91 | 5270.0 |
| 2020-10-15 05:40:00 | SPY | ETF | 343.86 | 343.86 | 343.63 | 343.65 | 22791.0 |
| 2020-10-15 05:45:00 | SPY | ETF | 343.57 | 344.1 | 343.39 | 344.1 | 10233.0 |
| 2020-10-15 05:50:00 | SPY | ETF | 344.08 | 344.17 | 343.98 | 344.12 | 6737.0 |
| 2020-10-15 05:55:00 | SPY | ETF | 344.11 | 344.27 | 344.02 | 344.27 | 1496.0 |
| 2020-10-15 06:00:00 | SPY | ETF | 344.2 | 344.7 | 344.2 | 344.5 | 18852.0 |
| 2020-10-15 06:05:00 | SPY | ETF | 344.41 | 344.52 | 344.27 | 344.27 | 5313.0 |
| 2020-10-15 06:10:00 | SPY | ETF | 344.24 | 344.38 | 344.24 | 344.24 | 3005.0 |
| 2020-10-15 06:15:00 | SPY | ETF | 344.26 | 344.4 | 343.99 | 344.4 | 5598.0 |
| 2020-10-15 06:20:00 | SPY | ETF | 344.35 | 344.35 | 343.96 | 344.18 | 15496.0 |
| 2020-10-15 06:25:00 | SPY | ETF | 344.0 | 344.36 | 343.77 | 344.36 | 44318.0 |
| 2020-10-15 06:30:00 | SPY | ETF | 344.4 | 344.4 | 344.3 | 344.32 | 1268.0 |
| 2020-10-15 06:35:00 | SPY | ETF | 344.33 | 344.59 | 344.29 | 344.55 | 6057.0 |
| 2020-10-15 06:40:00 | SPY | ETF | 344.54 | 344.7 | 344.48 | 344.7 | 6207.0 |
| 2020-10-15 06:45:00 | SPY | ETF | 344.74 | 344.78 | 344.48 | 344.52 | 41138.0 |
| 2020-10-15 06:50:00 | SPY | ETF | 344.54 | 344.62 | 344.5 | 344.5 | 58350.0 |
| 2020-10-15 06:55:00 | SPY | ETF | 344.56 | 344.66 | 344.5 | 344.66 | 13519.0 |
| 2020-10-15 07:00:00 | SPY | ETF | 344.7 | 345.05 | 344.59 | 344.96 | 53480.0 |
| 2020-10-15 07:05:00 | SPY | ETF | 344.88 | 344.88 | 344.59 | 344.59 | 10044.0 |
| 2020-10-15 07:10:00 | SPY | ETF | 344.61 | 344.7 | 344.27 | 344.28 | 36055.0 |
| 2020-10-15 07:15:00 | SPY | ETF | 344.33 | 344.67 | 344.21 | 344.62 | 32249.0 |
| 2020-10-15 07:20:00 | SPY | ETF | 344.62 | 344.92 | 344.6 | 344.85 | 28278.0 |
| 2020-10-15 07:25:00 | SPY | ETF | 344.78 | 344.85 | 344.72 | 344.83 | 3924.0 |
| 2020-10-15 07:30:00 | SPY | ETF | 344.84 | 345.02 | 344.66 | 344.72 | 16774.0 |
| 2020-10-15 07:35:00 | SPY | ETF | 344.83 | 344.87 | 344.6 | 344.674 | 52956.0 |
| 2020-10-15 07:40:00 | SPY | ETF | 344.71 | 344.81 | 344.51 | 344.78 | 25106.0 |
| 2020-10-15 07:45:00 | SPY | ETF | 344.78 | 344.85 | 344.5 | 344.57 | 16724.0 |
| 2020-10-15 07:50:00 | SPY | ETF | 344.67 | 344.69 | 344.17 | 344.2 | 45132.0 |
| 2020-10-15 07:55:00 | SPY | ETF | 344.2 | 344.45 | 344.19 | 344.4 | 26549.0 |
| 2020-10-15 08:00:00 | SPY | ETF | 344.37 | 347.3 | 344.14 | 344.24 | 87210.0 |
| 2020-10-15 08:05:00 | SPY | ETF | 344.22 | 344.27 | 343.99 | 344.02 | 55437.0 |
> showing 50 of 71,952 rows — these rows as CSV