PREVIEW / futures_1hour / 2010-05-04

all futures 1-hour files

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

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-04 00:00:00	ES	Futures	1170.56	1171.54	1170.56	1171.05	2336.0
2010-05-04 01:00:00	ES	Futures	1171.54	1171.54	1170.31	1170.8	2058.0
2010-05-04 02:00:00	ES	Futures	1171.05	1172.02	1169.82	1170.8	12205.0
2010-05-04 03:00:00	ES	Futures	1170.8	1171.78	1169.82	1170.8	27776.0
2010-05-04 04:00:00	ES	Futures	1170.8	1172.02	1166.65	1167.38	45114.0
2010-05-04 05:00:00	ES	Futures	1167.38	1167.87	1163.96	1165.18	48166.0
2010-05-04 06:00:00	ES	Futures	1165.42	1166.4	1163.96	1165.18	25106.0
2010-05-04 07:00:00	ES	Futures	1165.18	1166.16	1162.0	1163.71	74242.0
2010-05-04 08:00:00	ES	Futures	1163.71	1165.42	1159.8	1160.29	94137.0
2010-05-04 09:00:00	ES	Futures	1160.05	1160.78	1150.76	1154.67	514713.0
2010-05-04 10:00:00	ES	Futures	1154.67	1156.63	1144.4	1144.4	718841.0
2010-05-04 11:00:00	ES	Futures	1144.65	1147.34	1140.98	1146.6	442614.0
2010-05-04 12:00:00	ES	Futures	1146.6	1146.6	1139.27	1145.14	323707.0
2010-05-04 13:00:00	ES	Futures	1145.14	1147.58	1142.69	1145.38	222833.0
2010-05-04 14:00:00	ES	Futures	1145.14	1145.87	1141.47	1142.2	242110.0
2010-05-04 15:00:00	ES	Futures	1142.2	1146.11	1138.29	1144.4	555308.0
2010-05-04 16:00:00	ES	Futures	1144.4	1147.58	1143.91	1144.89	187110.0
2010-05-04 17:00:00	ES	Futures	1144.65	1144.89	1142.94	1143.18	2951.0
2010-05-04 18:00:00	ES	Futures	1143.18	1143.67	1142.2	1142.94	7900.0
2010-05-04 19:00:00	ES	Futures	1142.94	1144.4	1141.96	1144.16	4501.0
2010-05-04 20:00:00	ES	Futures	1144.4	1144.4	1143.43	1143.43	2789.0
2010-05-04 21:00:00	ES	Futures	1143.43	1144.65	1143.18	1144.16	4837.0
2010-05-04 22:00:00	ES	Futures	1144.4	1145.87	1144.16	1145.87	5048.0
2010-05-04 23:00:00	ES	Futures	1145.87	1146.36	1144.65	1144.89	3262.0
2010-05-04 00:00:00	NQ	Futures	2319.33	2320.48	2318.76	2319.9	142.0
2010-05-04 01:00:00	NQ	Futures	2319.9	2320.76	2318.76	2319.9	192.0
2010-05-04 02:00:00	NQ	Futures	2319.9	2320.76	2317.61	2319.33	542.0
2010-05-04 03:00:00	NQ	Futures	2319.33	2321.34	2317.04	2319.62	1608.0
2010-05-04 04:00:00	NQ	Futures	2319.33	2320.76	2311.6	2313.03	3262.0
2010-05-04 05:00:00	NQ	Futures	2312.75	2313.6	2308.45	2310.45	2854.0
2010-05-04 06:00:00	NQ	Futures	2310.17	2311.89	2307.02	2308.74	1805.0
2010-05-04 07:00:00	NQ	Futures	2309.02	2309.88	2302.15	2305.59	4456.0
2010-05-04 08:00:00	NQ	Futures	2305.59	2307.59	2295.56	2295.85	12559.0
2010-05-04 09:00:00	NQ	Futures	2295.85	2297.28	2266.35	2273.23	90538.0
2010-05-04 10:00:00	NQ	Futures	2273.23	2274.66	2248.88	2251.17	108236.0
2010-05-04 11:00:00	NQ	Futures	2251.46	2254.61	2240.29	2253.75	68844.0
2010-05-04 12:00:00	NQ	Futures	2253.75	2254.04	2236.28	2248.02	54557.0
2010-05-04 13:00:00	NQ	Futures	2248.31	2256.33	2244.3	2253.18	34863.0
2010-05-04 14:00:00	NQ	Futures	2253.18	2254.61	2244.02	2247.45	33085.0
2010-05-04 15:00:00	NQ	Futures	2247.45	2256.04	2241.15	2253.18	77629.0
2010-05-04 16:00:00	NQ	Futures	2253.18	2260.34	2252.89	2256.33	18023.0
2010-05-04 17:00:00	NQ	Futures	2255.47	2256.33	2253.18	2253.47	365.0
2010-05-04 18:00:00	NQ	Futures	2253.75	2254.04	2252.32	2253.18	382.0
2010-05-04 19:00:00	NQ	Futures	2252.61	2255.18	2250.89	2254.61	450.0
2010-05-04 20:00:00	NQ	Futures	2254.61	2255.47	2253.47	2253.47	192.0
2010-05-04 21:00:00	NQ	Futures	2253.18	2255.18	2252.61	2254.04	453.0
2010-05-04 22:00:00	NQ	Futures	2254.33	2256.62	2254.33	2255.76	294.0
2010-05-04 23:00:00	NQ	Futures	2255.76	2256.62	2254.61	2254.61	109.0
2010-05-04 00:00:00	YM	Futures	10438.3	10444.9	10437.3	10443.9	162.0
2010-05-04 01:00:00	YM	Futures	10442.1	10443.9	10435.5	10437.3	157.0

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

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