PREVIEW / etf_5min / 2013-07-19

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-07-19.parquet
  size:    912 KB
  rows:    39,562

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-19 04:00:00	SPY	ETF	168.2	168.27	168.2	168.27	516.0
2013-07-19 04:05:00	SPY	ETF	168.29	168.3	168.29	168.3	6378.0
2013-07-19 04:10:00	SPY	ETF	168.3	168.3	168.3	168.3	1600.0
2013-07-19 04:15:00	SPY	ETF	168.29	168.3	168.29	168.3	500.0
2013-07-19 04:20:00	SPY	ETF	168.28	168.28	168.24	168.24	757.0
2013-07-19 04:30:00	SPY	ETF	168.21	168.21	168.2	168.2	2566.0
2013-07-19 04:35:00	SPY	ETF	168.21	168.21	168.21	168.21	2943.0
2013-07-19 04:55:00	SPY	ETF	168.19	168.19	168.19	168.19	200.0
2013-07-19 05:05:00	SPY	ETF	168.16	168.16	168.15	168.15	1394.0
2013-07-19 05:10:00	SPY	ETF	168.2	168.25	168.2	168.2	1700.0
2013-07-19 05:25:00	SPY	ETF	168.24	168.26	168.24	168.26	1400.0
2013-07-19 05:30:00	SPY	ETF	168.26	168.26	168.24	168.24	10500.0
2013-07-19 05:35:00	SPY	ETF	168.28	168.28	168.28	168.28	400.0
2013-07-19 05:40:00	SPY	ETF	168.25	168.25	168.25	168.25	1700.0
2013-07-19 05:45:00	SPY	ETF	168.24	168.24	168.24	168.24	500.0
2013-07-19 05:50:00	SPY	ETF	168.28	168.36	168.28	168.36	1200.0
2013-07-19 05:55:00	SPY	ETF	168.32	168.33	168.29	168.33	600.0
2013-07-19 06:00:00	SPY	ETF	168.36	168.38	168.36	168.38	2600.0
2013-07-19 06:05:00	SPY	ETF	168.38	168.38	168.35	168.35	3100.0
2013-07-19 06:10:00	SPY	ETF	168.34	168.36	168.34	168.36	5300.0
2013-07-19 06:30:00	SPY	ETF	168.34	168.34	168.32	168.32	5600.0
2013-07-19 06:35:00	SPY	ETF	168.31	168.31	168.31	168.31	5000.0
2013-07-19 06:40:00	SPY	ETF	168.31	168.31	168.31	168.31	10100.0
2013-07-19 06:45:00	SPY	ETF	168.35	168.41	168.35	168.41	11900.0
2013-07-19 06:50:00	SPY	ETF	168.41	168.41	168.38	168.38	2300.0
2013-07-19 06:55:00	SPY	ETF	168.36	168.36	168.32	168.34	5520.0
2013-07-19 07:00:00	SPY	ETF	168.34	168.44	168.3	168.41	31620.0
2013-07-19 07:05:00	SPY	ETF	168.4	168.58	168.4	168.58	8566.0
2013-07-19 07:10:00	SPY	ETF	168.6	168.64	168.6	168.6	20508.0
2013-07-19 07:15:00	SPY	ETF	168.6	168.64	168.54	168.54	48800.0
2013-07-19 07:20:00	SPY	ETF	168.54	168.54	168.51	168.51	16700.0
2013-07-19 07:25:00	SPY	ETF	168.52	168.54	168.5	168.54	56600.0
2013-07-19 07:30:00	SPY	ETF	168.55	168.63	168.55	168.63	2300.0
2013-07-19 07:35:00	SPY	ETF	168.64	168.64	168.6	168.6	49400.0
2013-07-19 07:40:00	SPY	ETF	168.58	168.58	168.57	168.57	300.0
2013-07-19 07:45:00	SPY	ETF	168.59	168.59	168.5	168.53	8450.0
2013-07-19 07:50:00	SPY	ETF	168.54	168.54	168.5	168.5	3875.0
2013-07-19 07:55:00	SPY	ETF	168.5	168.53	168.48	168.53	23250.0
2013-07-19 08:00:00	SPY	ETF	168.51	168.64	168.34	168.49	40033.0
2013-07-19 08:05:00	SPY	ETF	168.49	168.5	168.41	168.5	49960.0
2013-07-19 08:10:00	SPY	ETF	168.49	168.52	168.48	168.51	15750.0
2013-07-19 08:15:00	SPY	ETF	168.49	168.5	168.44	168.44	23295.0
2013-07-19 08:20:00	SPY	ETF	168.44	168.47	168.4	168.4	12685.0
2013-07-19 08:25:00	SPY	ETF	168.41	168.42	168.38	168.41	39560.0
2013-07-19 08:30:00	SPY	ETF	168.41	168.46	168.31	168.36	83184.0
2013-07-19 08:35:00	SPY	ETF	168.33	168.41	168.29	168.39	81986.0
2013-07-19 08:40:00	SPY	ETF	168.4	168.4	168.29	168.37	58224.0
2013-07-19 08:45:00	SPY	ETF	168.36	168.43	168.31	168.31	63800.0
2013-07-19 08:50:00	SPY	ETF	168.31	168.33	168.29	168.29	78500.0
2013-07-19 08:55:00	SPY	ETF	168.28	168.35	168.28	168.33	120195.0

> showing 50 of 39,562 rows — these rows as CSV

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