PREVIEW / etf_1hour / 2020-11-24

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-24.parquet
  size:    410 KB
  rows:    13,939

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
2020-11-24 04:00:00	SPY	ETF	359.86	360.34	359.82	360.34	30708.0
2020-11-24 05:00:00	SPY	ETF	360.16	360.44	360.07	360.39	18141.0
2020-11-24 06:00:00	SPY	ETF	360.4	360.7	360.21	360.21	31349.0
2020-11-24 07:00:00	SPY	ETF	360.09	360.3	359.59	360.29	273139.0
2020-11-24 08:00:00	SPY	ETF	360.3	360.69	359.64	360.28	174576.0
2020-11-24 09:00:00	SPY	ETF	360.282	360.39	359.29	360.32	5285152.0
2020-11-24 10:00:00	SPY	ETF	360.3311	361.77	360.15	361.51	10420392.0
2020-11-24 11:00:00	SPY	ETF	361.51	363.49	361.5	362.97	8055002.0
2020-11-24 12:00:00	SPY	ETF	362.97	363.17	362.6	362.9801	3749885.0
2020-11-24 13:00:00	SPY	ETF	362.99	363.81	362.61	363.08	5937319.0
2020-11-24 14:00:00	SPY	ETF	363.08	363.4	362.32	363.07	6442581.0
2020-11-24 15:00:00	SPY	ETF	363.07	363.45	362.59	363.19	15493634.0
2020-11-24 16:00:00	SPY	ETF	363.17	363.94	363.1	363.79	4763853.0
2020-11-24 17:00:00	SPY	ETF	363.75	363.79	363.5	363.5	49467.0
2020-11-24 18:00:00	SPY	ETF	363.59	364.23	363.41	364.11	237501.0
2020-11-24 19:00:00	SPY	ETF	364.1	365.31	363.86	364.78	240444.0
2020-11-24 04:00:00	QQQ	ETF	291.18	291.54	291.09	291.49	22377.0
2020-11-24 05:00:00	QQQ	ETF	291.54	291.54	291.17	291.28	26530.0
2020-11-24 06:00:00	QQQ	ETF	291.21	291.59	291.17	291.36	64201.0
2020-11-24 07:00:00	QQQ	ETF	291.3	291.43	290.92	291.24	143696.0
2020-11-24 08:00:00	QQQ	ETF	291.3901	292.14	290.95	291.58	142418.0
2020-11-24 09:00:00	QQQ	ETF	291.598	291.77	289.63	290.8617	2749948.0
2020-11-24 10:00:00	QQQ	ETF	290.8694	292.41	290.34	292.4	3306557.0
2020-11-24 11:00:00	QQQ	ETF	292.41	293.58	292.39	293.13	3328397.0
2020-11-24 12:00:00	QQQ	ETF	293.14	294.05	292.855	293.79	1701172.0
2020-11-24 13:00:00	QQQ	ETF	293.76	294.75	293.52	294.69	2096475.0
2020-11-24 14:00:00	QQQ	ETF	294.7	294.98	294.03	294.47	1772323.0
2020-11-24 15:00:00	QQQ	ETF	294.46	294.79	293.97	294.52	3162112.0
2020-11-24 16:00:00	QQQ	ETF	294.52	295.3917	293.7948	295.14	975578.0
2020-11-24 17:00:00	QQQ	ETF	294.99	295.17	294.87	294.87	21272.0
2020-11-24 18:00:00	QQQ	ETF	295.05	295.79	295.0	295.73	99185.0
2020-11-24 19:00:00	QQQ	ETF	295.76	296.5	295.6	296.15	184878.0
2020-11-24 04:00:00	IWM	ETF	182.6	183.22	182.6	183.03	47485.0
2020-11-24 05:00:00	IWM	ETF	183.15	183.6	183.08	183.55	25984.0
2020-11-24 06:00:00	IWM	ETF	183.59	183.81	183.38	183.45	79648.0
2020-11-24 07:00:00	IWM	ETF	183.4	183.43	182.93	183.38	67067.0
2020-11-24 08:00:00	IWM	ETF	183.33	183.55	180.7993	183.11	379866.0
2020-11-24 09:00:00	IWM	ETF	183.14	183.55	182.36	183.45	3315643.0
2020-11-24 10:00:00	IWM	ETF	183.47	184.105	183.26	183.9	3083978.0
2020-11-24 11:00:00	IWM	ETF	183.89	185.15	183.77	184.79	3371349.0
2020-11-24 12:00:00	IWM	ETF	184.79	184.98	184.55	184.845	2069821.0
2020-11-24 13:00:00	IWM	ETF	184.84	185.44	184.17	184.2	3187555.0
2020-11-24 14:00:00	IWM	ETF	184.2093	184.46	183.66	184.43	2449666.0
2020-11-24 15:00:00	IWM	ETF	184.42	184.735	183.955	184.215	5195428.0
2020-11-24 16:00:00	IWM	ETF	184.2	184.73	184.1267	184.56	4261983.0
2020-11-24 17:00:00	IWM	ETF	184.5	184.68	184.5	184.61	5432.0
2020-11-24 18:00:00	IWM	ETF	184.57	184.7	184.21	184.6	148598.0
2020-11-24 19:00:00	IWM	ETF	184.6	185.25	184.51	185.02	55305.0
2020-11-24 04:00:00	DIA	ETF	298.59	298.67	298.59	298.67	1300.0
2020-11-24 05:00:00	DIA	ETF	298.7	299.0	298.53	298.89	2030.0

> showing 50 of 13,939 rows — these rows as CSV

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