PREVIEW / etf_1hour / 2013-08-06

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-08-06.parquet
  size:    205 KB
  rows:    6,407

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-06 04:00:00	SPY	ETF	170.68	170.71	170.65	170.69	2070.0
2013-08-06 05:00:00	SPY	ETF	170.71	170.83	170.65	170.65	4200.0
2013-08-06 06:00:00	SPY	ETF	170.63	170.63	170.41	170.44	9400.0
2013-08-06 07:00:00	SPY	ETF	170.41	170.5	170.35	170.44	62150.0
2013-08-06 08:00:00	SPY	ETF	170.45	170.56	170.37	170.45	400386.0
2013-08-06 09:00:00	SPY	ETF	170.47	170.52	170.02	170.19	12109997.0
2013-08-06 10:00:00	SPY	ETF	170.18	170.2	169.41	169.41	19823053.0
2013-08-06 11:00:00	SPY	ETF	169.41	169.81	169.35	169.77	9916806.0
2013-08-06 12:00:00	SPY	ETF	169.77	170.7402	169.61	169.95	5790532.0
2013-08-06 13:00:00	SPY	ETF	169.94	169.97	169.69	169.721	4870835.0
2013-08-06 14:00:00	SPY	ETF	169.73	169.85	169.565	169.74	5394889.0
2013-08-06 15:00:00	SPY	ETF	169.75	169.99	169.65	169.75	14003649.0
2013-08-06 16:00:00	SPY	ETF	169.76	170.2712	169.5011	169.81	12632251.0
2013-08-06 17:00:00	SPY	ETF	169.8	169.8	169.73	169.77	142079.0
2013-08-06 18:00:00	SPY	ETF	169.77	169.84	169.69	169.7	87800.0
2013-08-06 19:00:00	SPY	ETF	169.72	169.72	169.62	169.69	30279.0
2013-08-06 04:00:00	QQQ	ETF	77.02	77.04	77.02	77.02	6200.0
2013-08-06 05:00:00	QQQ	ETF	77.04	77.06	76.98	76.98	4400.0
2013-08-06 06:00:00	QQQ	ETF	76.96	76.96	76.92	76.94	4000.0
2013-08-06 07:00:00	QQQ	ETF	76.92	76.96	76.92	76.94	14815.0
2013-08-06 08:00:00	QQQ	ETF	76.92	77.01	76.79	76.96	51800.0
2013-08-06 09:00:00	QQQ	ETF	76.94	76.99	76.71	76.8099	1846815.0
2013-08-06 10:00:00	QQQ	ETF	76.81	76.82	76.2901	76.2901	3627809.0
2013-08-06 11:00:00	QQQ	ETF	76.29	76.53	76.25	76.52	1932860.0
2013-08-06 12:00:00	QQQ	ETF	76.51	76.64	76.49	76.63	1008964.0
2013-08-06 13:00:00	QQQ	ETF	76.63	76.63	76.47	76.47	838077.0
2013-08-06 14:00:00	QQQ	ETF	76.465	76.53	76.34	76.47	1548007.0
2013-08-06 15:00:00	QQQ	ETF	76.47	76.61	76.46	76.54	3027615.0
2013-08-06 16:00:00	QQQ	ETF	76.54	76.8361	76.49	76.5499	1222629.0
2013-08-06 17:00:00	QQQ	ETF	76.53	76.53	76.52	76.52	2200.0
2013-08-06 18:00:00	QQQ	ETF	76.53	76.53	76.49	76.49	4220.0
2013-08-06 19:00:00	QQQ	ETF	76.49	76.49	76.47	76.49	891.0
2013-08-06 06:00:00	IWM	ETF	105.4	105.4	105.4	105.4	100.0
2013-08-06 07:00:00	IWM	ETF	105.35	105.36	105.35	105.36	200.0
2013-08-06 08:00:00	IWM	ETF	105.34	105.42	105.31	105.33	16844.0
2013-08-06 09:00:00	IWM	ETF	105.34	105.34	104.7	104.83	3460562.0
2013-08-06 10:00:00	IWM	ETF	104.82	104.84	104.19	104.2	5892118.0
2013-08-06 11:00:00	IWM	ETF	104.19	104.53	104.15	104.49	3284331.0
2013-08-06 12:00:00	IWM	ETF	104.5	104.58	104.335	104.55	1205169.0
2013-08-06 13:00:00	IWM	ETF	104.555	104.58	104.35	104.45	823653.0
2013-08-06 14:00:00	IWM	ETF	104.44	104.53	104.3	104.45	1938822.0
2013-08-06 15:00:00	IWM	ETF	104.45	104.59	104.34	104.44	4270277.0
2013-08-06 16:00:00	IWM	ETF	104.44	105.5203	104.4	104.42	2163478.0
2013-08-06 17:00:00	IWM	ETF	104.41	104.41	104.36	104.36	7890.0
2013-08-06 19:00:00	IWM	ETF	104.37	104.37	104.36	104.36	300.0
2013-08-06 06:00:00	DIA	ETF	155.53	155.53	155.49	155.49	5500.0
2013-08-06 07:00:00	DIA	ETF	155.47	155.47	155.47	155.47	1500.0
2013-08-06 08:00:00	DIA	ETF	155.45	155.53	155.45	155.53	1050.0
2013-08-06 09:00:00	DIA	ETF	155.52	155.53	154.83	154.98	733282.0
2013-08-06 10:00:00	DIA	ETF	154.975	154.985	154.44	154.469	842393.0

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

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