PREVIEW / etf_1hour / 2022-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-01.parquet
  size:    459 KB
  rows:    17,170

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-11-01 04:00:00	SPY	ETF	388.37	389.76	388.01	389.22	76403.0
2022-11-01 05:00:00	SPY	ETF	389.2	389.62	388.68	389.51	71337.0
2022-11-01 06:00:00	SPY	ETF	389.63	390.15	389.35	390.04	85446.0
2022-11-01 07:00:00	SPY	ETF	389.86	390.18	389.45	389.98	250536.0
2022-11-01 08:00:00	SPY	ETF	389.5625	390.73	387.6	390.35	629934.0
2022-11-01 09:00:00	SPY	ETF	390.36	390.45	387.74	388.0407	8055718.0
2022-11-01 10:00:00	SPY	ETF	388.12	388.4	383.58	384.01	14288966.0
2022-11-01 11:00:00	SPY	ETF	384.01	384.82	383.29	384.54	7807397.0
2022-11-01 12:00:00	SPY	ETF	384.5299	386.02	383.97	384.73	6861108.0
2022-11-01 13:00:00	SPY	ETF	384.73	385.45	384.27	385.09	4554927.0
2022-11-01 14:00:00	SPY	ETF	385.08	385.55	384.2701	385.3899	5303630.0
2022-11-01 15:00:00	SPY	ETF	385.39	385.8	384.48	384.53	11996985.0
2022-11-01 16:00:00	SPY	ETF	384.53	384.89	383.6	384.23	4835851.0
2022-11-01 17:00:00	SPY	ETF	384.2	384.52	384.12	384.161	43664.0
2022-11-01 18:00:00	SPY	ETF	384.22	384.65	384.22	384.6	69142.0
2022-11-01 19:00:00	SPY	ETF	384.62	384.87	384.36	384.49	142297.0
2022-11-01 04:00:00	QQQ	ETF	279.68	280.96	279.68	280.5	64355.0
2022-11-01 05:00:00	QQQ	ETF	280.46	280.94	280.09	280.93	37556.0
2022-11-01 06:00:00	QQQ	ETF	280.93	281.43	280.66	281.23	79698.0
2022-11-01 07:00:00	QQQ	ETF	281.16	281.44	280.85	281.28	248857.0
2022-11-01 08:00:00	QQQ	ETF	281.29	281.93	278.158	281.64	432671.0
2022-11-01 09:00:00	QQQ	ETF	281.66	282.07	279.18	279.51	5689267.0
2022-11-01 10:00:00	QQQ	ETF	279.53	279.83	275.41	275.77	10898292.0
2022-11-01 11:00:00	QQQ	ETF	275.78	276.69	275.0	275.91	4354345.0
2022-11-01 12:00:00	QQQ	ETF	275.9	277.04	274.74	275.6999	4114210.0
2022-11-01 13:00:00	QQQ	ETF	275.7	276.15	274.94	275.6	2431100.0
2022-11-01 14:00:00	QQQ	ETF	275.6	276.17	275.031	276.03	2194080.0
2022-11-01 15:00:00	QQQ	ETF	276.03	276.28	274.99	275.04	5277689.0
2022-11-01 16:00:00	QQQ	ETF	275.04	275.26	274.05	274.84	1275977.0
2022-11-01 17:00:00	QQQ	ETF	274.84	275.11	274.84	274.9	203264.0
2022-11-01 18:00:00	QQQ	ETF	274.89	275.39	274.88	275.3	63670.0
2022-11-01 19:00:00	QQQ	ETF	275.3	275.47	275.02	275.06	64329.0
2022-11-01 04:00:00	IWM	ETF	184.51	185.24	184.51	184.98	16866.0
2022-11-01 05:00:00	IWM	ETF	184.92	185.06	184.69	184.99	30834.0
2022-11-01 06:00:00	IWM	ETF	185.05	185.36	184.84	185.25	13339.0
2022-11-01 07:00:00	IWM	ETF	185.18	185.5	184.99	185.36	75372.0
2022-11-01 08:00:00	IWM	ETF	185.09	185.68	183.8	185.36	121623.0
2022-11-01 09:00:00	IWM	ETF	185.38	185.6	184.12	184.938	3554599.0
2022-11-01 10:00:00	IWM	ETF	184.94	185.02	183.2	183.5	4140911.0
2022-11-01 11:00:00	IWM	ETF	183.5	183.92	182.88	183.64	2146859.0
2022-11-01 12:00:00	IWM	ETF	183.62	184.42	183.46	184.295	1829688.0
2022-11-01 13:00:00	IWM	ETF	184.31	184.94	184.165	184.7	1612118.0
2022-11-01 14:00:00	IWM	ETF	184.7	184.81	183.82	184.305	1894398.0
2022-11-01 15:00:00	IWM	ETF	184.3	184.3101	183.27	183.63	3345304.0
2022-11-01 16:00:00	IWM	ETF	183.58	183.8166	183.04	183.34	2614456.0
2022-11-01 17:00:00	IWM	ETF	183.36	183.58	183.2024	183.41	72063.0
2022-11-01 18:00:00	IWM	ETF	183.46	183.57	183.27	183.5	8571.0
2022-11-01 19:00:00	IWM	ETF	183.37	183.66	183.33	183.4	51916.0
2022-11-01 04:00:00	DIA	ETF	328.82	329.49	328.82	329.37	6870.0
2022-11-01 05:00:00	DIA	ETF	328.91	329.35	328.91	329.35	579.0

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

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