PREVIEW / etf_1hour / 2022-05-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-09.parquet
  size:    491 KB
  rows:    17,964

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-09 04:00:00	SPY	ETF	406.64	407.7	404.73	405.86	122579.0
2022-05-09 05:00:00	SPY	ETF	405.88	406.39	404.62	405.2	87644.0
2022-05-09 06:00:00	SPY	ETF	405.16	405.16	402.92	403.25	323254.0
2022-05-09 07:00:00	SPY	ETF	403.39	404.79	402.69	404.54	577320.0
2022-05-09 08:00:00	SPY	ETF	403.4699	408.56	402.7299	405.1	960399.0
2022-05-09 09:00:00	SPY	ETF	405.12	406.41	403.27	405.2	13936661.0
2022-05-09 10:00:00	SPY	ETF	405.19	405.46	400.72	400.9633	16085664.0
2022-05-09 11:00:00	SPY	ETF	400.96	402.51	399.34	401.9	15466617.0
2022-05-09 12:00:00	SPY	ETF	401.91	404.15	400.64	400.72	11003520.0
2022-05-09 13:00:00	SPY	ETF	400.72	401.955	399.41	400.54	10460932.0
2022-05-09 14:00:00	SPY	ETF	400.5	401.62	399.11	401.31	12289857.0
2022-05-09 15:00:00	SPY	ETF	401.31	402.58	396.5	398.24	29028432.0
2022-05-09 16:00:00	SPY	ETF	398.25	411.3491	398.08	398.4	7006858.0
2022-05-09 17:00:00	SPY	ETF	398.35	398.73	398.3	398.73	158464.0
2022-05-09 18:00:00	SPY	ETF	398.7	399.7	398.7	399.44	115591.0
2022-05-09 19:00:00	SPY	ETF	399.54	399.57	398.65	399.47	68692.0
2022-05-09 04:00:00	QQQ	ETF	305.58	306.66	303.74	304.55	252990.0
2022-05-09 05:00:00	QQQ	ETF	304.55	305.08	303.09	303.69	117580.0
2022-05-09 06:00:00	QQQ	ETF	303.6	303.84	301.5	301.96	440315.0
2022-05-09 07:00:00	QQQ	ETF	301.97	302.83	300.94	302.62	833530.0
2022-05-09 08:00:00	QQQ	ETF	302.58	309.481	300.98	303.32	1231915.0
2022-05-09 09:00:00	QQQ	ETF	303.33	306.0	302.71	303.46	12240002.0
2022-05-09 10:00:00	QQQ	ETF	303.47	303.78	299.58	299.83	13161612.0
2022-05-09 11:00:00	QQQ	ETF	299.83	301.19	298.25	300.38	10933360.0
2022-05-09 12:00:00	QQQ	ETF	300.37	302.65	299.11	299.49	8074670.0
2022-05-09 13:00:00	QQQ	ETF	299.43	300.5484	297.95	298.71	7384626.0
2022-05-09 14:00:00	QQQ	ETF	298.71	299.76	297.57	299.59	9588525.0
2022-05-09 15:00:00	QQQ	ETF	299.59	300.68	295.72	297.19	20110580.0
2022-05-09 16:00:00	QQQ	ETF	297.2	299.84	297.0318	297.38	2856324.0
2022-05-09 17:00:00	QQQ	ETF	297.45	297.51	297.0	297.35	401032.0
2022-05-09 18:00:00	QQQ	ETF	297.38	298.5	297.38	298.21	354737.0
2022-05-09 19:00:00	QQQ	ETF	298.29	298.33	297.56	298.2	137634.0
2022-05-09 04:00:00	IWM	ETF	180.71	180.71	179.64	180.25	48377.0
2022-05-09 05:00:00	IWM	ETF	180.08	180.26	179.42	179.57	14944.0
2022-05-09 06:00:00	IWM	ETF	179.74	179.81	178.5	178.65	57826.0
2022-05-09 07:00:00	IWM	ETF	178.75	180.02	178.7	179.88	136380.0
2022-05-09 08:00:00	IWM	ETF	180.5204	180.6496	178.73	180.07	149957.0
2022-05-09 09:00:00	IWM	ETF	180.08	180.63	179.01	179.68	5294341.0
2022-05-09 10:00:00	IWM	ETF	179.67	179.96	176.6	176.86	5426471.0
2022-05-09 11:00:00	IWM	ETF	176.85	177.7	175.75	177.34	4808263.0
2022-05-09 12:00:00	IWM	ETF	177.33	178.79	176.01	176.06	3646499.0
2022-05-09 13:00:00	IWM	ETF	176.05	176.62	175.02	175.69	4287390.0
2022-05-09 14:00:00	IWM	ETF	175.67	176.3	174.75	176.19	4412162.0
2022-05-09 15:00:00	IWM	ETF	176.19	177.16	174.1	174.93	11153630.0
2022-05-09 16:00:00	IWM	ETF	174.94	175.55	174.45	175.11	1797812.0
2022-05-09 17:00:00	IWM	ETF	175.05	175.48	174.9	175.21	321439.0
2022-05-09 18:00:00	IWM	ETF	175.24	175.85	175.24	175.81	42683.0
2022-05-09 19:00:00	IWM	ETF	175.79	175.88	175.41	175.7896	21765.0
2022-05-09 04:00:00	DIA	ETF	325.65	325.77	324.47	325.42	5000.0
2022-05-09 05:00:00	DIA	ETF	325.5	325.74	324.65	325.09	421.0

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

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