PREVIEW / etf_1hour / 2022-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-07-06.parquet
  size:    446 KB
  rows:    16,203

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-07-06 04:00:00	SPY	ETF	382.25	382.5	380.51	380.72	59331.0
2022-07-06 05:00:00	SPY	ETF	380.75	381.78	380.21	381.77	27696.0
2022-07-06 06:00:00	SPY	ETF	381.73	382.22	381.14	381.42	53782.0
2022-07-06 07:00:00	SPY	ETF	381.28	381.33	380.14	380.47	169213.0
2022-07-06 08:00:00	SPY	ETF	380.99	382.99	379.96	381.6	501993.0
2022-07-06 09:00:00	SPY	ETF	381.6	383.66	380.81	382.12	6221797.0
2022-07-06 10:00:00	SPY	ETF	382.13	383.48	380.62	381.59	7688467.0
2022-07-06 11:00:00	SPY	ETF	381.58	381.7	379.6	380.7064	5787290.0
2022-07-06 12:00:00	SPY	ETF	380.72	381.07	379.92	380.9526	3062027.0
2022-07-06 13:00:00	SPY	ETF	380.93	382.1	380.92	381.88	3522624.0
2022-07-06 14:00:00	SPY	ETF	381.88	385.08	380.69	384.55	11946786.0
2022-07-06 15:00:00	SPY	ETF	384.56	385.87	382.5	383.31	12937454.0
2022-07-06 16:00:00	SPY	ETF	383.31	383.77	383.19	383.71	2317887.0
2022-07-06 17:00:00	SPY	ETF	383.7	383.78	383.65	383.75	47425.0
2022-07-06 18:00:00	SPY	ETF	383.74	383.85	383.35	383.38	44898.0
2022-07-06 19:00:00	SPY	ETF	383.52	383.8	383.26	383.58	60329.0
2022-07-06 04:00:00	QQQ	ETF	287.55	287.63	285.8	286.08	118697.0
2022-07-06 05:00:00	QQQ	ETF	286.1	286.93	285.65	286.87	65448.0
2022-07-06 06:00:00	QQQ	ETF	286.91	287.2	286.22	286.37	48396.0
2022-07-06 07:00:00	QQQ	ETF	286.44	286.47	285.31	285.57	247687.0
2022-07-06 08:00:00	QQQ	ETF	286.38	288.38	285.02	286.94	806951.0
2022-07-06 09:00:00	QQQ	ETF	286.92	288.7355	285.63	288.02	8712623.0
2022-07-06 10:00:00	QQQ	ETF	287.95	288.57	285.9	287.84	8192675.0
2022-07-06 11:00:00	QQQ	ETF	287.78	288.1185	285.59	286.605	4178003.0
2022-07-06 12:00:00	QQQ	ETF	286.605	287.34	286.18	287.25	2728504.0
2022-07-06 13:00:00	QQQ	ETF	287.26	288.11	287.23	287.9	2420820.0
2022-07-06 14:00:00	QQQ	ETF	287.9121	290.23	286.53	290.07	8799302.0
2022-07-06 15:00:00	QQQ	ETF	290.085	290.95	287.88	288.75	7751313.0
2022-07-06 16:00:00	QQQ	ETF	288.78	289.28	288.2283	289.19	1969300.0
2022-07-06 17:00:00	QQQ	ETF	289.2	289.25	288.8	289.09	1181394.0
2022-07-06 18:00:00	QQQ	ETF	289.09	289.39	288.81	288.87	85340.0
2022-07-06 19:00:00	QQQ	ETF	288.95	289.27	288.75	289.12	55012.0
2022-07-06 04:00:00	IWM	ETF	172.86	172.98	172.06	172.06	12024.0
2022-07-06 05:00:00	IWM	ETF	172.05	172.66	171.96	172.66	12162.0
2022-07-06 06:00:00	IWM	ETF	172.64	172.9	172.47	172.47	3100.0
2022-07-06 07:00:00	IWM	ETF	172.43	172.43	171.74	171.93	18950.0
2022-07-06 08:00:00	IWM	ETF	171.95	172.67	171.46	172.37	157863.0
2022-07-06 09:00:00	IWM	ETF	172.39	173.71	171.57	172.14	2311758.0
2022-07-06 10:00:00	IWM	ETF	172.13	172.71	170.74	170.94	2351156.0
2022-07-06 11:00:00	IWM	ETF	170.91	171.01	169.75	170.72	2541649.0
2022-07-06 12:00:00	IWM	ETF	170.71	170.97	170.33	170.78	1358016.0
2022-07-06 13:00:00	IWM	ETF	170.78	171.34	170.77	171.18	762182.0
2022-07-06 14:00:00	IWM	ETF	171.2	172.64	170.46	172.12	2755714.0
2022-07-06 15:00:00	IWM	ETF	172.14	172.49	171.06	171.55	3247210.0
2022-07-06 16:00:00	IWM	ETF	171.55	171.83	171.42	171.72	752528.0
2022-07-06 17:00:00	IWM	ETF	171.8	171.8	171.55	171.63	1701305.0
2022-07-06 18:00:00	IWM	ETF	171.63	171.85	171.57	171.71	36870.0
2022-07-06 19:00:00	IWM	ETF	171.73	171.9	171.58	171.71	20482.0
2022-07-06 04:00:00	DIA	ETF	309.83	309.94	309.07	309.07	2459.0
2022-07-06 05:00:00	DIA	ETF	309.08	309.08	309.08	309.08	500.0

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

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