PREVIEW / etf_1hour / 2022-08-15

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-15.parquet
  size:    455 KB
  rows:    16,392

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-08-15 04:00:00	SPY	ETF	425.0	425.59	424.96	425.13	41750.0
2022-08-15 05:00:00	SPY	ETF	425.1	425.21	424.6	425.03	47392.0
2022-08-15 06:00:00	SPY	ETF	425.07	425.24	424.58	425.19	84768.0
2022-08-15 07:00:00	SPY	ETF	425.13	425.3	424.4	424.62	201041.0
2022-08-15 08:00:00	SPY	ETF	425.19	426.38	423.7	423.92	953301.0
2022-08-15 09:00:00	SPY	ETF	423.91	427.34	423.87	426.93	5212179.0
2022-08-15 10:00:00	SPY	ETF	426.945	426.96	425.56	425.76	5424653.0
2022-08-15 11:00:00	SPY	ETF	425.78	428.25	425.44	427.99	5205846.0
2022-08-15 12:00:00	SPY	ETF	428.02	428.95	427.72	428.8	3861101.0
2022-08-15 13:00:00	SPY	ETF	428.8	429.03	428.1	428.55	3096743.0
2022-08-15 14:00:00	SPY	ETF	428.54	429.029	428.1	428.95	3277245.0
2022-08-15 15:00:00	SPY	ETF	428.95	429.41	428.6	428.86	10131419.0
2022-08-15 16:00:00	SPY	ETF	428.86	429.021	428.34	428.46	2492848.0
2022-08-15 17:00:00	SPY	ETF	428.4	428.58	428.4	428.45	16595.0
2022-08-15 18:00:00	SPY	ETF	428.4	428.43	428.24	428.31	77931.0
2022-08-15 19:00:00	SPY	ETF	428.31	428.63	428.23	428.49	63884.0
2022-08-15 04:00:00	QQQ	ETF	329.75	329.75	328.83	328.98	31100.0
2022-08-15 05:00:00	QQQ	ETF	329.07	329.1	328.55	329.06	55331.0
2022-08-15 06:00:00	QQQ	ETF	329.14	329.75	328.99	329.74	100139.0
2022-08-15 07:00:00	QQQ	ETF	329.79	329.82	328.94	329.18	116721.0
2022-08-15 08:00:00	QQQ	ETF	329.76	330.637	328.64	328.7	353737.0
2022-08-15 09:00:00	QQQ	ETF	328.73	331.83	328.71	331.4166	4792731.0
2022-08-15 10:00:00	QQQ	ETF	331.46	331.46	329.52	329.961	4709047.0
2022-08-15 11:00:00	QQQ	ETF	329.97	332.485	329.57	332.33	3738715.0
2022-08-15 12:00:00	QQQ	ETF	332.35	332.6998	331.88	332.58	2630373.0
2022-08-15 13:00:00	QQQ	ETF	332.59	332.88	332.05	332.495	2090773.0
2022-08-15 14:00:00	QQQ	ETF	332.4901	333.02	332.0023	332.925	1836006.0
2022-08-15 15:00:00	QQQ	ETF	332.93	333.5652	332.78	333.1	4843715.0
2022-08-15 16:00:00	QQQ	ETF	333.09	333.1	332.6743	332.98	1042741.0
2022-08-15 17:00:00	QQQ	ETF	332.99	332.99	332.84	332.88	22450.0
2022-08-15 18:00:00	QQQ	ETF	332.87	332.88	332.64	332.72	40067.0
2022-08-15 19:00:00	QQQ	ETF	332.74	333.07	332.74	333.0	40245.0
2022-08-15 04:00:00	IWM	ETF	199.06	199.38	199.06	199.23	21848.0
2022-08-15 05:00:00	IWM	ETF	199.22	199.26	198.96	199.08	44442.0
2022-08-15 06:00:00	IWM	ETF	199.11	199.16	198.8	199.07	75880.0
2022-08-15 07:00:00	IWM	ETF	199.059	199.24	198.76	198.96	216504.0
2022-08-15 08:00:00	IWM	ETF	199.16	199.22	198.4	198.57	277608.0
2022-08-15 09:00:00	IWM	ETF	198.57	199.32	198.22	199.219	2362789.0
2022-08-15 10:00:00	IWM	ETF	199.22	199.38	198.53	198.89	1684407.0
2022-08-15 11:00:00	IWM	ETF	198.88	200.32	198.79	200.26	1367839.0
2022-08-15 12:00:00	IWM	ETF	200.255	200.63	200.01	200.345	1306991.0
2022-08-15 13:00:00	IWM	ETF	200.37	200.63	200.03	200.24	757629.0
2022-08-15 14:00:00	IWM	ETF	200.24	200.78	199.95	200.74	978648.0
2022-08-15 15:00:00	IWM	ETF	200.74	201.155	200.7	201.07	3199824.0
2022-08-15 16:00:00	IWM	ETF	201.07	201.1	200.68	200.93	1063355.0
2022-08-15 17:00:00	IWM	ETF	200.85	201.0	200.8	201.0	5899.0
2022-08-15 18:00:00	IWM	ETF	200.91	200.94	200.82	200.84	13329.0
2022-08-15 19:00:00	IWM	ETF	200.87	201.02	200.78	200.94	20921.0
2022-08-15 04:00:00	DIA	ETF	336.42	336.42	336.42	336.42	200.0
2022-08-15 06:00:00	DIA	ETF	336.48	336.48	336.0	336.02	4200.0

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

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