PREVIEW / etf_1hour / 2017-04-27

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-04-27.parquet
  size:    273 KB
  rows:    8,869

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
2017-04-27 04:00:00	SPY	ETF	238.4	238.41	238.33	238.33	2752.0
2017-04-27 05:00:00	SPY	ETF	238.28	238.38	238.28	238.37	8506.0
2017-04-27 06:00:00	SPY	ETF	238.36	238.49	238.31	238.44	17117.0
2017-04-27 07:00:00	SPY	ETF	238.44	238.73	238.43	238.6	327888.0
2017-04-27 08:00:00	SPY	ETF	238.6	238.75	238.37	238.56	789582.0
2017-04-27 09:00:00	SPY	ETF	238.57	238.8	238.37	238.585	5717935.0
2017-04-27 10:00:00	SPY	ETF	238.59	238.84	238.03	238.2208	9175902.0
2017-04-27 11:00:00	SPY	ETF	238.23	238.39	237.98	238.11	7106750.0
2017-04-27 12:00:00	SPY	ETF	238.11	238.94	238.1015	238.93	5417802.0
2017-04-27 13:00:00	SPY	ETF	238.93	238.95	238.635	238.68	4839319.0
2017-04-27 14:00:00	SPY	ETF	238.68	238.81	238.55	238.72	3608728.0
2017-04-27 15:00:00	SPY	ETF	238.715	238.72	238.41	238.61	9179154.0
2017-04-27 16:00:00	SPY	ETF	238.61	238.86	238.52	238.82	10120086.0
2017-04-27 17:00:00	SPY	ETF	238.8	238.83	238.6	238.72	196293.0
2017-04-27 18:00:00	SPY	ETF	238.71	238.74	238.56	238.67	137164.0
2017-04-27 19:00:00	SPY	ETF	238.67	238.69	238.58	238.6	65883.0
2017-04-27 05:00:00	QQQ	ETF	134.94	134.96	134.94	134.96	499.0
2017-04-27 06:00:00	QQQ	ETF	134.95	135.0	134.95	135.0	1932.0
2017-04-27 07:00:00	QQQ	ETF	135.05	135.21	135.05	135.15	45968.0
2017-04-27 08:00:00	QQQ	ETF	135.15	135.19	135.06	135.12	53074.0
2017-04-27 09:00:00	QQQ	ETF	135.17	135.451	135.15	135.42	2189837.0
2017-04-27 10:00:00	QQQ	ETF	135.42	135.61	135.325	135.41	2119602.0
2017-04-27 11:00:00	QQQ	ETF	135.4	135.54	135.35	135.47	1356560.0
2017-04-27 12:00:00	QQQ	ETF	135.48	135.68	135.41	135.67	1137518.0
2017-04-27 13:00:00	QQQ	ETF	135.6607	135.68	135.56	135.5762	1000650.0
2017-04-27 14:00:00	QQQ	ETF	135.57	135.65	135.48	135.62	920113.0
2017-04-27 15:00:00	QQQ	ETF	135.62	135.75	135.451	135.73	3584089.0
2017-04-27 16:00:00	QQQ	ETF	135.73	136.41	135.61	136.11	2101074.0
2017-04-27 17:00:00	QQQ	ETF	136.1	136.15	136.05	136.1	73268.0
2017-04-27 18:00:00	QQQ	ETF	136.07	136.15	136.03	136.15	31355.0
2017-04-27 19:00:00	QQQ	ETF	136.14	136.16	136.11	136.15	57623.0
2017-04-27 05:00:00	IWM	ETF	141.01	141.01	141.01	141.01	200.0
2017-04-27 06:00:00	IWM	ETF	141.02	141.02	141.02	141.02	100.0
2017-04-27 07:00:00	IWM	ETF	141.09	141.28	141.09	141.18	25939.0
2017-04-27 08:00:00	IWM	ETF	141.24	141.52	141.17	141.41	152405.0
2017-04-27 09:00:00	IWM	ETF	141.45	141.8	141.0	141.29	3483779.0
2017-04-27 10:00:00	IWM	ETF	141.29	141.51	140.69	140.83	3605563.0
2017-04-27 11:00:00	IWM	ETF	140.82	141.03	140.48	140.55	2058031.0
2017-04-27 12:00:00	IWM	ETF	140.56	141.27	140.56	141.26	1959789.0
2017-04-27 13:00:00	IWM	ETF	141.26	141.31	140.93	140.98	978542.0
2017-04-27 14:00:00	IWM	ETF	140.97	141.14	140.84	141.01	904901.0
2017-04-27 15:00:00	IWM	ETF	141.01	141.03	140.78	140.95	3619107.0
2017-04-27 16:00:00	IWM	ETF	140.95	141.33	140.8661	141.29	3019243.0
2017-04-27 17:00:00	IWM	ETF	141.29	141.29	141.21	141.29	1150.0
2017-04-27 18:00:00	IWM	ETF	141.2	141.2	141.13	141.13	2095.0
2017-04-27 19:00:00	IWM	ETF	141.24	141.25	141.16	141.23	15123.0
2017-04-27 05:00:00	DIA	ETF	209.41	209.41	209.41	209.41	100.0
2017-04-27 07:00:00	DIA	ETF	209.58	209.64	209.58	209.63	700.0
2017-04-27 08:00:00	DIA	ETF	209.53	209.81	209.53	209.54	8016.0
2017-04-27 09:00:00	DIA	ETF	209.58	209.75	209.46	209.525	212645.0

> showing 50 of 8,869 rows — these rows as CSV

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