PREVIEW / etf_1min / 2020-04-22
file: by_date/etf_1min/2020/2020-04-22.parquet size: 3.8 MB rows: 207,008
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-04-22 04:00:00 | SPY | ETF | 275.77 | 275.77 | 275.6 | 275.66 | 3665.0 |
| 2020-04-22 04:01:00 | SPY | ETF | 275.68 | 275.87 | 275.65 | 275.65 | 8202.0 |
| 2020-04-22 04:02:00 | SPY | ETF | 275.68 | 275.83 | 275.68 | 275.83 | 488.0 |
| 2020-04-22 04:03:00 | SPY | ETF | 275.76 | 275.87 | 275.76 | 275.81 | 6270.0 |
| 2020-04-22 04:04:00 | SPY | ETF | 275.65 | 275.65 | 275.65 | 275.65 | 303.0 |
| 2020-04-22 04:05:00 | SPY | ETF | 275.8 | 275.87 | 275.8 | 275.87 | 1100.0 |
| 2020-04-22 04:06:00 | SPY | ETF | 276.0 | 276.1 | 275.96 | 275.96 | 6384.0 |
| 2020-04-22 04:07:00 | SPY | ETF | 275.88 | 275.9 | 275.88 | 275.9 | 3070.0 |
| 2020-04-22 04:08:00 | SPY | ETF | 275.99 | 275.99 | 275.99 | 275.99 | 465.0 |
| 2020-04-22 04:09:00 | SPY | ETF | 276.09 | 276.13 | 276.09 | 276.13 | 410.0 |
| 2020-04-22 04:10:00 | SPY | ETF | 276.18 | 276.18 | 276.13 | 276.13 | 303.0 |
| 2020-04-22 04:11:00 | SPY | ETF | 276.33 | 276.33 | 276.33 | 276.33 | 100.0 |
| 2020-04-22 04:12:00 | SPY | ETF | 276.3 | 276.5 | 276.3 | 276.5 | 2306.0 |
| 2020-04-22 04:13:00 | SPY | ETF | 276.52 | 276.52 | 276.48 | 276.48 | 2682.0 |
| 2020-04-22 04:15:00 | SPY | ETF | 276.46 | 276.46 | 276.46 | 276.46 | 294.0 |
| 2020-04-22 04:16:00 | SPY | ETF | 276.5 | 276.58 | 276.5 | 276.58 | 1100.0 |
| 2020-04-22 04:17:00 | SPY | ETF | 276.5 | 276.6 | 276.5 | 276.6 | 1100.0 |
| 2020-04-22 04:18:00 | SPY | ETF | 276.6 | 276.64 | 276.59 | 276.6 | 15040.0 |
| 2020-04-22 04:19:00 | SPY | ETF | 276.61 | 276.7 | 276.61 | 276.69 | 720.0 |
| 2020-04-22 04:20:00 | SPY | ETF | 276.75 | 276.75 | 276.73 | 276.73 | 416.0 |
| 2020-04-22 04:21:00 | SPY | ETF | 276.66 | 276.77 | 276.66 | 276.7 | 1650.0 |
| 2020-04-22 04:22:00 | SPY | ETF | 276.65 | 276.65 | 276.65 | 276.65 | 652.0 |
| 2020-04-22 04:23:00 | SPY | ETF | 276.65 | 276.65 | 276.65 | 276.65 | 1102.0 |
| 2020-04-22 04:24:00 | SPY | ETF | 276.52 | 276.52 | 276.52 | 276.52 | 332.0 |
| 2020-04-22 04:26:00 | SPY | ETF | 276.81 | 277.0 | 276.81 | 276.98 | 4043.0 |
| 2020-04-22 04:27:00 | SPY | ETF | 276.91 | 276.91 | 276.91 | 276.91 | 2500.0 |
| 2020-04-22 04:28:00 | SPY | ETF | 276.88 | 276.9 | 276.88 | 276.9 | 2292.0 |
| 2020-04-22 04:29:00 | SPY | ETF | 276.7 | 276.7 | 276.7 | 276.7 | 195.0 |
| 2020-04-22 04:31:00 | SPY | ETF | 276.69 | 276.69 | 276.68 | 276.68 | 434.0 |
| 2020-04-22 04:32:00 | SPY | ETF | 276.69 | 276.69 | 276.69 | 276.69 | 100.0 |
| 2020-04-22 04:33:00 | SPY | ETF | 276.76 | 276.76 | 276.69 | 276.69 | 2088.0 |
| 2020-04-22 04:35:00 | SPY | ETF | 276.86 | 276.86 | 276.86 | 276.86 | 290.0 |
| 2020-04-22 04:36:00 | SPY | ETF | 276.99 | 276.99 | 276.99 | 276.99 | 15380.0 |
| 2020-04-22 04:37:00 | SPY | ETF | 277.1 | 277.1 | 277.1 | 277.1 | 156.0 |
| 2020-04-22 04:39:00 | SPY | ETF | 277.1 | 277.1 | 277.05 | 277.05 | 10344.0 |
| 2020-04-22 04:40:00 | SPY | ETF | 277.09 | 277.28 | 277.04 | 277.19 | 26258.0 |
| 2020-04-22 04:41:00 | SPY | ETF | 277.0 | 277.0 | 277.0 | 277.0 | 270.0 |
| 2020-04-22 04:42:00 | SPY | ETF | 277.03 | 277.03 | 277.03 | 277.03 | 111.0 |
| 2020-04-22 04:44:00 | SPY | ETF | 277.0 | 277.03 | 277.0 | 277.03 | 284.0 |
| 2020-04-22 04:45:00 | SPY | ETF | 277.0 | 277.0 | 277.0 | 277.0 | 10129.0 |
| 2020-04-22 04:46:00 | SPY | ETF | 276.95 | 276.95 | 276.95 | 276.95 | 220.0 |
| 2020-04-22 04:47:00 | SPY | ETF | 277.0 | 277.0 | 276.96 | 277.0 | 10350.0 |
| 2020-04-22 04:48:00 | SPY | ETF | 276.86 | 276.86 | 276.76 | 276.79 | 360.0 |
| 2020-04-22 04:49:00 | SPY | ETF | 276.86 | 276.86 | 276.86 | 276.86 | 150.0 |
| 2020-04-22 04:51:00 | SPY | ETF | 276.86 | 277.0 | 276.86 | 276.98 | 1500.0 |
| 2020-04-22 04:53:00 | SPY | ETF | 277.01 | 277.01 | 276.99 | 276.99 | 30010.0 |
| 2020-04-22 04:54:00 | SPY | ETF | 277.19 | 277.24 | 277.19 | 277.24 | 1400.0 |
| 2020-04-22 04:55:00 | SPY | ETF | 277.47 | 277.5 | 277.47 | 277.5 | 1236.0 |
| 2020-04-22 04:56:00 | SPY | ETF | 277.45 | 277.45 | 277.38 | 277.44 | 545.0 |
| 2020-04-22 04:57:00 | SPY | ETF | 277.47 | 277.5 | 277.47 | 277.49 | 820.0 |
> showing 50 of 207,008 rows — these rows as CSV