PREVIEW / etf_1hour / 2013-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-10-17.parquet
  size:    219 KB
  rows:    6,893

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
2013-10-17 04:00:00	SPY	ETF	171.77	171.77	171.14	171.41	234361.0
2013-10-17 05:00:00	SPY	ETF	171.43	171.47	171.32	171.39	43600.0
2013-10-17 06:00:00	SPY	ETF	171.41	171.69	171.4	171.65	60600.0
2013-10-17 07:00:00	SPY	ETF	171.67	171.73	171.55	171.68	246319.0
2013-10-17 08:00:00	SPY	ETF	171.67	171.68	171.29	171.3	1406673.0
2013-10-17 09:00:00	SPY	ETF	171.3	171.82	171.15	171.65	15699973.0
2013-10-17 10:00:00	SPY	ETF	171.65	172.16	171.62	172.05	18275297.0
2013-10-17 11:00:00	SPY	ETF	172.06	172.68	172.04	172.5683	17544990.0
2013-10-17 12:00:00	SPY	ETF	172.565	172.95	172.5	172.94	10961594.0
2013-10-17 13:00:00	SPY	ETF	172.95	172.95	172.6	172.61	9294625.0
2013-10-17 14:00:00	SPY	ETF	172.605	172.78	172.55	172.77	9600661.0
2013-10-17 15:00:00	SPY	ETF	172.76	173.32	172.66	173.22	29761562.0
2013-10-17 16:00:00	SPY	ETF	173.22	173.39	171.4	173.26	11133873.0
2013-10-17 17:00:00	SPY	ETF	173.26	173.34	172.1155	173.22	1285491.0
2013-10-17 18:00:00	SPY	ETF	173.23	173.45	173.2	173.41	134163.0
2013-10-17 19:00:00	SPY	ETF	173.4	173.82	173.38	173.62	251688.0
2013-10-17 04:00:00	QQQ	ETF	80.0	80.09	79.95	80.07	77100.0
2013-10-17 05:00:00	QQQ	ETF	80.08	80.08	80.0	80.05	35972.0
2013-10-17 06:00:00	QQQ	ETF	80.06	80.16	80.06	80.16	10300.0
2013-10-17 07:00:00	QQQ	ETF	80.15	80.16	80.11	80.14	200515.0
2013-10-17 08:00:00	QQQ	ETF	80.15	80.15	79.98	79.99	211094.0
2013-10-17 09:00:00	QQQ	ETF	79.99	80.27	79.91	80.17	6271809.0
2013-10-17 10:00:00	QQQ	ETF	80.18	80.38	80.11	80.35	5359681.0
2013-10-17 11:00:00	QQQ	ETF	80.35	80.65	80.349	80.61	3889606.0
2013-10-17 12:00:00	QQQ	ETF	80.62	80.78	80.591	80.75	2801950.0
2013-10-17 13:00:00	QQQ	ETF	80.75	80.76	80.571	80.58	2241675.0
2013-10-17 14:00:00	QQQ	ETF	80.58	80.66	80.54	80.64	1862197.0
2013-10-17 15:00:00	QQQ	ETF	80.64	80.87	80.6	80.82	5894041.0
2013-10-17 16:00:00	QQQ	ETF	80.83	81.17	80.164	81.16	2000127.0
2013-10-17 17:00:00	QQQ	ETF	80.37	81.3	80.37	81.25	153808.0
2013-10-17 18:00:00	QQQ	ETF	81.2	81.29	81.18	81.29	226854.0
2013-10-17 19:00:00	QQQ	ETF	81.27	81.47	81.27	81.4	46819.0
2013-10-17 06:00:00	IWM	ETF	108.14	108.15	108.14	108.15	600.0
2013-10-17 07:00:00	IWM	ETF	108.23	108.26	108.2	108.21	34640.0
2013-10-17 08:00:00	IWM	ETF	108.2	108.2	107.97	108.01	95615.0
2013-10-17 09:00:00	IWM	ETF	108.01	108.48	107.74	108.31	5474517.0
2013-10-17 10:00:00	IWM	ETF	108.315	108.7	108.2	108.7	4856475.0
2013-10-17 11:00:00	IWM	ETF	108.71	109.13	108.69	109.04	4003310.0
2013-10-17 12:00:00	IWM	ETF	109.05	109.25	109.0	109.19	2997304.0
2013-10-17 13:00:00	IWM	ETF	109.2	109.24	108.94	108.96	2323773.0
2013-10-17 14:00:00	IWM	ETF	108.98	109.08	108.88	109.0399	2173597.0
2013-10-17 15:00:00	IWM	ETF	109.04	109.46	108.95	109.45	6767851.0
2013-10-17 16:00:00	IWM	ETF	109.45	109.59	108.3971	109.46	3804923.0
2013-10-17 17:00:00	IWM	ETF	109.51	109.6	109.45	109.47	16020.0
2013-10-17 18:00:00	IWM	ETF	109.52	109.59	109.5	109.59	4299.0
2013-10-17 19:00:00	IWM	ETF	109.56	109.8	109.56	109.75	18664.0
2013-10-17 04:00:00	DIA	ETF	152.39	152.39	152.39	152.39	200.0
2013-10-17 06:00:00	DIA	ETF	152.69	152.69	152.65	152.65	600.0
2013-10-17 07:00:00	DIA	ETF	152.65	152.65	152.21	152.34	18615.0
2013-10-17 08:00:00	DIA	ETF	152.42	152.46	152.15	152.15	111949.0

> showing 50 of 6,893 rows — these rows as CSV

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