PREVIEW / etf_1hour / 2015-06-18

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-06-18.parquet
  size:    241 KB
  rows:    7,645

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
2015-06-18 04:00:00	SPY	ETF	210.6	210.66	210.24	210.5	10900.0
2015-06-18 05:00:00	SPY	ETF	210.38	210.71	210.0	210.63	102231.0
2015-06-18 06:00:00	SPY	ETF	210.66	211.1	210.54	210.98	143086.0
2015-06-18 07:00:00	SPY	ETF	210.96	211.0	210.76	210.92	116764.0
2015-06-18 08:00:00	SPY	ETF	210.91	211.18	210.84	210.98	771290.0
2015-06-18 09:00:00	SPY	ETF	210.97	212.02	210.88	211.86	16789769.0
2015-06-18 10:00:00	SPY	ETF	211.865	212.59	211.86	212.56	25619736.0
2015-06-18 11:00:00	SPY	ETF	212.56	212.94	212.54	212.76	20409679.0
2015-06-18 12:00:00	SPY	ETF	212.75	213.34	212.69	212.81	26237020.0
2015-06-18 13:00:00	SPY	ETF	212.81	212.95	212.44	212.56	13438999.0
2015-06-18 14:00:00	SPY	ETF	212.57	212.99	212.51	212.96	12763985.0
2015-06-18 15:00:00	SPY	ETF	212.96	213.1	212.66	212.75	33359278.0
2015-06-18 16:00:00	SPY	ETF	212.74	212.92	210.67	212.84	9451264.0
2015-06-18 17:00:00	SPY	ETF	212.86	212.94	212.86	212.92	153195.0
2015-06-18 18:00:00	SPY	ETF	212.9	212.9	212.62	212.66	939107.0
2015-06-18 19:00:00	SPY	ETF	212.68	212.78	212.67	212.77	15611.0
2015-06-18 05:00:00	QQQ	ETF	109.0	109.09	109.0	109.09	2200.0
2015-06-18 06:00:00	QQQ	ETF	109.13	109.29	109.13	109.21	33300.0
2015-06-18 07:00:00	QQQ	ETF	109.28	109.29	109.15	109.15	57800.0
2015-06-18 08:00:00	QQQ	ETF	109.23	109.43	109.2	109.29	206103.0
2015-06-18 09:00:00	QQQ	ETF	109.29	110.12	109.26	110.06	4351552.0
2015-06-18 10:00:00	QQQ	ETF	110.07	110.57	110.04	110.53	5746267.0
2015-06-18 11:00:00	QQQ	ETF	110.53	110.77	110.53	110.66	3946639.0
2015-06-18 12:00:00	QQQ	ETF	110.65	110.88	110.6	110.62	4269960.0
2015-06-18 13:00:00	QQQ	ETF	110.63	110.71	110.43	110.47	1968280.0
2015-06-18 14:00:00	QQQ	ETF	110.465	110.795	110.44	110.76	2175045.0
2015-06-18 15:00:00	QQQ	ETF	110.76	110.82	110.57	110.64	4716389.0
2015-06-18 16:00:00	QQQ	ETF	110.62	110.79	110.61	110.74	924972.0
2015-06-18 17:00:00	QQQ	ETF	110.74	110.79	110.74	110.78	61022.0
2015-06-18 18:00:00	QQQ	ETF	110.69	110.74	110.61	110.61	210263.0
2015-06-18 19:00:00	QQQ	ETF	110.61	110.69	110.61	110.64	29591.0
2015-06-18 05:00:00	IWM	ETF	126.05	126.35	126.05	126.35	200.0
2015-06-18 06:00:00	IWM	ETF	126.53	126.66	126.53	126.66	300.0
2015-06-18 07:00:00	IWM	ETF	126.7	126.7	126.51	126.51	500.0
2015-06-18 08:00:00	IWM	ETF	126.65	126.83	126.58	126.58	95134.0
2015-06-18 09:00:00	IWM	ETF	126.62	127.32	126.59	127.12	4663301.0
2015-06-18 10:00:00	IWM	ETF	127.15	127.78	127.15	127.56	6503992.0
2015-06-18 11:00:00	IWM	ETF	127.555	128.07	127.46	128.06	4176091.0
2015-06-18 12:00:00	IWM	ETF	128.0599	128.24	127.95	127.98	3146758.0
2015-06-18 13:00:00	IWM	ETF	127.98	128.02	127.68	127.865	3095554.0
2015-06-18 14:00:00	IWM	ETF	127.86	127.97	127.78	127.96	2042999.0
2015-06-18 15:00:00	IWM	ETF	127.96	128.13	127.795	127.9	5113205.0
2015-06-18 16:00:00	IWM	ETF	127.89	128.05	127.83	128.01	1488272.0
2015-06-18 17:00:00	IWM	ETF	128.04	128.1	128.04	128.1	7075.0
2015-06-18 18:00:00	IWM	ETF	127.92	127.98	127.92	127.98	474439.0
2015-06-18 19:00:00	IWM	ETF	127.98	127.98	127.98	127.98	364.0
2015-06-18 06:00:00	DIA	ETF	179.8	179.8	179.8	179.8	100.0
2015-06-18 07:00:00	DIA	ETF	179.81	179.81	179.8	179.8	300.0
2015-06-18 08:00:00	DIA	ETF	180.04	180.04	180.04	180.04	2500.0
2015-06-18 09:00:00	DIA	ETF	179.99	181.06	179.97	180.79	820107.0

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

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