PREVIEW / etf_1min / 2014-05-29

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-05-29.parquet
  size:    2.0 MB
  rows:    104,953

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-05-29 04:00:00	SPY	ETF	191.65	191.65	191.65	191.65	279.0
2014-05-29 04:03:00	SPY	ETF	191.58	191.58	191.58	191.58	190.0
2014-05-29 04:09:00	SPY	ETF	191.56	191.56	191.56	191.56	400.0
2014-05-29 04:11:00	SPY	ETF	191.6	191.6	191.59	191.59	4449.0
2014-05-29 04:20:00	SPY	ETF	191.65	191.65	191.65	191.65	110.0
2014-05-29 04:59:00	SPY	ETF	191.63	191.63	191.63	191.63	229.0
2014-05-29 05:35:00	SPY	ETF	191.5	191.58	191.5	191.58	3000.0
2014-05-29 05:36:00	SPY	ETF	191.62	191.62	191.62	191.62	400.0
2014-05-29 05:41:00	SPY	ETF	191.62	191.62	191.62	191.62	245.0
2014-05-29 06:05:00	SPY	ETF	191.63	191.63	191.63	191.63	700.0
2014-05-29 06:15:00	SPY	ETF	191.66	191.66	191.66	191.66	100.0
2014-05-29 06:19:00	SPY	ETF	191.63	191.63	191.62	191.62	286.0
2014-05-29 06:23:00	SPY	ETF	191.6	191.6	191.6	191.6	100.0
2014-05-29 06:25:00	SPY	ETF	191.58	191.58	191.58	191.58	1000.0
2014-05-29 06:28:00	SPY	ETF	191.58	191.58	191.58	191.58	200.0
2014-05-29 06:34:00	SPY	ETF	191.55	191.55	191.55	191.55	300.0
2014-05-29 06:35:00	SPY	ETF	191.54	191.54	191.54	191.54	400.0
2014-05-29 06:39:00	SPY	ETF	191.58	191.58	191.58	191.58	400.0
2014-05-29 06:40:00	SPY	ETF	191.62	191.62	191.62	191.62	500.0
2014-05-29 06:48:00	SPY	ETF	191.66	191.66	191.66	191.66	728.0
2014-05-29 06:51:00	SPY	ETF	191.65	191.65	191.65	191.65	200.0
2014-05-29 06:57:00	SPY	ETF	191.68	191.68	191.68	191.68	5950.0
2014-05-29 07:00:00	SPY	ETF	191.69	191.69	191.69	191.69	200.0
2014-05-29 07:04:00	SPY	ETF	191.65	191.65	191.65	191.65	2600.0
2014-05-29 07:07:00	SPY	ETF	191.65	191.65	191.63	191.63	1000.0
2014-05-29 07:08:00	SPY	ETF	191.62	191.63	191.62	191.63	5100.0
2014-05-29 07:09:00	SPY	ETF	191.62	191.62	191.62	191.62	500.0
2014-05-29 07:10:00	SPY	ETF	191.65	191.65	191.63	191.63	25200.0
2014-05-29 07:11:00	SPY	ETF	191.64	191.65	191.62	191.62	400.0
2014-05-29 07:12:00	SPY	ETF	191.61	191.61	191.61	191.61	100.0
2014-05-29 07:16:00	SPY	ETF	191.64	191.64	191.64	191.64	500.0
2014-05-29 07:17:00	SPY	ETF	191.62	191.62	191.62	191.62	100.0
2014-05-29 07:18:00	SPY	ETF	191.63	191.63	191.62	191.62	10100.0
2014-05-29 07:20:00	SPY	ETF	191.62	191.63	191.62	191.63	10008.0
2014-05-29 07:21:00	SPY	ETF	191.6	191.6	191.59	191.59	300.0
2014-05-29 07:22:00	SPY	ETF	191.6	191.6	191.6	191.6	361.0
2014-05-29 07:23:00	SPY	ETF	191.59	191.59	191.58	191.58	800.0
2014-05-29 07:24:00	SPY	ETF	191.58	191.58	191.58	191.58	100.0
2014-05-29 07:25:00	SPY	ETF	191.56	191.62	191.56	191.62	16201.0
2014-05-29 07:26:00	SPY	ETF	191.64	191.65	191.64	191.65	1490.0
2014-05-29 07:27:00	SPY	ETF	191.64	191.64	191.64	191.64	8810.0
2014-05-29 07:29:00	SPY	ETF	191.63	191.63	191.61	191.61	600.0
2014-05-29 07:33:00	SPY	ETF	191.61	191.61	191.61	191.61	4000.0
2014-05-29 07:35:00	SPY	ETF	191.6	191.6	191.6	191.6	500.0
2014-05-29 07:36:00	SPY	ETF	191.64	191.64	191.64	191.64	300.0
2014-05-29 07:37:00	SPY	ETF	191.64	191.64	191.64	191.64	600.0
2014-05-29 07:38:00	SPY	ETF	191.64	191.64	191.64	191.64	200.0
2014-05-29 07:39:00	SPY	ETF	191.64	191.66	191.64	191.66	16500.0
2014-05-29 07:40:00	SPY	ETF	191.68	191.68	191.68	191.68	5500.0
2014-05-29 07:41:00	SPY	ETF	191.67	191.67	191.65	191.65	3350.0

> showing 50 of 104,953 rows — these rows as CSV

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