PREVIEW / etf_1min / 2016-01-12

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-01-12.parquet
  size:    3.0 MB
  rows:    154,000

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
2016-01-12 04:00:00	SPY	ETF	191.64	191.71	191.64	191.71	1031.0
2016-01-12 04:04:00	SPY	ETF	191.43	191.43	191.4	191.4	400.0
2016-01-12 04:07:00	SPY	ETF	191.62	191.62	191.62	191.62	1000.0
2016-01-12 04:08:00	SPY	ETF	191.57	191.6	191.52	191.6	1640.0
2016-01-12 04:09:00	SPY	ETF	191.58	191.58	191.58	191.58	500.0
2016-01-12 04:10:00	SPY	ETF	191.55	191.55	191.35	191.35	3315.0
2016-01-12 04:11:00	SPY	ETF	191.43	191.48	191.38	191.38	1210.0
2016-01-12 04:13:00	SPY	ETF	191.48	191.48	191.41	191.41	1923.0
2016-01-12 04:14:00	SPY	ETF	191.63	191.64	191.63	191.64	500.0
2016-01-12 04:15:00	SPY	ETF	191.61	191.73	191.61	191.73	332.0
2016-01-12 04:16:00	SPY	ETF	191.71	191.71	191.71	191.71	310.0
2016-01-12 04:17:00	SPY	ETF	191.83	191.83	191.83	191.83	200.0
2016-01-12 04:18:00	SPY	ETF	191.88	191.88	191.87	191.87	520.0
2016-01-12 04:19:00	SPY	ETF	191.81	191.83	191.81	191.83	1610.0
2016-01-12 04:20:00	SPY	ETF	191.88	192.02	191.88	191.95	1610.0
2016-01-12 04:21:00	SPY	ETF	191.95	191.95	191.93	191.93	700.0
2016-01-12 04:23:00	SPY	ETF	191.93	191.93	191.93	191.93	763.0
2016-01-12 04:24:00	SPY	ETF	191.94	191.94	191.9	191.9	3200.0
2016-01-12 04:25:00	SPY	ETF	191.96	191.96	191.96	191.96	500.0
2016-01-12 04:26:00	SPY	ETF	192.03	192.13	192.03	192.13	500.0
2016-01-12 04:27:00	SPY	ETF	192.17	192.33	192.17	192.31	4030.0
2016-01-12 04:28:00	SPY	ETF	192.31	192.38	192.31	192.38	300.0
2016-01-12 04:30:00	SPY	ETF	192.36	192.36	192.33	192.33	310.0
2016-01-12 04:31:00	SPY	ETF	192.32	192.35	192.32	192.33	700.0
2016-01-12 04:32:00	SPY	ETF	192.23	192.23	192.23	192.23	300.0
2016-01-12 04:33:00	SPY	ETF	192.26	192.26	192.26	192.26	4840.0
2016-01-12 04:34:00	SPY	ETF	192.25	192.25	192.25	192.25	6810.0
2016-01-12 04:36:00	SPY	ETF	192.33	192.33	192.33	192.33	100.0
2016-01-12 04:38:00	SPY	ETF	192.33	192.34	192.33	192.34	600.0
2016-01-12 04:39:00	SPY	ETF	192.23	192.23	192.13	192.13	960.0
2016-01-12 04:41:00	SPY	ETF	192.13	192.13	192.13	192.13	150.0
2016-01-12 04:42:00	SPY	ETF	192.13	192.13	192.13	192.13	500.0
2016-01-12 04:46:00	SPY	ETF	192.43	192.49	192.43	192.49	500.0
2016-01-12 04:47:00	SPY	ETF	192.43	192.48	192.43	192.48	300.0
2016-01-12 04:49:00	SPY	ETF	192.48	192.48	192.48	192.48	1446.0
2016-01-12 04:50:00	SPY	ETF	192.5	192.5	192.5	192.5	1150.0
2016-01-12 04:52:00	SPY	ETF	192.55	192.55	192.55	192.55	100.0
2016-01-12 04:53:00	SPY	ETF	192.63	192.66	192.63	192.65	1255.0
2016-01-12 04:54:00	SPY	ETF	192.62	192.62	192.62	192.62	150.0
2016-01-12 04:55:00	SPY	ETF	192.71	192.71	192.71	192.71	210.0
2016-01-12 04:56:00	SPY	ETF	192.63	192.65	192.55	192.55	900.0
2016-01-12 04:59:00	SPY	ETF	192.6	192.6	192.6	192.6	100.0
2016-01-12 05:00:00	SPY	ETF	192.65	192.68	192.65	192.68	1800.0
2016-01-12 05:01:00	SPY	ETF	192.65	192.65	192.65	192.65	250.0
2016-01-12 05:02:00	SPY	ETF	192.68	192.71	192.68	192.71	500.0
2016-01-12 05:05:00	SPY	ETF	192.76	192.76	192.71	192.71	2900.0
2016-01-12 05:07:00	SPY	ETF	192.85	192.9	192.85	192.9	766.0
2016-01-12 05:08:00	SPY	ETF	192.85	192.91	192.85	192.91	2125.0
2016-01-12 05:09:00	SPY	ETF	192.93	192.95	192.93	192.95	619.0
2016-01-12 05:10:00	SPY	ETF	192.93	192.93	192.93	192.93	1430.0

> showing 50 of 154,000 rows — these rows as CSV

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