PREVIEW / etf_1hour / 2019-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-31.parquet
  size:    339 KB
  rows:    11,087

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-31 04:00:00	SPY	ETF	304.63	304.81	304.54	304.62	21785.0
2019-10-31 05:00:00	SPY	ETF	304.64	304.64	303.1	303.45	53045.0
2019-10-31 06:00:00	SPY	ETF	303.31	303.7	303.3	303.55	57687.0
2019-10-31 07:00:00	SPY	ETF	303.66	303.75	303.25	303.51	182105.0
2019-10-31 08:00:00	SPY	ETF	303.47	304.51	303.3	303.97	440508.0
2019-10-31 09:00:00	SPY	ETF	303.93	304.29	303.26	303.28	6343710.0
2019-10-31 10:00:00	SPY	ETF	303.27	303.2861	301.73	302.8	11463491.0
2019-10-31 11:00:00	SPY	ETF	302.81	303.02	302.35	302.675	6541458.0
2019-10-31 12:00:00	SPY	ETF	302.68	302.783	301.85	302.2	7056573.0
2019-10-31 13:00:00	SPY	ETF	302.21	302.68	302.11	302.36	3498516.0
2019-10-31 14:00:00	SPY	ETF	302.35	302.47	301.85	302.32	6337669.0
2019-10-31 15:00:00	SPY	ETF	302.31	303.39	302.21	303.26	16411388.0
2019-10-31 16:00:00	SPY	ETF	303.29	303.53	303.18	303.26	8693681.0
2019-10-31 17:00:00	SPY	ETF	303.26	303.36	303.22	303.34	422726.0
2019-10-31 18:00:00	SPY	ETF	303.33	303.33	303.07	303.14	76787.0
2019-10-31 19:00:00	SPY	ETF	303.13	303.3	303.1	303.2	18333.0
2019-10-31 04:00:00	QQQ	ETF	197.94	198.13	197.85	197.96	64544.0
2019-10-31 05:00:00	QQQ	ETF	197.96	198.01	196.81	197.04	68480.0
2019-10-31 06:00:00	QQQ	ETF	197.06	197.26	196.94	197.2	49700.0
2019-10-31 07:00:00	QQQ	ETF	197.24	197.25	196.9	197.08	70991.0
2019-10-31 08:00:00	QQQ	ETF	197.23	197.93	196.9201	197.46	189767.0
2019-10-31 09:00:00	QQQ	ETF	197.39	197.65	196.91	196.93	4301056.0
2019-10-31 10:00:00	QQQ	ETF	196.9346	197.08	195.94	196.83	5338915.0
2019-10-31 11:00:00	QQQ	ETF	196.83	197.15	196.66	196.705	2894541.0
2019-10-31 12:00:00	QQQ	ETF	196.71	196.79	196.21	196.4	1715527.0
2019-10-31 13:00:00	QQQ	ETF	196.41	196.785	196.35	196.5	1312756.0
2019-10-31 14:00:00	QQQ	ETF	196.49	196.51	196.11	196.48	1329338.0
2019-10-31 15:00:00	QQQ	ETF	196.49	197.09	196.43	197.03	4373209.0
2019-10-31 16:00:00	QQQ	ETF	197.04	197.25	196.9865	197.08	1244556.0
2019-10-31 17:00:00	QQQ	ETF	197.09	197.15	197.07	197.11	24735.0
2019-10-31 18:00:00	QQQ	ETF	197.11	197.14	196.94	196.97	66824.0
2019-10-31 19:00:00	QQQ	ETF	196.96	197.13	196.94	197.04	24606.0
2019-10-31 04:00:00	IWM	ETF	156.64	156.64	156.64	156.64	123.0
2019-10-31 05:00:00	IWM	ETF	156.48	156.48	155.66	155.66	8900.0
2019-10-31 06:00:00	IWM	ETF	155.66	155.71	155.61	155.71	2700.0
2019-10-31 07:00:00	IWM	ETF	155.9	155.91	155.75	155.75	9697.0
2019-10-31 08:00:00	IWM	ETF	155.77	156.15	155.75	156.13	39973.0
2019-10-31 09:00:00	IWM	ETF	156.11	156.2	155.11	155.37	1911743.0
2019-10-31 10:00:00	IWM	ETF	155.35	155.35	154.24	155.03	2701190.0
2019-10-31 11:00:00	IWM	ETF	155.0368	155.22	154.67	155.04	1423930.0
2019-10-31 12:00:00	IWM	ETF	155.02	155.12	154.29	154.49	911890.0
2019-10-31 13:00:00	IWM	ETF	154.47	154.73	154.41	154.57	969400.0
2019-10-31 14:00:00	IWM	ETF	154.57	154.85	154.4493	154.81	1492262.0
2019-10-31 15:00:00	IWM	ETF	154.81	155.5	154.78	155.41	3948045.0
2019-10-31 16:00:00	IWM	ETF	155.42	155.69	155.4	155.45	2425720.0
2019-10-31 17:00:00	IWM	ETF	155.45	155.46	155.45	155.46	20100.0
2019-10-31 18:00:00	IWM	ETF	155.55	155.55	155.3	155.36	15900.0
2019-10-31 19:00:00	IWM	ETF	155.33	155.44	155.33	155.43	2600.0
2019-10-31 04:00:00	DIA	ETF	272.2	272.2	272.17	272.17	558.0
2019-10-31 05:00:00	DIA	ETF	271.94	271.94	270.95	270.95	1000.0

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

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