PREVIEW / etf_1hour / 2017-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2017/2017-05-08.parquet
  size:    276 KB
  rows:    9,009

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-05-08 04:00:00	SPY	ETF	239.5	239.72	239.5	239.56	25481.0
2017-05-08 05:00:00	SPY	ETF	239.57	239.63	239.43	239.6	38100.0
2017-05-08 06:00:00	SPY	ETF	239.58	239.85	239.55	239.77	13700.0
2017-05-08 07:00:00	SPY	ETF	239.78	239.87	239.69	239.69	90829.0
2017-05-08 08:00:00	SPY	ETF	239.73	239.84	239.51	239.58	765776.0
2017-05-08 09:00:00	SPY	ETF	239.59	239.92	239.41	239.47	6596037.0
2017-05-08 10:00:00	SPY	ETF	239.46	239.63	239.3	239.4	7536008.0
2017-05-08 11:00:00	SPY	ETF	239.4	239.5	239.17	239.44	6000316.0
2017-05-08 12:00:00	SPY	ETF	239.44	239.66	239.33	239.59	2947050.0
2017-05-08 13:00:00	SPY	ETF	239.585	239.71	239.54	239.7093	3318845.0
2017-05-08 14:00:00	SPY	ETF	239.705	239.71	239.4999	239.61	6114832.0
2017-05-08 15:00:00	SPY	ETF	239.62	239.7	239.39	239.67	10128812.0
2017-05-08 16:00:00	SPY	ETF	239.67	239.74	239.4805	239.67	4091081.0
2017-05-08 17:00:00	SPY	ETF	239.7	239.71	239.66	239.66	63283.0
2017-05-08 18:00:00	SPY	ETF	239.66	239.76	239.65	239.75	61391.0
2017-05-08 19:00:00	SPY	ETF	239.76	239.76	239.66	239.68	26075.0
2017-05-08 04:00:00	QQQ	ETF	137.41	137.46	137.39	137.46	2550.0
2017-05-08 05:00:00	QQQ	ETF	137.47	137.47	137.39	137.39	5900.0
2017-05-08 06:00:00	QQQ	ETF	137.6	137.62	137.57	137.58	2800.0
2017-05-08 07:00:00	QQQ	ETF	137.59	137.64	137.56	137.61	31940.0
2017-05-08 08:00:00	QQQ	ETF	137.59	137.61	137.48	137.5	34850.0
2017-05-08 09:00:00	QQQ	ETF	137.52	137.735	137.435	137.44	1739702.0
2017-05-08 10:00:00	QQQ	ETF	137.44	137.67	137.4	137.48	1797628.0
2017-05-08 11:00:00	QQQ	ETF	137.48	137.58	137.33	137.53	1100081.0
2017-05-08 12:00:00	QQQ	ETF	137.54	137.75	137.51	137.67	1342419.0
2017-05-08 13:00:00	QQQ	ETF	137.6672	137.765	137.6	137.75	693640.0
2017-05-08 14:00:00	QQQ	ETF	137.76	137.78	137.63	137.755	897612.0
2017-05-08 15:00:00	QQQ	ETF	137.7573	137.84	137.57	137.84	2053126.0
2017-05-08 16:00:00	QQQ	ETF	137.83	137.86	137.622	137.82	697480.0
2017-05-08 17:00:00	QQQ	ETF	137.84	137.85	137.84	137.85	770.0
2017-05-08 18:00:00	QQQ	ETF	137.81	137.86	137.81	137.86	4575.0
2017-05-08 19:00:00	QQQ	ETF	137.85	137.86	137.81	137.83	24450.0
2017-05-08 04:00:00	IWM	ETF	138.68	138.72	138.6	138.6	4700.0
2017-05-08 05:00:00	IWM	ETF	138.56	138.58	138.43	138.46	10870.0
2017-05-08 06:00:00	IWM	ETF	138.52	138.52	138.52	138.52	4600.0
2017-05-08 07:00:00	IWM	ETF	138.71	138.79	138.62	138.62	13600.0
2017-05-08 08:00:00	IWM	ETF	138.64	138.65	138.45	138.47	65357.0
2017-05-08 09:00:00	IWM	ETF	138.47	138.98	138.42	138.69	1972838.0
2017-05-08 10:00:00	IWM	ETF	138.69	138.89	138.09	138.17	2455834.0
2017-05-08 11:00:00	IWM	ETF	138.2	138.28	137.82	137.965	2101386.0
2017-05-08 12:00:00	IWM	ETF	137.965	138.48	137.76	138.41	1742942.0
2017-05-08 13:00:00	IWM	ETF	138.41	138.6	138.33	138.56	863846.0
2017-05-08 14:00:00	IWM	ETF	138.55	138.59	138.18	138.3	1053782.0
2017-05-08 15:00:00	IWM	ETF	138.3	138.41	138.03	138.39	2927406.0
2017-05-08 16:00:00	IWM	ETF	138.41	138.41	138.26	138.41	2220632.0
2017-05-08 17:00:00	IWM	ETF	138.35	138.42	138.35	138.42	600.0
2017-05-08 18:00:00	IWM	ETF	138.4	138.4	138.36	138.36	1861.0
2017-05-08 19:00:00	IWM	ETF	138.38	138.44	138.38	138.44	3432.0
2017-05-08 05:00:00	DIA	ETF	209.59	209.59	209.59	209.59	240.0
2017-05-08 08:00:00	DIA	ETF	209.6	209.6	209.58	209.58	6065.0

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

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