PREVIEW / futures_1hour / 2008-06-09

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-09.parquet
  size:    44 KB
  rows:    1,216

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
2008-06-09 00:00:00	ES	Futures	1268.77	1269.93	1268.53	1269.23	1221.0
2008-06-09 01:00:00	ES	Futures	1269.23	1269.46	1267.83	1268.07	1784.0
2008-06-09 02:00:00	ES	Futures	1268.07	1270.86	1268.07	1270.63	7110.0
2008-06-09 03:00:00	ES	Futures	1270.63	1273.19	1268.53	1272.96	28434.0
2008-06-09 04:00:00	ES	Futures	1272.96	1273.66	1271.33	1272.96	15232.0
2008-06-09 05:00:00	ES	Futures	1272.96	1273.19	1270.4	1272.26	11193.0
2008-06-09 06:00:00	ES	Futures	1272.49	1272.96	1268.3	1271.33	23543.0
2008-06-09 07:00:00	ES	Futures	1271.56	1272.49	1265.74	1268.77	36518.0
2008-06-09 08:00:00	ES	Futures	1268.77	1272.96	1268.53	1271.79	34237.0
2008-06-09 09:00:00	ES	Futures	1271.79	1273.66	1266.9	1272.72	243014.0
2008-06-09 10:00:00	ES	Futures	1272.96	1277.38	1270.63	1271.33	372743.0
2008-06-09 11:00:00	ES	Futures	1271.33	1275.75	1270.86	1272.72	254308.0
2008-06-09 12:00:00	ES	Futures	1272.96	1274.59	1270.63	1274.12	100726.0
2008-06-09 13:00:00	ES	Futures	1274.12	1274.12	1261.55	1263.18	290149.0
2008-06-09 14:00:00	ES	Futures	1263.41	1266.9	1257.82	1262.01	357808.0
2008-06-09 15:00:00	ES	Futures	1262.25	1270.4	1258.99	1269.0	341975.0
2008-06-09 16:00:00	ES	Futures	1269.23	1270.4	1267.6	1269.23	63762.0
2008-06-09 17:00:00	ES	Futures	1269.23	1269.7	1269.23	1269.46	1120.0
2008-06-09 18:00:00	ES	Futures	1269.46	1269.7	1267.83	1268.07	2272.0
2008-06-09 19:00:00	ES	Futures	1268.07	1269.0	1267.83	1269.0	1198.0
2008-06-09 20:00:00	ES	Futures	1268.77	1269.23	1264.11	1265.04	6625.0
2008-06-09 21:00:00	ES	Futures	1265.04	1265.74	1263.18	1263.88	3291.0
2008-06-09 22:00:00	ES	Futures	1264.11	1264.81	1262.94	1263.41	2588.0
2008-06-09 23:00:00	ES	Futures	1263.41	1263.88	1262.25	1263.64	1381.0
2008-06-09 00:00:00	NQ	Futures	2256.12	2257.54	2254.43	2256.41	226.0
2008-06-09 01:00:00	NQ	Futures	2256.41	2256.69	2253.86	2254.99	92.0
2008-06-09 02:00:00	NQ	Futures	2254.71	2258.95	2254.71	2258.39	417.0
2008-06-09 03:00:00	NQ	Futures	2258.95	2261.5	2253.86	2260.65	2362.0
2008-06-09 04:00:00	NQ	Futures	2260.37	2262.35	2258.95	2260.93	1272.0
2008-06-09 05:00:00	NQ	Futures	2260.65	2261.5	2256.97	2260.93	887.0
2008-06-09 06:00:00	NQ	Futures	2261.21	2261.78	2254.14	2259.8	1158.0
2008-06-09 07:00:00	NQ	Futures	2260.08	2261.78	2250.18	2255.28	2136.0
2008-06-09 08:00:00	NQ	Futures	2255.28	2263.19	2254.99	2258.95	4168.0
2008-06-09 09:00:00	NQ	Futures	2258.67	2262.91	2226.71	2241.7	73368.0
2008-06-09 10:00:00	NQ	Futures	2240.0	2254.43	2229.26	2230.39	90271.0
2008-06-09 11:00:00	NQ	Futures	2230.67	2242.27	2230.1	2237.74	62852.0
2008-06-09 12:00:00	NQ	Futures	2237.74	2241.98	2229.82	2240.57	34028.0
2008-06-09 13:00:00	NQ	Futures	2240.29	2241.13	2207.19	2214.27	70875.0
2008-06-09 14:00:00	NQ	Futures	2214.27	2233.21	2204.93	2215.68	92229.0
2008-06-09 15:00:00	NQ	Futures	2215.96	2245.38	2208.04	2243.4	82982.0
2008-06-09 16:00:00	NQ	Futures	2243.4	2248.77	2241.42	2247.07	17117.0
2008-06-09 17:00:00	NQ	Futures	2246.79	2248.2	2246.51	2247.92	182.0
2008-06-09 18:00:00	NQ	Futures	2247.36	2247.36	2243.96	2244.25	423.0
2008-06-09 19:00:00	NQ	Futures	2243.96	2246.51	2243.96	2246.22	271.0
2008-06-09 20:00:00	NQ	Futures	2246.79	2246.79	2239.44	2239.72	612.0
2008-06-09 21:00:00	NQ	Futures	2239.72	2240.85	2237.74	2237.74	391.0
2008-06-09 22:00:00	NQ	Futures	2238.59	2238.87	2234.06	2235.76	851.0
2008-06-09 23:00:00	NQ	Futures	2235.76	2237.46	2234.63	2236.89	163.0
2008-06-09 00:00:00	YM	Futures	11117.4	11127.3	11117.4	11120.1	213.0
2008-06-09 01:00:00	YM	Futures	11120.1	11122.8	11109.2	11109.2	289.0

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

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