PREVIEW / etf_1hour / 2022-06-16

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-16.parquet
  size:    471 KB
  rows:    17,371

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-16 04:00:00	SPY	ETF	371.83	378.45	370.5	370.5	145692.0
2022-06-16 05:00:00	SPY	ETF	370.46	371.0	369.44	370.93	231269.0
2022-06-16 06:00:00	SPY	ETF	370.85	371.6	369.78	370.1	302375.0
2022-06-16 07:00:00	SPY	ETF	370.03	371.21	369.76	370.8	787466.0
2022-06-16 08:00:00	SPY	ETF	370.12	380.59	369.8096	371.36	1162160.0
2022-06-16 09:00:00	SPY	ETF	371.35	371.94	368.01	368.8181	11697973.0
2022-06-16 10:00:00	SPY	ETF	368.81	369.15	365.76	366.06	14337952.0
2022-06-16 11:00:00	SPY	ETF	366.07	368.78	365.96	367.885	8989448.0
2022-06-16 12:00:00	SPY	ETF	367.87	368.11	366.25	367.6737	8278918.0
2022-06-16 13:00:00	SPY	ETF	367.69	368.95	365.8	365.8265	8866810.0
2022-06-16 14:00:00	SPY	ETF	365.83	366.39	364.0799	364.82	10303730.0
2022-06-16 15:00:00	SPY	ETF	364.8	367.45	364.65	366.93	27657640.0
2022-06-16 16:00:00	SPY	ETF	366.9001	367.91	366.35	367.7	7872900.0
2022-06-16 17:00:00	SPY	ETF	367.71	368.0	367.58	367.74	126101.0
2022-06-16 18:00:00	SPY	ETF	367.74	368.35	367.5	367.59	158460.0
2022-06-16 19:00:00	SPY	ETF	367.65	368.44	366.83	367.67	117142.0
2022-06-16 04:00:00	QQQ	ETF	280.96	280.96	274.85	274.88	487944.0
2022-06-16 05:00:00	QQQ	ETF	274.75	275.58	274.15	275.43	480028.0
2022-06-16 06:00:00	QQQ	ETF	275.47	276.13	274.71	275.01	319583.0
2022-06-16 07:00:00	QQQ	ETF	275.05	275.87	274.47	275.41	1119375.0
2022-06-16 08:00:00	QQQ	ETF	275.42	284.73	274.4996	276.24	1436441.0
2022-06-16 09:00:00	QQQ	ETF	276.27	276.61	273.71	274.06	9482706.0
2022-06-16 10:00:00	QQQ	ETF	274.06	274.09	270.74	271.1	9282272.0
2022-06-16 11:00:00	QQQ	ETF	271.11	273.4401	271.02	272.29	6804240.0
2022-06-16 12:00:00	QQQ	ETF	272.28	272.809	271.11	272.35	4542727.0
2022-06-16 13:00:00	QQQ	ETF	272.38	273.31	270.37	270.41	5539907.0
2022-06-16 14:00:00	QQQ	ETF	270.405	270.96	269.28	269.98	5918036.0
2022-06-16 15:00:00	QQQ	ETF	269.94	271.99	269.805	271.64	11941256.0
2022-06-16 16:00:00	QQQ	ETF	271.63	272.59	271.11	272.52	2617582.0
2022-06-16 17:00:00	QQQ	ETF	272.58	272.72	271.39	272.35	1057960.0
2022-06-16 18:00:00	QQQ	ETF	272.41	272.95	271.39	272.11	206007.0
2022-06-16 19:00:00	QQQ	ETF	272.16	272.46	271.58	272.22	246815.0
2022-06-16 04:00:00	IWM	ETF	168.74	169.21	168.08	168.08	41619.0
2022-06-16 05:00:00	IWM	ETF	168.03	168.18	167.44	168.18	33384.0
2022-06-16 06:00:00	IWM	ETF	168.09	168.35	167.37	167.45	174497.0
2022-06-16 07:00:00	IWM	ETF	167.46	168.07	167.3	167.68	264873.0
2022-06-16 08:00:00	IWM	ETF	167.48	171.0	167.3801	168.18	172275.0
2022-06-16 09:00:00	IWM	ETF	168.2	168.52	165.43	165.44	3591355.0
2022-06-16 10:00:00	IWM	ETF	165.4	165.84	163.71	163.74	4381193.0
2022-06-16 11:00:00	IWM	ETF	163.74	165.48	163.65	164.94	3616457.0
2022-06-16 12:00:00	IWM	ETF	164.94	165.09	164.01	164.49	2067788.0
2022-06-16 13:00:00	IWM	ETF	164.47	165.1	163.83	163.83	3155462.0
2022-06-16 14:00:00	IWM	ETF	163.82	164.07	162.78	163.2	2627925.0
2022-06-16 15:00:00	IWM	ETF	163.205	164.455	162.84	163.91	8313252.0
2022-06-16 16:00:00	IWM	ETF	163.9	164.27	163.56	164.16	2142264.0
2022-06-16 17:00:00	IWM	ETF	164.02	164.35	164.01	164.21	20873.0
2022-06-16 18:00:00	IWM	ETF	164.47	164.49	164.05	164.17	25049.0
2022-06-16 19:00:00	IWM	ETF	164.17	164.36	163.86	164.11	39661.0
2022-06-16 04:00:00	DIA	ETF	307.0	307.0	302.65	303.0	2950.0
2022-06-16 05:00:00	DIA	ETF	301.84	301.98	301.04	301.98	8510.0

> showing 50 of 17,371 rows — these rows as CSV

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