PREVIEW / etf_1hour / 2017-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-27.parquet
  size:    285 KB
  rows:    9,285

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-27 04:00:00	SPY	ETF	247.9	247.9	247.71	247.71	1688.0
2017-07-27 05:00:00	SPY	ETF	247.67	247.68	247.63	247.68	7220.0
2017-07-27 06:00:00	SPY	ETF	247.68	247.83	247.67	247.78	65457.0
2017-07-27 07:00:00	SPY	ETF	247.82	247.82	247.7	247.7	82249.0
2017-07-27 08:00:00	SPY	ETF	247.74	247.85	247.69	247.8	507468.0
2017-07-27 09:00:00	SPY	ETF	247.82	248.0	247.54	247.61	4559628.0
2017-07-27 10:00:00	SPY	ETF	247.62	247.96	247.57	247.92	4233890.0
2017-07-27 11:00:00	SPY	ETF	247.93	247.94	247.73	247.92	2883375.0
2017-07-27 12:00:00	SPY	ETF	247.92	247.96	246.88	247.05	6951010.0
2017-07-27 13:00:00	SPY	ETF	247.06	247.19	245.68	246.24	21826950.0
2017-07-27 14:00:00	SPY	ETF	246.24	246.72	246.05	246.46	9024514.0
2017-07-27 15:00:00	SPY	ETF	246.47	247.24	246.2	247.22	14236889.0
2017-07-27 16:00:00	SPY	ETF	247.23	247.23	246.78	247.15	4633282.0
2017-07-27 17:00:00	SPY	ETF	247.12	247.21	247.04	247.18	281035.0
2017-07-27 18:00:00	SPY	ETF	247.17	247.83	246.92	246.96	292356.0
2017-07-27 19:00:00	SPY	ETF	246.97	247.02	246.81	246.82	52365.0
2017-07-27 04:00:00	QQQ	ETF	145.55	145.59	145.54	145.56	3376.0
2017-07-27 05:00:00	QQQ	ETF	145.5	145.5	145.5	145.5	274.0
2017-07-27 06:00:00	QQQ	ETF	145.5	145.64	145.5	145.64	3740.0
2017-07-27 07:00:00	QQQ	ETF	145.53	145.65	145.53	145.64	37853.0
2017-07-27 08:00:00	QQQ	ETF	145.64	145.89	145.51	145.79	334302.0
2017-07-27 09:00:00	QQQ	ETF	145.77	145.91	145.42	145.49	3970599.0
2017-07-27 10:00:00	QQQ	ETF	145.49	145.935	145.47	145.8375	4383434.0
2017-07-27 11:00:00	QQQ	ETF	145.84	145.96	145.69	145.86	2464344.0
2017-07-27 12:00:00	QQQ	ETF	145.8501	145.869	143.87	144.15	10235731.0
2017-07-27 13:00:00	QQQ	ETF	144.15	144.35	142.3	143.27	24135338.0
2017-07-27 14:00:00	QQQ	ETF	143.2636	143.8099	143.02	143.5	10032720.0
2017-07-27 15:00:00	QQQ	ETF	143.5	144.04	143.23	144.02	7449442.0
2017-07-27 16:00:00	QQQ	ETF	144.01	144.09	143.24	143.73	3037681.0
2017-07-27 17:00:00	QQQ	ETF	143.76	143.96	143.56	143.71	1702053.0
2017-07-27 18:00:00	QQQ	ETF	143.78	144.5137	143.52	143.56	255724.0
2017-07-27 19:00:00	QQQ	ETF	143.59	143.59	143.42	143.42	13293.0
2017-07-27 04:00:00	IWM	ETF	143.59	143.68	143.58	143.58	2084.0
2017-07-27 05:00:00	IWM	ETF	143.59	143.59	143.59	143.59	300.0
2017-07-27 06:00:00	IWM	ETF	143.53	143.64	143.53	143.64	2303.0
2017-07-27 07:00:00	IWM	ETF	143.58	143.58	143.35	143.35	9130.0
2017-07-27 08:00:00	IWM	ETF	143.37	143.44	143.2	143.27	152914.0
2017-07-27 09:00:00	IWM	ETF	143.27	143.68	142.87	142.895	2777209.0
2017-07-27 10:00:00	IWM	ETF	142.89	143.64	142.82	143.53	1913908.0
2017-07-27 11:00:00	IWM	ETF	143.53	143.64	143.345	143.53	1587560.0
2017-07-27 12:00:00	IWM	ETF	143.5292	143.6	142.52	142.69	3192739.0
2017-07-27 13:00:00	IWM	ETF	142.685	142.74	141.55	142.12	4984686.0
2017-07-27 14:00:00	IWM	ETF	142.13	142.41	141.75	142.14	2427180.0
2017-07-27 15:00:00	IWM	ETF	142.145	142.43	141.91	142.35	3249548.0
2017-07-27 16:00:00	IWM	ETF	142.34	143.0108	142.0	142.32	829830.0
2017-07-27 17:00:00	IWM	ETF	142.3	142.48	142.29	142.48	3500.0
2017-07-27 18:00:00	IWM	ETF	142.34	142.34	142.28	142.28	30400.0
2017-07-27 19:00:00	IWM	ETF	142.14	142.14	142.14	142.14	1000.0
2017-07-27 07:00:00	DIA	ETF	217.05	217.05	216.96	216.96	400.0
2017-07-27 08:00:00	DIA	ETF	216.99	217.05	216.9	217.03	5320.0

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

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