PREVIEW / etf_5min / 2014-09-25

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-09-25.parquet
  size:    1.1 MB
  rows:    46,306

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-09-25 04:05:00	SPY	ETF	199.43	199.43	199.43	199.43	236.0
2014-09-25 04:15:00	SPY	ETF	199.41	199.41	199.41	199.41	131.0
2014-09-25 04:40:00	SPY	ETF	199.55	199.55	199.55	199.55	1000.0
2014-09-25 04:45:00	SPY	ETF	199.53	199.56	199.51	199.51	3082.0
2014-09-25 04:55:00	SPY	ETF	199.43	199.45	199.37	199.37	814.0
2014-09-25 05:05:00	SPY	ETF	199.42	199.42	199.42	199.42	199.0
2014-09-25 05:10:00	SPY	ETF	199.43	199.43	199.43	199.43	20100.0
2014-09-25 05:15:00	SPY	ETF	199.39	199.39	199.39	199.39	149.0
2014-09-25 05:25:00	SPY	ETF	199.37	199.37	199.37	199.37	100.0
2014-09-25 05:35:00	SPY	ETF	199.42	199.42	199.42	199.42	500.0
2014-09-25 05:40:00	SPY	ETF	199.43	199.44	199.43	199.44	22500.0
2014-09-25 05:50:00	SPY	ETF	199.4	199.4	199.4	199.4	172.0
2014-09-25 06:00:00	SPY	ETF	199.38	199.38	199.38	199.38	150.0
2014-09-25 06:10:00	SPY	ETF	199.4	199.4	199.34	199.35	10295.0
2014-09-25 06:15:00	SPY	ETF	199.31	199.38	199.31	199.38	634.0
2014-09-25 06:20:00	SPY	ETF	199.33	199.33	199.33	199.33	180.0
2014-09-25 06:30:00	SPY	ETF	199.37	199.39	199.37	199.39	5089.0
2014-09-25 06:35:00	SPY	ETF	199.48	199.48	199.48	199.48	3000.0
2014-09-25 06:40:00	SPY	ETF	199.45	199.52	199.45	199.52	2725.0
2014-09-25 06:45:00	SPY	ETF	199.52	199.52	199.52	199.52	3000.0
2014-09-25 06:50:00	SPY	ETF	199.5	199.5	199.5	199.5	122.0
2014-09-25 06:55:00	SPY	ETF	199.52	199.52	199.49	199.49	384.0
2014-09-25 07:00:00	SPY	ETF	199.48	199.49	199.48	199.49	2100.0
2014-09-25 07:05:00	SPY	ETF	199.48	199.48	199.46	199.46	1290.0
2014-09-25 07:10:00	SPY	ETF	199.45	199.46	199.44	199.46	1326.0
2014-09-25 07:15:00	SPY	ETF	199.46	199.47	199.46	199.47	727.0
2014-09-25 07:20:00	SPY	ETF	199.47	199.47	199.46	199.47	2141.0
2014-09-25 07:25:00	SPY	ETF	199.49	199.5	199.49	199.5	730.0
2014-09-25 07:30:00	SPY	ETF	199.46	199.47	199.45	199.45	1620.0
2014-09-25 07:35:00	SPY	ETF	199.45	199.48	199.45	199.47	16000.0
2014-09-25 07:40:00	SPY	ETF	199.51	199.55	199.51	199.55	19750.0
2014-09-25 07:45:00	SPY	ETF	199.54	199.6	199.54	199.56	29006.0
2014-09-25 07:50:00	SPY	ETF	199.53	199.53	199.51	199.52	9819.0
2014-09-25 07:55:00	SPY	ETF	199.54	199.54	199.47	199.49	26047.0
2014-09-25 08:00:00	SPY	ETF	199.49	199.49	199.27	199.28	148933.0
2014-09-25 08:05:00	SPY	ETF	199.27	199.29	199.21	199.24	28265.0
2014-09-25 08:10:00	SPY	ETF	199.22	199.22	199.12	199.19	53592.0
2014-09-25 08:15:00	SPY	ETF	199.21	199.27	199.21	199.25	11245.0
2014-09-25 08:20:00	SPY	ETF	199.23	199.23	199.17	199.19	69470.0
2014-09-25 08:25:00	SPY	ETF	199.19	199.2	199.15	199.2	25474.0
2014-09-25 08:30:00	SPY	ETF	199.18	199.27	199.18	199.24	24423.0
2014-09-25 08:35:00	SPY	ETF	199.27	199.29	199.26	199.29	15751.0
2014-09-25 08:40:00	SPY	ETF	199.29	199.29	199.07	199.1	73056.0
2014-09-25 08:45:00	SPY	ETF	199.07	199.1	199.0	199.04	185365.0
2014-09-25 08:50:00	SPY	ETF	199.04	199.09	198.99	198.99	186087.0
2014-09-25 08:55:00	SPY	ETF	199.0	199.02	198.94	199.02	439849.0
2014-09-25 09:00:00	SPY	ETF	199.01	199.02	198.91	198.96	210997.0
2014-09-25 09:05:00	SPY	ETF	198.96	199.04	198.96	199.03	46096.0
2014-09-25 09:10:00	SPY	ETF	199.04	199.05	198.96	198.97	31927.0
2014-09-25 09:15:00	SPY	ETF	198.96	199.05	198.93	198.97	49529.0

> showing 50 of 46,306 rows — these rows as CSV

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