PREVIEW / etf_1min / 2021-01-06
file: by_date/etf_1min/2021/2021-01-06.parquet size: 4.8 MB rows: 258,954
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-06 04:00:00 | SPY | ETF | 368.66 | 368.79 | 368.6 | 368.6 | 5971.0 |
| 2021-01-06 04:01:00 | SPY | ETF | 368.31 | 368.44 | 368.04 | 368.44 | 6340.0 |
| 2021-01-06 04:02:00 | SPY | ETF | 368.59 | 368.69 | 368.5 | 368.5 | 6776.0 |
| 2021-01-06 04:03:00 | SPY | ETF | 368.55 | 368.66 | 368.55 | 368.66 | 4102.0 |
| 2021-01-06 04:04:00 | SPY | ETF | 368.69 | 368.74 | 368.69 | 368.74 | 2745.0 |
| 2021-01-06 04:05:00 | SPY | ETF | 368.69 | 368.74 | 368.61 | 368.69 | 2183.0 |
| 2021-01-06 04:06:00 | SPY | ETF | 368.76 | 368.76 | 368.76 | 368.76 | 657.0 |
| 2021-01-06 04:07:00 | SPY | ETF | 368.81 | 368.81 | 368.81 | 368.81 | 353.0 |
| 2021-01-06 04:08:00 | SPY | ETF | 368.75 | 368.75 | 368.67 | 368.67 | 978.0 |
| 2021-01-06 04:09:00 | SPY | ETF | 368.75 | 368.84 | 368.75 | 368.84 | 2802.0 |
| 2021-01-06 04:10:00 | SPY | ETF | 368.82 | 368.89 | 368.77 | 368.77 | 2565.0 |
| 2021-01-06 04:11:00 | SPY | ETF | 368.74 | 368.92 | 368.74 | 368.92 | 2050.0 |
| 2021-01-06 04:13:00 | SPY | ETF | 368.9 | 369.02 | 368.9 | 369.02 | 252.0 |
| 2021-01-06 04:14:00 | SPY | ETF | 369.1 | 369.11 | 369.02 | 369.02 | 3055.0 |
| 2021-01-06 04:15:00 | SPY | ETF | 369.08 | 369.3 | 369.08 | 369.3 | 2385.0 |
| 2021-01-06 04:16:00 | SPY | ETF | 369.21 | 369.27 | 369.2 | 369.2 | 3236.0 |
| 2021-01-06 04:17:00 | SPY | ETF | 369.29 | 369.47 | 369.29 | 369.47 | 4435.0 |
| 2021-01-06 04:18:00 | SPY | ETF | 369.7 | 369.79 | 369.7 | 369.72 | 3802.0 |
| 2021-01-06 04:19:00 | SPY | ETF | 369.79 | 369.8 | 369.71 | 369.71 | 3789.0 |
| 2021-01-06 04:20:00 | SPY | ETF | 369.75 | 369.77 | 369.71 | 369.72 | 3735.0 |
| 2021-01-06 04:21:00 | SPY | ETF | 369.66 | 369.69 | 369.64 | 369.67 | 3464.0 |
| 2021-01-06 04:22:00 | SPY | ETF | 369.6 | 369.6 | 369.49 | 369.49 | 2122.0 |
| 2021-01-06 04:23:00 | SPY | ETF | 369.49 | 369.5 | 369.46 | 369.5 | 2392.0 |
| 2021-01-06 04:24:00 | SPY | ETF | 369.48 | 369.51 | 369.48 | 369.51 | 1166.0 |
| 2021-01-06 04:25:00 | SPY | ETF | 369.53 | 369.55 | 369.53 | 369.55 | 1750.0 |
| 2021-01-06 04:26:00 | SPY | ETF | 369.56 | 369.56 | 369.56 | 369.56 | 460.0 |
| 2021-01-06 04:27:00 | SPY | ETF | 369.49 | 369.5 | 369.48 | 369.49 | 2282.0 |
| 2021-01-06 04:28:00 | SPY | ETF | 369.49 | 369.49 | 369.49 | 369.49 | 1076.0 |
| 2021-01-06 04:29:00 | SPY | ETF | 369.47 | 369.47 | 369.47 | 369.47 | 1000.0 |
| 2021-01-06 04:31:00 | SPY | ETF | 369.36 | 369.4 | 369.36 | 369.4 | 1945.0 |
| 2021-01-06 04:32:00 | SPY | ETF | 369.4 | 369.52 | 369.4 | 369.5 | 1513.0 |
| 2021-01-06 04:33:00 | SPY | ETF | 369.5 | 369.58 | 369.5 | 369.58 | 610.0 |
| 2021-01-06 04:34:00 | SPY | ETF | 369.55 | 369.55 | 369.55 | 369.55 | 201.0 |
| 2021-01-06 04:35:00 | SPY | ETF | 369.55 | 369.64 | 369.39 | 369.51 | 7862.0 |
| 2021-01-06 04:36:00 | SPY | ETF | 369.46 | 369.46 | 369.46 | 369.46 | 500.0 |
| 2021-01-06 04:37:00 | SPY | ETF | 369.43 | 369.43 | 369.43 | 369.43 | 1110.0 |
| 2021-01-06 04:38:00 | SPY | ETF | 369.45 | 369.46 | 369.45 | 369.45 | 2120.0 |
| 2021-01-06 04:39:00 | SPY | ETF | 369.6 | 369.6 | 369.54 | 369.54 | 560.0 |
| 2021-01-06 04:40:00 | SPY | ETF | 369.54 | 369.56 | 369.54 | 369.56 | 639.0 |
| 2021-01-06 04:41:00 | SPY | ETF | 369.48 | 369.52 | 369.48 | 369.52 | 1700.0 |
| 2021-01-06 04:43:00 | SPY | ETF | 369.59 | 369.67 | 369.59 | 369.67 | 410.0 |
| 2021-01-06 04:44:00 | SPY | ETF | 369.7 | 369.7 | 369.7 | 369.7 | 240.0 |
| 2021-01-06 04:45:00 | SPY | ETF | 369.78 | 369.78 | 369.78 | 369.78 | 215.0 |
| 2021-01-06 04:46:00 | SPY | ETF | 369.76 | 369.9 | 369.76 | 369.9 | 6041.0 |
| 2021-01-06 04:47:00 | SPY | ETF | 369.97 | 370.05 | 369.97 | 370.05 | 10340.0 |
| 2021-01-06 04:48:00 | SPY | ETF | 370.15 | 370.2 | 370.15 | 370.2 | 660.0 |
| 2021-01-06 04:49:00 | SPY | ETF | 370.31 | 370.48 | 370.27 | 370.42 | 6985.0 |
| 2021-01-06 04:50:00 | SPY | ETF | 370.45 | 370.62 | 370.42 | 370.6 | 1154.0 |
| 2021-01-06 04:51:00 | SPY | ETF | 370.57 | 370.64 | 370.56 | 370.56 | 12620.0 |
| 2021-01-06 04:52:00 | SPY | ETF | 370.46 | 370.46 | 370.46 | 370.46 | 100.0 |
> showing 50 of 258,954 rows — these rows as CSV