PREVIEW / etf_1hour / 2022-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-14.parquet
  size:    451 KB
  rows:    16,756

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-10-14 04:00:00	SPY	ETF	366.81	366.93	364.38	364.56	52983.0
2022-10-14 05:00:00	SPY	ETF	364.41	365.32	364.0	365.27	48284.0
2022-10-14 06:00:00	SPY	ETF	365.25	368.04	365.21	367.58	240053.0
2022-10-14 07:00:00	SPY	ETF	367.6	368.03	365.08	365.15	477457.0
2022-10-14 08:00:00	SPY	ETF	368.125	371.2	365.05	370.12	3708968.0
2022-10-14 09:00:00	SPY	ETF	370.14	370.4	365.99	366.6	11693652.0
2022-10-14 10:00:00	SPY	ETF	366.61	366.62	360.32	362.0602	18158811.0
2022-10-14 11:00:00	SPY	ETF	362.07	363.53	359.31	359.745	10011514.0
2022-10-14 12:00:00	SPY	ETF	359.72	361.0682	358.45	359.33	9868144.0
2022-10-14 13:00:00	SPY	ETF	359.34	360.23	358.51	360.12	7079495.0
2022-10-14 14:00:00	SPY	ETF	360.135	360.15	357.56	358.4683	6904190.0
2022-10-14 15:00:00	SPY	ETF	358.46	359.43	356.96	357.68	21319300.0
2022-10-14 16:00:00	SPY	ETF	357.67	358.0	357.0	357.5	5758454.0
2022-10-14 17:00:00	SPY	ETF	357.48	357.61	357.12	357.2	186608.0
2022-10-14 18:00:00	SPY	ETF	357.23	357.35	356.97	356.97	42923.0
2022-10-14 19:00:00	SPY	ETF	356.96	357.0	356.5	356.6	61627.0
2022-10-14 04:00:00	QQQ	ETF	269.39	269.4	266.98	267.1	79843.0
2022-10-14 05:00:00	QQQ	ETF	267.03	267.9	266.66	267.7	121853.0
2022-10-14 06:00:00	QQQ	ETF	267.85	269.75	267.67	269.48	168326.0
2022-10-14 07:00:00	QQQ	ETF	269.43	269.76	267.42	267.44	445042.0
2022-10-14 08:00:00	QQQ	ETF	269.0699	272.88	266.8996	272.06	1570027.0
2022-10-14 09:00:00	QQQ	ETF	272.11	272.24	267.5	268.0548	9703823.0
2022-10-14 10:00:00	QQQ	ETF	268.0	268.0	263.23	264.73	13655920.0
2022-10-14 11:00:00	QQQ	ETF	264.78	266.08	262.49	262.78	7765885.0
2022-10-14 12:00:00	QQQ	ETF	262.775	263.8	261.58	262.4249	6059065.0
2022-10-14 13:00:00	QQQ	ETF	262.45	263.25	261.83	263.19	3726975.0
2022-10-14 14:00:00	QQQ	ETF	263.2	263.2	261.19	261.965	4387521.0
2022-10-14 15:00:00	QQQ	ETF	261.97	262.56	260.14	260.64	10622111.0
2022-10-14 16:00:00	QQQ	ETF	260.65	261.4	260.53	260.63	1965891.0
2022-10-14 17:00:00	QQQ	ETF	260.68	260.74	260.3	260.3526	343236.0
2022-10-14 18:00:00	QQQ	ETF	260.31	260.45	258.88	260.25	43714.0
2022-10-14 19:00:00	QQQ	ETF	260.3	260.3	259.9	259.9	48520.0
2022-10-14 04:00:00	IWM	ETF	171.84	171.88	170.88	170.92	15547.0
2022-10-14 05:00:00	IWM	ETF	170.93	171.38	170.65	171.38	18847.0
2022-10-14 06:00:00	IWM	ETF	171.31	172.72	171.3	172.61	58353.0
2022-10-14 07:00:00	IWM	ETF	172.64	172.83	171.27	171.29	62478.0
2022-10-14 08:00:00	IWM	ETF	172.54	174.45	171.26	173.79	455235.0
2022-10-14 09:00:00	IWM	ETF	173.89	173.92	171.42	171.63	3021087.0
2022-10-14 10:00:00	IWM	ETF	171.63	171.63	168.8	169.65	3956069.0
2022-10-14 11:00:00	IWM	ETF	169.67	170.19	168.05	168.12	2116670.0
2022-10-14 12:00:00	IWM	ETF	168.11	169.08	167.48	168.32	1706774.0
2022-10-14 13:00:00	IWM	ETF	168.33	168.68	167.62	168.49	914732.0
2022-10-14 14:00:00	IWM	ETF	168.52	168.52	167.21	167.52	1243610.0
2022-10-14 15:00:00	IWM	ETF	167.51	167.92	166.71	166.89	4922093.0
2022-10-14 16:00:00	IWM	ETF	166.81	167.4996	166.81	167.04	1229734.0
2022-10-14 17:00:00	IWM	ETF	167.0	167.05	166.8	166.94	420153.0
2022-10-14 18:00:00	IWM	ETF	166.88	166.88	166.65	166.74	11081.0
2022-10-14 19:00:00	IWM	ETF	166.74	166.74	166.52	166.55	3115.0
2022-10-14 04:00:00	DIA	ETF	300.76	300.76	299.61	299.61	3400.0
2022-10-14 05:00:00	DIA	ETF	299.26	299.26	299.26	299.26	300.0

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

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