PREVIEW / etf_1hour / 2015-01-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-26.parquet
  size:    244 KB
  rows:    7,710

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-01-26 04:00:00	SPY	ETF	204.23	204.64	203.36	204.21	20859.0
2015-01-26 05:00:00	SPY	ETF	204.3	204.32	203.98	204.15	4800.0
2015-01-26 06:00:00	SPY	ETF	204.18	204.25	204.06	204.16	54919.0
2015-01-26 07:00:00	SPY	ETF	204.27	204.72	204.16	204.65	403205.0
2015-01-26 08:00:00	SPY	ETF	204.0378	205.07	204.0378	204.98	967091.0
2015-01-26 09:00:00	SPY	ETF	204.97	204.98	203.85	204.32	14464001.0
2015-01-26 10:00:00	SPY	ETF	204.33	205.16	204.23	205.0249	14426339.0
2015-01-26 11:00:00	SPY	ETF	205.03	205.2	204.63	205.12	9426412.0
2015-01-26 12:00:00	SPY	ETF	205.115	205.3	204.82	204.99	7268034.0
2015-01-26 13:00:00	SPY	ETF	204.99	205.56	204.84	205.43	6699414.0
2015-01-26 14:00:00	SPY	ETF	205.435	205.49	205.03	205.17	7028795.0
2015-01-26 15:00:00	SPY	ETF	205.16	205.56	204.93	205.46	16880031.0
2015-01-26 16:00:00	SPY	ETF	205.47	205.86	204.6594	205.83	8898494.0
2015-01-26 17:00:00	SPY	ETF	205.82	205.86	205.77	205.77	105939.0
2015-01-26 18:00:00	SPY	ETF	205.78	205.8	205.72	205.77	59154.0
2015-01-26 19:00:00	SPY	ETF	205.76	205.81	205.72	205.81	244834.0
2015-01-26 04:00:00	QQQ	ETF	104.09	104.09	103.94	103.94	4906.0
2015-01-26 05:00:00	QQQ	ETF	103.93	103.93	103.93	103.93	100.0
2015-01-26 06:00:00	QQQ	ETF	103.91	103.99	103.9	103.96	19700.0
2015-01-26 07:00:00	QQQ	ETF	104.02	104.23	103.99	104.21	17400.0
2015-01-26 08:00:00	QQQ	ETF	104.18	104.39	104.0	104.3	236535.0
2015-01-26 09:00:00	QQQ	ETF	104.3	104.31	103.61	103.84	4375947.0
2015-01-26 10:00:00	QQQ	ETF	103.85	104.13	103.71	104.1	3589642.0
2015-01-26 11:00:00	QQQ	ETF	104.1	104.19	103.78	104.0	2113371.0
2015-01-26 12:00:00	QQQ	ETF	104.01	104.13	103.92	104.01	1310573.0
2015-01-26 13:00:00	QQQ	ETF	104.01	104.33	103.931	104.2255	1677086.0
2015-01-26 14:00:00	QQQ	ETF	104.23	104.26	103.93	104.015	1512375.0
2015-01-26 15:00:00	QQQ	ETF	104.01	104.21	103.93	104.15	2665820.0
2015-01-26 16:00:00	QQQ	ETF	104.15	104.3	103.9477	104.14	774854.0
2015-01-26 17:00:00	QQQ	ETF	104.15	104.24	104.08	104.08	29310.0
2015-01-26 18:00:00	QQQ	ETF	104.1	104.11	104.06	104.09	30265.0
2015-01-26 19:00:00	QQQ	ETF	104.08	104.12	104.07	104.08	41785.0
2015-01-26 05:00:00	IWM	ETF	117.65	117.65	117.65	117.65	100.0
2015-01-26 06:00:00	IWM	ETF	117.66	117.66	117.55	117.55	11000.0
2015-01-26 07:00:00	IWM	ETF	117.7	117.84	117.59	117.84	5700.0
2015-01-26 08:00:00	IWM	ETF	117.88	118.23	117.77	118.08	190025.0
2015-01-26 09:00:00	IWM	ETF	118.1	118.1	117.07	117.795	3808823.0
2015-01-26 10:00:00	IWM	ETF	117.8	118.77	117.71	118.67	4519524.0
2015-01-26 11:00:00	IWM	ETF	118.68	118.72	118.42	118.66	1863132.0
2015-01-26 12:00:00	IWM	ETF	118.66	119.06	118.62	118.875	2237300.0
2015-01-26 13:00:00	IWM	ETF	118.87	119.03	118.81	118.95	1367183.0
2015-01-26 14:00:00	IWM	ETF	118.95	119.02	118.8101	118.96	1571813.0
2015-01-26 15:00:00	IWM	ETF	118.95	119.25	118.875	119.24	4951462.0
2015-01-26 16:00:00	IWM	ETF	119.24	119.43	119.1711	119.42	1049440.0
2015-01-26 17:00:00	IWM	ETF	119.42	119.45	119.34	119.37	16350.0
2015-01-26 18:00:00	IWM	ETF	119.4	119.46	119.4	119.46	1300.0
2015-01-26 19:00:00	IWM	ETF	119.43	119.43	119.35	119.4	745.0
2015-01-26 04:00:00	DIA	ETF	175.0	175.0	175.0	175.0	799.0
2015-01-26 05:00:00	DIA	ETF	175.85	175.85	175.85	175.85	300.0
2015-01-26 06:00:00	DIA	ETF	175.68	175.68	175.55	175.55	315.0

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

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