PREVIEW / etf_1min / 2020-05-11
file: by_date/etf_1min/2020/2020-05-11.parquet size: 3.8 MB rows: 209,143
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-11 04:00:00 | SPY | ETF | 293.83 | 294.34 | 293.83 | 294.05 | 2333.0 |
| 2020-05-11 04:01:00 | SPY | ETF | 294.05 | 294.05 | 294.05 | 294.05 | 239.0 |
| 2020-05-11 04:02:00 | SPY | ETF | 294.04 | 294.04 | 294.04 | 294.04 | 417.0 |
| 2020-05-11 04:03:00 | SPY | ETF | 293.95 | 293.97 | 293.95 | 293.97 | 1738.0 |
| 2020-05-11 04:04:00 | SPY | ETF | 293.94 | 293.96 | 293.94 | 293.96 | 200.0 |
| 2020-05-11 04:05:00 | SPY | ETF | 294.01 | 294.01 | 293.94 | 293.94 | 810.0 |
| 2020-05-11 04:06:00 | SPY | ETF | 293.96 | 294.02 | 293.96 | 294.02 | 5285.0 |
| 2020-05-11 04:07:00 | SPY | ETF | 294.0 | 294.0 | 294.0 | 294.0 | 333.0 |
| 2020-05-11 04:08:00 | SPY | ETF | 294.04 | 294.04 | 294.04 | 294.04 | 270.0 |
| 2020-05-11 04:09:00 | SPY | ETF | 293.96 | 293.96 | 293.92 | 293.92 | 722.0 |
| 2020-05-11 04:10:00 | SPY | ETF | 293.95 | 293.95 | 293.95 | 293.95 | 135.0 |
| 2020-05-11 04:11:00 | SPY | ETF | 293.91 | 293.96 | 293.91 | 293.96 | 1007.0 |
| 2020-05-11 04:12:00 | SPY | ETF | 293.97 | 293.97 | 293.97 | 293.97 | 1000.0 |
| 2020-05-11 04:13:00 | SPY | ETF | 293.98 | 293.98 | 293.98 | 293.98 | 554.0 |
| 2020-05-11 04:14:00 | SPY | ETF | 293.8 | 293.8 | 293.59 | 293.6 | 979.0 |
| 2020-05-11 04:15:00 | SPY | ETF | 293.6 | 293.6 | 293.57 | 293.59 | 2920.0 |
| 2020-05-11 04:16:00 | SPY | ETF | 293.58 | 293.64 | 293.58 | 293.64 | 660.0 |
| 2020-05-11 04:17:00 | SPY | ETF | 293.69 | 293.69 | 293.69 | 293.69 | 535.0 |
| 2020-05-11 04:18:00 | SPY | ETF | 293.57 | 293.57 | 293.57 | 293.57 | 2220.0 |
| 2020-05-11 04:19:00 | SPY | ETF | 293.64 | 293.67 | 293.64 | 293.67 | 610.0 |
| 2020-05-11 04:20:00 | SPY | ETF | 293.68 | 293.75 | 293.68 | 293.75 | 2306.0 |
| 2020-05-11 04:21:00 | SPY | ETF | 293.76 | 293.76 | 293.7 | 293.7 | 700.0 |
| 2020-05-11 04:22:00 | SPY | ETF | 293.72 | 293.72 | 293.68 | 293.68 | 851.0 |
| 2020-05-11 04:24:00 | SPY | ETF | 293.58 | 293.58 | 293.55 | 293.55 | 395.0 |
| 2020-05-11 04:25:00 | SPY | ETF | 293.52 | 293.55 | 293.5 | 293.5 | 1685.0 |
| 2020-05-11 04:26:00 | SPY | ETF | 293.45 | 293.45 | 293.45 | 293.45 | 730.0 |
| 2020-05-11 04:27:00 | SPY | ETF | 293.5 | 293.5 | 293.5 | 293.5 | 147.0 |
| 2020-05-11 04:30:00 | SPY | ETF | 293.42 | 293.42 | 293.4 | 293.4 | 953.0 |
| 2020-05-11 04:31:00 | SPY | ETF | 293.4 | 293.4 | 293.37 | 293.38 | 1703.0 |
| 2020-05-11 04:32:00 | SPY | ETF | 293.4 | 293.44 | 293.39 | 293.44 | 2000.0 |
| 2020-05-11 04:33:00 | SPY | ETF | 293.5 | 293.5 | 293.43 | 293.43 | 2300.0 |
| 2020-05-11 04:34:00 | SPY | ETF | 293.33 | 293.4 | 293.33 | 293.4 | 2650.0 |
| 2020-05-11 04:35:00 | SPY | ETF | 293.36 | 293.36 | 293.33 | 293.36 | 2325.0 |
| 2020-05-11 04:36:00 | SPY | ETF | 293.23 | 293.23 | 293.07 | 293.07 | 4623.0 |
| 2020-05-11 04:38:00 | SPY | ETF | 293.14 | 293.14 | 293.05 | 293.05 | 1105.0 |
| 2020-05-11 04:39:00 | SPY | ETF | 293.06 | 293.19 | 293.06 | 293.19 | 1781.0 |
| 2020-05-11 04:40:00 | SPY | ETF | 293.22 | 293.25 | 293.16 | 293.21 | 2255.0 |
| 2020-05-11 04:41:00 | SPY | ETF | 293.11 | 293.11 | 293.11 | 293.11 | 540.0 |
| 2020-05-11 04:42:00 | SPY | ETF | 293.1 | 293.1 | 293.0 | 293.01 | 4784.0 |
| 2020-05-11 04:43:00 | SPY | ETF | 292.98 | 293.02 | 292.98 | 293.02 | 822.0 |
| 2020-05-11 04:44:00 | SPY | ETF | 292.96 | 292.96 | 292.87 | 292.87 | 2530.0 |
| 2020-05-11 04:45:00 | SPY | ETF | 292.83 | 292.83 | 292.7 | 292.71 | 984.0 |
| 2020-05-11 04:46:00 | SPY | ETF | 292.66 | 292.67 | 292.65 | 292.65 | 459.0 |
| 2020-05-11 04:47:00 | SPY | ETF | 292.67 | 292.67 | 292.52 | 292.6 | 1374.0 |
| 2020-05-11 04:49:00 | SPY | ETF | 292.69 | 292.69 | 292.5 | 292.5 | 6486.0 |
| 2020-05-11 04:50:00 | SPY | ETF | 292.54 | 292.65 | 292.54 | 292.65 | 704.0 |
| 2020-05-11 04:51:00 | SPY | ETF | 292.65 | 292.65 | 292.61 | 292.61 | 1150.0 |
| 2020-05-11 04:52:00 | SPY | ETF | 292.59 | 292.66 | 292.59 | 292.63 | 1356.0 |
| 2020-05-11 04:53:00 | SPY | ETF | 292.65 | 292.71 | 292.65 | 292.71 | 1672.0 |
| 2020-05-11 04:54:00 | SPY | ETF | 292.72 | 292.72 | 292.68 | 292.68 | 738.0 |
> showing 50 of 209,143 rows — these rows as CSV