PREVIEW / etf_1hour / 2022-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-06-06.parquet
  size:    453 KB
  rows:    16,194

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-06 04:00:00	SPY	ETF	414.35	415.45	412.8	415.33	62390.0
2022-06-06 05:00:00	SPY	ETF	415.37	415.37	414.26	414.42	29480.0
2022-06-06 06:00:00	SPY	ETF	414.57	415.04	414.56	414.95	49780.0
2022-06-06 07:00:00	SPY	ETF	414.97	415.09	414.27	415.08	153388.0
2022-06-06 08:00:00	SPY	ETF	415.07	415.65	412.2	415.01	521015.0
2022-06-06 09:00:00	SPY	ETF	415.02	415.495	413.66	415.17	5061629.0
2022-06-06 10:00:00	SPY	ETF	415.17	416.609	415.02	416.08	7029803.0
2022-06-06 11:00:00	SPY	ETF	416.09	416.5	412.77	413.73	6604581.0
2022-06-06 12:00:00	SPY	ETF	413.73	413.79	410.84	412.42	5260284.0
2022-06-06 13:00:00	SPY	ETF	412.39	413.82	411.32	413.78	5392245.0
2022-06-06 14:00:00	SPY	ETF	413.78	413.83	410.84	411.83	5811837.0
2022-06-06 15:00:00	SPY	ETF	411.84	412.4	410.5523	411.76	9078451.0
2022-06-06 16:00:00	SPY	ETF	411.75	412.09	411.48	411.86	1822397.0
2022-06-06 17:00:00	SPY	ETF	411.86	412.1	411.7	411.99	77005.0
2022-06-06 18:00:00	SPY	ETF	411.95	412.17	411.33	411.39	72611.0
2022-06-06 19:00:00	SPY	ETF	411.46	412.16	411.4	411.9	41068.0
2022-06-06 04:00:00	QQQ	ETF	309.97	310.93	307.12	310.85	123473.0
2022-06-06 05:00:00	QQQ	ETF	310.84	310.84	309.82	309.98	112222.0
2022-06-06 06:00:00	QQQ	ETF	309.97	310.78	309.97	310.59	77043.0
2022-06-06 07:00:00	QQQ	ETF	310.59	310.72	309.91	310.6	388794.0
2022-06-06 08:00:00	QQQ	ETF	310.28	311.27	306.429	310.67	621540.0
2022-06-06 09:00:00	QQQ	ETF	310.68	311.79	309.04	310.86	6125748.0
2022-06-06 10:00:00	QQQ	ETF	310.855	312.35	310.81	311.61	6165700.0
2022-06-06 11:00:00	QQQ	ETF	311.62	311.9284	307.93	308.8899	5931589.0
2022-06-06 12:00:00	QQQ	ETF	308.85	308.91	305.62	307.36	4606633.0
2022-06-06 13:00:00	QQQ	ETF	307.36	309.1607	306.17	309.155	3558148.0
2022-06-06 14:00:00	QQQ	ETF	309.15	309.25	306.23	307.0001	3873863.0
2022-06-06 15:00:00	QQQ	ETF	306.99	307.67	305.82	307.25	5699338.0
2022-06-06 16:00:00	QQQ	ETF	307.25	307.48	306.75	307.4	1273579.0
2022-06-06 17:00:00	QQQ	ETF	307.4	307.48	307.11	307.46	41733.0
2022-06-06 18:00:00	QQQ	ETF	307.38	307.58	306.73	306.8	52754.0
2022-06-06 19:00:00	QQQ	ETF	306.91	307.55	306.84	307.36	46837.0
2022-06-06 04:00:00	IWM	ETF	189.0	189.59	189.0	189.57	18962.0
2022-06-06 05:00:00	IWM	ETF	189.53	189.53	189.06	189.06	11253.0
2022-06-06 06:00:00	IWM	ETF	189.18	189.33	189.17	189.26	24694.0
2022-06-06 07:00:00	IWM	ETF	189.25	189.33	189.03	189.33	63546.0
2022-06-06 08:00:00	IWM	ETF	189.23	189.55	189.02	189.26	179332.0
2022-06-06 09:00:00	IWM	ETF	189.27	189.48	187.1	187.82	3287656.0
2022-06-06 10:00:00	IWM	ETF	187.83	188.74	187.75	188.31	2434643.0
2022-06-06 11:00:00	IWM	ETF	188.34	188.72	187.38	188.27	1801433.0
2022-06-06 12:00:00	IWM	ETF	188.26	188.29	186.83	187.93	1451036.0
2022-06-06 13:00:00	IWM	ETF	187.92	188.7099	187.26	188.705	1308377.0
2022-06-06 14:00:00	IWM	ETF	188.71	188.71	187.13	187.65	1403757.0
2022-06-06 15:00:00	IWM	ETF	187.66	188.0	187.17	187.87	3171409.0
2022-06-06 16:00:00	IWM	ETF	187.87	188.04	187.69	187.94	2942819.0
2022-06-06 17:00:00	IWM	ETF	187.87	188.04	187.87	188.0	5151.0
2022-06-06 18:00:00	IWM	ETF	188.0	188.07	187.61	187.68	6184.0
2022-06-06 19:00:00	IWM	ETF	187.75	188.06	187.73	187.99	19895.0
2022-06-06 04:00:00	DIA	ETF	331.95	332.05	331.92	332.05	2535.0
2022-06-06 05:00:00	DIA	ETF	332.08	332.08	331.85	331.85	468.0

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

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