PREVIEW / futures_1hour / 2012-11-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-11-02.parquet
  size:    40 KB
  rows:    1,194

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-11-02 00:00:00	ES	Futures	1453.08	1453.84	1452.82	1452.82	2339.0
2012-11-02 01:00:00	ES	Futures	1452.82	1453.59	1452.57	1453.33	3823.0
2012-11-02 02:00:00	ES	Futures	1453.08	1454.1	1452.82	1453.33	2889.0
2012-11-02 03:00:00	ES	Futures	1453.33	1454.35	1452.31	1454.1	9400.0
2012-11-02 04:00:00	ES	Futures	1454.1	1454.35	1451.8	1451.8	23835.0
2012-11-02 05:00:00	ES	Futures	1451.8	1452.82	1451.29	1452.57	18781.0
2012-11-02 06:00:00	ES	Futures	1452.31	1455.12	1452.31	1454.61	16387.0
2012-11-02 07:00:00	ES	Futures	1454.61	1455.12	1454.1	1454.61	25200.0
2012-11-02 08:00:00	ES	Futures	1454.61	1462.79	1451.29	1461.51	173234.0
2012-11-02 09:00:00	ES	Futures	1461.51	1462.53	1454.87	1456.91	260088.0
2012-11-02 10:00:00	ES	Futures	1457.16	1457.68	1450.01	1451.03	330975.0
2012-11-02 11:00:00	ES	Futures	1451.29	1453.33	1449.5	1452.31	270169.0
2012-11-02 12:00:00	ES	Futures	1452.31	1453.59	1450.52	1451.54	128636.0
2012-11-02 13:00:00	ES	Futures	1451.8	1452.57	1447.97	1448.48	116304.0
2012-11-02 14:00:00	ES	Futures	1448.22	1448.48	1441.84	1444.14	184658.0
2012-11-02 15:00:00	ES	Futures	1444.14	1445.16	1438.52	1440.05	337768.0
2012-11-02 16:00:00	ES	Futures	1440.05	1440.05	1435.71	1436.22	144643.0
2012-11-02 00:00:00	NQ	Futures	3117.01	3120.79	3116.43	3118.18	660.0
2012-11-02 01:00:00	NQ	Futures	3117.88	3119.63	3116.43	3117.88	312.0
2012-11-02 02:00:00	NQ	Futures	3117.59	3121.66	3117.01	3121.37	368.0
2012-11-02 03:00:00	NQ	Futures	3121.37	3121.66	3116.72	3121.37	1201.0
2012-11-02 04:00:00	NQ	Futures	3121.37	3121.95	3117.59	3118.18	2429.0
2012-11-02 05:00:00	NQ	Futures	3118.18	3121.08	3116.14	3119.92	2602.0
2012-11-02 06:00:00	NQ	Futures	3119.92	3123.12	3119.63	3121.37	1387.0
2012-11-02 07:00:00	NQ	Futures	3121.37	3122.24	3119.63	3119.92	1912.0
2012-11-02 08:00:00	NQ	Futures	3119.92	3131.25	3114.11	3129.51	17970.0
2012-11-02 09:00:00	NQ	Futures	3129.51	3130.96	3112.36	3121.08	49335.0
2012-11-02 10:00:00	NQ	Futures	3120.79	3121.37	3110.04	3113.82	50463.0
2012-11-02 11:00:00	NQ	Futures	3114.4	3116.14	3107.13	3112.36	36776.0
2012-11-02 12:00:00	NQ	Futures	3112.07	3116.14	3109.46	3112.07	13354.0
2012-11-02 13:00:00	NQ	Futures	3112.07	3113.82	3103.07	3104.52	19021.0
2012-11-02 14:00:00	NQ	Futures	3104.23	3104.23	3087.08	3093.19	31180.0
2012-11-02 15:00:00	NQ	Futures	3093.19	3096.96	3077.49	3078.95	45528.0
2012-11-02 16:00:00	NQ	Futures	3078.66	3079.24	3070.23	3071.39	9719.0
2012-11-02 00:00:00	YM	Futures	13158.8	13166.8	13158.8	13158.8	247.0
2012-11-02 01:00:00	YM	Futures	13158.8	13166.8	13155.8	13162.8	296.0
2012-11-02 02:00:00	YM	Futures	13163.8	13166.8	13157.8	13166.8	448.0
2012-11-02 03:00:00	YM	Futures	13166.8	13168.8	13153.8	13166.8	566.0
2012-11-02 04:00:00	YM	Futures	13167.8	13168.8	13146.8	13147.8	1292.0
2012-11-02 05:00:00	YM	Futures	13147.8	13159.8	13142.8	13157.8	1419.0
2012-11-02 06:00:00	YM	Futures	13155.8	13172.8	13155.8	13170.8	1026.0
2012-11-02 07:00:00	YM	Futures	13168.8	13173.8	13163.8	13167.8	1363.0
2012-11-02 08:00:00	YM	Futures	13168.8	13225.8	13132.8	13217.8	12706.0
2012-11-02 09:00:00	YM	Futures	13217.8	13232.8	13161.8	13176.8	15593.0
2012-11-02 10:00:00	YM	Futures	13176.8	13181.8	13112.7	13126.8	19412.0
2012-11-02 11:00:00	YM	Futures	13127.8	13149.8	13112.7	13137.8	12389.0
2012-11-02 12:00:00	YM	Futures	13137.8	13151.8	13125.8	13135.8	6500.0
2012-11-02 13:00:00	YM	Futures	13134.8	13140.8	13099.7	13103.7	7675.0
2012-11-02 14:00:00	YM	Futures	13103.7	13103.7	13049.7	13066.7	13199.0
2012-11-02 15:00:00	YM	Futures	13066.7	13073.7	13017.7	13035.7	18395.0

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

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