PREVIEW / etf_1hour / 2022-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-23.parquet
  size:    462 KB
  rows:    16,664

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-23 04:00:00	SPY	ETF	394.1	394.59	391.0	391.83	102931.0
2022-05-23 05:00:00	SPY	ETF	391.5	393.01	391.28	392.05	28562.0
2022-05-23 06:00:00	SPY	ETF	392.05	394.55	391.99	394.4	98321.0
2022-05-23 07:00:00	SPY	ETF	394.4	394.54	392.85	393.38	238759.0
2022-05-23 08:00:00	SPY	ETF	393.46	395.0	391.23	393.06	541107.0
2022-05-23 09:00:00	SPY	ETF	393.1	394.44	391.1	392.1863	8153794.0
2022-05-23 10:00:00	SPY	ETF	392.23	395.01	390.38	393.88	10783752.0
2022-05-23 11:00:00	SPY	ETF	393.9	397.02	393.5	396.44	7856295.0
2022-05-23 12:00:00	SPY	ETF	396.45	397.61	395.26	395.9474	6327646.0
2022-05-23 13:00:00	SPY	ETF	395.97	396.83	394.02	396.72	5600455.0
2022-05-23 14:00:00	SPY	ETF	396.74	397.73	396.09	396.23	6127643.0
2022-05-23 15:00:00	SPY	ETF	396.23	397.25	394.93	396.93	12545743.0
2022-05-23 16:00:00	SPY	ETF	396.95	397.9	396.92	397.54	3452741.0
2022-05-23 17:00:00	SPY	ETF	397.56	397.67	394.58	394.84	648334.0
2022-05-23 18:00:00	SPY	ETF	394.8	394.83	392.62	394.17	489826.0
2022-05-23 19:00:00	SPY	ETF	394.27	394.66	393.69	394.5	186437.0
2022-05-23 04:00:00	QQQ	ETF	291.86	292.66	289.4	290.03	140797.0
2022-05-23 05:00:00	QQQ	ETF	289.84	291.08	289.65	289.98	91636.0
2022-05-23 06:00:00	QQQ	ETF	290.03	291.85	289.87	291.8	93794.0
2022-05-23 07:00:00	QQQ	ETF	291.72	291.85	290.21	290.63	481906.0
2022-05-23 08:00:00	QQQ	ETF	291.49	293.34	288.896	290.0	520043.0
2022-05-23 09:00:00	QQQ	ETF	290.08	292.005	288.1306	289.0	9202412.0
2022-05-23 10:00:00	QQQ	ETF	289.03	291.13	287.29	289.58	10431016.0
2022-05-23 11:00:00	QQQ	ETF	289.61	292.93	289.22	292.3	5996567.0
2022-05-23 12:00:00	QQQ	ETF	292.3104	293.84	291.6984	292.165	4335236.0
2022-05-23 13:00:00	QQQ	ETF	292.18	292.97	290.5401	292.61	3370340.0
2022-05-23 14:00:00	QQQ	ETF	292.62	293.87	292.07	292.4467	3403324.0
2022-05-23 15:00:00	QQQ	ETF	292.46	293.59	291.5	293.44	8543344.0
2022-05-23 16:00:00	QQQ	ETF	293.43	294.38	292.2	293.94	1779651.0
2022-05-23 17:00:00	QQQ	ETF	293.96	293.96	289.4	289.62	1171434.0
2022-05-23 18:00:00	QQQ	ETF	289.9	293.48	288.21	289.73	1096297.0
2022-05-23 19:00:00	QQQ	ETF	289.76	289.98	289.24	289.84	276732.0
2022-05-23 04:00:00	IWM	ETF	177.02	178.8	177.02	177.39	18974.0
2022-05-23 05:00:00	IWM	ETF	177.41	177.99	177.17	177.44	12034.0
2022-05-23 06:00:00	IWM	ETF	177.5	178.81	177.48	178.74	31715.0
2022-05-23 07:00:00	IWM	ETF	178.63	178.79	178.09	178.32	62766.0
2022-05-23 08:00:00	IWM	ETF	178.58	178.71	177.88	178.0	90399.0
2022-05-23 09:00:00	IWM	ETF	178.07	178.33	176.33	176.4	3687676.0
2022-05-23 10:00:00	IWM	ETF	176.41	177.65	175.5	177.2	3512257.0
2022-05-23 11:00:00	IWM	ETF	177.2	178.785	177.04	178.27	2519811.0
2022-05-23 12:00:00	IWM	ETF	178.27	178.91	177.63	177.97	1682474.0
2022-05-23 13:00:00	IWM	ETF	177.98	178.37	177.03	178.29	1462135.0
2022-05-23 14:00:00	IWM	ETF	178.3	178.96	178.02	178.3	1618836.0
2022-05-23 15:00:00	IWM	ETF	178.3	178.78	177.2412	178.21	3570972.0
2022-05-23 16:00:00	IWM	ETF	178.21	178.67	178.1	178.62	669827.0
2022-05-23 17:00:00	IWM	ETF	178.77	178.77	177.7	178.0	137864.0
2022-05-23 18:00:00	IWM	ETF	178.0	178.21	176.89	177.66	198205.0
2022-05-23 19:00:00	IWM	ETF	177.6	177.82	177.31	177.73	64007.0
2022-05-23 04:00:00	DIA	ETF	315.75	315.75	313.62	313.62	1170.0
2022-05-23 05:00:00	DIA	ETF	313.8	313.96	313.71	313.71	1160.0

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

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