PREVIEW / etf_1hour / 2017-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-24.parquet
  size:    275 KB
  rows:    9,042

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
2017-07-24 04:00:00	SPY	ETF	246.51	246.51	246.25	246.37	20620.0
2017-07-24 05:00:00	SPY	ETF	246.41	246.41	246.26	246.37	4563.0
2017-07-24 06:00:00	SPY	ETF	246.39	246.56	246.39	246.56	1705.0
2017-07-24 07:00:00	SPY	ETF	246.6	246.65	246.54	246.6	82351.0
2017-07-24 08:00:00	SPY	ETF	246.57	246.88	246.56	246.76	2080841.0
2017-07-24 09:00:00	SPY	ETF	246.75	246.85	246.42	246.6	3583249.0
2017-07-24 10:00:00	SPY	ETF	246.605	246.7788	246.37	246.44	4686108.0
2017-07-24 11:00:00	SPY	ETF	246.44	246.59	246.28	246.567	3798884.0
2017-07-24 12:00:00	SPY	ETF	246.57	246.71	246.56	246.67	2287199.0
2017-07-24 13:00:00	SPY	ETF	246.66	246.71	246.59	246.625	2921088.0
2017-07-24 14:00:00	SPY	ETF	246.63	246.84	246.62	246.79	3073768.0
2017-07-24 15:00:00	SPY	ETF	246.7942	246.98	246.69	246.81	11113837.0
2017-07-24 16:00:00	SPY	ETF	246.8	246.82	246.55	246.64	12030282.0
2017-07-24 17:00:00	SPY	ETF	246.6	246.67	246.57	246.65	129821.0
2017-07-24 18:00:00	SPY	ETF	246.62	246.7	246.58	246.66	75286.0
2017-07-24 19:00:00	SPY	ETF	246.66	246.68	246.65	246.68	13649.0
2017-07-24 20:00:00	SPY	ETF	246.82	246.82	246.6423	246.6463	213000.0
2017-07-24 04:00:00	QQQ	ETF	143.89	143.92	143.81	143.92	2066.0
2017-07-24 05:00:00	QQQ	ETF	143.81	143.87	143.77	143.87	3504.0
2017-07-24 06:00:00	QQQ	ETF	143.9	144.0	143.9	143.91	31236.0
2017-07-24 07:00:00	QQQ	ETF	143.9	143.93	143.88	143.89	47318.0
2017-07-24 08:00:00	QQQ	ETF	143.93	144.17	143.86	144.05	278646.0
2017-07-24 09:00:00	QQQ	ETF	144.07	144.26	143.98	144.21	1847930.0
2017-07-24 10:00:00	QQQ	ETF	144.2	144.26	144.05	144.1747	2172355.0
2017-07-24 11:00:00	QQQ	ETF	144.17	144.1746	143.92	144.15	1812433.0
2017-07-24 12:00:00	QQQ	ETF	144.16	144.41	144.15	144.39	1642182.0
2017-07-24 13:00:00	QQQ	ETF	144.4	144.455	144.35	144.35	960689.0
2017-07-24 14:00:00	QQQ	ETF	144.35	144.57	144.34	144.56	1836617.0
2017-07-24 15:00:00	QQQ	ETF	144.56	144.87	144.5	144.73	5185905.0
2017-07-24 16:00:00	QQQ	ETF	144.72	144.93	144.17	144.25	2979855.0
2017-07-24 17:00:00	QQQ	ETF	144.24	144.29	144.1	144.1	57077.0
2017-07-24 18:00:00	QQQ	ETF	144.2	144.3	144.1	144.3	20559.0
2017-07-24 19:00:00	QQQ	ETF	144.27	144.3	144.24	144.28	14886.0
2017-07-24 04:00:00	IWM	ETF	142.01	142.03	141.9	141.9	4598.0
2017-07-24 05:00:00	IWM	ETF	141.96	141.96	141.86	141.88	1372.0
2017-07-24 06:00:00	IWM	ETF	141.89	142.05	141.89	142.0	5936.0
2017-07-24 07:00:00	IWM	ETF	142.04	142.1	142.04	142.09	4699.0
2017-07-24 08:00:00	IWM	ETF	142.06	142.29	142.01	142.26	142225.0
2017-07-24 09:00:00	IWM	ETF	142.22	142.44	142.02	142.37	2534006.0
2017-07-24 10:00:00	IWM	ETF	142.36	142.51	142.11	142.17	2385759.0
2017-07-24 11:00:00	IWM	ETF	142.17	142.34	141.97	142.21	1533768.0
2017-07-24 12:00:00	IWM	ETF	142.22	142.35	142.09	142.32	830197.0
2017-07-24 13:00:00	IWM	ETF	142.3172	142.44	142.17	142.36	925936.0
2017-07-24 14:00:00	IWM	ETF	142.35	142.7299	142.34	142.6299	1460879.0
2017-07-24 15:00:00	IWM	ETF	142.6299	142.82	142.57	142.74	2531467.0
2017-07-24 16:00:00	IWM	ETF	142.75	142.84	142.5541	142.6	547772.0
2017-07-24 17:00:00	IWM	ETF	142.65	142.66	142.65	142.65	4731.0
2017-07-24 18:00:00	IWM	ETF	142.6	142.65	142.6	142.61	3027.0
2017-07-24 19:00:00	IWM	ETF	142.61	142.7694	142.61	142.65	400300.0
2017-07-24 08:00:00	DIA	ETF	215.1	215.34	215.1	215.34	2200.0

> showing 50 of 9,042 rows — these rows as CSV

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