PREVIEW / futures_1hour / 2010-05-07

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-07.parquet
  size:    42 KB
  rows:    1,153

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-05-07 00:00:00	ES	Futures	1103.83	1105.3	1100.41	1101.14	9838.0
2010-05-07 01:00:00	ES	Futures	1101.38	1102.36	1091.36	1094.3	18225.0
2010-05-07 02:00:00	ES	Futures	1094.3	1101.14	1091.61	1094.79	43985.0
2010-05-07 03:00:00	ES	Futures	1094.54	1103.83	1094.3	1100.16	83979.0
2010-05-07 04:00:00	ES	Futures	1100.41	1107.74	1098.21	1100.65	67583.0
2010-05-07 05:00:00	ES	Futures	1100.9	1104.81	1097.47	1101.87	43820.0
2010-05-07 06:00:00	ES	Futures	1101.87	1108.47	1101.63	1107.98	51136.0
2010-05-07 07:00:00	ES	Futures	1108.23	1108.72	1100.41	1100.9	67094.0
2010-05-07 08:00:00	ES	Futures	1100.9	1110.18	1098.21	1103.58	243850.0
2010-05-07 09:00:00	ES	Futures	1103.83	1107.5	1091.61	1095.52	559675.0
2010-05-07 10:00:00	ES	Futures	1095.27	1096.74	1066.43	1080.12	1090217.0
2010-05-07 11:00:00	ES	Futures	1080.12	1100.9	1077.92	1094.3	807431.0
2010-05-07 12:00:00	ES	Futures	1094.3	1102.61	1087.7	1089.65	439699.0
2010-05-07 13:00:00	ES	Futures	1089.9	1094.79	1083.3	1090.14	308350.0
2010-05-07 14:00:00	ES	Futures	1090.14	1092.1	1081.59	1085.25	322688.0
2010-05-07 15:00:00	ES	Futures	1085.25	1085.99	1076.21	1083.54	583172.0
2010-05-07 16:00:00	ES	Futures	1083.3	1083.3	1079.14	1082.81	123064.0
2010-05-07 00:00:00	NQ	Futures	2173.28	2175.86	2166.98	2168.13	663.0
2010-05-07 01:00:00	NQ	Futures	2168.41	2171.28	2146.94	2152.38	1868.0
2010-05-07 02:00:00	NQ	Futures	2152.38	2165.55	2148.65	2152.66	4503.0
2010-05-07 03:00:00	NQ	Futures	2152.38	2171.85	2152.38	2165.84	5471.0
2010-05-07 04:00:00	NQ	Futures	2165.55	2181.01	2162.4	2167.27	5211.0
2010-05-07 05:00:00	NQ	Futures	2167.27	2172.71	2159.54	2169.56	4275.0
2010-05-07 06:00:00	NQ	Futures	2169.56	2185.31	2169.56	2183.59	4271.0
2010-05-07 07:00:00	NQ	Futures	2183.88	2184.16	2168.7	2168.7	5869.0
2010-05-07 08:00:00	NQ	Futures	2168.7	2187.03	2163.83	2168.41	24349.0
2010-05-07 09:00:00	NQ	Futures	2168.7	2176.72	2134.91	2144.93	113339.0
2010-05-07 10:00:00	NQ	Futures	2145.22	2147.22	2068.47	2113.14	173129.0
2010-05-07 11:00:00	NQ	Futures	2113.43	2156.39	2109.99	2142.93	117681.0
2010-05-07 12:00:00	NQ	Futures	2142.64	2158.39	2128.89	2132.33	54382.0
2010-05-07 13:00:00	NQ	Futures	2132.9	2141.21	2120.3	2130.04	44328.0
2010-05-07 14:00:00	NQ	Futures	2130.33	2134.33	2112.57	2120.88	38907.0
2010-05-07 15:00:00	NQ	Futures	2120.59	2122.31	2099.68	2115.15	79258.0
2010-05-07 16:00:00	NQ	Futures	2114.86	2118.58	2110.57	2118.3	20031.0
2010-05-07 00:00:00	YM	Futures	9897.2	9907.6	9872.8	9876.5	1025.0
2010-05-07 01:00:00	YM	Futures	9876.5	9883.1	9803.1	9822.9	2536.0
2010-05-07 02:00:00	YM	Futures	9823.8	9878.4	9805.0	9823.8	5296.0
2010-05-07 03:00:00	YM	Futures	9822.9	9896.3	9821.9	9863.4	7371.0
2010-05-07 04:00:00	YM	Futures	9863.4	9915.1	9850.2	9859.6	4657.0
2010-05-07 05:00:00	YM	Futures	9861.5	9882.2	9835.1	9869.0	3444.0
2010-05-07 06:00:00	YM	Futures	9868.1	9914.2	9868.1	9910.4	2143.0
2010-05-07 07:00:00	YM	Futures	9912.3	9919.8	9855.8	9863.4	3295.0
2010-05-07 08:00:00	YM	Futures	9861.5	9955.6	9841.7	9884.1	12225.0
2010-05-07 09:00:00	YM	Futures	9885.0	9917.9	9797.5	9828.5	44724.0
2010-05-07 10:00:00	YM	Futures	9827.6	9838.9	9599.9	9704.3	70560.0
2010-05-07 11:00:00	YM	Futures	9703.4	9877.5	9687.4	9817.2	51227.0
2010-05-07 12:00:00	YM	Futures	9816.3	9888.8	9758.0	9781.5	28024.0
2010-05-07 13:00:00	YM	Futures	9782.4	9814.4	9728.8	9778.7	16895.0
2010-05-07 14:00:00	YM	Futures	9779.6	9793.7	9710.0	9745.7	18482.0
2010-05-07 15:00:00	YM	Futures	9742.9	9752.3	9662.0	9729.7	39244.0

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

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