PREVIEW / etf_1hour / 2018-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-12.parquet
  size:    316 KB
  rows:    10,414

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-02-12 04:00:00	SPY	ETF	263.48	265.31	263.48	264.95	88170.0
2018-02-12 05:00:00	SPY	ETF	264.91	264.91	264.29	264.77	85557.0
2018-02-12 06:00:00	SPY	ETF	264.69	264.92	264.25	264.27	100504.0
2018-02-12 07:00:00	SPY	ETF	264.4	265.02	264.27	264.6	635428.0
2018-02-12 08:00:00	SPY	ETF	264.61	264.94	263.22	264.0	967410.0
2018-02-12 09:00:00	SPY	ETF	263.95	265.29	261.5	263.67	16735310.0
2018-02-12 10:00:00	SPY	ETF	263.68	264.66	261.88	263.45	21367247.0
2018-02-12 11:00:00	SPY	ETF	263.44	265.1	262.81	265.07	17097675.0
2018-02-12 12:00:00	SPY	ETF	265.07	265.92	264.69	265.31	10561637.0
2018-02-12 13:00:00	SPY	ETF	265.32	266.61	264.88	266.3	11168791.0
2018-02-12 14:00:00	SPY	ETF	266.31	266.64	265.5047	265.91	11484478.0
2018-02-12 15:00:00	SPY	ETF	265.92	267.01	264.45	265.26	36132674.0
2018-02-12 16:00:00	SPY	ETF	265.24	265.6667	261.6644	265.14	11634543.0
2018-02-12 17:00:00	SPY	ETF	265.15	265.36	265.07	265.17	2557684.0
2018-02-12 18:00:00	SPY	ETF	265.17	265.57	264.81	265.05	445893.0
2018-02-12 19:00:00	SPY	ETF	265.05	265.13	264.56	264.86	57959.0
2018-02-12 04:00:00	QQQ	ETF	156.73	158.2	156.73	158.19	132378.0
2018-02-12 05:00:00	QQQ	ETF	158.04	158.09	157.81	157.95	60780.0
2018-02-12 06:00:00	QQQ	ETF	158.1	158.17	157.67	157.7	86201.0
2018-02-12 07:00:00	QQQ	ETF	157.75	158.17	157.7	157.93	215589.0
2018-02-12 08:00:00	QQQ	ETF	157.93	158.25	156.13	157.6	767243.0
2018-02-12 09:00:00	QQQ	ETF	157.55	158.69	156.1	157.7101	9688808.0
2018-02-12 10:00:00	QQQ	ETF	157.72	158.49	156.46	157.68	9331462.0
2018-02-12 11:00:00	QQQ	ETF	157.68	158.949	157.37	158.94	6241141.0
2018-02-12 12:00:00	QQQ	ETF	158.94	159.26	158.465	158.72	4116482.0
2018-02-12 13:00:00	QQQ	ETF	158.72	159.4	158.24	159.29	5642494.0
2018-02-12 14:00:00	QQQ	ETF	159.29	159.64	158.79	159.2515	4692460.0
2018-02-12 15:00:00	QQQ	ETF	159.26	159.95	158.49	158.93	11085633.0
2018-02-12 16:00:00	QQQ	ETF	158.9	159.19	158.6	158.91	1913442.0
2018-02-12 17:00:00	QQQ	ETF	158.95	159.03	158.87	158.98	934291.0
2018-02-12 18:00:00	QQQ	ETF	159.0	159.23	158.74	158.93	534028.0
2018-02-12 19:00:00	QQQ	ETF	158.92	158.93	158.45	158.72	43683.0
2018-02-12 04:00:00	IWM	ETF	148.0	148.53	148.0	148.16	5791.0
2018-02-12 06:00:00	IWM	ETF	148.33	148.35	148.03	148.12	13373.0
2018-02-12 07:00:00	IWM	ETF	148.11	148.39	147.88	147.95	136473.0
2018-02-12 08:00:00	IWM	ETF	147.9	148.29	146.16	146.41	418549.0
2018-02-12 09:00:00	IWM	ETF	146.4	147.74	145.6	146.6501	5786578.0
2018-02-12 10:00:00	IWM	ETF	146.69	147.01	145.48	146.52	5169822.0
2018-02-12 11:00:00	IWM	ETF	146.51	147.8	146.0	147.79	2934718.0
2018-02-12 12:00:00	IWM	ETF	147.78	148.2	147.46	147.73	2388131.0
2018-02-12 13:00:00	IWM	ETF	147.74	148.79	147.47	148.52	2026600.0
2018-02-12 14:00:00	IWM	ETF	148.51	148.87	148.18	148.36	1774377.0
2018-02-12 15:00:00	IWM	ETF	148.35	148.92	147.66	148.15	6899665.0
2018-02-12 16:00:00	IWM	ETF	148.12	148.39	147.84	147.92	2527285.0
2018-02-12 17:00:00	IWM	ETF	147.97	147.99	147.81	147.93	15951.0
2018-02-12 18:00:00	IWM	ETF	147.99	148.16	147.61	147.67	22800.0
2018-02-12 19:00:00	IWM	ETF	147.78	147.79	147.41	147.61	11300.0
2018-02-12 04:00:00	DIA	ETF	244.5	245.44	243.1	245.0	2905.0
2018-02-12 05:00:00	DIA	ETF	244.94	245.0	244.94	245.0	810.0
2018-02-12 06:00:00	DIA	ETF	244.72	245.0	244.72	244.84	8857.0

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

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