PREVIEW / etf_1hour / 2021-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-27.parquet
  size:    406 KB
  rows:    14,064

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-27 04:00:00	SPY	ETF	418.11	418.38	417.81	417.97	21847.0
2021-05-27 05:00:00	SPY	ETF	417.97	418.09	417.83	417.9	12674.0
2021-05-27 06:00:00	SPY	ETF	417.81	418.2	417.69	418.18	33704.0
2021-05-27 07:00:00	SPY	ETF	418.18	418.79	418.0	418.76	119957.0
2021-05-27 08:00:00	SPY	ETF	418.16	419.55	418.0	419.41	438759.0
2021-05-27 09:00:00	SPY	ETF	419.44	420.63	419.41	420.1	5650153.0
2021-05-27 10:00:00	SPY	ETF	420.1	420.72	419.79	420.103	6784606.0
2021-05-27 11:00:00	SPY	ETF	420.12	420.38	419.46	420.28	4190106.0
2021-05-27 12:00:00	SPY	ETF	420.28	420.43	419.98	420.045	2374675.0
2021-05-27 13:00:00	SPY	ETF	420.0489	420.1901	419.41	419.7089	3176719.0
2021-05-27 14:00:00	SPY	ETF	419.71	419.75	419.2	419.6011	5386649.0
2021-05-27 15:00:00	SPY	ETF	419.6	420.1	419.12	419.22	15380906.0
2021-05-27 16:00:00	SPY	ETF	419.22	420.82	419.15	420.76	3867589.0
2021-05-27 17:00:00	SPY	ETF	420.77	420.77	420.6	420.68	85166.0
2021-05-27 18:00:00	SPY	ETF	420.65	420.82	419.29	420.73	46091.0
2021-05-27 19:00:00	SPY	ETF	420.76	421.25	420.61	421.12	85419.0
2021-05-27 04:00:00	QQQ	ETF	333.37	333.37	332.28	332.41	37363.0
2021-05-27 05:00:00	QQQ	ETF	332.39	332.56	332.22	332.37	24916.0
2021-05-27 06:00:00	QQQ	ETF	332.3	332.79	332.21	332.76	51246.0
2021-05-27 07:00:00	QQQ	ETF	332.76	333.27	332.44	333.23	140040.0
2021-05-27 08:00:00	QQQ	ETF	332.9	333.58	332.13	333.08	533207.0
2021-05-27 09:00:00	QQQ	ETF	333.09	333.98	332.67	332.97	3550120.0
2021-05-27 10:00:00	QQQ	ETF	332.965	334.54	332.74	333.64	4464129.0
2021-05-27 11:00:00	QQQ	ETF	333.63	334.3	333.52	334.231	2001943.0
2021-05-27 12:00:00	QQQ	ETF	334.23	334.369	333.83	334.1018	1187492.0
2021-05-27 13:00:00	QQQ	ETF	334.105	334.28	333.53	333.71	1793793.0
2021-05-27 14:00:00	QQQ	ETF	333.71	333.75	332.84	333.19	2259364.0
2021-05-27 15:00:00	QQQ	ETF	333.18	333.51	332.76	332.85	5018377.0
2021-05-27 16:00:00	QQQ	ETF	332.85	333.85	332.83	333.85	1629923.0
2021-05-27 17:00:00	QQQ	ETF	333.82	333.87	333.63	333.8	31405.0
2021-05-27 18:00:00	QQQ	ETF	333.81	333.93	333.68	333.84	28657.0
2021-05-27 19:00:00	QQQ	ETF	333.81	334.22	333.61	334.1	105391.0
2021-05-27 04:00:00	IWM	ETF	223.2	223.2	222.74	222.74	19648.0
2021-05-27 05:00:00	IWM	ETF	222.83	222.86	222.65	222.85	16800.0
2021-05-27 06:00:00	IWM	ETF	222.72	223.06	222.72	222.97	18600.0
2021-05-27 07:00:00	IWM	ETF	222.97	223.46	222.97	223.45	44114.0
2021-05-27 08:00:00	IWM	ETF	223.04	224.66	222.95	224.55	322108.0
2021-05-27 09:00:00	IWM	ETF	224.65	225.41	224.18	225.15	2462547.0
2021-05-27 10:00:00	IWM	ETF	225.15	225.72	224.72	225.34	2448710.0
2021-05-27 11:00:00	IWM	ETF	225.35	225.65	225.07	225.49	1170227.0
2021-05-27 12:00:00	IWM	ETF	225.48	225.72	225.38	225.61	1876616.0
2021-05-27 13:00:00	IWM	ETF	225.62	226.2	225.5701	226.1956	2056586.0
2021-05-27 14:00:00	IWM	ETF	226.19	226.3	225.39	226.21	1837915.0
2021-05-27 15:00:00	IWM	ETF	226.21	226.36	225.66	225.68	3457806.0
2021-05-27 16:00:00	IWM	ETF	225.68	226.6	225.62	226.58	1415837.0
2021-05-27 17:00:00	IWM	ETF	226.55	226.56	226.46	226.46	4013.0
2021-05-27 18:00:00	IWM	ETF	226.55	226.71	226.55	226.64	17994.0
2021-05-27 19:00:00	IWM	ETF	226.63	227.33	226.55	227.0	43638.0
2021-05-27 04:00:00	DIA	ETF	343.06	343.25	343.02	343.06	3320.0
2021-05-27 05:00:00	DIA	ETF	342.93	342.93	342.82	342.82	1300.0

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

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