PREVIEW / etf_5min / 2014-04-21

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-04-21.parquet
  size:    963 KB
  rows:    41,426

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-04-21 05:05:00	SPY	ETF	186.58	186.58	186.58	186.58	2980.0
2014-04-21 05:35:00	SPY	ETF	186.54	186.54	186.54	186.54	400.0
2014-04-21 06:10:00	SPY	ETF	186.53	186.53	186.49	186.49	300.0
2014-04-21 06:20:00	SPY	ETF	186.49	186.49	186.49	186.49	400.0
2014-04-21 06:25:00	SPY	ETF	186.53	186.53	186.53	186.53	800.0
2014-04-21 06:35:00	SPY	ETF	186.54	186.55	186.54	186.55	700.0
2014-04-21 06:40:00	SPY	ETF	186.58	186.59	186.58	186.59	900.0
2014-04-21 06:45:00	SPY	ETF	186.61	186.61	186.61	186.61	400.0
2014-04-21 06:55:00	SPY	ETF	186.59	186.59	186.59	186.59	100.0
2014-04-21 07:00:00	SPY	ETF	186.61	186.61	186.61	186.61	3101.0
2014-04-21 07:05:00	SPY	ETF	186.61	186.61	186.58	186.58	17000.0
2014-04-21 07:10:00	SPY	ETF	186.61	186.65	186.61	186.65	5300.0
2014-04-21 07:15:00	SPY	ETF	186.64	186.64	186.64	186.64	11000.0
2014-04-21 07:20:00	SPY	ETF	186.62	186.62	186.62	186.62	600.0
2014-04-21 07:25:00	SPY	ETF	186.65	186.65	186.61	186.65	11100.0
2014-04-21 07:30:00	SPY	ETF	186.62	186.66	186.62	186.66	1800.0
2014-04-21 07:40:00	SPY	ETF	186.65	186.67	186.64	186.67	1900.0
2014-04-21 07:45:00	SPY	ETF	186.65	186.69	186.65	186.69	5200.0
2014-04-21 07:50:00	SPY	ETF	186.69	186.69	186.64	186.64	2900.0
2014-04-21 07:55:00	SPY	ETF	186.64	186.67	186.55	186.58	13378.0
2014-04-21 08:00:00	SPY	ETF	186.58	186.67	186.56	186.57	19597.0
2014-04-21 08:05:00	SPY	ETF	186.57	186.6	186.54	186.6	57684.0
2014-04-21 08:10:00	SPY	ETF	186.57	186.59	186.56	186.57	15284.0
2014-04-21 08:15:00	SPY	ETF	186.56	186.59	186.51	186.53	201126.0
2014-04-21 08:20:00	SPY	ETF	186.53	186.53	186.43	186.45	27766.0
2014-04-21 08:25:00	SPY	ETF	186.45	186.46	186.39	186.4	47494.0
2014-04-21 08:30:00	SPY	ETF	186.42	186.46	186.4	186.4	19968.0
2014-04-21 08:35:00	SPY	ETF	186.4	186.41	186.4	186.4	1450.0
2014-04-21 08:40:00	SPY	ETF	186.39	186.46	186.38	186.38	8510.0
2014-04-21 08:45:00	SPY	ETF	186.38	186.4	186.31	186.34	43970.0
2014-04-21 08:50:00	SPY	ETF	186.32	186.36	186.3	186.36	283191.0
2014-04-21 08:55:00	SPY	ETF	186.36	186.44	186.36	186.44	20484.0
2014-04-21 09:00:00	SPY	ETF	186.44	186.44	186.42	186.42	15570.0
2014-04-21 09:05:00	SPY	ETF	186.42	186.5	186.42	186.5	34869.0
2014-04-21 09:10:00	SPY	ETF	186.5	186.51	186.47	186.49	57530.0
2014-04-21 09:15:00	SPY	ETF	186.49	186.49	186.46	186.47	38353.0
2014-04-21 09:20:00	SPY	ETF	186.49	186.49	186.46	186.47	20883.0
2014-04-21 09:25:00	SPY	ETF	186.47	186.51	186.43	186.44	231303.0
2014-04-21 09:30:00	SPY	ETF	186.44	186.525	186.34	186.525	1713875.0
2014-04-21 09:35:00	SPY	ETF	186.53	186.7	186.45	186.49	1566889.0
2014-04-21 09:40:00	SPY	ETF	186.48	186.81	186.47	186.71	1501092.0
2014-04-21 09:45:00	SPY	ETF	186.72	186.8	186.62	186.7	898244.0
2014-04-21 09:50:00	SPY	ETF	186.7	186.84	186.645	186.66	1033471.0
2014-04-21 09:55:00	SPY	ETF	186.6515	186.81	186.6515	186.77	597677.0
2014-04-21 10:00:00	SPY	ETF	186.77	186.97	186.76	186.94	1447621.0
2014-04-21 10:05:00	SPY	ETF	186.94	187.0	186.83	186.91	1427845.0
2014-04-21 10:10:00	SPY	ETF	186.915	186.96	186.77	186.78	729022.0
2014-04-21 10:15:00	SPY	ETF	186.78	186.879	186.5259	186.71	813667.0
2014-04-21 10:20:00	SPY	ETF	186.71	186.75	186.64	186.68	969087.0
2014-04-21 10:25:00	SPY	ETF	186.68	186.76	186.6	186.65	605885.0

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

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