PREVIEW / etf_1hour / 2022-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-14.parquet
  size:    447 KB
  rows:    16,405

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
2022-07-14 04:00:00	SPY	ETF	376.44	376.82	374.16	374.6	186044.0
2022-07-14 05:00:00	SPY	ETF	374.48	375.4	374.21	375.24	96369.0
2022-07-14 06:00:00	SPY	ETF	375.38	375.5	373.62	374.09	331808.0
2022-07-14 07:00:00	SPY	ETF	374.07	374.63	373.68	373.79	576655.0
2022-07-14 08:00:00	SPY	ETF	374.4299	378.72	372.9	374.02	1039200.0
2022-07-14 09:00:00	SPY	ETF	373.93	374.4	371.7416	372.33	8846215.0
2022-07-14 10:00:00	SPY	ETF	372.33	373.04	371.04	372.36	9370238.0
2022-07-14 11:00:00	SPY	ETF	372.36	375.99	372.25	375.6901	8942550.0
2022-07-14 12:00:00	SPY	ETF	375.7	375.95	373.14	373.9401	5540902.0
2022-07-14 13:00:00	SPY	ETF	373.969	375.82	373.22	375.6	5509338.0
2022-07-14 14:00:00	SPY	ETF	375.605	378.36	375.49	377.78	8142108.0
2022-07-14 15:00:00	SPY	ETF	377.78	378.57	377.03	377.96	11022465.0
2022-07-14 16:00:00	SPY	ETF	377.96	378.4	377.9	378.15	2536412.0
2022-07-14 17:00:00	SPY	ETF	378.15	378.27	378.0	378.21	27788.0
2022-07-14 18:00:00	SPY	ETF	378.21	379.26	378.21	378.99	91995.0
2022-07-14 19:00:00	SPY	ETF	378.96	379.56	378.88	379.56	69517.0
2022-07-14 04:00:00	QQQ	ETF	283.67	284.25	281.93	282.73	242641.0
2022-07-14 05:00:00	QQQ	ETF	282.62	283.5	282.35	283.47	178694.0
2022-07-14 06:00:00	QQQ	ETF	283.47	283.76	282.72	283.31	154557.0
2022-07-14 07:00:00	QQQ	ETF	283.28	283.66	282.69	282.98	390711.0
2022-07-14 08:00:00	QQQ	ETF	283.2001	285.864	282.0	283.35	1326999.0
2022-07-14 09:00:00	QQQ	ETF	283.29	283.93	280.68	281.1383	7639150.0
2022-07-14 10:00:00	QQQ	ETF	281.1	282.13	279.8	281.53	8496665.0
2022-07-14 11:00:00	QQQ	ETF	281.54	284.74	281.4701	284.375	7005734.0
2022-07-14 12:00:00	QQQ	ETF	284.4094	284.7	282.42	283.16	4417909.0
2022-07-14 13:00:00	QQQ	ETF	283.16	285.37	282.63	284.96	4024475.0
2022-07-14 14:00:00	QQQ	ETF	284.96	287.52	284.83	286.8101	5767327.0
2022-07-14 15:00:00	QQQ	ETF	286.82	287.56	285.82	286.7	6666272.0
2022-07-14 16:00:00	QQQ	ETF	286.71	287.14	286.57	286.88	2050341.0
2022-07-14 17:00:00	QQQ	ETF	286.9	287.15	286.67	287.14	154975.0
2022-07-14 18:00:00	QQQ	ETF	287.13	287.76	286.97	287.52	147700.0
2022-07-14 19:00:00	QQQ	ETF	287.52	288.34	287.43	288.28	209826.0
2022-07-14 04:00:00	IWM	ETF	170.34	170.34	169.0	169.12	21434.0
2022-07-14 05:00:00	IWM	ETF	169.12	169.6	169.0	169.6	13992.0
2022-07-14 06:00:00	IWM	ETF	169.54	169.6	168.75	169.05	11823.0
2022-07-14 07:00:00	IWM	ETF	169.0	169.23	168.7	168.81	79429.0
2022-07-14 08:00:00	IWM	ETF	169.07	169.36	168.34	168.95	165319.0
2022-07-14 09:00:00	IWM	ETF	168.9	169.47	167.83	168.01	2470924.0
2022-07-14 10:00:00	IWM	ETF	168.01	168.13	167.02	167.49	3051354.0
2022-07-14 11:00:00	IWM	ETF	167.49	168.6	167.42	168.545	2290376.0
2022-07-14 12:00:00	IWM	ETF	168.55	168.67	167.21	167.68	1436748.0
2022-07-14 13:00:00	IWM	ETF	167.69	168.53	167.34	168.43	1588260.0
2022-07-14 14:00:00	IWM	ETF	168.43	170.0	168.34	169.63	2175773.0
2022-07-14 15:00:00	IWM	ETF	169.6393	169.88	169.13	169.63	3720294.0
2022-07-14 16:00:00	IWM	ETF	169.56	169.85	167.7119	169.56	969312.0
2022-07-14 17:00:00	IWM	ETF	169.56	169.75	169.5	169.73	145127.0
2022-07-14 18:00:00	IWM	ETF	169.73	170.25	169.71	170.12	18363.0
2022-07-14 19:00:00	IWM	ETF	170.09	170.26	169.97	170.21	21944.0
2022-07-14 04:00:00	DIA	ETF	306.35	306.35	304.37	304.79	5129.0
2022-07-14 05:00:00	DIA	ETF	304.61	304.61	304.4	304.4	2890.0

> showing 50 of 16,405 rows — these rows as CSV

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