PREVIEW / etf_1min / 2019-04-24
file: by_date/etf_1min/2019/2019-04-24.parquet size: 3.2 MB rows: 169,168
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-04-24 04:00:00 | SPY | ETF | 292.71 | 292.71 | 292.64 | 292.64 | 3265.0 |
| 2019-04-24 04:01:00 | SPY | ETF | 292.51 | 292.52 | 292.43 | 292.44 | 1995.0 |
| 2019-04-24 04:02:00 | SPY | ETF | 292.5 | 292.5 | 292.5 | 292.5 | 190.0 |
| 2019-04-24 04:10:00 | SPY | ETF | 292.5 | 292.5 | 292.45 | 292.45 | 300.0 |
| 2019-04-24 04:13:00 | SPY | ETF | 292.53 | 292.57 | 292.53 | 292.57 | 410.0 |
| 2019-04-24 04:14:00 | SPY | ETF | 292.61 | 292.62 | 292.61 | 292.62 | 2400.0 |
| 2019-04-24 04:43:00 | SPY | ETF | 292.73 | 292.73 | 292.73 | 292.73 | 300.0 |
| 2019-04-24 04:44:00 | SPY | ETF | 292.7 | 292.7 | 292.7 | 292.7 | 450.0 |
| 2019-04-24 04:58:00 | SPY | ETF | 292.72 | 292.72 | 292.72 | 292.72 | 1000.0 |
| 2019-04-24 05:00:00 | SPY | ETF | 292.7 | 292.7 | 292.7 | 292.7 | 300.0 |
| 2019-04-24 05:15:00 | SPY | ETF | 292.82 | 292.82 | 292.82 | 292.82 | 154.0 |
| 2019-04-24 05:16:00 | SPY | ETF | 292.86 | 292.86 | 292.86 | 292.86 | 179.0 |
| 2019-04-24 05:20:00 | SPY | ETF | 292.93 | 292.93 | 292.93 | 292.93 | 169.0 |
| 2019-04-24 05:21:00 | SPY | ETF | 292.95 | 292.95 | 292.95 | 292.95 | 510.0 |
| 2019-04-24 05:25:00 | SPY | ETF | 292.89 | 292.89 | 292.89 | 292.89 | 100.0 |
| 2019-04-24 05:27:00 | SPY | ETF | 292.85 | 292.85 | 292.85 | 292.85 | 200.0 |
| 2019-04-24 05:35:00 | SPY | ETF | 292.9 | 292.9 | 292.9 | 292.9 | 200.0 |
| 2019-04-24 05:45:00 | SPY | ETF | 292.93 | 292.93 | 292.93 | 292.93 | 200.0 |
| 2019-04-24 05:47:00 | SPY | ETF | 292.96 | 293.02 | 292.96 | 293.02 | 1129.0 |
| 2019-04-24 05:53:00 | SPY | ETF | 292.96 | 292.96 | 292.96 | 292.96 | 100.0 |
| 2019-04-24 05:55:00 | SPY | ETF | 292.95 | 292.95 | 292.95 | 292.95 | 2400.0 |
| 2019-04-24 06:00:00 | SPY | ETF | 293.01 | 293.02 | 293.01 | 293.02 | 619.0 |
| 2019-04-24 06:02:00 | SPY | ETF | 293.05 | 293.05 | 293.05 | 293.05 | 300.0 |
| 2019-04-24 06:08:00 | SPY | ETF | 293.03 | 293.03 | 293.03 | 293.03 | 189.0 |
| 2019-04-24 06:09:00 | SPY | ETF | 293.0 | 293.0 | 293.0 | 293.0 | 1100.0 |
| 2019-04-24 06:11:00 | SPY | ETF | 293.06 | 293.07 | 293.06 | 293.07 | 579.0 |
| 2019-04-24 06:14:00 | SPY | ETF | 293.1 | 293.1 | 293.1 | 293.1 | 2500.0 |
| 2019-04-24 06:15:00 | SPY | ETF | 293.06 | 293.06 | 293.06 | 293.06 | 170.0 |
| 2019-04-24 06:16:00 | SPY | ETF | 293.06 | 293.06 | 293.06 | 293.06 | 131.0 |
| 2019-04-24 06:21:00 | SPY | ETF | 293.0 | 293.0 | 293.0 | 293.0 | 500.0 |
| 2019-04-24 06:45:00 | SPY | ETF | 292.95 | 292.95 | 292.95 | 292.95 | 320.0 |
| 2019-04-24 06:46:00 | SPY | ETF | 292.94 | 292.94 | 292.94 | 292.94 | 230.0 |
| 2019-04-24 06:47:00 | SPY | ETF | 292.94 | 292.94 | 292.94 | 292.94 | 100.0 |
| 2019-04-24 06:48:00 | SPY | ETF | 292.97 | 292.97 | 292.97 | 292.97 | 130.0 |
| 2019-04-24 06:51:00 | SPY | ETF | 293.02 | 293.02 | 293.02 | 293.02 | 100.0 |
| 2019-04-24 06:53:00 | SPY | ETF | 292.98 | 292.98 | 292.98 | 292.98 | 1197.0 |
| 2019-04-24 07:00:00 | SPY | ETF | 292.97 | 292.97 | 292.95 | 292.95 | 3125.0 |
| 2019-04-24 07:03:00 | SPY | ETF | 293.0 | 293.03 | 293.0 | 293.03 | 4013.0 |
| 2019-04-24 07:06:00 | SPY | ETF | 293.02 | 293.02 | 293.02 | 293.02 | 3000.0 |
| 2019-04-24 07:07:00 | SPY | ETF | 293.0 | 293.01 | 293.0 | 293.01 | 15034.0 |
| 2019-04-24 07:09:00 | SPY | ETF | 293.0 | 293.0 | 293.0 | 293.0 | 200.0 |
| 2019-04-24 07:10:00 | SPY | ETF | 292.94 | 292.94 | 292.94 | 292.94 | 800.0 |
| 2019-04-24 07:11:00 | SPY | ETF | 292.94 | 292.94 | 292.94 | 292.94 | 870.0 |
| 2019-04-24 07:12:00 | SPY | ETF | 292.92 | 292.92 | 292.92 | 292.92 | 222.0 |
| 2019-04-24 07:13:00 | SPY | ETF | 292.93 | 292.93 | 292.9 | 292.9 | 250.0 |
| 2019-04-24 07:17:00 | SPY | ETF | 292.93 | 292.93 | 292.93 | 292.93 | 200.0 |
| 2019-04-24 07:21:00 | SPY | ETF | 292.93 | 292.93 | 292.93 | 292.93 | 100.0 |
| 2019-04-24 07:24:00 | SPY | ETF | 292.94 | 292.94 | 292.94 | 292.94 | 260.0 |
| 2019-04-24 07:27:00 | SPY | ETF | 292.93 | 292.93 | 292.93 | 292.93 | 5000.0 |
| 2019-04-24 07:30:00 | SPY | ETF | 292.94 | 292.94 | 292.87 | 292.87 | 6900.0 |
> showing 50 of 169,168 rows — these rows as CSV