PREVIEW / etf_1min / 2020-08-11
file: by_date/etf_1min/2020/2020-08-11.parquet size: 4.2 MB rows: 225,727
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-08-11 04:00:00 | SPY | ETF | 336.91 | 337.13 | 336.6 | 337.05 | 13478.0 |
| 2020-08-11 04:01:00 | SPY | ETF | 337.0 | 337.04 | 336.99 | 336.99 | 1665.0 |
| 2020-08-11 04:02:00 | SPY | ETF | 336.84 | 336.85 | 336.84 | 336.85 | 2189.0 |
| 2020-08-11 04:04:00 | SPY | ETF | 336.84 | 336.84 | 336.79 | 336.79 | 200.0 |
| 2020-08-11 04:07:00 | SPY | ETF | 336.88 | 336.89 | 336.88 | 336.88 | 20400.0 |
| 2020-08-11 04:08:00 | SPY | ETF | 336.82 | 336.82 | 336.82 | 336.82 | 100.0 |
| 2020-08-11 04:09:00 | SPY | ETF | 336.83 | 336.83 | 336.83 | 336.83 | 1041.0 |
| 2020-08-11 04:10:00 | SPY | ETF | 336.91 | 337.0 | 336.91 | 337.0 | 275.0 |
| 2020-08-11 04:13:00 | SPY | ETF | 336.9 | 336.9 | 336.82 | 336.83 | 3300.0 |
| 2020-08-11 04:14:00 | SPY | ETF | 336.87 | 336.88 | 336.87 | 336.88 | 1550.0 |
| 2020-08-11 04:18:00 | SPY | ETF | 336.83 | 336.86 | 336.83 | 336.86 | 2400.0 |
| 2020-08-11 04:19:00 | SPY | ETF | 336.83 | 336.83 | 336.83 | 336.83 | 1028.0 |
| 2020-08-11 04:20:00 | SPY | ETF | 336.83 | 336.83 | 336.83 | 336.83 | 1520.0 |
| 2020-08-11 04:22:00 | SPY | ETF | 336.97 | 337.2 | 336.97 | 337.2 | 1205.0 |
| 2020-08-11 04:24:00 | SPY | ETF | 337.02 | 337.02 | 337.02 | 337.02 | 116.0 |
| 2020-08-11 04:29:00 | SPY | ETF | 337.17 | 337.17 | 337.17 | 337.17 | 100.0 |
| 2020-08-11 04:33:00 | SPY | ETF | 337.18 | 337.18 | 337.18 | 337.18 | 209.0 |
| 2020-08-11 04:34:00 | SPY | ETF | 337.23 | 337.23 | 337.23 | 337.23 | 105.0 |
| 2020-08-11 04:36:00 | SPY | ETF | 337.3 | 337.45 | 337.3 | 337.45 | 773.0 |
| 2020-08-11 04:37:00 | SPY | ETF | 337.4 | 337.4 | 337.4 | 337.4 | 151.0 |
| 2020-08-11 04:38:00 | SPY | ETF | 337.41 | 337.41 | 337.41 | 337.41 | 274.0 |
| 2020-08-11 04:41:00 | SPY | ETF | 337.38 | 337.38 | 337.37 | 337.37 | 2500.0 |
| 2020-08-11 04:42:00 | SPY | ETF | 337.42 | 337.43 | 337.42 | 337.43 | 500.0 |
| 2020-08-11 04:44:00 | SPY | ETF | 337.5 | 337.5 | 337.5 | 337.5 | 2930.0 |
| 2020-08-11 04:45:00 | SPY | ETF | 337.53 | 337.56 | 337.53 | 337.56 | 600.0 |
| 2020-08-11 04:46:00 | SPY | ETF | 337.5 | 337.5 | 337.49 | 337.49 | 225.0 |
| 2020-08-11 04:48:00 | SPY | ETF | 337.54 | 337.54 | 337.54 | 337.54 | 100.0 |
| 2020-08-11 04:50:00 | SPY | ETF | 337.66 | 337.7 | 337.66 | 337.7 | 226.0 |
| 2020-08-11 04:51:00 | SPY | ETF | 337.73 | 337.73 | 337.61 | 337.61 | 5400.0 |
| 2020-08-11 04:52:00 | SPY | ETF | 337.6 | 337.6 | 337.6 | 337.6 | 160.0 |
| 2020-08-11 04:53:00 | SPY | ETF | 337.58 | 337.58 | 337.56 | 337.56 | 3500.0 |
| 2020-08-11 04:55:00 | SPY | ETF | 337.61 | 337.69 | 337.61 | 337.69 | 3960.0 |
| 2020-08-11 04:56:00 | SPY | ETF | 337.64 | 337.64 | 337.64 | 337.64 | 400.0 |
| 2020-08-11 04:57:00 | SPY | ETF | 337.65 | 337.7 | 337.65 | 337.7 | 1355.0 |
| 2020-08-11 04:58:00 | SPY | ETF | 337.72 | 337.8 | 337.72 | 337.8 | 2735.0 |
| 2020-08-11 04:59:00 | SPY | ETF | 337.75 | 337.84 | 337.75 | 337.84 | 5615.0 |
| 2020-08-11 05:00:00 | SPY | ETF | 337.84 | 337.84 | 337.84 | 337.84 | 200.0 |
| 2020-08-11 05:01:00 | SPY | ETF | 337.73 | 337.73 | 337.71 | 337.71 | 1110.0 |
| 2020-08-11 05:02:00 | SPY | ETF | 337.77 | 337.77 | 337.75 | 337.75 | 230.0 |
| 2020-08-11 05:03:00 | SPY | ETF | 337.6 | 337.6 | 337.6 | 337.6 | 2012.0 |
| 2020-08-11 05:04:00 | SPY | ETF | 337.59 | 337.59 | 337.59 | 337.59 | 566.0 |
| 2020-08-11 05:05:00 | SPY | ETF | 337.55 | 337.61 | 337.55 | 337.61 | 510.0 |
| 2020-08-11 05:06:00 | SPY | ETF | 337.55 | 337.55 | 337.55 | 337.55 | 205.0 |
| 2020-08-11 05:07:00 | SPY | ETF | 337.58 | 337.58 | 337.58 | 337.58 | 134.0 |
| 2020-08-11 05:08:00 | SPY | ETF | 337.7 | 337.77 | 337.7 | 337.77 | 500.0 |
| 2020-08-11 05:09:00 | SPY | ETF | 337.64 | 337.64 | 337.64 | 337.64 | 203.0 |
| 2020-08-11 05:10:00 | SPY | ETF | 337.72 | 337.72 | 337.65 | 337.65 | 361.0 |
| 2020-08-11 05:11:00 | SPY | ETF | 337.75 | 337.75 | 337.75 | 337.75 | 100.0 |
| 2020-08-11 05:13:00 | SPY | ETF | 337.7 | 337.7 | 337.7 | 337.7 | 300.0 |
| 2020-08-11 05:14:00 | SPY | ETF | 337.8 | 337.86 | 337.8 | 337.86 | 400.0 |
> showing 50 of 225,727 rows — these rows as CSV