PREVIEW / futures_1hour / 2010-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-14.parquet
  size:    45 KB
  rows:    1,388

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-14 00:00:00	ES	Futures	1168.6	1169.34	1167.87	1169.09	3383.0
2010-04-14 01:00:00	ES	Futures	1168.85	1169.58	1168.6	1169.34	3958.0
2010-04-14 02:00:00	ES	Futures	1169.34	1170.56	1168.85	1169.82	10659.0
2010-04-14 03:00:00	ES	Futures	1169.82	1170.31	1167.87	1168.11	16642.0
2010-04-14 04:00:00	ES	Futures	1168.11	1169.34	1167.87	1168.85	9433.0
2010-04-14 05:00:00	ES	Futures	1168.85	1169.34	1168.6	1169.09	5041.0
2010-04-14 06:00:00	ES	Futures	1169.09	1170.07	1168.6	1169.82	10696.0
2010-04-14 07:00:00	ES	Futures	1169.82	1171.78	1169.58	1171.54	35556.0
2010-04-14 08:00:00	ES	Futures	1171.54	1173.25	1170.8	1171.05	78856.0
2010-04-14 09:00:00	ES	Futures	1171.05	1173.73	1170.56	1171.78	221814.0
2010-04-14 10:00:00	ES	Futures	1171.54	1173.49	1169.34	1173.0	308445.0
2010-04-14 11:00:00	ES	Futures	1172.76	1174.96	1172.76	1173.73	189973.0
2010-04-14 12:00:00	ES	Futures	1173.73	1176.18	1173.73	1175.69	131153.0
2010-04-14 13:00:00	ES	Futures	1175.69	1177.4	1174.71	1174.96	126732.0
2010-04-14 14:00:00	ES	Futures	1174.71	1177.89	1174.71	1177.65	138141.0
2010-04-14 15:00:00	ES	Futures	1177.4	1180.33	1176.67	1179.85	286235.0
2010-04-14 16:00:00	ES	Futures	1180.09	1180.58	1179.11	1180.09	116462.0
2010-04-14 17:00:00	ES	Futures	1180.09	1180.09	1179.36	1179.6	2190.0
2010-04-14 18:00:00	ES	Futures	1179.6	1180.09	1179.11	1179.36	3347.0
2010-04-14 19:00:00	ES	Futures	1179.36	1179.6	1179.11	1179.6	955.0
2010-04-14 20:00:00	ES	Futures	1179.6	1179.6	1177.89	1178.38	6894.0
2010-04-14 21:00:00	ES	Futures	1178.13	1178.62	1177.65	1178.13	2581.0
2010-04-14 22:00:00	ES	Futures	1177.89	1178.62	1177.65	1177.65	2948.0
2010-04-14 23:00:00	ES	Futures	1177.89	1178.13	1177.65	1177.89	1168.0
2010-04-14 00:00:00	NQ	Futures	2300.43	2301.86	2299.86	2301.86	202.0
2010-04-14 01:00:00	NQ	Futures	2301.58	2303.01	2301.29	2302.15	702.0
2010-04-14 02:00:00	NQ	Futures	2302.15	2304.44	2301.29	2303.87	1604.0
2010-04-14 03:00:00	NQ	Futures	2304.15	2304.73	2299.86	2300.43	1755.0
2010-04-14 04:00:00	NQ	Futures	2300.14	2302.15	2300.14	2301.29	448.0
2010-04-14 05:00:00	NQ	Futures	2301.29	2302.15	2301.0	2301.86	363.0
2010-04-14 06:00:00	NQ	Futures	2301.86	2304.15	2301.58	2303.87	1013.0
2010-04-14 07:00:00	NQ	Futures	2304.15	2306.16	2303.01	2305.59	2220.0
2010-04-14 08:00:00	NQ	Futures	2305.59	2309.02	2304.73	2305.3	7609.0
2010-04-14 09:00:00	NQ	Futures	2305.01	2309.31	2302.15	2306.16	42612.0
2010-04-14 10:00:00	NQ	Futures	2306.44	2308.74	2302.44	2307.88	44076.0
2010-04-14 11:00:00	NQ	Futures	2308.16	2311.6	2305.87	2310.17	30863.0
2010-04-14 12:00:00	NQ	Futures	2310.45	2313.32	2309.02	2312.46	26314.0
2010-04-14 13:00:00	NQ	Futures	2312.46	2316.18	2310.45	2311.03	20337.0
2010-04-14 14:00:00	NQ	Futures	2311.03	2316.75	2311.03	2315.9	18830.0
2010-04-14 15:00:00	NQ	Futures	2315.61	2321.62	2314.18	2321.34	33089.0
2010-04-14 16:00:00	NQ	Futures	2321.34	2322.77	2319.05	2321.91	11879.0
2010-04-14 17:00:00	NQ	Futures	2321.91	2322.48	2321.34	2321.62	137.0
2010-04-14 18:00:00	NQ	Futures	2321.05	2321.91	2319.9	2321.05	236.0
2010-04-14 19:00:00	NQ	Futures	2320.76	2321.62	2320.76	2321.62	118.0
2010-04-14 20:00:00	NQ	Futures	2321.34	2321.34	2318.47	2319.05	314.0
2010-04-14 21:00:00	NQ	Futures	2318.76	2319.33	2318.19	2318.76	358.0
2010-04-14 22:00:00	NQ	Futures	2318.76	2319.62	2318.47	2318.47	146.0
2010-04-14 23:00:00	NQ	Futures	2318.76	2318.76	2317.04	2317.9	538.0
2010-04-14 00:00:00	YM	Futures	10336.7	10341.4	10332.9	10340.4	194.0
2010-04-14 01:00:00	YM	Futures	10340.4	10344.2	10337.6	10339.5	310.0

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

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