PREVIEW / futures_1hour / 2010-03-24

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-24.parquet
  size:    46 KB
  rows:    1,375

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-03-24 00:00:00	ES	Futures	1142.2	1142.69	1141.72	1142.2	2060.0
2010-03-24 01:00:00	ES	Futures	1142.2	1142.2	1140.74	1141.47	4486.0
2010-03-24 02:00:00	ES	Futures	1141.47	1141.96	1140.49	1141.72	4318.0
2010-03-24 03:00:00	ES	Futures	1141.72	1142.45	1141.23	1141.96	7900.0
2010-03-24 04:00:00	ES	Futures	1141.72	1143.43	1140.74	1141.47	22929.0
2010-03-24 05:00:00	ES	Futures	1141.47	1142.45	1140.98	1141.72	17662.0
2010-03-24 06:00:00	ES	Futures	1141.47	1141.72	1136.09	1138.54	66824.0
2010-03-24 07:00:00	ES	Futures	1138.54	1140.98	1138.29	1139.52	37202.0
2010-03-24 08:00:00	ES	Futures	1139.76	1141.47	1138.05	1140.25	57979.0
2010-03-24 09:00:00	ES	Futures	1140.25	1141.47	1138.54	1139.52	222967.0
2010-03-24 10:00:00	ES	Futures	1139.52	1142.69	1138.05	1140.49	277078.0
2010-03-24 11:00:00	ES	Futures	1140.49	1141.47	1135.36	1139.03	289174.0
2010-03-24 12:00:00	ES	Futures	1139.03	1141.47	1138.78	1140.0	163092.0
2010-03-24 13:00:00	ES	Futures	1140.25	1140.25	1135.12	1137.32	254672.0
2010-03-24 14:00:00	ES	Futures	1137.07	1139.03	1136.58	1136.83	145040.0
2010-03-24 15:00:00	ES	Futures	1136.83	1140.25	1136.09	1137.56	293508.0
2010-03-24 16:00:00	ES	Futures	1137.56	1138.78	1137.32	1138.05	86701.0
2010-03-24 17:00:00	ES	Futures	1138.29	1138.29	1137.8	1137.8	1217.0
2010-03-24 18:00:00	ES	Futures	1137.8	1138.29	1137.8	1138.05	1210.0
2010-03-24 19:00:00	ES	Futures	1138.29	1139.03	1138.05	1138.78	3269.0
2010-03-24 20:00:00	ES	Futures	1138.54	1138.78	1138.29	1138.54	2269.0
2010-03-24 21:00:00	ES	Futures	1138.54	1140.0	1138.54	1138.54	4789.0
2010-03-24 22:00:00	ES	Futures	1138.54	1138.54	1137.56	1138.29	3081.0
2010-03-24 23:00:00	ES	Futures	1138.05	1138.29	1137.56	1138.05	1028.0
2010-03-24 00:00:00	NQ	Futures	2245.16	2245.73	2244.87	2244.87	73.0
2010-03-24 01:00:00	NQ	Futures	2244.87	2244.87	2243.44	2244.02	143.0
2010-03-24 02:00:00	NQ	Futures	2244.02	2244.3	2243.16	2243.73	160.0
2010-03-24 03:00:00	NQ	Futures	2244.02	2245.16	2243.44	2244.02	591.0
2010-03-24 04:00:00	NQ	Futures	2244.3	2246.88	2242.3	2244.3	2075.0
2010-03-24 05:00:00	NQ	Futures	2244.3	2246.02	2243.16	2244.3	1073.0
2010-03-24 06:00:00	NQ	Futures	2244.02	2244.02	2235.71	2238.86	3448.0
2010-03-24 07:00:00	NQ	Futures	2238.86	2241.44	2238.57	2240.58	1554.0
2010-03-24 08:00:00	NQ	Futures	2240.87	2244.87	2238.57	2242.3	4581.0
2010-03-24 09:00:00	NQ	Futures	2242.3	2242.3	2234.85	2237.43	30403.0
2010-03-24 10:00:00	NQ	Futures	2237.14	2240.87	2233.42	2237.43	37079.0
2010-03-24 11:00:00	NQ	Futures	2237.43	2239.72	2229.12	2235.71	35416.0
2010-03-24 12:00:00	NQ	Futures	2235.71	2238.0	2234.57	2235.71	21109.0
2010-03-24 13:00:00	NQ	Futures	2236.0	2236.28	2229.41	2233.42	27347.0
2010-03-24 14:00:00	NQ	Futures	2233.42	2235.71	2230.84	2231.13	22291.0
2010-03-24 15:00:00	NQ	Futures	2231.42	2238.29	2230.56	2234.28	36063.0
2010-03-24 16:00:00	NQ	Futures	2234.28	2236.28	2233.42	2234.85	7508.0
2010-03-24 17:00:00	NQ	Futures	2234.85	2236.28	2234.28	2234.85	62.0
2010-03-24 18:00:00	NQ	Futures	2233.71	2235.71	2233.71	2235.14	97.0
2010-03-24 19:00:00	NQ	Futures	2234.85	2236.28	2234.85	2235.14	117.0
2010-03-24 20:00:00	NQ	Futures	2235.14	2235.71	2234.85	2235.71	106.0
2010-03-24 21:00:00	NQ	Futures	2236.0	2238.86	2236.0	2237.14	457.0
2010-03-24 22:00:00	NQ	Futures	2236.86	2236.86	2235.14	2235.71	126.0
2010-03-24 23:00:00	NQ	Futures	2235.71	2236.28	2235.42	2236.28	104.0
2010-03-24 00:00:00	YM	Futures	10177.6	10179.5	10175.8	10176.7	103.0
2010-03-24 01:00:00	YM	Futures	10175.8	10176.7	10170.1	10172.9	270.0

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

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