PREVIEW / etf_1min / 2019-04-10
file: by_date/etf_1min/2019/2019-04-10.parquet size: 3.0 MB rows: 161,585
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-10 04:00:00 | SPY | ETF | 287.72 | 287.79 | 287.72 | 287.72 | 2850.0 |
| 2019-04-10 04:01:00 | SPY | ETF | 287.78 | 287.78 | 287.78 | 287.78 | 207.0 |
| 2019-04-10 04:02:00 | SPY | ETF | 287.69 | 287.69 | 287.69 | 287.69 | 200.0 |
| 2019-04-10 04:04:00 | SPY | ETF | 287.69 | 287.69 | 287.68 | 287.68 | 7560.0 |
| 2019-04-10 04:06:00 | SPY | ETF | 287.69 | 287.69 | 287.69 | 287.69 | 825.0 |
| 2019-04-10 04:07:00 | SPY | ETF | 287.72 | 287.72 | 287.72 | 287.72 | 4200.0 |
| 2019-04-10 04:09:00 | SPY | ETF | 287.71 | 287.74 | 287.7 | 287.71 | 9119.0 |
| 2019-04-10 04:10:00 | SPY | ETF | 287.72 | 287.73 | 287.72 | 287.73 | 269.0 |
| 2019-04-10 04:13:00 | SPY | ETF | 287.68 | 287.69 | 287.68 | 287.69 | 338.0 |
| 2019-04-10 04:14:00 | SPY | ETF | 287.69 | 287.74 | 287.69 | 287.74 | 876.0 |
| 2019-04-10 04:16:00 | SPY | ETF | 287.67 | 287.69 | 287.67 | 287.68 | 507.0 |
| 2019-04-10 04:18:00 | SPY | ETF | 287.68 | 287.68 | 287.65 | 287.65 | 810.0 |
| 2019-04-10 04:31:00 | SPY | ETF | 287.76 | 287.78 | 287.76 | 287.78 | 300.0 |
| 2019-04-10 04:33:00 | SPY | ETF | 287.68 | 287.68 | 287.68 | 287.68 | 600.0 |
| 2019-04-10 04:37:00 | SPY | ETF | 287.75 | 287.75 | 287.75 | 287.75 | 100.0 |
| 2019-04-10 04:50:00 | SPY | ETF | 287.66 | 287.66 | 287.66 | 287.66 | 500.0 |
| 2019-04-10 04:59:00 | SPY | ETF | 287.58 | 287.58 | 287.58 | 287.58 | 100.0 |
| 2019-04-10 05:06:00 | SPY | ETF | 287.66 | 287.66 | 287.66 | 287.66 | 500.0 |
| 2019-04-10 05:08:00 | SPY | ETF | 287.73 | 287.73 | 287.73 | 287.73 | 300.0 |
| 2019-04-10 05:13:00 | SPY | ETF | 287.65 | 287.65 | 287.65 | 287.65 | 300.0 |
| 2019-04-10 05:21:00 | SPY | ETF | 287.65 | 287.65 | 287.65 | 287.65 | 300.0 |
| 2019-04-10 05:23:00 | SPY | ETF | 287.7 | 287.7 | 287.7 | 287.7 | 300.0 |
| 2019-04-10 05:32:00 | SPY | ETF | 287.7 | 287.7 | 287.7 | 287.7 | 500.0 |
| 2019-04-10 05:40:00 | SPY | ETF | 287.67 | 287.67 | 287.67 | 287.67 | 300.0 |
| 2019-04-10 05:42:00 | SPY | ETF | 287.65 | 287.65 | 287.65 | 287.65 | 300.0 |
| 2019-04-10 05:47:00 | SPY | ETF | 287.7 | 287.7 | 287.7 | 287.7 | 300.0 |
| 2019-04-10 05:49:00 | SPY | ETF | 287.74 | 287.74 | 287.74 | 287.74 | 300.0 |
| 2019-04-10 05:57:00 | SPY | ETF | 287.74 | 287.74 | 287.74 | 287.74 | 450.0 |
| 2019-04-10 06:00:00 | SPY | ETF | 287.8 | 287.8 | 287.8 | 287.8 | 1000.0 |
| 2019-04-10 06:05:00 | SPY | ETF | 287.74 | 287.74 | 287.74 | 287.74 | 300.0 |
| 2019-04-10 06:06:00 | SPY | ETF | 287.74 | 287.74 | 287.74 | 287.74 | 500.0 |
| 2019-04-10 06:11:00 | SPY | ETF | 287.79 | 287.79 | 287.79 | 287.79 | 200.0 |
| 2019-04-10 06:14:00 | SPY | ETF | 287.79 | 287.79 | 287.79 | 287.79 | 250.0 |
| 2019-04-10 06:20:00 | SPY | ETF | 287.78 | 287.78 | 287.78 | 287.78 | 300.0 |
| 2019-04-10 06:27:00 | SPY | ETF | 287.79 | 287.83 | 287.79 | 287.83 | 400.0 |
| 2019-04-10 06:31:00 | SPY | ETF | 287.74 | 287.74 | 287.74 | 287.74 | 1000.0 |
| 2019-04-10 06:36:00 | SPY | ETF | 287.76 | 287.76 | 287.76 | 287.76 | 500.0 |
| 2019-04-10 06:37:00 | SPY | ETF | 287.78 | 287.78 | 287.78 | 287.78 | 1500.0 |
| 2019-04-10 06:40:00 | SPY | ETF | 287.83 | 287.83 | 287.83 | 287.83 | 250.0 |
| 2019-04-10 06:43:00 | SPY | ETF | 287.83 | 287.84 | 287.83 | 287.83 | 8630.0 |
| 2019-04-10 06:44:00 | SPY | ETF | 287.83 | 287.85 | 287.83 | 287.85 | 16170.0 |
| 2019-04-10 06:45:00 | SPY | ETF | 287.85 | 287.85 | 287.85 | 287.85 | 1500.0 |
| 2019-04-10 06:46:00 | SPY | ETF | 287.86 | 287.86 | 287.85 | 287.85 | 600.0 |
| 2019-04-10 06:47:00 | SPY | ETF | 287.85 | 288.01 | 287.85 | 288.01 | 7835.0 |
| 2019-04-10 06:48:00 | SPY | ETF | 287.97 | 287.97 | 287.97 | 287.97 | 300.0 |
| 2019-04-10 06:49:00 | SPY | ETF | 287.99 | 288.0 | 287.99 | 288.0 | 400.0 |
| 2019-04-10 06:50:00 | SPY | ETF | 287.95 | 287.95 | 287.95 | 287.95 | 231.0 |
| 2019-04-10 06:51:00 | SPY | ETF | 287.99 | 287.99 | 287.98 | 287.98 | 1100.0 |
| 2019-04-10 06:52:00 | SPY | ETF | 287.99 | 288.02 | 287.99 | 288.02 | 305.0 |
| 2019-04-10 06:53:00 | SPY | ETF | 288.06 | 288.06 | 288.06 | 288.06 | 415.0 |
> showing 50 of 161,585 rows — these rows as CSV