PREVIEW / etf_1hour / 2016-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-04-07.parquet
  size:    250 KB
  rows:    7,972

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-04-07 04:00:00	SPY	ETF	206.0	206.21	205.94	205.94	33719.0
2016-04-07 05:00:00	SPY	ETF	205.96	205.96	205.24	205.44	248017.0
2016-04-07 06:00:00	SPY	ETF	205.44	205.6	205.3	205.4	85615.0
2016-04-07 07:00:00	SPY	ETF	205.45	205.67	205.21	205.36	368595.0
2016-04-07 08:00:00	SPY	ETF	206.12	206.12	205.26	205.45	719734.0
2016-04-07 09:00:00	SPY	ETF	205.43	205.51	205.02	205.3	10309493.0
2016-04-07 10:00:00	SPY	ETF	205.31	205.56	204.44	204.66	16312388.0
2016-04-07 11:00:00	SPY	ETF	204.66	204.69	204.18	204.51	11614288.0
2016-04-07 12:00:00	SPY	ETF	204.515	204.57	204.04	204.42	9956612.0
2016-04-07 13:00:00	SPY	ETF	204.43	204.77	203.76	203.83	9278010.0
2016-04-07 14:00:00	SPY	ETF	203.83	203.83	203.125	203.17	18371708.0
2016-04-07 15:00:00	SPY	ETF	203.17	204.07	203.09	203.94	27734045.0
2016-04-07 16:00:00	SPY	ETF	203.94	206.3979	203.7726	203.96	4803938.0
2016-04-07 17:00:00	SPY	ETF	203.96	203.98	203.84	203.88	518701.0
2016-04-07 18:00:00	SPY	ETF	203.85	203.85	203.56	203.62	897731.0
2016-04-07 19:00:00	SPY	ETF	203.64	203.68	203.43	203.45	515016.0
2016-04-07 04:00:00	QQQ	ETF	110.5	110.53	110.39	110.39	2500.0
2016-04-07 05:00:00	QQQ	ETF	110.33	110.33	110.04	110.04	1664.0
2016-04-07 06:00:00	QQQ	ETF	110.05	110.2	110.05	110.16	42072.0
2016-04-07 07:00:00	QQQ	ETF	110.24	110.24	110.01	110.1	19348.0
2016-04-07 08:00:00	QQQ	ETF	110.18	110.26	110.04	110.17	109958.0
2016-04-07 09:00:00	QQQ	ETF	110.16	110.225	109.8	109.9401	2829504.0
2016-04-07 10:00:00	QQQ	ETF	109.95	110.155	109.34	109.379	4040441.0
2016-04-07 11:00:00	QQQ	ETF	109.371	109.53	109.11	109.38	3541954.0
2016-04-07 12:00:00	QQQ	ETF	109.3886	109.44	109.15	109.3701	2064763.0
2016-04-07 13:00:00	QQQ	ETF	109.37	109.62	109.0	109.05	2452383.0
2016-04-07 14:00:00	QQQ	ETF	109.05	109.05	108.64	108.68	4859457.0
2016-04-07 15:00:00	QQQ	ETF	108.68	109.1	108.61	109.03	5295782.0
2016-04-07 16:00:00	QQQ	ETF	109.04	110.1767	109.0	109.01	588487.0
2016-04-07 17:00:00	QQQ	ETF	109.0	109.07	109.0	109.05	6106.0
2016-04-07 18:00:00	QQQ	ETF	109.0	109.0	108.85	108.88	23519.0
2016-04-07 19:00:00	QQQ	ETF	108.88	108.88	108.79	108.81	7168.0
2016-04-07 05:00:00	IWM	ETF	109.56	109.56	109.53	109.53	2300.0
2016-04-07 06:00:00	IWM	ETF	109.42	109.56	109.42	109.49	3300.0
2016-04-07 07:00:00	IWM	ETF	109.56	109.61	109.38	109.4	7948.0
2016-04-07 08:00:00	IWM	ETF	109.38	109.63	109.37	109.57	208094.0
2016-04-07 09:00:00	IWM	ETF	109.57	109.88	109.23	109.63	2670029.0
2016-04-07 10:00:00	IWM	ETF	109.63	109.75	108.9	109.21	4321531.0
2016-04-07 11:00:00	IWM	ETF	109.21	109.36	108.83	109.2	2743226.0
2016-04-07 12:00:00	IWM	ETF	109.1901	109.27	108.84	109.105	1755586.0
2016-04-07 13:00:00	IWM	ETF	109.09	109.4	108.66	108.71	2538664.0
2016-04-07 14:00:00	IWM	ETF	108.7	108.705	108.15	108.17	4341090.0
2016-04-07 15:00:00	IWM	ETF	108.17	108.75	108.13	108.68	6502229.0
2016-04-07 16:00:00	IWM	ETF	108.67	108.88	108.66	108.74	1312358.0
2016-04-07 17:00:00	IWM	ETF	108.78	108.78	108.74	108.74	10271.0
2016-04-07 18:00:00	IWM	ETF	108.71	108.71	108.58	108.6	8381.0
2016-04-07 19:00:00	IWM	ETF	108.56	108.61	108.4	108.4	2293.0
2016-04-07 07:00:00	DIA	ETF	176.23	176.23	176.2	176.2	1100.0
2016-04-07 08:00:00	DIA	ETF	176.21	176.34	176.12	176.25	4100.0
2016-04-07 09:00:00	DIA	ETF	176.03	176.04	175.66	176.0	613252.0

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

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