PREVIEW / futures_1hour / 2010-05-11

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-11.parquet
  size:    48 KB
  rows:    1,402

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-11 00:00:00	ES	Futures	1128.27	1128.27	1122.89	1124.36	15993.0
2010-05-11 01:00:00	ES	Futures	1124.12	1125.83	1122.65	1122.65	6241.0
2010-05-11 02:00:00	ES	Futures	1122.89	1122.89	1118.01	1119.72	27035.0
2010-05-11 03:00:00	ES	Futures	1119.72	1123.87	1117.27	1122.89	49581.0
2010-05-11 04:00:00	ES	Futures	1122.89	1123.38	1115.81	1117.76	37329.0
2010-05-11 05:00:00	ES	Futures	1118.01	1119.96	1116.54	1118.74	22321.0
2010-05-11 06:00:00	ES	Futures	1118.74	1120.69	1116.78	1117.03	22228.0
2010-05-11 07:00:00	ES	Futures	1117.03	1121.43	1115.07	1119.23	46620.0
2010-05-11 08:00:00	ES	Futures	1119.23	1121.43	1117.03	1117.52	51864.0
2010-05-11 09:00:00	ES	Futures	1117.27	1127.29	1116.54	1125.09	309997.0
2010-05-11 10:00:00	ES	Futures	1124.85	1128.76	1123.38	1126.32	316991.0
2010-05-11 11:00:00	ES	Futures	1126.07	1135.6	1125.83	1133.65	313691.0
2010-05-11 12:00:00	ES	Futures	1133.65	1140.0	1133.16	1139.03	248242.0
2010-05-11 13:00:00	ES	Futures	1139.27	1142.94	1136.34	1139.52	259495.0
2010-05-11 14:00:00	ES	Futures	1139.52	1140.25	1129.49	1131.45	382096.0
2010-05-11 15:00:00	ES	Futures	1131.45	1132.67	1125.34	1127.54	396698.0
2010-05-11 16:00:00	ES	Futures	1127.54	1128.27	1124.61	1124.61	103418.0
2010-05-11 17:00:00	ES	Futures	1124.61	1125.34	1124.36	1124.61	2910.0
2010-05-11 18:00:00	ES	Futures	1124.36	1124.61	1117.03	1120.94	17086.0
2010-05-11 19:00:00	ES	Futures	1120.94	1122.65	1119.96	1122.41	5410.0
2010-05-11 20:00:00	ES	Futures	1122.41	1125.09	1121.67	1123.14	10535.0
2010-05-11 21:00:00	ES	Futures	1123.14	1124.61	1121.43	1123.14	6532.0
2010-05-11 22:00:00	ES	Futures	1122.89	1123.63	1121.92	1121.92	3945.0
2010-05-11 23:00:00	ES	Futures	1121.92	1122.41	1120.21	1120.69	3579.0
2010-05-11 00:00:00	NQ	Futures	2215.66	2215.95	2204.78	2208.79	980.0
2010-05-11 01:00:00	NQ	Futures	2208.79	2213.09	2206.5	2207.07	474.0
2010-05-11 02:00:00	NQ	Futures	2206.79	2206.79	2197.91	2201.35	2228.0
2010-05-11 03:00:00	NQ	Futures	2201.35	2209.36	2196.48	2207.65	4392.0
2010-05-11 04:00:00	NQ	Futures	2207.65	2208.79	2195.05	2199.06	2719.0
2010-05-11 05:00:00	NQ	Futures	2198.48	2202.49	2196.19	2201.06	1605.0
2010-05-11 06:00:00	NQ	Futures	2200.77	2204.5	2197.34	2197.91	1414.0
2010-05-11 07:00:00	NQ	Futures	2197.91	2205.64	2193.61	2201.06	2947.0
2010-05-11 08:00:00	NQ	Futures	2201.06	2205.93	2196.76	2198.2	5233.0
2010-05-11 09:00:00	NQ	Futures	2198.2	2217.96	2195.62	2209.94	54208.0
2010-05-11 10:00:00	NQ	Futures	2209.94	2221.11	2205.64	2215.38	47046.0
2010-05-11 11:00:00	NQ	Futures	2215.38	2237.72	2214.52	2234.28	43355.0
2010-05-11 12:00:00	NQ	Futures	2233.99	2246.88	2233.13	2244.3	39164.0
2010-05-11 13:00:00	NQ	Futures	2244.3	2250.89	2240.87	2246.31	38871.0
2010-05-11 14:00:00	NQ	Futures	2246.59	2248.88	2225.4	2228.27	57950.0
2010-05-11 15:00:00	NQ	Futures	2227.98	2231.13	2217.1	2219.96	59503.0
2010-05-11 16:00:00	NQ	Futures	2219.67	2220.82	2211.66	2211.94	9587.0
2010-05-11 17:00:00	NQ	Futures	2211.94	2213.09	2211.37	2211.66	149.0
2010-05-11 18:00:00	NQ	Futures	2211.08	2211.94	2197.62	2205.64	1137.0
2010-05-11 19:00:00	NQ	Futures	2204.78	2208.51	2203.35	2208.51	288.0
2010-05-11 20:00:00	NQ	Futures	2208.79	2213.09	2207.07	2209.36	736.0
2010-05-11 21:00:00	NQ	Futures	2209.36	2212.51	2207.07	2209.65	388.0
2010-05-11 22:00:00	NQ	Futures	2209.65	2210.51	2206.79	2207.07	384.0
2010-05-11 23:00:00	NQ	Futures	2206.79	2207.07	2203.06	2203.06	289.0
2010-05-11 00:00:00	YM	Futures	10077.0	10077.0	10038.4	10054.4	1149.0
2010-05-11 01:00:00	YM	Futures	10057.2	10067.5	10044.0	10047.8	662.0

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

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