PREVIEW / etf_1hour / 2016-05-20

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-20.parquet
  size:    243 KB
  rows:    7,831

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-05-20 04:00:00	SPY	ETF	204.82	205.2	204.82	205.15	9078.0
2016-05-20 05:00:00	SPY	ETF	205.09	205.09	204.62	204.99	32570.0
2016-05-20 06:00:00	SPY	ETF	204.95	204.98	204.78	204.89	63922.0
2016-05-20 07:00:00	SPY	ETF	204.88	205.03	204.79	204.98	372864.0
2016-05-20 08:00:00	SPY	ETF	204.97	205.12	204.8	205.06	927174.0
2016-05-20 09:00:00	SPY	ETF	205.01	205.8	204.86	205.65	14718492.0
2016-05-20 10:00:00	SPY	ETF	205.66	205.95	205.47	205.63	19596858.0
2016-05-20 11:00:00	SPY	ETF	205.63	206.1	205.58	205.8105	10347063.0
2016-05-20 12:00:00	SPY	ETF	205.82	205.92	205.68	205.7708	5862425.0
2016-05-20 13:00:00	SPY	ETF	205.77	205.85	205.28	205.41	7444069.0
2016-05-20 14:00:00	SPY	ETF	205.41	205.8	205.35	205.4475	8628720.0
2016-05-20 15:00:00	SPY	ETF	205.45	205.51	205.04	205.46	20022997.0
2016-05-20 16:00:00	SPY	ETF	205.47	205.6	205.3981	205.57	11634702.0
2016-05-20 17:00:00	SPY	ETF	205.56	205.62	205.49	205.55	381781.0
2016-05-20 18:00:00	SPY	ETF	205.55	205.57	205.5	205.54	59882.0
2016-05-20 19:00:00	SPY	ETF	205.54	205.57	205.51	205.53	22498.0
2016-05-20 04:00:00	QQQ	ETF	105.93	105.97	105.93	105.97	1100.0
2016-05-20 05:00:00	QQQ	ETF	105.69	105.78	105.69	105.78	1035.0
2016-05-20 07:00:00	QQQ	ETF	105.69	105.8	105.69	105.79	6832.0
2016-05-20 08:00:00	QQQ	ETF	105.78	105.94	105.74	105.91	124452.0
2016-05-20 09:00:00	QQQ	ETF	105.94	106.43	105.67	106.43	4195489.0
2016-05-20 10:00:00	QQQ	ETF	106.43	106.71	106.38	106.5799	4092306.0
2016-05-20 11:00:00	QQQ	ETF	106.57	106.9	106.56	106.75	3248528.0
2016-05-20 12:00:00	QQQ	ETF	106.76	106.83	106.66	106.7239	1442630.0
2016-05-20 13:00:00	QQQ	ETF	106.72	106.76	106.41	106.5	1926846.0
2016-05-20 14:00:00	QQQ	ETF	106.495	106.67	106.455	106.49	1422501.0
2016-05-20 15:00:00	QQQ	ETF	106.5	106.51	106.27	106.46	4647153.0
2016-05-20 16:00:00	QQQ	ETF	106.45	106.53	106.43	106.51	2101395.0
2016-05-20 17:00:00	QQQ	ETF	106.5	106.5	106.43	106.47	33795.0
2016-05-20 18:00:00	QQQ	ETF	106.44	106.49	106.37	106.4	10897.0
2016-05-20 19:00:00	QQQ	ETF	106.47	106.47	106.37	106.42	7735.0
2016-05-20 06:00:00	IWM	ETF	109.25	109.3	109.25	109.3	599.0
2016-05-20 07:00:00	IWM	ETF	109.25	109.36	109.22	109.36	40067.0
2016-05-20 08:00:00	IWM	ETF	109.34	109.43	109.26	109.41	122290.0
2016-05-20 09:00:00	IWM	ETF	109.37	110.02	109.23	110.0	3926471.0
2016-05-20 10:00:00	IWM	ETF	109.99	110.44	109.95	110.23	4854391.0
2016-05-20 11:00:00	IWM	ETF	110.23	110.675	110.2	110.46	3057904.0
2016-05-20 12:00:00	IWM	ETF	110.47	110.65	110.365	110.5406	1815558.0
2016-05-20 13:00:00	IWM	ETF	110.54	110.605	110.12	110.27	2070665.0
2016-05-20 14:00:00	IWM	ETF	110.255	110.57	110.23	110.39	1579993.0
2016-05-20 15:00:00	IWM	ETF	110.4	110.78	110.15	110.77	5149770.0
2016-05-20 16:00:00	IWM	ETF	110.79	110.89	110.73	110.89	1004493.0
2016-05-20 17:00:00	IWM	ETF	110.87	110.87	110.81	110.87	267102.0
2016-05-20 18:00:00	IWM	ETF	110.8	110.8	110.8	110.8	1400.0
2016-05-20 19:00:00	IWM	ETF	110.81	110.81	110.81	110.81	540.0
2016-05-20 07:00:00	DIA	ETF	174.62	174.75	174.62	174.75	2000.0
2016-05-20 08:00:00	DIA	ETF	174.75	174.75	174.69	174.72	1600.0
2016-05-20 09:00:00	DIA	ETF	174.78	175.46	174.51	175.302	508471.0
2016-05-20 10:00:00	DIA	ETF	175.35	175.53	175.12	175.16	482529.0
2016-05-20 11:00:00	DIA	ETF	175.19	175.54	175.16	175.28	322221.0

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

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