PREVIEW / etf_1hour / 2016-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-28.parquet
  size:    250 KB
  rows:    8,021

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-01-28 04:00:00	SPY	ETF	189.7	189.9	189.21	189.46	39701.0
2016-01-28 05:00:00	SPY	ETF	189.5	189.52	188.98	189.15	35871.0
2016-01-28 06:00:00	SPY	ETF	189.12	189.12	187.91	188.14	193189.0
2016-01-28 07:00:00	SPY	ETF	188.16	188.79	187.86	188.73	507187.0
2016-01-28 08:00:00	SPY	ETF	188.73	189.57	188.0	189.56	1846492.0
2016-01-28 09:00:00	SPY	ETF	189.54	190.81	188.42	189.702	20835395.0
2016-01-28 10:00:00	SPY	ETF	189.7	189.75	187.16	188.37	29388724.0
2016-01-28 11:00:00	SPY	ETF	188.38	189.27	187.77	187.79	18617827.0
2016-01-28 12:00:00	SPY	ETF	187.79	189.76	187.76	189.25	14388210.0
2016-01-28 13:00:00	SPY	ETF	189.24	189.52	188.37	188.7	15565546.0
2016-01-28 14:00:00	SPY	ETF	188.7	189.84	188.66	189.21	14073959.0
2016-01-28 15:00:00	SPY	ETF	189.21	189.67	188.94	189.14	19863225.0
2016-01-28 16:00:00	SPY	ETF	189.17	189.21	188.4	188.81	6860940.0
2016-01-28 17:00:00	SPY	ETF	188.75	188.8	188.43	188.43	160116.0
2016-01-28 18:00:00	SPY	ETF	188.44	188.74	188.3	188.72	275044.0
2016-01-28 19:00:00	SPY	ETF	188.72	188.83	188.42	188.51	144649.0
2016-01-28 20:00:00	SPY	ETF	189.1923	189.1923	189.1923	189.1923	537200.0
2016-01-28 04:00:00	QQQ	ETF	102.0	102.19	101.87	102.14	11408.0
2016-01-28 05:00:00	QQQ	ETF	101.82	101.82	101.62	101.71	7400.0
2016-01-28 06:00:00	QQQ	ETF	101.65	101.68	101.01	101.24	24170.0
2016-01-28 07:00:00	QQQ	ETF	101.1	101.64	101.07	101.59	247743.0
2016-01-28 08:00:00	QQQ	ETF	101.14	102.0	100.58	102.0	657670.0
2016-01-28 09:00:00	QQQ	ETF	102.0	102.49	101.64	101.76	7317038.0
2016-01-28 10:00:00	QQQ	ETF	101.76	101.78	100.26	101.245	10297310.0
2016-01-28 11:00:00	QQQ	ETF	101.25	101.76	100.88	100.97	5032775.0
2016-01-28 12:00:00	QQQ	ETF	100.97	102.225	100.95	101.86	4806737.0
2016-01-28 13:00:00	QQQ	ETF	101.85	102.01	101.29	101.47	5043473.0
2016-01-28 14:00:00	QQQ	ETF	101.48	102.28	101.45	101.78	3265248.0
2016-01-28 15:00:00	QQQ	ETF	101.77	102.239	101.68	101.97	6161555.0
2016-01-28 16:00:00	QQQ	ETF	101.99	102.02	100.92	101.25	2132850.0
2016-01-28 17:00:00	QQQ	ETF	101.24	101.29	100.91	100.91	44091.0
2016-01-28 18:00:00	QQQ	ETF	100.92	101.15	100.86	101.14	37877.0
2016-01-28 19:00:00	QQQ	ETF	101.15	101.16	100.96	100.96	24222.0
2016-01-28 04:00:00	IWM	ETF	100.35	100.54	100.25	100.46	3108.0
2016-01-28 05:00:00	IWM	ETF	100.2	100.26	100.2	100.26	530.0
2016-01-28 06:00:00	IWM	ETF	100.13	100.17	99.72	99.72	9600.0
2016-01-28 07:00:00	IWM	ETF	99.55	100.02	99.55	99.98	93678.0
2016-01-28 08:00:00	IWM	ETF	100.04	100.39	99.68	100.39	263844.0
2016-01-28 09:00:00	IWM	ETF	100.41	100.95	100.22	100.64	5269640.0
2016-01-28 10:00:00	IWM	ETF	100.64	100.72	99.215	100.13	9074144.0
2016-01-28 11:00:00	IWM	ETF	100.13	100.69	99.63	99.65	5311362.0
2016-01-28 12:00:00	IWM	ETF	99.645	100.53	99.62	100.24	3871925.0
2016-01-28 13:00:00	IWM	ETF	100.23	100.41	99.52	99.59	3930026.0
2016-01-28 14:00:00	IWM	ETF	99.58	100.25	99.545	99.73	4062090.0
2016-01-28 15:00:00	IWM	ETF	99.73	99.92	99.35	99.68	6964321.0
2016-01-28 16:00:00	IWM	ETF	99.69	99.73	99.28	99.48	1397251.0
2016-01-28 17:00:00	IWM	ETF	99.5	99.5	99.36	99.36	5534.0
2016-01-28 18:00:00	IWM	ETF	99.32	99.45	99.32	99.32	2578.0
2016-01-28 19:00:00	IWM	ETF	99.49	99.55	99.49	99.55	600.0
2016-01-28 04:00:00	DIA	ETF	160.14	160.18	159.95	160.18	1500.0

> showing 50 of 8,021 rows — these rows as CSV

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