PREVIEW / etf_1hour / 2013-08-12

all etf 1-hour files

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

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-12 04:00:00	SPY	ETF	169.0	169.0	168.27	168.35	41377.0
2013-08-12 05:00:00	SPY	ETF	168.32	168.32	168.0	168.18	71800.0
2013-08-12 06:00:00	SPY	ETF	168.2	168.29	168.2	168.27	46079.0
2013-08-12 07:00:00	SPY	ETF	168.29	168.47	168.27	168.37	328722.0
2013-08-12 08:00:00	SPY	ETF	168.29	168.58	168.29	168.54	1304084.0
2013-08-12 09:00:00	SPY	ETF	168.54	169.05	168.37	168.9	12586108.0
2013-08-12 10:00:00	SPY	ETF	168.9	169.28	168.89	169.248	13198629.0
2013-08-12 11:00:00	SPY	ETF	169.24	169.31	169.03	169.12	7633245.0
2013-08-12 12:00:00	SPY	ETF	169.118	169.13	168.8	169.0699	7867012.0
2013-08-12 13:00:00	SPY	ETF	169.061	169.13	168.76	168.84	4503461.0
2013-08-12 14:00:00	SPY	ETF	168.8301	169.0	168.79	169.0	4534982.0
2013-08-12 15:00:00	SPY	ETF	168.995	169.24	168.89	169.11	10254665.0
2013-08-12 16:00:00	SPY	ETF	169.1	169.2995	168.3393	169.28	5018629.0
2013-08-12 17:00:00	SPY	ETF	169.28	169.33	169.27	169.3	229518.0
2013-08-12 18:00:00	SPY	ETF	169.31	169.31	169.25	169.26	43605.0
2013-08-12 19:00:00	SPY	ETF	169.26	169.26	169.18	169.23	71958.0
2013-08-12 04:00:00	QQQ	ETF	76.44	76.44	76.09	76.11	24920.0
2013-08-12 05:00:00	QQQ	ETF	76.09	76.09	75.97	76.02	11300.0
2013-08-12 06:00:00	QQQ	ETF	76.03	76.09	76.03	76.09	6700.0
2013-08-12 07:00:00	QQQ	ETF	76.1	76.19	76.1	76.17	17410.0
2013-08-12 08:00:00	QQQ	ETF	76.17	76.26	76.11	76.26	42666.0
2013-08-12 09:00:00	QQQ	ETF	76.25	76.59	76.17	76.54	2447445.0
2013-08-12 10:00:00	QQQ	ETF	76.54	76.78	76.54	76.77	3129485.0
2013-08-12 11:00:00	QQQ	ETF	76.77	76.8099	76.64	76.68	1715850.0
2013-08-12 12:00:00	QQQ	ETF	76.68	76.69	76.5	76.65	1483929.0
2013-08-12 13:00:00	QQQ	ETF	76.659	76.73	76.545	76.58	1527471.0
2013-08-12 14:00:00	QQQ	ETF	76.572	76.69	76.54	76.69	1464082.0
2013-08-12 15:00:00	QQQ	ETF	76.69	76.76	76.63	76.67	2940837.0
2013-08-12 16:00:00	QQQ	ETF	76.66	76.74	76.4989	76.74	3391711.0
2013-08-12 17:00:00	QQQ	ETF	76.75	76.78	76.67	76.78	505450.0
2013-08-12 18:00:00	QQQ	ETF	76.72	76.72	76.72	76.72	200.0
2013-08-12 19:00:00	QQQ	ETF	76.72	76.77	76.71	76.77	17100.0
2013-08-12 04:00:00	IWM	ETF	103.81	103.81	103.81	103.81	100.0
2013-08-12 06:00:00	IWM	ETF	103.2	103.2	103.2	103.2	100.0
2013-08-12 07:00:00	IWM	ETF	103.13	103.25	103.13	103.19	24250.0
2013-08-12 08:00:00	IWM	ETF	103.2	103.34	103.17	103.34	274369.0
2013-08-12 09:00:00	IWM	ETF	103.33	104.35	103.3	104.219	4220766.0
2013-08-12 10:00:00	IWM	ETF	104.21	104.51	104.13	104.47	2484902.0
2013-08-12 11:00:00	IWM	ETF	104.47	104.57	104.27	104.48	2199482.0
2013-08-12 12:00:00	IWM	ETF	104.48	104.49	104.29	104.482	1325972.0
2013-08-12 13:00:00	IWM	ETF	104.48	104.5	104.27	104.34	1112744.0
2013-08-12 14:00:00	IWM	ETF	104.345	104.47	104.32	104.45	1509569.0
2013-08-12 15:00:00	IWM	ETF	104.441	104.63	104.37	104.58	3378427.0
2013-08-12 16:00:00	IWM	ETF	104.57	104.66	104.2821	104.66	665544.0
2013-08-12 17:00:00	IWM	ETF	104.69	104.69	104.67	104.67	1832.0
2013-08-12 18:00:00	IWM	ETF	104.69	104.69	104.6	104.64	3170.0
2013-08-12 19:00:00	IWM	ETF	104.65	104.67	104.65	104.67	632.0
2013-08-12 04:00:00	DIA	ETF	153.99	153.99	153.7	153.7	200.0
2013-08-12 05:00:00	DIA	ETF	153.34	153.34	153.34	153.34	300.0
2013-08-12 07:00:00	DIA	ETF	153.43	153.43	153.43	153.43	500.0

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

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