PREVIEW / etf_1hour / 2019-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-31.parquet
  size:    338 KB
  rows:    11,133

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-07-31 04:00:00	SPY	ETF	301.11	301.34	301.07	301.23	6948.0
2019-07-31 05:00:00	SPY	ETF	301.26	301.32	301.12	301.26	6000.0
2019-07-31 06:00:00	SPY	ETF	301.26	301.28	300.92	301.02	12852.0
2019-07-31 07:00:00	SPY	ETF	301.02	301.29	301.02	301.22	41667.0
2019-07-31 08:00:00	SPY	ETF	301.02	301.28	300.7619	301.17	296788.0
2019-07-31 09:00:00	SPY	ETF	301.16	301.16	300.73	300.8972	3837444.0
2019-07-31 10:00:00	SPY	ETF	300.89	300.95	300.3	300.65	4391143.0
2019-07-31 11:00:00	SPY	ETF	300.66	301.2	300.62	301.17	3521489.0
2019-07-31 12:00:00	SPY	ETF	301.17	301.2	300.81	300.94	3701781.0
2019-07-31 13:00:00	SPY	ETF	300.935	301.08	300.6	300.96	4003400.0
2019-07-31 14:00:00	SPY	ETF	300.91	300.91	295.2	297.62	36484204.0
2019-07-31 15:00:00	SPY	ETF	297.61	299.3	296.57	297.38	34738657.0
2019-07-31 16:00:00	SPY	ETF	297.36	297.8685	296.72	296.78	10256615.0
2019-07-31 17:00:00	SPY	ETF	296.85	297.43	296.53	296.68	404956.0
2019-07-31 18:00:00	SPY	ETF	296.57	296.82	296.13	296.76	198334.0
2019-07-31 19:00:00	SPY	ETF	296.77	297.08	296.73	296.73	65121.0
2019-07-31 04:00:00	QQQ	ETF	194.39	194.6	194.34	194.45	25421.0
2019-07-31 05:00:00	QQQ	ETF	194.54	194.57	194.44	194.55	26544.0
2019-07-31 06:00:00	QQQ	ETF	194.55	194.59	194.23	194.33	47130.0
2019-07-31 07:00:00	QQQ	ETF	194.35	194.56	194.33	194.49	83546.0
2019-07-31 08:00:00	QQQ	ETF	194.51	194.56	193.78	194.48	51319.0
2019-07-31 09:00:00	QQQ	ETF	194.49	194.49	193.83	194.11	2688538.0
2019-07-31 10:00:00	QQQ	ETF	194.12	194.43	193.79	194.12	2685720.0
2019-07-31 11:00:00	QQQ	ETF	194.12	194.4	194.0	194.285	1561723.0
2019-07-31 12:00:00	QQQ	ETF	194.29	194.31	193.91	194.04	1264274.0
2019-07-31 13:00:00	QQQ	ETF	194.05	194.155	193.72	193.96	1549739.0
2019-07-31 14:00:00	QQQ	ETF	193.93	194.15	189.32	191.39	12760569.0
2019-07-31 15:00:00	QQQ	ETF	191.37	192.65	190.92	191.19	11438883.0
2019-07-31 16:00:00	QQQ	ETF	191.2	191.4	190.6	190.71	1812154.0
2019-07-31 17:00:00	QQQ	ETF	190.79	190.86	190.55	190.55	32733.0
2019-07-31 18:00:00	QQQ	ETF	190.54	190.73	190.25	190.65	117011.0
2019-07-31 19:00:00	QQQ	ETF	190.69	190.89	190.61	190.63	55035.0
2019-07-31 05:00:00	IWM	ETF	157.92	157.92	157.92	157.92	250.0
2019-07-31 06:00:00	IWM	ETF	157.95	157.95	157.95	157.95	2500.0
2019-07-31 07:00:00	IWM	ETF	157.78	157.91	157.78	157.9	23500.0
2019-07-31 08:00:00	IWM	ETF	157.89	157.95	157.7999	157.84	49640.0
2019-07-31 09:00:00	IWM	ETF	157.81	158.54	157.73	158.19	2730216.0
2019-07-31 10:00:00	IWM	ETF	158.19	158.45	157.87	158.4	2284723.0
2019-07-31 11:00:00	IWM	ETF	158.41	159.23	158.32	159.025	3013147.0
2019-07-31 12:00:00	IWM	ETF	159.02	159.06	158.52	158.6798	1029778.0
2019-07-31 13:00:00	IWM	ETF	158.67	158.99	158.625	158.85	1724020.0
2019-07-31 14:00:00	IWM	ETF	158.82	158.95	155.55	156.91	8640329.0
2019-07-31 15:00:00	IWM	ETF	156.9	158.0	156.53	156.54	11423800.0
2019-07-31 16:00:00	IWM	ETF	156.54	156.71	156.26	156.31	1755609.0
2019-07-31 17:00:00	IWM	ETF	156.32	156.56	156.29	156.32	73135.0
2019-07-31 18:00:00	IWM	ETF	156.21	156.36	156.0	156.32	11344.0
2019-07-31 19:00:00	IWM	ETF	156.3	156.49	156.3	156.48	4353.0
2019-07-31 04:00:00	DIA	ETF	272.46	272.49	272.46	272.49	200.0
2019-07-31 07:00:00	DIA	ETF	272.5	272.54	272.5	272.54	884.0
2019-07-31 08:00:00	DIA	ETF	272.59	272.59	272.28	272.51	2944.0

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

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