PREVIEW / etf_5min / 2013-07-09

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-09.parquet
  size:    993 KB
  rows:    43,028

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
2013-07-09 04:00:00	SPY	ETF	164.86	164.88	164.86	164.88	25600.0
2013-07-09 04:05:00	SPY	ETF	164.88	164.88	164.86	164.88	8000.0
2013-07-09 04:10:00	SPY	ETF	164.88	164.88	164.88	164.88	100.0
2013-07-09 04:15:00	SPY	ETF	164.84	164.85	164.84	164.85	200.0
2013-07-09 04:20:00	SPY	ETF	164.84	164.88	164.84	164.88	1400.0
2013-07-09 04:25:00	SPY	ETF	164.89	164.92	164.89	164.9	1500.0
2013-07-09 04:30:00	SPY	ETF	164.88	164.88	164.87	164.87	550.0
2013-07-09 04:35:00	SPY	ETF	164.84	164.84	164.8	164.8	520.0
2013-07-09 04:40:00	SPY	ETF	164.78	164.78	164.78	164.78	100.0
2013-07-09 04:45:00	SPY	ETF	164.81	164.82	164.77	164.82	14745.0
2013-07-09 04:50:00	SPY	ETF	164.76	164.76	164.73	164.73	2535.0
2013-07-09 04:55:00	SPY	ETF	164.8	164.8	164.8	164.8	200.0
2013-07-09 05:00:00	SPY	ETF	164.73	164.73	164.73	164.73	100.0
2013-07-09 05:05:00	SPY	ETF	164.73	164.76	164.73	164.76	200.0
2013-07-09 05:15:00	SPY	ETF	164.77	164.8	164.77	164.8	600.0
2013-07-09 05:20:00	SPY	ETF	164.76	164.76	164.73	164.73	10200.0
2013-07-09 05:25:00	SPY	ETF	164.74	164.74	164.74	164.74	400.0
2013-07-09 05:30:00	SPY	ETF	164.77	164.77	164.74	164.74	400.0
2013-07-09 05:35:00	SPY	ETF	164.74	164.8	164.74	164.76	3200.0
2013-07-09 05:40:00	SPY	ETF	164.77	164.77	164.77	164.77	3250.0
2013-07-09 05:45:00	SPY	ETF	164.77	164.77	164.77	164.77	100.0
2013-07-09 05:50:00	SPY	ETF	164.72	164.72	164.72	164.72	300.0
2013-07-09 05:55:00	SPY	ETF	164.72	164.72	164.66	164.66	1540.0
2013-07-09 06:05:00	SPY	ETF	164.68	164.68	164.6	164.6	1300.0
2013-07-09 06:10:00	SPY	ETF	164.64	164.67	164.64	164.67	600.0
2013-07-09 06:15:00	SPY	ETF	164.68	164.7	164.67	164.67	950.0
2013-07-09 06:20:00	SPY	ETF	164.64	164.64	164.61	164.61	1200.0
2013-07-09 06:25:00	SPY	ETF	164.62	164.62	164.61	164.61	26600.0
2013-07-09 06:30:00	SPY	ETF	164.65	164.65	164.65	164.65	100.0
2013-07-09 06:35:00	SPY	ETF	164.65	164.65	164.6	164.6	700.0
2013-07-09 06:40:00	SPY	ETF	164.59	164.59	164.53	164.53	2200.0
2013-07-09 06:45:00	SPY	ETF	164.53	164.55	164.52	164.54	1300.0
2013-07-09 06:50:00	SPY	ETF	164.5	164.5	164.4	164.4	4600.0
2013-07-09 06:55:00	SPY	ETF	164.4	164.5	164.4	164.5	3700.0
2013-07-09 07:00:00	SPY	ETF	164.5	164.55	164.5	164.55	30277.0
2013-07-09 07:05:00	SPY	ETF	164.52	164.6	164.5	164.58	4700.0
2013-07-09 07:10:00	SPY	ETF	164.58	164.59	164.54	164.58	3611.0
2013-07-09 07:15:00	SPY	ETF	164.57	164.59	164.52	164.53	11354.0
2013-07-09 07:20:00	SPY	ETF	164.52	164.57	164.52	164.57	3200.0
2013-07-09 07:25:00	SPY	ETF	164.59	164.62	164.59	164.6	4325.0
2013-07-09 07:30:00	SPY	ETF	164.62	164.62	164.59	164.61	4000.0
2013-07-09 07:35:00	SPY	ETF	164.58	164.62	164.58	164.62	39200.0
2013-07-09 07:40:00	SPY	ETF	164.61	164.62	164.58	164.61	22000.0
2013-07-09 07:45:00	SPY	ETF	164.63	164.71	164.63	164.66	61912.0
2013-07-09 07:50:00	SPY	ETF	164.68	164.71	164.66	164.69	57109.0
2013-07-09 07:55:00	SPY	ETF	164.72	164.72	164.65	164.65	21395.0
2013-07-09 08:00:00	SPY	ETF	164.65	164.67	164.45	164.61	83515.0
2013-07-09 08:05:00	SPY	ETF	164.63	164.635	164.5	164.51	103888.0
2013-07-09 08:10:00	SPY	ETF	164.54	164.65	164.53	164.63	83590.0
2013-07-09 08:15:00	SPY	ETF	164.63	164.64	164.6	164.6	50040.0

> showing 50 of 43,028 rows — these rows as CSV

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