PREVIEW / etf_1hour / 2022-06-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-09.parquet
  size:    442 KB
  rows:    16,062

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-09 04:00:00	SPY	ETF	411.28	412.93	410.8	412.91	21727.0
2022-06-09 05:00:00	SPY	ETF	412.85	412.98	412.38	412.38	34279.0
2022-06-09 06:00:00	SPY	ETF	412.59	413.93	412.29	413.51	182541.0
2022-06-09 07:00:00	SPY	ETF	413.46	414.2	411.98	412.35	330496.0
2022-06-09 08:00:00	SPY	ETF	413.4099	414.1301	409.54	409.97	903186.0
2022-06-09 09:00:00	SPY	ETF	409.89	411.69	408.42	411.65	6448008.0
2022-06-09 10:00:00	SPY	ETF	411.65	411.74	408.63	409.36	6780469.0
2022-06-09 11:00:00	SPY	ETF	409.35	410.35	408.11	409.43	5766410.0
2022-06-09 12:00:00	SPY	ETF	409.44	410.53	408.3	410.34	4806302.0
2022-06-09 13:00:00	SPY	ETF	410.34	410.95	408.28	409.43	5009629.0
2022-06-09 14:00:00	SPY	ETF	409.43	409.44	406.59	406.62	6842128.0
2022-06-09 15:00:00	SPY	ETF	406.61	406.7	401.45	401.47	22850080.0
2022-06-09 16:00:00	SPY	ETF	401.48	402.33	401.43	402.29	4992927.0
2022-06-09 17:00:00	SPY	ETF	402.19	402.61	402.0	402.47	166938.0
2022-06-09 18:00:00	SPY	ETF	402.47	402.5	401.69	401.87	94578.0
2022-06-09 19:00:00	SPY	ETF	401.9	402.39	401.28	402.1	70729.0
2022-06-09 04:00:00	QQQ	ETF	307.5	309.16	307.07	309.13	94035.0
2022-06-09 05:00:00	QQQ	ETF	309.12	309.3	308.64	308.78	62857.0
2022-06-09 06:00:00	QQQ	ETF	308.83	310.33	308.55	309.54	78212.0
2022-06-09 07:00:00	QQQ	ETF	309.47	310.11	308.14	308.35	348833.0
2022-06-09 08:00:00	QQQ	ETF	309.21	310.0	305.81	306.2104	988931.0
2022-06-09 09:00:00	QQQ	ETF	306.21	308.62	305.01	308.245	6705698.0
2022-06-09 10:00:00	QQQ	ETF	308.25	309.05	306.2	306.86	5657225.0
2022-06-09 11:00:00	QQQ	ETF	306.86	307.615	305.66	306.61	3859420.0
2022-06-09 12:00:00	QQQ	ETF	306.62	307.2	305.5	306.94	2500371.0
2022-06-09 13:00:00	QQQ	ETF	307.0	307.471	304.9001	305.8901	2931846.0
2022-06-09 14:00:00	QQQ	ETF	305.91	305.91	303.36	303.39	3832555.0
2022-06-09 15:00:00	QQQ	ETF	303.38	303.44	299.23	299.25	11009664.0
2022-06-09 16:00:00	QQQ	ETF	299.26	300.05	298.93	299.91	2348685.0
2022-06-09 17:00:00	QQQ	ETF	299.93	299.99	299.66	299.88	82836.0
2022-06-09 18:00:00	QQQ	ETF	299.92	300.11	299.4	299.52	136651.0
2022-06-09 19:00:00	QQQ	ETF	299.5104	299.94	299.42	299.72	159985.0
2022-06-09 04:00:00	IWM	ETF	187.6	188.45	187.4	188.45	19760.0
2022-06-09 05:00:00	IWM	ETF	188.34	188.4	188.09	188.14	18213.0
2022-06-09 06:00:00	IWM	ETF	188.19	188.77	188.19	188.66	9065.0
2022-06-09 07:00:00	IWM	ETF	188.59	189.08	188.01	188.15	45237.0
2022-06-09 08:00:00	IWM	ETF	188.75	188.75	186.76	186.89	94793.0
2022-06-09 09:00:00	IWM	ETF	186.88	187.0	184.89	186.04	2291547.0
2022-06-09 10:00:00	IWM	ETF	186.06	187.07	185.44	186.08	2118397.0
2022-06-09 11:00:00	IWM	ETF	186.07	186.44	185.35	186.1	1430974.0
2022-06-09 12:00:00	IWM	ETF	186.1	186.62	185.38	186.54	866470.0
2022-06-09 13:00:00	IWM	ETF	186.55	186.76	185.43	185.99	971475.0
2022-06-09 14:00:00	IWM	ETF	185.98	186.01	185.08	185.105	1500038.0
2022-06-09 15:00:00	IWM	ETF	185.09	185.12	183.53	183.5893	4699141.0
2022-06-09 16:00:00	IWM	ETF	183.59	184.02	183.42	184.0	2592829.0
2022-06-09 17:00:00	IWM	ETF	183.83	183.95	183.83	183.86	7596.0
2022-06-09 18:00:00	IWM	ETF	183.97	183.99	183.71	183.77	6716.0
2022-06-09 19:00:00	IWM	ETF	183.87	184.03	183.85	183.89	9085.0
2022-06-09 04:00:00	DIA	ETF	330.54	330.54	330.54	330.54	1354.0
2022-06-09 05:00:00	DIA	ETF	330.45	330.45	330.45	330.45	1000.0

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

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