PREVIEW / etf_1hour / 2022-06-21

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-21.parquet
  size:    468 KB
  rows:    17,109

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-21 04:00:00	SPY	ETF	372.4	373.06	371.0	372.84	179161.0
2022-06-21 05:00:00	SPY	ETF	372.88	373.03	372.19	372.19	28780.0
2022-06-21 06:00:00	SPY	ETF	372.32	372.65	372.09	372.45	83663.0
2022-06-21 07:00:00	SPY	ETF	372.36	372.44	370.88	371.11	312547.0
2022-06-21 08:00:00	SPY	ETF	372.35	372.8896	370.69	370.93	874487.0
2022-06-21 09:00:00	SPY	ETF	370.94	374.91	370.89	374.83	8769603.0
2022-06-21 10:00:00	SPY	ETF	374.84	376.25	374.39	376.06	8942923.0
2022-06-21 11:00:00	SPY	ETF	376.07	376.28	374.2	374.21	6779975.0
2022-06-21 12:00:00	SPY	ETF	374.2	375.61	373.91	375.55	4736892.0
2022-06-21 13:00:00	SPY	ETF	375.58	375.93	374.735	374.835	3790181.0
2022-06-21 14:00:00	SPY	ETF	374.85	376.19	374.52	376.0817	5738327.0
2022-06-21 15:00:00	SPY	ETF	376.1	376.525	374.67	375.0699	14102355.0
2022-06-21 16:00:00	SPY	ETF	375.04	375.3	374.0	375.07	4137984.0
2022-06-21 17:00:00	SPY	ETF	375.25	375.3	374.84	375.0	146801.0
2022-06-21 18:00:00	SPY	ETF	374.95	374.95	374.3	374.67	145315.0
2022-06-21 19:00:00	SPY	ETF	374.65	374.68	374.17	374.67	84282.0
2022-06-21 04:00:00	QQQ	ETF	278.56	280.25	278.06	279.94	237857.0
2022-06-21 05:00:00	QQQ	ETF	279.98	280.11	279.13	279.29	166813.0
2022-06-21 06:00:00	QQQ	ETF	279.3	279.57	279.0	279.41	197355.0
2022-06-21 07:00:00	QQQ	ETF	279.36	279.41	278.02	278.14	507454.0
2022-06-21 08:00:00	QQQ	ETF	278.14	280.1304	277.8	278.16	662123.0
2022-06-21 09:00:00	QQQ	ETF	278.16	282.345	278.15	282.295	6520064.0
2022-06-21 10:00:00	QQQ	ETF	282.29	283.44	281.93	283.31	6803275.0
2022-06-21 11:00:00	QQQ	ETF	283.32	283.45	281.74	281.74	4370716.0
2022-06-21 12:00:00	QQQ	ETF	281.75	282.4	281.2906	282.2923	3727358.0
2022-06-21 13:00:00	QQQ	ETF	282.3155	282.64	281.55	281.68	2687518.0
2022-06-21 14:00:00	QQQ	ETF	281.7	282.12	281.0801	281.98	3560774.0
2022-06-21 15:00:00	QQQ	ETF	282.005	282.45	280.75	281.19	7444550.0
2022-06-21 16:00:00	QQQ	ETF	281.17	281.44	280.83	281.08	3385521.0
2022-06-21 17:00:00	QQQ	ETF	281.25	281.42	281.08	281.08	72285.0
2022-06-21 18:00:00	QQQ	ETF	281.08	281.11	280.62	280.99	77829.0
2022-06-21 19:00:00	QQQ	ETF	281.01	281.1	280.6	281.1	40644.0
2022-06-21 04:00:00	IWM	ETF	168.5	168.91	168.47	168.82	64808.0
2022-06-21 05:00:00	IWM	ETF	168.87	168.87	168.35	168.37	25323.0
2022-06-21 06:00:00	IWM	ETF	168.37	168.63	168.33	168.5	21418.0
2022-06-21 07:00:00	IWM	ETF	168.51	168.53	167.81	167.97	75476.0
2022-06-21 08:00:00	IWM	ETF	168.53	168.53	167.62	167.71	79023.0
2022-06-21 09:00:00	IWM	ETF	167.64	168.64	166.81	168.58	3672240.0
2022-06-21 10:00:00	IWM	ETF	168.57	170.08	168.33	169.93	4548734.0
2022-06-21 11:00:00	IWM	ETF	169.94	169.985	168.42	168.42	2679224.0
2022-06-21 12:00:00	IWM	ETF	168.41	169.51	168.385	169.51	1785982.0
2022-06-21 13:00:00	IWM	ETF	169.505	169.565	168.59	168.66	1906259.0
2022-06-21 14:00:00	IWM	ETF	168.67	168.86	168.2	168.65	2319225.0
2022-06-21 15:00:00	IWM	ETF	168.66	169.07	167.93	168.13	4331330.0
2022-06-21 16:00:00	IWM	ETF	168.14	168.35	167.95	168.14	4061060.0
2022-06-21 17:00:00	IWM	ETF	168.16	168.33	168.15	168.3	8134.0
2022-06-21 18:00:00	IWM	ETF	168.22	168.22	167.83	168.09	31503.0
2022-06-21 19:00:00	IWM	ETF	168.14	168.14	167.85	168.03	31123.0
2022-06-21 04:00:00	DIA	ETF	302.5	303.88	302.5	303.7	1791.0
2022-06-21 05:00:00	DIA	ETF	303.7	303.7	303.7	303.7	314.0

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

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