PREVIEW / etf_1min / 2016-02-01

all etf 1-min files

  file:    by_date/etf_1min/2016/2016-02-01.parquet
  size:    2.8 MB
  rows:    149,939

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-02-01 04:00:00	SPY	ETF	193.32	193.33	193.22	193.33	1418.0
2016-02-01 04:01:00	SPY	ETF	193.22	193.22	193.22	193.22	100.0
2016-02-01 04:03:00	SPY	ETF	193.14	193.14	193.14	193.14	300.0
2016-02-01 04:04:00	SPY	ETF	193.07	193.2	193.03	193.03	2155.0
2016-02-01 04:05:00	SPY	ETF	193.07	193.07	193.0	193.0	2163.0
2016-02-01 04:06:00	SPY	ETF	192.9	193.0	192.9	193.0	320.0
2016-02-01 04:08:00	SPY	ETF	192.9	192.9	192.9	192.9	175.0
2016-02-01 04:09:00	SPY	ETF	192.9	192.9	192.9	192.9	120.0
2016-02-01 04:10:00	SPY	ETF	192.85	192.85	192.85	192.85	510.0
2016-02-01 04:11:00	SPY	ETF	192.8	192.8	192.72	192.72	810.0
2016-02-01 04:12:00	SPY	ETF	192.7	192.7	192.67	192.67	1025.0
2016-02-01 04:13:00	SPY	ETF	192.65	192.65	192.65	192.65	315.0
2016-02-01 04:15:00	SPY	ETF	192.73	192.73	192.73	192.73	320.0
2016-02-01 04:17:00	SPY	ETF	192.86	192.89	192.82	192.82	3029.0
2016-02-01 04:20:00	SPY	ETF	192.76	192.76	192.76	192.76	300.0
2016-02-01 04:21:00	SPY	ETF	192.66	192.66	192.64	192.64	410.0
2016-02-01 04:22:00	SPY	ETF	192.66	192.66	192.64	192.64	925.0
2016-02-01 04:23:00	SPY	ETF	192.75	192.76	192.75	192.76	5500.0
2016-02-01 04:24:00	SPY	ETF	192.77	192.85	192.77	192.82	2360.0
2016-02-01 04:25:00	SPY	ETF	192.86	192.86	192.86	192.86	490.0
2016-02-01 04:27:00	SPY	ETF	192.87	192.9	192.87	192.9	350.0
2016-02-01 04:28:00	SPY	ETF	192.8	192.8	192.8	192.8	100.0
2016-02-01 04:30:00	SPY	ETF	192.89	192.89	192.89	192.89	200.0
2016-02-01 04:32:00	SPY	ETF	192.96	192.96	192.96	192.96	200.0
2016-02-01 04:34:00	SPY	ETF	192.9	192.9	192.9	192.9	300.0
2016-02-01 04:35:00	SPY	ETF	192.9	192.93	192.9	192.93	600.0
2016-02-01 04:36:00	SPY	ETF	192.9	192.9	192.9	192.9	100.0
2016-02-01 04:42:00	SPY	ETF	192.76	192.76	192.75	192.75	1318.0
2016-02-01 04:43:00	SPY	ETF	192.71	192.71	192.71	192.71	1050.0
2016-02-01 04:44:00	SPY	ETF	192.7	192.7	192.69	192.69	2000.0
2016-02-01 04:45:00	SPY	ETF	192.59	192.6	192.59	192.59	1000.0
2016-02-01 04:46:00	SPY	ETF	192.66	192.69	192.66	192.69	300.0
2016-02-01 04:47:00	SPY	ETF	192.69	192.69	192.69	192.69	1100.0
2016-02-01 04:48:00	SPY	ETF	192.62	192.62	192.62	192.62	900.0
2016-02-01 04:50:00	SPY	ETF	192.66	192.66	192.66	192.66	500.0
2016-02-01 04:51:00	SPY	ETF	192.66	192.66	192.66	192.66	1003.0
2016-02-01 04:58:00	SPY	ETF	192.56	192.56	192.5	192.5	19065.0
2016-02-01 04:59:00	SPY	ETF	192.4	192.4	192.37	192.39	1798.0
2016-02-01 05:00:00	SPY	ETF	192.46	192.46	192.44	192.44	850.0
2016-02-01 05:02:00	SPY	ETF	192.5	192.52	192.5	192.52	3440.0
2016-02-01 05:06:00	SPY	ETF	192.44	192.44	192.44	192.44	1020.0
2016-02-01 05:07:00	SPY	ETF	192.43	192.43	192.43	192.43	205.0
2016-02-01 05:08:00	SPY	ETF	192.41	192.41	192.41	192.41	410.0
2016-02-01 05:10:00	SPY	ETF	192.51	192.51	192.51	192.51	200.0
2016-02-01 05:11:00	SPY	ETF	192.49	192.54	192.49	192.54	1250.0
2016-02-01 05:12:00	SPY	ETF	192.61	192.65	192.61	192.61	2150.0
2016-02-01 05:13:00	SPY	ETF	192.64	192.66	192.6	192.62	3600.0
2016-02-01 05:15:00	SPY	ETF	192.56	192.56	192.56	192.56	200.0
2016-02-01 05:16:00	SPY	ETF	192.52	192.52	192.52	192.52	100.0
2016-02-01 05:18:00	SPY	ETF	192.5	192.5	192.46	192.49	6400.0

> showing 50 of 149,939 rows — these rows as CSV

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