PREVIEW / etf_1hour / 2022-10-19

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-19.parquet
  size:    452 KB
  rows:    16,774

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-10-19 04:00:00	SPY	ETF	371.79	372.93	370.0	370.93	69373.0
2022-10-19 05:00:00	SPY	ETF	370.83	372.99	370.77	372.94	36236.0
2022-10-19 06:00:00	SPY	ETF	373.0	373.07	370.64	370.94	120107.0
2022-10-19 07:00:00	SPY	ETF	371.24	371.67	368.99	369.93	754109.0
2022-10-19 08:00:00	SPY	ETF	371.48	373.9	367.99	368.89	1138922.0
2022-10-19 09:00:00	SPY	ETF	368.84	370.94	367.85	368.59	7911479.0
2022-10-19 10:00:00	SPY	ETF	368.58	371.85	368.23	369.68	8743321.0
2022-10-19 11:00:00	SPY	ETF	369.68	370.74	368.67	369.73	6416972.0
2022-10-19 12:00:00	SPY	ETF	369.73	369.82	366.865	367.25	7235396.0
2022-10-19 13:00:00	SPY	ETF	367.23	367.48	365.55	366.9301	7838419.0
2022-10-19 14:00:00	SPY	ETF	366.931	368.47	366.58	367.19	6661369.0
2022-10-19 15:00:00	SPY	ETF	367.19	368.73	366.91	368.56	11272321.0
2022-10-19 16:00:00	SPY	ETF	368.56	369.92	367.91	368.93	4536704.0
2022-10-19 17:00:00	SPY	ETF	368.82	368.91	368.4459	368.57	280958.0
2022-10-19 18:00:00	SPY	ETF	368.58	368.84	367.5	367.66	119591.0
2022-10-19 19:00:00	SPY	ETF	367.67	367.7	367.0	367.49	119390.0
2022-10-19 04:00:00	QQQ	ETF	272.8	272.8	271.01	271.89	224206.0
2022-10-19 05:00:00	QQQ	ETF	271.86	273.79	271.86	273.72	156189.0
2022-10-19 06:00:00	QQQ	ETF	273.79	273.82	271.49	272.0	288406.0
2022-10-19 07:00:00	QQQ	ETF	272.04	272.49	269.91	270.87	665342.0
2022-10-19 08:00:00	QQQ	ETF	272.24	274.99	269.33	270.0	1080959.0
2022-10-19 09:00:00	QQQ	ETF	269.94	271.95	269.33	270.11	6627356.0
2022-10-19 10:00:00	QQQ	ETF	270.11	273.68	269.72	271.36	6554387.0
2022-10-19 11:00:00	QQQ	ETF	271.36	272.45	270.63	271.72	4619950.0
2022-10-19 12:00:00	QQQ	ETF	271.7	271.86	269.4801	269.7499	3996995.0
2022-10-19 13:00:00	QQQ	ETF	269.73	269.9	268.07	269.24	5708175.0
2022-10-19 14:00:00	QQQ	ETF	269.21	270.54	268.9	269.34	4317939.0
2022-10-19 15:00:00	QQQ	ETF	269.37	270.65	268.96	270.59	6289390.0
2022-10-19 16:00:00	QQQ	ETF	270.59	271.99	269.5	270.45	1855344.0
2022-10-19 17:00:00	QQQ	ETF	270.53	270.55	269.95	270.03	420386.0
2022-10-19 18:00:00	QQQ	ETF	270.01	270.49	269.06	269.2	267845.0
2022-10-19 19:00:00	QQQ	ETF	269.21	269.33	268.64	269.05	153415.0
2022-10-19 04:00:00	IWM	ETF	174.03	174.1	173.18	173.45	39110.0
2022-10-19 05:00:00	IWM	ETF	173.61	174.68	173.51	174.66	45800.0
2022-10-19 06:00:00	IWM	ETF	174.7	174.7	173.4	173.67	49228.0
2022-10-19 07:00:00	IWM	ETF	173.7	173.83	172.45	172.92	126964.0
2022-10-19 08:00:00	IWM	ETF	173.74	174.6	172.1	172.81	177054.0
2022-10-19 09:00:00	IWM	ETF	172.78	173.37	171.36	171.575	1931117.0
2022-10-19 10:00:00	IWM	ETF	171.57	173.4	171.38	171.78	2582510.0
2022-10-19 11:00:00	IWM	ETF	171.77	172.28	171.4	171.68	1995173.0
2022-10-19 12:00:00	IWM	ETF	171.68	171.74	169.85	169.97	2093632.0
2022-10-19 13:00:00	IWM	ETF	169.96	170.205	169.3301	170.05	2076828.0
2022-10-19 14:00:00	IWM	ETF	170.04	170.99	169.91	170.48	1515853.0
2022-10-19 15:00:00	IWM	ETF	170.5	171.28	170.26	171.2	3539209.0
2022-10-19 16:00:00	IWM	ETF	171.21	171.75	171.06	171.5	1073973.0
2022-10-19 17:00:00	IWM	ETF	171.53	171.53	171.21	171.3	2118115.0
2022-10-19 18:00:00	IWM	ETF	171.38	171.47	170.79	170.88	313072.0
2022-10-19 19:00:00	IWM	ETF	170.88	170.93	170.59	170.81	41747.0
2022-10-19 04:00:00	DIA	ETF	305.63	305.65	304.6	304.6	11321.0
2022-10-19 05:00:00	DIA	ETF	305.82	306.32	305.8	306.32	1100.0

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

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