PREVIEW / futures_1hour / 2013-02-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-26.parquet
  size:    51 KB
  rows:    1,571

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-02-26 00:00:00	ES	Futures	1527.74	1528.0	1525.69	1526.97	6028.0
2013-02-26 01:00:00	ES	Futures	1526.97	1527.74	1526.46	1526.72	5055.0
2013-02-26 02:00:00	ES	Futures	1526.72	1528.51	1523.12	1526.97	36166.0
2013-02-26 03:00:00	ES	Futures	1526.97	1532.62	1526.72	1530.57	79885.0
2013-02-26 04:00:00	ES	Futures	1530.82	1532.36	1529.03	1532.11	43606.0
2013-02-26 05:00:00	ES	Futures	1532.36	1532.36	1528.26	1529.03	31778.0
2013-02-26 06:00:00	ES	Futures	1529.03	1530.82	1528.77	1529.03	28262.0
2013-02-26 07:00:00	ES	Futures	1528.77	1531.85	1527.74	1531.34	53796.0
2013-02-26 08:00:00	ES	Futures	1531.34	1533.64	1528.77	1533.39	78828.0
2013-02-26 09:00:00	ES	Futures	1533.39	1535.18	1531.08	1533.9	336920.0
2013-02-26 10:00:00	ES	Futures	1534.16	1536.47	1525.43	1528.77	662269.0
2013-02-26 11:00:00	ES	Futures	1529.03	1529.28	1521.84	1525.69	408798.0
2013-02-26 12:00:00	ES	Futures	1525.69	1532.11	1524.66	1531.34	237024.0
2013-02-26 13:00:00	ES	Futures	1531.08	1533.9	1528.0	1532.11	222633.0
2013-02-26 14:00:00	ES	Futures	1532.36	1536.47	1531.34	1533.64	207555.0
2013-02-26 15:00:00	ES	Futures	1533.9	1537.24	1531.59	1535.18	284588.0
2013-02-26 16:00:00	ES	Futures	1535.18	1535.44	1531.34	1532.62	103583.0
2013-02-26 17:00:00	ES	Futures	1532.62	1532.88	1532.11	1532.88	3111.0
2013-02-26 18:00:00	ES	Futures	1532.62	1533.13	1531.85	1532.11	6109.0
2013-02-26 19:00:00	ES	Futures	1532.11	1533.9	1530.82	1531.59	10600.0
2013-02-26 20:00:00	ES	Futures	1531.59	1532.11	1529.8	1531.08	10715.0
2013-02-26 21:00:00	ES	Futures	1531.34	1531.85	1530.57	1531.85	3052.0
2013-02-26 22:00:00	ES	Futures	1531.59	1532.36	1530.82	1531.08	3037.0
2013-02-26 23:00:00	ES	Futures	1531.08	1531.59	1530.82	1531.34	1989.0
2013-02-26 00:00:00	NQ	Futures	3148.79	3149.66	3145.0	3149.08	581.0
2013-02-26 01:00:00	NQ	Futures	3149.37	3150.82	3148.79	3149.37	344.0
2013-02-26 02:00:00	NQ	Futures	3148.79	3152.28	3142.67	3151.11	2430.0
2013-02-26 03:00:00	NQ	Futures	3151.11	3155.48	3149.95	3152.86	5639.0
2013-02-26 04:00:00	NQ	Futures	3152.57	3155.19	3150.53	3154.9	2675.0
2013-02-26 05:00:00	NQ	Futures	3155.19	3155.48	3149.08	3150.24	1973.0
2013-02-26 06:00:00	NQ	Futures	3150.24	3152.57	3149.66	3150.24	1763.0
2013-02-26 07:00:00	NQ	Futures	3150.24	3154.32	3146.75	3153.15	5758.0
2013-02-26 08:00:00	NQ	Futures	3152.86	3156.35	3148.49	3156.35	5667.0
2013-02-26 09:00:00	NQ	Futures	3156.06	3157.52	3145.29	3156.06	48146.0
2013-02-26 10:00:00	NQ	Futures	3156.35	3164.79	3140.93	3148.49	71605.0
2013-02-26 11:00:00	NQ	Futures	3148.79	3150.24	3130.74	3135.98	53595.0
2013-02-26 12:00:00	NQ	Futures	3135.98	3147.91	3133.07	3145.0	24511.0
2013-02-26 13:00:00	NQ	Futures	3144.71	3158.39	3139.47	3154.61	24859.0
2013-02-26 14:00:00	NQ	Futures	3154.32	3160.72	3151.99	3157.52	22556.0
2013-02-26 15:00:00	NQ	Futures	3157.81	3163.05	3150.82	3158.39	34357.0
2013-02-26 16:00:00	NQ	Futures	3158.39	3158.97	3153.44	3156.06	6846.0
2013-02-26 17:00:00	NQ	Futures	3156.35	3156.94	3156.06	3156.94	106.0
2013-02-26 18:00:00	NQ	Futures	3156.35	3157.52	3155.19	3156.06	301.0
2013-02-26 19:00:00	NQ	Futures	3156.06	3158.39	3153.44	3154.02	569.0
2013-02-26 20:00:00	NQ	Futures	3154.32	3155.19	3150.53	3152.57	656.0
2013-02-26 21:00:00	NQ	Futures	3152.57	3154.61	3151.7	3154.32	277.0
2013-02-26 22:00:00	NQ	Futures	3154.61	3155.48	3152.57	3152.86	296.0
2013-02-26 23:00:00	NQ	Futures	3152.86	3153.73	3152.28	3153.44	213.0
2013-02-26 00:00:00	YM	Futures	13885.2	13886.2	13870.1	13882.1	739.0
2013-02-26 01:00:00	YM	Futures	13883.1	13886.2	13877.1	13878.1	401.0

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

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