PREVIEW / etf_1hour / 2022-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-06.parquet
  size:    470 KB
  rows:    16,957

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-12-06 04:00:00	SPY	ETF	400.65	400.72	399.89	399.89	31806.0
2022-12-06 05:00:00	SPY	ETF	399.93	400.1	399.09	399.93	50606.0
2022-12-06 06:00:00	SPY	ETF	399.79	400.02	399.43	400.01	29660.0
2022-12-06 07:00:00	SPY	ETF	400.01	400.54	399.89	399.89	246098.0
2022-12-06 08:00:00	SPY	ETF	400.3301	400.5	398.95	399.7	650849.0
2022-12-06 09:00:00	SPY	ETF	399.69	400.02	397.157	397.19	5887256.0
2022-12-06 10:00:00	SPY	ETF	397.18	397.49	394.81	395.44	10606114.0
2022-12-06 11:00:00	SPY	ETF	395.445	395.885	394.6	395.07	6371608.0
2022-12-06 12:00:00	SPY	ETF	395.08	395.64	393.84	394.0617	4762695.0
2022-12-06 13:00:00	SPY	ETF	394.08	394.34	392.6221	393.3	6725576.0
2022-12-06 14:00:00	SPY	ETF	393.3	393.43	391.64	392.49	6986767.0
2022-12-06 15:00:00	SPY	ETF	392.51	394.24	391.98	393.86	15137599.0
2022-12-06 16:00:00	SPY	ETF	393.86	394.23	393.62	393.98	3880997.0
2022-12-06 17:00:00	SPY	ETF	393.99	394.01	393.8	393.86	1000443.0
2022-12-06 18:00:00	SPY	ETF	393.89	394.4	393.89	394.25	121301.0
2022-12-06 19:00:00	SPY	ETF	394.25	394.52	394.06	394.08	63407.0
2022-12-06 04:00:00	QQQ	ETF	288.31	288.4	287.82	287.86	31179.0
2022-12-06 05:00:00	QQQ	ETF	287.9	288.03	287.26	287.92	41346.0
2022-12-06 06:00:00	QQQ	ETF	287.97	288.25	287.65	288.17	13881.0
2022-12-06 07:00:00	QQQ	ETF	288.21	288.58	288.0	288.0	166970.0
2022-12-06 08:00:00	QQQ	ETF	288.23	288.58	287.22	288.01	308485.0
2022-12-06 09:00:00	QQQ	ETF	288.02	288.21	284.19	284.21	5279766.0
2022-12-06 10:00:00	QQQ	ETF	284.19	284.44	282.4	282.93	7432914.0
2022-12-06 11:00:00	QQQ	ETF	282.92	283.74	282.455	283.06	4835754.0
2022-12-06 12:00:00	QQQ	ETF	283.08	283.48	282.055	282.3201	4102974.0
2022-12-06 13:00:00	QQQ	ETF	282.34	282.68	281.26	281.95	4943040.0
2022-12-06 14:00:00	QQQ	ETF	281.95	282.01	280.255	281.01	5641062.0
2022-12-06 15:00:00	QQQ	ETF	281.02	282.13	280.32	281.715	8761145.0
2022-12-06 16:00:00	QQQ	ETF	281.715	281.95	281.55	281.88	2027245.0
2022-12-06 17:00:00	QQQ	ETF	281.85	281.85	281.68	281.83	317231.0
2022-12-06 18:00:00	QQQ	ETF	281.84	282.19	281.84	282.12	115216.0
2022-12-06 19:00:00	QQQ	ETF	282.13	282.34	281.95	281.95	103399.0
2022-12-06 04:00:00	IWM	ETF	183.38	183.38	182.94	182.94	18819.0
2022-12-06 05:00:00	IWM	ETF	182.92	182.98	182.44	182.74	17018.0
2022-12-06 06:00:00	IWM	ETF	182.81	182.95	182.62	182.95	6969.0
2022-12-06 07:00:00	IWM	ETF	183.0	183.29	182.92	182.95	26412.0
2022-12-06 08:00:00	IWM	ETF	182.99	183.48	182.52	182.82	223386.0
2022-12-06 09:00:00	IWM	ETF	182.85	183.05	181.71	181.92	1611249.0
2022-12-06 10:00:00	IWM	ETF	181.92	182.05	180.63	181.15	2563913.0
2022-12-06 11:00:00	IWM	ETF	181.17	181.495	180.63	180.75	1665614.0
2022-12-06 12:00:00	IWM	ETF	180.74	180.99	180.135	180.24	1332350.0
2022-12-06 13:00:00	IWM	ETF	180.24	180.41	179.49	179.825	1485467.0
2022-12-06 14:00:00	IWM	ETF	179.82	179.88	179.08	179.57	1130967.0
2022-12-06 15:00:00	IWM	ETF	179.58	180.24	179.14	180.08	2836984.0
2022-12-06 16:00:00	IWM	ETF	180.07	180.31	179.96	180.07	855908.0
2022-12-06 17:00:00	IWM	ETF	180.19	180.21	180.0	180.05	3514.0
2022-12-06 18:00:00	IWM	ETF	180.07	180.35	180.07	180.29	34274.0
2022-12-06 19:00:00	IWM	ETF	180.3	180.36	180.1	180.17	28142.0
2022-12-06 04:00:00	DIA	ETF	340.59	340.64	340.52	340.52	588.0
2022-12-06 05:00:00	DIA	ETF	339.54	340.07	339.54	340.07	692.0

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

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