PREVIEW / futures_1hour / 2011-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-14.parquet
  size:    40 KB
  rows:    1,151

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
2011-01-14 00:00:00	ES	Futures	1268.56	1269.3	1268.06	1269.05	2612.0
2011-01-14 01:00:00	ES	Futures	1269.05	1269.3	1267.07	1268.06	3970.0
2011-01-14 02:00:00	ES	Futures	1268.31	1268.81	1267.57	1267.82	5985.0
2011-01-14 03:00:00	ES	Futures	1267.82	1270.04	1267.57	1268.06	25192.0
2011-01-14 04:00:00	ES	Futures	1268.31	1268.81	1265.84	1266.33	19294.0
2011-01-14 05:00:00	ES	Futures	1266.08	1267.32	1264.85	1266.08	22049.0
2011-01-14 06:00:00	ES	Futures	1266.08	1267.07	1265.09	1266.33	17051.0
2011-01-14 07:00:00	ES	Futures	1266.58	1266.58	1261.88	1263.86	59268.0
2011-01-14 08:00:00	ES	Futures	1263.86	1264.85	1261.14	1263.86	68458.0
2011-01-14 09:00:00	ES	Futures	1263.86	1267.82	1263.61	1267.57	216693.0
2011-01-14 10:00:00	ES	Futures	1267.32	1270.54	1265.59	1269.3	264104.0
2011-01-14 11:00:00	ES	Futures	1269.3	1271.53	1269.05	1270.04	191202.0
2011-01-14 12:00:00	ES	Futures	1270.29	1273.01	1270.04	1271.53	151962.0
2011-01-14 13:00:00	ES	Futures	1271.53	1275.24	1271.28	1274.25	102014.0
2011-01-14 14:00:00	ES	Futures	1274.25	1275.49	1273.75	1274.5	99764.0
2011-01-14 15:00:00	ES	Futures	1274.25	1276.23	1273.75	1275.73	239421.0
2011-01-14 16:00:00	ES	Futures	1275.73	1276.72	1274.99	1276.72	100604.0
2011-01-14 00:00:00	NQ	Futures	2649.88	2651.32	2647.59	2649.31	201.0
2011-01-14 01:00:00	NQ	Futures	2649.02	2649.02	2646.73	2647.59	317.0
2011-01-14 02:00:00	NQ	Futures	2647.3	2648.74	2646.44	2647.59	363.0
2011-01-14 03:00:00	NQ	Futures	2647.59	2651.32	2646.73	2647.3	2453.0
2011-01-14 04:00:00	NQ	Futures	2647.3	2648.74	2643.28	2644.43	1457.0
2011-01-14 05:00:00	NQ	Futures	2644.72	2646.73	2642.13	2645.87	1396.0
2011-01-14 06:00:00	NQ	Futures	2645.58	2648.74	2644.72	2647.59	1473.0
2011-01-14 07:00:00	NQ	Futures	2647.59	2647.59	2639.26	2641.27	4248.0
2011-01-14 08:00:00	NQ	Futures	2641.56	2645.58	2637.83	2642.99	6250.0
2011-01-14 09:00:00	NQ	Futures	2642.99	2647.01	2638.4	2643.86	27628.0
2011-01-14 10:00:00	NQ	Futures	2643.86	2653.33	2643.28	2651.32	30784.0
2011-01-14 11:00:00	NQ	Futures	2651.61	2657.63	2651.03	2653.04	22080.0
2011-01-14 12:00:00	NQ	Futures	2653.33	2657.92	2652.75	2656.2	12139.0
2011-01-14 13:00:00	NQ	Futures	2656.49	2661.08	2655.05	2660.22	13579.0
2011-01-14 14:00:00	NQ	Futures	2660.22	2661.94	2658.78	2660.5	11457.0
2011-01-14 15:00:00	NQ	Futures	2660.5	2665.38	2659.93	2664.81	27297.0
2011-01-14 16:00:00	NQ	Futures	2664.81	2667.11	2663.95	2665.67	9149.0
2011-01-14 00:00:00	YM	Futures	11193.6	11199.3	11189.8	11199.3	94.0
2011-01-14 01:00:00	YM	Futures	11196.5	11203.2	11182.1	11192.6	185.0
2011-01-14 02:00:00	YM	Futures	11191.7	11194.6	11186.9	11189.8	356.0
2011-01-14 03:00:00	YM	Futures	11190.7	11207.0	11185.0	11190.7	1440.0
2011-01-14 04:00:00	YM	Futures	11190.7	11195.5	11171.6	11172.5	1038.0
2011-01-14 05:00:00	YM	Futures	11174.4	11180.2	11162.0	11173.5	902.0
2011-01-14 06:00:00	YM	Futures	11173.5	11181.2	11165.8	11178.3	639.0
2011-01-14 07:00:00	YM	Futures	11178.3	11179.2	11138.1	11155.3	2493.0
2011-01-14 08:00:00	YM	Futures	11156.2	11161.0	11136.1	11153.4	2932.0
2011-01-14 09:00:00	YM	Futures	11153.4	11182.1	11151.5	11178.3	14750.0
2011-01-14 10:00:00	YM	Futures	11178.3	11208.0	11167.7	11199.3	16554.0
2011-01-14 11:00:00	YM	Futures	11199.3	11213.7	11197.4	11202.2	9324.0
2011-01-14 12:00:00	YM	Futures	11203.2	11223.3	11202.2	11212.8	7649.0
2011-01-14 13:00:00	YM	Futures	11212.8	11236.7	11210.8	11231.9	5242.0
2011-01-14 14:00:00	YM	Futures	11231.0	11244.4	11228.1	11231.9	7644.0
2011-01-14 15:00:00	YM	Futures	11231.9	11241.5	11222.3	11236.7	13326.0

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

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