PREVIEW / etf_1min / 2020-11-10
file: by_date/etf_1min/2020/2020-11-10.parquet size: 4.3 MB rows: 230,490
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-11-10 04:00:00 | SPY | ETF | 354.42 | 354.57 | 354.35 | 354.56 | 2999.0 |
| 2020-11-10 04:01:00 | SPY | ETF | 354.51 | 354.51 | 354.51 | 354.51 | 295.0 |
| 2020-11-10 04:02:00 | SPY | ETF | 354.57 | 354.64 | 354.57 | 354.6 | 3924.0 |
| 2020-11-10 04:03:00 | SPY | ETF | 354.56 | 354.73 | 354.55 | 354.73 | 4800.0 |
| 2020-11-10 04:04:00 | SPY | ETF | 354.81 | 354.81 | 354.8 | 354.8 | 3220.0 |
| 2020-11-10 04:05:00 | SPY | ETF | 354.63 | 354.67 | 354.55 | 354.56 | 3567.0 |
| 2020-11-10 04:06:00 | SPY | ETF | 354.28 | 354.35 | 354.28 | 354.35 | 227.0 |
| 2020-11-10 04:07:00 | SPY | ETF | 354.33 | 354.33 | 354.3 | 354.3 | 459.0 |
| 2020-11-10 04:08:00 | SPY | ETF | 354.3 | 354.3 | 354.3 | 354.3 | 100.0 |
| 2020-11-10 04:09:00 | SPY | ETF | 354.73 | 354.73 | 354.73 | 354.73 | 105.0 |
| 2020-11-10 04:10:00 | SPY | ETF | 354.73 | 354.73 | 354.73 | 354.73 | 140.0 |
| 2020-11-10 04:11:00 | SPY | ETF | 354.78 | 354.91 | 354.78 | 354.91 | 1570.0 |
| 2020-11-10 04:12:00 | SPY | ETF | 355.11 | 355.13 | 355.11 | 355.13 | 201.0 |
| 2020-11-10 04:13:00 | SPY | ETF | 355.15 | 355.15 | 355.1 | 355.1 | 6497.0 |
| 2020-11-10 04:14:00 | SPY | ETF | 355.15 | 355.16 | 355.0 | 355.0 | 4554.0 |
| 2020-11-10 04:15:00 | SPY | ETF | 355.0 | 355.15 | 355.0 | 355.1 | 12884.0 |
| 2020-11-10 04:16:00 | SPY | ETF | 355.17 | 355.2 | 354.95 | 355.0 | 1900.0 |
| 2020-11-10 04:18:00 | SPY | ETF | 355.02 | 355.02 | 354.88 | 354.88 | 6303.0 |
| 2020-11-10 04:19:00 | SPY | ETF | 354.99 | 355.2 | 354.99 | 355.0 | 8428.0 |
| 2020-11-10 04:20:00 | SPY | ETF | 355.0 | 355.0 | 354.76 | 354.76 | 16111.0 |
| 2020-11-10 04:21:00 | SPY | ETF | 354.8 | 354.8 | 354.8 | 354.8 | 5000.0 |
| 2020-11-10 04:22:00 | SPY | ETF | 354.8 | 354.8 | 354.8 | 354.8 | 903.0 |
| 2020-11-10 04:23:00 | SPY | ETF | 354.64 | 354.77 | 354.64 | 354.77 | 1663.0 |
| 2020-11-10 04:24:00 | SPY | ETF | 354.81 | 355.12 | 354.81 | 355.08 | 1670.0 |
| 2020-11-10 04:25:00 | SPY | ETF | 355.11 | 355.15 | 355.0 | 355.04 | 1649.0 |
| 2020-11-10 04:26:00 | SPY | ETF | 354.92 | 354.99 | 354.92 | 354.99 | 1200.0 |
| 2020-11-10 04:27:00 | SPY | ETF | 355.1 | 355.2 | 355.1 | 355.2 | 469.0 |
| 2020-11-10 04:29:00 | SPY | ETF | 355.24 | 355.35 | 355.24 | 355.35 | 645.0 |
| 2020-11-10 04:30:00 | SPY | ETF | 355.23 | 355.41 | 355.23 | 355.41 | 1000.0 |
| 2020-11-10 04:31:00 | SPY | ETF | 355.35 | 355.5 | 355.35 | 355.5 | 2743.0 |
| 2020-11-10 04:32:00 | SPY | ETF | 355.48 | 355.48 | 355.48 | 355.48 | 171.0 |
| 2020-11-10 04:33:00 | SPY | ETF | 355.2 | 355.2 | 355.2 | 355.2 | 251.0 |
| 2020-11-10 04:36:00 | SPY | ETF | 355.19 | 355.19 | 355.19 | 355.19 | 1010.0 |
| 2020-11-10 04:38:00 | SPY | ETF | 355.16 | 355.16 | 355.16 | 355.16 | 146.0 |
| 2020-11-10 04:39:00 | SPY | ETF | 355.25 | 355.45 | 355.25 | 355.44 | 1551.0 |
| 2020-11-10 04:40:00 | SPY | ETF | 355.55 | 355.55 | 355.55 | 355.55 | 1017.0 |
| 2020-11-10 04:41:00 | SPY | ETF | 355.56 | 355.56 | 355.43 | 355.5 | 1441.0 |
| 2020-11-10 04:42:00 | SPY | ETF | 355.52 | 355.53 | 355.31 | 355.36 | 4001.0 |
| 2020-11-10 04:43:00 | SPY | ETF | 355.13 | 355.13 | 354.95 | 354.96 | 2144.0 |
| 2020-11-10 04:46:00 | SPY | ETF | 355.45 | 355.45 | 355.4 | 355.45 | 1426.0 |
| 2020-11-10 04:47:00 | SPY | ETF | 355.54 | 355.65 | 355.54 | 355.65 | 1626.0 |
| 2020-11-10 04:48:00 | SPY | ETF | 355.69 | 355.77 | 355.65 | 355.73 | 5271.0 |
| 2020-11-10 04:49:00 | SPY | ETF | 355.65 | 355.67 | 355.65 | 355.66 | 2260.0 |
| 2020-11-10 04:50:00 | SPY | ETF | 355.75 | 355.77 | 355.47 | 355.47 | 5451.0 |
| 2020-11-10 04:51:00 | SPY | ETF | 355.34 | 355.5 | 355.34 | 355.5 | 1055.0 |
| 2020-11-10 04:53:00 | SPY | ETF | 355.47 | 355.47 | 355.32 | 355.32 | 323.0 |
| 2020-11-10 04:54:00 | SPY | ETF | 355.51 | 355.52 | 355.51 | 355.52 | 352.0 |
| 2020-11-10 04:55:00 | SPY | ETF | 355.6 | 355.64 | 355.6 | 355.64 | 350.0 |
| 2020-11-10 04:56:00 | SPY | ETF | 355.73 | 355.73 | 355.73 | 355.73 | 2002.0 |
| 2020-11-10 04:57:00 | SPY | ETF | 355.46 | 355.49 | 355.46 | 355.49 | 2001.0 |
> showing 50 of 230,490 rows — these rows as CSV