PREVIEW / etf_1hour / 2019-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-20.parquet
  size:    347 KB
  rows:    11,477

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
2019-11-20 04:00:00	SPY	ETF	310.64	310.99	310.49	310.89	11102.0
2019-11-20 05:00:00	SPY	ETF	310.83	310.83	310.58	310.68	65860.0
2019-11-20 06:00:00	SPY	ETF	310.77	311.08	310.39	311.08	131882.0
2019-11-20 07:00:00	SPY	ETF	311.04	311.2	310.88	310.93	119538.0
2019-11-20 08:00:00	SPY	ETF	311.04	311.46	310.66	310.84	194811.0
2019-11-20 09:00:00	SPY	ETF	310.83	311.62	310.82	311.5	4249872.0
2019-11-20 10:00:00	SPY	ETF	311.5	311.85	311.07	311.65	7267104.0
2019-11-20 11:00:00	SPY	ETF	311.655	311.78	311.27	311.365	5295021.0
2019-11-20 12:00:00	SPY	ETF	311.36	311.47	309.53	310.17	8649090.0
2019-11-20 13:00:00	SPY	ETF	310.17	310.28	309.06	309.99	16867068.0
2019-11-20 14:00:00	SPY	ETF	310.0	310.695	309.64	310.38	9227085.0
2019-11-20 15:00:00	SPY	ETF	310.38	310.92	310.15	310.79	15103060.0
2019-11-20 16:00:00	SPY	ETF	310.79	311.945	310.53	310.85	10167704.0
2019-11-20 17:00:00	SPY	ETF	310.8	310.82	309.6	309.81	692503.0
2019-11-20 18:00:00	SPY	ETF	309.81	310.33	309.4	310.16	329503.0
2019-11-20 19:00:00	SPY	ETF	310.2	310.29	309.41	309.48	148822.0
2019-11-20 04:00:00	QQQ	ETF	202.34	202.48	202.13	202.44	25059.0
2019-11-20 05:00:00	QQQ	ETF	202.42	202.44	202.21	202.36	44750.0
2019-11-20 06:00:00	QQQ	ETF	202.37	202.56	202.11	202.54	27070.0
2019-11-20 07:00:00	QQQ	ETF	202.55	202.7	202.41	202.52	143702.0
2019-11-20 08:00:00	QQQ	ETF	202.62	203.37	202.36	202.46	1322987.0
2019-11-20 09:00:00	QQQ	ETF	202.43	203.1	202.4	203.0794	3815183.0
2019-11-20 10:00:00	QQQ	ETF	203.08	203.45	202.8	203.32	3772329.0
2019-11-20 11:00:00	QQQ	ETF	203.33	203.42	202.79	202.86	1220056.0
2019-11-20 12:00:00	QQQ	ETF	202.86	203.03	201.255	201.8027	3701344.0
2019-11-20 13:00:00	QQQ	ETF	201.81	201.88	200.62	201.5	6208166.0
2019-11-20 14:00:00	QQQ	ETF	201.47	201.98	201.14	201.72	3561565.0
2019-11-20 15:00:00	QQQ	ETF	201.71	202.12	201.4258	202.12	4866941.0
2019-11-20 16:00:00	QQQ	ETF	202.14	203.4383	201.92	202.04	1535437.0
2019-11-20 17:00:00	QQQ	ETF	202.04	202.18	201.46	201.52	95932.0
2019-11-20 18:00:00	QQQ	ETF	201.38	201.7	201.0	201.57	58899.0
2019-11-20 19:00:00	QQQ	ETF	201.65	201.69	201.05	201.07	54797.0
2019-11-20 04:00:00	IWM	ETF	158.0	158.23	157.96	158.23	5800.0
2019-11-20 05:00:00	IWM	ETF	158.03	158.21	158.03	158.21	4500.0
2019-11-20 06:00:00	IWM	ETF	158.2	158.29	158.15	158.29	4898.0
2019-11-20 07:00:00	IWM	ETF	158.35	158.46	158.29	158.29	6539.0
2019-11-20 08:00:00	IWM	ETF	158.34	158.71	158.28	158.37	22190.0
2019-11-20 09:00:00	IWM	ETF	158.39	158.96	158.35	158.91	2137301.0
2019-11-20 10:00:00	IWM	ETF	158.91	159.595	158.89	159.43	1370621.0
2019-11-20 11:00:00	IWM	ETF	159.43	159.56	159.205	159.33	821312.0
2019-11-20 12:00:00	IWM	ETF	159.34	159.45	158.22	158.53	1838900.0
2019-11-20 13:00:00	IWM	ETF	158.51	158.51	157.26	158.23	4368960.0
2019-11-20 14:00:00	IWM	ETF	158.24	158.79	158.13	158.65	1763568.0
2019-11-20 15:00:00	IWM	ETF	158.64	158.8499	158.38	158.59	2594813.0
2019-11-20 16:00:00	IWM	ETF	158.59	158.77	158.38	158.73	3945037.0
2019-11-20 17:00:00	IWM	ETF	158.66	158.66	158.3	158.32	5525.0
2019-11-20 18:00:00	IWM	ETF	158.2	158.44	157.93	158.4	18274.0
2019-11-20 19:00:00	IWM	ETF	158.4	158.42	157.76	157.76	9302.0
2019-11-20 04:00:00	DIA	ETF	278.0	278.31	278.0	278.31	300.0
2019-11-20 05:00:00	DIA	ETF	278.06	278.06	278.06	278.06	5000.0

> showing 50 of 11,477 rows — these rows as CSV

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