PREVIEW / etf_1hour / 2016-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-08-25.parquet
  size:    247 KB
  rows:    7,996

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
2016-08-25 04:00:00	SPY	ETF	217.82	217.85	217.46	217.48	19054.0
2016-08-25 05:00:00	SPY	ETF	217.46	217.93	217.46	217.69	8378.0
2016-08-25 06:00:00	SPY	ETF	217.73	217.73	217.43	217.5	29322.0
2016-08-25 07:00:00	SPY	ETF	217.51	217.57	217.39	217.57	141252.0
2016-08-25 08:00:00	SPY	ETF	217.55	217.69	217.4	217.43	655250.0
2016-08-25 09:00:00	SPY	ETF	217.44	217.74	217.25	217.595	6804895.0
2016-08-25 10:00:00	SPY	ETF	217.595	217.92	217.48	217.815	11672037.0
2016-08-25 11:00:00	SPY	ETF	217.81	218.19	217.81	217.94	8950340.0
2016-08-25 12:00:00	SPY	ETF	217.94	218.02	217.69	217.95	5415723.0
2016-08-25 13:00:00	SPY	ETF	217.945	218.0	217.41	217.56	9568273.0
2016-08-25 14:00:00	SPY	ETF	217.56	217.771	217.26	217.34	6365563.0
2016-08-25 15:00:00	SPY	ETF	217.33	217.63	217.22	217.63	10625010.0
2016-08-25 16:00:00	SPY	ETF	217.63	217.91	217.62	217.88	5836941.0
2016-08-25 17:00:00	SPY	ETF	217.88	217.9	217.8007	217.86	601627.0
2016-08-25 18:00:00	SPY	ETF	217.86	217.94	217.86	217.92	41269.0
2016-08-25 19:00:00	SPY	ETF	217.92	217.92	217.87	217.92	36500.0
2016-08-25 04:00:00	QQQ	ETF	116.59	116.6	116.51	116.51	30621.0
2016-08-25 05:00:00	QQQ	ETF	116.49	116.66	116.49	116.66	2050.0
2016-08-25 06:00:00	QQQ	ETF	116.59	116.59	116.5	116.5	2720.0
2016-08-25 07:00:00	QQQ	ETF	116.51	116.56	116.49	116.56	18694.0
2016-08-25 08:00:00	QQQ	ETF	116.55	116.63	116.52	116.54	355268.0
2016-08-25 09:00:00	QQQ	ETF	116.54	116.71	116.36	116.55	2312575.0
2016-08-25 10:00:00	QQQ	ETF	116.55	116.78	116.45	116.69	4336338.0
2016-08-25 11:00:00	QQQ	ETF	116.7	116.97	116.7	116.84	3575025.0
2016-08-25 12:00:00	QQQ	ETF	116.84	116.9	116.7	116.83	999668.0
2016-08-25 13:00:00	QQQ	ETF	116.84	116.9	116.56	116.6261	2132562.0
2016-08-25 14:00:00	QQQ	ETF	116.63	116.6752	116.4	116.44	1891005.0
2016-08-25 15:00:00	QQQ	ETF	116.44	116.63	116.36	116.57	2258565.0
2016-08-25 16:00:00	QQQ	ETF	116.57	116.72	116.5328	116.7	901132.0
2016-08-25 17:00:00	QQQ	ETF	116.67	116.72	116.67	116.72	900.0
2016-08-25 18:00:00	QQQ	ETF	116.69	116.71	116.69	116.7	4362.0
2016-08-25 19:00:00	QQQ	ETF	116.71	116.71	116.67	116.67	16170.0
2016-08-25 04:00:00	IWM	ETF	122.73	122.73	122.73	122.73	100.0
2016-08-25 06:00:00	IWM	ETF	122.72	122.72	122.72	122.72	10000.0
2016-08-25 07:00:00	IWM	ETF	122.63	122.7	122.63	122.68	49982.0
2016-08-25 08:00:00	IWM	ETF	122.76	122.84	122.7	122.7	228246.0
2016-08-25 09:00:00	IWM	ETF	122.7	123.25	122.58	123.2	2138187.0
2016-08-25 10:00:00	IWM	ETF	123.199	123.44	123.1	123.3	2212411.0
2016-08-25 11:00:00	IWM	ETF	123.3	123.69	123.24	123.29	1769812.0
2016-08-25 12:00:00	IWM	ETF	123.29	123.49	123.03	123.465	1726237.0
2016-08-25 13:00:00	IWM	ETF	123.47	123.555	123.15	123.235	1628506.0
2016-08-25 14:00:00	IWM	ETF	123.22	123.29	122.93	122.98	1696871.0
2016-08-25 15:00:00	IWM	ETF	122.9775	123.33	122.89	123.3	3430744.0
2016-08-25 16:00:00	IWM	ETF	123.3	123.4	123.29	123.4	432586.0
2016-08-25 19:00:00	IWM	ETF	123.48	123.48	123.47	123.47	1500.0
2016-08-25 08:00:00	DIA	ETF	184.26	184.26	184.26	184.26	150.0
2016-08-25 09:00:00	DIA	ETF	184.3	184.53	184.23	184.53	255885.0
2016-08-25 10:00:00	DIA	ETF	184.47	184.71	184.41	184.56	257812.0
2016-08-25 11:00:00	DIA	ETF	184.6	184.79	184.53	184.57	207916.0
2016-08-25 12:00:00	DIA	ETF	184.57	184.6	184.29	184.52	291588.0

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

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