PREVIEW / etf_1min / 2020-10-12
file: by_date/etf_1min/2020/2020-10-12.parquet size: 3.6 MB rows: 191,387
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-12 04:00:00 | SPY | ETF | 347.97 | 347.99 | 347.97 | 347.99 | 561.0 |
| 2020-10-12 04:01:00 | SPY | ETF | 347.99 | 347.99 | 347.99 | 347.99 | 111.0 |
| 2020-10-12 04:02:00 | SPY | ETF | 347.97 | 347.97 | 347.96 | 347.97 | 1108.0 |
| 2020-10-12 04:03:00 | SPY | ETF | 348.0 | 348.0 | 347.99 | 347.99 | 5435.0 |
| 2020-10-12 04:04:00 | SPY | ETF | 348.07 | 348.08 | 348.07 | 348.08 | 300.0 |
| 2020-10-12 04:05:00 | SPY | ETF | 348.06 | 348.08 | 348.06 | 348.08 | 5500.0 |
| 2020-10-12 04:06:00 | SPY | ETF | 348.05 | 348.05 | 348.05 | 348.05 | 1000.0 |
| 2020-10-12 04:10:00 | SPY | ETF | 348.0 | 348.0 | 348.0 | 348.0 | 510.0 |
| 2020-10-12 04:12:00 | SPY | ETF | 348.09 | 348.1 | 348.09 | 348.1 | 3369.0 |
| 2020-10-12 04:17:00 | SPY | ETF | 348.13 | 348.14 | 348.13 | 348.14 | 1724.0 |
| 2020-10-12 04:18:00 | SPY | ETF | 348.2 | 348.36 | 348.2 | 348.35 | 4649.0 |
| 2020-10-12 04:19:00 | SPY | ETF | 348.29 | 348.3 | 348.29 | 348.29 | 1550.0 |
| 2020-10-12 04:21:00 | SPY | ETF | 348.36 | 348.36 | 348.36 | 348.36 | 483.0 |
| 2020-10-12 04:23:00 | SPY | ETF | 348.7 | 348.8 | 348.7 | 348.76 | 2585.0 |
| 2020-10-12 04:24:00 | SPY | ETF | 348.76 | 348.86 | 348.76 | 348.86 | 1217.0 |
| 2020-10-12 04:26:00 | SPY | ETF | 348.91 | 348.94 | 348.91 | 348.94 | 535.0 |
| 2020-10-12 04:27:00 | SPY | ETF | 349.0 | 349.09 | 349.0 | 349.09 | 956.0 |
| 2020-10-12 04:28:00 | SPY | ETF | 349.01 | 349.05 | 349.01 | 349.05 | 2320.0 |
| 2020-10-12 04:29:00 | SPY | ETF | 349.0 | 349.0 | 348.91 | 348.91 | 3115.0 |
| 2020-10-12 04:30:00 | SPY | ETF | 348.93 | 348.93 | 348.93 | 348.93 | 229.0 |
| 2020-10-12 04:31:00 | SPY | ETF | 349.05 | 349.05 | 348.92 | 348.92 | 4220.0 |
| 2020-10-12 04:35:00 | SPY | ETF | 348.92 | 348.92 | 348.9 | 348.92 | 501.0 |
| 2020-10-12 04:36:00 | SPY | ETF | 348.94 | 348.94 | 348.86 | 348.86 | 1109.0 |
| 2020-10-12 04:37:00 | SPY | ETF | 348.86 | 348.86 | 348.86 | 348.86 | 910.0 |
| 2020-10-12 04:41:00 | SPY | ETF | 348.66 | 348.66 | 348.61 | 348.61 | 982.0 |
| 2020-10-12 04:42:00 | SPY | ETF | 348.6 | 348.6 | 348.55 | 348.55 | 1381.0 |
| 2020-10-12 04:43:00 | SPY | ETF | 348.55 | 348.55 | 348.55 | 348.55 | 1041.0 |
| 2020-10-12 04:45:00 | SPY | ETF | 348.5 | 348.5 | 348.5 | 348.5 | 2181.0 |
| 2020-10-12 04:46:00 | SPY | ETF | 348.48 | 348.48 | 348.45 | 348.45 | 2805.0 |
| 2020-10-12 04:47:00 | SPY | ETF | 348.49 | 348.49 | 348.45 | 348.45 | 2405.0 |
| 2020-10-12 04:49:00 | SPY | ETF | 348.47 | 348.47 | 348.45 | 348.45 | 441.0 |
| 2020-10-12 04:54:00 | SPY | ETF | 348.21 | 348.22 | 348.21 | 348.22 | 1050.0 |
| 2020-10-12 04:57:00 | SPY | ETF | 348.18 | 348.18 | 348.18 | 348.18 | 100.0 |
| 2020-10-12 04:58:00 | SPY | ETF | 348.14 | 348.14 | 348.13 | 348.13 | 306.0 |
| 2020-10-12 05:00:00 | SPY | ETF | 348.12 | 348.14 | 348.12 | 348.14 | 3540.0 |
| 2020-10-12 05:01:00 | SPY | ETF | 348.14 | 348.14 | 348.13 | 348.14 | 5852.0 |
| 2020-10-12 05:02:00 | SPY | ETF | 348.14 | 348.14 | 348.12 | 348.12 | 19495.0 |
| 2020-10-12 05:04:00 | SPY | ETF | 348.22 | 348.26 | 348.22 | 348.26 | 3125.0 |
| 2020-10-12 05:05:00 | SPY | ETF | 348.29 | 348.29 | 348.29 | 348.29 | 325.0 |
| 2020-10-12 05:07:00 | SPY | ETF | 348.29 | 348.29 | 348.29 | 348.29 | 100.0 |
| 2020-10-12 05:08:00 | SPY | ETF | 348.25 | 348.27 | 348.25 | 348.27 | 1279.0 |
| 2020-10-12 05:10:00 | SPY | ETF | 348.34 | 348.34 | 348.34 | 348.34 | 4600.0 |
| 2020-10-12 05:11:00 | SPY | ETF | 348.34 | 348.4 | 348.34 | 348.4 | 10119.0 |
| 2020-10-12 05:12:00 | SPY | ETF | 348.48 | 348.48 | 348.48 | 348.48 | 100.0 |
| 2020-10-12 05:13:00 | SPY | ETF | 348.49 | 348.49 | 348.49 | 348.49 | 358.0 |
| 2020-10-12 05:14:00 | SPY | ETF | 348.5 | 348.5 | 348.47 | 348.49 | 1244.0 |
| 2020-10-12 05:16:00 | SPY | ETF | 348.49 | 348.49 | 348.48 | 348.48 | 1235.0 |
| 2020-10-12 05:20:00 | SPY | ETF | 348.46 | 348.51 | 348.46 | 348.5 | 14411.0 |
| 2020-10-12 05:22:00 | SPY | ETF | 348.48 | 348.48 | 348.48 | 348.48 | 200.0 |
| 2020-10-12 05:23:00 | SPY | ETF | 348.48 | 348.48 | 348.44 | 348.44 | 500.0 |
> showing 50 of 191,387 rows — these rows as CSV