PREVIEW / etf_1hour / 2016-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-02-01.parquet
  size:    255 KB
  rows:    8,219

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-02-01 04:00:00	SPY	ETF	193.32	193.33	192.37	192.39	54629.0
2016-02-01 05:00:00	SPY	ETF	192.46	192.75	192.39	192.74	52300.0
2016-02-01 06:00:00	SPY	ETF	192.83	193.08	192.65	192.77	73922.0
2016-02-01 07:00:00	SPY	ETF	192.74	192.8	191.99	192.24	838585.0
2016-02-01 08:00:00	SPY	ETF	192.26	193.87	192.04	192.37	2005122.0
2016-02-01 09:00:00	SPY	ETF	192.36	193.87	192.135	192.4	15378082.0
2016-02-01 10:00:00	SPY	ETF	192.4	193.21	191.84	193.07	18594191.0
2016-02-01 11:00:00	SPY	ETF	193.07	193.46	192.67	193.2	14844152.0
2016-02-01 12:00:00	SPY	ETF	193.205	193.32	192.46	192.55	13258140.0
2016-02-01 13:00:00	SPY	ETF	192.56	193.24	192.49	193.22	10721995.0
2016-02-01 14:00:00	SPY	ETF	193.22	193.92	192.86	193.82	12793039.0
2016-02-01 15:00:00	SPY	ETF	193.82	194.58	192.7743	193.69	31554623.0
2016-02-01 16:00:00	SPY	ETF	193.71	194.21	193.0482	193.44	13331750.0
2016-02-01 17:00:00	SPY	ETF	193.44	193.52	193.39	193.42	147072.0
2016-02-01 18:00:00	SPY	ETF	193.43	193.65	192.95	193.01	177231.0
2016-02-01 19:00:00	SPY	ETF	193.01	193.11	192.92	192.98	87351.0
2016-02-01 04:00:00	QQQ	ETF	103.94	103.94	103.56	103.56	2030.0
2016-02-01 05:00:00	QQQ	ETF	103.52	103.63	103.45	103.63	7980.0
2016-02-01 06:00:00	QQQ	ETF	103.62	103.77	103.58	103.6	2491.0
2016-02-01 07:00:00	QQQ	ETF	103.62	103.65	103.29	103.45	41534.0
2016-02-01 08:00:00	QQQ	ETF	103.45	103.67	103.4	103.55	164651.0
2016-02-01 09:00:00	QQQ	ETF	103.62	103.93	103.36	103.59	3948180.0
2016-02-01 10:00:00	QQQ	ETF	103.57	104.19	103.23	104.1	4768452.0
2016-02-01 11:00:00	QQQ	ETF	104.1	104.22	103.815	104.03	3028558.0
2016-02-01 12:00:00	QQQ	ETF	104.04	104.1	103.61	103.695	1852936.0
2016-02-01 13:00:00	QQQ	ETF	103.7	104.13	103.64	104.12	2821662.0
2016-02-01 14:00:00	QQQ	ETF	104.125	104.46	103.82	104.42	2976813.0
2016-02-01 15:00:00	QQQ	ETF	104.42	104.8	104.25	104.38	6245463.0
2016-02-01 16:00:00	QQQ	ETF	104.38	105.19	104.35	104.65	2370632.0
2016-02-01 17:00:00	QQQ	ETF	104.62	104.75	104.62	104.68	18783.0
2016-02-01 18:00:00	QQQ	ETF	104.66	104.66	104.33	104.34	51253.0
2016-02-01 19:00:00	QQQ	ETF	104.31	104.34	104.26	104.28	29724.0
2016-02-01 04:00:00	IWM	ETF	102.62	102.62	102.24	102.24	698.0
2016-02-01 05:00:00	IWM	ETF	102.31	102.46	102.31	102.45	5360.0
2016-02-01 06:00:00	IWM	ETF	102.5	102.7	102.4	102.44	9300.0
2016-02-01 07:00:00	IWM	ETF	102.4	102.44	102.05	102.16	59758.0
2016-02-01 08:00:00	IWM	ETF	102.2	102.91	102.0	102.12	183039.0
2016-02-01 09:00:00	IWM	ETF	102.16	102.91	101.34	101.65	5345921.0
2016-02-01 10:00:00	IWM	ETF	101.64	102.32	101.25	102.2	4892027.0
2016-02-01 11:00:00	IWM	ETF	102.21	102.42	101.95	102.21	3699767.0
2016-02-01 12:00:00	IWM	ETF	102.215	102.33	101.8	101.89	2022950.0
2016-02-01 13:00:00	IWM	ETF	101.89	102.38	101.85	102.34	1901126.0
2016-02-01 14:00:00	IWM	ETF	102.33	102.78	102.105	102.74	2970944.0
2016-02-01 15:00:00	IWM	ETF	102.72	103.09	102.47	102.5	7090874.0
2016-02-01 16:00:00	IWM	ETF	102.48	102.65	101.3664	102.15	2053465.0
2016-02-01 17:00:00	IWM	ETF	102.13	102.2	102.12	102.2	10137.0
2016-02-01 18:00:00	IWM	ETF	102.11	102.12	102.09	102.09	5118.0
2016-02-01 19:00:00	IWM	ETF	102.12	102.23	102.02	102.05	2092.0
2016-02-01 04:00:00	DIA	ETF	164.0	164.01	163.57	163.61	83189.0
2016-02-01 05:00:00	DIA	ETF	163.55	163.61	163.5	163.5	7900.0

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

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