PREVIEW / etf_1min / 2021-01-05
file: by_date/etf_1min/2021/2021-01-05.parquet size: 4.3 MB rows: 235,613
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-05 04:00:00 | SPY | ETF | 369.1 | 369.12 | 368.93 | 368.96 | 3200.0 |
| 2021-01-05 04:01:00 | SPY | ETF | 368.93 | 368.94 | 368.89 | 368.9 | 1060.0 |
| 2021-01-05 04:03:00 | SPY | ETF | 369.3 | 369.3 | 369.3 | 369.3 | 160.0 |
| 2021-01-05 04:04:00 | SPY | ETF | 369.19 | 369.2 | 369.19 | 369.2 | 246.0 |
| 2021-01-05 04:05:00 | SPY | ETF | 369.3 | 369.3 | 369.3 | 369.3 | 291.0 |
| 2021-01-05 04:06:00 | SPY | ETF | 369.28 | 369.28 | 369.28 | 369.28 | 329.0 |
| 2021-01-05 04:07:00 | SPY | ETF | 369.17 | 369.17 | 369.17 | 369.17 | 775.0 |
| 2021-01-05 04:08:00 | SPY | ETF | 369.18 | 369.3 | 369.18 | 369.3 | 2000.0 |
| 2021-01-05 04:09:00 | SPY | ETF | 369.32 | 369.32 | 369.15 | 369.15 | 2092.0 |
| 2021-01-05 04:10:00 | SPY | ETF | 369.16 | 369.16 | 369.13 | 369.13 | 449.0 |
| 2021-01-05 04:11:00 | SPY | ETF | 369.12 | 369.12 | 369.08 | 369.12 | 2400.0 |
| 2021-01-05 04:12:00 | SPY | ETF | 369.18 | 369.21 | 369.18 | 369.21 | 1500.0 |
| 2021-01-05 04:13:00 | SPY | ETF | 369.16 | 369.34 | 369.16 | 369.34 | 2600.0 |
| 2021-01-05 04:14:00 | SPY | ETF | 369.33 | 369.46 | 369.33 | 369.44 | 4053.0 |
| 2021-01-05 04:15:00 | SPY | ETF | 369.4 | 369.4 | 369.39 | 369.39 | 854.0 |
| 2021-01-05 04:16:00 | SPY | ETF | 369.34 | 369.38 | 369.34 | 369.37 | 4060.0 |
| 2021-01-05 04:17:00 | SPY | ETF | 369.5 | 369.51 | 369.5 | 369.51 | 2017.0 |
| 2021-01-05 04:18:00 | SPY | ETF | 369.55 | 369.58 | 369.5 | 369.58 | 1550.0 |
| 2021-01-05 04:19:00 | SPY | ETF | 369.6 | 369.6 | 369.6 | 369.6 | 987.0 |
| 2021-01-05 04:20:00 | SPY | ETF | 369.5 | 369.51 | 369.5 | 369.5 | 2600.0 |
| 2021-01-05 04:21:00 | SPY | ETF | 369.36 | 369.36 | 369.36 | 369.36 | 100.0 |
| 2021-01-05 04:22:00 | SPY | ETF | 369.26 | 369.27 | 369.13 | 369.27 | 865.0 |
| 2021-01-05 04:23:00 | SPY | ETF | 369.27 | 369.28 | 369.26 | 369.28 | 800.0 |
| 2021-01-05 04:24:00 | SPY | ETF | 369.17 | 369.17 | 369.17 | 369.17 | 150.0 |
| 2021-01-05 04:26:00 | SPY | ETF | 369.2 | 369.2 | 369.2 | 369.2 | 4911.0 |
| 2021-01-05 04:29:00 | SPY | ETF | 369.15 | 369.15 | 369.15 | 369.15 | 740.0 |
| 2021-01-05 04:30:00 | SPY | ETF | 369.17 | 369.17 | 369.17 | 369.17 | 718.0 |
| 2021-01-05 04:35:00 | SPY | ETF | 369.48 | 369.48 | 369.48 | 369.48 | 1500.0 |
| 2021-01-05 04:38:00 | SPY | ETF | 369.59 | 369.59 | 369.59 | 369.59 | 1000.0 |
| 2021-01-05 04:39:00 | SPY | ETF | 369.68 | 369.68 | 369.68 | 369.68 | 326.0 |
| 2021-01-05 04:40:00 | SPY | ETF | 369.69 | 369.7 | 369.69 | 369.7 | 1379.0 |
| 2021-01-05 04:41:00 | SPY | ETF | 369.71 | 369.73 | 369.71 | 369.73 | 680.0 |
| 2021-01-05 04:45:00 | SPY | ETF | 369.72 | 369.72 | 369.7 | 369.7 | 4000.0 |
| 2021-01-05 04:46:00 | SPY | ETF | 369.69 | 369.69 | 369.69 | 369.69 | 100.0 |
| 2021-01-05 04:47:00 | SPY | ETF | 369.72 | 369.74 | 369.72 | 369.74 | 2500.0 |
| 2021-01-05 04:49:00 | SPY | ETF | 369.67 | 369.67 | 369.62 | 369.62 | 340.0 |
| 2021-01-05 04:50:00 | SPY | ETF | 369.65 | 369.65 | 369.65 | 369.65 | 1027.0 |
| 2021-01-05 04:51:00 | SPY | ETF | 369.65 | 369.65 | 369.64 | 369.64 | 3228.0 |
| 2021-01-05 04:52:00 | SPY | ETF | 369.57 | 369.57 | 369.57 | 369.57 | 176.0 |
| 2021-01-05 04:55:00 | SPY | ETF | 369.65 | 369.65 | 369.65 | 369.65 | 2101.0 |
| 2021-01-05 04:56:00 | SPY | ETF | 369.66 | 369.66 | 369.66 | 369.66 | 394.0 |
| 2021-01-05 04:58:00 | SPY | ETF | 369.64 | 369.64 | 369.64 | 369.64 | 645.0 |
| 2021-01-05 05:00:00 | SPY | ETF | 369.36 | 369.36 | 369.36 | 369.36 | 500.0 |
| 2021-01-05 05:05:00 | SPY | ETF | 369.56 | 369.56 | 369.56 | 369.56 | 500.0 |
| 2021-01-05 05:10:00 | SPY | ETF | 369.57 | 369.57 | 369.57 | 369.57 | 125.0 |
| 2021-01-05 05:11:00 | SPY | ETF | 369.52 | 369.52 | 369.47 | 369.47 | 1626.0 |
| 2021-01-05 05:12:00 | SPY | ETF | 369.41 | 369.41 | 369.41 | 369.41 | 100.0 |
| 2021-01-05 05:19:00 | SPY | ETF | 369.4 | 369.4 | 369.4 | 369.4 | 100.0 |
| 2021-01-05 05:20:00 | SPY | ETF | 369.39 | 369.39 | 369.39 | 369.39 | 249.0 |
| 2021-01-05 05:23:00 | SPY | ETF | 369.29 | 369.29 | 369.29 | 369.29 | 500.0 |
> showing 50 of 235,613 rows — these rows as CSV