PREVIEW / futures_1hour / 2012-10-11

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-11.parquet
  size:    48 KB
  rows:    1,470

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-10-11 00:00:00	ES	Futures	1458.44	1458.7	1456.4	1457.16	5668.0
2012-10-11 01:00:00	ES	Futures	1457.16	1457.93	1455.89	1456.91	5036.0
2012-10-11 02:00:00	ES	Futures	1456.91	1458.44	1456.65	1457.16	7202.0
2012-10-11 03:00:00	ES	Futures	1457.16	1460.49	1456.65	1459.98	27296.0
2012-10-11 04:00:00	ES	Futures	1459.98	1463.04	1459.46	1461.76	30201.0
2012-10-11 05:00:00	ES	Futures	1461.76	1463.55	1461.25	1462.53	16622.0
2012-10-11 06:00:00	ES	Futures	1462.53	1463.81	1461.76	1463.3	24806.0
2012-10-11 07:00:00	ES	Futures	1463.3	1463.81	1461.25	1461.76	20313.0
2012-10-11 08:00:00	ES	Futures	1461.51	1466.62	1461.51	1464.83	69256.0
2012-10-11 09:00:00	ES	Futures	1464.83	1468.92	1464.57	1466.36	182254.0
2012-10-11 10:00:00	ES	Futures	1466.36	1470.7	1465.34	1469.43	225389.0
2012-10-11 11:00:00	ES	Futures	1469.68	1470.7	1463.3	1464.57	269180.0
2012-10-11 12:00:00	ES	Futures	1464.57	1466.36	1463.3	1464.83	106805.0
2012-10-11 13:00:00	ES	Futures	1465.08	1466.36	1459.72	1460.49	133433.0
2012-10-11 14:00:00	ES	Futures	1460.49	1463.3	1459.72	1460.74	105585.0
2012-10-11 15:00:00	ES	Futures	1460.74	1463.3	1459.21	1459.46	201172.0
2012-10-11 16:00:00	ES	Futures	1459.46	1461.25	1458.44	1461.0	79463.0
2012-10-11 17:00:00	ES	Futures	1461.0	1462.27	1461.0	1462.02	2224.0
2012-10-11 18:00:00	ES	Futures	1462.02	1462.27	1461.0	1461.51	3579.0
2012-10-11 19:00:00	ES	Futures	1461.51	1462.27	1460.74	1462.27	3710.0
2012-10-11 20:00:00	ES	Futures	1462.27	1463.3	1461.76	1462.02	4426.0
2012-10-11 21:00:00	ES	Futures	1462.02	1464.32	1461.0	1463.04	7925.0
2012-10-11 22:00:00	ES	Futures	1463.04	1464.06	1462.02	1462.27	3102.0
2012-10-11 23:00:00	ES	Futures	1462.27	1462.27	1461.0	1461.76	3282.0
2012-10-11 00:00:00	NQ	Futures	3170.19	3170.48	3166.12	3167.28	610.0
2012-10-11 01:00:00	NQ	Futures	3167.28	3168.74	3164.67	3166.41	549.0
2012-10-11 02:00:00	NQ	Futures	3166.41	3170.19	3165.25	3166.7	1078.0
2012-10-11 03:00:00	NQ	Futures	3166.7	3175.71	3166.12	3174.55	3128.0
2012-10-11 04:00:00	NQ	Futures	3174.26	3180.65	3172.51	3176.87	3097.0
2012-10-11 05:00:00	NQ	Futures	3176.58	3180.07	3175.71	3177.74	1766.0
2012-10-11 06:00:00	NQ	Futures	3177.74	3181.81	3176.87	3180.07	1767.0
2012-10-11 07:00:00	NQ	Futures	3180.07	3181.23	3175.71	3176.0	1775.0
2012-10-11 08:00:00	NQ	Futures	3176.29	3186.17	3176.0	3184.43	7115.0
2012-10-11 09:00:00	NQ	Futures	3184.14	3191.11	3179.49	3183.85	36668.0
2012-10-11 10:00:00	NQ	Futures	3183.85	3190.24	3181.81	3184.43	33892.0
2012-10-11 11:00:00	NQ	Futures	3184.43	3185.01	3161.76	3166.7	44348.0
2012-10-11 12:00:00	NQ	Futures	3166.41	3173.09	3162.34	3166.41	21352.0
2012-10-11 13:00:00	NQ	Futures	3166.12	3169.32	3152.17	3153.92	25858.0
2012-10-11 14:00:00	NQ	Futures	3153.92	3162.05	3153.63	3157.98	20014.0
2012-10-11 15:00:00	NQ	Futures	3158.27	3166.41	3153.63	3154.21	30568.0
2012-10-11 16:00:00	NQ	Futures	3154.21	3157.11	3152.75	3156.53	6555.0
2012-10-11 17:00:00	NQ	Futures	3156.82	3157.98	3156.24	3157.4	147.0
2012-10-11 18:00:00	NQ	Futures	3157.4	3158.27	3156.53	3156.82	290.0
2012-10-11 19:00:00	NQ	Futures	3157.69	3157.98	3155.66	3157.98	266.0
2012-10-11 20:00:00	NQ	Futures	3158.27	3160.02	3156.53	3157.11	653.0
2012-10-11 21:00:00	NQ	Futures	3156.82	3162.34	3155.37	3160.02	832.0
2012-10-11 22:00:00	NQ	Futures	3160.02	3163.21	3157.4	3157.4	1139.0
2012-10-11 23:00:00	NQ	Futures	3157.4	3157.69	3154.5	3155.95	672.0
2012-10-11 00:00:00	YM	Futures	13281.8	13282.8	13267.8	13271.8	486.0
2012-10-11 01:00:00	YM	Futures	13271.8	13277.8	13262.8	13269.8	471.0

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

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