PREVIEW / etf_1hour / 2022-03-30

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-30.parquet
  size:    459 KB
  rows:    16,362

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-03-30 04:00:00	SPY	ETF	460.36	460.42	459.45	459.62	34941.0
2022-03-30 05:00:00	SPY	ETF	459.84	460.57	459.79	460.1	23984.0
2022-03-30 06:00:00	SPY	ETF	460.25	460.37	459.48	460.22	49783.0
2022-03-30 07:00:00	SPY	ETF	460.29	460.66	460.2	460.43	90314.0
2022-03-30 08:00:00	SPY	ETF	460.44	461.896	459.2	460.0	478633.0
2022-03-30 09:00:00	SPY	ETF	460.06	461.0	459.5922	460.9	5067707.0
2022-03-30 10:00:00	SPY	ETF	460.9	461.195	459.76	459.8401	6564468.0
2022-03-30 11:00:00	SPY	ETF	459.86	460.05	458.64	459.67	7409293.0
2022-03-30 12:00:00	SPY	ETF	459.65	460.12	459.075	459.9	4300014.0
2022-03-30 13:00:00	SPY	ETF	459.89	459.94	458.515	458.64	5378548.0
2022-03-30 14:00:00	SPY	ETF	458.6499	459.34	457.78	457.875	6587570.0
2022-03-30 15:00:00	SPY	ETF	457.89	458.73	456.465	458.72	15969340.0
2022-03-30 16:00:00	SPY	ETF	458.71	459.31	457.81	459.14	4353024.0
2022-03-30 17:00:00	SPY	ETF	459.14	459.27	458.7	459.0	116812.0
2022-03-30 18:00:00	SPY	ETF	459.0	459.17	458.87	459.03	111301.0
2022-03-30 19:00:00	SPY	ETF	459.09	459.15	458.81	458.88	57313.0
2022-03-30 04:00:00	QQQ	ETF	370.2	370.2	368.92	369.21	76731.0
2022-03-30 05:00:00	QQQ	ETF	369.35	369.65	369.23	369.61	26025.0
2022-03-30 06:00:00	QQQ	ETF	369.67	369.67	368.77	369.33	92896.0
2022-03-30 07:00:00	QQQ	ETF	369.41	370.03	369.33	369.81	148732.0
2022-03-30 08:00:00	QQQ	ETF	369.58	371.1	368.41	369.1	713245.0
2022-03-30 09:00:00	QQQ	ETF	369.13	370.3698	368.69	369.83	6092595.0
2022-03-30 10:00:00	QQQ	ETF	369.85	370.98	368.95	369.09	7387943.0
2022-03-30 11:00:00	QQQ	ETF	369.1	369.23	367.61	369.04	7281160.0
2022-03-30 12:00:00	QQQ	ETF	369.03	370.07	368.42	369.985	4610352.0
2022-03-30 13:00:00	QQQ	ETF	369.95	370.025	368.26	368.405	4654136.0
2022-03-30 14:00:00	QQQ	ETF	368.39	369.049	367.125	367.26	5166683.0
2022-03-30 15:00:00	QQQ	ETF	367.29	367.34	365.57	367.195	11442023.0
2022-03-30 16:00:00	QQQ	ETF	367.19	368.03	367.0689	367.9	2069360.0
2022-03-30 17:00:00	QQQ	ETF	367.87	367.97	367.09	367.87	944836.0
2022-03-30 18:00:00	QQQ	ETF	367.86	367.94	367.68	367.92	51997.0
2022-03-30 19:00:00	QQQ	ETF	367.92	368.04	367.7	367.82	78839.0
2022-03-30 04:00:00	IWM	ETF	210.99	210.99	210.59	210.83	15585.0
2022-03-30 05:00:00	IWM	ETF	210.8	211.1	210.8	210.98	5876.0
2022-03-30 06:00:00	IWM	ETF	210.59	211.17	210.59	211.12	8509.0
2022-03-30 07:00:00	IWM	ETF	211.174	211.27	211.05	211.11	19210.0
2022-03-30 08:00:00	IWM	ETF	211.0801	211.19	210.56	210.98	131141.0
2022-03-30 09:00:00	IWM	ETF	210.95	211.61	210.565	211.61	3115513.0
2022-03-30 10:00:00	IWM	ETF	211.61	211.74	210.61	210.64	2939045.0
2022-03-30 11:00:00	IWM	ETF	210.65	211.07	210.13	210.31	1920780.0
2022-03-30 12:00:00	IWM	ETF	210.3	210.43	209.9	210.23	1040381.0
2022-03-30 13:00:00	IWM	ETF	210.22	210.25	208.94	209.18	1759811.0
2022-03-30 14:00:00	IWM	ETF	209.19	209.45	207.85	207.95	1970953.0
2022-03-30 15:00:00	IWM	ETF	207.97	207.97	206.61	207.55	4650044.0
2022-03-30 16:00:00	IWM	ETF	207.56	207.95	207.46	207.62	917876.0
2022-03-30 17:00:00	IWM	ETF	207.76	207.87	207.46	207.58	141609.0
2022-03-30 18:00:00	IWM	ETF	207.63	207.69	207.54	207.63	23412.0
2022-03-30 19:00:00	IWM	ETF	207.63	207.67	207.39	207.5	35991.0
2022-03-30 04:00:00	DIA	ETF	351.8	351.8	351.45	351.8	572.0
2022-03-30 05:00:00	DIA	ETF	351.82	351.99	351.82	351.99	1868.0

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

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