PREVIEW / futures_1hour / 2012-04-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-13.parquet
  size:    40 KB
  rows:    1,190

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-13 00:00:00	ES	Futures	1398.5	1399.26	1397.49	1397.99	5801.0
2012-04-13 01:00:00	ES	Futures	1397.99	1400.27	1397.99	1399.76	3750.0
2012-04-13 02:00:00	ES	Futures	1399.76	1399.76	1397.23	1399.26	11250.0
2012-04-13 03:00:00	ES	Futures	1399.51	1401.03	1397.23	1398.5	41610.0
2012-04-13 04:00:00	ES	Futures	1398.24	1398.5	1394.7	1395.71	47793.0
2012-04-13 05:00:00	ES	Futures	1395.71	1396.98	1393.44	1396.22	28999.0
2012-04-13 06:00:00	ES	Futures	1396.47	1401.03	1395.46	1400.27	31236.0
2012-04-13 07:00:00	ES	Futures	1400.27	1401.79	1395.71	1395.97	58312.0
2012-04-13 08:00:00	ES	Futures	1395.97	1397.49	1393.69	1396.98	79540.0
2012-04-13 09:00:00	ES	Futures	1396.98	1397.23	1390.15	1390.66	275124.0
2012-04-13 10:00:00	ES	Futures	1390.66	1392.43	1384.58	1387.11	403904.0
2012-04-13 11:00:00	ES	Futures	1386.86	1390.66	1385.34	1388.88	210146.0
2012-04-13 12:00:00	ES	Futures	1388.88	1389.9	1386.86	1389.14	94717.0
2012-04-13 13:00:00	ES	Futures	1389.14	1390.91	1387.87	1388.13	77974.0
2012-04-13 14:00:00	ES	Futures	1387.87	1389.64	1386.86	1388.13	96351.0
2012-04-13 15:00:00	ES	Futures	1388.13	1390.4	1381.04	1382.31	291079.0
2012-04-13 16:00:00	ES	Futures	1382.31	1383.82	1380.03	1381.29	104965.0
2012-04-13 00:00:00	NQ	Futures	3160.96	3162.41	3159.52	3160.38	418.0
2012-04-13 01:00:00	NQ	Futures	3160.38	3164.14	3160.38	3162.99	257.0
2012-04-13 02:00:00	NQ	Futures	3162.99	3162.99	3158.36	3161.25	706.0
2012-04-13 03:00:00	NQ	Futures	3160.96	3165.88	3157.2	3160.09	4051.0
2012-04-13 04:00:00	NQ	Futures	3160.09	3160.09	3152.86	3154.6	3067.0
2012-04-13 05:00:00	NQ	Futures	3154.89	3158.36	3152.29	3157.49	2659.0
2012-04-13 06:00:00	NQ	Futures	3157.49	3166.17	3156.05	3164.72	2753.0
2012-04-13 07:00:00	NQ	Futures	3165.01	3165.88	3154.89	3155.18	4021.0
2012-04-13 08:00:00	NQ	Futures	3155.47	3159.23	3152.29	3157.49	6220.0
2012-04-13 09:00:00	NQ	Futures	3157.49	3157.78	3140.72	3143.61	52451.0
2012-04-13 10:00:00	NQ	Futures	3143.61	3148.24	3116.43	3126.84	79319.0
2012-04-13 11:00:00	NQ	Futures	3126.84	3136.96	3119.32	3130.31	41612.0
2012-04-13 12:00:00	NQ	Futures	3130.31	3131.75	3125.97	3130.31	16725.0
2012-04-13 13:00:00	NQ	Futures	3130.6	3136.67	3127.7	3128.57	13728.0
2012-04-13 14:00:00	NQ	Futures	3128.57	3132.91	3125.68	3127.99	14597.0
2012-04-13 15:00:00	NQ	Futures	3127.7	3134.93	3115.85	3117.0	34181.0
2012-04-13 16:00:00	NQ	Futures	3117.29	3121.05	3112.95	3113.82	10098.0
2012-04-13 00:00:00	YM	Futures	12872.2	12878.2	12866.2	12868.2	302.0
2012-04-13 01:00:00	YM	Futures	12868.2	12885.1	12868.2	12882.2	224.0
2012-04-13 02:00:00	YM	Futures	12880.2	12880.2	12861.2	12877.2	464.0
2012-04-13 03:00:00	YM	Futures	12877.2	12889.1	12853.3	12864.2	4133.0
2012-04-13 04:00:00	YM	Futures	12862.2	12864.2	12840.3	12847.3	4066.0
2012-04-13 05:00:00	YM	Futures	12846.3	12856.2	12832.3	12851.3	2953.0
2012-04-13 06:00:00	YM	Futures	12850.3	12880.2	12843.3	12875.2	2583.0
2012-04-13 07:00:00	YM	Futures	12876.2	12886.1	12845.3	12845.3	3416.0
2012-04-13 08:00:00	YM	Futures	12845.3	12852.3	12824.4	12848.3	4806.0
2012-04-13 09:00:00	YM	Futures	12848.3	12849.3	12788.5	12790.5	19123.0
2012-04-13 10:00:00	YM	Futures	12791.5	12808.4	12765.6	12781.5	28185.0
2012-04-13 11:00:00	YM	Futures	12781.5	12811.4	12765.6	12800.5	16252.0
2012-04-13 12:00:00	YM	Futures	12799.5	12810.4	12784.5	12806.4	6876.0
2012-04-13 13:00:00	YM	Futures	12806.4	12824.4	12799.5	12803.4	6081.0
2012-04-13 14:00:00	YM	Futures	12803.4	12810.4	12788.5	12804.4	7590.0
2012-04-13 15:00:00	YM	Futures	12803.4	12816.4	12734.7	12746.7	17218.0

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

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