PREVIEW / etf_1hour / 2022-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-13.parquet
  size:    470 KB
  rows:    17,382

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-13 04:00:00	SPY	ETF	357.35	358.23	356.9	358.2	30005.0
2022-10-13 05:00:00	SPY	ETF	358.2	358.9	358.19	358.26	49546.0
2022-10-13 06:00:00	SPY	ETF	358.26	358.86	358.06	358.6	149397.0
2022-10-13 07:00:00	SPY	ETF	358.6	361.12	358.5	360.12	1041004.0
2022-10-13 08:00:00	SPY	ETF	358.59	361.99	348.53	349.9	8430480.0
2022-10-13 09:00:00	SPY	ETF	349.9	352.5	348.11	351.96	14721958.0
2022-10-13 10:00:00	SPY	ETF	351.96	354.72	351.4	353.6	14912335.0
2022-10-13 11:00:00	SPY	ETF	353.59	365.34	353.3534	362.86	27011465.0
2022-10-13 12:00:00	SPY	ETF	362.87	364.05	360.9499	362.94	11175217.0
2022-10-13 13:00:00	SPY	ETF	362.96	366.49	362.91	365.556	10318543.0
2022-10-13 14:00:00	SPY	ETF	365.52	367.13	363.96	366.8	9253090.0
2022-10-13 15:00:00	SPY	ETF	366.7801	367.51	365.04	365.96	19724031.0
2022-10-13 16:00:00	SPY	ETF	365.96	366.57	365.58	365.79	5187857.0
2022-10-13 17:00:00	SPY	ETF	365.84	365.95	365.6	365.82	89265.0
2022-10-13 18:00:00	SPY	ETF	365.83	366.29	365.6	366.1	114826.0
2022-10-13 19:00:00	SPY	ETF	365.97	366.12	365.71	365.76	76162.0
2022-10-13 20:00:00	SPY	ETF	365.72	365.72	365.72	365.72	100.0
2022-10-13 04:00:00	QQQ	ETF	262.79	263.39	262.53	263.35	34007.0
2022-10-13 05:00:00	QQQ	ETF	263.34	263.89	263.3	263.3	37642.0
2022-10-13 06:00:00	QQQ	ETF	263.44	263.82	263.26	263.59	50507.0
2022-10-13 07:00:00	QQQ	ETF	263.56	265.31	263.431	264.7	355533.0
2022-10-13 08:00:00	QQQ	ETF	263.5901	266.62	254.63	255.69	7493906.0
2022-10-13 09:00:00	QQQ	ETF	255.6	257.84	254.26	257.48	11363441.0
2022-10-13 10:00:00	QQQ	ETF	257.49	259.73	257.01	258.505	13210815.0
2022-10-13 11:00:00	QQQ	ETF	258.5	269.56	258.15	266.83	19939874.0
2022-10-13 12:00:00	QQQ	ETF	266.84	267.86	264.65	266.065	7714346.0
2022-10-13 13:00:00	QQQ	ETF	266.08	269.55	266.08	268.43	7372350.0
2022-10-13 14:00:00	QQQ	ETF	268.43	269.66	266.88	269.3	6136610.0
2022-10-13 15:00:00	QQQ	ETF	269.3105	270.17	268.01	268.75	11289863.0
2022-10-13 16:00:00	QQQ	ETF	268.74	269.45	268.23	268.35	1335265.0
2022-10-13 17:00:00	QQQ	ETF	268.3	268.82	268.3	268.57	966328.0
2022-10-13 18:00:00	QQQ	ETF	268.53	268.79	268.15	268.54	135711.0
2022-10-13 19:00:00	QQQ	ETF	268.54	268.73	268.38	268.38	104789.0
2022-10-13 04:00:00	IWM	ETF	167.88	168.37	167.68	168.31	13330.0
2022-10-13 05:00:00	IWM	ETF	168.4	168.81	168.34	168.34	12932.0
2022-10-13 06:00:00	IWM	ETF	168.38	168.62	168.26	168.48	9668.0
2022-10-13 07:00:00	IWM	ETF	168.46	169.84	168.46	169.25	207034.0
2022-10-13 08:00:00	IWM	ETF	168.72	170.44	163.22	164.32	1280721.0
2022-10-13 09:00:00	IWM	ETF	164.33	165.565	162.5	165.0033	4369776.0
2022-10-13 10:00:00	IWM	ETF	165.0	166.37	164.29	165.955	4100006.0
2022-10-13 11:00:00	IWM	ETF	165.94	170.64	165.78	169.69	6755426.0
2022-10-13 12:00:00	IWM	ETF	169.75	170.45	168.67	170.09	2592520.0
2022-10-13 13:00:00	IWM	ETF	170.11	171.75	169.97	171.48	3157263.0
2022-10-13 14:00:00	IWM	ETF	171.45	171.84	170.55	171.75	2580126.0
2022-10-13 15:00:00	IWM	ETF	171.75	172.2	170.9	171.39	4176912.0
2022-10-13 16:00:00	IWM	ETF	171.4	171.7	167.3441	171.33	2012593.0
2022-10-13 17:00:00	IWM	ETF	171.51	171.51	171.23	171.39	355320.0
2022-10-13 18:00:00	IWM	ETF	171.4	171.64	171.26	171.53	47364.0
2022-10-13 19:00:00	IWM	ETF	171.49	171.58	171.31	171.45	30168.0
2022-10-13 05:00:00	DIA	ETF	293.93	293.93	293.82	293.82	1500.0

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

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