PREVIEW / etf_1hour / 2020-10-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-06.parquet
  size:    380 KB
  rows:    13,011

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-10-06 04:00:00	SPY	ETF	338.75	338.79	338.11	338.44	47378.0
2020-10-06 05:00:00	SPY	ETF	338.4	338.59	338.38	338.39	9681.0
2020-10-06 06:00:00	SPY	ETF	338.26	338.89	338.11	338.57	160231.0
2020-10-06 07:00:00	SPY	ETF	338.64	339.59	338.51	339.43	175155.0
2020-10-06 08:00:00	SPY	ETF	338.6799	340.2	338.0796	339.9	293410.0
2020-10-06 09:00:00	SPY	ETF	339.92	340.26	339.06	339.41	4668748.0
2020-10-06 10:00:00	SPY	ETF	339.4	340.56	339.07	339.92	7803260.0
2020-10-06 11:00:00	SPY	ETF	339.92	340.17	338.66	338.91	5667341.0
2020-10-06 12:00:00	SPY	ETF	338.92	340.39	338.891	340.31	3821552.0
2020-10-06 13:00:00	SPY	ETF	340.32	341.0	340.19	340.45	4710768.0
2020-10-06 14:00:00	SPY	ETF	340.47	342.17	335.71	337.03	21769114.0
2020-10-06 15:00:00	SPY	ETF	337.02	337.12	334.38	334.94	32151704.0
2020-10-06 16:00:00	SPY	ETF	334.95	335.59	333.12	333.46	5772995.0
2020-10-06 17:00:00	SPY	ETF	333.4	334.93	333.4	333.85	175238.0
2020-10-06 18:00:00	SPY	ETF	333.76	334.61	333.28	333.75	471452.0
2020-10-06 19:00:00	SPY	ETF	333.73	334.79	333.7	334.62	228933.0
2020-10-06 04:00:00	QQQ	ETF	279.11	279.11	278.5	278.84	73673.0
2020-10-06 05:00:00	QQQ	ETF	278.72	278.85	278.6	278.68	21104.0
2020-10-06 06:00:00	QQQ	ETF	278.6	279.05	278.27	278.79	119817.0
2020-10-06 07:00:00	QQQ	ETF	278.81	279.49	278.75	279.12	118899.0
2020-10-06 08:00:00	QQQ	ETF	278.8299	280.0	278.4504	279.29	493669.0
2020-10-06 09:00:00	QQQ	ETF	279.34	280.07	278.6028	279.29	3127353.0
2020-10-06 10:00:00	QQQ	ETF	279.29	280.56	279.0	279.35	4727134.0
2020-10-06 11:00:00	QQQ	ETF	279.358	279.7165	277.13	277.6742	4947024.0
2020-10-06 12:00:00	QQQ	ETF	277.6772	279.39	277.62	279.231	2627805.0
2020-10-06 13:00:00	QQQ	ETF	279.25	279.77	278.98	279.538	2424249.0
2020-10-06 14:00:00	QQQ	ETF	279.54	281.19	275.41	276.865	6619698.0
2020-10-06 15:00:00	QQQ	ETF	276.79	276.93	274.25	275.15	11927225.0
2020-10-06 16:00:00	QQQ	ETF	275.13	275.47	273.2698	273.5	1563385.0
2020-10-06 17:00:00	QQQ	ETF	273.47	274.16	273.4	273.96	111399.0
2020-10-06 18:00:00	QQQ	ETF	273.91	274.57	273.55	273.98	228612.0
2020-10-06 19:00:00	QQQ	ETF	273.97	274.81	273.87	274.63	188001.0
2020-10-06 04:00:00	IWM	ETF	156.68	156.68	156.41	156.65	10899.0
2020-10-06 05:00:00	IWM	ETF	156.65	156.85	156.56	156.76	2500.0
2020-10-06 06:00:00	IWM	ETF	156.71	157.13	156.56	157.1	8500.0
2020-10-06 07:00:00	IWM	ETF	157.08	158.0	157.06	157.97	50591.0
2020-10-06 08:00:00	IWM	ETF	157.11	158.49	156.87	158.28	89511.0
2020-10-06 09:00:00	IWM	ETF	158.25	158.84	157.54	157.615	2532591.0
2020-10-06 10:00:00	IWM	ETF	157.62	159.02	157.61	158.81	3904133.0
2020-10-06 11:00:00	IWM	ETF	158.82	159.3	158.64	158.685	2860134.0
2020-10-06 12:00:00	IWM	ETF	158.69	159.73	158.58	159.69	1369069.0
2020-10-06 13:00:00	IWM	ETF	159.7	160.29	159.68	160.15	2413894.0
2020-10-06 14:00:00	IWM	ETF	160.14	161.01	157.11	157.95	7193805.0
2020-10-06 15:00:00	IWM	ETF	157.91	158.19	156.34	156.63	10289766.0
2020-10-06 16:00:00	IWM	ETF	156.62	156.78	155.68	155.8	1288377.0
2020-10-06 17:00:00	IWM	ETF	155.79	156.2	155.57	156.01	39218.0
2020-10-06 18:00:00	IWM	ETF	156.01	156.62	155.78	156.0	31424.0
2020-10-06 19:00:00	IWM	ETF	156.05	156.6	156.05	156.52	17323.0
2020-10-06 04:00:00	DIA	ETF	280.67	280.68	280.67	280.68	1000.0
2020-10-06 06:00:00	DIA	ETF	281.4	281.4	281.11	281.11	1200.0

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

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