PREVIEW / etf_1min / 2019-05-16
file: by_date/etf_1min/2019/2019-05-16.parquet size: 3.1 MB rows: 161,569
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-16 04:00:00 | SPY | ETF | 284.67 | 284.71 | 284.67 | 284.71 | 320.0 |
| 2019-05-16 04:01:00 | SPY | ETF | 284.49 | 284.49 | 284.49 | 284.49 | 511.0 |
| 2019-05-16 04:02:00 | SPY | ETF | 284.57 | 284.57 | 284.57 | 284.57 | 100.0 |
| 2019-05-16 04:04:00 | SPY | ETF | 284.52 | 284.52 | 284.52 | 284.52 | 202.0 |
| 2019-05-16 04:05:00 | SPY | ETF | 284.95 | 284.95 | 284.95 | 284.95 | 123.0 |
| 2019-05-16 04:06:00 | SPY | ETF | 284.64 | 284.64 | 284.64 | 284.64 | 103.0 |
| 2019-05-16 04:07:00 | SPY | ETF | 284.7 | 284.7 | 284.7 | 284.7 | 420.0 |
| 2019-05-16 04:09:00 | SPY | ETF | 284.73 | 284.73 | 284.73 | 284.73 | 111.0 |
| 2019-05-16 04:10:00 | SPY | ETF | 284.78 | 284.79 | 284.78 | 284.79 | 205.0 |
| 2019-05-16 04:19:00 | SPY | ETF | 285.0 | 285.0 | 285.0 | 285.0 | 335.0 |
| 2019-05-16 04:26:00 | SPY | ETF | 284.92 | 284.92 | 284.92 | 284.92 | 291.0 |
| 2019-05-16 04:27:00 | SPY | ETF | 284.91 | 284.91 | 284.91 | 284.91 | 141.0 |
| 2019-05-16 04:28:00 | SPY | ETF | 284.95 | 285.04 | 284.95 | 285.04 | 1393.0 |
| 2019-05-16 04:33:00 | SPY | ETF | 284.83 | 284.85 | 284.83 | 284.85 | 1166.0 |
| 2019-05-16 04:34:00 | SPY | ETF | 284.88 | 284.88 | 284.88 | 284.88 | 300.0 |
| 2019-05-16 04:36:00 | SPY | ETF | 284.9 | 284.9 | 284.9 | 284.9 | 301.0 |
| 2019-05-16 04:38:00 | SPY | ETF | 285.16 | 285.16 | 285.16 | 285.16 | 952.0 |
| 2019-05-16 04:39:00 | SPY | ETF | 285.08 | 285.08 | 285.08 | 285.08 | 224.0 |
| 2019-05-16 04:40:00 | SPY | ETF | 285.2 | 285.23 | 285.2 | 285.23 | 894.0 |
| 2019-05-16 04:42:00 | SPY | ETF | 285.25 | 285.25 | 285.25 | 285.25 | 111.0 |
| 2019-05-16 04:59:00 | SPY | ETF | 285.25 | 285.25 | 285.23 | 285.23 | 400.0 |
| 2019-05-16 05:03:00 | SPY | ETF | 285.42 | 285.42 | 285.42 | 285.42 | 417.0 |
| 2019-05-16 05:09:00 | SPY | ETF | 285.4 | 285.4 | 285.4 | 285.4 | 501.0 |
| 2019-05-16 05:11:00 | SPY | ETF | 285.37 | 285.38 | 285.37 | 285.37 | 1821.0 |
| 2019-05-16 05:12:00 | SPY | ETF | 285.39 | 285.4 | 285.39 | 285.4 | 3362.0 |
| 2019-05-16 05:14:00 | SPY | ETF | 285.4 | 285.4 | 285.4 | 285.4 | 634.0 |
| 2019-05-16 05:24:00 | SPY | ETF | 285.2 | 285.2 | 285.2 | 285.2 | 301.0 |
| 2019-05-16 05:33:00 | SPY | ETF | 285.36 | 285.36 | 285.36 | 285.36 | 601.0 |
| 2019-05-16 05:35:00 | SPY | ETF | 285.27 | 285.27 | 285.27 | 285.27 | 100.0 |
| 2019-05-16 05:37:00 | SPY | ETF | 285.3 | 285.3 | 285.3 | 285.3 | 101.0 |
| 2019-05-16 05:40:00 | SPY | ETF | 285.37 | 285.4 | 285.35 | 285.35 | 3001.0 |
| 2019-05-16 05:41:00 | SPY | ETF | 285.35 | 285.35 | 285.35 | 285.35 | 600.0 |
| 2019-05-16 05:42:00 | SPY | ETF | 285.4 | 285.4 | 285.4 | 285.4 | 601.0 |
| 2019-05-16 05:43:00 | SPY | ETF | 285.42 | 285.42 | 285.42 | 285.42 | 100.0 |
| 2019-05-16 05:44:00 | SPY | ETF | 285.37 | 285.37 | 285.37 | 285.37 | 608.0 |
| 2019-05-16 05:47:00 | SPY | ETF | 285.49 | 285.51 | 285.49 | 285.51 | 404.0 |
| 2019-05-16 05:50:00 | SPY | ETF | 285.57 | 285.57 | 285.56 | 285.56 | 1602.0 |
| 2019-05-16 05:57:00 | SPY | ETF | 285.63 | 285.63 | 285.63 | 285.63 | 501.0 |
| 2019-05-16 06:00:00 | SPY | ETF | 285.67 | 285.67 | 285.65 | 285.67 | 3263.0 |
| 2019-05-16 06:06:00 | SPY | ETF | 285.65 | 285.65 | 285.65 | 285.65 | 531.0 |
| 2019-05-16 06:08:00 | SPY | ETF | 285.7 | 285.73 | 285.7 | 285.73 | 253.0 |
| 2019-05-16 06:09:00 | SPY | ETF | 285.76 | 286.3 | 285.76 | 286.09 | 3259.0 |
| 2019-05-16 06:10:00 | SPY | ETF | 286.08 | 286.08 | 286.08 | 286.08 | 2006.0 |
| 2019-05-16 06:11:00 | SPY | ETF | 286.22 | 286.24 | 286.22 | 286.24 | 703.0 |
| 2019-05-16 06:12:00 | SPY | ETF | 286.17 | 286.17 | 286.17 | 286.17 | 416.0 |
| 2019-05-16 06:13:00 | SPY | ETF | 286.2 | 286.2 | 286.2 | 286.2 | 565.0 |
| 2019-05-16 06:14:00 | SPY | ETF | 286.25 | 286.25 | 286.25 | 286.25 | 103.0 |
| 2019-05-16 06:15:00 | SPY | ETF | 286.28 | 286.28 | 286.28 | 286.28 | 100.0 |
| 2019-05-16 06:16:00 | SPY | ETF | 286.3 | 286.3 | 286.3 | 286.3 | 2802.0 |
| 2019-05-16 06:17:00 | SPY | ETF | 286.28 | 286.28 | 286.28 | 286.28 | 173.0 |
> showing 50 of 161,569 rows — these rows as CSV