PREVIEW / etf_1hour / 2020-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-03-10.parquet
  size:    401 KB
  rows:    13,605

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
2020-03-10 04:00:00	SPY	ETF	281.96	286.04	281.24	285.9	254638.0
2020-03-10 05:00:00	SPY	ETF	285.9	288.33	285.1	287.91	292103.0
2020-03-10 06:00:00	SPY	ETF	287.96	288.45	286.91	287.86	680996.0
2020-03-10 07:00:00	SPY	ETF	287.85	288.01	285.6	286.0	1074128.0
2020-03-10 08:00:00	SPY	ETF	285.96	287.8904	281.92	284.5	3232617.0
2020-03-10 09:00:00	SPY	ETF	284.3	285.18	274.23	282.64	23146057.0
2020-03-10 10:00:00	SPY	ETF	282.63	284.79	278.565	278.6	29774765.0
2020-03-10 11:00:00	SPY	ETF	278.59	280.31	273.5	275.46	42090382.0
2020-03-10 12:00:00	SPY	ETF	275.465	280.28	275.46	278.36	31565785.0
2020-03-10 13:00:00	SPY	ETF	278.35	280.89	276.47	277.17	26519955.0
2020-03-10 14:00:00	SPY	ETF	277.1962	283.69	276.11	282.49	32928471.0
2020-03-10 15:00:00	SPY	ETF	282.49	288.52	282.01	288.44	62537507.0
2020-03-10 16:00:00	SPY	ETF	288.46	288.83	277.4	288.07	17905891.0
2020-03-10 17:00:00	SPY	ETF	288.07	288.42	286.5	286.6999	972969.0
2020-03-10 18:00:00	SPY	ETF	286.58	288.42	283.65	284.2	959922.0
2020-03-10 19:00:00	SPY	ETF	284.15	284.9	281.65	283.14	577054.0
2020-03-10 04:00:00	QQQ	ETF	199.8	202.16	199.09	202.13	156602.0
2020-03-10 05:00:00	QQQ	ETF	202.15	203.28	201.43	203.1	144110.0
2020-03-10 06:00:00	QQQ	ETF	203.09	203.66	202.58	203.3	364177.0
2020-03-10 07:00:00	QQQ	ETF	203.18	203.3	201.54	201.84	499973.0
2020-03-10 08:00:00	QQQ	ETF	202.95	203.67	199.29	200.83	1972658.0
2020-03-10 09:00:00	QQQ	ETF	200.8	201.23	198.65	199.94	10119611.0
2020-03-10 10:00:00	QQQ	ETF	199.92	201.5	197.36	197.39	8591485.0
2020-03-10 11:00:00	QQQ	ETF	197.37	198.68	193.6802	195.41	12576472.0
2020-03-10 12:00:00	QQQ	ETF	195.42	198.7	195.42	197.47	10209261.0
2020-03-10 13:00:00	QQQ	ETF	197.47	199.25	196.19	196.65	8470724.0
2020-03-10 14:00:00	QQQ	ETF	196.71	200.73	195.62	200.09	9947204.0
2020-03-10 15:00:00	QQQ	ETF	200.11	204.3	199.82	204.25	15059276.0
2020-03-10 16:00:00	QQQ	ETF	204.25	204.55	193.9271	203.99	2076074.0
2020-03-10 17:00:00	QQQ	ETF	204.14	204.14	202.8	203.0	117818.0
2020-03-10 18:00:00	QQQ	ETF	203.0	203.35	200.75	201.2	213655.0
2020-03-10 19:00:00	QQQ	ETF	200.88	201.59	199.34	200.45	262469.0
2020-03-10 04:00:00	IWM	ETF	134.46	136.0	134.0	136.0	13700.0
2020-03-10 05:00:00	IWM	ETF	136.0	137.17	135.67	136.67	20037.0
2020-03-10 06:00:00	IWM	ETF	136.5	136.94	136.37	136.78	47400.0
2020-03-10 07:00:00	IWM	ETF	136.4	136.53	135.51	135.55	82485.0
2020-03-10 08:00:00	IWM	ETF	135.61	136.12	133.9	134.96	518335.0
2020-03-10 09:00:00	IWM	ETF	135.0	135.4	132.135	133.2	4346081.0
2020-03-10 10:00:00	IWM	ETF	133.2	134.75	131.32	131.33	6263781.0
2020-03-10 11:00:00	IWM	ETF	131.31	131.89	128.02	129.0	5750743.0
2020-03-10 12:00:00	IWM	ETF	129.01	130.98	129.01	130.51	4975697.0
2020-03-10 13:00:00	IWM	ETF	130.53	131.27	129.21	129.345	5465296.0
2020-03-10 14:00:00	IWM	ETF	129.34	133.04	128.73	132.79	5207909.0
2020-03-10 15:00:00	IWM	ETF	132.8	134.45	132.61	134.43	8609114.0
2020-03-10 16:00:00	IWM	ETF	134.43	134.61	133.28	133.98	1431109.0
2020-03-10 17:00:00	IWM	ETF	133.86	134.43	133.56	133.56	148340.0
2020-03-10 18:00:00	IWM	ETF	133.4	134.43	132.52	132.64	524657.0
2020-03-10 19:00:00	IWM	ETF	132.55	132.55	131.57	131.62	23195.0
2020-03-10 04:00:00	DIA	ETF	244.8	248.24	244.44	248.24	8905.0
2020-03-10 05:00:00	DIA	ETF	248.37	250.05	247.52	249.98	12800.0

> showing 50 of 13,605 rows — these rows as CSV

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