PREVIEW / etf_1hour / 2013-08-26

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-26.parquet
  size:    206 KB
  rows:    6,478

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-08-26 04:00:00	SPY	ETF	166.62	166.62	166.54	166.58	7600.0
2013-08-26 05:00:00	SPY	ETF	166.54	166.65	166.54	166.54	20200.0
2013-08-26 06:00:00	SPY	ETF	166.54	166.56	166.41	166.48	31400.0
2013-08-26 07:00:00	SPY	ETF	166.52	166.69	166.52	166.54	115115.0
2013-08-26 08:00:00	SPY	ETF	166.54	167.11	166.28	166.75	1002857.0
2013-08-26 09:00:00	SPY	ETF	166.76	167.0	166.53	166.811	8581566.0
2013-08-26 10:00:00	SPY	ETF	166.81	167.2	166.74	167.18	10004542.0
2013-08-26 11:00:00	SPY	ETF	167.18	167.3	167.06	167.12	8352924.0
2013-08-26 12:00:00	SPY	ETF	167.12	167.17	166.97	167.115	5085687.0
2013-08-26 13:00:00	SPY	ETF	167.11	167.19	166.79	166.91	5984499.0
2013-08-26 14:00:00	SPY	ETF	166.902	166.95	166.81	166.93	4712591.0
2013-08-26 15:00:00	SPY	ETF	166.94	166.97	165.89	165.98	29687456.0
2013-08-26 16:00:00	SPY	ETF	165.99	167.1727	165.87	166.0	10503142.0
2013-08-26 17:00:00	SPY	ETF	166.0	166.03	165.97	166.0	64791.0
2013-08-26 18:00:00	SPY	ETF	166.0	166.1	165.66	165.74	90277.0
2013-08-26 19:00:00	SPY	ETF	165.72	165.81	165.69	165.8	121880.0
2013-08-26 04:00:00	QQQ	ETF	76.61	76.62	76.6	76.62	6700.0
2013-08-26 05:00:00	QQQ	ETF	76.66	76.67	76.64	76.64	2150.0
2013-08-26 06:00:00	QQQ	ETF	76.6	76.62	76.6	76.62	2440.0
2013-08-26 07:00:00	QQQ	ETF	76.66	76.7	76.66	76.66	10315.0
2013-08-26 08:00:00	QQQ	ETF	76.65	78.23	76.62	76.74	66363.0
2013-08-26 09:00:00	QQQ	ETF	76.74	77.0	76.6601	76.89	2134757.0
2013-08-26 10:00:00	QQQ	ETF	76.89	77.1	76.87	77.08	3021656.0
2013-08-26 11:00:00	QQQ	ETF	77.08	77.22	77.07	77.14	2453513.0
2013-08-26 12:00:00	QQQ	ETF	77.14	77.26	77.09	77.24	1853228.0
2013-08-26 13:00:00	QQQ	ETF	77.24	77.28	77.04	77.11	2294346.0
2013-08-26 14:00:00	QQQ	ETF	77.1	77.1692	77.03	77.12	1831411.0
2013-08-26 15:00:00	QQQ	ETF	77.13	77.14	76.55	76.66	7239521.0
2013-08-26 16:00:00	QQQ	ETF	76.66	77.0945	76.62	76.65	2083231.0
2013-08-26 17:00:00	QQQ	ETF	76.68	76.701	76.68	76.7	1403850.0
2013-08-26 18:00:00	QQQ	ETF	76.69	76.7	76.55	76.57	18936.0
2013-08-26 19:00:00	QQQ	ETF	76.58	76.61	76.57	76.59	7970.0
2013-08-26 07:00:00	IWM	ETF	103.26	103.26	103.24	103.24	300.0
2013-08-26 08:00:00	IWM	ETF	103.17	103.32	103.11	103.28	137225.0
2013-08-26 09:00:00	IWM	ETF	103.28	103.42	103.01	103.15	2731399.0
2013-08-26 10:00:00	IWM	ETF	103.16	103.6	103.07	103.59	3499072.0
2013-08-26 11:00:00	IWM	ETF	103.59	103.73	103.54	103.62	2727158.0
2013-08-26 12:00:00	IWM	ETF	103.62	103.67	103.48	103.6501	1453919.0
2013-08-26 13:00:00	IWM	ETF	103.66	103.82	103.55	103.61	1752058.0
2013-08-26 14:00:00	IWM	ETF	103.61	103.69	103.5488	103.66	1390153.0
2013-08-26 15:00:00	IWM	ETF	103.67	103.69	102.77	103.16	7673087.0
2013-08-26 16:00:00	IWM	ETF	103.16	103.6514	103.0	103.16	562440.0
2013-08-26 17:00:00	IWM	ETF	103.19	103.2	103.16	103.18	3400.0
2013-08-26 18:00:00	IWM	ETF	103.15	103.15	103.02	103.02	10320.0
2013-08-26 19:00:00	IWM	ETF	103.03	103.04	103.03	103.04	350.0
2013-08-26 07:00:00	DIA	ETF	149.79	149.79	149.79	149.79	200.0
2013-08-26 08:00:00	DIA	ETF	149.65	149.77	149.55	149.77	13600.0
2013-08-26 09:00:00	DIA	ETF	149.8	150.04	149.61	149.9	442315.0
2013-08-26 10:00:00	DIA	ETF	149.89	150.19	149.85	150.16	805102.0
2013-08-26 11:00:00	DIA	ETF	150.17	150.27	150.06	150.15	689088.0

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

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