PREVIEW / etf_1min / 2020-06-19
file: by_date/etf_1min/2020/2020-06-19.parquet size: 3.8 MB rows: 211,137
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-06-19 04:00:00 | SPY | ETF | 312.12 | 312.12 | 311.99 | 312.02 | 5668.0 |
| 2020-06-19 04:01:00 | SPY | ETF | 312.0 | 312.0 | 311.95 | 311.95 | 1054.0 |
| 2020-06-19 04:02:00 | SPY | ETF | 312.0 | 312.0 | 311.93 | 311.93 | 408.0 |
| 2020-06-19 04:03:00 | SPY | ETF | 311.98 | 311.99 | 311.98 | 311.99 | 1356.0 |
| 2020-06-19 04:04:00 | SPY | ETF | 312.0 | 312.0 | 311.94 | 311.95 | 2944.0 |
| 2020-06-19 04:05:00 | SPY | ETF | 311.9 | 311.9 | 311.83 | 311.83 | 1687.0 |
| 2020-06-19 04:06:00 | SPY | ETF | 311.72 | 311.76 | 311.72 | 311.76 | 933.0 |
| 2020-06-19 04:07:00 | SPY | ETF | 311.76 | 311.79 | 311.45 | 311.5 | 2410.0 |
| 2020-06-19 04:08:00 | SPY | ETF | 311.49 | 311.49 | 311.43 | 311.43 | 1198.0 |
| 2020-06-19 04:10:00 | SPY | ETF | 311.44 | 311.48 | 311.43 | 311.47 | 800.0 |
| 2020-06-19 04:11:00 | SPY | ETF | 311.37 | 311.37 | 311.37 | 311.37 | 156.0 |
| 2020-06-19 04:13:00 | SPY | ETF | 311.34 | 311.36 | 311.3 | 311.3 | 1520.0 |
| 2020-06-19 04:14:00 | SPY | ETF | 311.29 | 311.29 | 311.27 | 311.27 | 858.0 |
| 2020-06-19 04:15:00 | SPY | ETF | 311.41 | 311.45 | 311.41 | 311.45 | 1302.0 |
| 2020-06-19 04:17:00 | SPY | ETF | 311.41 | 311.41 | 311.41 | 311.41 | 300.0 |
| 2020-06-19 04:18:00 | SPY | ETF | 311.49 | 311.49 | 311.49 | 311.49 | 130.0 |
| 2020-06-19 04:20:00 | SPY | ETF | 311.45 | 311.45 | 311.45 | 311.45 | 1015.0 |
| 2020-06-19 04:23:00 | SPY | ETF | 311.47 | 311.47 | 311.47 | 311.47 | 169.0 |
| 2020-06-19 04:24:00 | SPY | ETF | 311.53 | 311.53 | 311.53 | 311.53 | 125.0 |
| 2020-06-19 04:26:00 | SPY | ETF | 311.59 | 311.65 | 311.59 | 311.65 | 500.0 |
| 2020-06-19 04:28:00 | SPY | ETF | 311.59 | 311.59 | 311.59 | 311.59 | 260.0 |
| 2020-06-19 04:29:00 | SPY | ETF | 311.57 | 311.57 | 311.57 | 311.57 | 100.0 |
| 2020-06-19 04:30:00 | SPY | ETF | 311.69 | 311.69 | 311.69 | 311.69 | 416.0 |
| 2020-06-19 04:32:00 | SPY | ETF | 311.62 | 311.62 | 311.62 | 311.62 | 218.0 |
| 2020-06-19 04:33:00 | SPY | ETF | 311.65 | 311.77 | 311.65 | 311.77 | 1407.0 |
| 2020-06-19 04:34:00 | SPY | ETF | 311.77 | 311.77 | 311.77 | 311.77 | 320.0 |
| 2020-06-19 04:35:00 | SPY | ETF | 311.67 | 311.67 | 311.67 | 311.67 | 416.0 |
| 2020-06-19 04:36:00 | SPY | ETF | 311.68 | 311.68 | 311.68 | 311.68 | 250.0 |
| 2020-06-19 04:38:00 | SPY | ETF | 311.57 | 311.57 | 311.4 | 311.4 | 2938.0 |
| 2020-06-19 04:39:00 | SPY | ETF | 311.34 | 311.42 | 311.33 | 311.42 | 1460.0 |
| 2020-06-19 04:40:00 | SPY | ETF | 311.49 | 311.49 | 311.42 | 311.42 | 697.0 |
| 2020-06-19 04:41:00 | SPY | ETF | 311.4 | 311.4 | 311.4 | 311.4 | 160.0 |
| 2020-06-19 04:42:00 | SPY | ETF | 311.58 | 311.58 | 311.58 | 311.58 | 101.0 |
| 2020-06-19 04:43:00 | SPY | ETF | 311.79 | 311.82 | 311.78 | 311.78 | 1325.0 |
| 2020-06-19 04:45:00 | SPY | ETF | 311.77 | 311.87 | 311.77 | 311.87 | 450.0 |
| 2020-06-19 04:46:00 | SPY | ETF | 311.84 | 311.84 | 311.84 | 311.84 | 150.0 |
| 2020-06-19 04:47:00 | SPY | ETF | 311.87 | 311.93 | 311.87 | 311.93 | 1400.0 |
| 2020-06-19 04:48:00 | SPY | ETF | 311.97 | 311.98 | 311.94 | 311.94 | 895.0 |
| 2020-06-19 04:49:00 | SPY | ETF | 311.97 | 311.97 | 311.97 | 311.97 | 115.0 |
| 2020-06-19 04:50:00 | SPY | ETF | 311.99 | 311.99 | 311.94 | 311.94 | 510.0 |
| 2020-06-19 04:51:00 | SPY | ETF | 311.97 | 312.0 | 311.97 | 312.0 | 569.0 |
| 2020-06-19 04:53:00 | SPY | ETF | 311.99 | 311.99 | 311.99 | 311.99 | 200.0 |
| 2020-06-19 04:55:00 | SPY | ETF | 311.94 | 311.99 | 311.9 | 311.9 | 8100.0 |
| 2020-06-19 04:58:00 | SPY | ETF | 311.92 | 311.92 | 311.92 | 311.92 | 100.0 |
| 2020-06-19 05:00:00 | SPY | ETF | 312.05 | 312.05 | 312.05 | 312.05 | 269.0 |
| 2020-06-19 05:03:00 | SPY | ETF | 312.04 | 312.04 | 312.04 | 312.04 | 302.0 |
| 2020-06-19 05:04:00 | SPY | ETF | 312.14 | 312.14 | 312.14 | 312.14 | 100.0 |
| 2020-06-19 05:06:00 | SPY | ETF | 312.1 | 312.1 | 312.07 | 312.07 | 226.0 |
| 2020-06-19 05:07:00 | SPY | ETF | 312.05 | 312.05 | 312.01 | 312.01 | 400.0 |
| 2020-06-19 05:08:00 | SPY | ETF | 311.94 | 311.94 | 311.9 | 311.91 | 3310.0 |
> showing 50 of 211,137 rows — these rows as CSV