PREVIEW / futures_1hour / 2013-02-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-04.parquet
  size:    50 KB
  rows:    1,517

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-04 00:00:00	ES	Futures	1545.96	1546.47	1545.7	1545.96	2654.0
2013-02-04 01:00:00	ES	Futures	1545.96	1546.47	1545.7	1546.22	882.0
2013-02-04 02:00:00	ES	Futures	1546.22	1546.99	1545.7	1546.22	5535.0
2013-02-04 03:00:00	ES	Futures	1545.96	1546.99	1545.19	1545.96	21149.0
2013-02-04 04:00:00	ES	Futures	1545.96	1547.76	1545.96	1546.22	14356.0
2013-02-04 05:00:00	ES	Futures	1546.22	1546.47	1542.88	1543.91	28868.0
2013-02-04 06:00:00	ES	Futures	1543.91	1544.42	1543.14	1543.14	18506.0
2013-02-04 07:00:00	ES	Futures	1543.14	1543.65	1541.09	1542.88	36944.0
2013-02-04 08:00:00	ES	Futures	1542.88	1543.14	1537.24	1539.03	114468.0
2013-02-04 09:00:00	ES	Futures	1539.29	1541.09	1537.24	1540.57	221914.0
2013-02-04 10:00:00	ES	Futures	1540.32	1541.34	1536.21	1536.47	267980.0
2013-02-04 11:00:00	ES	Futures	1536.47	1537.49	1532.62	1533.39	262618.0
2013-02-04 12:00:00	ES	Futures	1533.39	1535.18	1531.34	1533.9	140800.0
2013-02-04 13:00:00	ES	Futures	1533.9	1534.93	1531.85	1532.88	99269.0
2013-02-04 14:00:00	ES	Futures	1532.88	1536.21	1531.85	1535.7	114458.0
2013-02-04 15:00:00	ES	Futures	1535.95	1535.95	1529.54	1530.82	259332.0
2013-02-04 16:00:00	ES	Futures	1531.08	1533.64	1530.57	1532.62	97089.0
2013-02-04 17:00:00	ES	Futures	1532.62	1532.88	1531.59	1531.85	2698.0
2013-02-04 18:00:00	ES	Futures	1531.85	1533.39	1531.59	1533.13	4200.0
2013-02-04 19:00:00	ES	Futures	1533.13	1534.93	1533.13	1534.41	7509.0
2013-02-04 20:00:00	ES	Futures	1534.41	1535.44	1534.16	1535.18	7256.0
2013-02-04 21:00:00	ES	Futures	1534.93	1534.93	1533.13	1533.64	4197.0
2013-02-04 22:00:00	ES	Futures	1533.64	1534.93	1533.39	1533.9	4910.0
2013-02-04 23:00:00	ES	Futures	1534.16	1535.18	1533.9	1534.93	4158.0
2013-02-04 00:00:00	NQ	Futures	3205.25	3206.71	3205.25	3206.42	140.0
2013-02-04 01:00:00	NQ	Futures	3206.13	3206.71	3205.83	3206.42	101.0
2013-02-04 02:00:00	NQ	Futures	3206.42	3209.33	3206.13	3208.45	387.0
2013-02-04 03:00:00	NQ	Futures	3208.16	3209.33	3206.42	3208.16	1463.0
2013-02-04 04:00:00	NQ	Futures	3208.16	3211.66	3208.16	3209.91	2096.0
2013-02-04 05:00:00	NQ	Futures	3209.91	3211.37	3205.83	3206.13	2834.0
2013-02-04 06:00:00	NQ	Futures	3206.42	3208.16	3205.54	3205.83	2439.0
2013-02-04 07:00:00	NQ	Futures	3206.13	3206.42	3199.43	3203.22	4001.0
2013-02-04 08:00:00	NQ	Futures	3203.22	3203.8	3187.21	3192.74	12349.0
2013-02-04 09:00:00	NQ	Futures	3192.45	3202.34	3189.53	3199.14	35283.0
2013-02-04 10:00:00	NQ	Futures	3198.85	3200.89	3189.24	3189.24	31643.0
2013-02-04 11:00:00	NQ	Futures	3189.53	3190.99	3163.34	3167.12	66823.0
2013-02-04 12:00:00	NQ	Futures	3167.12	3170.62	3160.14	3165.38	27354.0
2013-02-04 13:00:00	NQ	Futures	3165.38	3169.16	3158.1	3161.59	21563.0
2013-02-04 14:00:00	NQ	Futures	3161.88	3169.16	3159.55	3167.41	19252.0
2013-02-04 15:00:00	NQ	Futures	3167.7	3167.7	3154.32	3155.19	35841.0
2013-02-04 16:00:00	NQ	Futures	3154.9	3159.26	3154.02	3156.06	9154.0
2013-02-04 17:00:00	NQ	Futures	3156.06	3156.35	3154.9	3154.9	204.0
2013-02-04 18:00:00	NQ	Futures	3155.19	3156.94	3154.32	3156.35	610.0
2013-02-04 19:00:00	NQ	Futures	3156.64	3160.43	3156.64	3159.26	702.0
2013-02-04 20:00:00	NQ	Futures	3159.26	3161.01	3158.97	3159.55	691.0
2013-02-04 21:00:00	NQ	Futures	3159.55	3159.55	3156.35	3156.94	534.0
2013-02-04 22:00:00	NQ	Futures	3156.94	3159.85	3156.06	3158.1	704.0
2013-02-04 23:00:00	NQ	Futures	3158.39	3160.14	3157.81	3158.97	327.0
2013-02-04 00:00:00	YM	Futures	14015.9	14021.0	14014.9	14018.0	299.0
2013-02-04 01:00:00	YM	Futures	14016.9	14021.0	14016.9	14016.9	130.0

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

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