PREVIEW / etf_1min / 2019-12-27

all etf 1-min files

  file:    by_date/etf_1min/2019/2019-12-27.parquet
  size:    3.0 MB
  rows:    162,566

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-12-27 04:00:00	SPY	ETF	323.61	323.61	323.61	323.61	172.0
2019-12-27 04:04:00	SPY	ETF	323.64	323.64	323.62	323.62	610.0
2019-12-27 04:06:00	SPY	ETF	323.6	323.6	323.57	323.58	1100.0
2019-12-27 04:09:00	SPY	ETF	323.55	323.55	323.55	323.55	100.0
2019-12-27 04:10:00	SPY	ETF	323.55	323.6	323.54	323.6	550.0
2019-12-27 04:12:00	SPY	ETF	323.55	323.55	323.55	323.55	150.0
2019-12-27 04:16:00	SPY	ETF	323.59	323.59	323.59	323.59	150.0
2019-12-27 04:19:00	SPY	ETF	323.59	323.59	323.59	323.59	210.0
2019-12-27 04:20:00	SPY	ETF	323.67	323.67	323.67	323.67	100.0
2019-12-27 04:29:00	SPY	ETF	323.55	323.57	323.55	323.57	1240.0
2019-12-27 04:30:00	SPY	ETF	323.62	323.62	323.62	323.62	174.0
2019-12-27 04:37:00	SPY	ETF	323.57	323.57	323.53	323.53	500.0
2019-12-27 04:44:00	SPY	ETF	323.58	323.58	323.58	323.58	200.0
2019-12-27 05:12:00	SPY	ETF	323.72	323.72	323.72	323.72	494.0
2019-12-27 05:13:00	SPY	ETF	323.72	323.72	323.72	323.72	100.0
2019-12-27 05:14:00	SPY	ETF	323.75	323.77	323.75	323.77	200.0
2019-12-27 05:16:00	SPY	ETF	323.84	323.84	323.84	323.84	170.0
2019-12-27 05:23:00	SPY	ETF	323.82	323.89	323.82	323.89	800.0
2019-12-27 05:24:00	SPY	ETF	323.82	323.82	323.81	323.81	1796.0
2019-12-27 05:32:00	SPY	ETF	323.95	324.03	323.95	324.03	446.0
2019-12-27 05:44:00	SPY	ETF	323.91	323.91	323.91	323.91	300.0
2019-12-27 05:52:00	SPY	ETF	323.96	323.96	323.89	323.96	2500.0
2019-12-27 05:58:00	SPY	ETF	323.95	323.95	323.95	323.95	400.0
2019-12-27 06:00:00	SPY	ETF	323.94	323.94	323.94	323.94	600.0
2019-12-27 06:01:00	SPY	ETF	323.98	323.98	323.98	323.98	200.0
2019-12-27 06:02:00	SPY	ETF	323.99	323.99	323.99	323.99	625.0
2019-12-27 06:03:00	SPY	ETF	324.0	324.01	324.0	324.01	223.0
2019-12-27 06:04:00	SPY	ETF	324.03	324.03	324.03	324.03	300.0
2019-12-27 06:06:00	SPY	ETF	324.03	324.03	324.03	324.03	511.0
2019-12-27 06:09:00	SPY	ETF	323.94	323.94	323.94	323.94	300.0
2019-12-27 06:10:00	SPY	ETF	323.84	323.84	323.84	323.84	980.0
2019-12-27 06:11:00	SPY	ETF	323.84	323.84	323.84	323.84	600.0
2019-12-27 06:12:00	SPY	ETF	323.92	323.92	323.92	323.92	100.0
2019-12-27 06:21:00	SPY	ETF	323.89	323.89	323.89	323.89	300.0
2019-12-27 06:22:00	SPY	ETF	323.94	323.94	323.94	323.94	100.0
2019-12-27 06:28:00	SPY	ETF	323.84	323.84	323.84	323.84	623.0
2019-12-27 06:29:00	SPY	ETF	323.87	323.87	323.87	323.87	600.0
2019-12-27 06:35:00	SPY	ETF	323.9	323.9	323.9	323.9	300.0
2019-12-27 06:37:00	SPY	ETF	323.94	323.94	323.94	323.94	200.0
2019-12-27 06:40:00	SPY	ETF	323.95	324.02	323.94	324.02	1700.0
2019-12-27 06:42:00	SPY	ETF	324.0	324.0	324.0	324.0	600.0
2019-12-27 06:50:00	SPY	ETF	323.97	323.98	323.97	323.98	1370.0
2019-12-27 06:54:00	SPY	ETF	323.95	323.95	323.95	323.95	100.0
2019-12-27 06:55:00	SPY	ETF	323.95	323.95	323.95	323.95	1900.0
2019-12-27 07:00:00	SPY	ETF	323.95	323.96	323.91	323.93	4615.0
2019-12-27 07:01:00	SPY	ETF	323.94	323.94	323.94	323.94	183.0
2019-12-27 07:02:00	SPY	ETF	323.9	323.9	323.89	323.89	952.0
2019-12-27 07:03:00	SPY	ETF	323.95	323.95	323.95	323.95	450.0
2019-12-27 07:04:00	SPY	ETF	323.94	323.99	323.94	323.99	660.0
2019-12-27 07:05:00	SPY	ETF	323.99	323.99	323.99	323.99	100.0

> showing 50 of 162,566 rows — these rows as CSV

> unlock the full archive -- $79 one-time