PREVIEW / futures_1hour / 2010-06-20

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-06-20.parquet
  size:    13 KB
  rows:    247

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
2010-06-20 18:00:00	ES	Futures	1095.37	1106.66	1094.88	1101.26	23262.0
2010-06-20 19:00:00	ES	Futures	1101.02	1103.72	1100.77	1103.47	10259.0
2010-06-20 20:00:00	ES	Futures	1103.72	1106.17	1103.23	1105.68	15971.0
2010-06-20 21:00:00	ES	Futures	1105.68	1106.17	1095.62	1100.28	29594.0
2010-06-20 22:00:00	ES	Futures	1100.28	1103.72	1098.07	1103.47	11431.0
2010-06-20 23:00:00	ES	Futures	1103.47	1104.94	1102.49	1102.74	6256.0
2010-06-20 18:00:00	NQ	Futures	2204.27	2215.44	2203.12	2211.72	1568.0
2010-06-20 19:00:00	NQ	Futures	2211.72	2214.87	2210.57	2214.87	857.0
2010-06-20 20:00:00	NQ	Futures	2214.87	2220.6	2214.87	2220.03	1276.0
2010-06-20 21:00:00	NQ	Futures	2220.03	2221.75	2202.55	2210.57	3028.0
2010-06-20 22:00:00	NQ	Futures	2210.57	2214.3	2205.99	2214.01	1952.0
2010-06-20 23:00:00	NQ	Futures	2214.01	2219.17	2213.44	2214.01	1172.0
2010-06-20 18:00:00	YM	Futures	9869.3	9939.4	9864.6	9912.9	712.0
2010-06-20 19:00:00	YM	Futures	9913.8	9931.8	9909.1	9930.8	413.0
2010-06-20 20:00:00	YM	Futures	9930.8	9955.5	9927.1	9943.2	1579.0
2010-06-20 21:00:00	YM	Futures	9943.2	9948.8	9870.3	9903.4	2056.0
2010-06-20 22:00:00	YM	Futures	9903.4	9929.0	9887.3	9927.1	857.0
2010-06-20 23:00:00	YM	Futures	9928.0	9940.3	9922.3	9924.2	501.0
2010-06-20 18:00:00	CL	Futures	151.91	152.86	151.76	152.55	1883.0
2010-06-20 19:00:00	CL	Futures	152.55	152.62	152.22	152.55	453.0
2010-06-20 20:00:00	CL	Futures	152.57	153.28	152.55	153.28	1318.0
2010-06-20 21:00:00	CL	Futures	153.3	153.32	152.35	152.89	2152.0
2010-06-20 22:00:00	CL	Futures	152.86	153.26	152.82	153.15	507.0
2010-06-20 23:00:00	CL	Futures	153.17	153.45	153.05	153.28	752.0
2010-06-20 19:00:00	GC	Futures	1770.8	1771.1	1769.0	1770.0	233.0
2010-06-20 20:00:00	GC	Futures	1770.0	1771.1	1768.8	1768.8	1117.0
2010-06-20 21:00:00	GC	Futures	1768.8	1768.8	1764.5	1765.5	2454.0
2010-06-20 22:00:00	GC	Futures	1765.3	1766.9	1765.2	1765.9	910.0
2010-06-20 23:00:00	GC	Futures	1765.9	1767.6	1765.7	1766.7	917.0
2010-06-20 18:00:00	ZN	Futures	99.424735	99.424735	99.204912	99.256635	14010.0
2010-06-20 19:00:00	ZN	Futures	99.256635	99.385943	99.243704	99.33422	9242.0
2010-06-20 20:00:00	ZN	Futures	99.33422	99.34715	99.269566	99.33422	8267.0
2010-06-20 21:00:00	ZN	Futures	99.33422	99.437666	99.282497	99.34715	18216.0
2010-06-20 22:00:00	ZN	Futures	99.34715	99.385943	99.295427	99.321289	6481.0
2010-06-20 23:00:00	ZN	Futures	99.308358	99.321289	99.256635	99.282497	5123.0

> showing 35 of 247 rows — these rows as CSV

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