PREVIEW / etf_1hour / 2015-06-25

all etf 1-hour files

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

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-06-25 04:00:00	SPY	ETF	211.0	211.7	211.0	211.31	48897.0
2015-06-25 05:00:00	SPY	ETF	211.31	211.35	211.04	211.21	84710.0
2015-06-25 06:00:00	SPY	ETF	211.22	211.66	211.15	211.36	211240.0
2015-06-25 07:00:00	SPY	ETF	211.34	211.51	211.03	211.11	504607.0
2015-06-25 08:00:00	SPY	ETF	211.49	211.49	210.86	211.11	725391.0
2015-06-25 09:00:00	SPY	ETF	211.11	211.21	210.31	210.78	12326701.0
2015-06-25 10:00:00	SPY	ETF	210.78	211.03	210.57	210.943	8906704.0
2015-06-25 11:00:00	SPY	ETF	210.95	211.25	210.84	210.98	10835746.0
2015-06-25 12:00:00	SPY	ETF	210.976	211.015	210.52	210.66	8038622.0
2015-06-25 13:00:00	SPY	ETF	210.66	210.77	210.5	210.605	5285209.0
2015-06-25 14:00:00	SPY	ETF	210.61	210.61	209.77	210.0201	13335702.0
2015-06-25 15:00:00	SPY	ETF	210.025	210.36	209.81	209.81	18102624.0
2015-06-25 16:00:00	SPY	ETF	209.82	210.95	209.73	209.9	11350324.0
2015-06-25 17:00:00	SPY	ETF	209.897	209.98	209.86	209.96	1675146.0
2015-06-25 18:00:00	SPY	ETF	209.97	209.99	209.88	209.98	47030.0
2015-06-25 19:00:00	SPY	ETF	209.98	209.99	209.91	209.99	21210.0
2015-06-25 04:00:00	QQQ	ETF	110.57	110.9	110.57	110.81	6750.0
2015-06-25 05:00:00	QQQ	ETF	110.51	110.56	110.51	110.56	10000.0
2015-06-25 06:00:00	QQQ	ETF	110.86	110.86	110.71	110.71	26000.0
2015-06-25 07:00:00	QQQ	ETF	110.68	110.74	110.56	110.56	25507.0
2015-06-25 08:00:00	QQQ	ETF	110.73	110.73	110.49	110.62	58203.0
2015-06-25 09:00:00	QQQ	ETF	110.59	110.69	110.24	110.47	2633644.0
2015-06-25 10:00:00	QQQ	ETF	110.495	110.649	110.35	110.585	1598186.0
2015-06-25 11:00:00	QQQ	ETF	110.59	110.76	110.57	110.61	1451239.0
2015-06-25 12:00:00	QQQ	ETF	110.61	110.64	110.355	110.43	1206934.0
2015-06-25 13:00:00	QQQ	ETF	110.435	110.47	110.2628	110.3	936161.0
2015-06-25 14:00:00	QQQ	ETF	110.3	110.31	109.815	110.01	2333100.0
2015-06-25 15:00:00	QQQ	ETF	110.01	110.24	109.98	110.0	2435798.0
2015-06-25 16:00:00	QQQ	ETF	109.98	110.08	109.93	109.96	348243.0
2015-06-25 17:00:00	QQQ	ETF	109.99	110.0	109.94	109.94	14700.0
2015-06-25 18:00:00	QQQ	ETF	109.96	110.01	109.94	110.01	21725.0
2015-06-25 19:00:00	QQQ	ETF	109.99	109.99	109.97	109.99	3290.0
2015-06-25 06:00:00	IWM	ETF	128.59	128.59	128.48	128.48	5400.0
2015-06-25 07:00:00	IWM	ETF	128.48	128.64	128.31	128.35	45200.0
2015-06-25 08:00:00	IWM	ETF	128.35	128.41	128.23	128.39	110607.0
2015-06-25 09:00:00	IWM	ETF	128.39	128.42	127.75	127.89	2680582.0
2015-06-25 10:00:00	IWM	ETF	127.89	128.15	127.63	128.05	2469780.0
2015-06-25 11:00:00	IWM	ETF	128.045	128.27	128.01	128.15	1501704.0
2015-06-25 12:00:00	IWM	ETF	128.15	128.18	127.7601	127.875	1606211.0
2015-06-25 13:00:00	IWM	ETF	127.88	127.99	127.775	127.83	1006964.0
2015-06-25 14:00:00	IWM	ETF	127.82	127.82	127.245	127.605	2377850.0
2015-06-25 15:00:00	IWM	ETF	127.6	127.91	127.55	127.83	3694601.0
2015-06-25 16:00:00	IWM	ETF	127.83	127.96	127.83	127.9	926183.0
2015-06-25 17:00:00	IWM	ETF	127.91	127.99	127.85	127.99	188472.0
2015-06-25 18:00:00	IWM	ETF	127.85	127.85	127.85	127.85	400.0
2015-06-25 04:00:00	DIA	ETF	180.3	180.3	180.3	180.3	300.0
2015-06-25 05:00:00	DIA	ETF	180.25	180.25	180.25	180.25	200.0
2015-06-25 06:00:00	DIA	ETF	180.44	180.44	180.16	180.34	2100.0
2015-06-25 07:00:00	DIA	ETF	180.05	180.05	180.05	180.05	820.0
2015-06-25 08:00:00	DIA	ETF	180.06	180.19	179.86	180.02	6000.0

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

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