PREVIEW / etf_1hour / 2015-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-01.parquet
  size:    241 KB
  rows:    7,692

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-10-01 04:00:00	SPY	ETF	193.43	193.48	192.88	193.1	23999.0
2015-10-01 05:00:00	SPY	ETF	193.16	193.5	192.97	193.01	54398.0
2015-10-01 06:00:00	SPY	ETF	193.08	193.2	192.63	192.9	124925.0
2015-10-01 07:00:00	SPY	ETF	192.98	193.04	191.92	191.93	458547.0
2015-10-01 08:00:00	SPY	ETF	191.92	193.1	191.69	191.89	1540432.0
2015-10-01 09:00:00	SPY	ETF	191.88	192.49	191.06	191.08	16857251.0
2015-10-01 10:00:00	SPY	ETF	191.09	192.01	190.61	190.98	20048088.0
2015-10-01 11:00:00	SPY	ETF	190.97	191.34	190.14	190.361	18283760.0
2015-10-01 12:00:00	SPY	ETF	190.37	190.9901	189.82	190.431	14120706.0
2015-10-01 13:00:00	SPY	ETF	190.43	190.9099	189.96	190.87	11611602.0
2015-10-01 14:00:00	SPY	ETF	190.87	191.83	190.68	191.7	13372334.0
2015-10-01 15:00:00	SPY	ETF	191.72	192.24	191.12	192.15	26862160.0
2015-10-01 16:00:00	SPY	ETF	192.15	192.61	192.11	192.52	6218264.0
2015-10-01 17:00:00	SPY	ETF	192.52	192.65	192.13	192.49	405297.0
2015-10-01 18:00:00	SPY	ETF	192.49	192.57	192.41	192.53	313620.0
2015-10-01 19:00:00	SPY	ETF	192.53	192.75	192.35	192.41	273555.0
2015-10-01 04:00:00	QQQ	ETF	103.0	103.04	102.74	102.74	45503.0
2015-10-01 05:00:00	QQQ	ETF	102.85	102.91	102.73	102.83	4600.0
2015-10-01 06:00:00	QQQ	ETF	102.67	102.76	102.49	102.65	39150.0
2015-10-01 07:00:00	QQQ	ETF	102.67	102.67	102.0	102.03	311645.0
2015-10-01 08:00:00	QQQ	ETF	102.02	102.62	101.8	101.88	395406.0
2015-10-01 09:00:00	QQQ	ETF	101.88	102.06	100.9338	100.969	6678288.0
2015-10-01 10:00:00	QQQ	ETF	100.965	101.69	100.71	101.11	6971565.0
2015-10-01 11:00:00	QQQ	ETF	101.12	101.43	100.81	100.97	4714276.0
2015-10-01 12:00:00	QQQ	ETF	100.97	101.24	100.59	101.06	3138973.0
2015-10-01 13:00:00	QQQ	ETF	101.05	101.24	100.6902	101.23	2417928.0
2015-10-01 14:00:00	QQQ	ETF	101.24	101.86	101.1	101.795	4785104.0
2015-10-01 15:00:00	QQQ	ETF	101.8	102.23	101.53	102.17	6247030.0
2015-10-01 16:00:00	QQQ	ETF	102.19	102.45	102.1608	102.45	856703.0
2015-10-01 17:00:00	QQQ	ETF	102.38	102.44	102.38	102.43	1152.0
2015-10-01 18:00:00	QQQ	ETF	102.37	102.46	102.35	102.46	61712.0
2015-10-01 19:00:00	QQQ	ETF	102.42	102.5	102.36	102.38	6320.0
2015-10-01 04:00:00	IWM	ETF	110.17	110.3	110.17	110.3	1399.0
2015-10-01 05:00:00	IWM	ETF	110.25	110.25	110.15	110.15	300.0
2015-10-01 06:00:00	IWM	ETF	110.04	110.04	109.96	109.96	92325.0
2015-10-01 07:00:00	IWM	ETF	109.96	109.96	109.53	109.58	188658.0
2015-10-01 08:00:00	IWM	ETF	109.37	109.58	109.2	109.32	101916.0
2015-10-01 09:00:00	IWM	ETF	109.3	109.68	108.58	108.65	4242417.0
2015-10-01 10:00:00	IWM	ETF	108.65	109.4	108.26	108.68	5498804.0
2015-10-01 11:00:00	IWM	ETF	108.68	108.86	107.64	107.76	6988583.0
2015-10-01 12:00:00	IWM	ETF	107.74	108.225	107.43	107.91	4975799.0
2015-10-01 13:00:00	IWM	ETF	107.9	108.29	107.515	108.27	3504775.0
2015-10-01 14:00:00	IWM	ETF	108.26	108.79	108.065	108.71	5031905.0
2015-10-01 15:00:00	IWM	ETF	108.71	109.04	108.31	109.03	9669751.0
2015-10-01 16:00:00	IWM	ETF	109.02	109.27	107.7139	109.27	1073824.0
2015-10-01 17:00:00	IWM	ETF	109.28	109.35	109.28	109.3	27866.0
2015-10-01 18:00:00	IWM	ETF	109.35	109.35	109.28	109.28	500.0
2015-10-01 04:00:00	DIA	ETF	164.02	164.02	164.02	164.02	590.0
2015-10-01 08:00:00	DIA	ETF	162.75	163.08	162.75	162.78	6106.0
2015-10-01 09:00:00	DIA	ETF	162.81	163.29	161.91	161.96	699423.0

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

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