PREVIEW / etf_1hour / 2015-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-12.parquet
  size:    242 KB
  rows:    7,709

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-11-12 04:00:00	SPY	ETF	208.16	208.16	207.62	207.92	17850.0
2015-11-12 05:00:00	SPY	ETF	207.62	207.62	207.3	207.38	24807.0
2015-11-12 06:00:00	SPY	ETF	207.35	207.8	207.3	207.64	30881.0
2015-11-12 07:00:00	SPY	ETF	207.72	207.74	207.29	207.29	165377.0
2015-11-12 08:00:00	SPY	ETF	207.59	207.67	206.88	207.07	1186559.0
2015-11-12 09:00:00	SPY	ETF	207.06	207.1	206.13	206.525	17321940.0
2015-11-12 10:00:00	SPY	ETF	206.525	206.94	206.06	206.9	19000041.0
2015-11-12 11:00:00	SPY	ETF	206.91	207.06	206.1	206.37	14005628.0
2015-11-12 12:00:00	SPY	ETF	206.36	206.47	205.62	206.1273	14683551.0
2015-11-12 13:00:00	SPY	ETF	206.13	206.48	205.97	206.24	8576001.0
2015-11-12 14:00:00	SPY	ETF	206.24	206.3	205.3	205.54	12665624.0
2015-11-12 15:00:00	SPY	ETF	205.54	205.73	204.82	204.89	26429998.0
2015-11-12 16:00:00	SPY	ETF	204.87	206.93	204.7	204.77	5489779.0
2015-11-12 17:00:00	SPY	ETF	204.75	207.02	204.68	204.74	205491.0
2015-11-12 18:00:00	SPY	ETF	204.76	205.03	204.57	204.99	200339.0
2015-11-12 19:00:00	SPY	ETF	205.0	205.14	204.89	204.9	69429.0
2015-11-12 04:00:00	QQQ	ETF	113.14	113.14	113.14	113.14	2323.0
2015-11-12 05:00:00	QQQ	ETF	112.97	112.97	112.97	112.97	100.0
2015-11-12 06:00:00	QQQ	ETF	112.95	113.15	112.9	113.15	1400.0
2015-11-12 07:00:00	QQQ	ETF	113.12	113.14	112.92	112.92	22900.0
2015-11-12 08:00:00	QQQ	ETF	112.91	113.04	112.71	112.88	107657.0
2015-11-12 09:00:00	QQQ	ETF	112.88	112.88	112.44	112.87	3572953.0
2015-11-12 10:00:00	QQQ	ETF	112.86	113.155	112.65	113.132	4614276.0
2015-11-12 11:00:00	QQQ	ETF	113.13	113.23	112.71	112.8906	3582882.0
2015-11-12 12:00:00	QQQ	ETF	112.8901	112.96	112.56	112.8322	2666954.0
2015-11-12 13:00:00	QQQ	ETF	112.84	113.02	112.71	112.8193	2040093.0
2015-11-12 14:00:00	QQQ	ETF	112.81	112.855	112.27	112.4	2961231.0
2015-11-12 15:00:00	QQQ	ETF	112.39	112.53	111.96	112.01	6405357.0
2015-11-12 16:00:00	QQQ	ETF	112.02	112.12	111.88	111.94	990028.0
2015-11-12 17:00:00	QQQ	ETF	111.98	111.98	111.81	111.86	47746.0
2015-11-12 18:00:00	QQQ	ETF	111.87	111.99	111.76	111.96	35802.0
2015-11-12 19:00:00	QQQ	ETF	112.04	112.05	111.92	111.93	13589.0
2015-11-12 06:00:00	IWM	ETF	116.96	116.96	116.96	116.96	125.0
2015-11-12 07:00:00	IWM	ETF	116.9	117.03	116.75	116.75	19000.0
2015-11-12 08:00:00	IWM	ETF	116.76	116.7865	116.53	116.57	150067.0
2015-11-12 09:00:00	IWM	ETF	116.57	116.57	115.87	115.89	3826156.0
2015-11-12 10:00:00	IWM	ETF	115.88	116.43	115.48	116.378	5789132.0
2015-11-12 11:00:00	IWM	ETF	116.39	116.49	115.66	115.92	4405829.0
2015-11-12 12:00:00	IWM	ETF	115.91	115.9924	115.51	115.74	2913832.0
2015-11-12 13:00:00	IWM	ETF	115.74	115.94	115.62	115.71	2014184.0
2015-11-12 14:00:00	IWM	ETF	115.7	115.74	114.92	115.06	4344012.0
2015-11-12 15:00:00	IWM	ETF	115.05	115.2899	114.73	114.9	7140530.0
2015-11-12 16:00:00	IWM	ETF	114.89	116.32	114.85	114.99	1364243.0
2015-11-12 17:00:00	IWM	ETF	114.9	114.9	114.9	114.9	1400.0
2015-11-12 18:00:00	IWM	ETF	114.92	114.99	114.91	114.99	4400.0
2015-11-12 19:00:00	IWM	ETF	115.06	115.1	114.95	115.08	3553.0
2015-11-12 07:00:00	DIA	ETF	176.84	176.84	176.75	176.75	1300.0
2015-11-12 08:00:00	DIA	ETF	176.79	176.79	176.41	176.43	39892.0
2015-11-12 09:00:00	DIA	ETF	176.45	176.45	175.294	175.64	801060.0
2015-11-12 10:00:00	DIA	ETF	175.64	176.13	175.32	176.1	860874.0

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

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