PREVIEW / etf_1hour / 2015-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-15.parquet
  size:    238 KB
  rows:    7,594

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-09-15 04:00:00	SPY	ETF	195.8	195.83	195.42	195.71	57898.0
2015-09-15 05:00:00	SPY	ETF	195.63	195.71	195.3	195.66	50162.0
2015-09-15 06:00:00	SPY	ETF	195.66	196.39	195.51	196.21	51066.0
2015-09-15 07:00:00	SPY	ETF	196.29	196.41	196.07	196.15	92388.0
2015-09-15 08:00:00	SPY	ETF	196.11	196.62	196.0	196.53	494028.0
2015-09-15 09:00:00	SPY	ETF	196.53	196.9	196.09	196.48	10527931.0
2015-09-15 10:00:00	SPY	ETF	196.48	197.82	196.34	197.64	17048401.0
2015-09-15 11:00:00	SPY	ETF	197.635	197.77	197.32	197.57	10653969.0
2015-09-15 12:00:00	SPY	ETF	197.57	197.93	197.47	197.7	7402678.0
2015-09-15 13:00:00	SPY	ETF	197.7	198.56	197.62	198.26	13798668.0
2015-09-15 14:00:00	SPY	ETF	198.27	198.83	198.2	198.79	14228580.0
2015-09-15 15:00:00	SPY	ETF	198.79	198.99	198.44	198.49	27474810.0
2015-09-15 16:00:00	SPY	ETF	198.49	198.84	197.9598	198.79	7771284.0
2015-09-15 17:00:00	SPY	ETF	198.78	198.84	195.9701	198.72	588623.0
2015-09-15 18:00:00	SPY	ETF	198.68	198.75	198.61	198.7	60678.0
2015-09-15 19:00:00	SPY	ETF	198.73	198.78	198.65	198.66	99319.0
2015-09-15 04:00:00	QQQ	ETF	105.07	105.07	104.97	104.97	800.0
2015-09-15 05:00:00	QQQ	ETF	104.87	105.02	104.81	105.0	2200.0
2015-09-15 06:00:00	QQQ	ETF	105.08	105.4	104.94	105.33	4073.0
2015-09-15 07:00:00	QQQ	ETF	105.37	105.38	105.23	105.29	19400.0
2015-09-15 08:00:00	QQQ	ETF	105.26	105.52	105.18	105.5	62230.0
2015-09-15 09:00:00	QQQ	ETF	105.49	105.66	105.11	105.4	3314291.0
2015-09-15 10:00:00	QQQ	ETF	105.4	106.33	105.4	106.19	5848461.0
2015-09-15 11:00:00	QQQ	ETF	106.2	106.269	105.98	106.091	3244437.0
2015-09-15 12:00:00	QQQ	ETF	106.09	106.28	106.04	106.137	1624828.0
2015-09-15 13:00:00	QQQ	ETF	106.13	106.59	106.1	106.41	3660579.0
2015-09-15 14:00:00	QQQ	ETF	106.41	106.76	106.37	106.71	3343780.0
2015-09-15 15:00:00	QQQ	ETF	106.71	106.82	106.45	106.46	5811802.0
2015-09-15 16:00:00	QQQ	ETF	106.47	106.61	106.2137	106.58	1942809.0
2015-09-15 17:00:00	QQQ	ETF	106.58	106.58	106.5	106.55	26300.0
2015-09-15 18:00:00	QQQ	ETF	106.55	106.58	106.52	106.57	4815.0
2015-09-15 19:00:00	QQQ	ETF	106.57	106.59	106.54	106.56	139453.0
2015-09-15 05:00:00	IWM	ETF	114.43	114.43	114.29	114.34	3000.0
2015-09-15 06:00:00	IWM	ETF	114.35	114.49	114.27	114.49	10995.0
2015-09-15 07:00:00	IWM	ETF	114.56	114.7	114.55	114.55	18400.0
2015-09-15 08:00:00	IWM	ETF	114.7	114.82	114.56	114.82	34135.0
2015-09-15 09:00:00	IWM	ETF	114.83	115.27	114.73	115.16	2468646.0
2015-09-15 10:00:00	IWM	ETF	115.16	115.81	115.03	115.62	4379483.0
2015-09-15 11:00:00	IWM	ETF	115.62	115.69	115.24	115.44	1986434.0
2015-09-15 12:00:00	IWM	ETF	115.43	115.58	115.28	115.2801	1802016.0
2015-09-15 13:00:00	IWM	ETF	115.28	115.87	115.25	115.58	2538977.0
2015-09-15 14:00:00	IWM	ETF	115.58	115.945	115.545	115.905	1835751.0
2015-09-15 15:00:00	IWM	ETF	115.91	116.19	115.855	115.95	4553900.0
2015-09-15 16:00:00	IWM	ETF	115.96	116.23	115.91	116.18	770349.0
2015-09-15 17:00:00	IWM	ETF	116.17	116.19	116.17	116.19	200.0
2015-09-15 18:00:00	IWM	ETF	116.13	116.13	116.13	116.13	305.0
2015-09-15 19:00:00	IWM	ETF	116.18	116.18	116.18	116.18	200.0
2015-09-15 07:00:00	DIA	ETF	164.0	164.07	163.95	163.95	1200.0
2015-09-15 08:00:00	DIA	ETF	164.0	164.29	163.91	164.29	1700.0
2015-09-15 09:00:00	DIA	ETF	164.28	164.5	163.97	164.31	573343.0

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

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