PREVIEW / etf_1hour / 2022-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-31.parquet
  size:    461 KB
  rows:    16,909

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-10-31 04:00:00	SPY	ETF	388.8	389.45	386.42	386.9	202004.0
2022-10-31 05:00:00	SPY	ETF	386.83	387.5	386.53	387.1	32480.0
2022-10-31 06:00:00	SPY	ETF	387.01	387.43	386.8	387.33	71260.0
2022-10-31 07:00:00	SPY	ETF	387.35	388.23	387.34	387.57	299147.0
2022-10-31 08:00:00	SPY	ETF	387.84	388.78	386.53	386.97	554583.0
2022-10-31 09:00:00	SPY	ETF	386.94	387.47	385.47	385.4749	7191745.0
2022-10-31 10:00:00	SPY	ETF	385.48	386.915	385.26	386.12	8156254.0
2022-10-31 11:00:00	SPY	ETF	386.12	388.4	386.04	387.08	7919834.0
2022-10-31 12:00:00	SPY	ETF	387.09	388.0	385.78	386.25	6017869.0
2022-10-31 13:00:00	SPY	ETF	386.25	387.5895	385.811	387.07	5017740.0
2022-10-31 14:00:00	SPY	ETF	387.07	387.72	386.52	386.845	6500433.0
2022-10-31 15:00:00	SPY	ETF	386.87	387.45	385.52	386.21	19311055.0
2022-10-31 16:00:00	SPY	ETF	386.22	386.63	385.91	386.23	6374865.0
2022-10-31 17:00:00	SPY	ETF	386.37	386.37	385.98	386.26	147384.0
2022-10-31 18:00:00	SPY	ETF	386.26	386.7	386.11	386.46	105899.0
2022-10-31 19:00:00	SPY	ETF	386.56	387.0	386.4	386.79	73128.0
2022-10-31 04:00:00	QQQ	ETF	280.94	280.94	278.83	279.22	132100.0
2022-10-31 05:00:00	QQQ	ETF	279.14	279.65	278.95	279.32	54039.0
2022-10-31 06:00:00	QQQ	ETF	279.3	279.59	279.08	279.51	70179.0
2022-10-31 07:00:00	QQQ	ETF	279.55	280.32	279.55	279.83	274929.0
2022-10-31 08:00:00	QQQ	ETF	279.94	280.89	278.98	279.3196	533718.0
2022-10-31 09:00:00	QQQ	ETF	279.33	279.76	277.13	277.385	6798158.0
2022-10-31 10:00:00	QQQ	ETF	277.37	278.09	275.99	277.1	7229582.0
2022-10-31 11:00:00	QQQ	ETF	277.09	279.24	276.97	278.24	5077533.0
2022-10-31 12:00:00	QQQ	ETF	278.27	279.535	277.4	277.9	3154684.0
2022-10-31 13:00:00	QQQ	ETF	277.91	279.15	277.46	278.55	2710561.0
2022-10-31 14:00:00	QQQ	ETF	278.55	279.16	278.04	278.39	3070696.0
2022-10-31 15:00:00	QQQ	ETF	278.41	278.73	277.16	277.92	6700332.0
2022-10-31 16:00:00	QQQ	ETF	277.92	278.41	277.66	278.05	1451610.0
2022-10-31 17:00:00	QQQ	ETF	278.04	278.1	277.95	278.01	314691.0
2022-10-31 18:00:00	QQQ	ETF	278.05	278.35	277.87	278.27	43075.0
2022-10-31 19:00:00	QQQ	ETF	278.29	278.64	278.29	278.39	37926.0
2022-10-31 04:00:00	IWM	ETF	183.16	183.16	182.0	182.18	16322.0
2022-10-31 05:00:00	IWM	ETF	182.19	182.64	182.08	182.52	11084.0
2022-10-31 06:00:00	IWM	ETF	182.45	182.58	182.3	182.45	16012.0
2022-10-31 07:00:00	IWM	ETF	182.59	183.16	182.59	182.83	23024.0
2022-10-31 08:00:00	IWM	ETF	183.0401	183.28	182.26	182.48	62523.0
2022-10-31 09:00:00	IWM	ETF	182.45	183.08	181.55	182.01	2133973.0
2022-10-31 10:00:00	IWM	ETF	182.01	183.315	181.93	182.72	2239830.0
2022-10-31 11:00:00	IWM	ETF	182.73	184.24	182.65	183.4	2750909.0
2022-10-31 12:00:00	IWM	ETF	183.43	184.16	182.8299	183.26	2384196.0
2022-10-31 13:00:00	IWM	ETF	183.265	183.95	182.85	183.6	2048164.0
2022-10-31 14:00:00	IWM	ETF	183.61	184.05	183.285	183.49	1844680.0
2022-10-31 15:00:00	IWM	ETF	183.5	184.06	182.9	183.32	4844103.0
2022-10-31 16:00:00	IWM	ETF	183.33	183.49	183.17	183.25	1127684.0
2022-10-31 17:00:00	IWM	ETF	183.26	183.46	183.26	183.45	192215.0
2022-10-31 18:00:00	IWM	ETF	183.38	183.44	183.21	183.32	315650.0
2022-10-31 19:00:00	IWM	ETF	183.36	183.69	183.36	183.5	13093.0
2022-10-31 04:00:00	DIA	ETF	328.35	328.5	327.0	327.24	96031.0
2022-10-31 05:00:00	DIA	ETF	327.22	327.46	327.03	327.46	1400.0

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

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