PREVIEW / futures_1hour / 2013-02-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-02-25.parquet
  size:    53 KB
  rows:    1,544

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-25 00:00:00	ES	Futures	1553.4	1555.2	1553.4	1554.94	5970.0
2013-02-25 01:00:00	ES	Futures	1554.94	1555.71	1554.94	1555.2	3826.0
2013-02-25 02:00:00	ES	Futures	1555.46	1555.71	1553.92	1554.43	8044.0
2013-02-25 03:00:00	ES	Futures	1554.43	1557.76	1554.43	1556.22	37678.0
2013-02-25 04:00:00	ES	Futures	1556.22	1557.25	1555.71	1556.48	20145.0
2013-02-25 05:00:00	ES	Futures	1556.74	1561.1	1556.48	1560.33	35645.0
2013-02-25 06:00:00	ES	Futures	1560.33	1562.38	1559.82	1560.84	36182.0
2013-02-25 07:00:00	ES	Futures	1561.1	1563.67	1560.84	1562.38	49191.0
2013-02-25 08:00:00	ES	Futures	1562.64	1562.9	1560.59	1561.36	48780.0
2013-02-25 09:00:00	ES	Futures	1561.36	1563.67	1559.56	1561.87	263934.0
2013-02-25 10:00:00	ES	Futures	1562.13	1564.69	1551.86	1554.17	566591.0
2013-02-25 11:00:00	ES	Futures	1553.92	1556.99	1545.7	1547.24	453831.0
2013-02-25 12:00:00	ES	Futures	1547.24	1552.12	1545.96	1551.61	220020.0
2013-02-25 13:00:00	ES	Futures	1551.35	1552.38	1541.34	1542.63	247918.0
2013-02-25 14:00:00	ES	Futures	1542.37	1544.68	1539.03	1542.88	265901.0
2013-02-25 15:00:00	ES	Futures	1542.88	1544.17	1524.66	1524.92	534337.0
2013-02-25 16:00:00	ES	Futures	1524.66	1527.23	1520.82	1522.35	220377.0
2013-02-25 17:00:00	ES	Futures	1522.87	1524.15	1521.84	1523.89	7103.0
2013-02-25 18:00:00	ES	Futures	1524.66	1528.0	1524.15	1526.97	19676.0
2013-02-25 19:00:00	ES	Futures	1526.97	1529.54	1526.97	1529.54	17780.0
2013-02-25 20:00:00	ES	Futures	1529.54	1530.57	1528.77	1529.8	13643.0
2013-02-25 21:00:00	ES	Futures	1529.8	1530.82	1528.77	1529.03	9228.0
2013-02-25 22:00:00	ES	Futures	1529.28	1529.54	1526.46	1527.49	9830.0
2013-02-25 23:00:00	ES	Futures	1527.23	1527.74	1524.41	1527.49	14273.0
2013-02-25 00:00:00	NQ	Futures	3182.55	3186.33	3182.26	3186.04	397.0
2013-02-25 01:00:00	NQ	Futures	3186.04	3187.21	3185.75	3186.92	256.0
2013-02-25 02:00:00	NQ	Futures	3186.62	3187.21	3184.0	3184.88	653.0
2013-02-25 03:00:00	NQ	Futures	3184.88	3193.9	3184.59	3191.28	3774.0
2013-02-25 04:00:00	NQ	Futures	3191.28	3194.19	3190.41	3193.32	1194.0
2013-02-25 05:00:00	NQ	Futures	3193.32	3204.09	3193.32	3203.51	2973.0
2013-02-25 06:00:00	NQ	Futures	3203.51	3207.58	3202.92	3204.38	2801.0
2013-02-25 07:00:00	NQ	Futures	3204.38	3212.24	3204.09	3209.62	5013.0
2013-02-25 08:00:00	NQ	Futures	3209.91	3210.49	3204.96	3205.54	5217.0
2013-02-25 09:00:00	NQ	Futures	3205.54	3215.44	3205.25	3213.69	37820.0
2013-02-25 10:00:00	NQ	Futures	3213.69	3218.64	3193.9	3197.68	57705.0
2013-02-25 11:00:00	NQ	Futures	3197.68	3203.51	3179.93	3183.71	46137.0
2013-02-25 12:00:00	NQ	Futures	3183.42	3196.81	3180.8	3194.77	53751.0
2013-02-25 13:00:00	NQ	Futures	3194.77	3197.1	3176.73	3179.64	56256.0
2013-02-25 14:00:00	NQ	Futures	3179.64	3181.09	3170.91	3177.89	33579.0
2013-02-25 15:00:00	NQ	Futures	3177.89	3179.35	3144.42	3145.58	55379.0
2013-02-25 16:00:00	NQ	Futures	3145.58	3149.37	3133.94	3142.96	14309.0
2013-02-25 17:00:00	NQ	Futures	3142.67	3145.29	3141.22	3145.29	813.0
2013-02-25 18:00:00	NQ	Futures	3146.17	3151.99	3146.17	3151.11	1041.0
2013-02-25 19:00:00	NQ	Futures	3150.82	3153.73	3150.82	3152.86	1071.0
2013-02-25 20:00:00	NQ	Futures	3152.86	3154.32	3150.24	3152.28	966.0
2013-02-25 21:00:00	NQ	Futures	3152.86	3154.32	3150.82	3151.4	514.0
2013-02-25 22:00:00	NQ	Futures	3151.7	3151.7	3147.04	3148.79	703.0
2013-02-25 23:00:00	NQ	Futures	3148.79	3148.79	3142.38	3148.49	1251.0
2013-02-25 00:00:00	YM	Futures	14054.2	14068.3	14052.2	14068.3	422.0
2013-02-25 01:00:00	YM	Futures	14067.2	14072.3	14066.2	14070.3	385.0

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

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