PREVIEW / etf_1hour / 2021-06-29

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-29.parquet
  size:    409 KB
  rows:    14,282

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-06-29 04:00:00	SPY	ETF	427.53	427.53	427.0	427.21	10692.0
2021-06-29 05:00:00	SPY	ETF	427.33	427.51	427.33	427.45	11247.0
2021-06-29 06:00:00	SPY	ETF	427.46	427.62	427.28	427.62	156172.0
2021-06-29 07:00:00	SPY	ETF	427.62	427.62	427.05	427.22	60833.0
2021-06-29 08:00:00	SPY	ETF	427.22	427.68	427.06	427.57	193576.0
2021-06-29 09:00:00	SPY	ETF	427.59	428.4	427.53	428.17	4317893.0
2021-06-29 10:00:00	SPY	ETF	428.17	428.56	427.94	428.165	4396040.0
2021-06-29 11:00:00	SPY	ETF	428.165	428.25	427.845	427.995	3481687.0
2021-06-29 12:00:00	SPY	ETF	427.99	428.09	427.77	428.01	2045029.0
2021-06-29 13:00:00	SPY	ETF	428.02	428.07	427.64	427.87	1599064.0
2021-06-29 14:00:00	SPY	ETF	427.87	428.06	427.13	427.54	3651241.0
2021-06-29 15:00:00	SPY	ETF	427.54	427.81	427.3	427.67	7290926.0
2021-06-29 16:00:00	SPY	ETF	427.67	428.07	427.66	427.9	2301239.0
2021-06-29 17:00:00	SPY	ETF	427.96	427.96	427.78	427.91	20946.0
2021-06-29 18:00:00	SPY	ETF	427.96	428.0	427.7	427.95	25230.0
2021-06-29 19:00:00	SPY	ETF	427.98	428.27	427.98	428.25	33101.0
2021-06-29 04:00:00	QQQ	ETF	353.18	353.18	352.64	352.99	20579.0
2021-06-29 05:00:00	QQQ	ETF	353.02	353.45	353.02	353.45	39540.0
2021-06-29 06:00:00	QQQ	ETF	353.31	353.7	353.2	353.7	97094.0
2021-06-29 07:00:00	QQQ	ETF	353.71	353.71	352.98	353.15	97858.0
2021-06-29 08:00:00	QQQ	ETF	353.16	353.58	352.84	353.11	272053.0
2021-06-29 09:00:00	QQQ	ETF	353.08	354.13	352.67	353.71	4002989.0
2021-06-29 10:00:00	QQQ	ETF	353.74	354.17	352.83	353.72	4338315.0
2021-06-29 11:00:00	QQQ	ETF	353.729	353.99	353.235	353.99	2154161.0
2021-06-29 12:00:00	QQQ	ETF	353.99	354.71	353.76	354.615	2199065.0
2021-06-29 13:00:00	QQQ	ETF	354.61	354.71	354.31	354.64	1694397.0
2021-06-29 14:00:00	QQQ	ETF	354.63	354.909	354.14	354.55	2334809.0
2021-06-29 15:00:00	QQQ	ETF	354.56	355.0199	354.3801	354.96	3267503.0
2021-06-29 16:00:00	QQQ	ETF	354.95	355.42	354.93	355.4	724086.0
2021-06-29 17:00:00	QQQ	ETF	355.4	355.49	354.99	355.4	45586.0
2021-06-29 18:00:00	QQQ	ETF	355.47	355.5	354.99	355.34	491099.0
2021-06-29 19:00:00	QQQ	ETF	355.32	355.54	354.89	355.52	102615.0
2021-06-29 04:00:00	IWM	ETF	230.57	230.63	230.11	230.16	4819.0
2021-06-29 05:00:00	IWM	ETF	230.12	230.41	230.12	230.41	8150.0
2021-06-29 06:00:00	IWM	ETF	230.19	230.9	230.19	230.9	77369.0
2021-06-29 07:00:00	IWM	ETF	230.94	230.94	230.39	230.57	116821.0
2021-06-29 08:00:00	IWM	ETF	230.52	231.05	230.52	230.83	94889.0
2021-06-29 09:00:00	IWM	ETF	230.95	231.73	230.78	231.2215	2450171.0
2021-06-29 10:00:00	IWM	ETF	231.25	231.49	230.425	230.73	1890533.0
2021-06-29 11:00:00	IWM	ETF	230.735	231.35	230.14	230.34	1769049.0
2021-06-29 12:00:00	IWM	ETF	230.35	230.44	229.8918	230.075	1533809.0
2021-06-29 13:00:00	IWM	ETF	230.09	230.17	229.81	230.045	907781.0
2021-06-29 14:00:00	IWM	ETF	230.05	230.0685	228.77	229.23	2568081.0
2021-06-29 15:00:00	IWM	ETF	229.23	229.675	229.11	229.34	3327987.0
2021-06-29 16:00:00	IWM	ETF	229.34	229.52	229.11	229.33	530753.0
2021-06-29 17:00:00	IWM	ETF	229.43	229.43	229.29	229.34	42369.0
2021-06-29 18:00:00	IWM	ETF	229.38	229.55	229.34	229.55	452213.0
2021-06-29 19:00:00	IWM	ETF	229.54	229.66	229.53	229.65	6211.0
2021-06-29 04:00:00	DIA	ETF	343.35	343.63	343.16	343.16	1000.0
2021-06-29 05:00:00	DIA	ETF	343.05	343.34	343.05	343.34	400.0

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

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