PREVIEW / etf_1hour / 2018-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-07.parquet
  size:    303 KB
  rows:    9,939

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-06-07 04:00:00	SPY	ETF	278.15	278.15	277.7	277.72	19866.0
2018-06-07 05:00:00	SPY	ETF	277.7	277.83	277.65	277.75	30371.0
2018-06-07 06:00:00	SPY	ETF	277.77	277.81	277.56	277.8	21169.0
2018-06-07 07:00:00	SPY	ETF	277.89	278.0	277.66	277.78	158856.0
2018-06-07 08:00:00	SPY	ETF	277.92	278.23	277.4	277.8	351748.0
2018-06-07 09:00:00	SPY	ETF	277.8	278.28	277.66	278.03	4916852.0
2018-06-07 10:00:00	SPY	ETF	278.025	278.26	276.92	277.5	9452901.0
2018-06-07 11:00:00	SPY	ETF	277.51	277.9275	277.18	277.39	6601777.0
2018-06-07 12:00:00	SPY	ETF	277.39	277.7675	277.01	277.27	4795229.0
2018-06-07 13:00:00	SPY	ETF	277.27	277.37	276.34	276.5	9004627.0
2018-06-07 14:00:00	SPY	ETF	276.5	277.41	276.35	277.19	8209279.0
2018-06-07 15:00:00	SPY	ETF	277.19	277.55	276.82	277.33	18592916.0
2018-06-07 16:00:00	SPY	ETF	277.33	277.8	276.5	277.6	9684172.0
2018-06-07 17:00:00	SPY	ETF	277.61	277.61	277.36	277.43	44079.0
2018-06-07 18:00:00	SPY	ETF	277.45	277.55	277.41	277.43	30366.0
2018-06-07 19:00:00	SPY	ETF	277.42	277.61	277.3	277.57	31797.0
2018-06-07 04:00:00	QQQ	ETF	176.2	176.27	176.01	176.1	5300.0
2018-06-07 05:00:00	QQQ	ETF	176.05	176.1	175.99	176.04	4100.0
2018-06-07 06:00:00	QQQ	ETF	175.98	175.98	175.84	175.89	12400.0
2018-06-07 07:00:00	QQQ	ETF	175.98	176.01	175.75	175.85	83300.0
2018-06-07 08:00:00	QQQ	ETF	175.97	175.97	175.7	175.79	223607.0
2018-06-07 09:00:00	QQQ	ETF	175.77	175.93	175.37	175.58	2918610.0
2018-06-07 10:00:00	QQQ	ETF	175.57	175.66	174.01	174.605	8072917.0
2018-06-07 11:00:00	QQQ	ETF	174.62	174.946	174.25	174.52	3932522.0
2018-06-07 12:00:00	QQQ	ETF	174.52	174.77	173.94	174.17	3018248.0
2018-06-07 13:00:00	QQQ	ETF	174.17	174.2863	173.55	173.745	5214511.0
2018-06-07 14:00:00	QQQ	ETF	173.7448	174.6	173.59	174.39	4196638.0
2018-06-07 15:00:00	QQQ	ETF	174.39	174.67	174.15	174.49	5929039.0
2018-06-07 16:00:00	QQQ	ETF	174.47	174.7	174.33	174.66	1920830.0
2018-06-07 17:00:00	QQQ	ETF	174.67	174.67	174.56	174.56	15194.0
2018-06-07 18:00:00	QQQ	ETF	174.58	174.6	174.49	174.51	26303.0
2018-06-07 19:00:00	QQQ	ETF	174.45	174.59	174.37	174.49	20786.0
2018-06-07 05:00:00	IWM	ETF	166.94	166.94	166.92	166.92	1000.0
2018-06-07 06:00:00	IWM	ETF	166.93	167.02	166.93	167.02	1000.0
2018-06-07 07:00:00	IWM	ETF	167.09	167.18	166.87	166.87	79125.0
2018-06-07 08:00:00	IWM	ETF	167.02	167.02	166.77	166.94	85523.0
2018-06-07 09:00:00	IWM	ETF	166.92	167.23	166.82	166.89	1604306.0
2018-06-07 10:00:00	IWM	ETF	166.88	166.96	166.16	166.58	2445081.0
2018-06-07 11:00:00	IWM	ETF	166.59	166.63	165.95	166.135	1728574.0
2018-06-07 12:00:00	IWM	ETF	166.13	166.25	165.85	166.005	1524363.0
2018-06-07 13:00:00	IWM	ETF	166.0	166.04	165.23	165.3	2071079.0
2018-06-07 14:00:00	IWM	ETF	165.3	166.08	165.24	166.01	2480549.0
2018-06-07 15:00:00	IWM	ETF	166.005	166.42	165.9	166.0	3126716.0
2018-06-07 16:00:00	IWM	ETF	166.02	166.42	165.99	166.35	494671.0
2018-06-07 17:00:00	IWM	ETF	166.34	166.34	166.3	166.3	714.0
2018-06-07 18:00:00	IWM	ETF	166.2	166.31	166.2	166.31	5336.0
2018-06-07 19:00:00	IWM	ETF	166.22	166.29	166.14	166.25	8009.0
2018-06-07 04:00:00	DIA	ETF	252.07	252.07	252.07	252.07	100.0
2018-06-07 06:00:00	DIA	ETF	251.83	251.83	251.83	251.83	100.0
2018-06-07 07:00:00	DIA	ETF	252.09	252.35	252.0	252.08	6907.0

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

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