PREVIEW / etf_1min / 2019-02-26
file: by_date/etf_1min/2019/2019-02-26.parquet size: 3.1 MB rows: 169,299
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-02-26 04:00:00 | SPY | ETF | 278.97 | 278.97 | 278.9 | 278.9 | 4178.0 |
| 2019-02-26 04:02:00 | SPY | ETF | 278.86 | 278.86 | 278.86 | 278.86 | 100.0 |
| 2019-02-26 04:12:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 1510.0 |
| 2019-02-26 04:18:00 | SPY | ETF | 278.73 | 278.73 | 278.73 | 278.73 | 200.0 |
| 2019-02-26 04:19:00 | SPY | ETF | 278.73 | 278.73 | 278.73 | 278.73 | 121.0 |
| 2019-02-26 04:20:00 | SPY | ETF | 278.72 | 278.72 | 278.72 | 278.72 | 6000.0 |
| 2019-02-26 04:22:00 | SPY | ETF | 278.7 | 278.7 | 278.7 | 278.7 | 475.0 |
| 2019-02-26 04:25:00 | SPY | ETF | 278.6 | 278.6 | 278.6 | 278.6 | 294.0 |
| 2019-02-26 04:26:00 | SPY | ETF | 278.56 | 278.56 | 278.5 | 278.5 | 340.0 |
| 2019-02-26 04:29:00 | SPY | ETF | 278.46 | 278.46 | 278.46 | 278.46 | 100.0 |
| 2019-02-26 04:31:00 | SPY | ETF | 278.49 | 278.49 | 278.49 | 278.49 | 1300.0 |
| 2019-02-26 04:38:00 | SPY | ETF | 278.68 | 278.68 | 278.68 | 278.68 | 300.0 |
| 2019-02-26 04:44:00 | SPY | ETF | 278.73 | 278.73 | 278.73 | 278.73 | 200.0 |
| 2019-02-26 04:58:00 | SPY | ETF | 278.96 | 278.96 | 278.96 | 278.96 | 150.0 |
| 2019-02-26 04:59:00 | SPY | ETF | 278.96 | 278.96 | 278.96 | 278.96 | 100.0 |
| 2019-02-26 05:04:00 | SPY | ETF | 279.0 | 279.0 | 279.0 | 279.0 | 140.0 |
| 2019-02-26 05:17:00 | SPY | ETF | 278.91 | 278.91 | 278.91 | 278.91 | 200.0 |
| 2019-02-26 05:25:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 400.0 |
| 2019-02-26 05:26:00 | SPY | ETF | 278.93 | 278.93 | 278.93 | 278.93 | 1266.0 |
| 2019-02-26 05:27:00 | SPY | ETF | 278.93 | 278.94 | 278.93 | 278.94 | 3700.0 |
| 2019-02-26 05:35:00 | SPY | ETF | 278.98 | 278.98 | 278.98 | 278.98 | 200.0 |
| 2019-02-26 05:40:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 100.0 |
| 2019-02-26 05:42:00 | SPY | ETF | 278.93 | 278.96 | 278.93 | 278.96 | 300.0 |
| 2019-02-26 05:43:00 | SPY | ETF | 278.94 | 278.94 | 278.94 | 278.94 | 100.0 |
| 2019-02-26 05:47:00 | SPY | ETF | 279.1 | 279.1 | 279.09 | 279.09 | 1800.0 |
| 2019-02-26 05:49:00 | SPY | ETF | 279.09 | 279.09 | 279.09 | 279.09 | 1200.0 |
| 2019-02-26 05:57:00 | SPY | ETF | 279.05 | 279.05 | 279.05 | 279.05 | 200.0 |
| 2019-02-26 05:58:00 | SPY | ETF | 279.08 | 279.12 | 279.07 | 279.07 | 500.0 |
| 2019-02-26 05:59:00 | SPY | ETF | 279.12 | 279.12 | 279.12 | 279.12 | 300.0 |
| 2019-02-26 06:01:00 | SPY | ETF | 279.11 | 279.12 | 279.1 | 279.11 | 1625.0 |
| 2019-02-26 06:03:00 | SPY | ETF | 279.1 | 279.1 | 279.1 | 279.1 | 500.0 |
| 2019-02-26 06:04:00 | SPY | ETF | 279.02 | 279.02 | 279.02 | 279.02 | 100.0 |
| 2019-02-26 06:06:00 | SPY | ETF | 279.01 | 279.01 | 278.94 | 278.94 | 5200.0 |
| 2019-02-26 06:09:00 | SPY | ETF | 278.95 | 278.95 | 278.94 | 278.94 | 4200.0 |
| 2019-02-26 06:11:00 | SPY | ETF | 278.99 | 278.99 | 278.99 | 278.99 | 100.0 |
| 2019-02-26 06:17:00 | SPY | ETF | 279.03 | 279.03 | 278.99 | 278.99 | 1750.0 |
| 2019-02-26 06:20:00 | SPY | ETF | 278.94 | 278.94 | 278.92 | 278.92 | 400.0 |
| 2019-02-26 06:24:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 400.0 |
| 2019-02-26 06:25:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 120.0 |
| 2019-02-26 06:26:00 | SPY | ETF | 278.9 | 278.9 | 278.9 | 278.9 | 100.0 |
| 2019-02-26 06:27:00 | SPY | ETF | 278.9 | 278.92 | 278.9 | 278.92 | 1180.0 |
| 2019-02-26 06:29:00 | SPY | ETF | 278.89 | 278.89 | 278.89 | 278.89 | 100.0 |
| 2019-02-26 06:32:00 | SPY | ETF | 278.84 | 278.84 | 278.84 | 278.84 | 100.0 |
| 2019-02-26 06:34:00 | SPY | ETF | 278.78 | 278.78 | 278.75 | 278.75 | 625.0 |
| 2019-02-26 06:35:00 | SPY | ETF | 278.7 | 278.7 | 278.7 | 278.7 | 2300.0 |
| 2019-02-26 06:36:00 | SPY | ETF | 278.77 | 278.77 | 278.77 | 278.77 | 200.0 |
| 2019-02-26 06:37:00 | SPY | ETF | 278.72 | 278.72 | 278.72 | 278.72 | 200.0 |
| 2019-02-26 06:40:00 | SPY | ETF | 278.78 | 278.78 | 278.77 | 278.77 | 5650.0 |
| 2019-02-26 06:45:00 | SPY | ETF | 278.86 | 278.86 | 278.83 | 278.83 | 600.0 |
| 2019-02-26 06:47:00 | SPY | ETF | 278.85 | 278.85 | 278.85 | 278.85 | 1000.0 |
> showing 50 of 169,299 rows — these rows as CSV