PREVIEW / etf_1min / 2020-05-05
file: by_date/etf_1min/2020/2020-05-05.parquet size: 4.0 MB rows: 211,054
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-05-05 04:00:00 | SPY | ETF | 286.17 | 286.4 | 286.17 | 286.35 | 6270.0 |
| 2020-05-05 04:01:00 | SPY | ETF | 286.35 | 286.44 | 286.35 | 286.37 | 2235.0 |
| 2020-05-05 04:02:00 | SPY | ETF | 286.37 | 286.41 | 286.27 | 286.41 | 3955.0 |
| 2020-05-05 04:03:00 | SPY | ETF | 286.23 | 286.33 | 286.23 | 286.33 | 1085.0 |
| 2020-05-05 04:04:00 | SPY | ETF | 286.41 | 286.41 | 286.34 | 286.34 | 672.0 |
| 2020-05-05 04:05:00 | SPY | ETF | 286.36 | 286.36 | 286.3 | 286.33 | 1050.0 |
| 2020-05-05 04:06:00 | SPY | ETF | 286.54 | 286.56 | 286.54 | 286.56 | 1966.0 |
| 2020-05-05 04:07:00 | SPY | ETF | 286.58 | 286.71 | 286.57 | 286.65 | 8494.0 |
| 2020-05-05 04:08:00 | SPY | ETF | 286.58 | 286.69 | 286.58 | 286.67 | 2123.0 |
| 2020-05-05 04:09:00 | SPY | ETF | 286.53 | 286.53 | 286.53 | 286.53 | 638.0 |
| 2020-05-05 04:10:00 | SPY | ETF | 286.63 | 286.63 | 286.58 | 286.58 | 5120.0 |
| 2020-05-05 04:11:00 | SPY | ETF | 286.7 | 286.73 | 286.63 | 286.69 | 985.0 |
| 2020-05-05 04:12:00 | SPY | ETF | 286.82 | 286.82 | 286.78 | 286.78 | 650.0 |
| 2020-05-05 04:13:00 | SPY | ETF | 286.76 | 286.8 | 286.7 | 286.8 | 3665.0 |
| 2020-05-05 04:14:00 | SPY | ETF | 286.8 | 286.8 | 286.46 | 286.46 | 5800.0 |
| 2020-05-05 04:15:00 | SPY | ETF | 286.34 | 286.34 | 285.68 | 285.68 | 4110.0 |
| 2020-05-05 04:16:00 | SPY | ETF | 285.72 | 285.99 | 285.72 | 285.9 | 5945.0 |
| 2020-05-05 04:17:00 | SPY | ETF | 285.99 | 285.99 | 285.95 | 285.95 | 1207.0 |
| 2020-05-05 04:18:00 | SPY | ETF | 285.92 | 285.92 | 285.88 | 285.88 | 705.0 |
| 2020-05-05 04:19:00 | SPY | ETF | 285.82 | 285.82 | 285.82 | 285.82 | 110.0 |
| 2020-05-05 04:20:00 | SPY | ETF | 285.82 | 285.82 | 285.76 | 285.76 | 891.0 |
| 2020-05-05 04:21:00 | SPY | ETF | 285.88 | 285.94 | 285.88 | 285.94 | 752.0 |
| 2020-05-05 04:22:00 | SPY | ETF | 285.9 | 286.38 | 285.9 | 286.38 | 1110.0 |
| 2020-05-05 04:23:00 | SPY | ETF | 286.26 | 286.32 | 286.26 | 286.32 | 814.0 |
| 2020-05-05 04:25:00 | SPY | ETF | 286.6 | 286.66 | 286.6 | 286.65 | 1200.0 |
| 2020-05-05 04:26:00 | SPY | ETF | 286.68 | 286.68 | 286.59 | 286.61 | 1012.0 |
| 2020-05-05 04:27:00 | SPY | ETF | 286.61 | 286.65 | 286.6 | 286.6 | 563.0 |
| 2020-05-05 04:29:00 | SPY | ETF | 286.59 | 286.59 | 286.51 | 286.51 | 700.0 |
| 2020-05-05 04:30:00 | SPY | ETF | 286.52 | 286.52 | 286.37 | 286.37 | 1809.0 |
| 2020-05-05 04:31:00 | SPY | ETF | 285.96 | 286.05 | 285.93 | 286.03 | 4087.0 |
| 2020-05-05 04:32:00 | SPY | ETF | 285.81 | 285.85 | 285.81 | 285.85 | 808.0 |
| 2020-05-05 04:33:00 | SPY | ETF | 285.75 | 285.8 | 285.75 | 285.8 | 8630.0 |
| 2020-05-05 04:34:00 | SPY | ETF | 285.75 | 285.75 | 285.63 | 285.75 | 3520.0 |
| 2020-05-05 04:35:00 | SPY | ETF | 285.82 | 285.93 | 285.82 | 285.93 | 640.0 |
| 2020-05-05 04:36:00 | SPY | ETF | 285.92 | 285.92 | 285.92 | 285.92 | 120.0 |
| 2020-05-05 04:37:00 | SPY | ETF | 285.75 | 285.79 | 285.75 | 285.79 | 888.0 |
| 2020-05-05 04:38:00 | SPY | ETF | 285.7 | 285.8 | 285.7 | 285.8 | 10200.0 |
| 2020-05-05 04:39:00 | SPY | ETF | 285.61 | 285.68 | 285.6 | 285.68 | 840.0 |
| 2020-05-05 04:40:00 | SPY | ETF | 285.55 | 285.61 | 285.45 | 285.45 | 2191.0 |
| 2020-05-05 04:41:00 | SPY | ETF | 285.3 | 285.37 | 285.27 | 285.27 | 1705.0 |
| 2020-05-05 04:42:00 | SPY | ETF | 285.41 | 285.41 | 284.95 | 284.95 | 3749.0 |
| 2020-05-05 04:43:00 | SPY | ETF | 284.92 | 285.13 | 284.92 | 285.09 | 27820.0 |
| 2020-05-05 04:44:00 | SPY | ETF | 285.13 | 285.26 | 285.13 | 285.26 | 923.0 |
| 2020-05-05 04:45:00 | SPY | ETF | 285.13 | 285.13 | 285.11 | 285.11 | 3074.0 |
| 2020-05-05 04:46:00 | SPY | ETF | 285.12 | 285.15 | 285.12 | 285.14 | 1200.0 |
| 2020-05-05 04:47:00 | SPY | ETF | 285.01 | 285.02 | 285.0 | 285.0 | 1790.0 |
| 2020-05-05 04:48:00 | SPY | ETF | 285.0 | 285.1 | 284.75 | 284.75 | 8040.0 |
| 2020-05-05 04:49:00 | SPY | ETF | 284.67 | 284.67 | 284.45 | 284.48 | 13721.0 |
| 2020-05-05 04:50:00 | SPY | ETF | 284.48 | 284.48 | 284.2 | 284.2 | 3003.0 |
| 2020-05-05 04:51:00 | SPY | ETF | 284.22 | 284.51 | 284.17 | 284.51 | 6910.0 |
> showing 50 of 211,054 rows — these rows as CSV