PREVIEW / futures_1hour / 2010-04-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-27.parquet
  size:    49 KB
  rows:    1,416

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-04-27 00:00:00	ES	Futures	1182.53	1183.02	1182.29	1182.29	2619.0
2010-04-27 01:00:00	ES	Futures	1182.29	1182.53	1181.31	1181.31	2977.0
2010-04-27 02:00:00	ES	Futures	1181.31	1182.29	1181.31	1181.56	6906.0
2010-04-27 03:00:00	ES	Futures	1181.8	1182.78	1179.11	1179.85	25745.0
2010-04-27 04:00:00	ES	Futures	1179.85	1181.31	1179.11	1180.33	13142.0
2010-04-27 05:00:00	ES	Futures	1180.58	1181.31	1178.13	1178.13	27690.0
2010-04-27 06:00:00	ES	Futures	1178.13	1178.62	1175.45	1175.93	37519.0
2010-04-27 07:00:00	ES	Futures	1175.93	1178.13	1175.93	1176.42	35746.0
2010-04-27 08:00:00	ES	Futures	1176.18	1177.4	1175.45	1175.93	60208.0
2010-04-27 09:00:00	ES	Futures	1176.18	1178.13	1173.98	1178.13	287372.0
2010-04-27 10:00:00	ES	Futures	1177.89	1181.07	1175.93	1179.11	467768.0
2010-04-27 11:00:00	ES	Futures	1179.11	1179.6	1160.54	1161.27	864572.0
2010-04-27 12:00:00	ES	Futures	1161.51	1163.71	1157.11	1162.98	340214.0
2010-04-27 13:00:00	ES	Futures	1162.98	1168.11	1162.49	1166.16	277051.0
2010-04-27 14:00:00	ES	Futures	1166.16	1166.4	1159.31	1160.29	282499.0
2010-04-27 15:00:00	ES	Futures	1160.29	1164.2	1151.25	1153.45	664467.0
2010-04-27 16:00:00	ES	Futures	1153.45	1156.14	1152.96	1154.91	166672.0
2010-04-27 17:00:00	ES	Futures	1154.91	1155.4	1153.45	1153.69	3158.0
2010-04-27 18:00:00	ES	Futures	1153.94	1154.91	1153.45	1154.43	4758.0
2010-04-27 19:00:00	ES	Futures	1154.67	1156.38	1153.94	1156.38	5261.0
2010-04-27 20:00:00	ES	Futures	1156.14	1156.63	1153.94	1154.91	11311.0
2010-04-27 21:00:00	ES	Futures	1154.91	1156.63	1154.43	1156.38	7600.0
2010-04-27 22:00:00	ES	Futures	1156.63	1157.36	1156.14	1156.63	12283.0
2010-04-27 23:00:00	ES	Futures	1156.38	1157.36	1155.89	1156.87	3784.0
2010-04-27 00:00:00	NQ	Futures	2348.26	2348.83	2348.26	2348.54	84.0
2010-04-27 01:00:00	NQ	Futures	2348.54	2348.54	2345.96	2345.96	243.0
2010-04-27 02:00:00	NQ	Futures	2345.96	2347.4	2344.82	2346.54	461.0
2010-04-27 03:00:00	NQ	Futures	2346.54	2347.4	2342.81	2343.1	1776.0
2010-04-27 04:00:00	NQ	Futures	2343.1	2345.96	2343.1	2344.82	795.0
2010-04-27 05:00:00	NQ	Futures	2344.82	2346.54	2339.38	2339.66	2360.0
2010-04-27 06:00:00	NQ	Futures	2339.66	2339.95	2334.8	2335.94	2922.0
2010-04-27 07:00:00	NQ	Futures	2336.23	2340.81	2336.23	2337.66	2137.0
2010-04-27 08:00:00	NQ	Futures	2337.37	2339.66	2336.23	2337.09	4335.0
2010-04-27 09:00:00	NQ	Futures	2337.09	2340.81	2331.65	2337.66	45406.0
2010-04-27 10:00:00	NQ	Futures	2337.95	2345.96	2334.51	2340.81	52885.0
2010-04-27 11:00:00	NQ	Futures	2340.52	2341.67	2302.44	2305.59	111232.0
2010-04-27 12:00:00	NQ	Futures	2305.59	2309.31	2296.99	2305.01	45570.0
2010-04-27 13:00:00	NQ	Futures	2305.01	2319.05	2305.01	2314.75	33512.0
2010-04-27 14:00:00	NQ	Futures	2314.46	2315.04	2302.44	2303.01	35292.0
2010-04-27 15:00:00	NQ	Futures	2303.29	2311.03	2289.26	2296.14	77495.0
2010-04-27 16:00:00	NQ	Futures	2296.42	2302.72	2295.28	2301.58	17223.0
2010-04-27 17:00:00	NQ	Futures	2301.29	2301.86	2299.0	2299.0	228.0
2010-04-27 18:00:00	NQ	Futures	2299.29	2300.43	2298.71	2299.57	521.0
2010-04-27 19:00:00	NQ	Futures	2299.86	2303.58	2299.57	2303.01	311.0
2010-04-27 20:00:00	NQ	Futures	2303.29	2303.87	2298.71	2299.86	1156.0
2010-04-27 21:00:00	NQ	Futures	2299.86	2303.01	2299.57	2303.01	260.0
2010-04-27 22:00:00	NQ	Futures	2303.29	2304.73	2302.72	2303.58	293.0
2010-04-27 23:00:00	NQ	Futures	2303.58	2305.01	2302.72	2303.58	206.0
2010-04-27 00:00:00	YM	Futures	10506.0	10507.0	10503.2	10506.0	140.0
2010-04-27 01:00:00	YM	Futures	10506.0	10507.0	10498.5	10498.5	177.0

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

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