PREVIEW / etf_1hour / 2022-05-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-12.parquet
  size:    476 KB
  rows:    17,439

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-05-12 04:00:00	SPY	ETF	392.49	392.49	389.35	390.05	112145.0
2022-05-12 05:00:00	SPY	ETF	390.1	390.47	388.81	389.8	99497.0
2022-05-12 06:00:00	SPY	ETF	389.73	391.19	389.53	390.93	89095.0
2022-05-12 07:00:00	SPY	ETF	390.91	392.09	388.14	388.57	705230.0
2022-05-12 08:00:00	SPY	ETF	388.47	392.85	388.03	389.56	815320.0
2022-05-12 09:00:00	SPY	ETF	389.68	391.28	386.92	388.6	12952488.0
2022-05-12 10:00:00	SPY	ETF	388.58	394.24	387.33	394.02	15011596.0
2022-05-12 11:00:00	SPY	ETF	394.03	395.8	388.66	388.697	11428676.0
2022-05-12 12:00:00	SPY	ETF	388.68	392.36	388.16	390.47	9339834.0
2022-05-12 13:00:00	SPY	ETF	390.44	391.1	386.34	387.04	7178237.0
2022-05-12 14:00:00	SPY	ETF	387.0	387.96	385.15	385.7349	9634670.0
2022-05-12 15:00:00	SPY	ETF	385.75	392.58	385.37	392.41	22965982.0
2022-05-12 16:00:00	SPY	ETF	392.38	392.6	390.15	390.6	4681514.0
2022-05-12 17:00:00	SPY	ETF	390.79	392.34	390.56	391.25	156277.0
2022-05-12 18:00:00	SPY	ETF	391.27	392.14	391.25	391.9	210390.0
2022-05-12 19:00:00	SPY	ETF	391.96	394.0	391.86	393.85	172316.0
2022-05-12 04:00:00	QQQ	ETF	290.78	291.0	288.0	288.51	155344.0
2022-05-12 05:00:00	QQQ	ETF	288.53	289.05	287.5	288.5	142242.0
2022-05-12 06:00:00	QQQ	ETF	288.44	289.47	288.22	289.26	119675.0
2022-05-12 07:00:00	QQQ	ETF	289.26	290.45	286.6	286.83	837265.0
2022-05-12 08:00:00	QQQ	ETF	286.79	292.45	286.64	287.5	1121476.0
2022-05-12 09:00:00	QQQ	ETF	287.47	290.25	285.04	287.53	16086646.0
2022-05-12 10:00:00	QQQ	ETF	287.49	294.61	286.26	294.36	18722430.0
2022-05-12 11:00:00	QQQ	ETF	294.38	295.75	288.75	288.78	11002038.0
2022-05-12 12:00:00	QQQ	ETF	288.78	292.12	287.91	290.31	9167541.0
2022-05-12 13:00:00	QQQ	ETF	290.29	291.055	285.63	286.21	6541211.0
2022-05-12 14:00:00	QQQ	ETF	286.17	287.24	284.94	285.6071	7535265.0
2022-05-12 15:00:00	QQQ	ETF	285.63	291.44	285.4145	291.25	17349518.0
2022-05-12 16:00:00	QQQ	ETF	291.26	291.39	289.04	289.39	3337402.0
2022-05-12 17:00:00	QQQ	ETF	289.67	290.4	289.38	290.16	255417.0
2022-05-12 18:00:00	QQQ	ETF	290.01	291.14	289.91	291.03	250609.0
2022-05-12 19:00:00	QQQ	ETF	291.03	293.18	291.01	293.04	332839.0
2022-05-12 04:00:00	IWM	ETF	170.57	170.57	169.29	169.65	23917.0
2022-05-12 05:00:00	IWM	ETF	169.76	169.91	169.16	169.69	28478.0
2022-05-12 06:00:00	IWM	ETF	169.6	170.38	169.6	170.26	42302.0
2022-05-12 07:00:00	IWM	ETF	170.23	170.71	169.0	169.21	146062.0
2022-05-12 08:00:00	IWM	ETF	169.21	170.58	169.18	169.59	196564.0
2022-05-12 09:00:00	IWM	ETF	169.73	171.17	168.9	170.1	6964035.0
2022-05-12 10:00:00	IWM	ETF	170.09	173.55	169.47	173.485	8723030.0
2022-05-12 11:00:00	IWM	ETF	173.49	174.34	170.9	170.9	5819270.0
2022-05-12 12:00:00	IWM	ETF	170.91	172.97	170.5	172.07	3481327.0
2022-05-12 13:00:00	IWM	ETF	172.06	172.39	169.6	170.02	3114113.0
2022-05-12 14:00:00	IWM	ETF	169.97	170.5	169.21	169.54	3319327.0
2022-05-12 15:00:00	IWM	ETF	169.545	172.91	169.31	172.8	8511167.0
2022-05-12 16:00:00	IWM	ETF	172.8	172.86	170.2179	171.94	2738567.0
2022-05-12 17:00:00	IWM	ETF	171.65	172.35	171.65	172.1	17332.0
2022-05-12 18:00:00	IWM	ETF	172.15	172.49	172.15	172.34	35034.0
2022-05-12 19:00:00	IWM	ETF	172.33	173.43	172.33	173.4	45372.0
2022-05-12 04:00:00	DIA	ETF	318.2	318.24	316.44	316.92	11435.0
2022-05-12 05:00:00	DIA	ETF	316.57	317.03	316.06	316.51	7900.0

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

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