PREVIEW / etf_1hour / 2018-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-27.parquet
  size:    283 KB
  rows:    9,310

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-04-27 04:00:00	SPY	ETF	266.66	266.68	266.4	266.47	10725.0
2018-04-27 05:00:00	SPY	ETF	266.46	266.65	266.25	266.65	25771.0
2018-04-27 06:00:00	SPY	ETF	266.65	266.91	266.62	266.64	21004.0
2018-04-27 07:00:00	SPY	ETF	266.69	266.93	266.56	266.92	154770.0
2018-04-27 08:00:00	SPY	ETF	266.86	267.1899	266.62	267.17	730550.0
2018-04-27 09:00:00	SPY	ETF	267.17	267.34	266.37	266.48	7769027.0
2018-04-27 10:00:00	SPY	ETF	266.46	267.03	265.5	265.88	10754296.0
2018-04-27 11:00:00	SPY	ETF	265.87	266.73	265.8	266.19	5525524.0
2018-04-27 12:00:00	SPY	ETF	266.2	267.07	266.06	266.95	4661261.0
2018-04-27 13:00:00	SPY	ETF	266.95	267.11	266.4469	266.56	3836834.0
2018-04-27 14:00:00	SPY	ETF	266.57	266.83	266.35	266.73	4315319.0
2018-04-27 15:00:00	SPY	ETF	266.72	267.02	266.31	266.58	11425797.0
2018-04-27 16:00:00	SPY	ETF	266.57	266.94	266.56	266.86	6496467.0
2018-04-27 17:00:00	SPY	ETF	266.87	266.87	266.56	266.66	364593.0
2018-04-27 18:00:00	SPY	ETF	266.69	266.71	266.62	266.62	7869.0
2018-04-27 19:00:00	SPY	ETF	266.63	266.63	266.54	266.55	13728.0
2018-04-27 04:00:00	QQQ	ETF	164.17	164.18	164.0	164.09	11588.0
2018-04-27 05:00:00	QQQ	ETF	164.07	164.13	163.89	164.13	8763.0
2018-04-27 06:00:00	QQQ	ETF	164.1	164.32	164.1	164.18	4842.0
2018-04-27 07:00:00	QQQ	ETF	164.15	164.35	164.01	164.35	166915.0
2018-04-27 08:00:00	QQQ	ETF	164.32	164.76	164.12	164.75	645393.0
2018-04-27 09:00:00	QQQ	ETF	164.75	164.79	162.4036	162.55	9963520.0
2018-04-27 10:00:00	QQQ	ETF	162.55	163.13	161.17	161.57	10879180.0
2018-04-27 11:00:00	QQQ	ETF	161.56	162.5775	161.5	161.95	5323794.0
2018-04-27 12:00:00	QQQ	ETF	161.95	162.41	161.49	162.26	2983593.0
2018-04-27 13:00:00	QQQ	ETF	162.28	162.509	161.83	161.9	2789680.0
2018-04-27 14:00:00	QQQ	ETF	161.91	162.41	161.735	162.07	2410893.0
2018-04-27 15:00:00	QQQ	ETF	162.07	162.38	161.76	162.11	6149091.0
2018-04-27 16:00:00	QQQ	ETF	162.1	162.39	162.09	162.34	2049931.0
2018-04-27 17:00:00	QQQ	ETF	162.38	162.38	162.2	162.2	4624.0
2018-04-27 18:00:00	QQQ	ETF	162.2	162.25	162.12	162.12	1836.0
2018-04-27 19:00:00	QQQ	ETF	162.18	162.18	162.01	162.01	1300.0
2018-04-27 04:00:00	IWM	ETF	154.75	154.75	154.55	154.59	4916.0
2018-04-27 05:00:00	IWM	ETF	154.51	154.56	154.45	154.46	6200.0
2018-04-27 07:00:00	IWM	ETF	154.62	154.81	154.62	154.8	16503.0
2018-04-27 08:00:00	IWM	ETF	154.81	154.97	154.77	154.92	105655.0
2018-04-27 09:00:00	IWM	ETF	154.96	155.37	154.83	155.11	1781808.0
2018-04-27 10:00:00	IWM	ETF	155.1	155.33	153.78	154.08	3022751.0
2018-04-27 11:00:00	IWM	ETF	154.05	154.61	154.04	154.31	1491746.0
2018-04-27 12:00:00	IWM	ETF	154.31	154.91	154.2599	154.87	1062040.0
2018-04-27 13:00:00	IWM	ETF	154.88	155.01	154.695	154.7585	782791.0
2018-04-27 14:00:00	IWM	ETF	154.75	154.91	154.61	154.77	720010.0
2018-04-27 15:00:00	IWM	ETF	154.77	154.93	154.5	154.69	2681338.0
2018-04-27 16:00:00	IWM	ETF	154.69	154.88	154.67	154.71	3311819.0
2018-04-27 17:00:00	IWM	ETF	154.84	154.84	154.72	154.72	2400.0
2018-04-27 18:00:00	IWM	ETF	154.72	154.72	154.72	154.72	100.0
2018-04-27 19:00:00	IWM	ETF	154.72	154.72	154.62	154.62	2284.0
2018-04-27 05:00:00	DIA	ETF	242.5	242.5	242.5	242.5	200.0
2018-04-27 07:00:00	DIA	ETF	242.66	242.8	242.44	242.76	72709.0
2018-04-27 08:00:00	DIA	ETF	242.72	243.22	242.67	243.2	26651.0

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

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