PREVIEW / etf_1hour / 2021-11-11

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-11-11.parquet
  size:    419 KB
  rows:    14,855

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-11-11 04:00:00	SPY	ETF	464.66	465.46	464.66	465.36	53406.0
2021-11-11 05:00:00	SPY	ETF	465.4	465.65	465.03	465.21	19129.0
2021-11-11 06:00:00	SPY	ETF	465.2	465.5	465.2	465.43	12948.0
2021-11-11 07:00:00	SPY	ETF	465.5	465.66	465.24	465.44	93308.0
2021-11-11 08:00:00	SPY	ETF	465.4025	465.58	465.22	465.45	239426.0
2021-11-11 09:00:00	SPY	ETF	465.43	465.46	464.23	465.02	4235028.0
2021-11-11 10:00:00	SPY	ETF	465.02	465.06	463.93	464.54	5524728.0
2021-11-11 11:00:00	SPY	ETF	464.53	465.095	464.24	464.681	3168512.0
2021-11-11 12:00:00	SPY	ETF	464.68	464.835	463.84	464.44	2097744.0
2021-11-11 13:00:00	SPY	ETF	464.44	464.515	463.905	464.39	1923958.0
2021-11-11 14:00:00	SPY	ETF	464.4	464.84	464.18	464.26	2049036.0
2021-11-11 15:00:00	SPY	ETF	464.26	464.45	463.75	463.81	6209426.0
2021-11-11 16:00:00	SPY	ETF	463.82	464.23	463.77	464.19	2006168.0
2021-11-11 17:00:00	SPY	ETF	464.2	464.2	464.03	464.14	55338.0
2021-11-11 18:00:00	SPY	ETF	464.19	464.61	463.77	464.6	52072.0
2021-11-11 19:00:00	SPY	ETF	464.62	465.32	464.62	465.0	78493.0
2021-11-11 04:00:00	QQQ	ETF	390.53	392.15	390.53	392.0	66102.0
2021-11-11 05:00:00	QQQ	ETF	391.97	392.35	391.44	391.96	43345.0
2021-11-11 06:00:00	QQQ	ETF	391.92	392.21	391.76	392.12	40201.0
2021-11-11 07:00:00	QQQ	ETF	392.1	392.31	391.83	392.18	167338.0
2021-11-11 08:00:00	QQQ	ETF	392.09	392.81	390.0	392.69	329329.0
2021-11-11 09:00:00	QQQ	ETF	392.71	392.76	391.35	392.36	3867597.0
2021-11-11 10:00:00	QQQ	ETF	392.36	392.48	390.97	391.8699	5640348.0
2021-11-11 11:00:00	QQQ	ETF	391.87	392.37	391.3237	391.86	2399797.0
2021-11-11 12:00:00	QQQ	ETF	391.86	391.9584	390.6	391.33	2988108.0
2021-11-11 13:00:00	QQQ	ETF	391.33	391.469	390.67	391.34	1514606.0
2021-11-11 14:00:00	QQQ	ETF	391.34	391.96	390.91	391.02	1744536.0
2021-11-11 15:00:00	QQQ	ETF	391.0	391.19	390.24	390.62	4204772.0
2021-11-11 16:00:00	QQQ	ETF	390.59	390.97	390.53	390.97	1675131.0
2021-11-11 17:00:00	QQQ	ETF	390.99	391.12	390.83	391.08	26876.0
2021-11-11 18:00:00	QQQ	ETF	391.06	391.6	391.01	391.6	46433.0
2021-11-11 19:00:00	QQQ	ETF	391.63	392.31	391.62	391.97	108433.0
2021-11-11 04:00:00	IWM	ETF	237.87	238.38	237.82	238.19	35585.0
2021-11-11 05:00:00	IWM	ETF	238.2	238.49	238.03	238.09	13928.0
2021-11-11 06:00:00	IWM	ETF	238.18	238.31	238.11	238.29	8453.0
2021-11-11 07:00:00	IWM	ETF	238.29	238.5	238.24	238.34	36928.0
2021-11-11 08:00:00	IWM	ETF	238.4401	238.64	238.08	238.49	90565.0
2021-11-11 09:00:00	IWM	ETF	238.49	239.5183	237.66	239.13	1814498.0
2021-11-11 10:00:00	IWM	ETF	239.12	239.64	238.57	239.21	2082694.0
2021-11-11 11:00:00	IWM	ETF	239.23	239.85	238.93	239.27	1186625.0
2021-11-11 12:00:00	IWM	ETF	239.26	240.378	239.18	239.83	1773755.0
2021-11-11 13:00:00	IWM	ETF	239.84	240.01	239.46	239.66	1226476.0
2021-11-11 14:00:00	IWM	ETF	239.65	239.85	239.12	239.335	1120185.0
2021-11-11 15:00:00	IWM	ETF	239.32	239.72	239.0	239.25	2702265.0
2021-11-11 16:00:00	IWM	ETF	239.26	239.36	239.05	239.18	700005.0
2021-11-11 17:00:00	IWM	ETF	239.01	239.35	239.01	239.35	23217.0
2021-11-11 18:00:00	IWM	ETF	239.3	239.62	239.18	239.58	27740.0
2021-11-11 19:00:00	IWM	ETF	239.59	240.09	239.59	239.86	48962.0
2021-11-11 04:00:00	DIA	ETF	361.62	361.62	361.57	361.57	900.0
2021-11-11 05:00:00	DIA	ETF	361.68	361.68	361.58	361.58	229.0

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

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