PREVIEW / etf_1hour / 2022-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-20.parquet
  size:    465 KB
  rows:    16,701

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-20 04:00:00	SPY	ETF	389.5	394.32	389.5	393.9	58082.0
2022-05-20 05:00:00	SPY	ETF	393.7	394.66	393.5	393.74	29027.0
2022-05-20 06:00:00	SPY	ETF	393.6	394.1	393.52	393.57	74487.0
2022-05-20 07:00:00	SPY	ETF	393.66	394.57	392.63	393.98	343990.0
2022-05-20 08:00:00	SPY	ETF	394.58	394.58	391.6	393.31	591411.0
2022-05-20 09:00:00	SPY	ETF	393.29	397.03	391.66	392.76	6631723.0
2022-05-20 10:00:00	SPY	ETF	392.75	393.28	387.47	387.561	8736792.0
2022-05-20 11:00:00	SPY	ETF	387.56	389.02	385.48	386.2	9341562.0
2022-05-20 12:00:00	SPY	ETF	386.2	386.3625	381.87	382.97	12206632.0
2022-05-20 13:00:00	SPY	ETF	382.94	384.07	380.54	383.46	11559357.0
2022-05-20 14:00:00	SPY	ETF	383.48	384.82	381.38	383.51	10478351.0
2022-05-20 15:00:00	SPY	ETF	383.55	389.9303	382.36	389.6	26440891.0
2022-05-20 16:00:00	SPY	ETF	389.59	390.27	388.96	389.95	6514578.0
2022-05-20 17:00:00	SPY	ETF	389.95	390.17	389.84	390.05	183199.0
2022-05-20 18:00:00	SPY	ETF	390.1	390.47	390.0	390.43	67487.0
2022-05-20 19:00:00	SPY	ETF	390.42	391.0	389.63	390.62	146180.0
2022-05-20 04:00:00	QQQ	ETF	293.78	294.69	292.66	294.17	129176.0
2022-05-20 05:00:00	QQQ	ETF	294.07	294.89	293.71	293.89	84470.0
2022-05-20 06:00:00	QQQ	ETF	293.91	294.26	293.51	293.55	72822.0
2022-05-20 07:00:00	QQQ	ETF	293.63	294.59	293.2	294.02	459237.0
2022-05-20 08:00:00	QQQ	ETF	294.81	294.81	289.363	293.29	753707.0
2022-05-20 09:00:00	QQQ	ETF	293.3	293.8	291.23	292.44	7404430.0
2022-05-20 10:00:00	QQQ	ETF	292.44	292.8	287.5801	287.74	7817459.0
2022-05-20 11:00:00	QQQ	ETF	287.75	288.15	285.601	286.12	7041200.0
2022-05-20 12:00:00	QQQ	ETF	286.09	286.31	281.2401	282.2823	8891729.0
2022-05-20 13:00:00	QQQ	ETF	282.25	283.7	280.21	283.1	8364161.0
2022-05-20 14:00:00	QQQ	ETF	283.145	283.87	280.88	282.5898	7305615.0
2022-05-20 15:00:00	QQQ	ETF	282.6	288.84	281.55	288.54	16215828.0
2022-05-20 16:00:00	QQQ	ETF	288.54	289.0	287.74	288.6	2787186.0
2022-05-20 17:00:00	QQQ	ETF	288.67	288.7	288.21	288.52	185009.0
2022-05-20 18:00:00	QQQ	ETF	288.5	288.59	288.24	288.5	55134.0
2022-05-20 19:00:00	QQQ	ETF	288.53	290.0	288.53	288.95	72455.0
2022-05-20 04:00:00	IWM	ETF	178.49	179.2	178.3	178.86	21188.0
2022-05-20 05:00:00	IWM	ETF	178.93	179.31	178.77	178.91	22322.0
2022-05-20 06:00:00	IWM	ETF	178.87	179.08	178.79	178.87	12036.0
2022-05-20 07:00:00	IWM	ETF	178.8	179.37	178.65	179.03	48461.0
2022-05-20 08:00:00	IWM	ETF	178.37	179.22	178.15	178.33	99527.0
2022-05-20 09:00:00	IWM	ETF	178.42	178.97	176.79	177.26	3288130.0
2022-05-20 10:00:00	IWM	ETF	177.25	177.41	174.54	174.61	3789738.0
2022-05-20 11:00:00	IWM	ETF	174.615	174.78	173.48	173.9827	3323202.0
2022-05-20 12:00:00	IWM	ETF	173.96	174.105	172.39	172.94	2674479.0
2022-05-20 13:00:00	IWM	ETF	172.9	173.74	171.79	173.51	2615944.0
2022-05-20 14:00:00	IWM	ETF	173.53	174.24	172.45	173.46	2848266.0
2022-05-20 15:00:00	IWM	ETF	173.47	176.31	172.88	176.19	5509090.0
2022-05-20 16:00:00	IWM	ETF	176.18	176.38	175.66	176.31	2989803.0
2022-05-20 17:00:00	IWM	ETF	176.01	176.34	176.01	176.34	9694.0
2022-05-20 18:00:00	IWM	ETF	176.27	176.7	176.27	176.67	13624.0
2022-05-20 19:00:00	IWM	ETF	176.64	176.79	176.42	176.49	17889.0
2022-05-20 04:00:00	DIA	ETF	315.18	315.18	315.18	315.18	100.0
2022-05-20 05:00:00	DIA	ETF	315.11	315.66	315.11	315.6	1673.0

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

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