PREVIEW / etf_1hour / 2019-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-03-11.parquet
  size:    325 KB
  rows:    10,721

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
2019-03-11 04:00:00	SPY	ETF	275.33	275.41	274.98	274.98	6364.0
2019-03-11 05:00:00	SPY	ETF	274.94	275.25	274.92	275.25	9990.0
2019-03-11 06:00:00	SPY	ETF	275.32	275.33	275.0	275.2	22013.0
2019-03-11 07:00:00	SPY	ETF	275.22	275.47	275.07	275.29	90506.0
2019-03-11 08:00:00	SPY	ETF	275.22	275.7	275.01	275.55	353126.0
2019-03-11 09:00:00	SPY	ETF	275.55	276.33	275.21	276.29	6521518.0
2019-03-11 10:00:00	SPY	ETF	276.29	277.29	276.25	277.25	8734235.0
2019-03-11 11:00:00	SPY	ETF	277.24	277.81	277.12	277.78	7250757.0
2019-03-11 12:00:00	SPY	ETF	277.78	277.98	277.56	277.65	4971372.0
2019-03-11 13:00:00	SPY	ETF	277.65	278.25	277.62	278.19	5388888.0
2019-03-11 14:00:00	SPY	ETF	278.2	278.34	277.95	278.145	6005732.0
2019-03-11 15:00:00	SPY	ETF	278.145	278.62	278.01	278.5	15329412.0
2019-03-11 16:00:00	SPY	ETF	278.5	278.97	275.68	278.77	6880401.0
2019-03-11 17:00:00	SPY	ETF	278.75	278.84	278.61	278.82	1344321.0
2019-03-11 18:00:00	SPY	ETF	278.77	279.6	278.64	279.6	201290.0
2019-03-11 19:00:00	SPY	ETF	279.48	279.54	279.31	279.38	99735.0
2019-03-11 04:00:00	QQQ	ETF	171.6	171.89	171.54	171.55	23968.0
2019-03-11 05:00:00	QQQ	ETF	171.54	171.78	171.49	171.76	58937.0
2019-03-11 06:00:00	QQQ	ETF	171.8	171.9	171.7	171.83	20443.0
2019-03-11 07:00:00	QQQ	ETF	171.84	172.06	171.73	171.88	60288.0
2019-03-11 08:00:00	QQQ	ETF	171.84	172.23	171.59	172.12	302218.0
2019-03-11 09:00:00	QQQ	ETF	172.12	173.09	171.84	173.02	3044543.0
2019-03-11 10:00:00	QQQ	ETF	173.02	173.67	173.02	173.65	4089782.0
2019-03-11 11:00:00	QQQ	ETF	173.649	174.2	173.57	174.15	3944662.0
2019-03-11 12:00:00	QQQ	ETF	174.15	174.39	174.02	174.17	2728447.0
2019-03-11 13:00:00	QQQ	ETF	174.17	174.581	174.12	174.54	1951795.0
2019-03-11 14:00:00	QQQ	ETF	174.53	174.64	174.3	174.56	1995813.0
2019-03-11 15:00:00	QQQ	ETF	174.56	174.85	174.46	174.74	6784431.0
2019-03-11 16:00:00	QQQ	ETF	174.74	175.0	174.6	174.93	1883290.0
2019-03-11 17:00:00	QQQ	ETF	174.91	174.93	174.73	174.73	151757.0
2019-03-11 18:00:00	QQQ	ETF	174.9	175.5	174.77	175.48	46215.0
2019-03-11 19:00:00	QQQ	ETF	175.46	175.48	175.3	175.42	69724.0
2019-03-11 04:00:00	IWM	ETF	151.99	151.99	151.86	151.86	4250.0
2019-03-11 05:00:00	IWM	ETF	151.91	152.02	151.91	152.02	11900.0
2019-03-11 06:00:00	IWM	ETF	152.01	152.03	151.92	151.92	3778.0
2019-03-11 07:00:00	IWM	ETF	151.87	152.05	151.87	151.9	17778.0
2019-03-11 08:00:00	IWM	ETF	151.84	152.26	151.84	152.23	41002.0
2019-03-11 09:00:00	IWM	ETF	152.15	152.61	151.9	152.44	1863707.0
2019-03-11 10:00:00	IWM	ETF	152.41	153.01	152.22	152.89	2674158.0
2019-03-11 11:00:00	IWM	ETF	152.88	153.38	152.82	153.37	1938634.0
2019-03-11 12:00:00	IWM	ETF	153.37	153.95	153.29	153.855	2478043.0
2019-03-11 13:00:00	IWM	ETF	153.85	154.16	153.83	153.97	1866190.0
2019-03-11 14:00:00	IWM	ETF	153.96	153.96	153.66	153.81	1317927.0
2019-03-11 15:00:00	IWM	ETF	153.81	154.31	153.68	154.26	4356344.0
2019-03-11 16:00:00	IWM	ETF	154.29	154.41	154.16	154.29	990243.0
2019-03-11 17:00:00	IWM	ETF	154.29	154.39	154.29	154.29	181768.0
2019-03-11 18:00:00	IWM	ETF	154.31	154.76	154.21	154.76	143854.0
2019-03-11 19:00:00	IWM	ETF	154.74	154.77	154.66	154.69	11200.0
2019-03-11 04:00:00	DIA	ETF	254.49	254.49	253.54	253.54	2505.0
2019-03-11 05:00:00	DIA	ETF	253.33	253.5	253.14	253.5	1015.0

> showing 50 of 10,721 rows — these rows as CSV

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