PREVIEW / etf_1hour / 2022-10-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-07.parquet
  size:    456 KB
  rows:    16,672

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-07 04:00:00	SPY	ETF	372.2	372.8	371.78	372.79	31742.0
2022-10-07 05:00:00	SPY	ETF	372.73	373.65	372.73	373.41	26501.0
2022-10-07 06:00:00	SPY	ETF	373.47	373.47	372.67	373.11	53369.0
2022-10-07 07:00:00	SPY	ETF	373.08	373.55	372.87	373.1	125592.0
2022-10-07 08:00:00	SPY	ETF	373.11	374.47	367.7	369.0813	4738554.0
2022-10-07 09:00:00	SPY	ETF	369.1	369.88	365.36	365.53	9581311.0
2022-10-07 10:00:00	SPY	ETF	365.54	367.14	364.77	366.46	10838621.0
2022-10-07 11:00:00	SPY	ETF	366.4507	367.12	364.87	365.29	6819722.0
2022-10-07 12:00:00	SPY	ETF	365.29	365.82	363.44	363.81	7493287.0
2022-10-07 13:00:00	SPY	ETF	363.8101	364.37	363.11	363.43	6154679.0
2022-10-07 14:00:00	SPY	ETF	363.43	363.82	362.28	362.78	7681511.0
2022-10-07 15:00:00	SPY	ETF	362.77	363.5	360.94	362.8	23211594.0
2022-10-07 16:00:00	SPY	ETF	362.8	363.0	362.33	362.77	6229073.0
2022-10-07 17:00:00	SPY	ETF	362.79	362.79	362.37	362.37	117145.0
2022-10-07 18:00:00	SPY	ETF	362.35	362.37	362.14	362.29	78913.0
2022-10-07 19:00:00	SPY	ETF	362.25	362.25	361.95	361.95	45570.0
2022-10-07 04:00:00	QQQ	ETF	278.44	278.87	278.02	278.81	44309.0
2022-10-07 05:00:00	QQQ	ETF	278.77	279.46	278.76	279.17	43565.0
2022-10-07 06:00:00	QQQ	ETF	279.02	279.03	278.4	278.65	52063.0
2022-10-07 07:00:00	QQQ	ETF	278.87	279.2	278.66	278.88	75210.0
2022-10-07 08:00:00	QQQ	ETF	278.99	279.99	274.0	275.23	4067498.0
2022-10-07 09:00:00	QQQ	ETF	275.2	275.78	271.96	272.175	8808032.0
2022-10-07 10:00:00	QQQ	ETF	272.18	273.38	271.67	272.41	8333279.0
2022-10-07 11:00:00	QQQ	ETF	272.42	272.91	270.76	271.26	5266620.0
2022-10-07 12:00:00	QQQ	ETF	271.21	271.62	269.68	270.03	4640806.0
2022-10-07 13:00:00	QQQ	ETF	270.04	270.44	269.34	269.48	3598210.0
2022-10-07 14:00:00	QQQ	ETF	269.47	269.93	268.81	269.32	4325237.0
2022-10-07 15:00:00	QQQ	ETF	269.33	269.941	267.74	269.02	12483339.0
2022-10-07 16:00:00	QQQ	ETF	269.02	269.18	268.78	268.96	4407130.0
2022-10-07 17:00:00	QQQ	ETF	268.95	269.1	268.83	268.87	142444.0
2022-10-07 18:00:00	QQQ	ETF	268.89	268.89	268.67	268.73	18280.0
2022-10-07 19:00:00	QQQ	ETF	268.67	268.69	268.41	268.65	39446.0
2022-10-07 04:00:00	IWM	ETF	173.41	173.94	173.28	173.94	6847.0
2022-10-07 05:00:00	IWM	ETF	173.87	174.31	173.87	174.31	8321.0
2022-10-07 06:00:00	IWM	ETF	174.18	174.3	173.91	174.09	6752.0
2022-10-07 07:00:00	IWM	ETF	174.12	174.35	173.97	174.11	34270.0
2022-10-07 08:00:00	IWM	ETF	174.24	174.99	171.13	172.06	932578.0
2022-10-07 09:00:00	IWM	ETF	171.94	172.47	169.61	169.65	3588825.0
2022-10-07 10:00:00	IWM	ETF	169.635	171.19	169.36	170.89	2973406.0
2022-10-07 11:00:00	IWM	ETF	170.895	171.27	169.55	169.76	2318348.0
2022-10-07 12:00:00	IWM	ETF	169.76	170.16	168.79	169.17	1545690.0
2022-10-07 13:00:00	IWM	ETF	169.17	169.38	168.65	168.96	1216984.0
2022-10-07 14:00:00	IWM	ETF	168.96	169.18	168.63	169.02	1067397.0
2022-10-07 15:00:00	IWM	ETF	169.02	169.3	167.92	168.61	4962252.0
2022-10-07 16:00:00	IWM	ETF	168.61	168.72	168.35	168.6	987279.0
2022-10-07 17:00:00	IWM	ETF	168.55	168.61	168.47	168.52	179649.0
2022-10-07 18:00:00	IWM	ETF	168.47	168.54	168.31	168.31	7891.0
2022-10-07 19:00:00	IWM	ETF	168.27	168.36	168.13	168.33	7842.0
2022-10-07 05:00:00	DIA	ETF	299.86	300.0	299.86	300.0	420.0
2022-10-07 06:00:00	DIA	ETF	299.44	299.71	299.44	299.71	1900.0

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

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