PREVIEW / etf_1hour / 2019-07-02

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-02.parquet
  size:    330 KB
  rows:    10,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
2019-07-02 04:00:00	SPY	ETF	295.2	295.2	294.95	295.14	5706.0
2019-07-02 05:00:00	SPY	ETF	295.19	295.31	295.06	295.16	21474.0
2019-07-02 06:00:00	SPY	ETF	295.16	295.43	295.16	295.4	11660.0
2019-07-02 07:00:00	SPY	ETF	295.34	295.5	295.17	295.37	75105.0
2019-07-02 08:00:00	SPY	ETF	295.41	295.96	295.24	295.4	474005.0
2019-07-02 09:00:00	SPY	ETF	295.34	295.69	295.13	295.29	5293409.0
2019-07-02 10:00:00	SPY	ETF	295.3	296.15	295.24	295.8765	7193210.0
2019-07-02 11:00:00	SPY	ETF	295.87	295.96	294.98	295.44	8399923.0
2019-07-02 12:00:00	SPY	ETF	295.43	295.53	294.68	295.0873	7171860.0
2019-07-02 13:00:00	SPY	ETF	295.08	295.67	294.905	295.5665	5259169.0
2019-07-02 14:00:00	SPY	ETF	295.57	295.88	295.44	295.52	7179299.0
2019-07-02 15:00:00	SPY	ETF	295.52	296.49	295.45	296.46	12882395.0
2019-07-02 16:00:00	SPY	ETF	296.46	296.84	296.1257	296.7	6345976.0
2019-07-02 17:00:00	SPY	ETF	296.71	296.78	296.66	296.73	387241.0
2019-07-02 18:00:00	SPY	ETF	296.72	296.79	296.5	296.61	76112.0
2019-07-02 19:00:00	SPY	ETF	296.64	296.74	296.53	296.61	46931.0
2019-07-02 04:00:00	QQQ	ETF	188.85	188.86	188.56	188.7	14474.0
2019-07-02 05:00:00	QQQ	ETF	188.7	188.8	188.66	188.68	6442.0
2019-07-02 06:00:00	QQQ	ETF	188.64	188.95	188.64	188.84	11836.0
2019-07-02 07:00:00	QQQ	ETF	188.85	188.94	188.71	188.91	62238.0
2019-07-02 08:00:00	QQQ	ETF	188.94	189.35	188.79	189.04	47980.0
2019-07-02 09:00:00	QQQ	ETF	189.03	189.33	188.8725	189.08	1660653.0
2019-07-02 10:00:00	QQQ	ETF	189.08	189.61	188.96	189.43	2519924.0
2019-07-02 11:00:00	QQQ	ETF	189.43	189.55	188.85	189.07	1922785.0
2019-07-02 12:00:00	QQQ	ETF	189.06	189.24	188.66	188.88	2056430.0
2019-07-02 13:00:00	QQQ	ETF	188.87	189.3	188.74	189.22	1241810.0
2019-07-02 14:00:00	QQQ	ETF	189.22	189.47	189.15	189.33	1312892.0
2019-07-02 15:00:00	QQQ	ETF	189.33	190.03	189.26	190.02	4400617.0
2019-07-02 16:00:00	QQQ	ETF	190.02	190.44	189.87	190.37	735277.0
2019-07-02 17:00:00	QQQ	ETF	190.36	190.42	190.3	190.33	14221.0
2019-07-02 18:00:00	QQQ	ETF	190.33	190.34	190.22	190.26	37784.0
2019-07-02 19:00:00	QQQ	ETF	190.26	190.35	190.18	190.24	49010.0
2019-07-02 04:00:00	IWM	ETF	155.75	155.82	155.68	155.79	4300.0
2019-07-02 05:00:00	IWM	ETF	155.87	155.9	155.78	155.79	8900.0
2019-07-02 06:00:00	IWM	ETF	155.97	155.97	155.94	155.94	1100.0
2019-07-02 07:00:00	IWM	ETF	155.94	155.94	155.82	155.93	20600.0
2019-07-02 08:00:00	IWM	ETF	155.9	156.29	155.86	155.9	22546.0
2019-07-02 09:00:00	IWM	ETF	155.9	156.1175	155.34	155.51	1740058.0
2019-07-02 10:00:00	IWM	ETF	155.5	155.78	155.21	155.285	2314850.0
2019-07-02 11:00:00	IWM	ETF	155.28	155.35	154.42	154.67	2092454.0
2019-07-02 12:00:00	IWM	ETF	154.66	155.17	154.508	154.71	1368967.0
2019-07-02 13:00:00	IWM	ETF	154.7	154.89	154.5	154.59	1290740.0
2019-07-02 14:00:00	IWM	ETF	154.59	154.79	154.26	154.345	1775548.0
2019-07-02 15:00:00	IWM	ETF	154.35	155.19	154.27	155.18	3940943.0
2019-07-02 16:00:00	IWM	ETF	155.19	155.45	155.0	155.34	972820.0
2019-07-02 17:00:00	IWM	ETF	155.31	155.45	155.1348	155.45	18496.0
2019-07-02 18:00:00	IWM	ETF	155.4	155.4	155.24	155.24	23701.0
2019-07-02 19:00:00	IWM	ETF	155.36	155.36	155.3	155.3	2540.0
2019-07-02 04:00:00	DIA	ETF	266.57	266.57	266.57	266.57	200.0
2019-07-02 07:00:00	DIA	ETF	266.7	266.7	266.7	266.7	250.0

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

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