PREVIEW / etf_1hour / 2021-08-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-08-11.parquet
  size:    418 KB
  rows:    14,420

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-11 04:00:00	SPY	ETF	441.95	442.16	441.95	442.06	11404.0
2021-08-11 05:00:00	SPY	ETF	442.12	442.12	441.83	442.1	11481.0
2021-08-11 06:00:00	SPY	ETF	442.11	442.38	442.06	442.3	27572.0
2021-08-11 07:00:00	SPY	ETF	442.4	442.41	442.03	442.15	48390.0
2021-08-11 08:00:00	SPY	ETF	442.2801	443.5	442.02	443.28	819428.0
2021-08-11 09:00:00	SPY	ETF	443.33	443.94	443.24	443.56	4591151.0
2021-08-11 10:00:00	SPY	ETF	443.55	443.8	443.27	443.358	4932630.0
2021-08-11 11:00:00	SPY	ETF	443.36	443.38	442.62	442.78	4846529.0
2021-08-11 12:00:00	SPY	ETF	442.78	443.26	442.74	443.2499	2514576.0
2021-08-11 13:00:00	SPY	ETF	443.245	443.49	443.15	443.3712	3020831.0
2021-08-11 14:00:00	SPY	ETF	443.375	443.5	443.12	443.39	2621874.0
2021-08-11 15:00:00	SPY	ETF	443.399	443.79	443.38	443.74	7874961.0
2021-08-11 16:00:00	SPY	ETF	443.74	443.8	443.505	443.75	2604343.0
2021-08-11 17:00:00	SPY	ETF	443.8	443.8	443.6	443.69	42507.0
2021-08-11 18:00:00	SPY	ETF	443.66	443.74	443.59	443.59	33753.0
2021-08-11 19:00:00	SPY	ETF	443.59	443.67	443.55	443.57	19889.0
2021-08-11 04:00:00	QQQ	ETF	366.4	366.4	365.79	365.84	58569.0
2021-08-11 05:00:00	QQQ	ETF	365.85	365.91	365.32	365.6	23033.0
2021-08-11 06:00:00	QQQ	ETF	365.5	366.25	365.4	366.25	38053.0
2021-08-11 07:00:00	QQQ	ETF	366.27	366.35	365.96	366.11	63409.0
2021-08-11 08:00:00	QQQ	ETF	366.12	368.44	365.34	367.94	1693039.0
2021-08-11 09:00:00	QQQ	ETF	367.98	368.65	366.89	367.135	4880146.0
2021-08-11 10:00:00	QQQ	ETF	367.12	367.7195	365.94	365.95	4585098.0
2021-08-11 11:00:00	QQQ	ETF	365.98	366.0502	364.84	365.305	4739241.0
2021-08-11 12:00:00	QQQ	ETF	365.29	366.07	365.16	365.79	1894477.0
2021-08-11 13:00:00	QQQ	ETF	365.82	366.49	365.4706	365.76	2175462.0
2021-08-11 14:00:00	QQQ	ETF	365.75	366.225	365.565	366.04	1484317.0
2021-08-11 15:00:00	QQQ	ETF	366.04	366.4	365.87	366.23	4072840.0
2021-08-11 16:00:00	QQQ	ETF	366.23	366.23	365.7	365.92	1805998.0
2021-08-11 17:00:00	QQQ	ETF	365.95	365.95	365.73	365.81	23707.0
2021-08-11 18:00:00	QQQ	ETF	365.81	365.81	365.64	365.67	43253.0
2021-08-11 19:00:00	QQQ	ETF	365.66	365.7	365.47	365.57	37151.0
2021-08-11 04:00:00	IWM	ETF	222.17	222.39	222.17	222.37	1800.0
2021-08-11 05:00:00	IWM	ETF	222.3	222.41	222.2	222.41	3280.0
2021-08-11 06:00:00	IWM	ETF	222.35	222.49	222.29	222.3	2858.0
2021-08-11 07:00:00	IWM	ETF	222.33	222.36	222.11	222.23	33506.0
2021-08-11 08:00:00	IWM	ETF	222.31	222.99	222.09	222.75	170898.0
2021-08-11 09:00:00	IWM	ETF	222.81	223.43	221.13	222.03	3839540.0
2021-08-11 10:00:00	IWM	ETF	222.02	222.29	221.31	221.565	3329409.0
2021-08-11 11:00:00	IWM	ETF	221.58	221.66	220.47	220.85	4002590.0
2021-08-11 12:00:00	IWM	ETF	220.84	221.93	220.83	221.79	1913953.0
2021-08-11 13:00:00	IWM	ETF	221.8	222.39	221.69	222.215	2315004.0
2021-08-11 14:00:00	IWM	ETF	222.22	223.13	222.13	223.03	1974306.0
2021-08-11 15:00:00	IWM	ETF	223.02	223.73	222.925	223.68	3355266.0
2021-08-11 16:00:00	IWM	ETF	223.675	223.81	223.57	223.78	811590.0
2021-08-11 17:00:00	IWM	ETF	223.83	223.83	223.64	223.67	10721.0
2021-08-11 18:00:00	IWM	ETF	223.7	223.84	223.66	223.75	22351.0
2021-08-11 19:00:00	IWM	ETF	223.75	223.8	223.7	223.7	6931.0
2021-08-11 04:00:00	DIA	ETF	352.73	352.73	352.73	352.73	149.0
2021-08-11 05:00:00	DIA	ETF	352.94	352.95	352.94	352.94	400.0

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

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