PREVIEW / futures_1hour / 2012-04-10

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-10.parquet
  size:    50 KB
  rows:    1,483

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-04-10 00:00:00	ES	Futures	1394.96	1395.21	1392.93	1393.69	2411.0
2012-04-10 01:00:00	ES	Futures	1393.69	1394.7	1393.44	1394.2	4211.0
2012-04-10 02:00:00	ES	Futures	1394.2	1396.22	1393.18	1393.18	11776.0
2012-04-10 03:00:00	ES	Futures	1393.44	1396.22	1390.15	1393.44	38787.0
2012-04-10 04:00:00	ES	Futures	1393.18	1396.47	1391.67	1395.21	32440.0
2012-04-10 05:00:00	ES	Futures	1394.96	1397.23	1393.94	1395.71	22645.0
2012-04-10 06:00:00	ES	Futures	1395.71	1395.71	1392.93	1393.18	23166.0
2012-04-10 07:00:00	ES	Futures	1393.18	1393.69	1390.91	1393.44	34715.0
2012-04-10 08:00:00	ES	Futures	1393.44	1393.94	1391.41	1391.92	46879.0
2012-04-10 09:00:00	ES	Futures	1391.92	1394.96	1389.64	1392.93	229008.0
2012-04-10 10:00:00	ES	Futures	1392.68	1393.69	1385.85	1386.61	351457.0
2012-04-10 11:00:00	ES	Futures	1386.35	1387.87	1376.99	1379.27	458568.0
2012-04-10 12:00:00	ES	Futures	1379.27	1379.27	1372.95	1375.22	323955.0
2012-04-10 13:00:00	ES	Futures	1375.22	1375.98	1370.42	1373.96	201787.0
2012-04-10 14:00:00	ES	Futures	1373.71	1374.72	1368.65	1371.68	203407.0
2012-04-10 15:00:00	ES	Futures	1371.68	1374.21	1369.15	1369.66	343762.0
2012-04-10 16:00:00	ES	Futures	1369.66	1375.73	1369.4	1375.48	155350.0
2012-04-10 17:00:00	ES	Futures	1375.48	1376.74	1374.97	1376.23	4803.0
2012-04-10 18:00:00	ES	Futures	1376.23	1376.23	1374.72	1375.48	3918.0
2012-04-10 19:00:00	ES	Futures	1375.22	1376.99	1374.97	1376.49	5585.0
2012-04-10 20:00:00	ES	Futures	1376.23	1378.01	1375.98	1376.99	8727.0
2012-04-10 21:00:00	ES	Futures	1376.99	1378.01	1376.49	1376.74	6946.0
2012-04-10 22:00:00	ES	Futures	1376.49	1378.51	1376.49	1378.01	5821.0
2012-04-10 23:00:00	ES	Futures	1378.01	1378.51	1377.25	1378.01	3741.0
2012-04-10 00:00:00	NQ	Futures	3165.3	3165.59	3161.25	3162.41	172.0
2012-04-10 01:00:00	NQ	Futures	3162.99	3164.14	3159.52	3162.12	1037.0
2012-04-10 02:00:00	NQ	Futures	3162.41	3166.46	3160.96	3161.25	1151.0
2012-04-10 03:00:00	NQ	Futures	3161.54	3167.04	3156.62	3163.85	4676.0
2012-04-10 04:00:00	NQ	Futures	3163.56	3170.79	3159.81	3166.46	3519.0
2012-04-10 05:00:00	NQ	Futures	3166.46	3170.22	3162.7	3168.77	2401.0
2012-04-10 06:00:00	NQ	Futures	3168.48	3168.48	3162.7	3165.01	2830.0
2012-04-10 07:00:00	NQ	Futures	3164.72	3167.32	3161.54	3167.04	2954.0
2012-04-10 08:00:00	NQ	Futures	3167.04	3168.77	3163.56	3164.72	6144.0
2012-04-10 09:00:00	NQ	Futures	3164.72	3176.0	3160.09	3173.11	45091.0
2012-04-10 10:00:00	NQ	Futures	3173.4	3176.58	3156.05	3160.38	39864.0
2012-04-10 11:00:00	NQ	Futures	3160.09	3164.43	3130.89	3137.25	68181.0
2012-04-10 12:00:00	NQ	Futures	3136.96	3138.12	3114.98	3125.39	62759.0
2012-04-10 13:00:00	NQ	Futures	3125.39	3126.84	3112.67	3120.47	29470.0
2012-04-10 14:00:00	NQ	Futures	3120.18	3125.1	3105.15	3117.58	39512.0
2012-04-10 15:00:00	NQ	Futures	3117.29	3121.05	3106.3	3114.69	58838.0
2012-04-10 16:00:00	NQ	Futures	3114.69	3125.39	3114.4	3125.39	12266.0
2012-04-10 17:00:00	NQ	Futures	3124.81	3126.55	3123.94	3125.68	359.0
2012-04-10 18:00:00	NQ	Futures	3125.1	3125.97	3122.79	3123.94	264.0
2012-04-10 19:00:00	NQ	Futures	3123.94	3127.41	3123.66	3126.26	360.0
2012-04-10 20:00:00	NQ	Futures	3126.26	3128.28	3125.39	3127.7	728.0
2012-04-10 21:00:00	NQ	Futures	3127.41	3128.57	3125.68	3125.97	529.0
2012-04-10 22:00:00	NQ	Futures	3126.26	3130.02	3125.97	3129.15	651.0
2012-04-10 23:00:00	NQ	Futures	3128.86	3129.73	3127.41	3129.15	308.0
2012-04-10 00:00:00	YM	Futures	12833.3	12833.3	12818.4	12823.4	170.0
2012-04-10 01:00:00	YM	Futures	12824.4	12830.3	12818.4	12826.4	289.0

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

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