PREVIEW / futures_1hour / 2012-12-19

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-19.parquet
  size:    49 KB
  rows:    1,518

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
2012-12-19 00:00:00	ES	Futures	1478.73	1480.02	1478.48	1479.5	2906.0
2012-12-19 01:00:00	ES	Futures	1479.76	1480.53	1479.5	1480.27	3558.0
2012-12-19 02:00:00	ES	Futures	1480.27	1481.04	1479.25	1480.79	6930.0
2012-12-19 03:00:00	ES	Futures	1480.79	1481.56	1478.99	1479.5	15422.0
2012-12-19 04:00:00	ES	Futures	1479.5	1481.04	1478.73	1481.04	13117.0
2012-12-19 05:00:00	ES	Futures	1481.04	1482.58	1480.79	1481.56	15845.0
2012-12-19 06:00:00	ES	Futures	1481.56	1482.58	1481.3	1482.07	14497.0
2012-12-19 07:00:00	ES	Futures	1482.07	1482.84	1481.56	1482.58	18917.0
2012-12-19 08:00:00	ES	Futures	1482.33	1483.87	1481.81	1483.1	37602.0
2012-12-19 09:00:00	ES	Futures	1482.84	1484.12	1477.19	1477.45	204348.0
2012-12-19 10:00:00	ES	Futures	1477.45	1478.73	1474.89	1477.96	244947.0
2012-12-19 11:00:00	ES	Futures	1477.71	1480.02	1477.19	1477.96	209303.0
2012-12-19 12:00:00	ES	Futures	1477.96	1480.02	1475.91	1477.71	138839.0
2012-12-19 13:00:00	ES	Futures	1477.96	1478.48	1474.89	1476.43	103874.0
2012-12-19 14:00:00	ES	Futures	1476.43	1476.68	1471.29	1473.09	186532.0
2012-12-19 15:00:00	ES	Futures	1473.09	1476.17	1468.73	1469.24	275381.0
2012-12-19 16:00:00	ES	Futures	1469.24	1471.29	1467.7	1468.21	96115.0
2012-12-19 17:00:00	ES	Futures	1468.21	1468.47	1465.9	1466.42	7863.0
2012-12-19 18:00:00	ES	Futures	1466.67	1466.93	1465.14	1466.67	8431.0
2012-12-19 19:00:00	ES	Futures	1466.42	1467.44	1465.9	1467.44	6133.0
2012-12-19 20:00:00	ES	Futures	1467.19	1468.21	1466.93	1467.44	4930.0
2012-12-19 21:00:00	ES	Futures	1467.44	1467.96	1466.93	1467.44	3180.0
2012-12-19 22:00:00	ES	Futures	1467.19	1467.44	1466.16	1466.67	4213.0
2012-12-19 23:00:00	ES	Futures	1466.67	1467.96	1464.88	1465.14	8069.0
2012-12-19 00:00:00	NQ	Futures	3146.75	3148.79	3146.75	3148.2	211.0
2012-12-19 01:00:00	NQ	Futures	3148.2	3151.11	3148.2	3150.82	300.0
2012-12-19 02:00:00	NQ	Futures	3150.82	3154.32	3147.91	3153.73	1772.0
2012-12-19 03:00:00	NQ	Futures	3153.73	3155.48	3150.24	3152.28	2109.0
2012-12-19 04:00:00	NQ	Futures	3152.28	3154.61	3149.66	3154.32	1425.0
2012-12-19 05:00:00	NQ	Futures	3154.61	3159.55	3154.02	3154.9	2639.0
2012-12-19 06:00:00	NQ	Futures	3155.19	3157.81	3153.44	3154.61	1464.0
2012-12-19 07:00:00	NQ	Futures	3154.61	3158.39	3154.02	3157.23	1971.0
2012-12-19 08:00:00	NQ	Futures	3157.23	3157.52	3151.99	3156.06	4789.0
2012-12-19 09:00:00	NQ	Futures	3156.06	3158.1	3145.29	3145.29	29084.0
2012-12-19 10:00:00	NQ	Futures	3145.29	3151.11	3138.6	3147.62	35496.0
2012-12-19 11:00:00	NQ	Futures	3147.91	3156.64	3147.04	3147.33	31919.0
2012-12-19 12:00:00	NQ	Futures	3147.33	3152.28	3143.84	3146.75	22103.0
2012-12-19 13:00:00	NQ	Futures	3147.04	3149.37	3137.72	3143.25	21400.0
2012-12-19 14:00:00	NQ	Futures	3142.96	3143.84	3133.65	3138.89	23205.0
2012-12-19 15:00:00	NQ	Futures	3138.6	3147.33	3132.49	3133.36	35994.0
2012-12-19 16:00:00	NQ	Futures	3133.65	3137.43	3132.78	3132.78	6771.0
2012-12-19 17:00:00	NQ	Futures	3133.36	3133.94	3128.99	3129.28	361.0
2012-12-19 18:00:00	NQ	Futures	3129.57	3131.03	3126.66	3128.99	702.0
2012-12-19 19:00:00	NQ	Futures	3128.7	3131.32	3127.83	3131.32	670.0
2012-12-19 20:00:00	NQ	Futures	3131.32	3133.07	3130.74	3131.03	367.0
2012-12-19 21:00:00	NQ	Futures	3130.74	3132.19	3129.57	3131.32	281.0
2012-12-19 22:00:00	NQ	Futures	3130.74	3130.74	3128.99	3129.87	291.0
2012-12-19 23:00:00	NQ	Futures	3130.16	3132.78	3127.54	3128.12	956.0
2012-12-19 00:00:00	YM	Futures	13355.0	13363.0	13354.0	13361.0	156.0
2012-12-19 01:00:00	YM	Futures	13361.0	13376.1	13361.0	13373.1	641.0

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

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