PREVIEW / etf_1hour / 2016-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-11-29.parquet
  size:    271 KB
  rows:    8,726

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-11-29 04:00:00	SPY	ETF	220.84	221.1	220.84	220.97	15155.0
2016-11-29 05:00:00	SPY	ETF	221.0	221.0	220.79	220.83	5700.0
2016-11-29 06:00:00	SPY	ETF	220.83	220.98	220.83	220.89	5804.0
2016-11-29 07:00:00	SPY	ETF	220.89	221.05	220.82	220.85	256064.0
2016-11-29 08:00:00	SPY	ETF	220.83	221.0	220.56	220.64	1851070.0
2016-11-29 09:00:00	SPY	ETF	220.6	220.78	220.17	220.291	7503627.0
2016-11-29 10:00:00	SPY	ETF	220.3	221.02	220.3	221.0	9983842.0
2016-11-29 11:00:00	SPY	ETF	221.01	221.31	220.82	221.275	9150905.0
2016-11-29 12:00:00	SPY	ETF	221.27	221.275	221.0	221.27	3998672.0
2016-11-29 13:00:00	SPY	ETF	221.27	221.37	221.12	221.31	3860341.0
2016-11-29 14:00:00	SPY	ETF	221.32	221.44	221.21	221.2375	7941028.0
2016-11-29 15:00:00	SPY	ETF	221.24	221.25	220.65	220.89	16827797.0
2016-11-29 16:00:00	SPY	ETF	220.88	220.93	220.81	220.82	6732807.0
2016-11-29 17:00:00	SPY	ETF	220.84	220.9	220.83	220.85	175651.0
2016-11-29 18:00:00	SPY	ETF	220.84	220.92	220.82	220.88	127738.0
2016-11-29 19:00:00	SPY	ETF	220.91	220.92	220.85	220.88	16509.0
2016-11-29 04:00:00	QQQ	ETF	118.79	118.8	118.79	118.79	1300.0
2016-11-29 05:00:00	QQQ	ETF	118.82	118.82	118.75	118.75	2497.0
2016-11-29 06:00:00	QQQ	ETF	118.83	118.83	118.81	118.81	600.0
2016-11-29 07:00:00	QQQ	ETF	118.77	118.86	118.73	118.75	6289.0
2016-11-29 08:00:00	QQQ	ETF	118.75	118.76	118.56	118.59	28152.0
2016-11-29 09:00:00	QQQ	ETF	118.58	118.76	118.3	118.46	1635169.0
2016-11-29 10:00:00	QQQ	ETF	118.46	119.06	118.45	119.04	2105221.0
2016-11-29 11:00:00	QQQ	ETF	119.04	119.51	118.9	119.502	2120827.0
2016-11-29 12:00:00	QQQ	ETF	119.51	119.51	119.3001	119.43	2131480.0
2016-11-29 13:00:00	QQQ	ETF	119.44	119.465	119.26	119.412	1293554.0
2016-11-29 14:00:00	QQQ	ETF	119.41	119.45	119.275	119.285	1556024.0
2016-11-29 15:00:00	QQQ	ETF	119.29	119.29	118.8	118.96	4133684.0
2016-11-29 16:00:00	QQQ	ETF	118.95	119.02	118.92	118.98	346579.0
2016-11-29 17:00:00	QQQ	ETF	118.95	118.97	118.94	118.94	1624.0
2016-11-29 18:00:00	QQQ	ETF	118.95	119.0	118.94	118.95	3090.0
2016-11-29 19:00:00	QQQ	ETF	118.97	118.99	118.97	118.98	8578.0
2016-11-29 04:00:00	IWM	ETF	132.6	132.7	132.6	132.69	723.0
2016-11-29 05:00:00	IWM	ETF	132.52	132.52	132.52	132.52	100.0
2016-11-29 06:00:00	IWM	ETF	132.73	132.73	132.7	132.7	1000.0
2016-11-29 07:00:00	IWM	ETF	132.67	132.78	132.64	132.66	12700.0
2016-11-29 08:00:00	IWM	ETF	132.64	132.68	132.49	132.6	151915.0
2016-11-29 09:00:00	IWM	ETF	132.59	133.0	132.1	132.22	4077035.0
2016-11-29 10:00:00	IWM	ETF	132.23	133.09	132.22	133.03	4186366.0
2016-11-29 11:00:00	IWM	ETF	133.03	133.05	132.38	132.87	4157239.0
2016-11-29 12:00:00	IWM	ETF	132.87	132.87	132.28	132.55	2421384.0
2016-11-29 13:00:00	IWM	ETF	132.544	132.88	132.33	132.87	1517811.0
2016-11-29 14:00:00	IWM	ETF	132.87	132.99	132.54	132.56	2085196.0
2016-11-29 15:00:00	IWM	ETF	132.57	132.6	132.13	132.28	4168394.0
2016-11-29 16:00:00	IWM	ETF	132.28	132.43	132.2156	132.27	582739.0
2016-11-29 17:00:00	IWM	ETF	132.3	132.32	132.25	132.25	13155.0
2016-11-29 19:00:00	IWM	ETF	132.25	132.39	132.25	132.39	3591.0
2016-11-29 04:00:00	DIA	ETF	191.15	191.15	191.15	191.15	200.0
2016-11-29 07:00:00	DIA	ETF	191.13	191.13	191.13	191.13	100.0
2016-11-29 08:00:00	DIA	ETF	191.13	191.17	191.05	191.05	11100.0

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

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