PREVIEW / etf_1hour / 2017-08-14

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-14.parquet
  size:    280 KB
  rows:    9,098

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-08-14 04:00:00	SPY	ETF	245.8	245.8	245.44	245.57	30389.0
2017-08-14 05:00:00	SPY	ETF	245.58	245.62	245.49	245.52	32930.0
2017-08-14 06:00:00	SPY	ETF	245.47	245.63	245.45	245.6	60783.0
2017-08-14 07:00:00	SPY	ETF	245.57	245.6	245.34	245.51	357713.0
2017-08-14 08:00:00	SPY	ETF	245.5	245.59	245.41	245.56	474846.0
2017-08-14 09:00:00	SPY	ETF	245.51	246.25	245.36	246.185	9282608.0
2017-08-14 10:00:00	SPY	ETF	246.19	246.79	246.165	246.65	9592580.0
2017-08-14 11:00:00	SPY	ETF	246.64	246.71	246.46	246.62	6089310.0
2017-08-14 12:00:00	SPY	ETF	246.62	246.74	246.45	246.54	3746312.0
2017-08-14 13:00:00	SPY	ETF	246.53	246.69	246.47	246.62	3854101.0
2017-08-14 14:00:00	SPY	ETF	246.62	246.69	246.245	246.365	6283388.0
2017-08-14 15:00:00	SPY	ETF	246.36	246.76	246.27	246.52	18014779.0
2017-08-14 16:00:00	SPY	ETF	246.52	246.69	246.38	246.63	13548579.0
2017-08-14 17:00:00	SPY	ETF	246.62	246.64	246.3805	246.61	139284.0
2017-08-14 18:00:00	SPY	ETF	246.61	246.72	246.43	246.64	102208.0
2017-08-14 19:00:00	SPY	ETF	246.67	246.98	246.66	246.93	63315.0
2017-08-14 04:00:00	QQQ	ETF	143.03	143.13	143.0	143.09	12077.0
2017-08-14 05:00:00	QQQ	ETF	143.13	143.13	143.05	143.07	13350.0
2017-08-14 06:00:00	QQQ	ETF	143.04	143.1	142.95	143.05	61609.0
2017-08-14 07:00:00	QQQ	ETF	143.06	143.07	142.88	142.93	64515.0
2017-08-14 08:00:00	QQQ	ETF	142.94	143.13	142.92	143.13	346310.0
2017-08-14 09:00:00	QQQ	ETF	143.11	143.55	143.01	143.47	5660829.0
2017-08-14 10:00:00	QQQ	ETF	143.47	144.015	143.47	143.805	5264582.0
2017-08-14 11:00:00	QQQ	ETF	143.8	143.82	143.64	143.751	1700441.0
2017-08-14 12:00:00	QQQ	ETF	143.76	143.87	143.655	143.79	1525555.0
2017-08-14 13:00:00	QQQ	ETF	143.81	143.97	143.81	143.92	2197286.0
2017-08-14 14:00:00	QQQ	ETF	143.92	143.98	143.69	143.78	3274927.0
2017-08-14 15:00:00	QQQ	ETF	143.78	144.15	143.69	143.92	9350934.0
2017-08-14 16:00:00	QQQ	ETF	143.92	144.1	143.9	144.08	2036241.0
2017-08-14 17:00:00	QQQ	ETF	144.07	144.12	143.7449	144.05	66424.0
2017-08-14 18:00:00	QQQ	ETF	144.02	144.09	143.99	144.05	31498.0
2017-08-14 19:00:00	QQQ	ETF	144.08	144.27	144.08	144.26	10948.0
2017-08-14 04:00:00	IWM	ETF	137.37	137.61	137.35	137.49	12493.0
2017-08-14 05:00:00	IWM	ETF	137.49	137.51	137.37	137.37	16516.0
2017-08-14 06:00:00	IWM	ETF	137.37	137.49	137.37	137.49	6702.0
2017-08-14 07:00:00	IWM	ETF	137.46	138.5277	137.37	137.46	300339.0
2017-08-14 08:00:00	IWM	ETF	137.46	137.56	137.41	137.41	20152.0
2017-08-14 09:00:00	IWM	ETF	137.47	138.05	137.23	137.91	2775619.0
2017-08-14 10:00:00	IWM	ETF	137.91	138.2	137.65	138.05	2776790.0
2017-08-14 11:00:00	IWM	ETF	138.0515	138.47	137.83	138.44	2102867.0
2017-08-14 12:00:00	IWM	ETF	138.45	138.59	138.23	138.25	1300489.0
2017-08-14 13:00:00	IWM	ETF	138.26	138.49	138.2	138.47	2012978.0
2017-08-14 14:00:00	IWM	ETF	138.47	138.58	138.23	138.3	1981748.0
2017-08-14 15:00:00	IWM	ETF	138.31	138.59	138.26	138.53	3840821.0
2017-08-14 16:00:00	IWM	ETF	138.53	138.64	137.8146	138.64	1827021.0
2017-08-14 17:00:00	IWM	ETF	138.62	138.68	138.3158	138.61	74600.0
2017-08-14 18:00:00	IWM	ETF	138.58	138.59	138.5	138.54	2266.0
2017-08-14 19:00:00	IWM	ETF	138.71	138.71	138.71	138.71	1300.0
2017-08-14 04:00:00	DIA	ETF	219.68	219.68	219.68	219.68	200.0
2017-08-14 07:00:00	DIA	ETF	219.68	219.82	219.68	219.8	2844.0

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

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