PREVIEW / etf_1hour / 2022-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-29.parquet
  size:    456 KB
  rows:    16,516

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-29 04:00:00	SPY	ETF	397.75	398.0	396.58	396.83	54037.0
2022-11-29 05:00:00	SPY	ETF	396.88	397.53	396.77	397.02	30239.0
2022-11-29 06:00:00	SPY	ETF	397.07	397.48	396.67	397.48	54084.0
2022-11-29 07:00:00	SPY	ETF	397.46	397.5	396.76	397.38	201747.0
2022-11-29 08:00:00	SPY	ETF	397.36	398.14	395.79	396.36	428488.0
2022-11-29 09:00:00	SPY	ETF	396.3	396.6399	395.24	395.68	4394611.0
2022-11-29 10:00:00	SPY	ETF	395.71	397.3	395.39	396.33	6876841.0
2022-11-29 11:00:00	SPY	ETF	396.34	396.5189	393.3	394.6407	8070772.0
2022-11-29 12:00:00	SPY	ETF	394.65	395.257	394.085	394.957	3914497.0
2022-11-29 13:00:00	SPY	ETF	394.94	395.09	393.93	395.015	3418348.0
2022-11-29 14:00:00	SPY	ETF	395.02	396.09	394.191	394.74	5145117.0
2022-11-29 15:00:00	SPY	ETF	394.73	395.53	394.475	395.25	7314072.0
2022-11-29 16:00:00	SPY	ETF	395.25	395.45	394.95	395.43	2006669.0
2022-11-29 17:00:00	SPY	ETF	395.43	395.45	395.23	395.3	46051.0
2022-11-29 18:00:00	SPY	ETF	395.35	395.36	394.86	394.96	85788.0
2022-11-29 19:00:00	SPY	ETF	394.98	395.6	394.94	395.52	65274.0
2022-11-29 04:00:00	QQQ	ETF	284.12	284.8	283.67	283.83	88236.0
2022-11-29 05:00:00	QQQ	ETF	283.86	284.37	283.69	284.09	51941.0
2022-11-29 06:00:00	QQQ	ETF	284.08	284.25	283.79	284.19	89922.0
2022-11-29 07:00:00	QQQ	ETF	284.3	284.32	283.7	284.24	261690.0
2022-11-29 08:00:00	QQQ	ETF	284.17	284.7204	282.88	283.3	665071.0
2022-11-29 09:00:00	QQQ	ETF	283.27	283.61	281.58	281.89	3781023.0
2022-11-29 10:00:00	QQQ	ETF	281.91	283.35	281.49	282.2907	4628031.0
2022-11-29 11:00:00	QQQ	ETF	282.32	282.42	279.17	280.57	6501264.0
2022-11-29 12:00:00	QQQ	ETF	280.585	281.2899	280.19	280.89	2634436.0
2022-11-29 13:00:00	QQQ	ETF	280.9	280.94	279.45	280.47	2948653.0
2022-11-29 14:00:00	QQQ	ETF	280.465	281.31	279.76	280.25	3203594.0
2022-11-29 15:00:00	QQQ	ETF	280.25	280.73	279.98	280.54	4173052.0
2022-11-29 16:00:00	QQQ	ETF	280.55	280.68	280.16	280.47	805090.0
2022-11-29 17:00:00	QQQ	ETF	280.6	280.6	280.4	280.45	37747.0
2022-11-29 18:00:00	QQQ	ETF	280.43	280.48	280.0	280.04	87666.0
2022-11-29 19:00:00	QQQ	ETF	280.1	280.65	280.05	280.59	69942.0
2022-11-29 04:00:00	IWM	ETF	182.88	183.05	182.2	182.4	52647.0
2022-11-29 05:00:00	IWM	ETF	182.39	182.75	182.39	182.47	20090.0
2022-11-29 06:00:00	IWM	ETF	182.49	182.69	182.39	182.68	10438.0
2022-11-29 07:00:00	IWM	ETF	182.69	182.72	182.31	182.65	30065.0
2022-11-29 08:00:00	IWM	ETF	182.7	183.0	181.86	182.18	90534.0
2022-11-29 09:00:00	IWM	ETF	182.15	182.94	181.8796	182.75	1658339.0
2022-11-29 10:00:00	IWM	ETF	182.77	183.61	182.75	183.17	1942846.0
2022-11-29 11:00:00	IWM	ETF	183.18	183.33	182.1101	182.83	1335685.0
2022-11-29 12:00:00	IWM	ETF	182.83	183.12	182.515	182.7801	624866.0
2022-11-29 13:00:00	IWM	ETF	182.79	182.88	182.17	182.7199	686856.0
2022-11-29 14:00:00	IWM	ETF	182.71	183.06	182.17	182.35	1190835.0
2022-11-29 15:00:00	IWM	ETF	182.35	182.75	182.27	182.38	2094881.0
2022-11-29 16:00:00	IWM	ETF	182.38	182.5138	182.19	182.35	626015.0
2022-11-29 17:00:00	IWM	ETF	182.26	182.47	182.26	182.32	15509.0
2022-11-29 18:00:00	IWM	ETF	182.4	182.4	182.21	182.21	9368.0
2022-11-29 19:00:00	IWM	ETF	182.27	182.6	182.25	182.54	34787.0
2022-11-29 04:00:00	DIA	ETF	339.01	339.4	339.01	339.03	400.0
2022-11-29 05:00:00	DIA	ETF	338.69	339.09	338.69	338.79	3408.0

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

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