PREVIEW / etf_1hour / 2022-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-03.parquet
  size:    438 KB
  rows:    15,792

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-03 04:00:00	SPY	ETF	416.78	416.98	415.87	416.0	38998.0
2022-06-03 05:00:00	SPY	ETF	416.2	416.28	415.54	416.0	20263.0
2022-06-03 06:00:00	SPY	ETF	415.98	416.09	414.94	415.1	104449.0
2022-06-03 07:00:00	SPY	ETF	415.11	415.28	413.82	414.0	362912.0
2022-06-03 08:00:00	SPY	ETF	415.1799	418.2	412.95	413.46	1617224.0
2022-06-03 09:00:00	SPY	ETF	413.48	413.98	411.36	413.114	6944845.0
2022-06-03 10:00:00	SPY	ETF	413.17	414.04	410.72	411.3	7687695.0
2022-06-03 11:00:00	SPY	ETF	411.26	411.3599	409.51	410.46	6538823.0
2022-06-03 12:00:00	SPY	ETF	410.46	412.26	409.73	412.16	5030307.0
2022-06-03 13:00:00	SPY	ETF	412.17	413.26	410.39	410.7699	5764045.0
2022-06-03 14:00:00	SPY	ETF	410.77	412.12	410.3	411.57	5365920.0
2022-06-03 15:00:00	SPY	ETF	411.58	411.79	409.81	410.59	13876415.0
2022-06-03 16:00:00	SPY	ETF	410.59	411.14	410.16	410.68	3367222.0
2022-06-03 17:00:00	SPY	ETF	410.77	410.79	410.4	410.41	107048.0
2022-06-03 18:00:00	SPY	ETF	410.48	410.55	410.3	410.33	35345.0
2022-06-03 19:00:00	SPY	ETF	410.31	410.5	410.26	410.3	13791.0
2022-06-03 04:00:00	QQQ	ETF	313.41	313.41	312.37	313.1	154996.0
2022-06-03 05:00:00	QQQ	ETF	313.05	313.13	312.23	312.68	108200.0
2022-06-03 06:00:00	QQQ	ETF	312.81	312.81	311.28	311.45	225017.0
2022-06-03 07:00:00	QQQ	ETF	311.49	311.69	310.43	310.5	509717.0
2022-06-03 08:00:00	QQQ	ETF	310.49	315.07	309.38	310.03	2006766.0
2022-06-03 09:00:00	QQQ	ETF	310.07	310.66	307.5	309.58	7765967.0
2022-06-03 10:00:00	QQQ	ETF	309.57	310.47	306.4203	306.49	8069555.0
2022-06-03 11:00:00	QQQ	ETF	306.485	306.65	304.92	306.01	6922065.0
2022-06-03 12:00:00	QQQ	ETF	305.92	307.59	305.47	307.42	3509674.0
2022-06-03 13:00:00	QQQ	ETF	307.44	308.39	305.7	306.09	4383694.0
2022-06-03 14:00:00	QQQ	ETF	306.06	307.35	305.78	306.7063	2892059.0
2022-06-03 15:00:00	QQQ	ETF	306.74	306.94	305.12	306.1	8275762.0
2022-06-03 16:00:00	QQQ	ETF	306.1	306.41	305.75	306.03	1735530.0
2022-06-03 17:00:00	QQQ	ETF	306.08	306.2	306.0	306.06	402902.0
2022-06-03 18:00:00	QQQ	ETF	306.05	306.1	305.84	305.84	28324.0
2022-06-03 19:00:00	QQQ	ETF	305.85	306.0	305.7	305.79	23237.0
2022-06-03 04:00:00	IWM	ETF	187.91	188.32	187.87	188.02	19766.0
2022-06-03 05:00:00	IWM	ETF	188.12	188.18	187.8	188.05	11005.0
2022-06-03 06:00:00	IWM	ETF	188.1	188.14	187.66	187.75	82238.0
2022-06-03 07:00:00	IWM	ETF	187.87	188.0	187.4	187.5	77132.0
2022-06-03 08:00:00	IWM	ETF	187.9099	188.59	187.22	187.55	173610.0
2022-06-03 09:00:00	IWM	ETF	187.56	187.71	186.14	187.62	2805882.0
2022-06-03 10:00:00	IWM	ETF	187.62	187.96	186.63	186.85	2243625.0
2022-06-03 11:00:00	IWM	ETF	186.84	186.88	185.79	186.29	1775961.0
2022-06-03 12:00:00	IWM	ETF	186.28	187.27	186.05	187.26	1034228.0
2022-06-03 13:00:00	IWM	ETF	187.25	187.71	186.515	186.7001	1304774.0
2022-06-03 14:00:00	IWM	ETF	186.7	187.48	186.51	187.12	1023811.0
2022-06-03 15:00:00	IWM	ETF	187.115	187.415	186.5	187.1	2973977.0
2022-06-03 16:00:00	IWM	ETF	187.06	187.47	187.0	187.23	1209753.0
2022-06-03 17:00:00	IWM	ETF	187.33	187.33	187.12	187.12	5925.0
2022-06-03 18:00:00	IWM	ETF	187.18	187.2	187.1	187.11	9480.0
2022-06-03 19:00:00	IWM	ETF	187.12	187.26	187.1	187.1	7281.0
2022-06-03 04:00:00	DIA	ETF	332.19	332.21	332.14	332.21	1580.0
2022-06-03 06:00:00	DIA	ETF	331.99	332.03	331.61	331.66	4301.0

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

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