PREVIEW / etf_1min / 2020-07-24
file: by_date/etf_1min/2020/2020-07-24.parquet size: 3.6 MB rows: 201,999
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-07-24 04:00:00 | SPY | ETF | 320.67 | 320.72 | 320.61 | 320.67 | 6606.0 |
| 2020-07-24 04:01:00 | SPY | ETF | 320.58 | 320.6 | 320.53 | 320.6 | 2022.0 |
| 2020-07-24 04:02:00 | SPY | ETF | 320.77 | 320.87 | 320.69 | 320.87 | 2065.0 |
| 2020-07-24 04:03:00 | SPY | ETF | 320.87 | 320.92 | 320.8 | 320.8 | 4114.0 |
| 2020-07-24 04:04:00 | SPY | ETF | 320.91 | 320.95 | 320.91 | 320.95 | 610.0 |
| 2020-07-24 04:05:00 | SPY | ETF | 320.97 | 321.0 | 320.75 | 320.75 | 2377.0 |
| 2020-07-24 04:06:00 | SPY | ETF | 320.75 | 320.89 | 320.75 | 320.89 | 3083.0 |
| 2020-07-24 04:07:00 | SPY | ETF | 320.7 | 320.7 | 320.66 | 320.66 | 3060.0 |
| 2020-07-24 04:09:00 | SPY | ETF | 320.75 | 320.75 | 320.55 | 320.55 | 5530.0 |
| 2020-07-24 04:10:00 | SPY | ETF | 320.55 | 320.69 | 320.55 | 320.69 | 5784.0 |
| 2020-07-24 04:11:00 | SPY | ETF | 320.54 | 320.86 | 320.54 | 320.83 | 5399.0 |
| 2020-07-24 04:12:00 | SPY | ETF | 320.96 | 321.05 | 320.96 | 321.05 | 558.0 |
| 2020-07-24 04:13:00 | SPY | ETF | 321.06 | 321.11 | 321.06 | 321.11 | 732.0 |
| 2020-07-24 04:14:00 | SPY | ETF | 321.22 | 321.22 | 321.22 | 321.22 | 631.0 |
| 2020-07-24 04:15:00 | SPY | ETF | 321.22 | 321.22 | 321.16 | 321.18 | 1320.0 |
| 2020-07-24 04:16:00 | SPY | ETF | 321.12 | 321.12 | 321.12 | 321.12 | 680.0 |
| 2020-07-24 04:17:00 | SPY | ETF | 321.08 | 321.08 | 321.08 | 321.08 | 1110.0 |
| 2020-07-24 04:21:00 | SPY | ETF | 320.9 | 320.96 | 320.9 | 320.96 | 1589.0 |
| 2020-07-24 04:22:00 | SPY | ETF | 320.88 | 320.88 | 320.88 | 320.88 | 803.0 |
| 2020-07-24 04:23:00 | SPY | ETF | 320.91 | 321.05 | 320.91 | 321.04 | 1423.0 |
| 2020-07-24 04:26:00 | SPY | ETF | 321.0 | 321.0 | 321.0 | 321.0 | 300.0 |
| 2020-07-24 04:27:00 | SPY | ETF | 320.85 | 320.85 | 320.81 | 320.81 | 200.0 |
| 2020-07-24 04:29:00 | SPY | ETF | 320.95 | 320.95 | 320.95 | 320.95 | 528.0 |
| 2020-07-24 04:30:00 | SPY | ETF | 321.04 | 321.19 | 321.04 | 321.19 | 277.0 |
| 2020-07-24 04:31:00 | SPY | ETF | 321.23 | 321.31 | 321.23 | 321.26 | 3141.0 |
| 2020-07-24 04:33:00 | SPY | ETF | 321.3 | 321.3 | 321.3 | 321.3 | 111.0 |
| 2020-07-24 04:34:00 | SPY | ETF | 321.38 | 321.4 | 321.25 | 321.3 | 36830.0 |
| 2020-07-24 04:36:00 | SPY | ETF | 321.04 | 321.15 | 321.01 | 321.15 | 483.0 |
| 2020-07-24 04:37:00 | SPY | ETF | 321.26 | 321.32 | 321.22 | 321.28 | 25338.0 |
| 2020-07-24 04:38:00 | SPY | ETF | 321.38 | 321.43 | 321.38 | 321.39 | 2405.0 |
| 2020-07-24 04:39:00 | SPY | ETF | 321.37 | 321.37 | 321.37 | 321.37 | 259.0 |
| 2020-07-24 04:40:00 | SPY | ETF | 321.35 | 321.35 | 321.35 | 321.35 | 250.0 |
| 2020-07-24 04:41:00 | SPY | ETF | 321.3 | 321.3 | 321.3 | 321.3 | 555.0 |
| 2020-07-24 04:42:00 | SPY | ETF | 321.33 | 321.33 | 321.23 | 321.23 | 810.0 |
| 2020-07-24 04:43:00 | SPY | ETF | 321.32 | 321.32 | 321.32 | 321.32 | 1005.0 |
| 2020-07-24 04:45:00 | SPY | ETF | 321.1 | 321.11 | 321.08 | 321.08 | 1160.0 |
| 2020-07-24 04:48:00 | SPY | ETF | 321.05 | 321.06 | 321.05 | 321.06 | 255.0 |
| 2020-07-24 04:49:00 | SPY | ETF | 321.1 | 321.1 | 321.1 | 321.1 | 155.0 |
| 2020-07-24 04:50:00 | SPY | ETF | 321.15 | 321.15 | 321.15 | 321.15 | 155.0 |
| 2020-07-24 04:53:00 | SPY | ETF | 321.23 | 321.23 | 321.23 | 321.23 | 400.0 |
| 2020-07-24 04:54:00 | SPY | ETF | 321.43 | 321.45 | 321.43 | 321.45 | 675.0 |
| 2020-07-24 04:55:00 | SPY | ETF | 321.33 | 321.33 | 321.33 | 321.33 | 155.0 |
| 2020-07-24 04:56:00 | SPY | ETF | 321.47 | 321.5 | 321.47 | 321.5 | 1071.0 |
| 2020-07-24 04:58:00 | SPY | ETF | 321.55 | 321.56 | 321.55 | 321.56 | 615.0 |
| 2020-07-24 04:59:00 | SPY | ETF | 321.56 | 321.6 | 321.56 | 321.6 | 1450.0 |
| 2020-07-24 05:00:00 | SPY | ETF | 321.68 | 321.68 | 321.62 | 321.62 | 620.0 |
| 2020-07-24 05:01:00 | SPY | ETF | 321.62 | 321.62 | 321.62 | 321.62 | 3645.0 |
| 2020-07-24 05:02:00 | SPY | ETF | 321.58 | 321.58 | 321.57 | 321.57 | 530.0 |
| 2020-07-24 05:03:00 | SPY | ETF | 321.47 | 321.47 | 321.47 | 321.47 | 220.0 |
| 2020-07-24 05:06:00 | SPY | ETF | 321.39 | 321.39 | 321.39 | 321.39 | 150.0 |
> showing 50 of 201,999 rows — these rows as CSV