PREVIEW / etf_1hour / 2022-06-08

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-08.parquet
  size:    447 KB
  rows:    15,931

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-08 04:00:00	SPY	ETF	414.0	414.51	413.61	414.21	41642.0
2022-06-08 05:00:00	SPY	ETF	414.22	414.42	413.65	414.33	19190.0
2022-06-08 06:00:00	SPY	ETF	414.2	414.49	413.56	414.43	35876.0
2022-06-08 07:00:00	SPY	ETF	414.43	415.14	414.12	414.44	256072.0
2022-06-08 08:00:00	SPY	ETF	414.44	415.0999	413.29	413.74	436009.0
2022-06-08 09:00:00	SPY	ETF	413.71	415.82	412.66	415.28	5802156.0
2022-06-08 10:00:00	SPY	ETF	415.32	415.4424	413.26	414.14	5783372.0
2022-06-08 11:00:00	SPY	ETF	414.155	415.69	413.655	414.8053	3882786.0
2022-06-08 12:00:00	SPY	ETF	414.82	415.37	411.56	412.73	5434534.0
2022-06-08 13:00:00	SPY	ETF	412.72	412.7299	410.64	411.52	5507624.0
2022-06-08 14:00:00	SPY	ETF	411.545	412.05	410.4	411.22	6019168.0
2022-06-08 15:00:00	SPY	ETF	411.23	412.48	410.38	411.29	12287127.0
2022-06-08 16:00:00	SPY	ETF	411.28	411.63	410.5	411.5	3098542.0
2022-06-08 17:00:00	SPY	ETF	411.55	411.62	411.22	411.52	54603.0
2022-06-08 18:00:00	SPY	ETF	411.53	411.7	411.22	411.7	46796.0
2022-06-08 19:00:00	SPY	ETF	411.7	411.79	411.49	411.6	33544.0
2022-06-08 04:00:00	QQQ	ETF	308.45	309.45	308.45	309.13	50634.0
2022-06-08 05:00:00	QQQ	ETF	309.18	309.56	308.81	309.31	18163.0
2022-06-08 06:00:00	QQQ	ETF	309.2	309.63	308.5	309.48	30637.0
2022-06-08 07:00:00	QQQ	ETF	309.52	310.17	309.24	309.38	175581.0
2022-06-08 08:00:00	QQQ	ETF	309.33	310.102	308.04	308.59	436178.0
2022-06-08 09:00:00	QQQ	ETF	308.59	311.72	307.95	311.15	5848195.0
2022-06-08 10:00:00	QQQ	ETF	311.175	311.4893	309.37	310.0322	4681524.0
2022-06-08 11:00:00	QQQ	ETF	310.0699	311.48	309.41	310.32	3094887.0
2022-06-08 12:00:00	QQQ	ETF	310.32	310.86	307.4	308.4	4164759.0
2022-06-08 13:00:00	QQQ	ETF	308.36	308.4099	306.77	308.06	3547778.0
2022-06-08 14:00:00	QQQ	ETF	308.07	308.57	306.96	307.67	3204533.0
2022-06-08 15:00:00	QQQ	ETF	307.68	308.67	306.8	307.7	4367530.0
2022-06-08 16:00:00	QQQ	ETF	307.73	307.9	307.19	307.84	764263.0
2022-06-08 17:00:00	QQQ	ETF	307.72	307.9	307.64	307.7	87391.0
2022-06-08 18:00:00	QQQ	ETF	307.73	307.98	307.5	307.97	66083.0
2022-06-08 19:00:00	QQQ	ETF	307.91	308.03	307.69	307.82	54834.0
2022-06-08 04:00:00	IWM	ETF	189.86	190.24	189.71	190.05	12980.0
2022-06-08 05:00:00	IWM	ETF	190.07	190.17	189.79	189.96	8151.0
2022-06-08 06:00:00	IWM	ETF	189.83	190.19	189.67	190.04	11002.0
2022-06-08 07:00:00	IWM	ETF	190.09	190.39	189.94	190.08	53503.0
2022-06-08 08:00:00	IWM	ETF	190.05	190.92	189.58	189.96	34640.0
2022-06-08 09:00:00	IWM	ETF	189.95	190.7	188.86	190.45	2264294.0
2022-06-08 10:00:00	IWM	ETF	190.44	190.5905	189.03	189.58	1962090.0
2022-06-08 11:00:00	IWM	ETF	189.59	190.49	189.38	190.0	1474349.0
2022-06-08 12:00:00	IWM	ETF	189.99	190.38	187.835	188.44	1881907.0
2022-06-08 13:00:00	IWM	ETF	188.43	188.54	187.26	187.71	1694122.0
2022-06-08 14:00:00	IWM	ETF	187.68	187.99	187.06	187.51	1287257.0
2022-06-08 15:00:00	IWM	ETF	187.51	188.305	187.24	187.99	2356021.0
2022-06-08 16:00:00	IWM	ETF	187.95	188.32	187.94	188.32	683228.0
2022-06-08 17:00:00	IWM	ETF	188.11	188.3	187.95	188.3	350448.0
2022-06-08 18:00:00	IWM	ETF	188.2	188.35	188.08	188.34	17684.0
2022-06-08 19:00:00	IWM	ETF	188.38	188.44	188.19	188.31	27499.0
2022-06-08 04:00:00	DIA	ETF	330.68	330.68	330.56	330.56	3100.0
2022-06-08 05:00:00	DIA	ETF	330.8	330.83	330.8	330.83	440.0

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

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