PREVIEW / futures_1hour / 2013-03-06

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-06.parquet
  size:    49 KB
  rows:    1,538

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-03-06 00:00:00	ES	Futures	1578.29	1579.83	1578.04	1579.57	4934.0
2013-03-06 01:00:00	ES	Futures	1579.83	1579.83	1579.06	1579.57	3174.0
2013-03-06 02:00:00	ES	Futures	1579.57	1580.6	1579.32	1580.09	9865.0
2013-03-06 03:00:00	ES	Futures	1580.09	1583.17	1580.09	1582.91	29402.0
2013-03-06 04:00:00	ES	Futures	1582.91	1584.96	1582.4	1583.68	32519.0
2013-03-06 05:00:00	ES	Futures	1583.68	1584.19	1582.14	1582.65	18584.0
2013-03-06 06:00:00	ES	Futures	1582.4	1583.94	1582.14	1583.42	16358.0
2013-03-06 07:00:00	ES	Futures	1583.68	1583.68	1582.65	1583.68	20084.0
2013-03-06 08:00:00	ES	Futures	1583.68	1585.48	1583.17	1584.96	64309.0
2013-03-06 09:00:00	ES	Futures	1585.22	1585.48	1581.37	1584.19	247573.0
2013-03-06 10:00:00	ES	Futures	1584.19	1584.45	1579.57	1579.83	359038.0
2013-03-06 11:00:00	ES	Futures	1579.83	1581.63	1579.32	1579.57	186952.0
2013-03-06 12:00:00	ES	Futures	1579.83	1581.37	1577.78	1579.06	132523.0
2013-03-06 13:00:00	ES	Futures	1579.32	1582.14	1578.55	1581.37	58991.0
2013-03-06 14:00:00	ES	Futures	1581.37	1584.96	1579.83	1583.94	134862.0
2013-03-06 15:00:00	ES	Futures	1583.94	1584.19	1579.32	1581.37	165357.0
2013-03-06 16:00:00	ES	Futures	1581.37	1581.63	1579.06	1580.34	66945.0
2013-03-06 17:00:00	ES	Futures	1580.34	1580.6	1580.09	1580.34	1973.0
2013-03-06 18:00:00	ES	Futures	1580.34	1580.6	1579.32	1580.34	5482.0
2013-03-06 19:00:00	ES	Futures	1580.09	1580.34	1578.8	1578.8	5524.0
2013-03-06 20:00:00	ES	Futures	1579.06	1579.57	1578.29	1579.06	4276.0
2013-03-06 21:00:00	ES	Futures	1578.8	1579.83	1578.8	1579.57	1896.0
2013-03-06 22:00:00	ES	Futures	1579.32	1579.57	1578.04	1578.55	3246.0
2013-03-06 23:00:00	ES	Futures	1578.8	1579.32	1578.55	1579.32	1887.0
2013-03-06 00:00:00	NQ	Futures	3257.65	3259.97	3257.65	3259.68	238.0
2013-03-06 01:00:00	NQ	Futures	3259.97	3260.56	3259.68	3260.56	128.0
2013-03-06 02:00:00	NQ	Futures	3260.56	3263.18	3260.26	3261.72	776.0
2013-03-06 03:00:00	NQ	Futures	3261.72	3266.96	3261.43	3266.38	2140.0
2013-03-06 04:00:00	NQ	Futures	3266.38	3270.74	3265.8	3268.41	2836.0
2013-03-06 05:00:00	NQ	Futures	3268.71	3268.71	3264.05	3264.05	1583.0
2013-03-06 06:00:00	NQ	Futures	3264.05	3266.67	3263.18	3264.92	1791.0
2013-03-06 07:00:00	NQ	Futures	3264.92	3265.21	3262.3	3263.18	1596.0
2013-03-06 08:00:00	NQ	Futures	3263.18	3268.12	3261.72	3266.38	5116.0
2013-03-06 09:00:00	NQ	Futures	3266.38	3270.45	3254.15	3258.52	37034.0
2013-03-06 10:00:00	NQ	Futures	3258.81	3260.26	3248.04	3249.2	54363.0
2013-03-06 11:00:00	NQ	Futures	3249.2	3256.48	3248.62	3251.24	29022.0
2013-03-06 12:00:00	NQ	Futures	3251.24	3253.28	3247.46	3248.62	11577.0
2013-03-06 13:00:00	NQ	Futures	3248.62	3255.03	3246.88	3252.99	9561.0
2013-03-06 14:00:00	NQ	Futures	3252.7	3260.26	3249.5	3257.35	15637.0
2013-03-06 15:00:00	NQ	Futures	3257.06	3257.35	3247.17	3251.53	20600.0
2013-03-06 16:00:00	NQ	Futures	3251.82	3252.11	3247.17	3249.2	4019.0
2013-03-06 17:00:00	NQ	Futures	3249.5	3250.66	3249.5	3250.37	104.0
2013-03-06 18:00:00	NQ	Futures	3248.91	3250.37	3247.17	3248.62	307.0
2013-03-06 19:00:00	NQ	Futures	3248.33	3248.91	3247.17	3248.04	533.0
2013-03-06 20:00:00	NQ	Futures	3248.04	3249.2	3247.17	3248.04	280.0
2013-03-06 21:00:00	NQ	Futures	3248.33	3249.2	3248.33	3248.91	131.0
2013-03-06 22:00:00	NQ	Futures	3248.91	3249.2	3246.58	3247.46	352.0
2013-03-06 23:00:00	NQ	Futures	3247.75	3249.2	3247.75	3248.91	116.0
2013-03-06 00:00:00	YM	Futures	14327.8	14336.9	14324.8	14336.9	644.0
2013-03-06 01:00:00	YM	Futures	14337.9	14339.9	14332.8	14335.9	370.0

> showing 50 of 1,538 rows — these rows as CSV

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