PREVIEW / etf_1hour / 2023-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-01-25.parquet
  size:    470 KB
  rows:    17,091

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-25 04:00:00	SPY	ETF	398.8	398.8	397.56	397.56	55355.0
2023-01-25 05:00:00	SPY	ETF	397.6	397.77	396.85	397.5	186653.0
2023-01-25 06:00:00	SPY	ETF	397.4	397.84	396.95	397.17	39241.0
2023-01-25 07:00:00	SPY	ETF	397.27	397.6	397.03	397.36	237708.0
2023-01-25 08:00:00	SPY	ETF	397.32	400.2	395.95	396.1	742959.0
2023-01-25 09:00:00	SPY	ETF	396.1	396.65	394.32	394.41	7815646.0
2023-01-25 10:00:00	SPY	ETF	394.41	395.86	393.56	394.92	12586714.0
2023-01-25 11:00:00	SPY	ETF	394.9301	397.725	394.69	397.185	8759324.0
2023-01-25 12:00:00	SPY	ETF	397.195	397.48	396.51	397.22	4548814.0
2023-01-25 13:00:00	SPY	ETF	397.23	399.36	397.1	398.99	6790983.0
2023-01-25 14:00:00	SPY	ETF	399.0	400.21	398.69	399.77	7667536.0
2023-01-25 15:00:00	SPY	ETF	399.77	400.7	399.22	400.36	11960459.0
2023-01-25 16:00:00	SPY	ETF	400.36	401.02	399.73	400.08	5667100.0
2023-01-25 17:00:00	SPY	ETF	400.12	400.2	399.89	400.1	99003.0
2023-01-25 18:00:00	SPY	ETF	400.14	401.03	399.99	400.84	220645.0
2023-01-25 19:00:00	SPY	ETF	400.98	401.08	400.64	400.7	117976.0
2023-01-25 04:00:00	QQQ	ETF	286.6	286.7	285.44	285.44	130358.0
2023-01-25 05:00:00	QQQ	ETF	285.51	285.58	284.76	285.07	118863.0
2023-01-25 06:00:00	QQQ	ETF	285.17	285.35	284.3	284.56	138775.0
2023-01-25 07:00:00	QQQ	ETF	284.59	285.12	284.5	284.97	279551.0
2023-01-25 08:00:00	QQQ	ETF	284.61	288.586	283.59	283.73	785199.0
2023-01-25 09:00:00	QQQ	ETF	283.73	284.08	281.62	281.655	7707882.0
2023-01-25 10:00:00	QQQ	ETF	281.65	282.8	281.18	282.682	6777956.0
2023-01-25 11:00:00	QQQ	ETF	282.67	285.6	282.48	285.04	5951849.0
2023-01-25 12:00:00	QQQ	ETF	285.08	285.235	284.2501	284.775	2814997.0
2023-01-25 13:00:00	QQQ	ETF	284.83	286.74	284.735	286.3	3526623.0
2023-01-25 14:00:00	QQQ	ETF	286.31	287.68	286.06	287.318	4211022.0
2023-01-25 15:00:00	QQQ	ETF	287.32	288.36	286.75	287.7	5163233.0
2023-01-25 16:00:00	QQQ	ETF	287.71	288.67	287.0	287.73	2291097.0
2023-01-25 17:00:00	QQQ	ETF	287.72	287.8	287.25	287.4	314641.0
2023-01-25 18:00:00	QQQ	ETF	287.59	288.69	287.48	288.47	222333.0
2023-01-25 19:00:00	QQQ	ETF	288.52	288.84	288.27	288.29	161760.0
2023-01-25 04:00:00	IWM	ETF	186.55	186.56	185.98	185.98	10208.0
2023-01-25 05:00:00	IWM	ETF	185.97	186.13	185.71	186.05	20009.0
2023-01-25 06:00:00	IWM	ETF	186.1	186.42	185.98	186.13	25786.0
2023-01-25 07:00:00	IWM	ETF	186.12	186.21	185.73	185.96	27281.0
2023-01-25 08:00:00	IWM	ETF	186.1	186.57	185.26	185.39	120147.0
2023-01-25 09:00:00	IWM	ETF	185.49	185.5	183.935	183.96	2743886.0
2023-01-25 10:00:00	IWM	ETF	183.96	185.01	183.87	184.91	2070342.0
2023-01-25 11:00:00	IWM	ETF	184.92	186.04	184.82	185.7093	1992932.0
2023-01-25 12:00:00	IWM	ETF	185.72	185.89	185.325	185.79	782192.0
2023-01-25 13:00:00	IWM	ETF	185.79	186.73	185.71	186.485	1379544.0
2023-01-25 14:00:00	IWM	ETF	186.485	187.11	186.35	186.89	1351392.0
2023-01-25 15:00:00	IWM	ETF	186.9	187.51	186.89	187.44	2304189.0
2023-01-25 16:00:00	IWM	ETF	187.45	187.7	187.2	187.24	456864.0
2023-01-25 17:00:00	IWM	ETF	187.43	187.44	187.15	187.43	11767.0
2023-01-25 18:00:00	IWM	ETF	187.43	187.7	187.3	187.65	39250.0
2023-01-25 19:00:00	IWM	ETF	187.7	187.72	187.54	187.57	32363.0
2023-01-25 04:00:00	DIA	ETF	336.12	336.12	335.49	335.49	4195.0
2023-01-25 05:00:00	DIA	ETF	335.3	335.53	334.9	335.53	3635.0

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

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