PREVIEW / etf_1hour / 2015-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-08.parquet
  size:    241 KB
  rows:    7,675

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
2015-05-08 04:00:00	SPY	ETF	209.36	209.47	209.15	209.25	32997.0
2015-05-08 05:00:00	SPY	ETF	209.25	209.3	209.2	209.22	33761.0
2015-05-08 06:00:00	SPY	ETF	209.13	209.4	209.1	209.29	23574.0
2015-05-08 07:00:00	SPY	ETF	209.35	209.43	209.23	209.36	335977.0
2015-05-08 08:00:00	SPY	ETF	209.36	211.2	209.26	210.89	6929176.0
2015-05-08 09:00:00	SPY	ETF	210.87	211.43	210.71	211.29	24990964.0
2015-05-08 10:00:00	SPY	ETF	211.29	211.58	211.23	211.415	20024641.0
2015-05-08 11:00:00	SPY	ETF	211.415	211.86	211.41	211.74	15906817.0
2015-05-08 12:00:00	SPY	ETF	211.74	211.82	211.52	211.6099	10795980.0
2015-05-08 13:00:00	SPY	ETF	211.6	211.77	211.395	211.42	11869269.0
2015-05-08 14:00:00	SPY	ETF	211.43	211.58	211.3	211.57	19063895.0
2015-05-08 15:00:00	SPY	ETF	211.57	211.76	211.45	211.62	23036260.0
2015-05-08 16:00:00	SPY	ETF	211.63	211.673	208.8568	211.36	17221776.0
2015-05-08 17:00:00	SPY	ETF	211.37	211.62	210.86	211.48	2866598.0
2015-05-08 18:00:00	SPY	ETF	211.47	211.52	211.47	211.52	55507.0
2015-05-08 19:00:00	SPY	ETF	211.51	211.59	211.47	211.59	45913.0
2015-05-08 04:00:00	QQQ	ETF	107.8	107.81	107.7	107.81	21083.0
2015-05-08 05:00:00	QQQ	ETF	107.72	107.73	107.72	107.72	40485.0
2015-05-08 06:00:00	QQQ	ETF	107.72	107.75	107.72	107.75	23769.0
2015-05-08 07:00:00	QQQ	ETF	107.74	107.8	107.59	107.69	52924.0
2015-05-08 08:00:00	QQQ	ETF	107.67	108.66	107.59	108.53	942875.0
2015-05-08 09:00:00	QQQ	ETF	108.53	108.78	108.3	108.6299	4769438.0
2015-05-08 10:00:00	QQQ	ETF	108.63	108.75	108.545	108.625	3939721.0
2015-05-08 11:00:00	QQQ	ETF	108.62	108.92	108.61	108.87	3971770.0
2015-05-08 12:00:00	QQQ	ETF	108.87	108.915	108.69	108.73	2002919.0
2015-05-08 13:00:00	QQQ	ETF	108.72	108.8	108.6	108.62	1858430.0
2015-05-08 14:00:00	QQQ	ETF	108.62	108.69	108.53	108.659	1836762.0
2015-05-08 15:00:00	QQQ	ETF	108.655	108.82	108.59	108.68	9131875.0
2015-05-08 16:00:00	QQQ	ETF	108.67	108.7567	108.55	108.62	751847.0
2015-05-08 17:00:00	QQQ	ETF	108.6	108.62	108.5	108.56	63190.0
2015-05-08 18:00:00	QQQ	ETF	108.59	108.63	108.59	108.61	22340.0
2015-05-08 19:00:00	QQQ	ETF	108.599	108.599	108.48	108.5	16274.0
2015-05-08 04:00:00	IWM	ETF	122.22	122.22	122.22	122.22	100.0
2015-05-08 07:00:00	IWM	ETF	122.21	122.27	122.21	122.26	16800.0
2015-05-08 08:00:00	IWM	ETF	122.22	123.21	122.18	122.93	517513.0
2015-05-08 09:00:00	IWM	ETF	122.9	123.04	122.6	122.88	4103467.0
2015-05-08 10:00:00	IWM	ETF	122.875	123.17	122.74	122.87	3451917.0
2015-05-08 11:00:00	IWM	ETF	122.86	123.13	122.86	123.13	1801703.0
2015-05-08 12:00:00	IWM	ETF	123.125	123.25	122.73	122.81	1911221.0
2015-05-08 13:00:00	IWM	ETF	122.815	122.92	122.43	122.49	1580557.0
2015-05-08 14:00:00	IWM	ETF	122.49	122.65	122.4	122.62	1691883.0
2015-05-08 15:00:00	IWM	ETF	122.62	122.91	122.59	122.65	4779287.0
2015-05-08 16:00:00	IWM	ETF	122.64	122.71	122.39	122.49	2005741.0
2015-05-08 17:00:00	IWM	ETF	122.46	122.47	122.44	122.47	34642.0
2015-05-08 18:00:00	IWM	ETF	122.46	122.46	122.46	122.46	13185.0
2015-05-08 19:00:00	IWM	ETF	122.46	122.46	122.46	122.46	7168.0
2015-05-08 07:00:00	DIA	ETF	179.82	179.82	179.65	179.65	300.0
2015-05-08 08:00:00	DIA	ETF	179.75	181.3	179.7	180.95	64086.0
2015-05-08 09:00:00	DIA	ETF	181.05	181.75	180.92	181.6506	1254625.0
2015-05-08 10:00:00	DIA	ETF	181.66	181.88	181.52	181.79	1266732.0

> showing 50 of 7,675 rows — these rows as CSV

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