PREVIEW / etf_1hour / 2013-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-09.parquet
  size:    198 KB
  rows:    6,217

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-09 04:00:00	SPY	ETF	169.85	169.85	169.35	169.42	15900.0
2013-08-09 05:00:00	SPY	ETF	169.44	169.49	169.35	169.35	32100.0
2013-08-09 06:00:00	SPY	ETF	169.32	169.32	169.13	169.26	19023.0
2013-08-09 07:00:00	SPY	ETF	169.27	169.44	169.24	169.41	108863.0
2013-08-09 08:00:00	SPY	ETF	169.31	169.48	169.23	169.38	600248.0
2013-08-09 09:00:00	SPY	ETF	169.35	170.1	169.32	169.97	9682404.0
2013-08-09 10:00:00	SPY	ETF	169.97	170.02	169.31	169.375	13957420.0
2013-08-09 11:00:00	SPY	ETF	169.37	169.379	168.72	169.14	17805954.0
2013-08-09 12:00:00	SPY	ETF	169.14	169.56	169.0	169.41	9776724.0
2013-08-09 13:00:00	SPY	ETF	169.415	169.7	169.34	169.5356	7798741.0
2013-08-09 14:00:00	SPY	ETF	169.53	169.61	169.265	169.455	7811445.0
2013-08-09 15:00:00	SPY	ETF	169.455	169.555	169.17	169.3	15732241.0
2013-08-09 16:00:00	SPY	ETF	169.31	169.4808	169.02	169.05	5296141.0
2013-08-09 17:00:00	SPY	ETF	169.05	169.06	168.98	169.01	315437.0
2013-08-09 18:00:00	SPY	ETF	169.01	169.05	169.01	169.01	9139.0
2013-08-09 19:00:00	SPY	ETF	169.0	169.04	168.97	169.02	23163.0
2013-08-09 04:00:00	QQQ	ETF	76.71	76.71	76.56	76.6	23800.0
2013-08-09 05:00:00	QQQ	ETF	76.62	76.68	76.62	76.64	5500.0
2013-08-09 06:00:00	QQQ	ETF	76.62	76.64	76.56	76.64	8150.0
2013-08-09 07:00:00	QQQ	ETF	76.63	76.68	76.63	76.68	51000.0
2013-08-09 08:00:00	QQQ	ETF	76.71	76.72	76.65	76.66	193174.0
2013-08-09 09:00:00	QQQ	ETF	76.66	76.94	76.63	76.87	2712423.0
2013-08-09 10:00:00	QQQ	ETF	76.88	76.91	76.58	76.62	3041206.0
2013-08-09 11:00:00	QQQ	ETF	76.615	76.615	76.27	76.5	3216898.0
2013-08-09 12:00:00	QQQ	ETF	76.49	76.75	76.46	76.6527	1624262.0
2013-08-09 13:00:00	QQQ	ETF	76.66	76.75	76.6	76.65	1215541.0
2013-08-09 14:00:00	QQQ	ETF	76.65	76.6799	76.49	76.56	2388202.0
2013-08-09 15:00:00	QQQ	ETF	76.555	76.59	76.43	76.49	3025114.0
2013-08-09 16:00:00	QQQ	ETF	76.5	76.7472	76.43	76.44	965143.0
2013-08-09 17:00:00	QQQ	ETF	76.42	76.5	76.42	76.49	13960.0
2013-08-09 18:00:00	QQQ	ETF	76.4	76.4	76.34	76.34	2479.0
2013-08-09 19:00:00	QQQ	ETF	76.4	76.4	76.37	76.4	6300.0
2013-08-09 06:00:00	IWM	ETF	103.69	103.72	103.69	103.71	4000.0
2013-08-09 07:00:00	IWM	ETF	103.7	103.9	103.7	103.9	22500.0
2013-08-09 08:00:00	IWM	ETF	103.75	103.91	103.74	103.78	120871.0
2013-08-09 09:00:00	IWM	ETF	103.82	104.57	103.81	104.42	2837781.0
2013-08-09 10:00:00	IWM	ETF	104.43	104.47	103.99	104.1	5461028.0
2013-08-09 11:00:00	IWM	ETF	104.1	104.1	103.52	103.95	5316661.0
2013-08-09 12:00:00	IWM	ETF	103.95	104.32	103.87	104.19	3257802.0
2013-08-09 13:00:00	IWM	ETF	104.19	104.44	104.16	104.3	1776949.0
2013-08-09 14:00:00	IWM	ETF	104.31	104.39	104.15	104.28	2333544.0
2013-08-09 15:00:00	IWM	ETF	104.28	104.33	104.0	104.03	4081218.0
2013-08-09 16:00:00	IWM	ETF	104.04	104.06	103.81	103.99	888992.0
2013-08-09 17:00:00	IWM	ETF	103.99	103.99	103.91	103.91	53559.0
2013-08-09 18:00:00	IWM	ETF	103.83	103.84	103.82	103.82	10735.0
2013-08-09 04:00:00	DIA	ETF	154.7	154.7	154.7	154.7	100.0
2013-08-09 06:00:00	DIA	ETF	154.28	154.28	154.28	154.28	200.0
2013-08-09 08:00:00	DIA	ETF	154.41	154.41	154.3	154.3	700.0
2013-08-09 09:00:00	DIA	ETF	154.23	154.95	154.23	154.9	352878.0
2013-08-09 10:00:00	DIA	ETF	154.88	154.92	154.09	154.13	830112.0

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

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