PREVIEW / etf_1hour / 2021-01-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-01-04.parquet
  size:    432 KB
  rows:    14,913

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-01-04 04:00:00	SPY	ETF	375.64	376.74	375.64	376.48	90959.0
2021-01-04 05:00:00	SPY	ETF	376.51	376.61	376.15	376.18	26379.0
2021-01-04 06:00:00	SPY	ETF	376.23	376.46	376.19	376.19	26362.0
2021-01-04 07:00:00	SPY	ETF	376.14	376.2	375.74	376.18	66928.0
2021-01-04 08:00:00	SPY	ETF	376.11	376.18	374.1	375.58	293195.0
2021-01-04 09:00:00	SPY	ETF	375.69	375.79	373.11	373.51	6779787.0
2021-01-04 10:00:00	SPY	ETF	373.53	373.74	369.82	369.98	12802395.0
2021-01-04 11:00:00	SPY	ETF	369.995	370.45	366.69	366.96	14974173.0
2021-01-04 12:00:00	SPY	ETF	366.95	367.25	364.82	366.2701	14459578.0
2021-01-04 13:00:00	SPY	ETF	366.27	368.64	366.07	368.595	9371421.0
2021-01-04 14:00:00	SPY	ETF	368.59	368.62	366.6	367.98	9472217.0
2021-01-04 15:00:00	SPY	ETF	367.97	369.55	367.05	368.85	25290138.0
2021-01-04 16:00:00	SPY	ETF	368.84	369.37	368.37	369.1	11888062.0
2021-01-04 17:00:00	SPY	ETF	369.08	369.12	368.6842	368.98	2989557.0
2021-01-04 18:00:00	SPY	ETF	369.02	369.02	368.23	368.8	187368.0
2021-01-04 19:00:00	SPY	ETF	368.88	369.44	368.79	369.34	127766.0
2021-01-04 04:00:00	QQQ	ETF	315.06	315.75	315.06	315.52	59159.0
2021-01-04 05:00:00	QQQ	ETF	315.53	315.61	315.14	315.3	56403.0
2021-01-04 06:00:00	QQQ	ETF	315.3	315.53	315.28	315.38	57880.0
2021-01-04 07:00:00	QQQ	ETF	315.32	315.6	315.2	315.6	204541.0
2021-01-04 08:00:00	QQQ	ETF	315.6	315.62	313.16	315.3	316200.0
2021-01-04 09:00:00	QQQ	ETF	315.301	315.301	313.29	313.81	4124031.0
2021-01-04 10:00:00	QQQ	ETF	313.82	314.08	310.9502	310.9558	5131628.0
2021-01-04 11:00:00	QQQ	ETF	310.98	311.47	307.94	307.9401	6130677.0
2021-01-04 12:00:00	QQQ	ETF	307.96	308.28	305.18	307.0125	6434187.0
2021-01-04 13:00:00	QQQ	ETF	307.0	308.97	306.74	308.89	3310752.0
2021-01-04 14:00:00	QQQ	ETF	308.89	308.95	307.28	308.66	2998514.0
2021-01-04 15:00:00	QQQ	ETF	308.62	309.79	307.86	309.24	5047870.0
2021-01-04 16:00:00	QQQ	ETF	309.2	309.44	308.78	309.27	1888159.0
2021-01-04 17:00:00	QQQ	ETF	309.2	309.3	309.02	309.04	15340.0
2021-01-04 18:00:00	QQQ	ETF	309.16	309.21	308.58	308.9	51960.0
2021-01-04 19:00:00	QQQ	ETF	309.0	309.38	308.88	309.31	118851.0
2021-01-04 04:00:00	IWM	ETF	197.82	198.46	197.8	197.96	97252.0
2021-01-04 05:00:00	IWM	ETF	197.95	198.12	197.8	197.8	13996.0
2021-01-04 06:00:00	IWM	ETF	197.92	197.95	197.53	197.64	10300.0
2021-01-04 07:00:00	IWM	ETF	197.57	197.78	197.35	197.72	122170.0
2021-01-04 08:00:00	IWM	ETF	197.7	197.82	196.84	197.47	54897.0
2021-01-04 09:00:00	IWM	ETF	197.51	197.89	196.0	196.36	3498247.0
2021-01-04 10:00:00	IWM	ETF	196.4	196.75	191.84	192.78	5915626.0
2021-01-04 11:00:00	IWM	ETF	192.79	193.5	191.73	192.673	3833494.0
2021-01-04 12:00:00	IWM	ETF	192.67	192.79	190.94	192.24	3712170.0
2021-01-04 13:00:00	IWM	ETF	192.23	194.14	192.18	193.89	2584775.0
2021-01-04 14:00:00	IWM	ETF	193.88	193.91	192.79	193.51	2389534.0
2021-01-04 15:00:00	IWM	ETF	193.5	193.75	192.8011	193.45	5367162.0
2021-01-04 16:00:00	IWM	ETF	193.47	193.89	193.0277	193.82	2252748.0
2021-01-04 17:00:00	IWM	ETF	193.76	193.83	193.76	193.76	6656.0
2021-01-04 18:00:00	IWM	ETF	193.52	193.81	193.39	193.8	52731.0
2021-01-04 19:00:00	IWM	ETF	193.92	194.22	193.8	194.19	18975.0
2021-01-04 04:00:00	DIA	ETF	307.2	307.83	307.15	307.73	4900.0
2021-01-04 05:00:00	DIA	ETF	307.66	307.7	307.66	307.7	200.0

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

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