PREVIEW / etf_1min / 2019-05-01
file: by_date/etf_1min/2019/2019-05-01.parquet size: 3.3 MB rows: 169,179
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 |
|---|---|---|---|---|---|---|---|
| 2019-05-01 04:00:00 | SPY | ETF | 295.27 | 295.27 | 295.27 | 295.27 | 400.0 |
| 2019-05-01 04:05:00 | SPY | ETF | 295.35 | 295.35 | 295.35 | 295.35 | 200.0 |
| 2019-05-01 04:11:00 | SPY | ETF | 295.33 | 295.33 | 295.33 | 295.33 | 200.0 |
| 2019-05-01 04:16:00 | SPY | ETF | 295.36 | 295.36 | 295.36 | 295.36 | 100.0 |
| 2019-05-01 04:19:00 | SPY | ETF | 295.35 | 295.38 | 295.35 | 295.38 | 400.0 |
| 2019-05-01 04:20:00 | SPY | ETF | 295.36 | 295.36 | 295.36 | 295.36 | 700.0 |
| 2019-05-01 04:21:00 | SPY | ETF | 295.34 | 295.34 | 295.34 | 295.34 | 100.0 |
| 2019-05-01 04:30:00 | SPY | ETF | 295.31 | 295.31 | 295.31 | 295.31 | 910.0 |
| 2019-05-01 04:31:00 | SPY | ETF | 295.32 | 295.32 | 295.32 | 295.32 | 300.0 |
| 2019-05-01 04:52:00 | SPY | ETF | 295.28 | 295.28 | 295.28 | 295.28 | 300.0 |
| 2019-05-01 04:57:00 | SPY | ETF | 295.22 | 295.22 | 295.22 | 295.22 | 1610.0 |
| 2019-05-01 05:10:00 | SPY | ETF | 295.21 | 295.21 | 295.21 | 295.21 | 200.0 |
| 2019-05-01 05:17:00 | SPY | ETF | 295.23 | 295.23 | 295.23 | 295.23 | 100.0 |
| 2019-05-01 05:22:00 | SPY | ETF | 295.19 | 295.19 | 295.19 | 295.19 | 300.0 |
| 2019-05-01 05:28:00 | SPY | ETF | 295.19 | 295.19 | 295.19 | 295.19 | 200.0 |
| 2019-05-01 05:40:00 | SPY | ETF | 295.14 | 295.16 | 295.14 | 295.16 | 600.0 |
| 2019-05-01 05:47:00 | SPY | ETF | 295.16 | 295.16 | 295.16 | 295.16 | 300.0 |
| 2019-05-01 05:49:00 | SPY | ETF | 295.16 | 295.16 | 295.16 | 295.16 | 115.0 |
| 2019-05-01 05:50:00 | SPY | ETF | 295.18 | 295.18 | 295.18 | 295.18 | 2050.0 |
| 2019-05-01 05:59:00 | SPY | ETF | 295.15 | 295.15 | 295.15 | 295.15 | 200.0 |
| 2019-05-01 06:04:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 108.0 |
| 2019-05-01 06:05:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 100.0 |
| 2019-05-01 06:06:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 250.0 |
| 2019-05-01 06:07:00 | SPY | ETF | 295.12 | 295.12 | 295.12 | 295.12 | 155.0 |
| 2019-05-01 06:08:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 145.0 |
| 2019-05-01 06:20:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 300.0 |
| 2019-05-01 06:22:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 100.0 |
| 2019-05-01 06:26:00 | SPY | ETF | 295.1 | 295.11 | 295.1 | 295.11 | 1069.0 |
| 2019-05-01 06:27:00 | SPY | ETF | 295.11 | 295.11 | 295.11 | 295.11 | 169.0 |
| 2019-05-01 06:30:00 | SPY | ETF | 295.12 | 295.12 | 295.12 | 295.12 | 169.0 |
| 2019-05-01 06:38:00 | SPY | ETF | 295.06 | 295.06 | 295.06 | 295.06 | 100.0 |
| 2019-05-01 06:43:00 | SPY | ETF | 295.06 | 295.06 | 295.04 | 295.04 | 398.0 |
| 2019-05-01 06:44:00 | SPY | ETF | 295.0 | 295.0 | 294.97 | 294.97 | 1463.0 |
| 2019-05-01 06:45:00 | SPY | ETF | 294.97 | 294.97 | 294.97 | 294.97 | 3731.0 |
| 2019-05-01 06:47:00 | SPY | ETF | 294.96 | 294.96 | 294.95 | 294.95 | 309.0 |
| 2019-05-01 06:56:00 | SPY | ETF | 294.95 | 294.95 | 294.95 | 294.95 | 1030.0 |
| 2019-05-01 07:00:00 | SPY | ETF | 294.93 | 294.96 | 294.93 | 294.96 | 3986.0 |
| 2019-05-01 07:01:00 | SPY | ETF | 294.97 | 294.97 | 294.95 | 294.95 | 5600.0 |
| 2019-05-01 07:02:00 | SPY | ETF | 294.95 | 294.95 | 294.93 | 294.93 | 1158.0 |
| 2019-05-01 07:03:00 | SPY | ETF | 294.92 | 294.92 | 294.85 | 294.88 | 1268.0 |
| 2019-05-01 07:06:00 | SPY | ETF | 294.93 | 294.93 | 294.93 | 294.93 | 169.0 |
| 2019-05-01 07:08:00 | SPY | ETF | 294.95 | 294.96 | 294.95 | 294.96 | 284.0 |
| 2019-05-01 07:09:00 | SPY | ETF | 294.98 | 295.0 | 294.98 | 295.0 | 1802.0 |
| 2019-05-01 07:10:00 | SPY | ETF | 295.01 | 295.06 | 295.01 | 295.06 | 676.0 |
| 2019-05-01 07:11:00 | SPY | ETF | 295.06 | 295.06 | 295.06 | 295.06 | 189.0 |
| 2019-05-01 07:14:00 | SPY | ETF | 295.09 | 295.09 | 295.09 | 295.09 | 144.0 |
| 2019-05-01 07:15:00 | SPY | ETF | 295.1 | 295.15 | 295.1 | 295.15 | 6419.0 |
| 2019-05-01 07:17:00 | SPY | ETF | 295.12 | 295.13 | 295.12 | 295.13 | 485.0 |
| 2019-05-01 07:21:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 10100.0 |
| 2019-05-01 07:22:00 | SPY | ETF | 295.13 | 295.13 | 295.13 | 295.13 | 3780.0 |
> showing 50 of 169,179 rows — these rows as CSV