PREVIEW / etf_1min / 2020-09-04
file: by_date/etf_1min/2020/2020-09-04.parquet size: 4.4 MB rows: 230,347
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-04 04:00:00 | SPY | ETF | 347.0 | 347.03 | 346.86 | 346.99 | 9479.0 |
| 2020-09-04 04:01:00 | SPY | ETF | 346.98 | 347.04 | 346.96 | 347.0 | 2136.0 |
| 2020-09-04 04:02:00 | SPY | ETF | 346.94 | 346.99 | 346.94 | 346.99 | 3841.0 |
| 2020-09-04 04:03:00 | SPY | ETF | 346.96 | 347.04 | 346.96 | 347.04 | 3304.0 |
| 2020-09-04 04:04:00 | SPY | ETF | 346.81 | 346.81 | 346.74 | 346.74 | 1201.0 |
| 2020-09-04 04:05:00 | SPY | ETF | 346.75 | 346.76 | 346.69 | 346.69 | 1000.0 |
| 2020-09-04 04:06:00 | SPY | ETF | 346.69 | 346.69 | 346.69 | 346.69 | 115.0 |
| 2020-09-04 04:09:00 | SPY | ETF | 346.86 | 347.06 | 346.86 | 347.06 | 2357.0 |
| 2020-09-04 04:10:00 | SPY | ETF | 346.89 | 346.89 | 346.89 | 346.89 | 215.0 |
| 2020-09-04 04:11:00 | SPY | ETF | 346.81 | 346.87 | 346.81 | 346.87 | 460.0 |
| 2020-09-04 04:12:00 | SPY | ETF | 346.8 | 346.8 | 346.76 | 346.76 | 4726.0 |
| 2020-09-04 04:13:00 | SPY | ETF | 346.84 | 346.87 | 346.84 | 346.87 | 491.0 |
| 2020-09-04 04:14:00 | SPY | ETF | 347.22 | 347.22 | 347.19 | 347.19 | 255.0 |
| 2020-09-04 04:15:00 | SPY | ETF | 347.26 | 347.44 | 347.2 | 347.43 | 3286.0 |
| 2020-09-04 04:16:00 | SPY | ETF | 347.44 | 347.44 | 347.39 | 347.43 | 3485.0 |
| 2020-09-04 04:17:00 | SPY | ETF | 347.34 | 347.43 | 347.34 | 347.43 | 1000.0 |
| 2020-09-04 04:18:00 | SPY | ETF | 347.38 | 347.38 | 347.24 | 347.24 | 4700.0 |
| 2020-09-04 04:19:00 | SPY | ETF | 347.25 | 347.25 | 347.11 | 347.11 | 1435.0 |
| 2020-09-04 04:20:00 | SPY | ETF | 347.09 | 347.11 | 347.09 | 347.11 | 360.0 |
| 2020-09-04 04:25:00 | SPY | ETF | 347.08 | 347.28 | 347.08 | 347.28 | 770.0 |
| 2020-09-04 04:26:00 | SPY | ETF | 347.33 | 347.33 | 347.31 | 347.31 | 800.0 |
| 2020-09-04 04:27:00 | SPY | ETF | 347.36 | 347.36 | 347.36 | 347.36 | 103.0 |
| 2020-09-04 04:29:00 | SPY | ETF | 347.2 | 347.21 | 347.2 | 347.21 | 1030.0 |
| 2020-09-04 04:30:00 | SPY | ETF | 347.2 | 347.23 | 347.17 | 347.18 | 1614.0 |
| 2020-09-04 04:34:00 | SPY | ETF | 347.56 | 347.76 | 347.53 | 347.7 | 4366.0 |
| 2020-09-04 04:35:00 | SPY | ETF | 347.73 | 347.8 | 347.73 | 347.73 | 1535.0 |
| 2020-09-04 04:36:00 | SPY | ETF | 347.74 | 347.74 | 347.58 | 347.61 | 710.0 |
| 2020-09-04 04:37:00 | SPY | ETF | 347.61 | 347.61 | 347.56 | 347.56 | 4000.0 |
| 2020-09-04 04:39:00 | SPY | ETF | 347.66 | 347.66 | 347.63 | 347.63 | 303.0 |
| 2020-09-04 04:40:00 | SPY | ETF | 347.61 | 347.66 | 347.6 | 347.66 | 1860.0 |
| 2020-09-04 04:41:00 | SPY | ETF | 347.59 | 347.59 | 347.56 | 347.58 | 4530.0 |
| 2020-09-04 04:42:00 | SPY | ETF | 347.6 | 347.6 | 347.58 | 347.6 | 1059.0 |
| 2020-09-04 04:43:00 | SPY | ETF | 347.56 | 347.56 | 347.47 | 347.51 | 1667.0 |
| 2020-09-04 04:46:00 | SPY | ETF | 347.29 | 347.32 | 347.29 | 347.32 | 581.0 |
| 2020-09-04 04:48:00 | SPY | ETF | 347.46 | 347.46 | 347.46 | 347.46 | 570.0 |
| 2020-09-04 04:49:00 | SPY | ETF | 347.47 | 347.47 | 347.47 | 347.47 | 375.0 |
| 2020-09-04 04:50:00 | SPY | ETF | 347.45 | 347.45 | 347.45 | 347.45 | 150.0 |
| 2020-09-04 04:51:00 | SPY | ETF | 347.69 | 347.69 | 347.69 | 347.69 | 400.0 |
| 2020-09-04 04:52:00 | SPY | ETF | 347.7 | 347.7 | 347.7 | 347.7 | 1005.0 |
| 2020-09-04 04:53:00 | SPY | ETF | 347.64 | 347.64 | 347.64 | 347.64 | 180.0 |
| 2020-09-04 04:57:00 | SPY | ETF | 347.46 | 347.46 | 347.36 | 347.36 | 658.0 |
| 2020-09-04 05:01:00 | SPY | ETF | 347.6 | 347.6 | 347.6 | 347.6 | 100.0 |
| 2020-09-04 05:03:00 | SPY | ETF | 347.49 | 347.49 | 347.49 | 347.49 | 250.0 |
| 2020-09-04 05:05:00 | SPY | ETF | 347.48 | 347.48 | 347.48 | 347.48 | 1710.0 |
| 2020-09-04 05:08:00 | SPY | ETF | 347.4 | 347.4 | 347.4 | 347.4 | 210.0 |
| 2020-09-04 05:09:00 | SPY | ETF | 347.34 | 347.38 | 347.34 | 347.37 | 414.0 |
| 2020-09-04 05:10:00 | SPY | ETF | 347.4 | 347.4 | 347.31 | 347.33 | 2107.0 |
| 2020-09-04 05:11:00 | SPY | ETF | 347.35 | 347.35 | 347.35 | 347.35 | 164.0 |
| 2020-09-04 05:13:00 | SPY | ETF | 347.39 | 347.39 | 347.39 | 347.39 | 230.0 |
| 2020-09-04 05:14:00 | SPY | ETF | 347.33 | 347.33 | 347.33 | 347.33 | 206.0 |
> showing 50 of 230,347 rows — these rows as CSV