PREVIEW / etf_1min / 2014-03-24

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-03-24.parquet
  size:    2.3 MB
  rows:    119,820

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
2014-03-24 04:00:00	SPY	ETF	186.47	186.77	186.47	186.77	200.0
2014-03-24 04:01:00	SPY	ETF	186.79	186.79	186.79	186.79	2100.0
2014-03-24 04:02:00	SPY	ETF	186.8	186.84	186.8	186.84	10600.0
2014-03-24 04:04:00	SPY	ETF	186.85	186.87	186.85	186.87	500.0
2014-03-24 04:06:00	SPY	ETF	186.92	186.92	186.92	186.92	300.0
2014-03-24 04:07:00	SPY	ETF	186.88	186.88	186.88	186.88	300.0
2014-03-24 04:08:00	SPY	ETF	186.82	186.82	186.82	186.82	500.0
2014-03-24 04:10:00	SPY	ETF	186.84	186.84	186.84	186.84	2000.0
2014-03-24 04:14:00	SPY	ETF	186.79	186.79	186.79	186.79	400.0
2014-03-24 04:16:00	SPY	ETF	186.69	186.69	186.69	186.69	2000.0
2014-03-24 04:19:00	SPY	ETF	186.64	186.64	186.64	186.64	500.0
2014-03-24 04:25:00	SPY	ETF	186.74	186.74	186.74	186.74	3900.0
2014-03-24 04:30:00	SPY	ETF	186.72	186.72	186.72	186.72	21000.0
2014-03-24 04:34:00	SPY	ETF	186.61	186.61	186.61	186.61	100.0
2014-03-24 04:45:00	SPY	ETF	186.61	186.61	186.61	186.61	1650.0
2014-03-24 04:46:00	SPY	ETF	186.64	186.68	186.54	186.58	2000.0
2014-03-24 04:48:00	SPY	ETF	186.62	186.68	186.62	186.66	900.0
2014-03-24 04:50:00	SPY	ETF	186.7	186.7	186.7	186.7	400.0
2014-03-24 04:59:00	SPY	ETF	186.69	186.69	186.69	186.69	1000.0
2014-03-24 05:03:00	SPY	ETF	186.66	186.66	186.66	186.66	400.0
2014-03-24 05:04:00	SPY	ETF	186.62	186.62	186.62	186.62	400.0
2014-03-24 05:07:00	SPY	ETF	186.61	186.61	186.61	186.61	100.0
2014-03-24 05:09:00	SPY	ETF	186.61	186.61	186.58	186.58	1600.0
2014-03-24 05:14:00	SPY	ETF	186.62	186.62	186.62	186.62	400.0
2014-03-24 05:18:00	SPY	ETF	186.58	186.58	186.5	186.5	1800.0
2014-03-24 05:19:00	SPY	ETF	186.5	186.52	186.42	186.46	3163.0
2014-03-24 05:20:00	SPY	ETF	186.5	186.5	186.5	186.5	400.0
2014-03-24 05:21:00	SPY	ETF	186.53	186.56	186.53	186.56	301.0
2014-03-24 05:26:00	SPY	ETF	186.46	186.5	186.46	186.5	400.0
2014-03-24 05:35:00	SPY	ETF	186.5	186.5	186.5	186.5	100.0
2014-03-24 05:37:00	SPY	ETF	186.54	186.54	186.54	186.54	400.0
2014-03-24 05:40:00	SPY	ETF	186.51	186.51	186.51	186.51	100.0
2014-03-24 05:43:00	SPY	ETF	186.5	186.5	186.49	186.49	3400.0
2014-03-24 05:44:00	SPY	ETF	186.47	186.47	186.45	186.45	6600.0
2014-03-24 05:46:00	SPY	ETF	186.5	186.5	186.5	186.5	400.0
2014-03-24 05:48:00	SPY	ETF	186.54	186.54	186.54	186.54	400.0
2014-03-24 05:49:00	SPY	ETF	186.58	186.58	186.58	186.58	537.0
2014-03-24 05:50:00	SPY	ETF	186.57	186.57	186.57	186.57	700.0
2014-03-24 05:52:00	SPY	ETF	186.54	186.54	186.54	186.54	400.0
2014-03-24 05:53:00	SPY	ETF	186.58	186.59	186.58	186.59	500.0
2014-03-24 05:55:00	SPY	ETF	186.59	186.59	186.59	186.59	700.0
2014-03-24 05:57:00	SPY	ETF	186.58	186.58	186.58	186.58	838.0
2014-03-24 06:01:00	SPY	ETF	186.57	186.57	186.57	186.57	200.0
2014-03-24 06:07:00	SPY	ETF	186.56	186.56	186.54	186.54	1180.0
2014-03-24 06:08:00	SPY	ETF	186.55	186.55	186.55	186.55	800.0
2014-03-24 06:09:00	SPY	ETF	186.56	186.56	186.56	186.56	205.0
2014-03-24 06:11:00	SPY	ETF	186.56	186.56	186.56	186.56	295.0
2014-03-24 06:12:00	SPY	ETF	186.58	186.58	186.58	186.58	5400.0
2014-03-24 06:13:00	SPY	ETF	186.6	186.61	186.6	186.61	11200.0
2014-03-24 06:14:00	SPY	ETF	186.6	186.62	186.6	186.62	1700.0

> showing 50 of 119,820 rows — these rows as CSV

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