PREVIEW / etf_1min / 2019-05-15
file: by_date/etf_1min/2019/2019-05-15.parquet size: 3.1 MB rows: 163,133
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-15 04:00:00 | SPY | ETF | 283.41 | 283.41 | 283.36 | 283.36 | 511.0 |
| 2019-05-15 04:02:00 | SPY | ETF | 283.56 | 283.56 | 283.56 | 283.56 | 278.0 |
| 2019-05-15 04:04:00 | SPY | ETF | 283.45 | 283.45 | 283.45 | 283.45 | 476.0 |
| 2019-05-15 04:05:00 | SPY | ETF | 283.32 | 283.32 | 283.32 | 283.32 | 105.0 |
| 2019-05-15 04:08:00 | SPY | ETF | 283.3 | 283.3 | 283.27 | 283.27 | 1107.0 |
| 2019-05-15 04:09:00 | SPY | ETF | 283.21 | 283.21 | 283.21 | 283.21 | 200.0 |
| 2019-05-15 04:11:00 | SPY | ETF | 283.37 | 283.37 | 283.37 | 283.37 | 144.0 |
| 2019-05-15 04:13:00 | SPY | ETF | 283.42 | 283.42 | 283.42 | 283.42 | 169.0 |
| 2019-05-15 04:14:00 | SPY | ETF | 283.44 | 283.47 | 283.44 | 283.47 | 839.0 |
| 2019-05-15 04:17:00 | SPY | ETF | 283.5 | 283.5 | 283.5 | 283.5 | 169.0 |
| 2019-05-15 04:19:00 | SPY | ETF | 283.47 | 283.47 | 283.47 | 283.47 | 300.0 |
| 2019-05-15 04:22:00 | SPY | ETF | 283.49 | 283.49 | 283.49 | 283.49 | 169.0 |
| 2019-05-15 04:25:00 | SPY | ETF | 283.53 | 283.53 | 283.53 | 283.53 | 200.0 |
| 2019-05-15 04:27:00 | SPY | ETF | 283.55 | 283.55 | 283.55 | 283.55 | 342.0 |
| 2019-05-15 04:29:00 | SPY | ETF | 283.6 | 283.6 | 283.6 | 283.6 | 219.0 |
| 2019-05-15 04:39:00 | SPY | ETF | 283.62 | 283.62 | 283.62 | 283.62 | 400.0 |
| 2019-05-15 04:44:00 | SPY | ETF | 283.62 | 283.62 | 283.62 | 283.62 | 300.0 |
| 2019-05-15 04:54:00 | SPY | ETF | 283.75 | 283.75 | 283.75 | 283.75 | 300.0 |
| 2019-05-15 04:56:00 | SPY | ETF | 283.62 | 283.62 | 283.62 | 283.62 | 100.0 |
| 2019-05-15 05:11:00 | SPY | ETF | 283.7 | 283.7 | 283.7 | 283.7 | 222.0 |
| 2019-05-15 05:17:00 | SPY | ETF | 283.84 | 283.84 | 283.84 | 283.84 | 100.0 |
| 2019-05-15 05:19:00 | SPY | ETF | 283.81 | 283.81 | 283.79 | 283.79 | 2150.0 |
| 2019-05-15 05:20:00 | SPY | ETF | 283.75 | 283.75 | 283.75 | 283.75 | 100.0 |
| 2019-05-15 05:21:00 | SPY | ETF | 283.79 | 283.79 | 283.78 | 283.78 | 2000.0 |
| 2019-05-15 05:34:00 | SPY | ETF | 283.5 | 283.5 | 283.49 | 283.49 | 823.0 |
| 2019-05-15 05:35:00 | SPY | ETF | 283.42 | 283.42 | 283.42 | 283.42 | 439.0 |
| 2019-05-15 05:36:00 | SPY | ETF | 283.4 | 283.42 | 283.37 | 283.4 | 2443.0 |
| 2019-05-15 05:37:00 | SPY | ETF | 283.37 | 283.37 | 283.22 | 283.22 | 912.0 |
| 2019-05-15 05:38:00 | SPY | ETF | 283.32 | 283.32 | 283.32 | 283.32 | 169.0 |
| 2019-05-15 05:39:00 | SPY | ETF | 283.22 | 283.22 | 283.2 | 283.2 | 200.0 |
| 2019-05-15 05:40:00 | SPY | ETF | 283.2 | 283.2 | 283.19 | 283.19 | 650.0 |
| 2019-05-15 05:42:00 | SPY | ETF | 283.2 | 283.22 | 283.2 | 283.2 | 1010.0 |
| 2019-05-15 05:43:00 | SPY | ETF | 283.15 | 283.15 | 283.0 | 283.0 | 3175.0 |
| 2019-05-15 05:44:00 | SPY | ETF | 283.05 | 283.05 | 283.05 | 283.05 | 750.0 |
| 2019-05-15 05:45:00 | SPY | ETF | 283.02 | 283.05 | 283.02 | 283.04 | 1215.0 |
| 2019-05-15 05:46:00 | SPY | ETF | 283.07 | 283.07 | 283.0 | 283.0 | 400.0 |
| 2019-05-15 05:48:00 | SPY | ETF | 283.02 | 283.02 | 282.97 | 282.97 | 1360.0 |
| 2019-05-15 05:51:00 | SPY | ETF | 283.0 | 283.08 | 283.0 | 283.08 | 750.0 |
| 2019-05-15 05:52:00 | SPY | ETF | 283.02 | 283.05 | 283.02 | 283.05 | 10839.0 |
| 2019-05-15 05:53:00 | SPY | ETF | 283.02 | 283.02 | 283.02 | 283.02 | 1000.0 |
| 2019-05-15 05:55:00 | SPY | ETF | 282.9 | 282.9 | 282.9 | 282.9 | 520.0 |
| 2019-05-15 05:56:00 | SPY | ETF | 282.9 | 282.9 | 282.9 | 282.9 | 317.0 |
| 2019-05-15 05:57:00 | SPY | ETF | 282.87 | 282.87 | 282.87 | 282.87 | 1050.0 |
| 2019-05-15 05:58:00 | SPY | ETF | 282.97 | 282.97 | 282.97 | 282.97 | 300.0 |
| 2019-05-15 05:59:00 | SPY | ETF | 282.91 | 282.95 | 282.91 | 282.95 | 300.0 |
| 2019-05-15 06:00:00 | SPY | ETF | 282.92 | 282.97 | 282.92 | 282.97 | 1000.0 |
| 2019-05-15 06:03:00 | SPY | ETF | 283.09 | 283.09 | 283.09 | 283.09 | 301.0 |
| 2019-05-15 06:04:00 | SPY | ETF | 283.08 | 283.08 | 283.08 | 283.08 | 100.0 |
| 2019-05-15 06:08:00 | SPY | ETF | 283.1 | 283.12 | 283.1 | 283.12 | 420.0 |
| 2019-05-15 06:09:00 | SPY | ETF | 283.1 | 283.1 | 283.07 | 283.07 | 510.0 |
> showing 50 of 163,133 rows — these rows as CSV