PREVIEW / etf_1hour / 2022-06-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-22.parquet
  size:    460 KB
  rows:    16,836

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-06-22 04:00:00	SPY	ETF	368.07	368.92	367.65	368.7	175874.0
2022-06-22 05:00:00	SPY	ETF	368.65	369.45	368.55	369.39	84500.0
2022-06-22 06:00:00	SPY	ETF	369.37	370.07	369.2	369.69	165921.0
2022-06-22 07:00:00	SPY	ETF	369.67	370.68	369.67	369.74	495222.0
2022-06-22 08:00:00	SPY	ETF	369.66	372.78	367.8396	369.87	1062886.0
2022-06-22 09:00:00	SPY	ETF	369.89	374.51	368.98	373.54	8496261.0
2022-06-22 10:00:00	SPY	ETF	373.53	377.96	372.775	376.79	10171221.0
2022-06-22 11:00:00	SPY	ETF	376.81	377.69	374.59	374.7	7713238.0
2022-06-22 12:00:00	SPY	ETF	374.67	376.53	374.11	376.44	5140331.0
2022-06-22 13:00:00	SPY	ETF	376.46	377.45	375.51	377.11	4522749.0
2022-06-22 14:00:00	SPY	ETF	377.11	378.72	376.49	377.25	7384692.0
2022-06-22 15:00:00	SPY	ETF	377.26	377.6	374.23	374.39	15563456.0
2022-06-22 16:00:00	SPY	ETF	374.37	375.0	374.14	374.25	4465429.0
2022-06-22 17:00:00	SPY	ETF	374.18	374.35	374.13	374.25	90463.0
2022-06-22 18:00:00	SPY	ETF	374.3	374.5	373.68	373.92	175796.0
2022-06-22 19:00:00	SPY	ETF	373.92	373.92	372.07	372.67	205324.0
2022-06-22 04:00:00	QQQ	ETF	275.43	276.96	274.93	275.69	170732.0
2022-06-22 05:00:00	QQQ	ETF	275.74	276.36	275.65	276.33	110574.0
2022-06-22 06:00:00	QQQ	ETF	276.25	276.76	276.18	276.5	80259.0
2022-06-22 07:00:00	QQQ	ETF	276.4	277.49	276.4	276.8	497461.0
2022-06-22 08:00:00	QQQ	ETF	276.7	281.29	275.0996	277.18	1387149.0
2022-06-22 09:00:00	QQQ	ETF	277.21	282.11	276.55	281.43	8603624.0
2022-06-22 10:00:00	QQQ	ETF	281.45	285.18	280.64	284.0	8643973.0
2022-06-22 11:00:00	QQQ	ETF	284.02	284.43	281.23	281.34	6615691.0
2022-06-22 12:00:00	QQQ	ETF	281.32	283.02	280.83	282.9578	5149801.0
2022-06-22 13:00:00	QQQ	ETF	282.9399	283.67	282.12	283.115	3584414.0
2022-06-22 14:00:00	QQQ	ETF	283.13	284.54	282.69	283.355	4732296.0
2022-06-22 15:00:00	QQQ	ETF	283.37	283.66	280.23	280.66	8883253.0
2022-06-22 16:00:00	QQQ	ETF	280.66	281.47	280.24	280.3	2600809.0
2022-06-22 17:00:00	QQQ	ETF	280.25	280.5	280.21	280.31	53250.0
2022-06-22 18:00:00	QQQ	ETF	280.33	280.57	279.76	279.99	131524.0
2022-06-22 19:00:00	QQQ	ETF	279.96	279.97	278.34	278.9	234898.0
2022-06-22 04:00:00	IWM	ETF	165.0	165.25	164.59	165.12	84872.0
2022-06-22 05:00:00	IWM	ETF	165.19	165.53	165.12	165.53	16214.0
2022-06-22 06:00:00	IWM	ETF	165.44	165.88	165.44	165.8	52004.0
2022-06-22 07:00:00	IWM	ETF	165.71	166.18	165.69	165.7	51306.0
2022-06-22 08:00:00	IWM	ETF	165.7	166.12	165.2	165.74	100984.0
2022-06-22 09:00:00	IWM	ETF	165.78	167.3	165.37	166.96	3973875.0
2022-06-22 10:00:00	IWM	ETF	166.965	169.255	166.38	168.32	3140441.0
2022-06-22 11:00:00	IWM	ETF	168.32	168.745	167.08	167.1012	2412765.0
2022-06-22 12:00:00	IWM	ETF	167.1	168.32	167.09	168.23	1790512.0
2022-06-22 13:00:00	IWM	ETF	168.25	168.76	167.76	168.55	1534256.0
2022-06-22 14:00:00	IWM	ETF	168.58	169.24	168.24	168.64	1924853.0
2022-06-22 15:00:00	IWM	ETF	168.65	168.8	167.41	167.81	4234868.0
2022-06-22 16:00:00	IWM	ETF	167.82	168.07	167.49	167.49	1930315.0
2022-06-22 17:00:00	IWM	ETF	167.36	167.69	167.36	167.49	20724.0
2022-06-22 18:00:00	IWM	ETF	167.52	167.63	167.28	167.39	49325.0
2022-06-22 19:00:00	IWM	ETF	167.34	167.34	166.61	166.82	37758.0
2022-06-22 04:00:00	DIA	ETF	300.37	300.69	300.35	300.35	1980.0
2022-06-22 05:00:00	DIA	ETF	300.8	301.4	300.8	301.4	1203.0

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

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