PREVIEW / etf_1hour / 2022-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-07.parquet
  size:    449 KB
  rows:    15,929

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-07 04:00:00	SPY	ETF	410.5	410.85	410.16	410.54	41508.0
2022-06-07 05:00:00	SPY	ETF	410.35	410.61	409.86	409.88	26985.0
2022-06-07 06:00:00	SPY	ETF	409.98	410.09	408.67	408.8	60310.0
2022-06-07 07:00:00	SPY	ETF	408.87	409.43	407.66	408.65	510350.0
2022-06-07 08:00:00	SPY	ETF	409.38	410.08	407.75	407.77	507258.0
2022-06-07 09:00:00	SPY	ETF	407.72	410.54	407.42	409.7	5376941.0
2022-06-07 10:00:00	SPY	ETF	409.71	413.65	408.965	413.03	8132846.0
2022-06-07 11:00:00	SPY	ETF	413.03	413.38	410.86	411.77	4812617.0
2022-06-07 12:00:00	SPY	ETF	411.79	412.67	410.6644	412.4801	3556137.0
2022-06-07 13:00:00	SPY	ETF	412.5	413.6	412.23	413.105	3549459.0
2022-06-07 14:00:00	SPY	ETF	413.12	414.91	412.91	414.1	4840322.0
2022-06-07 15:00:00	SPY	ETF	414.11	416.22	413.96	415.7	11925089.0
2022-06-07 16:00:00	SPY	ETF	415.68	415.767	414.75	414.8	3359205.0
2022-06-07 17:00:00	SPY	ETF	414.87	415.1	414.77	415.02	88137.0
2022-06-07 18:00:00	SPY	ETF	415.02	415.38	414.9	415.05	88245.0
2022-06-07 19:00:00	SPY	ETF	415.1	415.25	414.45	414.55	104988.0
2022-06-07 04:00:00	QQQ	ETF	305.8	306.36	305.64	306.12	44475.0
2022-06-07 05:00:00	QQQ	ETF	306.12	306.13	305.42	305.56	32138.0
2022-06-07 06:00:00	QQQ	ETF	305.63	305.73	304.37	304.38	61043.0
2022-06-07 07:00:00	QQQ	ETF	304.57	305.07	303.4	304.03	373760.0
2022-06-07 08:00:00	QQQ	ETF	304.08	307.45	303.13	303.2	456236.0
2022-06-07 09:00:00	QQQ	ETF	303.2	306.78	302.6886	305.495	6477107.0
2022-06-07 10:00:00	QQQ	ETF	305.53	309.82	304.63	308.95	7457757.0
2022-06-07 11:00:00	QQQ	ETF	308.96	309.17	306.33	307.6	5001190.0
2022-06-07 12:00:00	QQQ	ETF	307.6016	308.0999	306.3813	307.8711	3230194.0
2022-06-07 13:00:00	QQQ	ETF	307.87	308.9	307.54	308.31	2330079.0
2022-06-07 14:00:00	QQQ	ETF	308.36	309.74	308.15	308.85	3126990.0
2022-06-07 15:00:00	QQQ	ETF	308.85	310.67	308.74	309.95	5614937.0
2022-06-07 16:00:00	QQQ	ETF	309.96	309.96	309.16	309.2	1785933.0
2022-06-07 17:00:00	QQQ	ETF	309.19	309.36	309.17	309.27	27313.0
2022-06-07 18:00:00	QQQ	ETF	309.27	309.75	309.25	309.37	79161.0
2022-06-07 19:00:00	QQQ	ETF	309.49	309.71	308.89	308.93	102598.0
2022-06-07 04:00:00	IWM	ETF	187.03	187.22	187.02	187.11	11163.0
2022-06-07 05:00:00	IWM	ETF	187.18	187.23	186.8	186.97	6926.0
2022-06-07 06:00:00	IWM	ETF	187.02	187.06	186.48	186.56	15861.0
2022-06-07 07:00:00	IWM	ETF	186.42	186.71	185.88	186.47	54266.0
2022-06-07 08:00:00	IWM	ETF	186.65	187.1296	186.03	186.12	35485.0
2022-06-07 09:00:00	IWM	ETF	186.1	187.63	185.9	187.47	1716959.0
2022-06-07 10:00:00	IWM	ETF	187.48	189.73	187.33	189.545	2537714.0
2022-06-07 11:00:00	IWM	ETF	189.545	189.75	188.1	188.59	1795512.0
2022-06-07 12:00:00	IWM	ETF	188.61	189.32	188.06	189.25	1368096.0
2022-06-07 13:00:00	IWM	ETF	189.26	189.45	189.035	189.25	1018915.0
2022-06-07 14:00:00	IWM	ETF	189.25	190.135	189.13	189.87	1516818.0
2022-06-07 15:00:00	IWM	ETF	189.85	190.94	189.79	190.88	3529231.0
2022-06-07 16:00:00	IWM	ETF	190.9	190.9	190.4	190.4	2855375.0
2022-06-07 17:00:00	IWM	ETF	190.37	190.64	190.31	190.57	8163.0
2022-06-07 18:00:00	IWM	ETF	190.57	190.68	190.41	190.43	34220.0
2022-06-07 19:00:00	IWM	ETF	190.53	190.6	190.25	190.34	24185.0
2022-06-07 04:00:00	DIA	ETF	328.44	328.44	328.44	328.44	100.0
2022-06-07 05:00:00	DIA	ETF	328.3	328.3	328.3	328.3	400.0

> showing 50 of 15,929 rows — these rows as CSV

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