PREVIEW / etf_1hour / 2022-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-22.parquet
  size:    467 KB
  rows:    16,695

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-04-22 04:00:00	SPY	ETF	438.01	438.33	437.3	437.41	57223.0
2022-04-22 05:00:00	SPY	ETF	437.28	437.77	436.31	436.65	19312.0
2022-04-22 06:00:00	SPY	ETF	436.5	437.02	436.15	436.73	97601.0
2022-04-22 07:00:00	SPY	ETF	436.8	437.88	436.8	437.73	378999.0
2022-04-22 08:00:00	SPY	ETF	437.75	438.3396	436.4596	437.12	578021.0
2022-04-22 09:00:00	SPY	ETF	437.09	437.31	433.84	434.31	7979123.0
2022-04-22 10:00:00	SPY	ETF	434.34	435.96	432.16	432.3401	12180439.0
2022-04-22 11:00:00	SPY	ETF	432.32	433.5	430.35	430.38	8842770.0
2022-04-22 12:00:00	SPY	ETF	430.37	431.89	429.87	430.44	7606951.0
2022-04-22 13:00:00	SPY	ETF	430.42	430.72	428.74	428.75	6684438.0
2022-04-22 14:00:00	SPY	ETF	428.74	430.0	426.81	427.4524	11387952.0
2022-04-22 15:00:00	SPY	ETF	427.4578	430.41	425.44	426.09	33364794.0
2022-04-22 16:00:00	SPY	ETF	426.08	426.25	423.95	424.38	8475510.0
2022-04-22 17:00:00	SPY	ETF	424.44	424.75	424.25	424.37	233597.0
2022-04-22 18:00:00	SPY	ETF	424.37	424.45	424.17	424.26	48169.0
2022-04-22 19:00:00	SPY	ETF	424.29	424.3	424.1	424.23	58477.0
2022-04-22 04:00:00	QQQ	ETF	333.36	334.81	333.36	334.04	78552.0
2022-04-22 05:00:00	QQQ	ETF	333.99	334.34	332.63	332.91	91217.0
2022-04-22 06:00:00	QQQ	ETF	332.84	333.61	332.57	333.39	129511.0
2022-04-22 07:00:00	QQQ	ETF	333.38	335.0	333.27	334.88	450257.0
2022-04-22 08:00:00	QQQ	ETF	333.5001	335.62	332.6196	334.28	609965.0
2022-04-22 09:00:00	QQQ	ETF	334.24	335.56	331.64	332.9072	10319515.0
2022-04-22 10:00:00	QQQ	ETF	332.91	335.04	330.83	331.525	11645589.0
2022-04-22 11:00:00	QQQ	ETF	331.52	333.01	329.13	329.15	8030142.0
2022-04-22 12:00:00	QQQ	ETF	329.14	330.13	328.4799	328.62	5951274.0
2022-04-22 13:00:00	QQQ	ETF	328.61	329.02	327.12	327.12	5195917.0
2022-04-22 14:00:00	QQQ	ETF	327.12	328.56	325.8	326.4	7240347.0
2022-04-22 15:00:00	QQQ	ETF	326.41	329.05	324.96	325.4	15661096.0
2022-04-22 16:00:00	QQQ	ETF	325.37	325.65	324.0	324.42	2290185.0
2022-04-22 17:00:00	QQQ	ETF	324.44	325.4	324.36	324.5	389097.0
2022-04-22 18:00:00	QQQ	ETF	324.57	324.57	324.24	324.25	29067.0
2022-04-22 19:00:00	QQQ	ETF	324.29	324.35	324.04	324.25	72440.0
2022-04-22 04:00:00	IWM	ETF	197.67	197.91	197.38	197.4	15467.0
2022-04-22 05:00:00	IWM	ETF	197.46	197.61	196.95	196.95	4524.0
2022-04-22 06:00:00	IWM	ETF	196.97	197.27	196.78	197.17	23253.0
2022-04-22 07:00:00	IWM	ETF	197.24	197.59	197.17	197.49	48943.0
2022-04-22 08:00:00	IWM	ETF	197.47	197.71	196.93	197.12	131939.0
2022-04-22 09:00:00	IWM	ETF	197.15	197.37	196.23	196.68	3673538.0
2022-04-22 10:00:00	IWM	ETF	196.71	197.34	195.01	195.22	3726415.0
2022-04-22 11:00:00	IWM	ETF	195.22	195.76	193.83	193.84	2497325.0
2022-04-22 12:00:00	IWM	ETF	193.82	194.72	193.555	193.83	2528690.0
2022-04-22 13:00:00	IWM	ETF	193.85	193.92	193.01	193.025	2431265.0
2022-04-22 14:00:00	IWM	ETF	193.02	194.0	192.57	192.755	3571798.0
2022-04-22 15:00:00	IWM	ETF	192.76	193.97	192.29	192.66	6244482.0
2022-04-22 16:00:00	IWM	ETF	192.68	193.56	191.61	191.79	1243135.0
2022-04-22 17:00:00	IWM	ETF	191.79	192.68	191.62	191.82	199422.0
2022-04-22 18:00:00	IWM	ETF	191.86	191.99	191.56	191.72	40015.0
2022-04-22 19:00:00	IWM	ETF	191.69	191.69	191.31	191.59	11366.0
2022-04-22 04:00:00	DIA	ETF	347.81	347.81	347.23	347.23	8200.0
2022-04-22 05:00:00	DIA	ETF	347.24	347.24	347.24	347.24	100.0

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

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