PREVIEW / etf_1min / 2019-05-30
file: by_date/etf_1min/2019/2019-05-30.parquet size: 3.0 MB rows: 160,254
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-30 04:00:00 | SPY | ETF | 279.21 | 279.21 | 279.21 | 279.21 | 340.0 |
| 2019-05-30 04:07:00 | SPY | ETF | 279.02 | 279.06 | 279.02 | 279.06 | 200.0 |
| 2019-05-30 04:08:00 | SPY | ETF | 279.06 | 279.06 | 279.06 | 279.06 | 200.0 |
| 2019-05-30 04:18:00 | SPY | ETF | 278.97 | 278.97 | 278.97 | 278.97 | 400.0 |
| 2019-05-30 04:25:00 | SPY | ETF | 278.99 | 278.99 | 278.99 | 278.99 | 100.0 |
| 2019-05-30 04:30:00 | SPY | ETF | 279.19 | 279.2 | 279.19 | 279.2 | 6979.0 |
| 2019-05-30 04:31:00 | SPY | ETF | 279.18 | 279.18 | 279.18 | 279.18 | 100.0 |
| 2019-05-30 04:32:00 | SPY | ETF | 279.2 | 279.2 | 279.2 | 279.2 | 1500.0 |
| 2019-05-30 04:58:00 | SPY | ETF | 279.04 | 279.04 | 279.04 | 279.04 | 109.0 |
| 2019-05-30 04:59:00 | SPY | ETF | 279.04 | 279.04 | 279.04 | 279.04 | 200.0 |
| 2019-05-30 05:03:00 | SPY | ETF | 279.14 | 279.21 | 279.14 | 279.2 | 12754.0 |
| 2019-05-30 05:04:00 | SPY | ETF | 279.2 | 279.2 | 279.2 | 279.2 | 671.0 |
| 2019-05-30 05:06:00 | SPY | ETF | 279.28 | 279.28 | 279.28 | 279.28 | 101.0 |
| 2019-05-30 05:22:00 | SPY | ETF | 279.15 | 279.15 | 279.15 | 279.15 | 300.0 |
| 2019-05-30 05:26:00 | SPY | ETF | 279.18 | 279.18 | 279.18 | 279.18 | 100.0 |
| 2019-05-30 05:27:00 | SPY | ETF | 279.18 | 279.18 | 279.18 | 279.18 | 400.0 |
| 2019-05-30 05:29:00 | SPY | ETF | 279.19 | 279.19 | 279.19 | 279.19 | 100.0 |
| 2019-05-30 05:32:00 | SPY | ETF | 279.16 | 279.16 | 279.16 | 279.16 | 300.0 |
| 2019-05-30 05:33:00 | SPY | ETF | 279.13 | 279.13 | 279.13 | 279.13 | 100.0 |
| 2019-05-30 05:36:00 | SPY | ETF | 279.17 | 279.2 | 279.17 | 279.2 | 1869.0 |
| 2019-05-30 05:37:00 | SPY | ETF | 279.18 | 279.18 | 279.18 | 279.18 | 10000.0 |
| 2019-05-30 05:39:00 | SPY | ETF | 279.2 | 279.2 | 279.2 | 279.2 | 610.0 |
| 2019-05-30 05:40:00 | SPY | ETF | 279.2 | 279.2 | 279.2 | 279.2 | 300.0 |
| 2019-05-30 05:41:00 | SPY | ETF | 279.22 | 279.24 | 279.22 | 279.24 | 4720.0 |
| 2019-05-30 05:43:00 | SPY | ETF | 279.16 | 279.16 | 279.16 | 279.16 | 100.0 |
| 2019-05-30 05:45:00 | SPY | ETF | 279.19 | 279.19 | 279.19 | 279.19 | 100.0 |
| 2019-05-30 05:46:00 | SPY | ETF | 279.19 | 279.19 | 279.19 | 279.19 | 100.0 |
| 2019-05-30 05:56:00 | SPY | ETF | 279.25 | 279.25 | 279.25 | 279.25 | 300.0 |
| 2019-05-30 05:59:00 | SPY | ETF | 279.25 | 279.26 | 279.25 | 279.26 | 2660.0 |
| 2019-05-30 06:00:00 | SPY | ETF | 279.29 | 279.29 | 279.29 | 279.29 | 600.0 |
| 2019-05-30 06:02:00 | SPY | ETF | 279.28 | 279.28 | 279.28 | 279.28 | 600.0 |
| 2019-05-30 06:03:00 | SPY | ETF | 279.35 | 279.35 | 279.35 | 279.35 | 200.0 |
| 2019-05-30 06:04:00 | SPY | ETF | 279.35 | 279.35 | 279.31 | 279.31 | 1200.0 |
| 2019-05-30 06:06:00 | SPY | ETF | 279.27 | 279.27 | 279.27 | 279.27 | 109.0 |
| 2019-05-30 06:14:00 | SPY | ETF | 279.17 | 279.17 | 279.17 | 279.17 | 110.0 |
| 2019-05-30 06:15:00 | SPY | ETF | 279.17 | 279.17 | 279.17 | 279.17 | 2000.0 |
| 2019-05-30 06:23:00 | SPY | ETF | 279.34 | 279.37 | 279.33 | 279.37 | 6000.0 |
| 2019-05-30 06:26:00 | SPY | ETF | 279.29 | 279.29 | 279.29 | 279.29 | 130.0 |
| 2019-05-30 06:27:00 | SPY | ETF | 279.26 | 279.26 | 279.23 | 279.23 | 5000.0 |
| 2019-05-30 06:28:00 | SPY | ETF | 279.24 | 279.24 | 279.24 | 279.24 | 100.0 |
| 2019-05-30 06:30:00 | SPY | ETF | 279.26 | 279.26 | 279.26 | 279.26 | 600.0 |
| 2019-05-30 06:34:00 | SPY | ETF | 279.3 | 279.31 | 279.3 | 279.3 | 6500.0 |
| 2019-05-30 06:36:00 | SPY | ETF | 279.31 | 279.31 | 279.31 | 279.31 | 200.0 |
| 2019-05-30 06:38:00 | SPY | ETF | 279.22 | 279.22 | 279.22 | 279.22 | 1000.0 |
| 2019-05-30 06:39:00 | SPY | ETF | 279.21 | 279.21 | 279.2 | 279.2 | 10000.0 |
| 2019-05-30 06:40:00 | SPY | ETF | 279.12 | 279.12 | 279.12 | 279.12 | 300.0 |
| 2019-05-30 06:41:00 | SPY | ETF | 279.07 | 279.07 | 279.05 | 279.05 | 553.0 |
| 2019-05-30 06:42:00 | SPY | ETF | 279.06 | 279.12 | 279.06 | 279.11 | 8800.0 |
| 2019-05-30 06:43:00 | SPY | ETF | 279.11 | 279.14 | 279.06 | 279.14 | 4705.0 |
| 2019-05-30 06:44:00 | SPY | ETF | 279.14 | 279.14 | 279.14 | 279.14 | 995.0 |
> showing 50 of 160,254 rows — these rows as CSV