PREVIEW / etf_1hour / 2018-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-22.parquet
  size:    312 KB
  rows:    10,353

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
2018-10-22 04:00:00	SPY	ETF	276.76	276.91	276.27	276.41	91769.0
2018-10-22 05:00:00	SPY	ETF	276.45	276.77	276.25	276.3	76902.0
2018-10-22 06:00:00	SPY	ETF	276.3	277.01	276.16	276.97	159950.0
2018-10-22 07:00:00	SPY	ETF	276.93	277.47	276.86	277.18	346531.0
2018-10-22 08:00:00	SPY	ETF	277.21	277.47	276.25	276.99	509366.0
2018-10-22 09:00:00	SPY	ETF	276.97	277.36	275.07	275.36	9442065.0
2018-10-22 10:00:00	SPY	ETF	275.36	276.78	274.41	276.395	17100286.0
2018-10-22 11:00:00	SPY	ETF	276.38	276.57	274.89	275.17	10614148.0
2018-10-22 12:00:00	SPY	ETF	275.18	275.83	274.59	275.3799	8918519.0
2018-10-22 13:00:00	SPY	ETF	275.3715	277.19	275.07	275.0838	5630019.0
2018-10-22 14:00:00	SPY	ETF	275.08	275.8	274.94	275.55	7193438.0
2018-10-22 15:00:00	SPY	ETF	275.55	276.1485	275.04	275.06	14355553.0
2018-10-22 16:00:00	SPY	ETF	275.06	276.1	274.73	274.97	6763787.0
2018-10-22 17:00:00	SPY	ETF	274.95	275.01	274.86	274.86	198339.0
2018-10-22 18:00:00	SPY	ETF	274.87	275.01	274.75	274.97	75243.0
2018-10-22 19:00:00	SPY	ETF	275.0	275.02	274.45	274.52	55195.0
2018-10-22 04:00:00	QQQ	ETF	173.72	173.89	173.4	173.45	58083.0
2018-10-22 05:00:00	QQQ	ETF	173.45	173.75	173.38	173.46	20830.0
2018-10-22 06:00:00	QQQ	ETF	173.48	173.97	173.38	173.94	59262.0
2018-10-22 07:00:00	QQQ	ETF	173.85	174.44	173.83	174.27	239864.0
2018-10-22 08:00:00	QQQ	ETF	173.8576	174.4	173.26	174.07	658238.0
2018-10-22 09:00:00	QQQ	ETF	174.04	174.58	172.6	172.9	6407580.0
2018-10-22 10:00:00	QQQ	ETF	172.9	175.2485	172.59	174.87	11099516.0
2018-10-22 11:00:00	QQQ	ETF	174.87	175.17	173.77	174.07	5927456.0
2018-10-22 12:00:00	QQQ	ETF	174.09	174.57	173.49	174.255	5165278.0
2018-10-22 13:00:00	QQQ	ETF	174.23	174.68	173.78	173.78	3179286.0
2018-10-22 14:00:00	QQQ	ETF	173.78	174.441	173.71	174.29	3655425.0
2018-10-22 15:00:00	QQQ	ETF	174.27	174.95	173.91	173.92	8040907.0
2018-10-22 16:00:00	QQQ	ETF	173.93	174.02	173.8	173.97	2202813.0
2018-10-22 17:00:00	QQQ	ETF	173.75	173.95	173.74	173.87	115371.0
2018-10-22 18:00:00	QQQ	ETF	173.87	173.99	173.76	173.99	162764.0
2018-10-22 19:00:00	QQQ	ETF	173.96	173.97	173.55	173.57	63791.0
2018-10-22 04:00:00	IWM	ETF	153.6	153.6	153.4	153.5	9000.0
2018-10-22 05:00:00	IWM	ETF	153.67	153.67	153.46	153.48	7000.0
2018-10-22 06:00:00	IWM	ETF	153.41	153.75	153.35	153.75	9225.0
2018-10-22 07:00:00	IWM	ETF	153.84	154.14	153.82	154.09	61620.0
2018-10-22 08:00:00	IWM	ETF	153.83	154.03	153.83	153.97	99971.0
2018-10-22 09:00:00	IWM	ETF	153.88	154.38	153.39	153.6	3249424.0
2018-10-22 10:00:00	IWM	ETF	153.6	154.45	152.67	154.09	5062400.0
2018-10-22 11:00:00	IWM	ETF	154.081	154.23	153.425	153.68	2191846.0
2018-10-22 12:00:00	IWM	ETF	153.7	153.94	152.73	153.18	1892091.0
2018-10-22 13:00:00	IWM	ETF	153.17	153.69	152.96	152.98	1278714.0
2018-10-22 14:00:00	IWM	ETF	152.96	153.2	152.52	153.08	2466226.0
2018-10-22 15:00:00	IWM	ETF	153.08	153.61	152.94	153.01	5212956.0
2018-10-22 16:00:00	IWM	ETF	152.9707	153.07	152.9	153.03	925075.0
2018-10-22 17:00:00	IWM	ETF	153.09	153.2202	152.97	152.97	177267.0
2018-10-22 18:00:00	IWM	ETF	153.03	153.05	153.03	153.05	799250.0
2018-10-22 19:00:00	IWM	ETF	153.04	153.04	152.78	152.87	3650.0
2018-10-22 04:00:00	DIA	ETF	254.83	254.83	254.68	254.68	2400.0
2018-10-22 06:00:00	DIA	ETF	254.41	254.97	254.41	254.97	1200.0

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

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