PREVIEW / etf_1hour / 2020-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-26.parquet
  size:    386 KB
  rows:    13,238

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-26 04:00:00	SPY	ETF	341.55	342.15	341.3	341.91	71737.0
2020-10-26 05:00:00	SPY	ETF	342.04	342.17	341.6	341.86	33985.0
2020-10-26 06:00:00	SPY	ETF	341.54	342.03	341.51	342.02	32867.0
2020-10-26 07:00:00	SPY	ETF	342.06	342.43	341.7	341.76	229791.0
2020-10-26 08:00:00	SPY	ETF	341.78	343.71	341.4	341.65	386705.0
2020-10-26 09:00:00	SPY	ETF	341.65	342.75	341.54	342.53	6279623.0
2020-10-26 10:00:00	SPY	ETF	342.55	342.98	339.53	339.65	13866233.0
2020-10-26 11:00:00	SPY	ETF	339.65	340.2	338.0	338.6345	15310642.0
2020-10-26 12:00:00	SPY	ETF	338.615	338.91	337.24	337.5	8417994.0
2020-10-26 13:00:00	SPY	ETF	337.5	337.6898	335.62	337.391	11871832.0
2020-10-26 14:00:00	SPY	ETF	337.39	338.68	337.13	338.176	9521622.0
2020-10-26 15:00:00	SPY	ETF	338.2	339.47	337.35	339.415	17171289.0
2020-10-26 16:00:00	SPY	ETF	339.41	339.81	339.2	339.48	6295851.0
2020-10-26 17:00:00	SPY	ETF	339.46	339.49	339.24	339.41	159101.0
2020-10-26 18:00:00	SPY	ETF	339.41	339.81	339.41	339.61	181341.0
2020-10-26 19:00:00	SPY	ETF	339.62	339.94	339.15	339.29	193142.0
2020-10-26 04:00:00	QQQ	ETF	282.0	282.32	281.8	281.95	50282.0
2020-10-26 05:00:00	QQQ	ETF	281.93	282.29	281.82	282.1	23245.0
2020-10-26 06:00:00	QQQ	ETF	282.1	282.36	281.88	282.25	72200.0
2020-10-26 07:00:00	QQQ	ETF	282.29	282.82	282.16	282.35	267027.0
2020-10-26 08:00:00	QQQ	ETF	282.31	284.74	281.88	282.04	185389.0
2020-10-26 09:00:00	QQQ	ETF	282.04	284.9	282.04	284.64	3597247.0
2020-10-26 10:00:00	QQQ	ETF	284.64	285.3	281.29	281.47	5159395.0
2020-10-26 11:00:00	QQQ	ETF	281.45	281.45	279.37	280.03	5453739.0
2020-10-26 12:00:00	QQQ	ETF	280.04	280.57	278.33	278.52	3384653.0
2020-10-26 13:00:00	QQQ	ETF	278.52	278.72	276.76	278.38	4946716.0
2020-10-26 14:00:00	QQQ	ETF	278.39	279.58	278.2	279.24	3696987.0
2020-10-26 15:00:00	QQQ	ETF	279.26	280.51	278.5201	280.4	4942248.0
2020-10-26 16:00:00	QQQ	ETF	280.41	280.85	280.35	280.49	1141931.0
2020-10-26 17:00:00	QQQ	ETF	280.49	280.55	280.4	280.4	21911.0
2020-10-26 18:00:00	QQQ	ETF	280.47	280.74	280.47	280.5	38048.0
2020-10-26 19:00:00	QQQ	ETF	280.5	281.07	280.12	280.25	84802.0
2020-10-26 04:00:00	IWM	ETF	160.56	161.04	160.35	160.96	38814.0
2020-10-26 05:00:00	IWM	ETF	160.94	161.07	160.65	160.65	13324.0
2020-10-26 06:00:00	IWM	ETF	160.7	160.83	160.7	160.72	99813.0
2020-10-26 07:00:00	IWM	ETF	160.75	161.06	160.64	160.65	119104.0
2020-10-26 08:00:00	IWM	ETF	160.86	161.25	160.45	160.71	175006.0
2020-10-26 09:00:00	IWM	ETF	160.68	161.37	160.09	160.91	2844111.0
2020-10-26 10:00:00	IWM	ETF	160.9	161.045	159.44	159.44	4040132.0
2020-10-26 11:00:00	IWM	ETF	159.44	159.51	158.74	159.21	2633946.0
2020-10-26 12:00:00	IWM	ETF	159.2	159.44	158.2636	158.29	1279561.0
2020-10-26 13:00:00	IWM	ETF	158.285	158.54	157.38	158.4	3320640.0
2020-10-26 14:00:00	IWM	ETF	158.4	159.5	158.25	159.2	2298685.0
2020-10-26 15:00:00	IWM	ETF	159.23	159.56	158.67	159.56	4106824.0
2020-10-26 16:00:00	IWM	ETF	159.55	159.67	159.25	159.44	2742538.0
2020-10-26 17:00:00	IWM	ETF	159.49	159.55	159.27	159.42	27694.0
2020-10-26 18:00:00	IWM	ETF	159.44	159.65	159.42	159.56	18495.0
2020-10-26 19:00:00	IWM	ETF	159.54	159.72	159.29	159.34	15690.0
2020-10-26 04:00:00	DIA	ETF	280.28	280.36	279.76	280.33	3379.0
2020-10-26 05:00:00	DIA	ETF	280.35	280.35	280.34	280.34	400.0

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

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