PREVIEW / etf_1hour / 2021-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-09-22.parquet
  size:    421 KB
  rows:    14,674

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
2021-09-22 04:00:00	SPY	ETF	434.02	436.12	433.02	436.03	39098.0
2021-09-22 05:00:00	SPY	ETF	436.03	436.25	435.51	435.96	40692.0
2021-09-22 06:00:00	SPY	ETF	435.97	436.56	435.97	435.98	178489.0
2021-09-22 07:00:00	SPY	ETF	435.99	436.13	435.67	435.98	168647.0
2021-09-22 08:00:00	SPY	ETF	435.9199	436.5096	433.915	436.27	364840.0
2021-09-22 09:00:00	SPY	ETF	436.35	436.83	435.07	436.83	6314210.0
2021-09-22 10:00:00	SPY	ETF	436.82	438.05	436.61	437.955	9369690.0
2021-09-22 11:00:00	SPY	ETF	437.96	439.57	437.93	438.94	8336425.0
2021-09-22 12:00:00	SPY	ETF	438.93	439.03	438.28	438.47	4453836.0
2021-09-22 13:00:00	SPY	ETF	438.46	438.4899	437.53	438.01	5652332.0
2021-09-22 14:00:00	SPY	ETF	437.98	440.03	436.6	437.62	20657630.0
2021-09-22 15:00:00	SPY	ETF	437.6296	439.73	437.11	437.83	21258544.0
2021-09-22 16:00:00	SPY	ETF	437.82	438.33	437.6	438.05	3886974.0
2021-09-22 17:00:00	SPY	ETF	437.94	438.05	437.88	437.97	77398.0
2021-09-22 18:00:00	SPY	ETF	438.0	438.36	437.86	438.31	681457.0
2021-09-22 19:00:00	SPY	ETF	438.38	438.71	438.25	438.6	81918.0
2021-09-22 04:00:00	QQQ	ETF	366.74	367.75	366.73	367.61	34894.0
2021-09-22 05:00:00	QQQ	ETF	367.67	367.71	367.0	367.3	34431.0
2021-09-22 06:00:00	QQQ	ETF	367.38	367.65	367.34	367.35	45627.0
2021-09-22 07:00:00	QQQ	ETF	367.32	367.35	366.93	367.21	193212.0
2021-09-22 08:00:00	QQQ	ETF	367.2899	367.82	366.01	367.63	153033.0
2021-09-22 09:00:00	QQQ	ETF	367.69	368.08	365.9584	367.455	4273462.0
2021-09-22 10:00:00	QQQ	ETF	367.46	368.94	367.43	368.7	4808457.0
2021-09-22 11:00:00	QQQ	ETF	368.71	370.51	368.71	369.88	3417914.0
2021-09-22 12:00:00	QQQ	ETF	369.89	369.97	369.14	369.285	2174981.0
2021-09-22 13:00:00	QQQ	ETF	369.28	369.3273	368.34	368.895	2815414.0
2021-09-22 14:00:00	QQQ	ETF	368.87	371.07	367.58	368.6	12195587.0
2021-09-22 15:00:00	QQQ	ETF	368.61	371.0	368.14	369.55	6692805.0
2021-09-22 16:00:00	QQQ	ETF	369.52	369.99	369.4	369.94	699379.0
2021-09-22 17:00:00	QQQ	ETF	369.96	370.07	369.8	370.0	33625.0
2021-09-22 18:00:00	QQQ	ETF	370.0	370.15	369.91	370.13	48502.0
2021-09-22 19:00:00	QQQ	ETF	370.19	370.41	370.06	370.29	47914.0
2021-09-22 04:00:00	IWM	ETF	218.39	219.24	218.39	219.17	15558.0
2021-09-22 05:00:00	IWM	ETF	219.22	219.27	218.74	218.94	22221.0
2021-09-22 06:00:00	IWM	ETF	219.08	219.55	219.05	219.11	94684.0
2021-09-22 07:00:00	IWM	ETF	219.11	219.18	218.85	218.98	90196.0
2021-09-22 08:00:00	IWM	ETF	219.0	219.23	217.87	219.03	89175.0
2021-09-22 09:00:00	IWM	ETF	219.02	220.46	218.6	220.43	4069414.0
2021-09-22 10:00:00	IWM	ETF	220.44	220.62	219.53	220.42	3093696.0
2021-09-22 11:00:00	IWM	ETF	220.43	221.65	220.325	221.2	3217774.0
2021-09-22 12:00:00	IWM	ETF	221.22	221.31	220.75	220.95	1430640.0
2021-09-22 13:00:00	IWM	ETF	220.94	221.15	220.5	221.07	1597992.0
2021-09-22 14:00:00	IWM	ETF	220.69	222.55	220.43	221.19	5619906.0
2021-09-22 15:00:00	IWM	ETF	221.23	222.12	220.69	220.83	4861315.0
2021-09-22 16:00:00	IWM	ETF	220.9	221.29	220.69	220.9	1832451.0
2021-09-22 17:00:00	IWM	ETF	220.73	220.97	220.66	220.76	467619.0
2021-09-22 18:00:00	IWM	ETF	220.89	221.29	220.89	221.29	44428.0
2021-09-22 19:00:00	IWM	ETF	221.3	221.39	221.15	221.32	31859.0
2021-09-22 04:00:00	DIA	ETF	340.26	341.05	340.26	340.95	3791.0
2021-09-22 05:00:00	DIA	ETF	340.93	341.09	340.66	340.95	2825.0

> showing 50 of 14,674 rows — these rows as CSV

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