PREVIEW / etf_1min / 2020-11-13
file: by_date/etf_1min/2020/2020-11-13.parquet size: 3.7 MB rows: 198,208
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-11-13 04:00:00 | SPY | ETF | 355.1 | 355.27 | 354.99 | 355.18 | 8488.0 |
| 2020-11-13 04:01:00 | SPY | ETF | 355.22 | 355.26 | 355.22 | 355.26 | 390.0 |
| 2020-11-13 04:02:00 | SPY | ETF | 355.19 | 355.19 | 355.19 | 355.19 | 475.0 |
| 2020-11-13 04:03:00 | SPY | ETF | 355.22 | 355.22 | 355.22 | 355.22 | 1060.0 |
| 2020-11-13 04:06:00 | SPY | ETF | 355.26 | 355.32 | 355.26 | 355.32 | 1240.0 |
| 2020-11-13 04:07:00 | SPY | ETF | 355.32 | 355.32 | 355.32 | 355.32 | 600.0 |
| 2020-11-13 04:09:00 | SPY | ETF | 355.32 | 355.32 | 355.32 | 355.32 | 121.0 |
| 2020-11-13 04:10:00 | SPY | ETF | 355.35 | 355.35 | 355.35 | 355.35 | 105.0 |
| 2020-11-13 04:11:00 | SPY | ETF | 355.21 | 355.21 | 355.21 | 355.21 | 2693.0 |
| 2020-11-13 04:12:00 | SPY | ETF | 355.21 | 355.21 | 355.21 | 355.21 | 120.0 |
| 2020-11-13 04:13:00 | SPY | ETF | 355.18 | 355.18 | 355.18 | 355.18 | 129.0 |
| 2020-11-13 04:19:00 | SPY | ETF | 355.43 | 355.5 | 355.43 | 355.5 | 4522.0 |
| 2020-11-13 04:20:00 | SPY | ETF | 355.66 | 355.66 | 355.6 | 355.6 | 7316.0 |
| 2020-11-13 04:21:00 | SPY | ETF | 355.47 | 355.55 | 355.46 | 355.55 | 2376.0 |
| 2020-11-13 04:24:00 | SPY | ETF | 355.58 | 355.58 | 355.58 | 355.58 | 580.0 |
| 2020-11-13 04:26:00 | SPY | ETF | 355.51 | 355.53 | 355.49 | 355.49 | 925.0 |
| 2020-11-13 04:27:00 | SPY | ETF | 355.58 | 355.58 | 355.57 | 355.57 | 1135.0 |
| 2020-11-13 04:29:00 | SPY | ETF | 355.54 | 355.54 | 355.53 | 355.53 | 200.0 |
| 2020-11-13 04:31:00 | SPY | ETF | 355.69 | 355.82 | 355.69 | 355.81 | 909.0 |
| 2020-11-13 04:32:00 | SPY | ETF | 356.0 | 356.3 | 355.97 | 356.12 | 6689.0 |
| 2020-11-13 04:33:00 | SPY | ETF | 356.08 | 356.18 | 356.01 | 356.11 | 6702.0 |
| 2020-11-13 04:34:00 | SPY | ETF | 356.14 | 356.14 | 356.11 | 356.11 | 2320.0 |
| 2020-11-13 04:37:00 | SPY | ETF | 356.01 | 356.01 | 356.01 | 356.01 | 700.0 |
| 2020-11-13 04:38:00 | SPY | ETF | 356.03 | 356.03 | 355.96 | 355.96 | 1250.0 |
| 2020-11-13 04:39:00 | SPY | ETF | 355.97 | 356.0 | 355.96 | 355.96 | 1768.0 |
| 2020-11-13 04:40:00 | SPY | ETF | 355.96 | 356.0 | 355.94 | 355.94 | 3501.0 |
| 2020-11-13 04:45:00 | SPY | ETF | 356.0 | 356.0 | 356.0 | 356.0 | 1100.0 |
| 2020-11-13 04:46:00 | SPY | ETF | 355.98 | 355.98 | 355.93 | 355.93 | 212.0 |
| 2020-11-13 04:47:00 | SPY | ETF | 356.06 | 356.23 | 356.06 | 356.16 | 2050.0 |
| 2020-11-13 04:49:00 | SPY | ETF | 356.13 | 356.13 | 356.02 | 356.13 | 3170.0 |
| 2020-11-13 04:51:00 | SPY | ETF | 356.26 | 356.26 | 356.24 | 356.24 | 640.0 |
| 2020-11-13 04:52:00 | SPY | ETF | 356.26 | 356.3 | 356.26 | 356.3 | 1621.0 |
| 2020-11-13 04:53:00 | SPY | ETF | 356.37 | 356.37 | 356.33 | 356.33 | 1004.0 |
| 2020-11-13 04:54:00 | SPY | ETF | 356.36 | 356.36 | 356.36 | 356.36 | 180.0 |
| 2020-11-13 04:57:00 | SPY | ETF | 356.36 | 356.36 | 356.36 | 356.36 | 208.0 |
| 2020-11-13 04:58:00 | SPY | ETF | 356.36 | 356.36 | 356.32 | 356.32 | 524.0 |
| 2020-11-13 05:00:00 | SPY | ETF | 356.28 | 356.28 | 356.28 | 356.28 | 654.0 |
| 2020-11-13 05:01:00 | SPY | ETF | 356.39 | 356.39 | 356.39 | 356.39 | 593.0 |
| 2020-11-13 05:02:00 | SPY | ETF | 356.24 | 356.24 | 356.23 | 356.23 | 500.0 |
| 2020-11-13 05:05:00 | SPY | ETF | 356.33 | 356.33 | 356.33 | 356.33 | 100.0 |
| 2020-11-13 05:06:00 | SPY | ETF | 356.36 | 356.43 | 356.36 | 356.4 | 355.0 |
| 2020-11-13 05:07:00 | SPY | ETF | 356.33 | 356.33 | 356.33 | 356.33 | 100.0 |
| 2020-11-13 05:08:00 | SPY | ETF | 356.38 | 356.38 | 356.36 | 356.36 | 22000.0 |
| 2020-11-13 05:09:00 | SPY | ETF | 356.36 | 356.38 | 356.35 | 356.35 | 21860.0 |
| 2020-11-13 05:10:00 | SPY | ETF | 356.27 | 356.29 | 356.14 | 356.14 | 12800.0 |
| 2020-11-13 05:11:00 | SPY | ETF | 356.24 | 356.24 | 356.14 | 356.14 | 5070.0 |
| 2020-11-13 05:12:00 | SPY | ETF | 356.24 | 356.24 | 356.24 | 356.24 | 401.0 |
| 2020-11-13 05:13:00 | SPY | ETF | 356.24 | 356.26 | 356.24 | 356.26 | 2740.0 |
| 2020-11-13 05:15:00 | SPY | ETF | 356.24 | 356.24 | 356.24 | 356.24 | 5500.0 |
| 2020-11-13 05:16:00 | SPY | ETF | 356.24 | 356.26 | 356.24 | 356.24 | 17600.0 |
> showing 50 of 198,208 rows — these rows as CSV