PREVIEW / futures_1hour / 2011-05-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-01.parquet
  size:    15 KB
  rows:    279

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-05-01 18:00:00	ES	Futures	1354.69	1356.93	1353.2	1354.19	14516.0
2011-05-01 19:00:00	ES	Futures	1354.19	1355.19	1352.46	1354.19	6290.0
2011-05-01 20:00:00	ES	Futures	1353.95	1356.43	1353.7	1355.19	9560.0
2011-05-01 21:00:00	ES	Futures	1355.19	1355.93	1353.95	1354.44	4875.0
2011-05-01 22:00:00	ES	Futures	1354.44	1364.88	1351.46	1363.88	60322.0
2011-05-01 23:00:00	ES	Futures	1363.88	1363.88	1360.65	1362.64	21000.0
2011-05-01 18:00:00	NQ	Futures	2767.42	2771.15	2764.26	2765.98	911.0
2011-05-01 19:00:00	NQ	Futures	2765.98	2767.7	2762.53	2766.27	619.0
2011-05-01 20:00:00	NQ	Futures	2766.27	2771.73	2765.12	2770.29	788.0
2011-05-01 21:00:00	NQ	Futures	2770.29	2771.44	2766.84	2767.99	345.0
2011-05-01 22:00:00	NQ	Futures	2768.28	2790.4	2762.24	2789.25	4212.0
2011-05-01 23:00:00	NQ	Futures	2789.54	2789.54	2781.21	2786.09	945.0
2011-05-01 18:00:00	YM	Futures	12316.3	12334.6	12310.5	12317.2	558.0
2011-05-01 19:00:00	YM	Futures	12318.2	12325.0	12304.7	12317.2	359.0
2011-05-01 20:00:00	YM	Futures	12317.2	12336.5	12315.3	12328.8	371.0
2011-05-01 21:00:00	YM	Futures	12327.8	12331.7	12316.3	12318.2	219.0
2011-05-01 22:00:00	YM	Futures	12319.2	12399.1	12298.0	12395.3	3291.0
2011-05-01 23:00:00	YM	Futures	12394.3	12398.2	12372.1	12382.7	1324.0
2011-05-01 18:00:00	CL	Futures	197.36	197.8	196.18	196.34	3087.0
2011-05-01 19:00:00	CL	Futures	196.31	196.74	195.82	196.58	2135.0
2011-05-01 20:00:00	CL	Futures	196.58	197.09	196.24	196.39	1368.0
2011-05-01 21:00:00	CL	Futures	196.38	196.67	195.77	196.31	2036.0
2011-05-01 22:00:00	CL	Futures	196.34	196.69	194.45	195.09	6120.0
2011-05-01 23:00:00	CL	Futures	195.04	195.65	194.57	195.47	3626.0
2011-05-01 18:00:00	GC	Futures	2186.9	2201.7	2171.5	2172.5	11202.0
2011-05-01 19:00:00	GC	Futures	2172.4	2173.5	2154.3	2168.4	8145.0
2011-05-01 20:00:00	GC	Futures	2168.3	2171.8	2156.0	2157.8	6873.0
2011-05-01 21:00:00	GC	Futures	2157.7	2163.1	2156.0	2161.6	3677.0
2011-05-01 22:00:00	GC	Futures	2161.6	2163.3	2149.9	2154.1	7794.0
2011-05-01 23:00:00	GC	Futures	2153.9	2167.6	2152.3	2163.3	5149.0
2011-05-01 18:00:00	ZN	Futures	103.126799	103.140103	103.020373	103.060283	3373.0
2011-05-01 19:00:00	ZN	Futures	103.060283	103.113496	103.033677	103.08689	4141.0
2011-05-01 20:00:00	ZN	Futures	103.100193	103.113496	103.060283	103.08689	2601.0
2011-05-01 21:00:00	ZN	Futures	103.08689	103.126799	103.08689	103.126799	1668.0
2011-05-01 22:00:00	ZN	Futures	103.126799	103.273135	102.980464	102.993767	21920.0
2011-05-01 23:00:00	ZN	Futures	102.993767	103.113496	102.980464	103.033677	10523.0

> showing 36 of 279 rows — these rows as CSV

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