PREVIEW / etf_1hour / 2019-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-29.parquet
  size:    330 KB
  rows:    10,954

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-10-29 04:00:00	SPY	ETF	303.43	303.43	302.95	303.04	7446.0
2019-10-29 05:00:00	SPY	ETF	303.1	303.12	302.84	302.85	15021.0
2019-10-29 06:00:00	SPY	ETF	302.84	303.1	302.84	303.09	16496.0
2019-10-29 07:00:00	SPY	ETF	303.1	303.1	302.63	302.9	84816.0
2019-10-29 08:00:00	SPY	ETF	302.94	303.43	302.61	303.08	181517.0
2019-10-29 09:00:00	SPY	ETF	303.09	303.59	302.86	303.33	5811800.0
2019-10-29 10:00:00	SPY	ETF	303.32	304.23	303.1438	303.98	5832015.0
2019-10-29 11:00:00	SPY	ETF	303.975	304.16	303.06	303.27	7232284.0
2019-10-29 12:00:00	SPY	ETF	303.27	304.02	302.98	303.8001	5165169.0
2019-10-29 13:00:00	SPY	ETF	303.8	303.99	303.72	303.79	3541894.0
2019-10-29 14:00:00	SPY	ETF	303.795	303.8	303.1	303.11	4187628.0
2019-10-29 15:00:00	SPY	ETF	303.11	303.41	302.93	303.2	8986772.0
2019-10-29 16:00:00	SPY	ETF	303.19	303.32	303.02	303.24	2563654.0
2019-10-29 17:00:00	SPY	ETF	303.2	303.29	303.03	303.2	50488.0
2019-10-29 18:00:00	SPY	ETF	303.22	303.37	303.2	303.2	49077.0
2019-10-29 19:00:00	SPY	ETF	303.18	303.23	303.0	303.19	33564.0
2019-10-29 04:00:00	QQQ	ETF	197.43	197.43	197.13	197.24	9900.0
2019-10-29 05:00:00	QQQ	ETF	197.23	197.29	197.0	197.0	16036.0
2019-10-29 06:00:00	QQQ	ETF	197.05	197.17	197.03	197.12	9350.0
2019-10-29 07:00:00	QQQ	ETF	197.19	197.22	196.83	196.96	86597.0
2019-10-29 08:00:00	QQQ	ETF	197.02	197.48	196.75	197.29	98314.0
2019-10-29 09:00:00	QQQ	ETF	197.28	197.535	196.8602	196.97	1714116.0
2019-10-29 10:00:00	QQQ	ETF	196.965	197.3	196.54	196.9	2703675.0
2019-10-29 11:00:00	QQQ	ETF	196.89	197.09	196.04	196.2075	2549083.0
2019-10-29 12:00:00	QQQ	ETF	196.22	196.87	196.01	196.6363	1887299.0
2019-10-29 13:00:00	QQQ	ETF	196.63	196.87	196.49	196.61	728277.0
2019-10-29 14:00:00	QQQ	ETF	196.605	196.605	196.18	196.18	1156350.0
2019-10-29 15:00:00	QQQ	ETF	196.19	196.5	196.02	196.09	3722859.0
2019-10-29 16:00:00	QQQ	ETF	196.07	196.19	196.0	196.11	853040.0
2019-10-29 17:00:00	QQQ	ETF	196.2	196.2	196.05	196.12	14953.0
2019-10-29 18:00:00	QQQ	ETF	196.12	196.27	196.12	196.18	25457.0
2019-10-29 19:00:00	QQQ	ETF	196.14	196.19	196.09	196.17	14456.0
2019-10-29 04:00:00	IWM	ETF	156.05	156.05	156.05	156.05	300.0
2019-10-29 05:00:00	IWM	ETF	156.14	156.14	156.01	156.02	5200.0
2019-10-29 06:00:00	IWM	ETF	155.91	156.02	155.91	156.01	9425.0
2019-10-29 07:00:00	IWM	ETF	156.07	156.07	155.89	156.03	6747.0
2019-10-29 08:00:00	IWM	ETF	155.97	156.13	155.88	156.04	8613.0
2019-10-29 09:00:00	IWM	ETF	156.04	156.57	155.86	156.33	1286439.0
2019-10-29 10:00:00	IWM	ETF	156.33	156.85	156.15	156.8	1276452.0
2019-10-29 11:00:00	IWM	ETF	156.81	157.1	156.57	156.79	1032037.0
2019-10-29 12:00:00	IWM	ETF	156.8	157.29	156.62	157.15	1321214.0
2019-10-29 13:00:00	IWM	ETF	157.15	157.34	157.05	157.29	728646.0
2019-10-29 14:00:00	IWM	ETF	157.29	157.31	156.96	156.96	960457.0
2019-10-29 15:00:00	IWM	ETF	156.96	157.115	156.75	156.86	1952346.0
2019-10-29 16:00:00	IWM	ETF	156.87	156.93	156.74	156.9	1329999.0
2019-10-29 17:00:00	IWM	ETF	156.9	156.9	156.8353	156.8353	3716.0
2019-10-29 18:00:00	IWM	ETF	156.89	156.95	156.85	156.95	5709.0
2019-10-29 19:00:00	IWM	ETF	156.82	156.85	156.8	156.85	2900.0
2019-10-29 04:00:00	DIA	ETF	270.5	270.55	270.5	270.55	710.0
2019-10-29 07:00:00	DIA	ETF	270.66	270.7	270.34	270.45	6070.0

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

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