PREVIEW / etf_1hour / 2018-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-03.parquet
  size:    335 KB
  rows:    11,057

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
2018-12-03 04:00:00	SPY	ETF	281.0	281.27	280.1	281.03	97548.0
2018-12-03 05:00:00	SPY	ETF	281.03	281.1	280.61	280.68	55580.0
2018-12-03 06:00:00	SPY	ETF	280.92	281.27	280.1	280.29	323946.0
2018-12-03 07:00:00	SPY	ETF	280.2	280.28	279.69	279.9	1014916.0
2018-12-03 08:00:00	SPY	ETF	280.25	281.28	275.65	280.02	1328705.0
2018-12-03 09:00:00	SPY	ETF	280.02	281.0	278.63	278.92	13354829.0
2018-12-03 10:00:00	SPY	ETF	278.94	279.76	278.03	278.17	15953575.0
2018-12-03 11:00:00	SPY	ETF	278.17	278.7	277.505	277.68	12504974.0
2018-12-03 12:00:00	SPY	ETF	277.69	279.02	277.67	278.5075	6605019.0
2018-12-03 13:00:00	SPY	ETF	278.5061	279.22	277.99	278.2925	8599078.0
2018-12-03 14:00:00	SPY	ETF	278.3	278.92	277.65	278.6044	9616206.0
2018-12-03 15:00:00	SPY	ETF	278.6	279.4676	278.23	279.23	20790450.0
2018-12-03 16:00:00	SPY	ETF	279.22	279.56	278.93	279.08	11656453.0
2018-12-03 17:00:00	SPY	ETF	279.11	279.26	279.06	279.08	116540.0
2018-12-03 18:00:00	SPY	ETF	279.07	279.08	278.73	278.8	140098.0
2018-12-03 19:00:00	SPY	ETF	278.85	278.9	278.48	278.49	51011.0
2018-12-03 04:00:00	QQQ	ETF	173.6	173.87	173.59	173.87	75931.0
2018-12-03 05:00:00	QQQ	ETF	173.83	173.88	173.5	173.58	111861.0
2018-12-03 06:00:00	QQQ	ETF	173.56	173.57	173.21	173.29	136541.0
2018-12-03 07:00:00	QQQ	ETF	173.28	173.3	172.97	173.2	349525.0
2018-12-03 08:00:00	QQQ	ETF	173.05	173.98	172.73	172.87	874886.0
2018-12-03 09:00:00	QQQ	ETF	172.85	173.31	171.5	171.87	7138290.0
2018-12-03 10:00:00	QQQ	ETF	171.88	173.12	171.62	171.7	10147229.0
2018-12-03 11:00:00	QQQ	ETF	171.7	172.29	171.3	171.4	4917322.0
2018-12-03 12:00:00	QQQ	ETF	171.4	172.21	171.39	171.85	2846952.0
2018-12-03 13:00:00	QQQ	ETF	171.87	172.32	171.22	171.5	3705056.0
2018-12-03 14:00:00	QQQ	ETF	171.51	172.01	171.04	171.76	3743515.0
2018-12-03 15:00:00	QQQ	ETF	171.76	172.36	171.41	172.27	8369232.0
2018-12-03 16:00:00	QQQ	ETF	172.27	172.33	171.92	171.99	1724530.0
2018-12-03 17:00:00	QQQ	ETF	172.11	172.17	171.92	172.01	47744.0
2018-12-03 18:00:00	QQQ	ETF	172.03	172.03	171.73	171.76	44056.0
2018-12-03 19:00:00	QQQ	ETF	171.75	171.87	171.53	171.53	52974.0
2018-12-03 04:00:00	IWM	ETF	155.3	155.3	155.05	155.15	10589.0
2018-12-03 05:00:00	IWM	ETF	155.14	155.14	154.79	154.79	14700.0
2018-12-03 06:00:00	IWM	ETF	155.21	155.21	154.49	154.49	20263.0
2018-12-03 07:00:00	IWM	ETF	154.55	154.55	154.3	154.31	50382.0
2018-12-03 08:00:00	IWM	ETF	154.29	155.26	154.05	154.05	105512.0
2018-12-03 09:00:00	IWM	ETF	154.0	154.48	153.07	153.3	3697615.0
2018-12-03 10:00:00	IWM	ETF	153.3	153.72	152.76	152.94	3456248.0
2018-12-03 11:00:00	IWM	ETF	152.94	153.12	152.02	152.15	2924094.0
2018-12-03 12:00:00	IWM	ETF	152.16	153.41	152.15	153.26	2042641.0
2018-12-03 13:00:00	IWM	ETF	153.2675	153.81	153.02	153.2451	1550579.0
2018-12-03 14:00:00	IWM	ETF	153.25	153.72	152.86	153.61	1272488.0
2018-12-03 15:00:00	IWM	ETF	153.62	154.22	153.41	154.12	4658140.0
2018-12-03 16:00:00	IWM	ETF	154.08	154.23	153.87	153.99	1499300.0
2018-12-03 17:00:00	IWM	ETF	153.86	153.93	153.81	153.81	3741.0
2018-12-03 18:00:00	IWM	ETF	153.86	153.86	153.65	153.71	5570.0
2018-12-03 19:00:00	IWM	ETF	153.68	153.73	153.51	153.51	4880.0
2018-12-03 04:00:00	DIA	ETF	259.95	260.71	259.95	260.6	10527.0
2018-12-03 05:00:00	DIA	ETF	260.78	260.87	260.4	260.43	13190.0

> showing 50 of 11,057 rows — these rows as CSV

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