PREVIEW / etf_5min / 2014-07-09

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-07-09.parquet
  size:    981 KB
  rows:    42,040

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-07-09 04:00:00	SPY	ETF	196.5	196.5	196.47	196.47	604.0
2014-07-09 04:05:00	SPY	ETF	196.49	196.49	196.49	196.49	250.0
2014-07-09 04:10:00	SPY	ETF	196.57	196.58	196.57	196.58	800.0
2014-07-09 04:15:00	SPY	ETF	196.58	196.59	196.58	196.59	328.0
2014-07-09 04:20:00	SPY	ETF	196.56	196.59	196.56	196.59	600.0
2014-07-09 04:25:00	SPY	ETF	196.58	196.58	196.58	196.58	138.0
2014-07-09 04:35:00	SPY	ETF	196.52	196.52	196.51	196.51	287.0
2014-07-09 04:45:00	SPY	ETF	196.48	196.48	196.48	196.48	194.0
2014-07-09 04:55:00	SPY	ETF	196.48	196.48	196.48	196.48	199.0
2014-07-09 05:00:00	SPY	ETF	196.44	196.46	196.44	196.46	226.0
2014-07-09 05:05:00	SPY	ETF	196.43	196.43	196.43	196.43	100.0
2014-07-09 05:10:00	SPY	ETF	196.48	196.51	196.48	196.49	1253.0
2014-07-09 05:15:00	SPY	ETF	196.51	196.51	196.47	196.47	228.0
2014-07-09 05:25:00	SPY	ETF	196.4	196.42	196.4	196.42	1151.0
2014-07-09 05:30:00	SPY	ETF	196.51	196.51	196.51	196.51	143.0
2014-07-09 05:35:00	SPY	ETF	196.41	196.48	196.41	196.48	600.0
2014-07-09 05:40:00	SPY	ETF	196.46	196.48	196.46	196.48	1200.0
2014-07-09 05:45:00	SPY	ETF	196.47	196.47	196.47	196.47	100.0
2014-07-09 05:50:00	SPY	ETF	196.51	196.53	196.51	196.53	700.0
2014-07-09 05:55:00	SPY	ETF	196.52	196.52	196.52	196.52	4800.0
2014-07-09 06:05:00	SPY	ETF	196.54	196.54	196.54	196.54	200.0
2014-07-09 06:10:00	SPY	ETF	196.54	196.63	196.54	196.63	4050.0
2014-07-09 06:15:00	SPY	ETF	196.64	196.64	196.59	196.59	4800.0
2014-07-09 06:20:00	SPY	ETF	196.6	196.64	196.6	196.64	3417.0
2014-07-09 06:25:00	SPY	ETF	196.64	196.66	196.64	196.64	6286.0
2014-07-09 06:30:00	SPY	ETF	196.59	196.59	196.59	196.59	228.0
2014-07-09 06:40:00	SPY	ETF	196.59	196.59	196.52	196.52	8353.0
2014-07-09 06:45:00	SPY	ETF	196.52	196.52	196.51	196.51	200.0
2014-07-09 06:50:00	SPY	ETF	196.56	196.57	196.52	196.57	1192.0
2014-07-09 07:00:00	SPY	ETF	196.57	196.59	196.56	196.59	13903.0
2014-07-09 07:05:00	SPY	ETF	196.62	196.65	196.62	196.65	35433.0
2014-07-09 07:10:00	SPY	ETF	196.66	196.66	196.61	196.66	36829.0
2014-07-09 07:15:00	SPY	ETF	196.66	196.66	196.64	196.64	39500.0
2014-07-09 07:20:00	SPY	ETF	196.62	196.64	196.59	196.59	9500.0
2014-07-09 07:25:00	SPY	ETF	196.58	196.64	196.58	196.64	23400.0
2014-07-09 07:30:00	SPY	ETF	196.6	196.66	196.6	196.66	2545.0
2014-07-09 07:35:00	SPY	ETF	196.66	196.66	196.66	196.66	1850.0
2014-07-09 07:40:00	SPY	ETF	196.66	196.74	196.66	196.71	28244.0
2014-07-09 07:45:00	SPY	ETF	196.69	196.71	196.61	196.66	64152.0
2014-07-09 07:50:00	SPY	ETF	196.63	196.69	196.63	196.69	9285.0
2014-07-09 07:55:00	SPY	ETF	196.68	196.75	196.67	196.75	16569.0
2014-07-09 08:00:00	SPY	ETF	196.74	196.87	196.66	196.86	99648.0
2014-07-09 08:05:00	SPY	ETF	196.86	196.87	196.81	196.84	59738.0
2014-07-09 08:10:00	SPY	ETF	196.86	196.87	196.8	196.81	92507.0
2014-07-09 08:15:00	SPY	ETF	196.8	196.83	196.78	196.78	8249.0
2014-07-09 08:20:00	SPY	ETF	196.78	196.82	196.78	196.81	7930.0
2014-07-09 08:25:00	SPY	ETF	196.79	196.87	196.79	196.82	16389.0
2014-07-09 08:30:00	SPY	ETF	196.81	196.82	196.74	196.74	36697.0
2014-07-09 08:35:00	SPY	ETF	196.79	196.79	196.74	196.77	28098.0
2014-07-09 08:40:00	SPY	ETF	196.78	196.79	196.71	196.76	16857.0

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

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