PREVIEW / etf_5min / 2014-08-07

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-08-07.parquet
  size:    1.0 MB
  rows:    42,717

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-08-07 04:00:00	SPY	ETF	192.27	192.43	192.27	192.43	1195.0
2014-08-07 04:05:00	SPY	ETF	192.45	192.45	192.45	192.45	500.0
2014-08-07 04:10:00	SPY	ETF	192.5	192.5	192.42	192.42	350.0
2014-08-07 04:15:00	SPY	ETF	192.38	192.4	192.38	192.4	300.0
2014-08-07 04:20:00	SPY	ETF	192.39	192.39	192.39	192.39	200.0
2014-08-07 04:25:00	SPY	ETF	192.54	192.64	192.54	192.64	516.0
2014-08-07 04:35:00	SPY	ETF	192.64	192.64	192.64	192.64	165.0
2014-08-07 04:40:00	SPY	ETF	192.62	192.65	192.62	192.65	5299.0
2014-08-07 04:55:00	SPY	ETF	192.59	192.59	192.56	192.56	10700.0
2014-08-07 05:00:00	SPY	ETF	192.63	192.63	192.63	192.63	100.0
2014-08-07 05:10:00	SPY	ETF	192.52	192.52	192.52	192.52	100.0
2014-08-07 05:15:00	SPY	ETF	192.47	192.47	192.47	192.47	100.0
2014-08-07 05:20:00	SPY	ETF	192.47	192.55	192.47	192.55	900.0
2014-08-07 05:30:00	SPY	ETF	192.38	192.41	192.38	192.39	1476.0
2014-08-07 05:35:00	SPY	ETF	192.46	192.46	192.46	192.46	230.0
2014-08-07 05:55:00	SPY	ETF	192.56	192.56	192.56	192.56	100.0
2014-08-07 06:00:00	SPY	ETF	192.57	192.57	192.57	192.57	3000.0
2014-08-07 06:10:00	SPY	ETF	192.56	192.56	192.56	192.56	100.0
2014-08-07 06:20:00	SPY	ETF	192.47	192.47	192.42	192.44	1200.0
2014-08-07 06:25:00	SPY	ETF	192.44	192.52	192.44	192.52	21200.0
2014-08-07 06:30:00	SPY	ETF	192.5	192.5	192.4	192.41	6359.0
2014-08-07 06:35:00	SPY	ETF	192.4	192.42	192.37	192.37	2245.0
2014-08-07 06:40:00	SPY	ETF	192.37	192.4	192.33	192.33	5509.0
2014-08-07 06:45:00	SPY	ETF	192.31	192.37	192.3	192.3	3527.0
2014-08-07 06:50:00	SPY	ETF	192.32	192.33	192.25	192.33	6975.0
2014-08-07 06:55:00	SPY	ETF	192.34	192.34	192.3	192.3	6600.0
2014-08-07 07:00:00	SPY	ETF	192.3	192.38	192.3	192.38	5700.0
2014-08-07 07:05:00	SPY	ETF	192.36	192.46	192.33	192.43	25130.0
2014-08-07 07:10:00	SPY	ETF	192.43	192.49	192.43	192.47	12635.0
2014-08-07 07:15:00	SPY	ETF	192.47	192.47	192.4	192.43	19316.0
2014-08-07 07:20:00	SPY	ETF	192.46	192.52	192.46	192.52	21165.0
2014-08-07 07:25:00	SPY	ETF	192.52	192.52	192.39	192.42	31200.0
2014-08-07 07:30:00	SPY	ETF	192.47	192.48	192.45	192.48	1000.0
2014-08-07 07:35:00	SPY	ETF	192.49	192.49	192.41	192.42	3000.0
2014-08-07 07:40:00	SPY	ETF	192.42	192.42	192.42	192.42	100.0
2014-08-07 07:45:00	SPY	ETF	192.42	192.47	192.33	192.33	14454.0
2014-08-07 07:50:00	SPY	ETF	192.4	192.44	192.39	192.41	2402.0
2014-08-07 07:55:00	SPY	ETF	192.41	192.43	192.33	192.43	51737.0
2014-08-07 08:00:00	SPY	ETF	192.44	192.7	192.25	192.25	103000.0
2014-08-07 08:05:00	SPY	ETF	192.67	192.8	192.66	192.8	94085.0
2014-08-07 08:10:00	SPY	ETF	192.8	192.96	192.78	192.9	165411.0
2014-08-07 08:15:00	SPY	ETF	192.91	192.98	192.86	192.98	139590.0
2014-08-07 08:20:00	SPY	ETF	192.99	193.04	192.95	192.97	180920.0
2014-08-07 08:25:00	SPY	ETF	192.94	193.0	192.93	192.96	183762.0
2014-08-07 08:30:00	SPY	ETF	192.94	193.03	192.75	192.76	347801.0
2014-08-07 08:35:00	SPY	ETF	192.74	192.85	192.71	192.75	133668.0
2014-08-07 08:40:00	SPY	ETF	192.75	192.75	192.55	192.59	246521.0
2014-08-07 08:45:00	SPY	ETF	192.6	192.69	192.58	192.65	146108.0
2014-08-07 08:50:00	SPY	ETF	192.65	192.65	192.56	192.58	68426.0
2014-08-07 08:55:00	SPY	ETF	192.57	192.59	192.43	192.59	241558.0

> showing 50 of 42,717 rows — these rows as CSV

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