PREVIEW / etf_1hour / 2021-05-05

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-05.parquet
  size:    412 KB
  rows:    14,421

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-05-05 04:00:00	SPY	ETF	416.8	417.16	416.03	416.83	28241.0
2021-05-05 05:00:00	SPY	ETF	416.87	417.17	416.87	417.0	66336.0
2021-05-05 06:00:00	SPY	ETF	417.0	417.28	416.84	417.03	65424.0
2021-05-05 07:00:00	SPY	ETF	416.97	417.1	416.62	416.97	176971.0
2021-05-05 08:00:00	SPY	ETF	416.99	417.48	416.0	417.12	325535.0
2021-05-05 09:00:00	SPY	ETF	417.15	417.5	416.255	416.575	5584383.0
2021-05-05 10:00:00	SPY	ETF	416.58	416.67	414.94	416.4	9508588.0
2021-05-05 11:00:00	SPY	ETF	416.41	417.57	416.1312	417.555	4518013.0
2021-05-05 12:00:00	SPY	ETF	417.56	417.63	416.58	416.64	4704362.0
2021-05-05 13:00:00	SPY	ETF	416.65	417.129	416.33	416.8799	4078132.0
2021-05-05 14:00:00	SPY	ETF	416.8781	417.23	416.44	416.7099	4486441.0
2021-05-05 15:00:00	SPY	ETF	416.7	416.82	415.15	415.72	12950939.0
2021-05-05 16:00:00	SPY	ETF	415.72	415.9	415.29	415.44	4242394.0
2021-05-05 17:00:00	SPY	ETF	415.44	415.44	415.14	415.41	128320.0
2021-05-05 18:00:00	SPY	ETF	415.44	415.75	415.13	415.25	141353.0
2021-05-05 19:00:00	SPY	ETF	415.3	415.7	415.26	415.68	44238.0
2021-05-05 04:00:00	QQQ	ETF	330.74	331.68	330.74	331.4	63915.0
2021-05-05 05:00:00	QQQ	ETF	331.39	331.85	331.39	331.59	45927.0
2021-05-05 06:00:00	QQQ	ETF	331.62	332.07	331.54	331.92	83567.0
2021-05-05 07:00:00	QQQ	ETF	331.94	332.26	331.54	331.95	241468.0
2021-05-05 08:00:00	QQQ	ETF	331.8704	332.8	329.9	332.08	690327.0
2021-05-05 09:00:00	QQQ	ETF	332.12	333.14	331.32	331.47	6542674.0
2021-05-05 10:00:00	QQQ	ETF	331.49	332.06	329.8499	331.87	7471203.0
2021-05-05 11:00:00	QQQ	ETF	331.87	332.28	330.99	332.17	4046465.0
2021-05-05 12:00:00	QQQ	ETF	332.19	332.31	330.73	330.84	2942746.0
2021-05-05 13:00:00	QQQ	ETF	330.81	331.44	330.32	330.88	2586536.0
2021-05-05 14:00:00	QQQ	ETF	330.91	330.99	330.095	330.19	3278018.0
2021-05-05 15:00:00	QQQ	ETF	330.16	330.3	328.23	328.96	8532243.0
2021-05-05 16:00:00	QQQ	ETF	328.97	329.17	328.55	328.81	1665938.0
2021-05-05 17:00:00	QQQ	ETF	328.8	329.03	328.63	328.76	333353.0
2021-05-05 18:00:00	QQQ	ETF	328.77	329.02	328.43	328.48	95267.0
2021-05-05 19:00:00	QQQ	ETF	328.53	329.15	328.5	329.12	97645.0
2021-05-05 04:00:00	IWM	ETF	224.4	224.77	224.05	224.6	15512.0
2021-05-05 05:00:00	IWM	ETF	224.65	224.71	224.51	224.63	10845.0
2021-05-05 06:00:00	IWM	ETF	224.63	224.79	224.49	224.51	29009.0
2021-05-05 07:00:00	IWM	ETF	224.53	224.61	224.08	224.61	23638.0
2021-05-05 08:00:00	IWM	ETF	224.43	224.67	224.08	224.41	174419.0
2021-05-05 09:00:00	IWM	ETF	224.35	224.69	222.519	222.85	2571277.0
2021-05-05 10:00:00	IWM	ETF	222.88	223.255	221.36	223.17	4754361.0
2021-05-05 11:00:00	IWM	ETF	223.16	224.16	223.08	223.86	1715628.0
2021-05-05 12:00:00	IWM	ETF	223.86	224.14	223.01	223.08	1423950.0
2021-05-05 13:00:00	IWM	ETF	223.08	224.03	222.805	223.78	1538917.0
2021-05-05 14:00:00	IWM	ETF	223.79	223.865	223.155	223.23	1522948.0
2021-05-05 15:00:00	IWM	ETF	223.22	223.27	221.44	222.41	4125760.0
2021-05-05 16:00:00	IWM	ETF	222.4	222.74	222.2	222.31	1036935.0
2021-05-05 17:00:00	IWM	ETF	222.5	222.5	222.16	222.252	192428.0
2021-05-05 18:00:00	IWM	ETF	222.34	222.54	222.25	222.25	26660.0
2021-05-05 19:00:00	IWM	ETF	222.21	222.58	222.21	222.57	22658.0
2021-05-05 04:00:00	DIA	ETF	342.25	342.35	342.12	342.27	7481.0
2021-05-05 05:00:00	DIA	ETF	342.31	342.31	342.12	342.2	300.0

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

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