PREVIEW / etf_1hour / 2015-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-08-06.parquet
  size:    238 KB
  rows:    7,559

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-08-06 04:00:00	SPY	ETF	210.08	210.23	210.08	210.23	4000.0
2015-08-06 05:00:00	SPY	ETF	210.1	210.1	209.86	209.96	8614.0
2015-08-06 06:00:00	SPY	ETF	209.96	210.11	209.89	210.04	12429.0
2015-08-06 07:00:00	SPY	ETF	210.08	210.55	209.98	210.43	210886.0
2015-08-06 08:00:00	SPY	ETF	210.39	210.51	210.01	210.15	486015.0
2015-08-06 09:00:00	SPY	ETF	210.19	210.415	209.23	209.35	9157837.0
2015-08-06 10:00:00	SPY	ETF	209.36	209.61	208.94	209.15	13206741.0
2015-08-06 11:00:00	SPY	ETF	209.14	209.18	207.965	208.005	17747651.0
2015-08-06 12:00:00	SPY	ETF	208.0	208.21	207.65	207.89	13024425.0
2015-08-06 13:00:00	SPY	ETF	207.89	208.495	207.81	208.205	10789288.0
2015-08-06 14:00:00	SPY	ETF	208.2	208.62	208.09	208.409	9609322.0
2015-08-06 15:00:00	SPY	ETF	208.41	208.7	208.12	208.47	20401262.0
2015-08-06 16:00:00	SPY	ETF	208.45	208.65	208.27	208.62	6151186.0
2015-08-06 17:00:00	SPY	ETF	208.62	208.66	208.355	208.65	5700154.0
2015-08-06 18:00:00	SPY	ETF	208.64	208.67	208.59	208.64	108618.0
2015-08-06 19:00:00	SPY	ETF	208.62	208.65	208.54	208.55	37897.0
2015-08-06 06:00:00	QQQ	ETF	112.25	112.25	112.25	112.25	17000.0
2015-08-06 07:00:00	QQQ	ETF	112.23	112.5	112.23	112.41	21600.0
2015-08-06 08:00:00	QQQ	ETF	112.4	112.41	112.22	112.25	45903.0
2015-08-06 09:00:00	QQQ	ETF	112.26	112.5	111.48	111.58	4201183.0
2015-08-06 10:00:00	QQQ	ETF	111.58	111.789	111.0	111.0001	5876851.0
2015-08-06 11:00:00	QQQ	ETF	111.0	111.06	110.09	110.12	7599700.0
2015-08-06 12:00:00	QQQ	ETF	110.11	110.27	109.95	110.18	3721865.0
2015-08-06 13:00:00	QQQ	ETF	110.18	110.58	110.09	110.335	3620758.0
2015-08-06 14:00:00	QQQ	ETF	110.33	110.61	110.25	110.42	3318201.0
2015-08-06 15:00:00	QQQ	ETF	110.42	110.6	110.16	110.48	6400236.0
2015-08-06 16:00:00	QQQ	ETF	110.48	110.55	110.35	110.53	1311399.0
2015-08-06 17:00:00	QQQ	ETF	110.55	110.57	110.5	110.5	37467.0
2015-08-06 18:00:00	QQQ	ETF	110.55	110.56	110.45	110.53	22420.0
2015-08-06 19:00:00	QQQ	ETF	110.52	110.53	110.47	110.47	10600.0
2015-08-06 07:00:00	IWM	ETF	122.62	122.62	122.62	122.62	100.0
2015-08-06 08:00:00	IWM	ETF	122.64	122.64	122.38	122.43	64517.0
2015-08-06 09:00:00	IWM	ETF	122.47	122.66	121.67	121.79	2723552.0
2015-08-06 10:00:00	IWM	ETF	121.78	121.79	121.14	121.4939	5411804.0
2015-08-06 11:00:00	IWM	ETF	121.48	121.52	120.16	120.27	5155855.0
2015-08-06 12:00:00	IWM	ETF	120.25	120.35	119.78	120.0	5502703.0
2015-08-06 13:00:00	IWM	ETF	119.99	120.62	119.89	120.46	4558857.0
2015-08-06 14:00:00	IWM	ETF	120.46	120.96	120.24	120.68	4252143.0
2015-08-06 15:00:00	IWM	ETF	120.685	120.8801	120.42	120.69	4799651.0
2015-08-06 16:00:00	IWM	ETF	120.69	120.9	120.51	120.67	1190604.0
2015-08-06 17:00:00	IWM	ETF	120.5349	120.69	120.5349	120.69	383009.0
2015-08-06 18:00:00	IWM	ETF	120.64	120.64	120.64	120.64	200.0
2015-08-06 07:00:00	DIA	ETF	175.62	175.63	175.62	175.63	2700.0
2015-08-06 08:00:00	DIA	ETF	175.52	175.52	175.52	175.52	300.0
2015-08-06 09:00:00	DIA	ETF	175.5	175.65	174.4	174.5	587822.0
2015-08-06 10:00:00	DIA	ETF	174.51	174.89	174.27	174.67	820234.0
2015-08-06 11:00:00	DIA	ETF	174.67	174.69	173.93	173.96	837641.0
2015-08-06 12:00:00	DIA	ETF	173.95	174.18	173.65	173.91	846698.0
2015-08-06 13:00:00	DIA	ETF	173.88	174.25	173.84	173.9835	724800.0
2015-08-06 14:00:00	DIA	ETF	173.98	174.29	173.9277	174.14	401126.0

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

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