PREVIEW / etf_1hour / 2021-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-10-01.parquet
  size:    431 KB
  rows:    15,036

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-10-01 04:00:00	SPY	ETF	427.22	427.85	426.1	426.48	99048.0
2021-10-01 05:00:00	SPY	ETF	426.69	427.29	426.68	426.95	43639.0
2021-10-01 06:00:00	SPY	ETF	427.02	427.89	426.96	427.89	198196.0
2021-10-01 07:00:00	SPY	ETF	427.86	431.33	427.84	430.6	1351885.0
2021-10-01 08:00:00	SPY	ETF	430.65	431.51	425.65	430.42	1617284.0
2021-10-01 09:00:00	SPY	ETF	430.48	431.61	428.8	429.41	10642267.0
2021-10-01 10:00:00	SPY	ETF	429.4	430.319	427.23	429.19	18820844.0
2021-10-01 11:00:00	SPY	ETF	429.18	432.1	428.28	431.44	12884725.0
2021-10-01 12:00:00	SPY	ETF	431.44	431.95	430.75	431.43	6763708.0
2021-10-01 13:00:00	SPY	ETF	431.43	433.89	430.99	433.295	8899487.0
2021-10-01 14:00:00	SPY	ETF	433.29	434.93	433.29	434.755	9165504.0
2021-10-01 15:00:00	SPY	ETF	434.755	436.0329	433.57	434.19	22923652.0
2021-10-01 16:00:00	SPY	ETF	434.18	434.76	433.88	434.58	5238485.0
2021-10-01 17:00:00	SPY	ETF	434.59	435.0	434.59	434.78	174080.0
2021-10-01 18:00:00	SPY	ETF	434.8	434.95	434.75	434.95	34740.0
2021-10-01 19:00:00	SPY	ETF	434.95	434.99	434.8	434.88	20762.0
2021-10-01 04:00:00	QQQ	ETF	356.75	356.75	355.45	355.7	105595.0
2021-10-01 05:00:00	QQQ	ETF	355.8	356.44	355.8	356.3	63104.0
2021-10-01 06:00:00	QQQ	ETF	356.46	356.93	356.21	356.9	86959.0
2021-10-01 07:00:00	QQQ	ETF	356.89	359.21	356.89	358.72	509682.0
2021-10-01 08:00:00	QQQ	ETF	358.7899	359.36	354.88	358.4	1039461.0
2021-10-01 09:00:00	QQQ	ETF	358.42	359.18	356.03	356.61	6068834.0
2021-10-01 10:00:00	QQQ	ETF	356.59	356.9499	354.38	356.41	9270100.0
2021-10-01 11:00:00	QQQ	ETF	356.4	358.54	355.52	358.09	6135864.0
2021-10-01 12:00:00	QQQ	ETF	358.106	358.31	357.03	357.46	4211833.0
2021-10-01 13:00:00	QQQ	ETF	357.47	359.39	357.08	358.785	3976957.0
2021-10-01 14:00:00	QQQ	ETF	358.8	360.5599	358.77	360.33	3861792.0
2021-10-01 15:00:00	QQQ	ETF	360.32	361.25	359.71	360.11	8063731.0
2021-10-01 16:00:00	QQQ	ETF	360.11	360.48	359.8	360.25	1889325.0
2021-10-01 17:00:00	QQQ	ETF	360.35	360.5	360.01	360.24	152147.0
2021-10-01 18:00:00	QQQ	ETF	360.24	360.33	360.21	360.21	14289.0
2021-10-01 19:00:00	QQQ	ETF	360.29	360.34	360.15	360.2999	12045.0
2021-10-01 04:00:00	IWM	ETF	218.06	218.06	216.12	217.01	56143.0
2021-10-01 05:00:00	IWM	ETF	217.03	217.39	216.83	216.95	35005.0
2021-10-01 06:00:00	IWM	ETF	217.14	217.72	216.97	217.72	186563.0
2021-10-01 07:00:00	IWM	ETF	217.75	220.28	217.74	219.63	522096.0
2021-10-01 08:00:00	IWM	ETF	219.67	220.49	216.5	219.7	500771.0
2021-10-01 09:00:00	IWM	ETF	219.75	220.37	218.45	218.97	3444701.0
2021-10-01 10:00:00	IWM	ETF	219.02	219.89	217.74	219.23	4277604.0
2021-10-01 11:00:00	IWM	ETF	219.23	221.15	218.64	220.85	3549839.0
2021-10-01 12:00:00	IWM	ETF	220.87	221.15	220.5	220.91	2405101.0
2021-10-01 13:00:00	IWM	ETF	220.9	222.635	220.65	222.38	2859385.0
2021-10-01 14:00:00	IWM	ETF	222.39	223.5	222.38	223.065	2805549.0
2021-10-01 15:00:00	IWM	ETF	223.07	223.5	222.17	222.28	5756683.0
2021-10-01 16:00:00	IWM	ETF	222.29	222.9	222.28	222.65	856938.0
2021-10-01 17:00:00	IWM	ETF	222.52	222.99	222.51	222.89	29571.0
2021-10-01 18:00:00	IWM	ETF	222.76	222.97	222.76	222.82	11249.0
2021-10-01 19:00:00	IWM	ETF	222.88	222.98	222.75	222.8	5970.0
2021-10-01 04:00:00	DIA	ETF	336.59	336.59	335.77	336.09	11684.0
2021-10-01 05:00:00	DIA	ETF	336.36	336.53	336.2	336.2	2494.0

> showing 50 of 15,036 rows — these rows as CSV

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