PREVIEW / etf_1hour / 2019-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-07.parquet
  size:    332 KB
  rows:    11,011

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-01-07 04:00:00	SPY	ETF	252.6	252.72	251.87	251.98	21689.0
2019-01-07 05:00:00	SPY	ETF	251.95	252.34	251.87	252.21	19681.0
2019-01-07 06:00:00	SPY	ETF	252.22	252.25	251.59	252.1	75110.0
2019-01-07 07:00:00	SPY	ETF	252.08	252.58	251.91	252.46	264655.0
2019-01-07 08:00:00	SPY	ETF	252.1301	253.3	251.96	252.08	1185554.0
2019-01-07 09:00:00	SPY	ETF	252.1	252.9	251.69	252.53	9247445.0
2019-01-07 10:00:00	SPY	ETF	252.52	254.2	252.1	253.9101	16352022.0
2019-01-07 11:00:00	SPY	ETF	253.91	255.42	253.73	255.4	15975215.0
2019-01-07 12:00:00	SPY	ETF	255.38	255.67	254.77	255.46	8921726.0
2019-01-07 13:00:00	SPY	ETF	255.47	255.95	254.75	254.84	9106665.0
2019-01-07 14:00:00	SPY	ETF	254.84	255.13	253.93	254.075	9893674.0
2019-01-07 15:00:00	SPY	ETF	254.08	255.17	254.03	254.29	21494919.0
2019-01-07 16:00:00	SPY	ETF	254.27	254.65	245.29	254.6	7910816.0
2019-01-07 17:00:00	SPY	ETF	254.57	254.59	254.38	254.52	110636.0
2019-01-07 18:00:00	SPY	ETF	254.57	254.69	254.2	254.35	707224.0
2019-01-07 19:00:00	SPY	ETF	254.35	255.04	254.33	255.0	95887.0
2019-01-07 04:00:00	QQQ	ETF	156.34	156.47	155.91	156.0	25283.0
2019-01-07 05:00:00	QQQ	ETF	155.95	156.23	155.92	156.16	15476.0
2019-01-07 06:00:00	QQQ	ETF	156.13	156.13	155.6	155.92	48854.0
2019-01-07 07:00:00	QQQ	ETF	155.92	156.43	155.8	156.33	178946.0
2019-01-07 08:00:00	QQQ	ETF	155.9	157.13	155.8499	156.04	470536.0
2019-01-07 09:00:00	QQQ	ETF	156.04	157.069	156.03	156.635	6720031.0
2019-01-07 10:00:00	QQQ	ETF	156.63	157.59	156.2	157.44	7386211.0
2019-01-07 11:00:00	QQQ	ETF	157.44	158.49	157.1	158.45	6716648.0
2019-01-07 12:00:00	QQQ	ETF	158.45	158.69	158.0873	158.57	3266165.0
2019-01-07 13:00:00	QQQ	ETF	158.57	158.86	158.08	158.2	3726822.0
2019-01-07 14:00:00	QQQ	ETF	158.2	158.415	157.55	157.64	3716819.0
2019-01-07 15:00:00	QQQ	ETF	157.64	158.48	157.62	158.0	7477764.0
2019-01-07 16:00:00	QQQ	ETF	158.01	158.15	157.84	158.09	1434586.0
2019-01-07 17:00:00	QQQ	ETF	158.0	158.11	157.95	158.11	16317.0
2019-01-07 18:00:00	QQQ	ETF	158.08	158.17	157.8	157.88	58537.0
2019-01-07 19:00:00	QQQ	ETF	157.93	158.37	157.93	158.35	62296.0
2019-01-07 04:00:00	IWM	ETF	137.14	137.14	136.78	136.78	4828.0
2019-01-07 05:00:00	IWM	ETF	136.94	136.94	136.94	136.94	133.0
2019-01-07 07:00:00	IWM	ETF	136.84	137.1	136.79	137.1	7275.0
2019-01-07 08:00:00	IWM	ETF	136.85	137.48	136.71	136.79	27337.0
2019-01-07 09:00:00	IWM	ETF	136.95	138.04	136.74	137.8	2363819.0
2019-01-07 10:00:00	IWM	ETF	137.81	139.2	137.6	138.98	3426615.0
2019-01-07 11:00:00	IWM	ETF	138.96	140.01	138.82	139.95	3239759.0
2019-01-07 12:00:00	IWM	ETF	139.95	140.05	139.263	139.74	3128782.0
2019-01-07 13:00:00	IWM	ETF	139.73	140.37	139.62	139.7	2436752.0
2019-01-07 14:00:00	IWM	ETF	139.68	139.92	138.89	139.0	3417555.0
2019-01-07 15:00:00	IWM	ETF	138.99	139.83	138.96	139.62	4548857.0
2019-01-07 16:00:00	IWM	ETF	139.62	139.722	137.2256	139.58	1426351.0
2019-01-07 17:00:00	IWM	ETF	139.55	139.6001	139.55	139.59	46407.0
2019-01-07 18:00:00	IWM	ETF	139.6	139.6	139.47	139.59	8020.0
2019-01-07 19:00:00	IWM	ETF	139.69	139.93	139.69	139.89	4440.0
2019-01-07 04:00:00	DIA	ETF	234.26	234.26	234.2	234.2	1981.0
2019-01-07 07:00:00	DIA	ETF	234.23	234.5	234.23	234.5	700.0
2019-01-07 08:00:00	DIA	ETF	233.97	234.64	233.97	234.31	12965.0

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

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