PREVIEW / etf_1hour / 2022-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-10.parquet
  size:    472 KB
  rows:    17,265

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-10 04:00:00	SPY	ETF	400.73	402.7	400.73	402.58	63359.0
2022-05-10 05:00:00	SPY	ETF	402.6	402.99	401.35	401.48	93078.0
2022-05-10 06:00:00	SPY	ETF	401.69	402.4	401.27	401.28	132774.0
2022-05-10 07:00:00	SPY	ETF	401.21	401.46	400.17	401.2	430820.0
2022-05-10 08:00:00	SPY	ETF	401.23	404.05	396.9549	403.85	1410802.0
2022-05-10 09:00:00	SPY	ETF	403.87	406.08	401.85	404.14	11236037.0
2022-05-10 10:00:00	SPY	ETF	404.16	405.04	398.34	398.95	13139315.0
2022-05-10 11:00:00	SPY	ETF	398.95	399.86	395.77	397.41	15320944.0
2022-05-10 12:00:00	SPY	ETF	397.4	398.5	394.82	395.95	10344783.0
2022-05-10 13:00:00	SPY	ETF	395.94	403.14	395.63	403.07	12431654.0
2022-05-10 14:00:00	SPY	ETF	403.1	403.26	399.88	401.33	11608719.0
2022-05-10 15:00:00	SPY	ETF	401.32	402.78	398.08	399.07	20255702.0
2022-05-10 16:00:00	SPY	ETF	399.07	400.71	398.26	398.7	4330716.0
2022-05-10 17:00:00	SPY	ETF	398.52	398.81	398.5124	398.68	101633.0
2022-05-10 18:00:00	SPY	ETF	398.65	399.3	398.43	399.17	193104.0
2022-05-10 19:00:00	SPY	ETF	399.15	399.38	398.21	398.66	166762.0
2022-05-10 04:00:00	QQQ	ETF	300.12	302.36	300.12	301.94	200245.0
2022-05-10 05:00:00	QQQ	ETF	301.9	302.65	301.04	301.12	208420.0
2022-05-10 06:00:00	QQQ	ETF	301.01	301.95	300.7	300.71	237281.0
2022-05-10 07:00:00	QQQ	ETF	300.65	300.87	299.64	300.69	472489.0
2022-05-10 08:00:00	QQQ	ETF	300.18	304.0	299.47	303.83	2375349.0
2022-05-10 09:00:00	QQQ	ETF	303.81	305.76	300.62	303.7	13525975.0
2022-05-10 10:00:00	QQQ	ETF	303.69	305.49	298.67	298.98	16256077.0
2022-05-10 11:00:00	QQQ	ETF	298.97	300.05	296.57	298.99	14188236.0
2022-05-10 12:00:00	QQQ	ETF	298.98	300.16	297.12	298.045	9740855.0
2022-05-10 13:00:00	QQQ	ETF	298.03	304.96	297.74	304.94	13125961.0
2022-05-10 14:00:00	QQQ	ETF	304.96	305.07	301.98	303.59	11286982.0
2022-05-10 15:00:00	QQQ	ETF	303.58	304.86	300.14	300.82	14210837.0
2022-05-10 16:00:00	QQQ	ETF	300.81	301.21	300.1	300.48	2587183.0
2022-05-10 17:00:00	QQQ	ETF	300.4	300.76	300.24	300.37	84972.0
2022-05-10 18:00:00	QQQ	ETF	300.36	301.22	300.36	301.0499	134216.0
2022-05-10 19:00:00	QQQ	ETF	301.05	301.34	300.25	300.71	148983.0
2022-05-10 04:00:00	IWM	ETF	176.22	177.04	176.17	176.82	20665.0
2022-05-10 05:00:00	IWM	ETF	176.96	177.11	176.15	176.15	17839.0
2022-05-10 06:00:00	IWM	ETF	176.28	176.79	176.04	176.55	48851.0
2022-05-10 07:00:00	IWM	ETF	176.5	176.58	175.98	176.52	37952.0
2022-05-10 08:00:00	IWM	ETF	176.55	177.65	176.15	177.48	253071.0
2022-05-10 09:00:00	IWM	ETF	177.57	178.905	176.16	177.84	6553752.0
2022-05-10 10:00:00	IWM	ETF	177.85	178.42	174.82	174.93	5547555.0
2022-05-10 11:00:00	IWM	ETF	174.895	175.17	172.27	173.15	5842141.0
2022-05-10 12:00:00	IWM	ETF	173.14	173.75	171.2	172.08	5310151.0
2022-05-10 13:00:00	IWM	ETF	172.09	176.56	171.89	176.54	5657233.0
2022-05-10 14:00:00	IWM	ETF	176.57	176.71	174.85	175.74	5356096.0
2022-05-10 15:00:00	IWM	ETF	175.74	176.54	174.13	174.96	6478172.0
2022-05-10 16:00:00	IWM	ETF	174.95	175.19	174.59	174.95	1013619.0
2022-05-10 17:00:00	IWM	ETF	175.0	175.0	174.66	174.88	4456.0
2022-05-10 18:00:00	IWM	ETF	174.89	175.13	174.7	175.05	48928.0
2022-05-10 19:00:00	IWM	ETF	175.03	175.13	174.55	174.77	62087.0
2022-05-10 04:00:00	DIA	ETF	324.23	325.6	324.23	325.38	2406.0
2022-05-10 05:00:00	DIA	ETF	325.63	325.77	324.81	324.81	4300.0

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

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