PREVIEW / etf_1hour / 2018-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-08.parquet
  size:    292 KB
  rows:    9,636

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-05-08 04:00:00	SPY	ETF	266.75	266.75	266.13	266.43	9257.0
2018-05-08 05:00:00	SPY	ETF	266.38	266.38	265.88	266.13	14693.0
2018-05-08 06:00:00	SPY	ETF	266.22	266.34	265.86	265.95	35407.0
2018-05-08 07:00:00	SPY	ETF	265.94	266.26	265.77	266.14	124950.0
2018-05-08 08:00:00	SPY	ETF	266.09	267.05	266.0	266.61	321310.0
2018-05-08 09:00:00	SPY	ETF	266.6	266.73	265.86	266.16	6572126.0
2018-05-08 10:00:00	SPY	ETF	266.15	266.87	266.02	266.45	7479065.0
2018-05-08 11:00:00	SPY	ETF	266.45	267.325	266.075	266.43	8412671.0
2018-05-08 12:00:00	SPY	ETF	266.42	266.55	265.65	265.9	5392533.0
2018-05-08 13:00:00	SPY	ETF	265.8934	266.5	265.8	266.02	4631716.0
2018-05-08 14:00:00	SPY	ETF	266.02	266.85	265.15	265.765	12657201.0
2018-05-08 15:00:00	SPY	ETF	265.78	266.9	265.51	266.9	11846218.0
2018-05-08 16:00:00	SPY	ETF	266.89	267.0	266.6283	266.92	8880428.0
2018-05-08 17:00:00	SPY	ETF	266.92	267.0	266.85	266.92	119898.0
2018-05-08 18:00:00	SPY	ETF	266.9	267.18	266.9	267.01	44137.0
2018-05-08 19:00:00	SPY	ETF	267.04	267.06	266.7	266.74	90526.0
2018-05-08 04:00:00	QQQ	ETF	165.85	165.9	165.72	165.88	3100.0
2018-05-08 05:00:00	QQQ	ETF	165.7	165.81	165.61	165.68	5000.0
2018-05-08 06:00:00	QQQ	ETF	165.84	165.94	165.43	165.52	11500.0
2018-05-08 07:00:00	QQQ	ETF	165.57	165.64	165.34	165.57	84067.0
2018-05-08 08:00:00	QQQ	ETF	165.56	166.0	165.34	166.0	122346.0
2018-05-08 09:00:00	QQQ	ETF	166.0	166.1	165.13	165.4201	2953764.0
2018-05-08 10:00:00	QQQ	ETF	165.43	166.01	165.36	165.6	2807772.0
2018-05-08 11:00:00	QQQ	ETF	165.585	166.43	165.41	165.71	3559323.0
2018-05-08 12:00:00	QQQ	ETF	165.69	165.78	165.1	165.31	2135206.0
2018-05-08 13:00:00	QQQ	ETF	165.31	165.88	165.2551	165.46	2513931.0
2018-05-08 14:00:00	QQQ	ETF	165.4699	166.12	164.86	165.295	3758899.0
2018-05-08 15:00:00	QQQ	ETF	165.29	166.01	165.13	166.01	3198573.0
2018-05-08 16:00:00	QQQ	ETF	166.015	166.11	165.89	166.1	1188777.0
2018-05-08 17:00:00	QQQ	ETF	166.09	166.12	166.06	166.1	25269.0
2018-05-08 18:00:00	QQQ	ETF	166.11	166.21	166.07	166.08	12571.0
2018-05-08 19:00:00	QQQ	ETF	166.15	166.15	165.9	165.96	23720.0
2018-05-08 04:00:00	IWM	ETF	156.82	156.84	156.68	156.78	4920.0
2018-05-08 05:00:00	IWM	ETF	156.7	156.75	156.7	156.75	600.0
2018-05-08 06:00:00	IWM	ETF	156.58	156.64	156.58	156.6	9991.0
2018-05-08 07:00:00	IWM	ETF	156.6	156.78	156.54	156.78	9601.0
2018-05-08 08:00:00	IWM	ETF	156.7	157.03	156.65	157.01	92850.0
2018-05-08 09:00:00	IWM	ETF	157.04	157.31	156.75	157.24	1633615.0
2018-05-08 10:00:00	IWM	ETF	157.24	157.715	157.19	157.23	2086791.0
2018-05-08 11:00:00	IWM	ETF	157.21	157.62	156.99	157.34	1438503.0
2018-05-08 12:00:00	IWM	ETF	157.33	157.38	156.81	157.0	1220521.0
2018-05-08 13:00:00	IWM	ETF	156.995	157.55	156.97	157.17	1411968.0
2018-05-08 14:00:00	IWM	ETF	157.17	157.67	156.99	157.37	2483137.0
2018-05-08 15:00:00	IWM	ETF	157.37	157.83	157.2	157.83	3443888.0
2018-05-08 16:00:00	IWM	ETF	157.83	157.97	157.77	157.97	598903.0
2018-05-08 17:00:00	IWM	ETF	157.95	157.99	157.91	157.95	32496.0
2018-05-08 18:00:00	IWM	ETF	157.91	158.09	157.91	158.0	5352.0
2018-05-08 19:00:00	IWM	ETF	158.06	158.06	157.82	157.87	4679.0
2018-05-08 04:00:00	DIA	ETF	243.2	243.2	243.2	243.2	200.0
2018-05-08 05:00:00	DIA	ETF	243.08	243.08	242.6	242.6	300.0

> showing 50 of 9,636 rows — these rows as CSV

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