PREVIEW / etf_1hour / 2019-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-03.parquet
  size:    337 KB
  rows:    11,155

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-06-03 04:00:00	SPY	ETF	273.65	274.24	273.65	274.24	45036.0
2019-06-03 05:00:00	SPY	ETF	274.27	274.64	274.27	274.62	41854.0
2019-06-03 06:00:00	SPY	ETF	274.64	274.84	274.37	274.42	110593.0
2019-06-03 07:00:00	SPY	ETF	274.47	274.93	274.45	274.66	626264.0
2019-06-03 08:00:00	SPY	ETF	274.7	275.19	273.81	275.19	703375.0
2019-06-03 09:00:00	SPY	ETF	275.18	276.17	274.55	274.6	9902090.0
2019-06-03 10:00:00	SPY	ETF	274.58	276.5521	274.0	276.32	13468806.0
2019-06-03 11:00:00	SPY	ETF	276.31	276.41	275.08	275.14	8006226.0
2019-06-03 12:00:00	SPY	ETF	275.13	275.29	273.74	274.03	10725547.0
2019-06-03 13:00:00	SPY	ETF	274.03	275.86	273.68	274.92	14937922.0
2019-06-03 14:00:00	SPY	ETF	274.92	275.5	273.75	274.02	8386197.0
2019-06-03 15:00:00	SPY	ETF	274.02	274.86	273.09	274.58	21356274.0
2019-06-03 16:00:00	SPY	ETF	274.59	275.6	274.35	275.53	6511200.0
2019-06-03 17:00:00	SPY	ETF	275.57	275.59	274.57	275.59	308656.0
2019-06-03 18:00:00	SPY	ETF	275.58	275.74	274.57	275.46	104466.0
2019-06-03 19:00:00	SPY	ETF	275.5	275.64	275.22	275.3	103916.0
2019-06-03 04:00:00	QQQ	ETF	172.55	172.9	172.5	172.8	112596.0
2019-06-03 05:00:00	QQQ	ETF	172.89	173.17	172.84	173.12	72915.0
2019-06-03 06:00:00	QQQ	ETF	173.1	173.32	172.88	172.94	174176.0
2019-06-03 07:00:00	QQQ	ETF	172.98	173.29	172.91	173.12	479970.0
2019-06-03 08:00:00	QQQ	ETF	173.02	173.95	172.6	173.49	267729.0
2019-06-03 09:00:00	QQQ	ETF	173.48	173.95	171.97	171.97	7982143.0
2019-06-03 10:00:00	QQQ	ETF	171.97	172.93	171.405	172.876	10454213.0
2019-06-03 11:00:00	QQQ	ETF	172.87	173.05	172.06	172.15	5060001.0
2019-06-03 12:00:00	QQQ	ETF	172.15	172.27	170.54	170.79	7450681.0
2019-06-03 13:00:00	QQQ	ETF	170.79	171.92	169.91	170.7899	11143978.0
2019-06-03 14:00:00	QQQ	ETF	170.79	171.22	169.86	170.09	6547554.0
2019-06-03 15:00:00	QQQ	ETF	170.1	170.41	169.27	170.21	14263567.0
2019-06-03 16:00:00	QQQ	ETF	170.2	171.0086	170.12	170.93	2919651.0
2019-06-03 17:00:00	QQQ	ETF	170.92	170.98	170.12	170.88	90153.0
2019-06-03 18:00:00	QQQ	ETF	170.92	171.0	170.12	170.83	39597.0
2019-06-03 19:00:00	QQQ	ETF	170.83	171.01	170.65	170.74	98694.0
2019-06-03 04:00:00	IWM	ETF	145.15	145.15	145.03	145.12	6400.0
2019-06-03 05:00:00	IWM	ETF	145.53	145.6	145.41	145.6	1700.0
2019-06-03 06:00:00	IWM	ETF	145.82	145.82	145.58	145.58	500.0
2019-06-03 07:00:00	IWM	ETF	145.58	145.81	145.58	145.7	15215.0
2019-06-03 08:00:00	IWM	ETF	145.69	145.9	145.63	145.9	60481.0
2019-06-03 09:00:00	IWM	ETF	145.96	146.6	145.91	145.98	2741671.0
2019-06-03 10:00:00	IWM	ETF	145.96	147.17	145.62	147.12	4540631.0
2019-06-03 11:00:00	IWM	ETF	147.12	147.205	146.19	146.3	2012883.0
2019-06-03 12:00:00	IWM	ETF	146.28	146.43	145.33	145.75	2418691.0
2019-06-03 13:00:00	IWM	ETF	145.75	146.87	145.42	146.72	3417775.0
2019-06-03 14:00:00	IWM	ETF	146.73	147.12	146.24	146.43	2243093.0
2019-06-03 15:00:00	IWM	ETF	146.41	146.64	145.62	146.33	5206487.0
2019-06-03 16:00:00	IWM	ETF	146.37	146.95	146.35	146.95	1201432.0
2019-06-03 17:00:00	IWM	ETF	146.84	146.95	146.8	146.95	9023.0
2019-06-03 18:00:00	IWM	ETF	146.97	147.06	146.37	146.9	8986.0
2019-06-03 19:00:00	IWM	ETF	146.89	146.94	146.85	146.87	3170.0
2019-06-03 04:00:00	DIA	ETF	246.72	246.99	246.7	246.99	1550.0
2019-06-03 05:00:00	DIA	ETF	247.45	247.45	247.45	247.45	500.0

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

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