PREVIEW / etf_1hour / 2017-07-05

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-07-05.parquet
  size:    277 KB
  rows:    9,177

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-07-05 04:00:00	SPY	ETF	242.25	242.33	242.07	242.24	10379.0
2017-07-05 05:00:00	SPY	ETF	242.3	242.32	242.22	242.22	4080.0
2017-07-05 06:00:00	SPY	ETF	242.2	242.45	242.17	242.4	21437.0
2017-07-05 07:00:00	SPY	ETF	242.42	242.54	242.3	242.53	99370.0
2017-07-05 08:00:00	SPY	ETF	242.4	242.71	242.021	242.61	282442.0
2017-07-05 09:00:00	SPY	ETF	242.6	242.72	242.05	242.21	7566956.0
2017-07-05 10:00:00	SPY	ETF	242.21	242.5	241.7	242.46	9692580.0
2017-07-05 11:00:00	SPY	ETF	242.47	242.74	242.4	242.43	4924222.0
2017-07-05 12:00:00	SPY	ETF	242.43	242.73	242.38	242.685	3895856.0
2017-07-05 13:00:00	SPY	ETF	242.69	242.88	242.61	242.6504	3563182.0
2017-07-05 14:00:00	SPY	ETF	242.65	243.01	242.44	242.61	5708398.0
2017-07-05 15:00:00	SPY	ETF	242.61	242.94	242.44	242.77	10785559.0
2017-07-05 16:00:00	SPY	ETF	242.77	242.77	242.51	242.62	5569870.0
2017-07-05 17:00:00	SPY	ETF	242.62	242.77	242.55	242.6	391676.0
2017-07-05 18:00:00	SPY	ETF	242.59	242.78	242.54	242.76	126365.0
2017-07-05 19:00:00	SPY	ETF	242.74	242.76	242.72	242.76	7775.0
2017-07-05 04:00:00	QQQ	ETF	136.05	136.24	135.54	135.61	5544.0
2017-07-05 05:00:00	QQQ	ETF	135.69	135.7	135.61	135.7	1417.0
2017-07-05 06:00:00	QQQ	ETF	135.63	135.71	135.63	135.7	29040.0
2017-07-05 07:00:00	QQQ	ETF	135.71	136.28	135.64	136.27	92237.0
2017-07-05 08:00:00	QQQ	ETF	136.27	136.59	135.71	136.51	249260.0
2017-07-05 09:00:00	QQQ	ETF	136.51	137.03	136.37	136.58	6365861.0
2017-07-05 10:00:00	QQQ	ETF	136.58	137.1699	136.16	137.06	7158982.0
2017-07-05 11:00:00	QQQ	ETF	137.06	137.36	136.98	137.16	2429622.0
2017-07-05 12:00:00	QQQ	ETF	137.16	137.4497	137.13	137.4075	1924572.0
2017-07-05 13:00:00	QQQ	ETF	137.41	137.73	137.4	137.45	2909323.0
2017-07-05 14:00:00	QQQ	ETF	137.45	137.9	137.28	137.5	3877481.0
2017-07-05 15:00:00	QQQ	ETF	137.5	137.67	137.3	137.51	6325591.0
2017-07-05 16:00:00	QQQ	ETF	137.53	137.64	136.2318	137.53	5035530.0
2017-07-05 17:00:00	QQQ	ETF	137.6	137.6	137.51	137.55	3994.0
2017-07-05 18:00:00	QQQ	ETF	137.54	137.54	137.4	137.5	27796.0
2017-07-05 19:00:00	QQQ	ETF	137.49	137.5	137.47	137.48	5444.0
2017-07-05 04:00:00	IWM	ETF	141.22	141.3	141.06	141.11	14003.0
2017-07-05 05:00:00	IWM	ETF	141.33	141.33	141.08	141.11	3354.0
2017-07-05 06:00:00	IWM	ETF	141.07	141.26	141.07	141.26	1700.0
2017-07-05 07:00:00	IWM	ETF	141.32	141.57	141.22	141.53	23530.0
2017-07-05 08:00:00	IWM	ETF	141.28	142.22	141.28	141.48	353463.0
2017-07-05 09:00:00	IWM	ETF	141.44	141.85	141.0	141.38	2684703.0
2017-07-05 10:00:00	IWM	ETF	141.37	141.69	140.77	141.26	2701756.0
2017-07-05 11:00:00	IWM	ETF	141.26	141.4275	140.87	140.91	2724657.0
2017-07-05 12:00:00	IWM	ETF	140.9	141.37	140.7	141.29	1316782.0
2017-07-05 13:00:00	IWM	ETF	141.29	141.63	141.25	141.38	877441.0
2017-07-05 14:00:00	IWM	ETF	141.37	141.58	141.11	141.15	1334420.0
2017-07-05 15:00:00	IWM	ETF	141.16	141.655	141.01	141.61	4831271.0
2017-07-05 16:00:00	IWM	ETF	141.59	141.64	140.9856	141.47	1286432.0
2017-07-05 17:00:00	IWM	ETF	141.47	141.47	141.42	141.47	1436.0
2017-07-05 18:00:00	IWM	ETF	141.45	141.48	141.45	141.45	1770.0
2017-07-05 19:00:00	IWM	ETF	141.5	141.5	141.5	141.5	500.0
2017-07-05 07:00:00	DIA	ETF	214.6	214.61	214.6	214.6	2345.0
2017-07-05 08:00:00	DIA	ETF	214.77	214.9	214.77	214.9	2300.0

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

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