PREVIEW / etf_5min / 2014-03-17

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-17.parquet
  size:    976 KB
  rows:    41,921

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-17 04:00:00	SPY	ETF	184.32	184.77	184.32	184.77	1825.0
2014-03-17 04:05:00	SPY	ETF	184.74	184.87	184.74	184.85	1400.0
2014-03-17 04:20:00	SPY	ETF	184.91	184.97	184.91	184.97	650.0
2014-03-17 04:25:00	SPY	ETF	185.02	185.17	185.02	185.17	5950.0
2014-03-17 04:30:00	SPY	ETF	185.2	185.25	185.2	185.25	1225.0
2014-03-17 04:35:00	SPY	ETF	185.37	185.64	185.37	185.64	26775.0
2014-03-17 04:40:00	SPY	ETF	185.64	185.68	185.64	185.64	7325.0
2014-03-17 04:45:00	SPY	ETF	185.62	185.62	185.59	185.59	2200.0
2014-03-17 04:50:00	SPY	ETF	185.57	185.58	185.57	185.58	6025.0
2014-03-17 04:55:00	SPY	ETF	185.57	185.57	185.57	185.57	400.0
2014-03-17 05:00:00	SPY	ETF	185.58	185.77	185.58	185.76	23933.0
2014-03-17 05:05:00	SPY	ETF	185.74	185.76	185.74	185.74	11900.0
2014-03-17 05:10:00	SPY	ETF	185.74	185.74	185.64	185.65	4211.0
2014-03-17 05:15:00	SPY	ETF	185.63	185.64	185.63	185.64	868.0
2014-03-17 05:20:00	SPY	ETF	185.66	185.66	185.65	185.65	8340.0
2014-03-17 05:25:00	SPY	ETF	185.59	185.64	185.59	185.64	17018.0
2014-03-17 05:30:00	SPY	ETF	185.6	185.6	185.6	185.6	200.0
2014-03-17 05:35:00	SPY	ETF	185.62	185.62	185.47	185.55	3940.0
2014-03-17 05:40:00	SPY	ETF	185.54	185.54	185.47	185.5	2515.0
2014-03-17 05:45:00	SPY	ETF	185.45	185.45	185.42	185.45	5185.0
2014-03-17 05:50:00	SPY	ETF	185.46	185.57	185.46	185.57	1200.0
2014-03-17 06:00:00	SPY	ETF	185.56	185.65	185.56	185.65	4150.0
2014-03-17 06:05:00	SPY	ETF	185.62	185.62	185.62	185.62	200.0
2014-03-17 06:10:00	SPY	ETF	185.58	185.58	185.54	185.54	2482.0
2014-03-17 06:15:00	SPY	ETF	185.55	185.55	185.47	185.47	3925.0
2014-03-17 06:20:00	SPY	ETF	185.49	185.58	185.49	185.58	1300.0
2014-03-17 06:25:00	SPY	ETF	185.61	185.66	185.61	185.66	7486.0
2014-03-17 06:30:00	SPY	ETF	185.68	185.68	185.58	185.58	11544.0
2014-03-17 06:35:00	SPY	ETF	185.6	185.67	185.59	185.67	9600.0
2014-03-17 06:40:00	SPY	ETF	185.68	185.68	185.62	185.67	2121.0
2014-03-17 06:45:00	SPY	ETF	185.62	185.62	185.58	185.58	1650.0
2014-03-17 06:50:00	SPY	ETF	185.54	185.54	185.46	185.5	6800.0
2014-03-17 06:55:00	SPY	ETF	185.48	185.48	185.45	185.46	3362.0
2014-03-17 07:00:00	SPY	ETF	185.42	185.49	185.35	185.39	69572.0
2014-03-17 07:05:00	SPY	ETF	185.4	185.44	185.4	185.44	5269.0
2014-03-17 07:10:00	SPY	ETF	185.41	185.45	185.41	185.44	45952.0
2014-03-17 07:15:00	SPY	ETF	185.45	185.46	185.41	185.45	43405.0
2014-03-17 07:20:00	SPY	ETF	185.45	185.46	185.39	185.44	14703.0
2014-03-17 07:25:00	SPY	ETF	185.38	185.41	185.36	185.37	30942.0
2014-03-17 07:30:00	SPY	ETF	185.38	185.47	185.38	185.46	7582.0
2014-03-17 07:35:00	SPY	ETF	185.48	185.54	185.47	185.53	32908.0
2014-03-17 07:40:00	SPY	ETF	185.54	185.55	185.5	185.5	18015.0
2014-03-17 07:45:00	SPY	ETF	185.5	185.52	185.47	185.47	3076.0
2014-03-17 07:50:00	SPY	ETF	185.46	185.5	185.44	185.46	36338.0
2014-03-17 07:55:00	SPY	ETF	185.47	185.49	185.44	185.47	17430.0
2014-03-17 08:00:00	SPY	ETF	184.45	185.57	184.45	185.54	111815.0
2014-03-17 08:05:00	SPY	ETF	185.54	185.54	184.38	185.5	236467.0
2014-03-17 08:10:00	SPY	ETF	185.52	185.52	185.42	185.42	106110.0
2014-03-17 08:15:00	SPY	ETF	185.41	185.42	185.28	185.36	206835.0
2014-03-17 08:20:00	SPY	ETF	185.35	185.35	185.25	185.35	75998.0

> showing 50 of 41,921 rows — these rows as CSV

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