PREVIEW / etf_1min / 2014-06-16

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-06-16.parquet
  size:    2.0 MB
  rows:    107,806

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-06-16 04:15:00	SPY	ETF	193.7	193.7	193.7	193.7	100.0
2014-06-16 04:25:00	SPY	ETF	193.53	193.53	193.53	193.53	435.0
2014-06-16 06:03:00	SPY	ETF	193.99	194.42	193.53	193.56	22919.0
2014-06-16 06:04:00	SPY	ETF	193.6	193.6	193.6	193.6	2000.0
2014-06-16 06:05:00	SPY	ETF	193.62	193.62	193.62	193.62	100.0
2014-06-16 06:08:00	SPY	ETF	193.63	193.63	193.63	193.63	200.0
2014-06-16 06:09:00	SPY	ETF	193.63	193.63	193.63	193.63	200.0
2014-06-16 06:11:00	SPY	ETF	193.65	193.65	193.6	193.6	600.0
2014-06-16 06:13:00	SPY	ETF	193.65	193.67	193.65	193.67	1000.0
2014-06-16 06:14:00	SPY	ETF	193.67	193.67	193.63	193.67	700.0
2014-06-16 06:17:00	SPY	ETF	193.71	193.71	193.71	193.71	350.0
2014-06-16 06:19:00	SPY	ETF	193.7	193.7	193.65	193.7	38260.0
2014-06-16 06:20:00	SPY	ETF	193.7	193.7	193.7	193.7	2149.0
2014-06-16 06:21:00	SPY	ETF	193.7	193.7	193.7	193.7	103.0
2014-06-16 06:23:00	SPY	ETF	193.68	193.68	193.67	193.67	950.0
2014-06-16 06:24:00	SPY	ETF	193.72	193.72	193.71	193.72	1000.0
2014-06-16 06:30:00	SPY	ETF	193.71	193.71	193.7	193.7	12500.0
2014-06-16 06:32:00	SPY	ETF	193.74	193.74	193.74	193.74	1000.0
2014-06-16 06:35:00	SPY	ETF	193.75	193.75	193.75	193.75	400.0
2014-06-16 06:37:00	SPY	ETF	193.78	193.78	193.78	193.78	250.0
2014-06-16 06:42:00	SPY	ETF	193.74	193.74	193.74	193.74	400.0
2014-06-16 06:43:00	SPY	ETF	193.72	193.72	193.72	193.72	100.0
2014-06-16 06:44:00	SPY	ETF	193.71	193.71	193.7	193.7	1000.0
2014-06-16 06:54:00	SPY	ETF	193.7	193.7	193.7	193.7	125.0
2014-06-16 06:55:00	SPY	ETF	193.7	193.7	193.69	193.69	2500.0
2014-06-16 06:56:00	SPY	ETF	193.68	193.72	193.65	193.67	8279.0
2014-06-16 06:59:00	SPY	ETF	193.7	193.71	193.67	193.67	4521.0
2014-06-16 07:00:00	SPY	ETF	193.71	193.71	193.71	193.71	221.0
2014-06-16 07:01:00	SPY	ETF	193.71	193.71	193.71	193.71	300.0
2014-06-16 07:02:00	SPY	ETF	193.71	193.72	193.71	193.71	818.0
2014-06-16 07:03:00	SPY	ETF	193.7	193.7	193.7	193.7	200.0
2014-06-16 07:06:00	SPY	ETF	193.74	193.74	193.74	193.74	300.0
2014-06-16 07:08:00	SPY	ETF	193.74	193.74	193.74	193.74	100.0
2014-06-16 07:09:00	SPY	ETF	193.74	193.76	193.74	193.76	5008.0
2014-06-16 07:10:00	SPY	ETF	193.76	193.76	193.76	193.76	11118.0
2014-06-16 07:11:00	SPY	ETF	193.77	193.77	193.7	193.71	8457.0
2014-06-16 07:12:00	SPY	ETF	193.7	193.7	193.65	193.65	3478.0
2014-06-16 07:16:00	SPY	ETF	193.65	193.68	193.65	193.68	300.0
2014-06-16 07:19:00	SPY	ETF	193.69	193.7	193.69	193.69	1425.0
2014-06-16 07:21:00	SPY	ETF	193.69	193.69	193.69	193.69	100.0
2014-06-16 07:22:00	SPY	ETF	193.69	193.69	193.69	193.69	2005.0
2014-06-16 07:23:00	SPY	ETF	193.68	193.68	193.67	193.67	4502.0
2014-06-16 07:24:00	SPY	ETF	193.67	193.67	193.62	193.65	8743.0
2014-06-16 07:25:00	SPY	ETF	193.67	193.7	193.67	193.67	5600.0
2014-06-16 07:26:00	SPY	ETF	193.64	193.64	193.6	193.61	20000.0
2014-06-16 07:28:00	SPY	ETF	193.62	193.62	193.62	193.62	5100.0
2014-06-16 07:30:00	SPY	ETF	193.66	193.66	193.66	193.66	100.0
2014-06-16 07:31:00	SPY	ETF	193.69	193.69	193.67	193.69	1400.0
2014-06-16 07:32:00	SPY	ETF	193.67	193.67	193.67	193.67	100.0
2014-06-16 07:34:00	SPY	ETF	193.69	193.7	193.69	193.7	19000.0

> showing 50 of 107,806 rows — these rows as CSV

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