PREVIEW / futures_1hour / 2013-02-05

all futures 1-hour files

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

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-05 00:00:00	ES	Futures	1534.67	1535.44	1534.41	1534.93	4736.0
2013-02-05 01:00:00	ES	Futures	1534.93	1535.44	1533.9	1533.9	4484.0
2013-02-05 02:00:00	ES	Futures	1533.9	1535.7	1533.13	1533.9	13247.0
2013-02-05 03:00:00	ES	Futures	1533.9	1537.75	1533.39	1537.49	36414.0
2013-02-05 04:00:00	ES	Futures	1537.49	1538.26	1536.72	1537.49	23932.0
2013-02-05 05:00:00	ES	Futures	1537.75	1539.03	1536.47	1538.78	20388.0
2013-02-05 06:00:00	ES	Futures	1538.78	1540.83	1538.01	1540.06	28173.0
2013-02-05 07:00:00	ES	Futures	1540.06	1541.34	1539.55	1539.8	35037.0
2013-02-05 08:00:00	ES	Futures	1539.8	1540.32	1537.75	1539.29	48399.0
2013-02-05 09:00:00	ES	Futures	1539.55	1544.17	1538.26	1543.14	239194.0
2013-02-05 10:00:00	ES	Futures	1543.14	1545.96	1541.86	1544.68	254989.0
2013-02-05 11:00:00	ES	Futures	1544.68	1545.96	1543.65	1544.68	213445.0
2013-02-05 12:00:00	ES	Futures	1544.42	1545.19	1543.14	1544.68	124861.0
2013-02-05 13:00:00	ES	Futures	1544.68	1548.01	1544.68	1547.5	141433.0
2013-02-05 14:00:00	ES	Futures	1547.24	1550.84	1546.99	1549.55	152607.0
2013-02-05 15:00:00	ES	Futures	1549.55	1550.58	1545.7	1546.47	265545.0
2013-02-05 16:00:00	ES	Futures	1546.22	1547.76	1545.19	1547.5	98361.0
2013-02-05 17:00:00	ES	Futures	1547.5	1548.01	1547.24	1547.24	2865.0
2013-02-05 18:00:00	ES	Futures	1546.99	1547.24	1545.7	1546.22	4979.0
2013-02-05 19:00:00	ES	Futures	1546.22	1547.24	1545.96	1546.22	5033.0
2013-02-05 20:00:00	ES	Futures	1546.22	1548.27	1545.7	1548.01	7466.0
2013-02-05 21:00:00	ES	Futures	1548.01	1548.01	1546.99	1547.76	3203.0
2013-02-05 22:00:00	ES	Futures	1547.76	1548.01	1546.47	1546.99	4073.0
2013-02-05 23:00:00	ES	Futures	1546.73	1547.76	1546.73	1547.24	4567.0
2013-02-05 00:00:00	NQ	Futures	3159.26	3160.43	3158.68	3160.14	255.0
2013-02-05 01:00:00	NQ	Futures	3160.14	3160.43	3157.52	3157.81	355.0
2013-02-05 02:00:00	NQ	Futures	3157.52	3160.14	3156.35	3156.94	1296.0
2013-02-05 03:00:00	NQ	Futures	3156.64	3165.38	3156.64	3164.21	3383.0
2013-02-05 04:00:00	NQ	Futures	3164.5	3165.67	3162.76	3163.63	2222.0
2013-02-05 05:00:00	NQ	Futures	3163.63	3166.25	3162.17	3165.96	2189.0
2013-02-05 06:00:00	NQ	Futures	3165.96	3171.2	3165.67	3169.74	3621.0
2013-02-05 07:00:00	NQ	Futures	3169.74	3173.53	3169.16	3171.2	3762.0
2013-02-05 08:00:00	NQ	Futures	3171.2	3171.78	3168.0	3171.49	4955.0
2013-02-05 09:00:00	NQ	Futures	3171.49	3181.09	3161.88	3177.89	41300.0
2013-02-05 10:00:00	NQ	Futures	3178.18	3189.24	3174.69	3187.79	44092.0
2013-02-05 11:00:00	NQ	Futures	3188.08	3192.15	3186.62	3190.12	24313.0
2013-02-05 12:00:00	NQ	Futures	3190.41	3195.36	3188.95	3193.61	16619.0
2013-02-05 13:00:00	NQ	Futures	3193.61	3202.92	3193.03	3200.3	21726.0
2013-02-05 14:00:00	NQ	Futures	3200.3	3212.53	3200.01	3208.75	30482.0
2013-02-05 15:00:00	NQ	Futures	3208.45	3210.49	3199.14	3202.92	31143.0
2013-02-05 16:00:00	NQ	Futures	3202.63	3206.42	3200.89	3206.42	7551.0
2013-02-05 17:00:00	NQ	Futures	3206.13	3207.29	3205.83	3205.83	194.0
2013-02-05 18:00:00	NQ	Futures	3205.83	3206.13	3202.34	3204.09	453.0
2013-02-05 19:00:00	NQ	Futures	3204.09	3205.25	3203.51	3204.67	560.0
2013-02-05 20:00:00	NQ	Futures	3204.38	3207.58	3203.8	3206.71	551.0
2013-02-05 21:00:00	NQ	Futures	3206.71	3207.0	3205.83	3206.71	275.0
2013-02-05 22:00:00	NQ	Futures	3206.71	3206.71	3204.67	3205.54	305.0
2013-02-05 23:00:00	NQ	Futures	3204.96	3206.71	3204.09	3205.25	370.0
2013-02-05 00:00:00	YM	Futures	13943.5	13949.5	13941.5	13944.5	424.0
2013-02-05 01:00:00	YM	Futures	13944.5	13945.5	13932.4	13935.5	479.0

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

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