PREVIEW / futures_1hour / 2010-09-03

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-03.parquet
  size:    38 KB
  rows:    1,086

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-09-03 00:00:00	ES	Futures	1067.16	1068.14	1066.66	1067.16	1742.0
2010-09-03 01:00:00	ES	Futures	1067.16	1067.65	1066.17	1067.4	4113.0
2010-09-03 02:00:00	ES	Futures	1067.4	1068.63	1066.91	1067.89	6948.0
2010-09-03 03:00:00	ES	Futures	1068.14	1069.85	1066.91	1069.61	26140.0
2010-09-03 04:00:00	ES	Futures	1069.61	1069.85	1067.65	1069.12	15532.0
2010-09-03 05:00:00	ES	Futures	1069.12	1070.84	1068.87	1070.35	16489.0
2010-09-03 06:00:00	ES	Futures	1070.59	1071.82	1070.1	1070.35	11980.0
2010-09-03 07:00:00	ES	Futures	1070.59	1070.59	1067.65	1067.89	30683.0
2010-09-03 08:00:00	ES	Futures	1067.89	1083.35	1067.4	1081.14	251760.0
2010-09-03 09:00:00	ES	Futures	1081.14	1084.09	1079.18	1083.35	310789.0
2010-09-03 10:00:00	ES	Futures	1083.11	1083.35	1073.54	1075.74	445323.0
2010-09-03 11:00:00	ES	Futures	1075.74	1078.2	1074.52	1076.97	161499.0
2010-09-03 12:00:00	ES	Futures	1077.22	1080.9	1076.73	1080.16	103567.0
2010-09-03 13:00:00	ES	Futures	1080.16	1082.61	1079.67	1081.88	118240.0
2010-09-03 14:00:00	ES	Futures	1081.88	1082.61	1078.93	1079.42	107933.0
2010-09-03 15:00:00	ES	Futures	1079.18	1083.6	1078.69	1083.35	233530.0
2010-09-03 16:00:00	ES	Futures	1083.35	1084.09	1082.37	1082.86	100318.0
2010-09-03 00:00:00	NQ	Futures	2103.11	2105.97	2102.82	2104.83	182.0
2010-09-03 01:00:00	NQ	Futures	2105.4	2106.26	2102.82	2104.25	552.0
2010-09-03 02:00:00	NQ	Futures	2104.54	2106.83	2103.39	2105.97	321.0
2010-09-03 03:00:00	NQ	Futures	2105.97	2109.7	2104.25	2109.7	1978.0
2010-09-03 04:00:00	NQ	Futures	2109.7	2110.56	2105.97	2109.13	1127.0
2010-09-03 05:00:00	NQ	Futures	2109.41	2113.14	2108.55	2110.85	1813.0
2010-09-03 06:00:00	NQ	Futures	2110.85	2113.42	2110.27	2110.56	914.0
2010-09-03 07:00:00	NQ	Futures	2110.85	2110.85	2104.54	2105.4	1899.0
2010-09-03 08:00:00	NQ	Futures	2105.4	2136.64	2105.11	2132.91	24139.0
2010-09-03 09:00:00	NQ	Futures	2132.91	2143.51	2127.75	2142.08	56026.0
2010-09-03 10:00:00	NQ	Futures	2142.08	2142.37	2121.73	2125.75	72598.0
2010-09-03 11:00:00	NQ	Futures	2125.75	2132.05	2122.88	2129.47	32008.0
2010-09-03 12:00:00	NQ	Futures	2129.47	2138.36	2128.61	2136.35	19733.0
2010-09-03 13:00:00	NQ	Futures	2136.35	2142.08	2135.78	2141.51	21911.0
2010-09-03 14:00:00	NQ	Futures	2141.51	2142.65	2135.49	2135.78	22591.0
2010-09-03 15:00:00	NQ	Futures	2135.78	2143.23	2134.34	2142.94	36214.0
2010-09-03 16:00:00	NQ	Futures	2142.65	2144.95	2140.36	2140.65	10002.0
2010-09-03 00:00:00	YM	Futures	9743.4	9750.0	9739.6	9742.5	91.0
2010-09-03 01:00:00	YM	Futures	9740.6	9746.3	9735.8	9746.3	112.0
2010-09-03 02:00:00	YM	Futures	9745.3	9753.8	9739.6	9748.2	529.0
2010-09-03 03:00:00	YM	Futures	9748.2	9762.4	9740.6	9762.4	1234.0
2010-09-03 04:00:00	YM	Futures	9762.4	9765.2	9743.4	9752.9	1146.0
2010-09-03 05:00:00	YM	Futures	9751.9	9768.0	9751.0	9767.1	808.0
2010-09-03 06:00:00	YM	Futures	9766.1	9775.6	9762.4	9766.1	493.0
2010-09-03 07:00:00	YM	Futures	9766.1	9766.1	9746.3	9747.2	800.0
2010-09-03 08:00:00	YM	Futures	9746.3	9878.8	9743.4	9861.7	12766.0
2010-09-03 09:00:00	YM	Futures	9861.7	9887.3	9840.9	9883.5	21522.0
2010-09-03 10:00:00	YM	Futures	9883.5	9883.5	9795.5	9810.6	33656.0
2010-09-03 11:00:00	YM	Futures	9811.6	9833.3	9801.2	9823.9	14637.0
2010-09-03 12:00:00	YM	Futures	9822.9	9856.1	9819.1	9851.3	6768.0
2010-09-03 13:00:00	YM	Futures	9850.4	9869.3	9846.6	9865.5	7523.0
2010-09-03 14:00:00	YM	Futures	9866.5	9868.4	9845.7	9846.6	8090.0
2010-09-03 15:00:00	YM	Futures	9845.7	9881.6	9842.8	9879.7	13704.0

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

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