PREVIEW / etf_1hour / 2015-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-07-17.parquet
  size:    238 KB
  rows:    7,665

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-07-17 04:00:00	SPY	ETF	212.2	212.2	212.04	212.06	1880.0
2015-07-17 05:00:00	SPY	ETF	212.06	212.18	212.04	212.14	5568.0
2015-07-17 06:00:00	SPY	ETF	212.15	212.23	212.15	212.2	8406.0
2015-07-17 07:00:00	SPY	ETF	212.2	212.33	212.14	212.31	72695.0
2015-07-17 08:00:00	SPY	ETF	212.3	212.42	212.29	212.3	304100.0
2015-07-17 09:00:00	SPY	ETF	212.32	212.44	211.89	212.04	15870374.0
2015-07-17 10:00:00	SPY	ETF	212.05	212.19	211.8	212.05	17263121.0
2015-07-17 11:00:00	SPY	ETF	212.06	212.2	211.98	212.02	6815955.0
2015-07-17 12:00:00	SPY	ETF	212.02	212.11	211.87	212.06	5639919.0
2015-07-17 13:00:00	SPY	ETF	212.06	212.11	211.95	212.0	6862897.0
2015-07-17 14:00:00	SPY	ETF	212.0	212.34	211.98	212.2632	7541912.0
2015-07-17 15:00:00	SPY	ETF	212.26	212.55	212.15	212.45	19726950.0
2015-07-17 16:00:00	SPY	ETF	212.45	212.51	212.36	212.47	6957836.0
2015-07-17 17:00:00	SPY	ETF	212.45	212.55	212.43	212.47	173739.0
2015-07-17 18:00:00	SPY	ETF	212.48	212.51	212.43	212.43	867645.0
2015-07-17 19:00:00	SPY	ETF	212.46	212.56	212.46	212.55	16333.0
2015-07-17 05:00:00	QQQ	ETF	112.59	112.69	112.59	112.69	2877.0
2015-07-17 06:00:00	QQQ	ETF	112.52	112.56	112.52	112.55	6700.0
2015-07-17 07:00:00	QQQ	ETF	112.54	112.65	112.54	112.62	25999.0
2015-07-17 08:00:00	QQQ	ETF	112.62	112.78	112.57	112.74	480174.0
2015-07-17 09:00:00	QQQ	ETF	112.73	112.94	112.65	112.911	5764419.0
2015-07-17 10:00:00	QQQ	ETF	112.915	113.13	112.83	113.09	8215355.0
2015-07-17 11:00:00	QQQ	ETF	113.09	113.255	113.04	113.11	3370726.0
2015-07-17 12:00:00	QQQ	ETF	113.105	113.16	112.98	113.11	1603556.0
2015-07-17 13:00:00	QQQ	ETF	113.11	113.19	113.04	113.14	1448903.0
2015-07-17 14:00:00	QQQ	ETF	113.14	113.44	113.12	113.37	2688105.0
2015-07-17 15:00:00	QQQ	ETF	113.37	113.57	113.28	113.57	5023935.0
2015-07-17 16:00:00	QQQ	ETF	113.56	113.59	113.47	113.54	956636.0
2015-07-17 17:00:00	QQQ	ETF	113.55	113.59	113.49	113.59	37168.0
2015-07-17 18:00:00	QQQ	ETF	113.51	113.6	113.5	113.6	520600.0
2015-07-17 19:00:00	QQQ	ETF	113.54	113.59	113.54	113.57	3347.0
2015-07-17 07:00:00	IWM	ETF	126.45	126.48	126.45	126.45	4100.0
2015-07-17 08:00:00	IWM	ETF	126.45	126.57	126.42	126.55	22805.0
2015-07-17 09:00:00	IWM	ETF	126.52	126.58	125.89	126.04	3040723.0
2015-07-17 10:00:00	IWM	ETF	126.0899	126.15	125.64	125.83	3589047.0
2015-07-17 11:00:00	IWM	ETF	125.83	125.85	125.54	125.615	1727436.0
2015-07-17 12:00:00	IWM	ETF	125.62	125.7	125.36	125.38	1771113.0
2015-07-17 13:00:00	IWM	ETF	125.38	125.55	125.36	125.425	1822599.0
2015-07-17 14:00:00	IWM	ETF	125.429	125.74	125.4	125.58	1370487.0
2015-07-17 15:00:00	IWM	ETF	125.58	125.89	125.46	125.72	4552026.0
2015-07-17 16:00:00	IWM	ETF	125.73	125.8	125.59	125.67	2657796.0
2015-07-17 17:00:00	IWM	ETF	125.67	125.67	125.66	125.66	609.0
2015-07-17 18:00:00	IWM	ETF	125.76	125.76	125.73	125.73	69900.0
2015-07-17 19:00:00	IWM	ETF	125.7	125.77	125.7	125.77	600.0
2015-07-17 07:00:00	DIA	ETF	180.7	180.7	180.7	180.7	100.0
2015-07-17 08:00:00	DIA	ETF	180.7	180.7	180.68	180.68	600.0
2015-07-17 09:00:00	DIA	ETF	180.68	180.68	180.14	180.26	632030.0
2015-07-17 10:00:00	DIA	ETF	180.2599	180.345	180.01	180.1699	722558.0
2015-07-17 11:00:00	DIA	ETF	180.19	180.29	180.08	180.15	287536.0
2015-07-17 12:00:00	DIA	ETF	180.15	180.267	180.09	180.24	207780.0

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

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