PREVIEW / etf_1hour / 2022-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-05-05.parquet
  size:    464 KB
  rows:    16,924

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-05-05 04:00:00	SPY	ETF	427.16	427.24	425.48	425.9	90219.0
2022-05-05 05:00:00	SPY	ETF	425.88	426.5	425.67	426.38	60680.0
2022-05-05 06:00:00	SPY	ETF	426.3	426.86	425.79	425.79	118789.0
2022-05-05 07:00:00	SPY	ETF	425.83	426.98	425.79	426.2	344294.0
2022-05-05 08:00:00	SPY	ETF	426.06	429.09	425.5196	425.8	630429.0
2022-05-05 09:00:00	SPY	ETF	425.83	425.83	421.11	421.565	13749271.0
2022-05-05 10:00:00	SPY	ETF	421.59	421.63	415.22	416.77	23133230.0
2022-05-05 11:00:00	SPY	ETF	416.76	417.135	412.28	412.335	18898229.0
2022-05-05 12:00:00	SPY	ETF	412.33	414.9201	411.01	414.51	16647506.0
2022-05-05 13:00:00	SPY	ETF	414.5263	416.39	412.83	413.45	10434498.0
2022-05-05 14:00:00	SPY	ETF	413.46	415.18	411.58	412.77	11894498.0
2022-05-05 15:00:00	SPY	ETF	412.77	414.3199	409.44	413.92	37438495.0
2022-05-05 16:00:00	SPY	ETF	413.89	415.17	413.51	414.47	6939629.0
2022-05-05 17:00:00	SPY	ETF	414.69	414.69	413.8	413.8	159231.0
2022-05-05 18:00:00	SPY	ETF	414.3	414.3	413.14	413.93	343550.0
2022-05-05 19:00:00	SPY	ETF	413.8	414.32	413.61	414.23	196040.0
2022-05-05 04:00:00	QQQ	ETF	327.5	327.78	326.02	326.55	221779.0
2022-05-05 05:00:00	QQQ	ETF	326.68	327.5	326.58	327.12	77640.0
2022-05-05 06:00:00	QQQ	ETF	327.04	327.7	326.84	326.84	103454.0
2022-05-05 07:00:00	QQQ	ETF	326.85	327.77	326.71	327.08	392115.0
2022-05-05 08:00:00	QQQ	ETF	326.981	329.5	326.44	326.55	560277.0
2022-05-05 09:00:00	QQQ	ETF	326.55	326.55	320.61	321.02	13589911.0
2022-05-05 10:00:00	QQQ	ETF	321.06	321.1	315.04	316.4	22884638.0
2022-05-05 11:00:00	QQQ	ETF	316.4	316.54	312.91	312.98	15141676.0
2022-05-05 12:00:00	QQQ	ETF	312.96	315.29	311.89	314.5181	11918441.0
2022-05-05 13:00:00	QQQ	ETF	314.48	315.985	312.36	312.805	11199539.0
2022-05-05 14:00:00	QQQ	ETF	312.77	314.3	311.5156	312.43	10394121.0
2022-05-05 15:00:00	QQQ	ETF	312.41	313.87	309.62	313.39	29735928.0
2022-05-05 16:00:00	QQQ	ETF	313.41	314.87	313.0	314.3596	4715995.0
2022-05-05 17:00:00	QQQ	ETF	314.25	314.49	313.84	314.02	191093.0
2022-05-05 18:00:00	QQQ	ETF	313.91	314.1	313.13	313.6	282078.0
2022-05-05 19:00:00	QQQ	ETF	313.44	314.07	313.34	314.01	240500.0
2022-05-05 04:00:00	IWM	ETF	192.7	192.85	192.18	192.28	11778.0
2022-05-05 05:00:00	IWM	ETF	192.31	192.64	192.25	192.64	20926.0
2022-05-05 06:00:00	IWM	ETF	192.54	192.78	192.42	192.46	12105.0
2022-05-05 07:00:00	IWM	ETF	192.4	192.77	192.24	192.38	63363.0
2022-05-05 08:00:00	IWM	ETF	192.2604	192.6696	191.99	192.18	189449.0
2022-05-05 09:00:00	IWM	ETF	192.12	192.13	189.94	190.23	3377156.0
2022-05-05 10:00:00	IWM	ETF	190.22	190.24	186.93	187.3485	5483947.0
2022-05-05 11:00:00	IWM	ETF	187.345	187.42	184.48	184.62	4364773.0
2022-05-05 12:00:00	IWM	ETF	184.6	185.79	183.9938	185.7	3000565.0
2022-05-05 13:00:00	IWM	ETF	185.74	186.71	184.74	184.98	2502057.0
2022-05-05 14:00:00	IWM	ETF	184.97	185.9	184.08	184.73	2939118.0
2022-05-05 15:00:00	IWM	ETF	184.74	185.94	183.38	185.72	7347646.0
2022-05-05 16:00:00	IWM	ETF	185.67	186.35	185.4	186.04	1627348.0
2022-05-05 17:00:00	IWM	ETF	185.9	186.35	185.67	185.95	260161.0
2022-05-05 18:00:00	IWM	ETF	185.9	185.97	185.5	185.84	47483.0
2022-05-05 19:00:00	IWM	ETF	185.79	186.01	185.68	185.95	44045.0
2022-05-05 04:00:00	DIA	ETF	339.72	339.72	338.75	338.78	1200.0
2022-05-05 05:00:00	DIA	ETF	339.15	339.15	338.78	338.78	825.0

> showing 50 of 16,924 rows — these rows as CSV

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