PREVIEW / etf_1hour / 2017-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-08-25.parquet
  size:    271 KB
  rows:    8,832

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-25 04:00:00	SPY	ETF	244.46	244.46	244.4	244.4	4511.0
2017-08-25 05:00:00	SPY	ETF	244.32	244.75	244.3	244.72	3343.0
2017-08-25 06:00:00	SPY	ETF	244.8	244.93	244.75	244.93	50206.0
2017-08-25 07:00:00	SPY	ETF	244.97	245.15	244.89	245.09	233611.0
2017-08-25 08:00:00	SPY	ETF	245.08	245.09	244.86	244.99	523287.0
2017-08-25 09:00:00	SPY	ETF	244.99	245.43	244.84	245.2701	6810088.0
2017-08-25 10:00:00	SPY	ETF	245.27	245.61	244.816	244.88	11431347.0
2017-08-25 11:00:00	SPY	ETF	244.885	244.89	244.39	244.59	8656139.0
2017-08-25 12:00:00	SPY	ETF	244.59	244.88	244.56	244.83	3976655.0
2017-08-25 13:00:00	SPY	ETF	244.83	245.03	244.79	244.89	1930071.0
2017-08-25 14:00:00	SPY	ETF	244.88	245.05	244.86	245.017	3244014.0
2017-08-25 15:00:00	SPY	ETF	245.02	245.23	244.46	244.54	15322439.0
2017-08-25 16:00:00	SPY	ETF	244.53	244.64	244.48	244.51	9388679.0
2017-08-25 17:00:00	SPY	ETF	244.5	244.7994	244.42	244.45	187128.0
2017-08-25 18:00:00	SPY	ETF	244.45	244.56	244.07	244.19	541050.0
2017-08-25 19:00:00	SPY	ETF	244.18	244.2	244.08	244.16	110080.0
2017-08-25 04:00:00	QQQ	ETF	142.51	142.51	142.44	142.44	2962.0
2017-08-25 05:00:00	QQQ	ETF	142.4	142.53	142.4	142.53	804.0
2017-08-25 06:00:00	QQQ	ETF	142.78	142.87	142.77	142.83	6997.0
2017-08-25 07:00:00	QQQ	ETF	142.85	143.0	142.75	142.98	24596.0
2017-08-25 08:00:00	QQQ	ETF	142.96	142.96	142.73	142.87	246241.0
2017-08-25 09:00:00	QQQ	ETF	142.85	143.03	142.49	142.87	2977471.0
2017-08-25 10:00:00	QQQ	ETF	142.87	143.18	142.25	142.26	4639822.0
2017-08-25 11:00:00	QQQ	ETF	142.26	142.28	141.78	142.07	4889380.0
2017-08-25 12:00:00	QQQ	ETF	142.08	142.195	141.97	142.1	1685382.0
2017-08-25 13:00:00	QQQ	ETF	142.109	142.32	142.03	142.1	1608819.0
2017-08-25 14:00:00	QQQ	ETF	142.11	142.31	142.09	142.28	989429.0
2017-08-25 15:00:00	QQQ	ETF	142.2801	142.44	141.92	141.97	4337280.0
2017-08-25 16:00:00	QQQ	ETF	141.97	142.07	141.94	141.98	892256.0
2017-08-25 17:00:00	QQQ	ETF	141.99	141.99	141.94	141.95	9474.0
2017-08-25 18:00:00	QQQ	ETF	141.91	141.94	141.8	141.94	10518.0
2017-08-25 19:00:00	QQQ	ETF	141.8	141.85	141.49	141.85	30284.0
2017-08-25 04:00:00	IWM	ETF	136.52	136.52	136.52	136.52	2174.0
2017-08-25 05:00:00	IWM	ETF	136.39	136.74	136.39	136.74	5706.0
2017-08-25 06:00:00	IWM	ETF	136.75	136.82	136.72	136.8	10606.0
2017-08-25 07:00:00	IWM	ETF	136.83	136.91	136.71	136.9	16230.0
2017-08-25 08:00:00	IWM	ETF	136.78	136.89	136.7	136.88	208257.0
2017-08-25 09:00:00	IWM	ETF	136.88	137.18	136.71	136.94	2468766.0
2017-08-25 10:00:00	IWM	ETF	136.93	137.07	136.42	136.66	3322818.0
2017-08-25 11:00:00	IWM	ETF	136.65	136.86	136.43	136.69	1719202.0
2017-08-25 12:00:00	IWM	ETF	136.69	136.84	136.63	136.8	941110.0
2017-08-25 13:00:00	IWM	ETF	136.7967	136.95	136.7967	136.88	606780.0
2017-08-25 14:00:00	IWM	ETF	136.88	137.16	136.85	137.125	1084902.0
2017-08-25 15:00:00	IWM	ETF	137.12	137.31	136.84	136.88	2812044.0
2017-08-25 16:00:00	IWM	ETF	136.88	136.97	136.8	136.82	1067464.0
2017-08-25 17:00:00	IWM	ETF	136.8182	136.88	136.8182	136.88	800582.0
2017-08-25 18:00:00	IWM	ETF	136.88	136.88	136.8	136.8	100.0
2017-08-25 19:00:00	IWM	ETF	136.68	136.74	136.59	136.63	22681.0
2017-08-25 08:00:00	DIA	ETF	218.22	218.22	218.18	218.22	2400.0
2017-08-25 09:00:00	DIA	ETF	218.28	218.77	218.23	218.68	222697.0

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

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