PREVIEW / etf_5min / 2020-09-01
file: by_date/etf_5min/2020/2020-09-01.parquet size: 1.7 MB rows: 77,405
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-09-01 04:00:00 | SPY | ETF | 351.27 | 351.43 | 351.27 | 351.27 | 14889.0 |
| 2020-09-01 04:05:00 | SPY | ETF | 351.16 | 351.24 | 351.1 | 351.13 | 1901.0 |
| 2020-09-01 04:10:00 | SPY | ETF | 351.06 | 351.15 | 351.06 | 351.15 | 336.0 |
| 2020-09-01 04:15:00 | SPY | ETF | 351.0 | 351.22 | 350.98 | 351.03 | 12782.0 |
| 2020-09-01 04:20:00 | SPY | ETF | 351.03 | 351.03 | 351.03 | 351.03 | 100.0 |
| 2020-09-01 04:25:00 | SPY | ETF | 351.12 | 351.35 | 351.12 | 351.35 | 4601.0 |
| 2020-09-01 04:30:00 | SPY | ETF | 351.04 | 351.15 | 351.03 | 351.15 | 674.0 |
| 2020-09-01 04:35:00 | SPY | ETF | 351.19 | 351.28 | 351.19 | 351.28 | 1000.0 |
| 2020-09-01 04:40:00 | SPY | ETF | 351.07 | 351.07 | 350.72 | 350.91 | 5356.0 |
| 2020-09-01 04:45:00 | SPY | ETF | 350.8 | 350.8 | 350.8 | 350.8 | 150.0 |
| 2020-09-01 04:50:00 | SPY | ETF | 350.61 | 350.61 | 350.59 | 350.59 | 4105.0 |
| 2020-09-01 04:55:00 | SPY | ETF | 350.45 | 350.56 | 350.45 | 350.5 | 11243.0 |
| 2020-09-01 05:00:00 | SPY | ETF | 350.61 | 350.61 | 350.48 | 350.61 | 446.0 |
| 2020-09-01 05:05:00 | SPY | ETF | 350.72 | 350.73 | 350.58 | 350.58 | 1750.0 |
| 2020-09-01 05:10:00 | SPY | ETF | 350.72 | 350.72 | 350.72 | 350.72 | 700.0 |
| 2020-09-01 05:15:00 | SPY | ETF | 350.83 | 351.01 | 350.83 | 351.01 | 2579.0 |
| 2020-09-01 05:20:00 | SPY | ETF | 351.08 | 351.11 | 351.03 | 351.1 | 7399.0 |
| 2020-09-01 05:25:00 | SPY | ETF | 351.13 | 351.15 | 351.13 | 351.15 | 430.0 |
| 2020-09-01 05:30:00 | SPY | ETF | 351.16 | 351.19 | 351.16 | 351.19 | 225.0 |
| 2020-09-01 05:35:00 | SPY | ETF | 351.17 | 351.26 | 351.16 | 351.26 | 7750.0 |
| 2020-09-01 05:40:00 | SPY | ETF | 351.2 | 351.21 | 351.2 | 351.21 | 965.0 |
| 2020-09-01 05:45:00 | SPY | ETF | 351.13 | 351.18 | 351.09 | 351.17 | 3050.0 |
| 2020-09-01 05:50:00 | SPY | ETF | 351.07 | 351.07 | 351.07 | 351.07 | 101.0 |
| 2020-09-01 05:55:00 | SPY | ETF | 351.0 | 351.0 | 350.89 | 350.96 | 1874.0 |
| 2020-09-01 06:00:00 | SPY | ETF | 350.96 | 351.04 | 350.86 | 351.04 | 3066.0 |
| 2020-09-01 06:05:00 | SPY | ETF | 351.04 | 351.1 | 350.96 | 350.97 | 2057.0 |
| 2020-09-01 06:10:00 | SPY | ETF | 351.0 | 351.0 | 350.84 | 350.93 | 2401.0 |
| 2020-09-01 06:15:00 | SPY | ETF | 350.96 | 350.98 | 350.94 | 350.98 | 1375.0 |
| 2020-09-01 06:20:00 | SPY | ETF | 350.99 | 350.99 | 350.86 | 350.94 | 1775.0 |
| 2020-09-01 06:25:00 | SPY | ETF | 350.94 | 351.1 | 350.94 | 351.1 | 1925.0 |
| 2020-09-01 06:30:00 | SPY | ETF | 351.08 | 351.09 | 351.08 | 351.09 | 400.0 |
| 2020-09-01 06:35:00 | SPY | ETF | 351.1 | 351.1 | 350.96 | 350.96 | 200.0 |
| 2020-09-01 06:40:00 | SPY | ETF | 351.0 | 351.09 | 350.94 | 351.09 | 2945.0 |
| 2020-09-01 06:45:00 | SPY | ETF | 350.96 | 351.0 | 350.93 | 350.93 | 5430.0 |
| 2020-09-01 06:50:00 | SPY | ETF | 351.04 | 351.04 | 351.04 | 351.04 | 3000.0 |
| 2020-09-01 06:55:00 | SPY | ETF | 351.09 | 351.22 | 351.04 | 351.15 | 4650.0 |
| 2020-09-01 07:00:00 | SPY | ETF | 351.06 | 351.11 | 351.0 | 351.0 | 40474.0 |
| 2020-09-01 07:05:00 | SPY | ETF | 351.02 | 351.07 | 350.98 | 351.02 | 46392.0 |
| 2020-09-01 07:10:00 | SPY | ETF | 351.02 | 351.05 | 350.9 | 350.94 | 51597.0 |
| 2020-09-01 07:15:00 | SPY | ETF | 350.95 | 350.95 | 350.83 | 350.83 | 3084.0 |
| 2020-09-01 07:20:00 | SPY | ETF | 350.8 | 350.82 | 350.8 | 350.8 | 5113.0 |
| 2020-09-01 07:25:00 | SPY | ETF | 350.7 | 350.74 | 350.67 | 350.7 | 12437.0 |
| 2020-09-01 07:30:00 | SPY | ETF | 350.68 | 350.68 | 350.47 | 350.5 | 14103.0 |
| 2020-09-01 07:35:00 | SPY | ETF | 350.54 | 350.63 | 350.48 | 350.6 | 22929.0 |
| 2020-09-01 07:40:00 | SPY | ETF | 350.6 | 350.68 | 350.54 | 350.56 | 53960.0 |
| 2020-09-01 07:45:00 | SPY | ETF | 350.55 | 350.59 | 350.53 | 350.54 | 26585.0 |
| 2020-09-01 07:50:00 | SPY | ETF | 350.57 | 350.57 | 350.49 | 350.49 | 3350.0 |
| 2020-09-01 07:55:00 | SPY | ETF | 350.5 | 350.54 | 350.46 | 350.54 | 2684.0 |
| 2020-09-01 08:00:00 | SPY | ETF | 350.54 | 351.55 | 350.4999 | 350.63 | 21452.0 |
| 2020-09-01 08:05:00 | SPY | ETF | 350.66 | 350.68 | 350.63 | 350.63 | 2964.0 |
> showing 50 of 77,405 rows — these rows as CSV