PREVIEW / etf_1hour / 2022-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-09-22.parquet
  size:    452 KB
  rows:    16,946

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-09-22 04:00:00	SPY	ETF	378.23	380.32	377.02	379.29	112510.0
2022-09-22 05:00:00	SPY	ETF	379.23	379.23	377.3	377.88	94459.0
2022-09-22 06:00:00	SPY	ETF	377.75	378.6	377.21	378.4	72436.0
2022-09-22 07:00:00	SPY	ETF	378.31	378.57	376.17	377.79	473690.0
2022-09-22 08:00:00	SPY	ETF	378.48	379.15	375.19	378.39	1050067.0
2022-09-22 09:00:00	SPY	ETF	378.34	378.4	374.44	374.93	9976317.0
2022-09-22 10:00:00	SPY	ETF	374.95	376.57	373.96	374.09	10842596.0
2022-09-22 11:00:00	SPY	ETF	374.09	375.37	373.44	374.4484	7365009.0
2022-09-22 12:00:00	SPY	ETF	374.43	375.99	374.15	375.2	5937638.0
2022-09-22 13:00:00	SPY	ETF	375.1666	375.79	373.9438	375.43	4765033.0
2022-09-22 14:00:00	SPY	ETF	375.38	375.6599	373.72	375.42	5675778.0
2022-09-22 15:00:00	SPY	ETF	375.43	377.54	374.13	374.23	15609160.0
2022-09-22 16:00:00	SPY	ETF	374.23	374.89	373.87	374.44	4742965.0
2022-09-22 17:00:00	SPY	ETF	374.48	374.84	374.22	374.79	84895.0
2022-09-22 18:00:00	SPY	ETF	374.74	374.94	374.24	374.55	99206.0
2022-09-22 19:00:00	SPY	ETF	374.55	375.03	374.47	374.99	58863.0
2022-09-22 20:00:00	SPY	ETF	375.0	375.0	375.0	375.0	500.0
2022-09-22 04:00:00	QQQ	ETF	283.06	285.7	283.06	284.77	141939.0
2022-09-22 05:00:00	QQQ	ETF	284.78	284.78	283.0	283.53	75502.0
2022-09-22 06:00:00	QQQ	ETF	283.28	284.2	282.96	284.04	125031.0
2022-09-22 07:00:00	QQQ	ETF	283.96	284.23	281.96	283.36	453176.0
2022-09-22 08:00:00	QQQ	ETF	284.0	285.67	281.53	283.76	1033869.0
2022-09-22 09:00:00	QQQ	ETF	283.769	283.87	280.3	280.81	9080436.0
2022-09-22 10:00:00	QQQ	ETF	280.81	281.97	279.45	279.625	9113442.0
2022-09-22 11:00:00	QQQ	ETF	279.62	280.765	278.815	280.12	5934754.0
2022-09-22 12:00:00	QQQ	ETF	280.11	281.23	279.55	280.47	3996687.0
2022-09-22 13:00:00	QQQ	ETF	280.48	281.115	279.45	280.79	3726876.0
2022-09-22 14:00:00	QQQ	ETF	280.76	280.98	279.08	280.56	3923129.0
2022-09-22 15:00:00	QQQ	ETF	280.56	283.03	279.98	280.05	10153340.0
2022-09-22 16:00:00	QQQ	ETF	280.04	280.39	279.6	280.2	2296564.0
2022-09-22 17:00:00	QQQ	ETF	280.26	280.75	280.07	280.64	241249.0
2022-09-22 18:00:00	QQQ	ETF	280.64	280.64	280.0	280.32	157499.0
2022-09-22 19:00:00	QQQ	ETF	280.27	280.73	280.27	280.69	84415.0
2022-09-22 04:00:00	IWM	ETF	175.8	176.82	175.38	176.21	31154.0
2022-09-22 05:00:00	IWM	ETF	176.26	176.26	175.27	175.55	42274.0
2022-09-22 06:00:00	IWM	ETF	175.54	175.99	175.26	175.93	16686.0
2022-09-22 07:00:00	IWM	ETF	175.86	175.99	174.79	175.69	83527.0
2022-09-22 08:00:00	IWM	ETF	175.89	176.29	174.72	175.95	131484.0
2022-09-22 09:00:00	IWM	ETF	175.92	175.92	172.45	172.64	2154094.0
2022-09-22 10:00:00	IWM	ETF	172.63	173.325	171.535	171.65	4104208.0
2022-09-22 11:00:00	IWM	ETF	171.65	172.32	171.35	171.64	2607711.0
2022-09-22 12:00:00	IWM	ETF	171.65	172.08	171.255	171.46	1769490.0
2022-09-22 13:00:00	IWM	ETF	171.44	172.01	170.945	171.82	2004548.0
2022-09-22 14:00:00	IWM	ETF	171.79	171.875	170.7405	171.36	3819033.0
2022-09-22 15:00:00	IWM	ETF	171.36	172.655	171.36	171.41	4859917.0
2022-09-22 16:00:00	IWM	ETF	171.39	171.75	171.26	171.68	2507310.0
2022-09-22 17:00:00	IWM	ETF	171.57	171.7	171.39	171.7	208682.0
2022-09-22 18:00:00	IWM	ETF	171.74	171.85	171.45	171.59	95265.0
2022-09-22 19:00:00	IWM	ETF	171.6	171.9	171.6	171.88	33283.0
2022-09-22 04:00:00	DIA	ETF	302.43	303.7	302.43	303.2	9735.0

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

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