PREVIEW / etf_1hour / 2022-07-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-01.parquet
  size:    443 KB
  rows:    16,197

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-07-01 04:00:00	SPY	ETF	374.69	376.34	373.8	376.11	48792.0
2022-07-01 05:00:00	SPY	ETF	376.11	377.2	375.82	377.11	73755.0
2022-07-01 06:00:00	SPY	ETF	377.25	377.8	375.71	375.74	63887.0
2022-07-01 07:00:00	SPY	ETF	375.88	376.4	374.75	375.31	209380.0
2022-07-01 08:00:00	SPY	ETF	375.5801	377.19	373.5	376.3	478559.0
2022-07-01 09:00:00	SPY	ETF	376.51	379.71	375.75	378.69	7420865.0
2022-07-01 10:00:00	SPY	ETF	378.69	380.03	373.8	375.4	11655186.0
2022-07-01 11:00:00	SPY	ETF	375.4	377.51	374.69	375.4	6084649.0
2022-07-01 12:00:00	SPY	ETF	375.44	377.1399	374.9001	375.67	3930700.0
2022-07-01 13:00:00	SPY	ETF	375.68	378.32	375.46	378.2197	5227504.0
2022-07-01 14:00:00	SPY	ETF	378.23	380.19	377.3	379.9	6390466.0
2022-07-01 15:00:00	SPY	ETF	379.9	381.7	378.93	381.2	14096399.0
2022-07-01 16:00:00	SPY	ETF	381.2	381.42	380.9	381.02	3774462.0
2022-07-01 17:00:00	SPY	ETF	381.18	381.2	380.94	381.2	118385.0
2022-07-01 18:00:00	SPY	ETF	381.15	381.48	380.95	381.08	19128.0
2022-07-01 19:00:00	SPY	ETF	381.14	381.26	381.0	381.07	16178.0
2022-07-01 04:00:00	QQQ	ETF	277.98	279.31	277.29	279.19	308589.0
2022-07-01 05:00:00	QQQ	ETF	279.17	279.94	278.9	279.9	57185.0
2022-07-01 06:00:00	QQQ	ETF	279.93	279.93	278.44	278.58	93262.0
2022-07-01 07:00:00	QQQ	ETF	278.64	279.34	277.7	278.13	286669.0
2022-07-01 08:00:00	QQQ	ETF	278.12	279.9396	277.29	279.24	631051.0
2022-07-01 09:00:00	QQQ	ETF	279.33	281.82	277.4	280.846	8376150.0
2022-07-01 10:00:00	QQQ	ETF	280.87	282.26	277.03	278.38	8960737.0
2022-07-01 11:00:00	QQQ	ETF	278.38	280.16	277.63	278.28	5054301.0
2022-07-01 12:00:00	QQQ	ETF	278.27	279.34	277.65	277.88	3423652.0
2022-07-01 13:00:00	QQQ	ETF	277.82	279.97	277.76	279.935	4146173.0
2022-07-01 14:00:00	QQQ	ETF	279.94	281.54	279.0	281.29	3852508.0
2022-07-01 15:00:00	QQQ	ETF	281.31	282.53	280.39	282.13	8806833.0
2022-07-01 16:00:00	QQQ	ETF	282.13	282.31	281.92	282.21	1502323.0
2022-07-01 17:00:00	QQQ	ETF	282.12	282.3	282.03	282.03	42689.0
2022-07-01 18:00:00	QQQ	ETF	282.04	282.2	282.0	282.1	12216.0
2022-07-01 19:00:00	QQQ	ETF	282.19	282.19	282.01	282.17	13506.0
2022-07-01 04:00:00	IWM	ETF	167.83	168.84	167.6	168.74	39119.0
2022-07-01 05:00:00	IWM	ETF	168.67	169.46	168.67	169.36	14410.0
2022-07-01 06:00:00	IWM	ETF	169.27	169.47	168.7	168.7	24208.0
2022-07-01 07:00:00	IWM	ETF	168.8	168.88	168.24	168.41	50947.0
2022-07-01 08:00:00	IWM	ETF	168.7599	169.3704	167.78	169.06	50776.0
2022-07-01 09:00:00	IWM	ETF	169.13	171.48	168.72	170.84	2380428.0
2022-07-01 10:00:00	IWM	ETF	170.87	171.37	167.66	168.89	2880134.0
2022-07-01 11:00:00	IWM	ETF	168.89	170.11	168.39	168.66	2428320.0
2022-07-01 12:00:00	IWM	ETF	168.65	169.51	168.23	168.67	1726353.0
2022-07-01 13:00:00	IWM	ETF	168.63	170.36	168.5	170.28	1871328.0
2022-07-01 14:00:00	IWM	ETF	170.29	171.18	169.795	171.08	2047846.0
2022-07-01 15:00:00	IWM	ETF	171.08	171.84	170.6	171.49	3984854.0
2022-07-01 16:00:00	IWM	ETF	171.41	171.62	171.3	171.3	1465338.0
2022-07-01 17:00:00	IWM	ETF	171.33	171.78	171.33	171.78	32300.0
2022-07-01 18:00:00	IWM	ETF	171.69	171.95	171.68	171.85	15404.0
2022-07-01 19:00:00	IWM	ETF	171.71	172.55	171.67	171.95	15801.0
2022-07-01 04:00:00	DIA	ETF	305.8	306.7	305.2	306.52	4813.0
2022-07-01 05:00:00	DIA	ETF	307.3	307.81	307.1	307.81	1514.0

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

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