PREVIEW / etf_1hour / 2016-01-05

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-01-05.parquet
  size:    250 KB
  rows:    7,937

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
2016-01-05 04:00:00	SPY	ETF	201.14	201.14	200.33	200.61	23084.0
2016-01-05 05:00:00	SPY	ETF	200.34	200.34	199.82	200.22	284429.0
2016-01-05 06:00:00	SPY	ETF	200.2	200.33	200.01	200.14	91823.0
2016-01-05 07:00:00	SPY	ETF	200.36	200.54	200.03	200.54	401328.0
2016-01-05 08:00:00	SPY	ETF	199.93	202.225	199.93	201.31	1432685.0
2016-01-05 09:00:00	SPY	ETF	201.3	201.8	200.89	200.92	12524792.0
2016-01-05 10:00:00	SPY	ETF	200.92	201.49	200.35	201.3099	14264157.0
2016-01-05 11:00:00	SPY	ETF	201.3	201.435	200.6	200.88	11030071.0
2016-01-05 12:00:00	SPY	ETF	200.8814	200.89	200.05	200.6	10276406.0
2016-01-05 13:00:00	SPY	ETF	200.6	201.49	200.31	201.28	11404331.0
2016-01-05 14:00:00	SPY	ETF	201.2892	201.9	201.05	201.35	15090958.0
2016-01-05 15:00:00	SPY	ETF	201.34	201.68	200.78	201.43	22635184.0
2016-01-05 16:00:00	SPY	ETF	201.43	201.75	201.3	201.52	9370821.0
2016-01-05 17:00:00	SPY	ETF	201.56	201.56	201.49	201.55	163134.0
2016-01-05 18:00:00	SPY	ETF	201.58	201.7	201.56	201.59	273925.0
2016-01-05 19:00:00	SPY	ETF	201.57	201.76	201.45	201.65	116124.0
2016-01-05 04:00:00	QQQ	ETF	109.5	109.5	109.27	109.33	3300.0
2016-01-05 05:00:00	QQQ	ETF	109.27	109.27	109.02	109.13	1618.0
2016-01-05 06:00:00	QQQ	ETF	109.09	109.21	109.08	109.17	4668.0
2016-01-05 07:00:00	QQQ	ETF	109.29	109.35	109.18	109.35	110150.0
2016-01-05 08:00:00	QQQ	ETF	109.39	109.92	109.28	109.85	207115.0
2016-01-05 09:00:00	QQQ	ETF	109.82	110.18	109.51	109.52	5278279.0
2016-01-05 10:00:00	QQQ	ETF	109.53	109.95	109.25	109.8	5624015.0
2016-01-05 11:00:00	QQQ	ETF	109.79	109.87	109.31	109.419	3835722.0
2016-01-05 12:00:00	QQQ	ETF	109.41	109.415	108.8	109.11	5779367.0
2016-01-05 13:00:00	QQQ	ETF	109.11	109.72	108.93	109.579	4048529.0
2016-01-05 14:00:00	QQQ	ETF	109.58	109.8836	109.33	109.41	3768977.0
2016-01-05 15:00:00	QQQ	ETF	109.39	109.59	109.08	109.24	5305931.0
2016-01-05 16:00:00	QQQ	ETF	109.26	109.5	109.22	109.36	578514.0
2016-01-05 17:00:00	QQQ	ETF	109.4	109.4	109.27	109.32	14959.0
2016-01-05 18:00:00	QQQ	ETF	109.35	109.43	109.35	109.37	6363.0
2016-01-05 19:00:00	QQQ	ETF	109.45	109.5	109.34	109.45	15700.0
2016-01-05 04:00:00	IWM	ETF	109.9	109.9	109.8	109.8	600.0
2016-01-05 05:00:00	IWM	ETF	109.75	109.75	109.66	109.66	800.0
2016-01-05 07:00:00	IWM	ETF	109.79	109.82	109.61	109.8	96900.0
2016-01-05 08:00:00	IWM	ETF	109.96	110.32	109.92	110.26	282561.0
2016-01-05 09:00:00	IWM	ETF	110.25	110.53	109.86	109.91	3600982.0
2016-01-05 10:00:00	IWM	ETF	109.93	110.575	109.67	110.39	4449697.0
2016-01-05 11:00:00	IWM	ETF	110.39	110.52	109.92	110.01	3238358.0
2016-01-05 12:00:00	IWM	ETF	110.04	110.04	109.55	109.98	2632987.0
2016-01-05 13:00:00	IWM	ETF	109.98	110.37	109.66	110.27	3456021.0
2016-01-05 14:00:00	IWM	ETF	110.27	110.43	110.115	110.27	2795692.0
2016-01-05 15:00:00	IWM	ETF	110.27	110.4	110.04	110.22	3978518.0
2016-01-05 16:00:00	IWM	ETF	110.24	110.48	110.18	110.43	979055.0
2016-01-05 19:00:00	IWM	ETF	110.39	110.4	110.3	110.39	5600.0
2016-01-05 07:00:00	DIA	ETF	170.39	170.75	170.37	170.75	7487.0
2016-01-05 08:00:00	DIA	ETF	170.58	171.55	170.58	171.55	7425.0
2016-01-05 09:00:00	DIA	ETF	171.59	171.74	171.1	171.13	1129319.0
2016-01-05 10:00:00	DIA	ETF	171.14	171.42	170.54	171.28	807868.0
2016-01-05 11:00:00	DIA	ETF	171.28	171.37	170.6	170.81	819892.0

> showing 50 of 7,937 rows — these rows as CSV

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