PREVIEW / etf_1hour / 2023-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-12.parquet
  size:    479 KB
  rows:    17,572

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
2023-01-12 04:00:00	SPY	ETF	395.36	395.87	395.36	395.8	47225.0
2023-01-12 05:00:00	SPY	ETF	395.78	395.78	395.25	395.62	17872.0
2023-01-12 06:00:00	SPY	ETF	395.62	395.9	395.53	395.75	33653.0
2023-01-12 07:00:00	SPY	ETF	395.74	396.68	395.71	396.67	260414.0
2023-01-12 08:00:00	SPY	ETF	396.66	398.45	392.0	398.0	4754211.0
2023-01-12 09:00:00	SPY	ETF	398.05	398.78	392.42	393.71	10325506.0
2023-01-12 10:00:00	SPY	ETF	393.73	396.99	393.64	395.49	12496654.0
2023-01-12 11:00:00	SPY	ETF	395.51	396.54	394.36	396.36	5709824.0
2023-01-12 12:00:00	SPY	ETF	396.37	398.126	396.14	397.755	6481212.0
2023-01-12 13:00:00	SPY	ETF	397.75	398.43	395.53	398.26	8434041.0
2023-01-12 14:00:00	SPY	ETF	398.27	398.485	396.72	397.39	6545000.0
2023-01-12 15:00:00	SPY	ETF	397.3913	397.54	395.86	396.94	12186122.0
2023-01-12 16:00:00	SPY	ETF	396.93	397.16	396.79	396.92	5172870.0
2023-01-12 17:00:00	SPY	ETF	397.07	397.12	396.94	397.03	120732.0
2023-01-12 18:00:00	SPY	ETF	397.02	397.16	396.78	397.11	90311.0
2023-01-12 19:00:00	SPY	ETF	397.13	397.45	397.05	397.05	40119.0
2023-01-12 04:00:00	QQQ	ETF	277.6	278.0	277.48	277.89	42548.0
2023-01-12 05:00:00	QQQ	ETF	277.8	277.8	277.05	277.44	41046.0
2023-01-12 06:00:00	QQQ	ETF	277.44	277.55	277.4	277.42	13063.0
2023-01-12 07:00:00	QQQ	ETF	277.4	278.21	277.4	278.21	255230.0
2023-01-12 08:00:00	QQQ	ETF	277.5	279.75	273.3	279.37	5146172.0
2023-01-12 09:00:00	QQQ	ETF	279.41	280.15	273.74	274.86	9169531.0
2023-01-12 10:00:00	QQQ	ETF	274.89	278.57	274.83	276.6	8639899.0
2023-01-12 11:00:00	QQQ	ETF	276.62	278.22	275.62	278.06	3963313.0
2023-01-12 12:00:00	QQQ	ETF	278.06	279.55	277.68	279.18	4293802.0
2023-01-12 13:00:00	QQQ	ETF	279.185	279.99	277.14	279.87	5148196.0
2023-01-12 14:00:00	QQQ	ETF	279.88	280.1	278.69	279.16	3723525.0
2023-01-12 15:00:00	QQQ	ETF	279.17	279.21	277.9	279.03	6404101.0
2023-01-12 16:00:00	QQQ	ETF	279.03	279.22	278.78	278.85	1142751.0
2023-01-12 17:00:00	QQQ	ETF	278.84	279.05	278.82	278.97	177287.0
2023-01-12 18:00:00	QQQ	ETF	278.86	278.91	278.66	278.89	102134.0
2023-01-12 19:00:00	QQQ	ETF	278.9	279.16	278.74	278.8	120851.0
2023-01-12 04:00:00	IWM	ETF	182.78	183.02	182.77	182.9	11877.0
2023-01-12 05:00:00	IWM	ETF	182.85	182.88	182.64	182.88	4392.0
2023-01-12 06:00:00	IWM	ETF	182.96	183.05	182.9	182.99	2707.0
2023-01-12 07:00:00	IWM	ETF	182.97	183.41	182.95	183.38	95880.0
2023-01-12 08:00:00	IWM	ETF	183.0	184.59	181.7	184.44	1188077.0
2023-01-12 09:00:00	IWM	ETF	184.41	184.59	181.92	182.37	3108856.0
2023-01-12 10:00:00	IWM	ETF	182.35	184.39	182.34	183.5721	3222159.0
2023-01-12 11:00:00	IWM	ETF	183.61	184.65	183.07	184.45	1507900.0
2023-01-12 12:00:00	IWM	ETF	184.47	185.35	184.39	185.18	1306251.0
2023-01-12 13:00:00	IWM	ETF	185.171	185.85	184.3	185.54	1834634.0
2023-01-12 14:00:00	IWM	ETF	185.56	185.81	185.19	185.55	1332132.0
2023-01-12 15:00:00	IWM	ETF	185.56	185.95	185.11	185.84	2909694.0
2023-01-12 16:00:00	IWM	ETF	185.83	185.97	185.75	185.81	1494971.0
2023-01-12 17:00:00	IWM	ETF	185.81	185.98	185.7201	185.85	338662.0
2023-01-12 18:00:00	IWM	ETF	185.75	185.98	185.71	185.98	35983.0
2023-01-12 19:00:00	IWM	ETF	185.98	186.1	185.86	185.89	36416.0
2023-01-12 04:00:00	DIA	ETF	339.66	339.98	339.66	339.87	2000.0
2023-01-12 06:00:00	DIA	ETF	339.99	339.99	339.99	339.99	100.0

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

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