PREVIEW / etf_1hour / 2021-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-06-03.parquet
  size:    411 KB
  rows:    14,500

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-03 04:00:00	SPY	ETF	419.63	420.02	419.49	419.98	13388.0
2021-06-03 05:00:00	SPY	ETF	419.9	419.9	419.35	419.52	13416.0
2021-06-03 06:00:00	SPY	ETF	419.51	419.51	417.83	418.02	140040.0
2021-06-03 07:00:00	SPY	ETF	418.05	418.1	416.97	417.34	451405.0
2021-06-03 08:00:00	SPY	ETF	417.3	420.98	416.76	417.61	760138.0
2021-06-03 09:00:00	SPY	ETF	417.71	418.24	416.28	417.17	7337532.0
2021-06-03 10:00:00	SPY	ETF	417.16	419.3511	417.03	419.325	9357510.0
2021-06-03 11:00:00	SPY	ETF	419.33	419.99	419.07	419.425	7006232.0
2021-06-03 12:00:00	SPY	ETF	419.43	419.75	418.93	419.56	4216555.0
2021-06-03 13:00:00	SPY	ETF	419.5704	419.9	418.88	419.5301	4072612.0
2021-06-03 14:00:00	SPY	ETF	419.53	419.61	418.74	418.765	3645917.0
2021-06-03 15:00:00	SPY	ETF	418.76	419.45	418.73	418.82	7909156.0
2021-06-03 16:00:00	SPY	ETF	418.81	418.91	418.6	418.87	2093852.0
2021-06-03 17:00:00	SPY	ETF	418.77	418.99	418.76	418.84	44586.0
2021-06-03 18:00:00	SPY	ETF	418.89	419.12	418.61	418.83	52274.0
2021-06-03 19:00:00	SPY	ETF	418.9	418.9	418.31	418.37	27533.0
2021-06-03 04:00:00	QQQ	ETF	333.02	333.27	332.86	333.23	14716.0
2021-06-03 05:00:00	QQQ	ETF	333.25	333.25	332.43	332.67	13824.0
2021-06-03 06:00:00	QQQ	ETF	332.62	332.65	330.88	331.06	102678.0
2021-06-03 07:00:00	QQQ	ETF	331.1	331.19	329.69	330.07	603370.0
2021-06-03 08:00:00	QQQ	ETF	329.95	333.63	329.49	330.291	525310.0
2021-06-03 09:00:00	QQQ	ETF	330.32	330.8999	328.28	329.18	5690642.0
2021-06-03 10:00:00	QQQ	ETF	329.18	331.14	328.75	331.14	5881245.0
2021-06-03 11:00:00	QQQ	ETF	331.14	331.86	329.89	330.4596	4680245.0
2021-06-03 12:00:00	QQQ	ETF	330.46	331.155	330.02	331.14	2878706.0
2021-06-03 13:00:00	QQQ	ETF	331.14	331.49	330.33	330.81	2624234.0
2021-06-03 14:00:00	QQQ	ETF	330.82	331.01	329.98	330.03	1772743.0
2021-06-03 15:00:00	QQQ	ETF	330.01	330.51	329.685	329.87	4797598.0
2021-06-03 16:00:00	QQQ	ETF	329.88	333.4106	329.62	329.92	956585.0
2021-06-03 17:00:00	QQQ	ETF	329.94	330.0	329.86	329.95	41129.0
2021-06-03 18:00:00	QQQ	ETF	329.96	330.19	329.63	329.79	67828.0
2021-06-03 19:00:00	QQQ	ETF	329.87	329.87	329.22	329.26	64809.0
2021-06-03 04:00:00	IWM	ETF	228.16	228.39	227.98	228.36	11413.0
2021-06-03 05:00:00	IWM	ETF	228.2	228.44	228.07	228.3	2478.0
2021-06-03 06:00:00	IWM	ETF	228.25	228.25	227.22	227.24	32634.0
2021-06-03 07:00:00	IWM	ETF	227.3	227.39	226.09	226.18	358908.0
2021-06-03 08:00:00	IWM	ETF	227.1601	228.77	225.49	226.48	297167.0
2021-06-03 09:00:00	IWM	ETF	226.48	227.18	224.04	224.75	4378860.0
2021-06-03 10:00:00	IWM	ETF	224.72	226.74	224.59	226.74	3710815.0
2021-06-03 11:00:00	IWM	ETF	226.73	226.74	225.35	226.12	2817188.0
2021-06-03 12:00:00	IWM	ETF	226.13	226.88	226.072	226.87	1457261.0
2021-06-03 13:00:00	IWM	ETF	226.88	227.6099	226.41	227.59	2029826.0
2021-06-03 14:00:00	IWM	ETF	227.6	227.62	226.5	226.71	1362521.0
2021-06-03 15:00:00	IWM	ETF	226.72	227.075	226.31	226.41	2921757.0
2021-06-03 16:00:00	IWM	ETF	226.41	226.79	226.38	226.65	694734.0
2021-06-03 17:00:00	IWM	ETF	226.85	226.88	226.42	226.78	239040.0
2021-06-03 18:00:00	IWM	ETF	226.75	226.75	226.5	226.59	11436.0
2021-06-03 19:00:00	IWM	ETF	226.57	226.57	226.0	226.11	62287.0
2021-06-03 04:00:00	DIA	ETF	345.67	345.67	345.67	345.67	100.0
2021-06-03 05:00:00	DIA	ETF	345.79	345.79	345.7	345.7	599.0

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

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