PREVIEW / etf_1hour / 2022-01-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-01-20.parquet
  size:    467 KB
  rows:    16,702

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-01-20 04:00:00	SPY	ETF	453.15	453.65	452.34	453.38	84643.0
2022-01-20 05:00:00	SPY	ETF	453.46	453.86	453.19	453.65	33234.0
2022-01-20 06:00:00	SPY	ETF	453.89	454.46	453.64	454.11	144293.0
2022-01-20 07:00:00	SPY	ETF	454.07	454.19	453.03	453.52	311797.0
2022-01-20 08:00:00	SPY	ETF	453.52	454.48	452.088	453.89	811414.0
2022-01-20 09:00:00	SPY	ETF	453.97	457.01	453.51	456.71	8951282.0
2022-01-20 10:00:00	SPY	ETF	456.72	458.38	455.53	458.06	11553120.0
2022-01-20 11:00:00	SPY	ETF	458.07	458.74	456.94	457.5	7637361.0
2022-01-20 12:00:00	SPY	ETF	457.51	457.8599	456.48	456.73	4771649.0
2022-01-20 13:00:00	SPY	ETF	456.72	456.72	455.16	455.29	6769379.0
2022-01-20 14:00:00	SPY	ETF	455.3	456.57	453.02	453.275	13021993.0
2022-01-20 15:00:00	SPY	ETF	453.26	453.875	444.5	446.79	38102335.0
2022-01-20 16:00:00	SPY	ETF	446.79	447.11	443.16	445.06	8370352.0
2022-01-20 17:00:00	SPY	ETF	445.01	446.75	444.75	444.95	1056687.0
2022-01-20 18:00:00	SPY	ETF	444.87	446.75	444.23	445.47	308855.0
2022-01-20 19:00:00	SPY	ETF	445.65	445.8	444.58	444.64	111069.0
2022-01-20 04:00:00	QQQ	ETF	368.0	369.11	367.4	368.8	130575.0
2022-01-20 05:00:00	QQQ	ETF	368.92	369.2	368.44	368.93	48518.0
2022-01-20 06:00:00	QQQ	ETF	369.28	370.0	369.25	369.61	159457.0
2022-01-20 07:00:00	QQQ	ETF	369.67	369.79	368.49	369.2	383352.0
2022-01-20 08:00:00	QQQ	ETF	369.68	370.59	366.754	370.13	850207.0
2022-01-20 09:00:00	QQQ	ETF	370.2	372.55	369.53	372.31	7133290.0
2022-01-20 10:00:00	QQQ	ETF	372.38	373.6	370.92	373.17	8598700.0
2022-01-20 11:00:00	QQQ	ETF	373.15	373.87	371.48	372.48	6199313.0
2022-01-20 12:00:00	QQQ	ETF	372.52	372.929	371.3	371.59	3927481.0
2022-01-20 13:00:00	QQQ	ETF	371.55	371.58	369.822	369.981	6080131.0
2022-01-20 14:00:00	QQQ	ETF	369.97	371.3	367.45	367.65	7552533.0
2022-01-20 15:00:00	QQQ	ETF	367.65	368.38	361.17	361.61	21016148.0
2022-01-20 16:00:00	QQQ	ETF	361.58	362.08	357.1	358.89	3938008.0
2022-01-20 17:00:00	QQQ	ETF	358.88	361.72	358.41	358.58	734401.0
2022-01-20 18:00:00	QQQ	ETF	358.59	359.56	357.96	359.3	466515.0
2022-01-20 19:00:00	QQQ	ETF	359.34	359.69	358.26	358.26	256752.0
2022-01-20 04:00:00	IWM	ETF	204.95	205.33	204.3	205.23	199579.0
2022-01-20 05:00:00	IWM	ETF	205.21	205.64	205.19	205.47	79012.0
2022-01-20 06:00:00	IWM	ETF	205.61	205.97	205.38	205.65	146907.0
2022-01-20 07:00:00	IWM	ETF	205.62	205.76	205.08	205.29	249953.0
2022-01-20 08:00:00	IWM	ETF	205.67	205.96	204.5196	205.4	347859.0
2022-01-20 09:00:00	IWM	ETF	205.41	206.761	205.22	206.61	4921980.0
2022-01-20 10:00:00	IWM	ETF	206.66	208.81	206.28	208.7	4730045.0
2022-01-20 11:00:00	IWM	ETF	208.7	208.99	207.63	208.07	3493714.0
2022-01-20 12:00:00	IWM	ETF	208.09	208.33	207.28	207.48	2564187.0
2022-01-20 13:00:00	IWM	ETF	207.5	207.5	206.21	206.29	3268733.0
2022-01-20 14:00:00	IWM	ETF	206.3	207.09	204.46	204.6	4627323.0
2022-01-20 15:00:00	IWM	ETF	204.59	204.98	200.33	200.74	12592638.0
2022-01-20 16:00:00	IWM	ETF	200.75	201.14	199.72	200.6	1638138.0
2022-01-20 17:00:00	IWM	ETF	200.63	200.96	200.1	200.54	133950.0
2022-01-20 18:00:00	IWM	ETF	200.6	201.19	200.3	201.02	114117.0
2022-01-20 19:00:00	IWM	ETF	201.02	201.05	200.3	200.32	44592.0
2022-01-20 04:00:00	DIA	ETF	351.45	351.46	350.62	351.43	6621.0
2022-01-20 05:00:00	DIA	ETF	351.46	351.54	351.36	351.54	800.0

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

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