PREVIEW / etf_5min / 2020-10-29
file: by_date/etf_5min/2020/2020-10-29.parquet size: 1.7 MB rows: 76,801
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-29 04:00:00 | SPY | ETF | 329.16 | 330.05 | 329.11 | 330.05 | 39189.0 |
| 2020-10-29 04:05:00 | SPY | ETF | 330.1 | 330.1 | 329.65 | 329.69 | 3103.0 |
| 2020-10-29 04:10:00 | SPY | ETF | 329.49 | 329.52 | 329.0 | 329.0 | 6833.0 |
| 2020-10-29 04:15:00 | SPY | ETF | 328.97 | 328.97 | 328.41 | 328.69 | 11876.0 |
| 2020-10-29 04:20:00 | SPY | ETF | 328.57 | 329.39 | 328.51 | 329.39 | 21908.0 |
| 2020-10-29 04:25:00 | SPY | ETF | 329.19 | 329.51 | 329.19 | 329.5 | 2732.0 |
| 2020-10-29 04:30:00 | SPY | ETF | 329.37 | 329.37 | 329.2 | 329.2 | 636.0 |
| 2020-10-29 04:35:00 | SPY | ETF | 329.24 | 329.24 | 329.24 | 329.24 | 3501.0 |
| 2020-10-29 04:40:00 | SPY | ETF | 329.18 | 329.18 | 329.06 | 329.06 | 715.0 |
| 2020-10-29 04:45:00 | SPY | ETF | 328.82 | 329.28 | 328.76 | 328.94 | 12616.0 |
| 2020-10-29 04:50:00 | SPY | ETF | 328.85 | 328.85 | 328.85 | 328.85 | 228.0 |
| 2020-10-29 04:55:00 | SPY | ETF | 328.7 | 328.95 | 328.6 | 328.95 | 815.0 |
| 2020-10-29 05:00:00 | SPY | ETF | 329.05 | 329.22 | 329.04 | 329.22 | 13303.0 |
| 2020-10-29 05:05:00 | SPY | ETF | 329.22 | 329.56 | 329.22 | 329.56 | 4680.0 |
| 2020-10-29 05:10:00 | SPY | ETF | 329.49 | 329.62 | 329.49 | 329.57 | 810.0 |
| 2020-10-29 05:15:00 | SPY | ETF | 329.43 | 329.43 | 329.06 | 329.09 | 4004.0 |
| 2020-10-29 05:20:00 | SPY | ETF | 329.25 | 329.45 | 329.25 | 329.45 | 3651.0 |
| 2020-10-29 05:25:00 | SPY | ETF | 329.56 | 329.64 | 329.54 | 329.54 | 4818.0 |
| 2020-10-29 05:30:00 | SPY | ETF | 329.6 | 329.6 | 328.9 | 328.9 | 4616.0 |
| 2020-10-29 05:35:00 | SPY | ETF | 328.86 | 329.04 | 328.8 | 329.04 | 2868.0 |
| 2020-10-29 05:40:00 | SPY | ETF | 328.97 | 329.26 | 328.96 | 329.07 | 4912.0 |
| 2020-10-29 05:45:00 | SPY | ETF | 329.15 | 329.15 | 328.89 | 328.89 | 4534.0 |
| 2020-10-29 05:50:00 | SPY | ETF | 328.92 | 328.92 | 328.69 | 328.69 | 10026.0 |
| 2020-10-29 05:55:00 | SPY | ETF | 328.72 | 329.07 | 328.62 | 329.07 | 8037.0 |
| 2020-10-29 06:00:00 | SPY | ETF | 328.99 | 328.99 | 328.6 | 328.65 | 21358.0 |
| 2020-10-29 06:05:00 | SPY | ETF | 328.57 | 328.81 | 328.57 | 328.68 | 2703.0 |
| 2020-10-29 06:10:00 | SPY | ETF | 328.5 | 328.66 | 328.2 | 328.52 | 18986.0 |
| 2020-10-29 06:15:00 | SPY | ETF | 328.48 | 328.52 | 328.21 | 328.5 | 28053.0 |
| 2020-10-29 06:20:00 | SPY | ETF | 328.63 | 328.8 | 328.49 | 328.56 | 56284.0 |
| 2020-10-29 06:25:00 | SPY | ETF | 328.47 | 328.47 | 328.28 | 328.33 | 7948.0 |
| 2020-10-29 06:30:00 | SPY | ETF | 328.43 | 328.43 | 328.25 | 328.3 | 1928.0 |
| 2020-10-29 06:35:00 | SPY | ETF | 328.22 | 328.3 | 328.18 | 328.3 | 6201.0 |
| 2020-10-29 06:40:00 | SPY | ETF | 328.3 | 328.69 | 328.25 | 328.69 | 8432.0 |
| 2020-10-29 06:45:00 | SPY | ETF | 328.61 | 328.71 | 328.6 | 328.7 | 26470.0 |
| 2020-10-29 06:50:00 | SPY | ETF | 328.61 | 328.62 | 328.51 | 328.51 | 2979.0 |
| 2020-10-29 06:55:00 | SPY | ETF | 328.64 | 328.85 | 328.51 | 328.53 | 8660.0 |
| 2020-10-29 07:00:00 | SPY | ETF | 328.51 | 328.53 | 328.2 | 328.3 | 39244.0 |
| 2020-10-29 07:05:00 | SPY | ETF | 328.32 | 328.32 | 327.94 | 327.94 | 38262.0 |
| 2020-10-29 07:10:00 | SPY | ETF | 327.9 | 327.9 | 327.5 | 327.72 | 78266.0 |
| 2020-10-29 07:15:00 | SPY | ETF | 327.7 | 327.79 | 327.6 | 327.72 | 105324.0 |
| 2020-10-29 07:20:00 | SPY | ETF | 327.7 | 327.77 | 327.5 | 327.71 | 22482.0 |
| 2020-10-29 07:25:00 | SPY | ETF | 327.65 | 327.65 | 327.44 | 327.5 | 17286.0 |
| 2020-10-29 07:30:00 | SPY | ETF | 327.48 | 327.73 | 327.48 | 327.72 | 30607.0 |
| 2020-10-29 07:35:00 | SPY | ETF | 327.7 | 327.8 | 326.8 | 326.8 | 57836.0 |
| 2020-10-29 07:40:00 | SPY | ETF | 326.8 | 327.05 | 326.45 | 326.7 | 59631.0 |
| 2020-10-29 07:45:00 | SPY | ETF | 326.8 | 326.99 | 326.74 | 326.77 | 40058.0 |
| 2020-10-29 07:50:00 | SPY | ETF | 326.84 | 326.85 | 326.38 | 326.62 | 92920.0 |
| 2020-10-29 07:55:00 | SPY | ETF | 326.61 | 326.7 | 325.65 | 325.75 | 194700.0 |
| 2020-10-29 08:00:00 | SPY | ETF | 325.79 | 331.02 | 325.67 | 326.2 | 151392.0 |
| 2020-10-29 08:05:00 | SPY | ETF | 326.16 | 326.39 | 325.83 | 326.35 | 170609.0 |
> showing 50 of 76,801 rows — these rows as CSV