PREVIEW / etf_5min / 2020-10-30
file: by_date/etf_5min/2020/2020-10-30.parquet size: 1.7 MB rows: 77,167
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-30 04:00:00 | SPY | ETF | 324.41 | 325.2 | 324.41 | 325.2 | 18588.0 |
| 2020-10-30 04:05:00 | SPY | ETF | 325.07 | 325.33 | 324.92 | 325.33 | 6391.0 |
| 2020-10-30 04:10:00 | SPY | ETF | 325.28 | 325.46 | 325.21 | 325.34 | 4914.0 |
| 2020-10-30 04:15:00 | SPY | ETF | 325.59 | 325.89 | 325.57 | 325.7 | 2357.0 |
| 2020-10-30 04:20:00 | SPY | ETF | 325.65 | 325.68 | 325.57 | 325.68 | 1625.0 |
| 2020-10-30 04:25:00 | SPY | ETF | 325.54 | 325.83 | 325.5 | 325.77 | 4887.0 |
| 2020-10-30 04:30:00 | SPY | ETF | 325.9 | 325.9 | 325.61 | 325.8 | 4693.0 |
| 2020-10-30 04:35:00 | SPY | ETF | 325.83 | 326.1 | 325.82 | 325.88 | 7150.0 |
| 2020-10-30 04:40:00 | SPY | ETF | 325.78 | 325.78 | 325.49 | 325.49 | 9154.0 |
| 2020-10-30 04:45:00 | SPY | ETF | 325.34 | 325.35 | 325.21 | 325.21 | 5596.0 |
| 2020-10-30 04:50:00 | SPY | ETF | 325.14 | 325.2 | 324.7 | 324.7 | 4404.0 |
| 2020-10-30 04:55:00 | SPY | ETF | 325.04 | 325.47 | 325.04 | 325.28 | 3743.0 |
| 2020-10-30 05:00:00 | SPY | ETF | 325.3 | 325.54 | 325.3 | 325.54 | 13796.0 |
| 2020-10-30 05:05:00 | SPY | ETF | 325.19 | 325.31 | 325.19 | 325.31 | 612.0 |
| 2020-10-30 05:10:00 | SPY | ETF | 325.47 | 325.55 | 325.46 | 325.46 | 25832.0 |
| 2020-10-30 05:15:00 | SPY | ETF | 325.81 | 326.31 | 325.81 | 326.31 | 5926.0 |
| 2020-10-30 05:20:00 | SPY | ETF | 326.38 | 326.72 | 326.36 | 326.7 | 7119.0 |
| 2020-10-30 05:25:00 | SPY | ETF | 326.49 | 326.66 | 326.49 | 326.64 | 7428.0 |
| 2020-10-30 05:30:00 | SPY | ETF | 326.65 | 326.65 | 326.34 | 326.34 | 3546.0 |
| 2020-10-30 05:35:00 | SPY | ETF | 326.46 | 326.61 | 326.46 | 326.61 | 1745.0 |
| 2020-10-30 05:40:00 | SPY | ETF | 326.95 | 327.17 | 326.84 | 327.16 | 14110.0 |
| 2020-10-30 05:45:00 | SPY | ETF | 326.97 | 327.31 | 326.9 | 327.31 | 7765.0 |
| 2020-10-30 05:50:00 | SPY | ETF | 327.41 | 327.71 | 327.2 | 327.23 | 22322.0 |
| 2020-10-30 05:55:00 | SPY | ETF | 327.18 | 327.21 | 326.97 | 327.21 | 5924.0 |
| 2020-10-30 06:00:00 | SPY | ETF | 327.15 | 327.17 | 326.94 | 327.17 | 5285.0 |
| 2020-10-30 06:05:00 | SPY | ETF | 326.97 | 327.5 | 326.97 | 327.5 | 3192.0 |
| 2020-10-30 06:10:00 | SPY | ETF | 327.4 | 327.61 | 327.4 | 327.59 | 1663.0 |
| 2020-10-30 06:15:00 | SPY | ETF | 327.59 | 327.59 | 327.02 | 327.05 | 7781.0 |
| 2020-10-30 06:20:00 | SPY | ETF | 327.04 | 327.09 | 326.76 | 326.94 | 17328.0 |
| 2020-10-30 06:25:00 | SPY | ETF | 326.98 | 327.5 | 326.98 | 327.5 | 3969.0 |
| 2020-10-30 06:30:00 | SPY | ETF | 327.5 | 327.68 | 327.37 | 327.65 | 2914.0 |
| 2020-10-30 06:35:00 | SPY | ETF | 327.6 | 327.7 | 327.42 | 327.45 | 3948.0 |
| 2020-10-30 06:40:00 | SPY | ETF | 327.25 | 327.37 | 327.09 | 327.19 | 5634.0 |
| 2020-10-30 06:45:00 | SPY | ETF | 327.35 | 327.92 | 327.27 | 327.3 | 28491.0 |
| 2020-10-30 06:50:00 | SPY | ETF | 327.01 | 327.82 | 327.01 | 327.82 | 13725.0 |
| 2020-10-30 06:55:00 | SPY | ETF | 327.84 | 328.16 | 327.84 | 328.09 | 76457.0 |
| 2020-10-30 07:00:00 | SPY | ETF | 328.04 | 328.77 | 328.04 | 328.47 | 89558.0 |
| 2020-10-30 07:05:00 | SPY | ETF | 328.46 | 329.15 | 328.43 | 329.04 | 30402.0 |
| 2020-10-30 07:10:00 | SPY | ETF | 328.91 | 329.02 | 328.49 | 328.49 | 73265.0 |
| 2020-10-30 07:15:00 | SPY | ETF | 328.51 | 328.51 | 328.19 | 328.31 | 71744.0 |
| 2020-10-30 07:20:00 | SPY | ETF | 328.3 | 328.39 | 328.19 | 328.24 | 17824.0 |
| 2020-10-30 07:25:00 | SPY | ETF | 328.45 | 328.45 | 328.2 | 328.2 | 9899.0 |
| 2020-10-30 07:30:00 | SPY | ETF | 328.2 | 328.37 | 328.05 | 328.2 | 50344.0 |
| 2020-10-30 07:35:00 | SPY | ETF | 328.2 | 328.2 | 327.99 | 328.01 | 28332.0 |
| 2020-10-30 07:40:00 | SPY | ETF | 328.1 | 328.29 | 327.99 | 328.17 | 17707.0 |
| 2020-10-30 07:45:00 | SPY | ETF | 328.07 | 328.07 | 327.65 | 327.66 | 89781.0 |
| 2020-10-30 07:50:00 | SPY | ETF | 327.74 | 327.81 | 327.66 | 327.79 | 27257.0 |
| 2020-10-30 07:55:00 | SPY | ETF | 327.76 | 327.91 | 327.68 | 327.81 | 34900.0 |
| 2020-10-30 08:00:00 | SPY | ETF | 328.45 | 329.02 | 323.28 | 327.4899 | 61178.0 |
| 2020-10-30 08:05:00 | SPY | ETF | 327.509 | 327.51 | 327.33 | 327.42 | 37605.0 |
> showing 50 of 77,167 rows — these rows as CSV