PREVIEW / etf_1hour / 2022-06-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-23.parquet
  size:    454 KB
  rows:    16,430

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-06-23 04:00:00	SPY	ETF	372.55	375.51	372.24	373.92	83399.0
2022-06-23 05:00:00	SPY	ETF	373.98	375.81	373.98	375.54	108180.0
2022-06-23 06:00:00	SPY	ETF	375.65	377.53	375.56	377.39	151206.0
2022-06-23 07:00:00	SPY	ETF	377.41	377.85	376.85	377.32	380703.0
2022-06-23 08:00:00	SPY	ETF	377.21	377.8	372.0	376.25	943138.0
2022-06-23 09:00:00	SPY	ETF	376.24	377.38	374.8	377.0125	8099706.0
2022-06-23 10:00:00	SPY	ETF	377.015	378.1	375.32	377.82	8145567.0
2022-06-23 11:00:00	SPY	ETF	377.83	378.2	375.05	375.2	6456102.0
2022-06-23 12:00:00	SPY	ETF	375.21	375.43	373.08	373.5766	7436323.0
2022-06-23 13:00:00	SPY	ETF	373.58	374.99	372.89	374.86	6677522.0
2022-06-23 14:00:00	SPY	ETF	374.865	376.515	374.52	376.19	6066913.0
2022-06-23 15:00:00	SPY	ETF	376.17	378.83	375.71	378.13	12604783.0
2022-06-23 16:00:00	SPY	ETF	378.12	378.14	376.1653	376.67	2999272.0
2022-06-23 17:00:00	SPY	ETF	376.64	376.9	376.64	376.84	71578.0
2022-06-23 18:00:00	SPY	ETF	376.84	377.34	376.6	377.19	93166.0
2022-06-23 19:00:00	SPY	ETF	377.21	377.49	376.7	376.77	56037.0
2022-06-23 04:00:00	QQQ	ETF	279.5	282.32	279.5	281.43	180799.0
2022-06-23 05:00:00	QQQ	ETF	281.4	282.89	281.4	282.69	142596.0
2022-06-23 06:00:00	QQQ	ETF	282.7	284.18	282.5	284.02	172884.0
2022-06-23 07:00:00	QQQ	ETF	283.94	284.27	283.39	283.67	330249.0
2022-06-23 08:00:00	QQQ	ETF	283.69	284.21	279.8	282.7996	803822.0
2022-06-23 09:00:00	QQQ	ETF	282.83	283.78	280.31	282.83	8104808.0
2022-06-23 10:00:00	QQQ	ETF	282.8	284.84	281.54	284.6201	7820324.0
2022-06-23 11:00:00	QQQ	ETF	284.63	285.14	282.84	282.91	5167477.0
2022-06-23 12:00:00	QQQ	ETF	282.93	283.05	280.91	281.1967	5518737.0
2022-06-23 13:00:00	QQQ	ETF	281.21	282.27	280.41	282.16	4782005.0
2022-06-23 14:00:00	QQQ	ETF	282.18	283.67	281.84	283.35	3917630.0
2022-06-23 15:00:00	QQQ	ETF	283.35	285.72	282.93	284.9	8153485.0
2022-06-23 16:00:00	QQQ	ETF	284.91	284.91	283.67	283.77	1443452.0
2022-06-23 17:00:00	QQQ	ETF	283.77	284.01	283.73	283.98	88863.0
2022-06-23 18:00:00	QQQ	ETF	283.92	284.44	283.83	284.25	128230.0
2022-06-23 19:00:00	QQQ	ETF	284.33	284.65	283.9	284.06	157490.0
2022-06-23 04:00:00	IWM	ETF	166.77	167.89	166.77	167.21	30985.0
2022-06-23 05:00:00	IWM	ETF	167.17	168.22	167.17	168.04	23753.0
2022-06-23 06:00:00	IWM	ETF	168.06	168.94	168.03	168.8	47779.0
2022-06-23 07:00:00	IWM	ETF	168.81	169.1	168.59	168.91	66837.0
2022-06-23 08:00:00	IWM	ETF	168.84	169.04	167.9	168.18	82300.0
2022-06-23 09:00:00	IWM	ETF	168.24	169.2	167.19	168.42	2897365.0
2022-06-23 10:00:00	IWM	ETF	168.42	169.35	167.71	169.14	2795845.0
2022-06-23 11:00:00	IWM	ETF	169.17	169.36	167.99	168.28	2240816.0
2022-06-23 12:00:00	IWM	ETF	168.28	168.29	166.9329	167.02	2249299.0
2022-06-23 13:00:00	IWM	ETF	166.99	167.71	166.55	167.58	1933622.0
2022-06-23 14:00:00	IWM	ETF	167.6	168.68	167.38	168.62	1883543.0
2022-06-23 15:00:00	IWM	ETF	168.61	170.23	168.41	169.85	6608321.0
2022-06-23 16:00:00	IWM	ETF	169.86	169.87	168.89	168.98	731929.0
2022-06-23 17:00:00	IWM	ETF	169.19	169.31	169.0	169.3	12663.0
2022-06-23 18:00:00	IWM	ETF	169.19	169.46	169.01	169.41	27758.0
2022-06-23 19:00:00	IWM	ETF	169.37	169.53	169.04	169.05	19982.0
2022-06-23 04:00:00	DIA	ETF	302.79	303.81	302.79	303.81	3298.0
2022-06-23 05:00:00	DIA	ETF	304.11	305.07	303.99	305.0	4000.0

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

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