PREVIEW / etf_1hour / 2021-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-07-06.parquet
  size:    423 KB
  rows:    14,991

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-07-06 04:00:00	SPY	ETF	433.38	433.52	433.2	433.41	3333.0
2021-07-06 05:00:00	SPY	ETF	433.45	433.55	433.29	433.43	23694.0
2021-07-06 06:00:00	SPY	ETF	433.55	433.67	433.36	433.38	36481.0
2021-07-06 07:00:00	SPY	ETF	433.43	433.75	433.37	433.49	71465.0
2021-07-06 08:00:00	SPY	ETF	433.59	433.7	433.34	433.65	117393.0
2021-07-06 09:00:00	SPY	ETF	433.65	434.01	432.86	432.97	4122642.0
2021-07-06 10:00:00	SPY	ETF	432.97	433.05	431.0	431.01	7468057.0
2021-07-06 11:00:00	SPY	ETF	431.02	431.48	430.45	431.16	7342502.0
2021-07-06 12:00:00	SPY	ETF	431.14	431.145	430.01	431.03	7380937.0
2021-07-06 13:00:00	SPY	ETF	431.03	433.39	430.58	431.74	5772943.0
2021-07-06 14:00:00	SPY	ETF	431.745	432.45	431.67	432.11	5386436.0
2021-07-06 15:00:00	SPY	ETF	432.11	433.45	432.065	432.9	12051866.0
2021-07-06 16:00:00	SPY	ETF	432.91	432.96	432.2	432.32	3130101.0
2021-07-06 17:00:00	SPY	ETF	432.28	432.42	432.08	432.21	135054.0
2021-07-06 18:00:00	SPY	ETF	432.22	432.48	432.2	432.39	80223.0
2021-07-06 19:00:00	SPY	ETF	432.36	432.45	432.06	432.18	68630.0
2021-07-06 04:00:00	QQQ	ETF	358.26	358.43	358.07	358.25	11544.0
2021-07-06 05:00:00	QQQ	ETF	358.25	358.57	358.25	358.54	13298.0
2021-07-06 06:00:00	QQQ	ETF	358.51	359.06	358.46	358.75	38850.0
2021-07-06 07:00:00	QQQ	ETF	358.72	359.33	358.7	359.09	113045.0
2021-07-06 08:00:00	QQQ	ETF	359.33	359.41	357.83	359.17	187076.0
2021-07-06 09:00:00	QQQ	ETF	359.17	360.08	359.1	359.61	3002553.0
2021-07-06 10:00:00	QQQ	ETF	359.64	360.48	358.66	359.06	4035230.0
2021-07-06 11:00:00	QQQ	ETF	359.07	359.64	358.34	358.8	4274802.0
2021-07-06 12:00:00	QQQ	ETF	358.785	358.785	356.49	358.33	5765552.0
2021-07-06 13:00:00	QQQ	ETF	358.33	359.28	358.19	359.15	2913528.0
2021-07-06 14:00:00	QQQ	ETF	359.13	359.66	358.97	359.41	2160979.0
2021-07-06 15:00:00	QQQ	ETF	359.41	360.4	359.33	360.17	4099816.0
2021-07-06 16:00:00	QQQ	ETF	360.17	360.19	359.75	359.83	999725.0
2021-07-06 17:00:00	QQQ	ETF	359.88	359.96	359.75	359.88	51252.0
2021-07-06 18:00:00	QQQ	ETF	359.86	360.05	359.8	359.88	52547.0
2021-07-06 19:00:00	QQQ	ETF	359.86	359.95	359.71	359.85	57228.0
2021-07-06 04:00:00	IWM	ETF	229.01	229.04	228.99	228.99	1148.0
2021-07-06 05:00:00	IWM	ETF	229.05	229.05	228.94	228.96	14507.0
2021-07-06 06:00:00	IWM	ETF	229.09	229.18	228.96	228.97	23500.0
2021-07-06 07:00:00	IWM	ETF	228.99	229.27	228.95	229.22	59942.0
2021-07-06 08:00:00	IWM	ETF	229.11	230.15	228.95	229.42	112958.0
2021-07-06 09:00:00	IWM	ETF	229.46	229.57	226.28	226.39	3017220.0
2021-07-06 10:00:00	IWM	ETF	226.38	226.38	224.77	224.94	5013140.0
2021-07-06 11:00:00	IWM	ETF	224.93	225.62	224.415	225.11	3479980.0
2021-07-06 12:00:00	IWM	ETF	225.11	225.11	223.87	224.6619	2816249.0
2021-07-06 13:00:00	IWM	ETF	224.67	225.36	224.48	225.35	2082233.0
2021-07-06 14:00:00	IWM	ETF	225.34	225.76	225.185	225.61	2044790.0
2021-07-06 15:00:00	IWM	ETF	225.6	226.38	225.515	225.87	3531533.0
2021-07-06 16:00:00	IWM	ETF	225.86	225.95	225.34	225.36	644182.0
2021-07-06 17:00:00	IWM	ETF	225.34	225.48	225.26	225.26	16875.0
2021-07-06 18:00:00	IWM	ETF	225.37	225.54	225.3	225.52	21830.0
2021-07-06 19:00:00	IWM	ETF	225.6	225.61	225.21	225.34	17650.0
2021-07-06 04:00:00	DIA	ETF	345.0	347.84	345.0	347.84	1210.0
2021-07-06 05:00:00	DIA	ETF	347.6	347.87	347.6	347.87	250.0

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

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