PREVIEW / etf_1min / 2019-05-22
file: by_date/etf_1min/2019/2019-05-22.parquet size: 2.9 MB rows: 153,714
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-22 04:00:00 | SPY | ETF | 285.73 | 285.73 | 285.69 | 285.69 | 716.0 |
| 2019-05-22 04:01:00 | SPY | ETF | 285.65 | 285.65 | 285.65 | 285.65 | 100.0 |
| 2019-05-22 04:04:00 | SPY | ETF | 285.63 | 285.63 | 285.63 | 285.63 | 100.0 |
| 2019-05-22 04:08:00 | SPY | ETF | 285.77 | 285.77 | 285.77 | 285.77 | 100.0 |
| 2019-05-22 04:13:00 | SPY | ETF | 285.79 | 285.79 | 285.77 | 285.77 | 289.0 |
| 2019-05-22 04:21:00 | SPY | ETF | 285.95 | 285.95 | 285.95 | 285.95 | 300.0 |
| 2019-05-22 04:38:00 | SPY | ETF | 286.06 | 286.06 | 286.06 | 286.06 | 200.0 |
| 2019-05-22 05:04:00 | SPY | ETF | 285.99 | 285.99 | 285.99 | 285.99 | 100.0 |
| 2019-05-22 05:22:00 | SPY | ETF | 286.31 | 286.31 | 286.31 | 286.31 | 1001.0 |
| 2019-05-22 05:29:00 | SPY | ETF | 286.37 | 286.37 | 286.37 | 286.37 | 200.0 |
| 2019-05-22 05:34:00 | SPY | ETF | 286.44 | 286.44 | 286.44 | 286.44 | 300.0 |
| 2019-05-22 05:40:00 | SPY | ETF | 286.41 | 286.41 | 286.41 | 286.41 | 100.0 |
| 2019-05-22 05:42:00 | SPY | ETF | 286.44 | 286.44 | 286.44 | 286.44 | 100.0 |
| 2019-05-22 05:45:00 | SPY | ETF | 286.37 | 286.37 | 286.36 | 286.36 | 900.0 |
| 2019-05-22 05:50:00 | SPY | ETF | 286.28 | 286.28 | 286.26 | 286.26 | 8000.0 |
| 2019-05-22 05:51:00 | SPY | ETF | 286.28 | 286.31 | 286.26 | 286.26 | 2200.0 |
| 2019-05-22 05:52:00 | SPY | ETF | 286.31 | 286.31 | 286.31 | 286.31 | 600.0 |
| 2019-05-22 06:05:00 | SPY | ETF | 286.4 | 286.4 | 286.4 | 286.4 | 1500.0 |
| 2019-05-22 06:10:00 | SPY | ETF | 286.4 | 286.4 | 286.4 | 286.4 | 200.0 |
| 2019-05-22 06:21:00 | SPY | ETF | 286.53 | 286.53 | 286.52 | 286.52 | 599.0 |
| 2019-05-22 06:25:00 | SPY | ETF | 286.46 | 286.46 | 286.46 | 286.46 | 300.0 |
| 2019-05-22 06:26:00 | SPY | ETF | 286.4 | 286.4 | 286.4 | 286.4 | 100.0 |
| 2019-05-22 06:27:00 | SPY | ETF | 286.41 | 286.41 | 286.41 | 286.41 | 100.0 |
| 2019-05-22 06:29:00 | SPY | ETF | 286.43 | 286.43 | 286.43 | 286.43 | 100.0 |
| 2019-05-22 06:37:00 | SPY | ETF | 286.31 | 286.31 | 286.31 | 286.31 | 601.0 |
| 2019-05-22 06:39:00 | SPY | ETF | 286.3 | 286.3 | 286.3 | 286.3 | 169.0 |
| 2019-05-22 06:40:00 | SPY | ETF | 286.3 | 286.3 | 286.3 | 286.3 | 169.0 |
| 2019-05-22 06:42:00 | SPY | ETF | 286.29 | 286.29 | 286.27 | 286.27 | 338.0 |
| 2019-05-22 06:45:00 | SPY | ETF | 286.27 | 286.27 | 286.16 | 286.17 | 2319.0 |
| 2019-05-22 06:46:00 | SPY | ETF | 286.13 | 286.13 | 286.11 | 286.11 | 1001.0 |
| 2019-05-22 06:48:00 | SPY | ETF | 286.17 | 286.17 | 286.17 | 286.17 | 169.0 |
| 2019-05-22 06:49:00 | SPY | ETF | 286.13 | 286.16 | 286.13 | 286.15 | 4550.0 |
| 2019-05-22 06:51:00 | SPY | ETF | 286.16 | 286.16 | 286.15 | 286.15 | 10800.0 |
| 2019-05-22 06:52:00 | SPY | ETF | 286.15 | 286.15 | 286.15 | 286.15 | 1700.0 |
| 2019-05-22 06:55:00 | SPY | ETF | 286.17 | 286.17 | 286.17 | 286.17 | 169.0 |
| 2019-05-22 06:56:00 | SPY | ETF | 286.16 | 286.16 | 286.13 | 286.13 | 5020.0 |
| 2019-05-22 06:58:00 | SPY | ETF | 286.12 | 286.12 | 286.12 | 286.12 | 169.0 |
| 2019-05-22 06:59:00 | SPY | ETF | 286.07 | 286.07 | 286.07 | 286.07 | 231.0 |
| 2019-05-22 07:00:00 | SPY | ETF | 286.13 | 286.13 | 286.13 | 286.13 | 480.0 |
| 2019-05-22 07:01:00 | SPY | ETF | 286.12 | 286.12 | 286.1 | 286.1 | 4400.0 |
| 2019-05-22 07:02:00 | SPY | ETF | 286.1 | 286.11 | 286.06 | 286.06 | 5879.0 |
| 2019-05-22 07:03:00 | SPY | ETF | 286.01 | 286.06 | 285.99 | 286.06 | 3204.0 |
| 2019-05-22 07:04:00 | SPY | ETF | 286.05 | 286.05 | 285.98 | 286.0 | 16023.0 |
| 2019-05-22 07:05:00 | SPY | ETF | 286.0 | 286.0 | 285.94 | 285.94 | 8650.0 |
| 2019-05-22 07:07:00 | SPY | ETF | 286.0 | 286.0 | 285.99 | 285.99 | 5200.0 |
| 2019-05-22 07:08:00 | SPY | ETF | 286.0 | 286.0 | 286.0 | 286.0 | 16899.0 |
| 2019-05-22 07:09:00 | SPY | ETF | 286.0 | 286.0 | 286.0 | 286.0 | 18100.0 |
| 2019-05-22 07:10:00 | SPY | ETF | 285.97 | 285.97 | 285.97 | 285.97 | 500.0 |
| 2019-05-22 07:11:00 | SPY | ETF | 285.91 | 285.91 | 285.9 | 285.9 | 520.0 |
| 2019-05-22 07:12:00 | SPY | ETF | 285.92 | 285.92 | 285.92 | 285.92 | 300.0 |
> showing 50 of 153,714 rows — these rows as CSV