PREVIEW / etf_1hour / 2020-09-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-15.parquet
  size:    368 KB
  rows:    12,541

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-09-15 04:00:00	SPY	ETF	339.24	340.0	339.24	339.9	6806.0
2020-09-15 05:00:00	SPY	ETF	340.0	340.78	339.99	340.78	20025.0
2020-09-15 06:00:00	SPY	ETF	340.55	340.92	340.32	340.84	99675.0
2020-09-15 07:00:00	SPY	ETF	340.84	341.01	340.6	340.71	176408.0
2020-09-15 08:00:00	SPY	ETF	340.7501	341.69	339.05	341.28	597899.0
2020-09-15 09:00:00	SPY	ETF	341.29	342.02	341.06	341.605	5072020.0
2020-09-15 10:00:00	SPY	ETF	341.61	341.98	340.6	341.515	6485053.0
2020-09-15 11:00:00	SPY	ETF	341.515	341.9	341.08	341.31	5704289.0
2020-09-15 12:00:00	SPY	ETF	341.3081	341.75	341.26	341.685	4396887.0
2020-09-15 13:00:00	SPY	ETF	341.68	341.95	341.12	341.17	3818294.0
2020-09-15 14:00:00	SPY	ETF	341.16	341.23	340.43	340.85	4897985.0
2020-09-15 15:00:00	SPY	ETF	340.87	340.89	339.02	340.15	14957220.0
2020-09-15 16:00:00	SPY	ETF	340.14	340.84	340.11	340.66	4845018.0
2020-09-15 17:00:00	SPY	ETF	340.6	340.8	340.17	340.76	98188.0
2020-09-15 18:00:00	SPY	ETF	340.74	340.99	340.55	340.7899	73805.0
2020-09-15 19:00:00	SPY	ETF	340.78	340.78	339.94	340.28	122480.0
2020-09-15 04:00:00	QQQ	ETF	276.44	276.97	276.44	276.84	22811.0
2020-09-15 05:00:00	QQQ	ETF	277.03	278.1	277.03	277.84	50365.0
2020-09-15 06:00:00	QQQ	ETF	277.84	277.87	277.33	277.77	50624.0
2020-09-15 07:00:00	QQQ	ETF	277.79	278.44	277.65	278.09	224059.0
2020-09-15 08:00:00	QQQ	ETF	278.06	278.78	275.8	278.49	285339.0
2020-09-15 09:00:00	QQQ	ETF	278.49	280.14	278.48	280.14	4647286.0
2020-09-15 10:00:00	QQQ	ETF	280.135	280.24	277.6859	278.92	6374534.0
2020-09-15 11:00:00	QQQ	ETF	278.91	279.91	278.72	279.52	3202654.0
2020-09-15 12:00:00	QQQ	ETF	279.52	280.32	279.495	280.19	2241871.0
2020-09-15 13:00:00	QQQ	ETF	280.2	280.45	279.68	279.74	2359579.0
2020-09-15 14:00:00	QQQ	ETF	279.74	279.85	278.57	279.4701	3274351.0
2020-09-15 15:00:00	QQQ	ETF	279.5	279.51	277.26	279.05	7418405.0
2020-09-15 16:00:00	QQQ	ETF	279.04	279.93	279.02	279.61	1217201.0
2020-09-15 17:00:00	QQQ	ETF	279.6	279.78	279.4	279.78	23852.0
2020-09-15 18:00:00	QQQ	ETF	279.79	279.99	279.62	279.81	65609.0
2020-09-15 19:00:00	QQQ	ETF	279.82	279.83	278.56	278.97	194044.0
2020-09-15 04:00:00	IWM	ETF	153.5	153.75	153.46	153.75	708.0
2020-09-15 05:00:00	IWM	ETF	153.71	153.86	153.71	153.86	9155.0
2020-09-15 06:00:00	IWM	ETF	153.91	154.15	153.91	154.15	17380.0
2020-09-15 07:00:00	IWM	ETF	154.15	154.24	154.0	154.15	69969.0
2020-09-15 08:00:00	IWM	ETF	153.8704	154.75	153.69	154.54	36729.0
2020-09-15 09:00:00	IWM	ETF	154.56	154.695	153.545	153.59	1681125.0
2020-09-15 10:00:00	IWM	ETF	153.6	154.55	153.37	154.535	2452922.0
2020-09-15 11:00:00	IWM	ETF	154.535	154.6	153.75	153.76	1705019.0
2020-09-15 12:00:00	IWM	ETF	153.75	154.045	153.72	154.005	1404680.0
2020-09-15 13:00:00	IWM	ETF	154.005	154.25	154.0	154.03	1159733.0
2020-09-15 14:00:00	IWM	ETF	154.035	154.3	153.89	154.11	1258840.0
2020-09-15 15:00:00	IWM	ETF	154.12	154.12	152.86	153.39	3613678.0
2020-09-15 16:00:00	IWM	ETF	153.37	153.6	153.2686	153.57	646708.0
2020-09-15 17:00:00	IWM	ETF	153.5	153.5	153.47	153.47	5180.0
2020-09-15 18:00:00	IWM	ETF	153.55	153.69	153.5	153.57	14491.0
2020-09-15 19:00:00	IWM	ETF	153.5	153.51	153.29	153.39	27378.0
2020-09-15 04:00:00	DIA	ETF	281.26	281.3	281.23	281.27	437.0
2020-09-15 05:00:00	DIA	ETF	282.0	282.0	282.0	282.0	100.0

> showing 50 of 12,541 rows — these rows as CSV

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