PREVIEW / etf_1hour / 2022-11-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-30.parquet
  size:    471 KB
  rows:    17,462

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-30 04:00:00	SPY	ETF	395.65	396.94	395.65	396.17	36437.0
2022-11-30 05:00:00	SPY	ETF	396.21	396.43	395.96	395.98	10218.0
2022-11-30 06:00:00	SPY	ETF	396.14	396.4	395.79	396.4	14363.0
2022-11-30 07:00:00	SPY	ETF	396.28	396.36	395.95	396.01	136790.0
2022-11-30 08:00:00	SPY	ETF	396.01	397.27	395.02	395.07	507822.0
2022-11-30 09:00:00	SPY	ETF	395.05	396.2094	394.865	395.21	5091496.0
2022-11-30 10:00:00	SPY	ETF	395.2	395.42	393.8501	394.2	5900766.0
2022-11-30 11:00:00	SPY	ETF	394.21	395.56	393.76	395.1536	4490724.0
2022-11-30 12:00:00	SPY	ETF	395.1533	395.3683	393.48	394.2218	4365967.0
2022-11-30 13:00:00	SPY	ETF	394.22	400.0	394.06	399.72	12700252.0
2022-11-30 14:00:00	SPY	ETF	399.72	403.49	399.68	403.26	17759547.0
2022-11-30 15:00:00	SPY	ETF	403.26	407.55	403.06	407.47	36760464.0
2022-11-30 16:00:00	SPY	ETF	407.46	408.45	405.66	408.41	9279741.0
2022-11-30 17:00:00	SPY	ETF	408.35	408.51	408.13	408.35	244205.0
2022-11-30 18:00:00	SPY	ETF	408.39	408.7	407.81	408.27	186010.0
2022-11-30 19:00:00	SPY	ETF	408.27	408.45	407.9	408.0	192658.0
2022-11-30 04:00:00	QQQ	ETF	281.59	282.1	281.25	281.54	58925.0
2022-11-30 05:00:00	QQQ	ETF	281.53	281.85	281.38	281.57	16523.0
2022-11-30 06:00:00	QQQ	ETF	281.58	281.86	281.3	281.86	18009.0
2022-11-30 07:00:00	QQQ	ETF	281.78	281.84	281.43	281.46	119412.0
2022-11-30 08:00:00	QQQ	ETF	281.7613	282.35	280.47	280.51	601293.0
2022-11-30 09:00:00	QQQ	ETF	280.52	281.97	280.47	281.5899	3876192.0
2022-11-30 10:00:00	QQQ	ETF	281.59	281.905	280.47	280.7	4305771.0
2022-11-30 11:00:00	QQQ	ETF	280.72	281.83	280.22	281.445	3097766.0
2022-11-30 12:00:00	QQQ	ETF	281.445	281.62	279.97	280.77	2958889.0
2022-11-30 13:00:00	QQQ	ETF	280.76	286.475	280.71	286.16	12527856.0
2022-11-30 14:00:00	QQQ	ETF	286.15	290.48	286.12	289.67	14352407.0
2022-11-30 15:00:00	QQQ	ETF	289.68	293.45	289.39	293.42	14931165.0
2022-11-30 16:00:00	QQQ	ETF	293.44	294.02	292.87	294.01	3795807.0
2022-11-30 17:00:00	QQQ	ETF	293.93	294.0914	293.36	293.84	175018.0
2022-11-30 18:00:00	QQQ	ETF	293.9	294.21	293.36	293.98	195578.0
2022-11-30 19:00:00	QQQ	ETF	293.95	294.14	293.63	293.78	209923.0
2022-11-30 04:00:00	IWM	ETF	182.75	183.2	182.63	182.8	22965.0
2022-11-30 05:00:00	IWM	ETF	182.66	182.87	182.61	182.64	6338.0
2022-11-30 06:00:00	IWM	ETF	182.61	182.79	182.54	182.76	4842.0
2022-11-30 07:00:00	IWM	ETF	182.74	182.9	182.7	182.76	12416.0
2022-11-30 08:00:00	IWM	ETF	182.78	183.18	182.37	182.39	57447.0
2022-11-30 09:00:00	IWM	ETF	182.35	183.18	181.215	181.62	1702089.0
2022-11-30 10:00:00	IWM	ETF	181.66	182.03	181.28	181.6115	1677037.0
2022-11-30 11:00:00	IWM	ETF	181.62	182.24	181.37	181.8	1260763.0
2022-11-30 12:00:00	IWM	ETF	181.815	181.85	180.795	181.38	1213730.0
2022-11-30 13:00:00	IWM	ETF	181.37	184.3	181.22	184.1906	3570785.0
2022-11-30 14:00:00	IWM	ETF	184.19	186.38	184.15	185.48	4765991.0
2022-11-30 15:00:00	IWM	ETF	185.48	187.43	185.36	187.37	4892803.0
2022-11-30 16:00:00	IWM	ETF	187.37	188.22	187.22	188.22	2284369.0
2022-11-30 17:00:00	IWM	ETF	188.31	188.31	187.91	188.0	21825.0
2022-11-30 18:00:00	IWM	ETF	188.08	188.34	187.37	188.19	86655.0
2022-11-30 19:00:00	IWM	ETF	188.19	188.3	187.89	187.92	27512.0
2022-11-30 04:00:00	DIA	ETF	339.16	339.46	339.16	339.46	378.0
2022-11-30 05:00:00	DIA	ETF	338.75	338.75	338.75	338.75	300.0

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

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