PREVIEW / etf_1hour / 2022-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-29.parquet
  size:    462 KB
  rows:    16,622

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-04-29 04:00:00	SPY	ETF	425.51	426.48	425.47	425.56	26542.0
2022-04-29 05:00:00	SPY	ETF	425.3	425.47	424.34	424.34	81752.0
2022-04-29 06:00:00	SPY	ETF	424.6	425.1	423.5	423.5	121030.0
2022-04-29 07:00:00	SPY	ETF	423.78	424.21	422.98	423.36	216695.0
2022-04-29 08:00:00	SPY	ETF	423.76	427.0	423.02	423.56	661022.0
2022-04-29 09:00:00	SPY	ETF	423.53	425.87	422.35	425.71	8201985.0
2022-04-29 10:00:00	SPY	ETF	425.71	425.86	419.93	420.76	11664328.0
2022-04-29 11:00:00	SPY	ETF	420.73	422.13	419.6	420.45	9085433.0
2022-04-29 12:00:00	SPY	ETF	420.45	420.56	417.21	417.679	8948361.0
2022-04-29 13:00:00	SPY	ETF	417.66	419.78	417.49	417.66	7932676.0
2022-04-29 14:00:00	SPY	ETF	417.665	418.06	414.83	415.66	10818457.0
2022-04-29 15:00:00	SPY	ETF	415.67	415.74	411.21	412.05	40446973.0
2022-04-29 16:00:00	SPY	ETF	412.08	413.57	411.94	413.08	10915792.0
2022-04-29 17:00:00	SPY	ETF	412.96	413.55	412.96	413.45	221893.0
2022-04-29 18:00:00	SPY	ETF	413.45	413.49	413.02	413.45	41117.0
2022-04-29 19:00:00	SPY	ETF	413.45	413.55	412.0	413.35	250763.0
2022-04-29 04:00:00	QQQ	ETF	324.51	326.13	324.51	325.16	95629.0
2022-04-29 05:00:00	QQQ	ETF	325.12	325.35	324.09	324.29	138263.0
2022-04-29 06:00:00	QQQ	ETF	324.52	324.9	323.62	323.64	132714.0
2022-04-29 07:00:00	QQQ	ETF	323.87	324.18	322.8	323.18	269616.0
2022-04-29 08:00:00	QQQ	ETF	323.9901	326.5	322.8296	323.57	877337.0
2022-04-29 09:00:00	QQQ	ETF	323.6	327.225	322.21	326.99	10274578.0
2022-04-29 10:00:00	QQQ	ETF	326.98	327.15	320.7601	321.79	11020063.0
2022-04-29 11:00:00	QQQ	ETF	321.8	322.9	320.4757	320.9	7462511.0
2022-04-29 12:00:00	QQQ	ETF	320.9	321.085	318.13	318.52	6255590.0
2022-04-29 13:00:00	QQQ	ETF	318.48	320.05	317.97	318.06	7138295.0
2022-04-29 14:00:00	QQQ	ETF	318.06	318.48	315.63	316.43	8389912.0
2022-04-29 15:00:00	QQQ	ETF	316.44	316.68	312.6	313.24	19398987.0
2022-04-29 16:00:00	QQQ	ETF	313.24	315.3	313.07	314.06	3299346.0
2022-04-29 17:00:00	QQQ	ETF	314.02	314.44	313.25	314.25	423386.0
2022-04-29 18:00:00	QQQ	ETF	314.3	314.36	313.98	314.32	46074.0
2022-04-29 19:00:00	QQQ	ETF	314.3	314.59	313.25	314.25	71876.0
2022-04-29 04:00:00	IWM	ETF	190.5	190.86	190.37	190.37	7064.0
2022-04-29 05:00:00	IWM	ETF	190.12	190.27	189.92	190.07	20053.0
2022-04-29 06:00:00	IWM	ETF	190.29	190.29	189.46	189.46	36479.0
2022-04-29 07:00:00	IWM	ETF	189.69	189.78	189.21	189.38	20872.0
2022-04-29 08:00:00	IWM	ETF	189.6301	190.0696	189.18	189.57	149216.0
2022-04-29 09:00:00	IWM	ETF	189.61	191.73	188.95	191.6	3629637.0
2022-04-29 10:00:00	IWM	ETF	191.59	191.73	188.59	189.18	3983186.0
2022-04-29 11:00:00	IWM	ETF	189.17	190.38	188.64	189.6	2809943.0
2022-04-29 12:00:00	IWM	ETF	189.6	189.65	187.37	187.5927	2403687.0
2022-04-29 13:00:00	IWM	ETF	187.57	188.87	187.15	187.26	2527993.0
2022-04-29 14:00:00	IWM	ETF	187.25	187.67	185.77	186.175	3434929.0
2022-04-29 15:00:00	IWM	ETF	186.18	186.19	184.51	185.12	10233674.0
2022-04-29 16:00:00	IWM	ETF	185.1	185.66	184.93	185.34	2303164.0
2022-04-29 17:00:00	IWM	ETF	185.26	185.55	184.95	185.33	192279.0
2022-04-29 18:00:00	IWM	ETF	185.33	185.4	185.24	185.27	11377.0
2022-04-29 19:00:00	IWM	ETF	185.36	185.49	184.95	185.4	36094.0
2022-04-29 04:00:00	DIA	ETF	338.94	339.3	338.93	338.93	1241.0
2022-04-29 05:00:00	DIA	ETF	338.34	338.34	337.82	337.82	300.0

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

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