PREVIEW / etf_1hour / 2022-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-13.parquet
  size:    482 KB
  rows:    18,094

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-06-13 04:00:00	SPY	ETF	382.07	384.5	379.81	380.29	185145.0
2022-06-13 05:00:00	SPY	ETF	380.06	381.25	379.97	380.82	230357.0
2022-06-13 06:00:00	SPY	ETF	380.86	381.75	380.64	381.37	432636.0
2022-06-13 07:00:00	SPY	ETF	381.43	382.07	380.17	380.3	907682.0
2022-06-13 08:00:00	SPY	ETF	380.28	385.44	379.9404	380.58	897403.0
2022-06-13 09:00:00	SPY	ETF	380.56	381.81	379.18	379.79	11711852.0
2022-06-13 10:00:00	SPY	ETF	379.79	380.71	375.47	376.12	16209463.0
2022-06-13 11:00:00	SPY	ETF	376.14	379.29	374.93	378.28	14071342.0
2022-06-13 12:00:00	SPY	ETF	378.3	381.35	377.84	378.18	10053579.0
2022-06-13 13:00:00	SPY	ETF	378.18	379.98	376.9	379.3544	8633740.0
2022-06-13 14:00:00	SPY	ETF	379.33	379.4	376.681	376.9352	8742906.0
2022-06-13 15:00:00	SPY	ETF	376.93	378.08	373.3	375.02	32242838.0
2022-06-13 16:00:00	SPY	ETF	375.02	376.0	373.4	375.44	8488060.0
2022-06-13 17:00:00	SPY	ETF	375.43	375.78	375.35	375.75	103715.0
2022-06-13 18:00:00	SPY	ETF	375.75	376.68	375.75	376.26	187778.0
2022-06-13 19:00:00	SPY	ETF	376.3	376.3	375.3	376.04	144910.0
2022-06-13 04:00:00	QQQ	ETF	281.94	283.64	278.94	279.97	382303.0
2022-06-13 05:00:00	QQQ	ETF	279.97	280.84	279.52	280.3	185865.0
2022-06-13 06:00:00	QQQ	ETF	280.48	281.33	280.24	280.91	274383.0
2022-06-13 07:00:00	QQQ	ETF	280.95	281.47	279.56	279.71	779568.0
2022-06-13 08:00:00	QQQ	ETF	281.2	289.056	279.2796	280.38	1110339.0
2022-06-13 09:00:00	QQQ	ETF	280.36	282.34	279.61	280.14	8676167.0
2022-06-13 10:00:00	QQQ	ETF	280.14	281.14	276.68	277.04	10729495.0
2022-06-13 11:00:00	QQQ	ETF	277.07	279.16	276.07	278.33	9164900.0
2022-06-13 12:00:00	QQQ	ETF	278.33	281.22	277.76	278.5	6834766.0
2022-06-13 13:00:00	QQQ	ETF	278.52	279.62	277.43	279.32	5295061.0
2022-06-13 14:00:00	QQQ	ETF	279.31	279.35	276.96	277.16	6467231.0
2022-06-13 15:00:00	QQQ	ETF	277.18	278.19	274.53	275.49	16934381.0
2022-06-13 16:00:00	QQQ	ETF	275.51	276.84	275.0	276.43	3464492.0
2022-06-13 17:00:00	QQQ	ETF	276.46	276.7	275.41	276.52	281010.0
2022-06-13 18:00:00	QQQ	ETF	276.58	277.35	276.57	276.91	196494.0
2022-06-13 19:00:00	QQQ	ETF	276.9	276.95	276.0	276.58	238380.0
2022-06-13 04:00:00	IWM	ETF	174.73	174.73	173.76	173.81	62988.0
2022-06-13 05:00:00	IWM	ETF	173.71	174.46	173.71	174.16	17878.0
2022-06-13 06:00:00	IWM	ETF	174.21	174.72	174.06	174.44	124174.0
2022-06-13 07:00:00	IWM	ETF	174.45	174.83	173.91	173.97	145815.0
2022-06-13 08:00:00	IWM	ETF	174.23	175.4	173.96	174.14	209218.0
2022-06-13 09:00:00	IWM	ETF	174.1	174.96	172.15	172.21	4282132.0
2022-06-13 10:00:00	IWM	ETF	172.19	172.72	169.61	169.94	5529753.0
2022-06-13 11:00:00	IWM	ETF	169.94	171.61	169.29	171.18	4447959.0
2022-06-13 12:00:00	IWM	ETF	171.16	173.145	170.77	171.18	2727664.0
2022-06-13 13:00:00	IWM	ETF	171.2	172.36	170.575	171.95	2140827.0
2022-06-13 14:00:00	IWM	ETF	171.94	171.95	170.63	170.76	1974473.0
2022-06-13 15:00:00	IWM	ETF	170.75	171.45	169.36	170.17	6117743.0
2022-06-13 16:00:00	IWM	ETF	170.2	170.54	169.74	170.36	1880530.0
2022-06-13 17:00:00	IWM	ETF	170.22	170.44	170.08	170.24	632042.0
2022-06-13 18:00:00	IWM	ETF	170.38	170.95	170.38	170.61	24030.0
2022-06-13 19:00:00	IWM	ETF	170.64	170.64	170.2	170.49	36353.0
2022-06-13 04:00:00	DIA	ETF	310.0	310.0	308.13	308.2	6352.0
2022-06-13 05:00:00	DIA	ETF	307.98	308.78	307.98	308.51	1724.0

> showing 50 of 18,094 rows — these rows as CSV

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