PREVIEW / etf_1hour / 2021-08-10

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-10.parquet
  size:    413 KB
  rows:    14,305

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
2021-08-10 04:00:00	SPY	ETF	442.15	442.3	442.0	442.11	11454.0
2021-08-10 05:00:00	SPY	ETF	442.15	442.16	442.08	442.1	4750.0
2021-08-10 06:00:00	SPY	ETF	442.09	442.19	442.0	442.16	12659.0
2021-08-10 07:00:00	SPY	ETF	442.05	442.28	442.05	442.19	43069.0
2021-08-10 08:00:00	SPY	ETF	442.2399	442.511	441.63	442.25	85593.0
2021-08-10 09:00:00	SPY	ETF	442.28	443.03	442.23	442.8924	3355775.0
2021-08-10 10:00:00	SPY	ETF	442.895	443.44	441.88	442.33	8949009.0
2021-08-10 11:00:00	SPY	ETF	442.335	443.045	441.92	443.04	4033402.0
2021-08-10 12:00:00	SPY	ETF	443.03	443.31	442.76	442.895	2402747.0
2021-08-10 13:00:00	SPY	ETF	442.895	443.0	442.5021	442.965	2238600.0
2021-08-10 14:00:00	SPY	ETF	442.96	443.07	442.4	442.84	3591190.0
2021-08-10 15:00:00	SPY	ETF	442.85	442.89	442.21	442.66	6673962.0
2021-08-10 16:00:00	SPY	ETF	442.67	442.68	442.28	442.57	2958843.0
2021-08-10 17:00:00	SPY	ETF	442.5	442.59	442.44	442.53	29065.0
2021-08-10 18:00:00	SPY	ETF	442.53	442.59	442.36	442.4	51992.0
2021-08-10 19:00:00	SPY	ETF	442.39	442.48	442.31	442.4	24031.0
2021-08-10 04:00:00	QQQ	ETF	369.0	369.32	368.84	369.0	22549.0
2021-08-10 05:00:00	QQQ	ETF	368.99	369.3	368.99	369.3	12174.0
2021-08-10 06:00:00	QQQ	ETF	369.22	369.25	369.05	369.17	22953.0
2021-08-10 07:00:00	QQQ	ETF	369.13	369.4	369.1	369.26	71267.0
2021-08-10 08:00:00	QQQ	ETF	369.17	369.37	368.88	369.07	105854.0
2021-08-10 09:00:00	QQQ	ETF	369.101	369.46	368.588	369.32	2730306.0
2021-08-10 10:00:00	QQQ	ETF	369.32	369.56	365.91	366.615	7307314.0
2021-08-10 11:00:00	QQQ	ETF	366.61	367.15	365.62	366.86	4833287.0
2021-08-10 12:00:00	QQQ	ETF	366.86	367.832	366.84	367.075	2604395.0
2021-08-10 13:00:00	QQQ	ETF	367.08	367.389	366.64	367.06	1942319.0
2021-08-10 14:00:00	QQQ	ETF	367.05	367.13	366.24	367.01	2497402.0
2021-08-10 15:00:00	QQQ	ETF	367.02	367.12	366.34	366.85	4061132.0
2021-08-10 16:00:00	QQQ	ETF	366.85	366.87	366.64	366.85	1344715.0
2021-08-10 17:00:00	QQQ	ETF	366.81	366.9	366.72	366.89	19936.0
2021-08-10 18:00:00	QQQ	ETF	366.84	366.84	366.57	366.59	43127.0
2021-08-10 19:00:00	QQQ	ETF	366.63	366.66	366.53	366.59	50159.0
2021-08-10 04:00:00	IWM	ETF	222.21	222.35	222.11	222.35	2150.0
2021-08-10 05:00:00	IWM	ETF	222.1	222.11	221.89	221.89	3994.0
2021-08-10 06:00:00	IWM	ETF	221.83	222.1	221.83	221.9	2137.0
2021-08-10 07:00:00	IWM	ETF	221.94	222.43	221.93	222.28	31863.0
2021-08-10 08:00:00	IWM	ETF	222.13	222.37	222.08	222.32	21707.0
2021-08-10 09:00:00	IWM	ETF	222.29	223.02	221.19	221.81	3011321.0
2021-08-10 10:00:00	IWM	ETF	221.81	222.68	221.5036	222.35	3843920.0
2021-08-10 11:00:00	IWM	ETF	222.35	223.07	222.01	222.78	2530142.0
2021-08-10 12:00:00	IWM	ETF	222.78	222.91	222.515	222.83	1885039.0
2021-08-10 13:00:00	IWM	ETF	222.825	223.22	222.55	222.74	1978032.0
2021-08-10 14:00:00	IWM	ETF	222.725	222.89	222.29	222.72	1310318.0
2021-08-10 15:00:00	IWM	ETF	222.71	222.785	222.33	222.6	3162422.0
2021-08-10 16:00:00	IWM	ETF	222.6	222.67	222.36	222.64	1625735.0
2021-08-10 17:00:00	IWM	ETF	222.8	222.8	222.62	222.66	9495.0
2021-08-10 18:00:00	IWM	ETF	222.6	222.65	222.5	222.54	94185.0
2021-08-10 19:00:00	IWM	ETF	222.5	222.61	222.5	222.58	13880.0
2021-08-10 04:00:00	DIA	ETF	351.02	351.02	350.89	350.89	1300.0
2021-08-10 05:00:00	DIA	ETF	350.93	350.93	350.89	350.89	600.0

> showing 50 of 14,305 rows — these rows as CSV

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