PREVIEW / etf_1min / 2020-09-17
file: by_date/etf_1min/2020/2020-09-17.parquet size: 3.6 MB rows: 201,072
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-17 04:00:00 | SPY | ETF | 334.42 | 334.62 | 334.42 | 334.62 | 8132.0 |
| 2020-09-17 04:01:00 | SPY | ETF | 334.61 | 334.63 | 334.54 | 334.57 | 10213.0 |
| 2020-09-17 04:02:00 | SPY | ETF | 334.64 | 334.68 | 334.63 | 334.68 | 1187.0 |
| 2020-09-17 04:03:00 | SPY | ETF | 334.68 | 334.7 | 334.61 | 334.63 | 2660.0 |
| 2020-09-17 04:04:00 | SPY | ETF | 334.63 | 334.63 | 334.45 | 334.45 | 4019.0 |
| 2020-09-17 04:05:00 | SPY | ETF | 334.55 | 334.74 | 334.55 | 334.74 | 1521.0 |
| 2020-09-17 04:06:00 | SPY | ETF | 334.76 | 334.78 | 334.76 | 334.77 | 2891.0 |
| 2020-09-17 04:07:00 | SPY | ETF | 334.76 | 334.79 | 334.74 | 334.78 | 7910.0 |
| 2020-09-17 04:08:00 | SPY | ETF | 334.78 | 334.78 | 334.78 | 334.78 | 175.0 |
| 2020-09-17 04:10:00 | SPY | ETF | 335.0 | 335.0 | 335.0 | 335.0 | 214.0 |
| 2020-09-17 04:11:00 | SPY | ETF | 335.03 | 335.03 | 334.98 | 334.98 | 3576.0 |
| 2020-09-17 04:12:00 | SPY | ETF | 334.99 | 334.99 | 334.91 | 334.91 | 251.0 |
| 2020-09-17 04:13:00 | SPY | ETF | 334.85 | 334.85 | 334.77 | 334.78 | 2131.0 |
| 2020-09-17 04:14:00 | SPY | ETF | 334.78 | 334.78 | 334.51 | 334.51 | 14075.0 |
| 2020-09-17 04:15:00 | SPY | ETF | 334.52 | 334.56 | 334.52 | 334.56 | 887.0 |
| 2020-09-17 04:16:00 | SPY | ETF | 334.53 | 334.56 | 334.53 | 334.56 | 1618.0 |
| 2020-09-17 04:17:00 | SPY | ETF | 334.65 | 334.7 | 334.59 | 334.59 | 1463.0 |
| 2020-09-17 04:18:00 | SPY | ETF | 334.66 | 334.7 | 334.66 | 334.66 | 2205.0 |
| 2020-09-17 04:19:00 | SPY | ETF | 334.78 | 334.78 | 334.65 | 334.71 | 15925.0 |
| 2020-09-17 04:20:00 | SPY | ETF | 334.95 | 334.95 | 334.95 | 334.95 | 700.0 |
| 2020-09-17 04:22:00 | SPY | ETF | 335.1 | 335.13 | 335.1 | 335.13 | 1000.0 |
| 2020-09-17 04:23:00 | SPY | ETF | 335.16 | 335.32 | 335.16 | 335.18 | 2421.0 |
| 2020-09-17 04:24:00 | SPY | ETF | 335.18 | 335.18 | 335.11 | 335.16 | 4584.0 |
| 2020-09-17 04:25:00 | SPY | ETF | 335.21 | 335.25 | 335.21 | 335.25 | 1122.0 |
| 2020-09-17 04:26:00 | SPY | ETF | 335.38 | 335.38 | 335.38 | 335.38 | 113.0 |
| 2020-09-17 04:27:00 | SPY | ETF | 335.38 | 335.38 | 335.38 | 335.38 | 627.0 |
| 2020-09-17 04:28:00 | SPY | ETF | 335.38 | 335.38 | 335.38 | 335.38 | 225.0 |
| 2020-09-17 04:29:00 | SPY | ETF | 335.44 | 335.44 | 335.44 | 335.44 | 735.0 |
| 2020-09-17 04:30:00 | SPY | ETF | 335.52 | 335.59 | 335.52 | 335.58 | 3761.0 |
| 2020-09-17 04:31:00 | SPY | ETF | 335.56 | 335.56 | 335.48 | 335.48 | 221.0 |
| 2020-09-17 04:32:00 | SPY | ETF | 335.38 | 335.38 | 335.21 | 335.21 | 1321.0 |
| 2020-09-17 04:37:00 | SPY | ETF | 335.09 | 335.09 | 335.04 | 335.08 | 5700.0 |
| 2020-09-17 04:39:00 | SPY | ETF | 335.0 | 335.0 | 335.0 | 335.0 | 236.0 |
| 2020-09-17 04:40:00 | SPY | ETF | 335.09 | 335.13 | 335.09 | 335.11 | 608.0 |
| 2020-09-17 04:41:00 | SPY | ETF | 335.2 | 335.24 | 335.19 | 335.19 | 1714.0 |
| 2020-09-17 04:43:00 | SPY | ETF | 335.31 | 335.36 | 335.31 | 335.36 | 1133.0 |
| 2020-09-17 04:46:00 | SPY | ETF | 335.21 | 335.21 | 335.2 | 335.2 | 4305.0 |
| 2020-09-17 04:47:00 | SPY | ETF | 335.14 | 335.14 | 335.0 | 335.0 | 1818.0 |
| 2020-09-17 04:48:00 | SPY | ETF | 334.94 | 334.94 | 334.94 | 334.94 | 160.0 |
| 2020-09-17 04:50:00 | SPY | ETF | 335.01 | 335.04 | 335.01 | 335.04 | 989.0 |
| 2020-09-17 04:51:00 | SPY | ETF | 335.1 | 335.1 | 335.1 | 335.1 | 600.0 |
| 2020-09-17 04:53:00 | SPY | ETF | 335.19 | 335.2 | 335.19 | 335.2 | 1228.0 |
| 2020-09-17 04:56:00 | SPY | ETF | 335.24 | 335.24 | 335.24 | 335.24 | 379.0 |
| 2020-09-17 04:57:00 | SPY | ETF | 335.39 | 335.39 | 335.39 | 335.39 | 100.0 |
| 2020-09-17 04:59:00 | SPY | ETF | 335.3 | 335.3 | 335.3 | 335.3 | 5000.0 |
| 2020-09-17 05:01:00 | SPY | ETF | 335.42 | 335.54 | 335.42 | 335.54 | 3546.0 |
| 2020-09-17 05:05:00 | SPY | ETF | 335.21 | 335.21 | 335.21 | 335.21 | 653.0 |
| 2020-09-17 05:06:00 | SPY | ETF | 335.27 | 335.27 | 335.27 | 335.27 | 100.0 |
| 2020-09-17 05:07:00 | SPY | ETF | 335.34 | 335.34 | 335.19 | 335.19 | 2275.0 |
| 2020-09-17 05:08:00 | SPY | ETF | 335.18 | 335.24 | 335.18 | 335.24 | 1270.0 |
> showing 50 of 201,072 rows — these rows as CSV