PREVIEW / etf_1hour / 2022-05-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-19.parquet
  size:    461 KB
  rows:    16,783

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-19 04:00:00	SPY	ETF	388.77	389.02	386.4	386.4	140997.0
2022-05-19 05:00:00	SPY	ETF	386.36	386.85	385.41	385.8	173079.0
2022-05-19 06:00:00	SPY	ETF	385.7	388.15	385.7	387.84	392119.0
2022-05-19 07:00:00	SPY	ETF	388.08	389.56	387.09	389.05	746165.0
2022-05-19 08:00:00	SPY	ETF	388.0009	392.66	385.4204	387.74	1047467.0
2022-05-19 09:00:00	SPY	ETF	387.7	391.79	387.11	388.64	10837068.0
2022-05-19 10:00:00	SPY	ETF	388.63	391.92	387.86	389.32	10620149.0
2022-05-19 11:00:00	SPY	ETF	389.29	393.34	388.285	391.895	8710024.0
2022-05-19 12:00:00	SPY	ETF	391.95	393.0	388.82	389.96	7728056.0
2022-05-19 13:00:00	SPY	ETF	389.95	392.25	388.33	391.75	7916241.0
2022-05-19 14:00:00	SPY	ETF	391.72	393.13	390.0	392.79	8120386.0
2022-05-19 15:00:00	SPY	ETF	392.81	394.14	389.04	389.45	16192775.0
2022-05-19 16:00:00	SPY	ETF	389.44	390.602	388.74	389.62	3702695.0
2022-05-19 17:00:00	SPY	ETF	389.51	389.63	389.4	389.5	49831.0
2022-05-19 18:00:00	SPY	ETF	389.52	390.39	389.52	390.02	129038.0
2022-05-19 19:00:00	SPY	ETF	390.01	390.7	389.68	390.52	70145.0
2022-05-19 04:00:00	QQQ	ETF	288.15	288.21	286.14	286.22	204848.0
2022-05-19 05:00:00	QQQ	ETF	286.22	286.64	285.45	285.82	138251.0
2022-05-19 06:00:00	QQQ	ETF	285.97	287.96	285.88	287.86	156902.0
2022-05-19 07:00:00	QQQ	ETF	287.84	289.12	287.08	288.75	685068.0
2022-05-19 08:00:00	QQQ	ETF	287.72	291.5	285.7	288.2	903834.0
2022-05-19 09:00:00	QQQ	ETF	288.19	292.06	287.58	289.96	11200381.0
2022-05-19 10:00:00	QQQ	ETF	289.96	292.78	289.39	291.35	11568592.0
2022-05-19 11:00:00	QQQ	ETF	291.34	294.39	290.185	293.25	7224225.0
2022-05-19 12:00:00	QQQ	ETF	293.27	293.95	289.84	290.8866	5335064.0
2022-05-19 13:00:00	QQQ	ETF	290.88	292.31	288.94	291.89	5674611.0
2022-05-19 14:00:00	QQQ	ETF	291.93	293.43	290.2217	292.83	5826553.0
2022-05-19 15:00:00	QQQ	ETF	292.86	293.81	289.12	289.6	9415774.0
2022-05-19 16:00:00	QQQ	ETF	289.57	290.34	288.87	290.12	3974351.0
2022-05-19 17:00:00	QQQ	ETF	290.07	290.3	289.58	290.12	152998.0
2022-05-19 18:00:00	QQQ	ETF	290.22	290.76	290.15	290.39	117553.0
2022-05-19 19:00:00	QQQ	ETF	290.39	291.05	290.04	290.93	113711.0
2022-05-19 04:00:00	IWM	ETF	174.85	175.02	174.02	174.07	18858.0
2022-05-19 05:00:00	IWM	ETF	173.84	174.02	173.57	173.7	31599.0
2022-05-19 06:00:00	IWM	ETF	173.95	174.95	173.91	174.88	31215.0
2022-05-19 07:00:00	IWM	ETF	174.98	175.57	174.42	175.35	59908.0
2022-05-19 08:00:00	IWM	ETF	175.35	176.6	174.23	174.73	205888.0
2022-05-19 09:00:00	IWM	ETF	174.63	177.28	174.62	175.32	4620216.0
2022-05-19 10:00:00	IWM	ETF	175.29	177.09	175.06	176.1	4466699.0
2022-05-19 11:00:00	IWM	ETF	176.1	178.48	175.52	178.09	3866222.0
2022-05-19 12:00:00	IWM	ETF	178.09	178.27	176.14	176.95	2843176.0
2022-05-19 13:00:00	IWM	ETF	176.98	178.81	176.49	178.54	2476742.0
2022-05-19 14:00:00	IWM	ETF	178.51	178.61	177.32	178.36	2282068.0
2022-05-19 15:00:00	IWM	ETF	178.37	178.8	176.335	176.54	4050451.0
2022-05-19 16:00:00	IWM	ETF	176.53	176.84	176.22	176.7	925191.0
2022-05-19 17:00:00	IWM	ETF	176.94	176.94	176.53	176.85	151221.0
2022-05-19 18:00:00	IWM	ETF	176.74	177.08	176.74	176.96	21615.0
2022-05-19 19:00:00	IWM	ETF	176.94	177.35	176.82	177.19	29859.0
2022-05-19 04:00:00	DIA	ETF	312.2	312.31	311.58	311.58	2698.0
2022-05-19 05:00:00	DIA	ETF	311.25	311.3	310.68	311.19	2384.0

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

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