PREVIEW / etf_1hour / 2019-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-05.parquet
  size:    337 KB
  rows:    11,032

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-12-05 04:00:00	SPY	ETF	311.92	312.1	311.63	312.1	10805.0
2019-12-05 05:00:00	SPY	ETF	312.12	312.62	311.99	312.39	29234.0
2019-12-05 06:00:00	SPY	ETF	312.41	312.67	312.39	312.49	32993.0
2019-12-05 07:00:00	SPY	ETF	312.44	312.53	312.26	312.36	85645.0
2019-12-05 08:00:00	SPY	ETF	312.32	312.51	311.22	312.16	339489.0
2019-12-05 09:00:00	SPY	ETF	312.21	312.25	311.35	311.45	3501988.0
2019-12-05 10:00:00	SPY	ETF	311.43	311.48	310.58	311.36	6317917.0
2019-12-05 11:00:00	SPY	ETF	311.36	311.61	311.04	311.2961	3125588.0
2019-12-05 12:00:00	SPY	ETF	311.29	311.49	311.06	311.25	1989898.0
2019-12-05 13:00:00	SPY	ETF	311.25	311.72	311.17	311.57	4251145.0
2019-12-05 14:00:00	SPY	ETF	311.57	311.99	311.11	311.58	6761248.0
2019-12-05 15:00:00	SPY	ETF	311.59	312.2	311.54	312.04	10370703.0
2019-12-05 16:00:00	SPY	ETF	312.05	312.12	311.91	312.04	3178946.0
2019-12-05 17:00:00	SPY	ETF	312.05	312.06	311.96	312.01	39484.0
2019-12-05 18:00:00	SPY	ETF	312.03	312.15	311.98	312.1	62229.0
2019-12-05 19:00:00	SPY	ETF	312.15	312.52	312.15	312.45	58533.0
2019-12-05 04:00:00	QQQ	ETF	202.84	202.95	202.6	202.9	21014.0
2019-12-05 05:00:00	QQQ	ETF	202.91	203.36	202.86	203.21	26952.0
2019-12-05 06:00:00	QQQ	ETF	203.23	203.45	203.17	203.27	18387.0
2019-12-05 07:00:00	QQQ	ETF	203.28	203.4	203.13	203.24	80960.0
2019-12-05 08:00:00	QQQ	ETF	203.16	203.36	202.25	203.1	195134.0
2019-12-05 09:00:00	QQQ	ETF	203.14	203.15	202.56	202.64	1739033.0
2019-12-05 10:00:00	QQQ	ETF	202.64	202.66	201.84	202.31	2216660.0
2019-12-05 11:00:00	QQQ	ETF	202.3	202.4875	202.07	202.32	1168172.0
2019-12-05 12:00:00	QQQ	ETF	202.3	202.43	202.13	202.2645	570369.0
2019-12-05 13:00:00	QQQ	ETF	202.26	202.5596	202.2252	202.5	779634.0
2019-12-05 14:00:00	QQQ	ETF	202.49	202.81	202.14	202.5	1746554.0
2019-12-05 15:00:00	QQQ	ETF	202.5	202.88	202.45	202.79	1858143.0
2019-12-05 16:00:00	QQQ	ETF	202.79	202.84	202.66	202.76	591480.0
2019-12-05 17:00:00	QQQ	ETF	202.79	202.83	202.72	202.79	6038.0
2019-12-05 18:00:00	QQQ	ETF	202.78	202.87	202.7	202.87	19185.0
2019-12-05 19:00:00	QQQ	ETF	202.94	203.16	202.9	203.13	62424.0
2019-12-05 04:00:00	IWM	ETF	161.05	161.06	161.0	161.0	1800.0
2019-12-05 05:00:00	IWM	ETF	161.19	161.5	161.19	161.4	12600.0
2019-12-05 06:00:00	IWM	ETF	161.39	161.57	161.39	161.5	9290.0
2019-12-05 07:00:00	IWM	ETF	161.42	161.5	161.34	161.36	44867.0
2019-12-05 08:00:00	IWM	ETF	161.4401	161.4401	160.92	161.31	15838.0
2019-12-05 09:00:00	IWM	ETF	161.27	161.65	160.96	161.03	1097102.0
2019-12-05 10:00:00	IWM	ETF	161.01	161.22	160.49	161.08	1530952.0
2019-12-05 11:00:00	IWM	ETF	161.07	161.33	160.95	161.0152	678074.0
2019-12-05 12:00:00	IWM	ETF	161.02	161.15	160.69	160.74	795056.0
2019-12-05 13:00:00	IWM	ETF	160.74	160.98	160.67	160.715	695800.0
2019-12-05 14:00:00	IWM	ETF	160.71	160.95	160.45	160.65	1408298.0
2019-12-05 15:00:00	IWM	ETF	160.655	161.04	160.65	160.93	1462837.0
2019-12-05 16:00:00	IWM	ETF	160.94	161.11	160.7683	161.11	1091260.0
2019-12-05 17:00:00	IWM	ETF	161.1	161.1	161.1	161.1	400.0
2019-12-05 18:00:00	IWM	ETF	161.06	161.15	160.94	161.09	19028.0
2019-12-05 19:00:00	IWM	ETF	161.18	161.34	161.16	161.34	14700.0
2019-12-05 04:00:00	DIA	ETF	277.41	277.41	277.41	277.41	117.0
2019-12-05 06:00:00	DIA	ETF	278.08	278.08	278.06	278.06	202.0

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

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