PREVIEW / etf_1hour / 2022-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-14.parquet
  size:    469 KB
  rows:    17,137

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-14 04:00:00	SPY	ETF	379.29	379.6	377.04	377.11	55024.0
2022-06-14 05:00:00	SPY	ETF	377.26	377.55	376.64	376.97	42255.0
2022-06-14 06:00:00	SPY	ETF	376.65	377.3	375.61	376.82	121798.0
2022-06-14 07:00:00	SPY	ETF	376.77	376.9	375.4	375.49	417633.0
2022-06-14 08:00:00	SPY	ETF	376.8674	380.3	375.4201	377.05	1021132.0
2022-06-14 09:00:00	SPY	ETF	377.02	378.0899	374.5	377.42	9083618.0
2022-06-14 10:00:00	SPY	ETF	377.44	377.94	373.1	375.16	11000341.0
2022-06-14 11:00:00	SPY	ETF	375.17	375.96	373.14	374.9599	8555600.0
2022-06-14 12:00:00	SPY	ETF	374.95	375.0	372.6	374.0	6758103.0
2022-06-14 13:00:00	SPY	ETF	374.0	376.45	372.68	373.17	8234134.0
2022-06-14 14:00:00	SPY	ETF	373.18	374.43	372.01	372.18	7123368.0
2022-06-14 15:00:00	SPY	ETF	372.19	375.04	370.59	373.82	19167083.0
2022-06-14 16:00:00	SPY	ETF	373.82	374.08	373.02	373.87	3388629.0
2022-06-14 17:00:00	SPY	ETF	373.85	374.0	373.66	373.9	148014.0
2022-06-14 18:00:00	SPY	ETF	373.9	375.07	373.9	374.51	161103.0
2022-06-14 19:00:00	SPY	ETF	374.44	376.0	374.01	375.66	78235.0
2022-06-14 04:00:00	QQQ	ETF	279.29	279.45	277.6	277.75	235552.0
2022-06-14 05:00:00	QQQ	ETF	277.75	278.18	277.41	277.74	84875.0
2022-06-14 06:00:00	QQQ	ETF	277.67	278.25	276.62	277.8	129743.0
2022-06-14 07:00:00	QQQ	ETF	277.79	277.86	276.3	276.43	461984.0
2022-06-14 08:00:00	QQQ	ETF	277.85	280.25	275.616	277.77	1537064.0
2022-06-14 09:00:00	QQQ	ETF	277.77	278.6799	274.76	277.49	7272646.0
2022-06-14 10:00:00	QQQ	ETF	277.48	278.22	274.18	275.98	8686707.0
2022-06-14 11:00:00	QQQ	ETF	276.0	277.15	274.5502	276.84	5923820.0
2022-06-14 12:00:00	QQQ	ETF	276.86	276.9	275.07	276.28	5036045.0
2022-06-14 13:00:00	QQQ	ETF	276.29	278.66	275.36	275.63	6074219.0
2022-06-14 14:00:00	QQQ	ETF	275.63	276.61	274.89	274.93	4377583.0
2022-06-14 15:00:00	QQQ	ETF	274.93	277.22	273.3375	276.11	9465162.0
2022-06-14 16:00:00	QQQ	ETF	276.09	276.37	275.52	276.3	1360697.0
2022-06-14 17:00:00	QQQ	ETF	276.1	276.39	275.91	276.28	327603.0
2022-06-14 18:00:00	QQQ	ETF	276.28	277.25	276.28	276.75	152867.0
2022-06-14 19:00:00	QQQ	ETF	276.7996	278.42	276.35	278.01	174479.0
2022-06-14 04:00:00	IWM	ETF	172.03	172.03	170.79	170.83	72421.0
2022-06-14 05:00:00	IWM	ETF	170.89	170.99	170.6	170.7	17785.0
2022-06-14 06:00:00	IWM	ETF	170.67	170.84	170.07	170.63	22962.0
2022-06-14 07:00:00	IWM	ETF	170.62	170.69	169.89	169.9	74952.0
2022-06-14 08:00:00	IWM	ETF	170.64	172.55	169.91	170.57	142466.0
2022-06-14 09:00:00	IWM	ETF	170.53	171.21	169.18	170.79	2933374.0
2022-06-14 10:00:00	IWM	ETF	170.78	171.24	168.87	169.81	2847730.0
2022-06-14 11:00:00	IWM	ETF	169.81	170.4	168.72	170.15	2382805.0
2022-06-14 12:00:00	IWM	ETF	170.15	170.15	168.79	169.41	2350458.0
2022-06-14 13:00:00	IWM	ETF	169.42	170.45	168.37	168.785	2240397.0
2022-06-14 14:00:00	IWM	ETF	168.8	169.62	168.44	168.5	2609855.0
2022-06-14 15:00:00	IWM	ETF	168.49	170.02	167.74	169.52	4757757.0
2022-06-14 16:00:00	IWM	ETF	169.52	169.66	169.11	169.54	664187.0
2022-06-14 17:00:00	IWM	ETF	169.53	169.65	169.38	169.52	226051.0
2022-06-14 18:00:00	IWM	ETF	169.52	170.06	169.52	169.77	38405.0
2022-06-14 19:00:00	IWM	ETF	169.77	170.39	169.52	170.38	46175.0
2022-06-14 04:00:00	DIA	ETF	308.0	308.0	306.98	306.98	900.0
2022-06-14 05:00:00	DIA	ETF	306.9	306.97	306.69	306.97	4025.0

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

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