PREVIEW / etf_1hour / 2023-01-09

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-09.parquet
  size:    483 KB
  rows:    17,508

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-09 04:00:00	SPY	ETF	388.37	389.8	388.37	389.4	41944.0
2023-01-09 05:00:00	SPY	ETF	389.35	389.9	389.31	389.68	34288.0
2023-01-09 06:00:00	SPY	ETF	389.65	389.8	389.22	389.31	25526.0
2023-01-09 07:00:00	SPY	ETF	389.3	390.05	389.3	389.65	301766.0
2023-01-09 08:00:00	SPY	ETF	389.5	390.29	388.5	389.66	429940.0
2023-01-09 09:00:00	SPY	ETF	389.67	391.67	389.35	391.6	6458323.0
2023-01-09 10:00:00	SPY	ETF	391.62	393.25	391.21	392.6	8136541.0
2023-01-09 11:00:00	SPY	ETF	392.6	393.7	392.6	393.38	5786988.0
2023-01-09 12:00:00	SPY	ETF	393.38	393.38	391.86	392.32	4711960.0
2023-01-09 13:00:00	SPY	ETF	392.325	392.47	389.87	390.485	7515780.0
2023-01-09 14:00:00	SPY	ETF	390.49	391.12	388.76	388.95	7119827.0
2023-01-09 15:00:00	SPY	ETF	388.9495	389.22	387.67	387.8657	14210065.0
2023-01-09 16:00:00	SPY	ETF	387.87	387.95	387.51	387.79	3635278.0
2023-01-09 17:00:00	SPY	ETF	387.82	387.94	387.6	387.81	107712.0
2023-01-09 18:00:00	SPY	ETF	387.83	387.92	387.38	387.54	69475.0
2023-01-09 19:00:00	SPY	ETF	387.6	387.66	386.8	387.15	123244.0
2023-01-09 04:00:00	QQQ	ETF	268.83	270.5	268.83	270.02	93831.0
2023-01-09 05:00:00	QQQ	ETF	270.0	270.29	269.71	269.88	39514.0
2023-01-09 06:00:00	QQQ	ETF	269.82	270.05	269.46	269.64	44910.0
2023-01-09 07:00:00	QQQ	ETF	269.67	270.41	269.61	270.18	133220.0
2023-01-09 08:00:00	QQQ	ETF	269.88	270.73	269.14	270.26	446497.0
2023-01-09 09:00:00	QQQ	ETF	270.22	273.5401	270.17	273.52	7316322.0
2023-01-09 10:00:00	QQQ	ETF	273.53	274.79	272.76	274.0823	6495140.0
2023-01-09 11:00:00	QQQ	ETF	274.09	275.29	274.07	274.92	3844551.0
2023-01-09 12:00:00	QQQ	ETF	274.94	275.02	273.98	274.565	2840781.0
2023-01-09 13:00:00	QQQ	ETF	274.56	274.87	272.37	272.845	3574590.0
2023-01-09 14:00:00	QQQ	ETF	272.84	273.47	271.34	271.46	4254861.0
2023-01-09 15:00:00	QQQ	ETF	271.48	271.7799	269.92	270.54	7425736.0
2023-01-09 16:00:00	QQQ	ETF	270.57	270.62	270.15	270.42	1408141.0
2023-01-09 17:00:00	QQQ	ETF	270.41	270.46	270.31	270.4	53369.0
2023-01-09 18:00:00	QQQ	ETF	270.42	270.48	270.03	270.17	67965.0
2023-01-09 19:00:00	QQQ	ETF	270.2	270.2499	269.5	269.71	139564.0
2023-01-09 04:00:00	IWM	ETF	177.81	178.26	177.81	178.13	4499.0
2023-01-09 05:00:00	IWM	ETF	178.13	178.44	178.13	178.34	10475.0
2023-01-09 06:00:00	IWM	ETF	178.44	178.44	178.21	178.21	15971.0
2023-01-09 07:00:00	IWM	ETF	178.181	178.62	178.181	178.42	20819.0
2023-01-09 08:00:00	IWM	ETF	178.18	178.79	177.7	178.57	64663.0
2023-01-09 09:00:00	IWM	ETF	178.55	179.34	178.05	179.17	2105963.0
2023-01-09 10:00:00	IWM	ETF	179.18	179.71	178.94	179.38	1928278.0
2023-01-09 11:00:00	IWM	ETF	179.38	180.12	179.38	179.89	1707125.0
2023-01-09 12:00:00	IWM	ETF	179.91	179.98	179.41	179.55	968015.0
2023-01-09 13:00:00	IWM	ETF	179.55	179.62	178.49	178.83	1105035.0
2023-01-09 14:00:00	IWM	ETF	178.835	179.14	178.14	178.21	1375062.0
2023-01-09 15:00:00	IWM	ETF	178.21	178.39	177.65	177.9	2458987.0
2023-01-09 16:00:00	IWM	ETF	177.88	177.97	177.69	177.82	2250166.0
2023-01-09 17:00:00	IWM	ETF	177.96	177.96	177.72	177.77	29000.0
2023-01-09 18:00:00	IWM	ETF	177.81	177.84	177.59	177.61	23063.0
2023-01-09 19:00:00	IWM	ETF	177.63	177.73	177.2	177.4	41949.0
2023-01-09 04:00:00	DIA	ETF	336.54	336.93	336.54	336.93	452.0
2023-01-09 05:00:00	DIA	ETF	337.24	337.33	337.24	337.32	1518.0

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

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