PREVIEW / etf_1hour / 2022-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-15.parquet
  size:    463 KB
  rows:    16,988

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-06-15 04:00:00	SPY	ETF	375.74	377.13	375.57	376.19	63261.0
2022-06-15 05:00:00	SPY	ETF	376.01	376.25	375.2	376.0	32741.0
2022-06-15 06:00:00	SPY	ETF	375.81	375.9	374.96	375.32	50305.0
2022-06-15 07:00:00	SPY	ETF	375.55	377.5	374.83	377.37	522708.0
2022-06-15 08:00:00	SPY	ETF	375.1901	377.95	373.78	377.5	722954.0
2022-06-15 09:00:00	SPY	ETF	377.6	379.13	376.7	378.6	7018619.0
2022-06-15 10:00:00	SPY	ETF	378.61	379.5	376.4	377.2299	8931772.0
2022-06-15 11:00:00	SPY	ETF	377.25	377.5099	376.05	377.405	5416996.0
2022-06-15 12:00:00	SPY	ETF	377.42	378.31	376.0	376.15	5202521.0
2022-06-15 13:00:00	SPY	ETF	376.15	378.68	376.08	378.138	5731245.0
2022-06-15 14:00:00	SPY	ETF	378.14	382.64	372.12	378.13	29465665.0
2022-06-15 15:00:00	SPY	ETF	378.18	383.9	377.85	379.13	26821443.0
2022-06-15 16:00:00	SPY	ETF	379.13	379.48	378.25	379.03	5810839.0
2022-06-15 17:00:00	SPY	ETF	379.21	379.74	379.03	379.7	234473.0
2022-06-15 18:00:00	SPY	ETF	379.7	380.99	379.65	380.75	230509.0
2022-06-15 19:00:00	SPY	ETF	380.82	381.71	380.38	381.71	159009.0
2022-06-15 04:00:00	QQQ	ETF	277.87	278.68	277.56	277.96	69607.0
2022-06-15 05:00:00	QQQ	ETF	277.7	278.1	277.28	277.87	57552.0
2022-06-15 06:00:00	QQQ	ETF	277.91	277.97	277.35	277.56	62543.0
2022-06-15 07:00:00	QQQ	ETF	277.77	279.32	277.29	279.21	331398.0
2022-06-15 08:00:00	QQQ	ETF	277.5	280.12	276.116	279.62	1079027.0
2022-06-15 09:00:00	QQQ	ETF	279.62	280.91	278.76	280.06	5914430.0
2022-06-15 10:00:00	QQQ	ETF	280.04	281.53	278.85	279.64	5062472.0
2022-06-15 11:00:00	QQQ	ETF	279.65	280.6	279.25	280.54	3445534.0
2022-06-15 12:00:00	QQQ	ETF	280.54	281.47	279.42	279.54	2829089.0
2022-06-15 13:00:00	QQQ	ETF	279.55	281.9	279.47	281.49	3716099.0
2022-06-15 14:00:00	QQQ	ETF	281.49	285.85	276.61	281.93	23943261.0
2022-06-15 15:00:00	QQQ	ETF	281.95	286.83	281.58	282.875	17462224.0
2022-06-15 16:00:00	QQQ	ETF	282.87	283.06	281.95	282.72	2789613.0
2022-06-15 17:00:00	QQQ	ETF	282.72	283.74	282.69	283.66	484642.0
2022-06-15 18:00:00	QQQ	ETF	283.61	284.73	283.33	284.4	267975.0
2022-06-15 19:00:00	QQQ	ETF	284.35	285.21	283.98	285.16	240151.0
2022-06-15 04:00:00	IWM	ETF	170.59	171.29	170.51	170.68	25026.0
2022-06-15 05:00:00	IWM	ETF	170.49	170.76	170.2	170.57	15559.0
2022-06-15 06:00:00	IWM	ETF	170.55	170.56	170.16	170.29	10586.0
2022-06-15 07:00:00	IWM	ETF	170.26	171.3	170.15	171.3	37461.0
2022-06-15 08:00:00	IWM	ETF	170.6399	171.4	169.98	171.29	268445.0
2022-06-15 09:00:00	IWM	ETF	171.38	172.19	170.71	171.85	2854712.0
2022-06-15 10:00:00	IWM	ETF	171.85	172.47	171.15	171.6	1623145.0
2022-06-15 11:00:00	IWM	ETF	171.6	172.15	171.0	172.04	1398321.0
2022-06-15 12:00:00	IWM	ETF	172.02	172.34	170.9	170.96	1060259.0
2022-06-15 13:00:00	IWM	ETF	170.97	172.19	170.86	172.054	1567309.0
2022-06-15 14:00:00	IWM	ETF	172.05	173.94	168.66	171.45	7800602.0
2022-06-15 15:00:00	IWM	ETF	171.46	174.06	171.21	171.84	5246316.0
2022-06-15 16:00:00	IWM	ETF	171.86	172.05	171.58	171.86	785616.0
2022-06-15 17:00:00	IWM	ETF	171.97	172.5	171.87	172.41	17230.0
2022-06-15 18:00:00	IWM	ETF	172.32	173.0	172.2	172.76	112519.0
2022-06-15 19:00:00	IWM	ETF	172.82	173.34	172.6	173.34	33413.0
2022-06-15 04:00:00	DIA	ETF	305.68	306.46	305.68	306.39	3100.0
2022-06-15 05:00:00	DIA	ETF	305.28	305.28	305.24	305.24	500.0

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

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