PREVIEW / etf_1hour / 2023-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-06-07.parquet
  size:    480 KB
  rows:    17,587

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
2023-06-07 04:00:00	SPY	ETF	427.71	427.75	427.4	427.69	23803.0
2023-06-07 05:00:00	SPY	ETF	427.72	427.91	427.56	427.76	8741.0
2023-06-07 06:00:00	SPY	ETF	427.81	428.38	427.81	428.35	11766.0
2023-06-07 07:00:00	SPY	ETF	428.32	428.83	428.25	428.83	116620.0
2023-06-07 08:00:00	SPY	ETF	428.3499	428.83	427.5604	428.46	339629.0
2023-06-07 09:00:00	SPY	ETF	428.5	429.62	428.34	429.29	6103747.0
2023-06-07 10:00:00	SPY	ETF	429.295	429.4	427.03	427.67	11119881.0
2023-06-07 11:00:00	SPY	ETF	427.67	428.2	426.8	426.895	6557373.0
2023-06-07 12:00:00	SPY	ETF	426.91	427.55	426.65	426.88	5462247.0
2023-06-07 13:00:00	SPY	ETF	426.89	427.2001	426.11	426.715	6977155.0
2023-06-07 14:00:00	SPY	ETF	426.71	427.395	426.28	426.97	5538945.0
2023-06-07 15:00:00	SPY	ETF	426.96	427.25	426.115	426.6	17319295.0
2023-06-07 16:00:00	SPY	ETF	426.59	426.71	426.43	426.52	3163312.0
2023-06-07 17:00:00	SPY	ETF	426.55	426.62	426.28	426.55	137696.0
2023-06-07 18:00:00	SPY	ETF	426.56	426.84	426.44	426.48	132249.0
2023-06-07 19:00:00	SPY	ETF	426.45	426.65	426.45	426.62	37858.0
2023-06-07 04:00:00	QQQ	ETF	354.08	354.28	353.9	354.22	33599.0
2023-06-07 05:00:00	QQQ	ETF	354.28	354.54	354.1	354.39	10510.0
2023-06-07 06:00:00	QQQ	ETF	354.45	354.98	354.45	354.9	37984.0
2023-06-07 07:00:00	QQQ	ETF	354.95	355.64	354.921	355.63	187313.0
2023-06-07 08:00:00	QQQ	ETF	354.9685	355.65	354.1604	355.26	283039.0
2023-06-07 09:00:00	QQQ	ETF	355.26	357.12	355.09	356.0687	5711775.0
2023-06-07 10:00:00	QQQ	ETF	356.05	356.25	351.63	352.2462	9118844.0
2023-06-07 11:00:00	QQQ	ETF	352.265	353.11	351.07	351.2	6388056.0
2023-06-07 12:00:00	QQQ	ETF	351.21	351.84	349.82	350.22	6789727.0
2023-06-07 13:00:00	QQQ	ETF	350.225	350.7	349.03	349.86	6697654.0
2023-06-07 14:00:00	QQQ	ETF	349.86	350.68	349.03	349.83	5296048.0
2023-06-07 15:00:00	QQQ	ETF	349.83	350.04	348.18	348.8	10572565.0
2023-06-07 16:00:00	QQQ	ETF	348.81	349.248	348.4	348.47	2955626.0
2023-06-07 17:00:00	QQQ	ETF	348.45	348.58	348.35	348.45	37240.0
2023-06-07 18:00:00	QQQ	ETF	348.45	348.82	348.22	348.33	198493.0
2023-06-07 19:00:00	QQQ	ETF	348.33	348.79	348.33	348.77	84669.0
2023-06-07 04:00:00	IWM	ETF	183.68	183.72	183.54	183.67	18894.0
2023-06-07 05:00:00	IWM	ETF	183.71	183.92	183.6	183.83	6260.0
2023-06-07 06:00:00	IWM	ETF	183.91	184.4	183.91	184.4	16108.0
2023-06-07 07:00:00	IWM	ETF	184.4	184.82	184.08	184.78	46726.0
2023-06-07 08:00:00	IWM	ETF	184.12	185.11	183.5204	185.1	179454.0
2023-06-07 09:00:00	IWM	ETF	185.1	187.44	184.8	187.42	6757686.0
2023-06-07 10:00:00	IWM	ETF	187.425	187.6	185.81	186.71	9177665.0
2023-06-07 11:00:00	IWM	ETF	186.7	187.68	186.31	186.44	4821759.0
2023-06-07 12:00:00	IWM	ETF	186.45	187.21	186.36	186.88	3300790.0
2023-06-07 13:00:00	IWM	ETF	186.88	186.95	186.17	186.76	4138311.0
2023-06-07 14:00:00	IWM	ETF	186.76	187.57	186.76	187.54	4250898.0
2023-06-07 15:00:00	IWM	ETF	187.54	187.77	187.12	187.23	8783519.0
2023-06-07 16:00:00	IWM	ETF	187.24	187.82	187.23	187.73	4933236.0
2023-06-07 17:00:00	IWM	ETF	187.74	187.83	187.611	187.75	32136.0
2023-06-07 18:00:00	IWM	ETF	187.66	187.81	187.52	187.61	33337.0
2023-06-07 19:00:00	IWM	ETF	187.57	187.64	187.49	187.55	23230.0
2023-06-07 04:00:00	DIA	ETF	335.64	335.64	335.64	335.64	241.0
2023-06-07 07:00:00	DIA	ETF	336.049	336.16	336.0	336.16	6984.0

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

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