PREVIEW / etf_1hour / 2022-03-11

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-11.parquet
  size:    457 KB
  rows:    16,378

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-03-11 04:00:00	SPY	ETF	425.67	427.13	425.53	426.91	40770.0
2022-03-11 05:00:00	SPY	ETF	427.2	428.03	426.95	427.56	31077.0
2022-03-11 06:00:00	SPY	ETF	427.34	433.22	426.88	431.5	524888.0
2022-03-11 07:00:00	SPY	ETF	431.4	431.57	429.69	430.0	475510.0
2022-03-11 08:00:00	SPY	ETF	431.05	431.9104	424.88	428.81	855478.0
2022-03-11 09:00:00	SPY	ETF	428.91	429.17	426.57	427.125	9002356.0
2022-03-11 10:00:00	SPY	ETF	427.14	427.19	424.85	426.96	10878989.0
2022-03-11 11:00:00	SPY	ETF	426.97	427.03	423.73	424.38	8462731.0
2022-03-11 12:00:00	SPY	ETF	424.38	424.82	423.0	424.005	6860335.0
2022-03-11 13:00:00	SPY	ETF	424.01	425.52	423.65	423.68	5871964.0
2022-03-11 14:00:00	SPY	ETF	423.7	424.86	422.605	423.1	7241904.0
2022-03-11 15:00:00	SPY	ETF	423.105	423.18	419.53	420.08	19352442.0
2022-03-11 16:00:00	SPY	ETF	420.08	420.74	419.87	420.2201	5398922.0
2022-03-11 17:00:00	SPY	ETF	420.35	420.35	420.03	420.05	114120.0
2022-03-11 18:00:00	SPY	ETF	420.05	420.1	419.75	420.0	72228.0
2022-03-11 19:00:00	SPY	ETF	420.06	420.35	419.81	419.95	30926.0
2022-03-11 04:00:00	QQQ	ETF	330.72	333.0	330.72	332.81	53802.0
2022-03-11 05:00:00	QQQ	ETF	332.79	333.63	332.58	333.02	152689.0
2022-03-11 06:00:00	QQQ	ETF	332.96	338.0	332.2	336.86	503609.0
2022-03-11 07:00:00	QQQ	ETF	336.81	337.11	335.55	335.81	497760.0
2022-03-11 08:00:00	QQQ	ETF	336.5692	337.4004	328.9	335.0	636379.0
2022-03-11 09:00:00	QQQ	ETF	335.03	335.38	330.99	331.5192	7446689.0
2022-03-11 10:00:00	QQQ	ETF	331.5	331.5	329.35	330.98	7507007.0
2022-03-11 11:00:00	QQQ	ETF	330.98	331.07	327.11	328.25	8043275.0
2022-03-11 12:00:00	QQQ	ETF	328.24	328.8	326.8599	327.97	4745327.0
2022-03-11 13:00:00	QQQ	ETF	327.98	329.63	327.66	327.69	4718137.0
2022-03-11 14:00:00	QQQ	ETF	327.7	328.96	326.96	327.34	4788566.0
2022-03-11 15:00:00	QQQ	ETF	327.36	327.6199	323.9	324.339	10683718.0
2022-03-11 16:00:00	QQQ	ETF	324.35	325.1	324.3	324.45	2785557.0
2022-03-11 17:00:00	QQQ	ETF	324.43	324.58	324.34	324.4	69518.0
2022-03-11 18:00:00	QQQ	ETF	324.45	324.55	324.25	324.35	31303.0
2022-03-11 19:00:00	QQQ	ETF	324.4	324.4	324.0	324.0	29549.0
2022-03-11 04:00:00	IWM	ETF	199.77	200.5	199.63	200.36	16257.0
2022-03-11 05:00:00	IWM	ETF	200.56	200.91	200.15	200.15	13996.0
2022-03-11 06:00:00	IWM	ETF	200.4	203.79	200.18	202.59	242132.0
2022-03-11 07:00:00	IWM	ETF	202.72	202.95	201.96	202.17	303041.0
2022-03-11 08:00:00	IWM	ETF	202.77	202.9996	200.77	200.83	230454.0
2022-03-11 09:00:00	IWM	ETF	200.83	201.76	200.38	200.73	3363476.0
2022-03-11 10:00:00	IWM	ETF	200.67	200.68	198.28	199.27	2898829.0
2022-03-11 11:00:00	IWM	ETF	199.27	199.31	197.65	198.24	2324756.0
2022-03-11 12:00:00	IWM	ETF	198.22	198.68	197.5	198.13	1231173.0
2022-03-11 13:00:00	IWM	ETF	198.14	198.64	197.69	197.71	793844.0
2022-03-11 14:00:00	IWM	ETF	197.69	198.41	197.46	197.63	1256093.0
2022-03-11 15:00:00	IWM	ETF	197.61	197.76	196.44	196.65	3067355.0
2022-03-11 16:00:00	IWM	ETF	196.73	196.87	196.55	196.68	2257168.0
2022-03-11 17:00:00	IWM	ETF	196.82	196.85	196.55	196.73	35438.0
2022-03-11 18:00:00	IWM	ETF	196.78	196.82	196.56	196.67	9709.0
2022-03-11 19:00:00	IWM	ETF	196.74	196.85	196.61	196.84	21198.0
2022-03-11 04:00:00	DIA	ETF	332.98	333.05	332.98	333.05	400.0
2022-03-11 06:00:00	DIA	ETF	334.0	336.62	334.0	336.16	7946.0

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

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