PREVIEW / etf_5min / 2012-12-19

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-12-19.parquet
  size:    955 KB
  rows:    40,828

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
2012-12-19 04:00:00	SPY	ETF	145.3	145.3	145.26	145.26	2048.0
2012-12-19 04:05:00	SPY	ETF	145.29	145.29	145.29	145.29	100.0
2012-12-19 04:25:00	SPY	ETF	145.33	145.33	145.33	145.33	100.0
2012-12-19 04:35:00	SPY	ETF	145.41	145.41	145.41	145.41	4000.0
2012-12-19 05:10:00	SPY	ETF	145.48	145.58	145.48	145.58	25993.0
2012-12-19 05:15:00	SPY	ETF	145.58	145.58	145.58	145.58	400.0
2012-12-19 05:25:00	SPY	ETF	145.59	145.59	145.56	145.56	12507.0
2012-12-19 06:00:00	SPY	ETF	145.57	145.6	145.57	145.6	1140.0
2012-12-19 06:05:00	SPY	ETF	145.6	145.6	145.58	145.58	1000.0
2012-12-19 06:10:00	SPY	ETF	145.59	145.59	145.59	145.59	1100.0
2012-12-19 06:15:00	SPY	ETF	145.59	145.59	145.59	145.59	100.0
2012-12-19 06:20:00	SPY	ETF	145.59	145.59	145.57	145.57	2300.0
2012-12-19 06:25:00	SPY	ETF	145.58	145.58	145.58	145.58	200.0
2012-12-19 06:30:00	SPY	ETF	145.58	145.58	145.51	145.51	1650.0
2012-12-19 06:35:00	SPY	ETF	145.53	145.53	145.49	145.51	4250.0
2012-12-19 06:45:00	SPY	ETF	145.5	145.6	145.5	145.55	19850.0
2012-12-19 06:50:00	SPY	ETF	145.57	145.57	145.57	145.57	1500.0
2012-12-19 06:55:00	SPY	ETF	145.57	145.6	145.57	145.57	10600.0
2012-12-19 07:00:00	SPY	ETF	145.54	145.55	145.52	145.55	25943.0
2012-12-19 07:05:00	SPY	ETF	145.52	145.54	145.52	145.52	16700.0
2012-12-19 07:10:00	SPY	ETF	145.52	145.59	145.52	145.59	25300.0
2012-12-19 07:15:00	SPY	ETF	145.59	145.63	145.58	145.58	7000.0
2012-12-19 07:20:00	SPY	ETF	145.55	145.56	145.53	145.53	218064.0
2012-12-19 07:25:00	SPY	ETF	145.54	145.56	145.5	145.53	283156.0
2012-12-19 07:30:00	SPY	ETF	145.54	145.56	145.51	145.54	228224.0
2012-12-19 07:35:00	SPY	ETF	145.54	145.57	145.54	145.54	23468.0
2012-12-19 07:40:00	SPY	ETF	145.54	145.54	145.53	145.54	13600.0
2012-12-19 07:45:00	SPY	ETF	145.55	145.6	145.55	145.55	13620.0
2012-12-19 07:50:00	SPY	ETF	145.53	145.6	145.53	145.56	17200.0
2012-12-19 07:55:00	SPY	ETF	145.57	145.59	145.56	145.56	4650.0
2012-12-19 08:00:00	SPY	ETF	145.56	145.59	145.52	145.56	45426.0
2012-12-19 08:05:00	SPY	ETF	145.56	145.58	145.53	145.56	23500.0
2012-12-19 08:10:00	SPY	ETF	145.58	145.62	145.54	145.55	113353.0
2012-12-19 08:15:00	SPY	ETF	145.55	145.59	145.55	145.56	27215.0
2012-12-19 08:20:00	SPY	ETF	145.56	145.66	145.56	145.63	133354.0
2012-12-19 08:25:00	SPY	ETF	145.63	145.72	145.61	145.67	256758.0
2012-12-19 08:30:00	SPY	ETF	145.55	145.71	145.55	145.66	395972.0
2012-12-19 08:35:00	SPY	ETF	145.66	145.7	145.63	145.7	296874.0
2012-12-19 08:40:00	SPY	ETF	145.69	145.72	145.65	145.65	111881.0
2012-12-19 08:45:00	SPY	ETF	145.65	145.65	145.56	145.57	60570.0
2012-12-19 08:50:00	SPY	ETF	145.56	145.66	145.56	145.66	93779.0
2012-12-19 08:55:00	SPY	ETF	145.66	145.69	145.64	145.65	50349.0
2012-12-19 09:00:00	SPY	ETF	145.64	145.67	145.41	145.64	17668.0
2012-12-19 09:05:00	SPY	ETF	145.64	145.68	145.62	145.66	29722.0
2012-12-19 09:10:00	SPY	ETF	145.67	145.72	145.67	145.7	35510.0
2012-12-19 09:15:00	SPY	ETF	145.7	145.75	145.58	145.6	173742.0
2012-12-19 09:20:00	SPY	ETF	145.59	145.63	145.56	145.58	129891.0
2012-12-19 09:25:00	SPY	ETF	145.58	145.58	145.46	145.54	279698.0
2012-12-19 09:30:00	SPY	ETF	145.53	145.58	145.33	145.34	3796911.0
2012-12-19 09:35:00	SPY	ETF	145.33	145.45	145.32	145.42	2004844.0

> showing 50 of 40,828 rows — these rows as CSV

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