PREVIEW / futures_1hour / 2008-06-17

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-06-17.parquet
  size:    42 KB
  rows:    1,245

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-17 00:00:00	ES	Futures	1263.64	1265.27	1263.18	1264.11	880.0
2008-06-17 01:00:00	ES	Futures	1264.11	1265.04	1263.18	1264.57	1237.0
2008-06-17 02:00:00	ES	Futures	1264.57	1266.9	1264.34	1266.66	4009.0
2008-06-17 03:00:00	ES	Futures	1266.66	1268.76	1266.66	1267.36	10490.0
2008-06-17 04:00:00	ES	Futures	1267.36	1270.85	1267.36	1269.92	11532.0
2008-06-17 05:00:00	ES	Futures	1269.69	1270.85	1268.29	1270.38	11903.0
2008-06-17 06:00:00	ES	Futures	1270.38	1271.31	1269.69	1270.85	6224.0
2008-06-17 07:00:00	ES	Futures	1270.85	1272.01	1270.61	1271.78	22253.0
2008-06-17 08:00:00	ES	Futures	1271.78	1275.5	1271.31	1274.57	89385.0
2008-06-17 09:00:00	ES	Futures	1274.57	1275.03	1266.66	1268.76	260283.0
2008-06-17 10:00:00	ES	Futures	1268.76	1270.85	1264.8	1267.83	297360.0
2008-06-17 11:00:00	ES	Futures	1267.59	1269.69	1261.55	1262.48	251835.0
2008-06-17 12:00:00	ES	Futures	1262.48	1264.57	1259.46	1261.55	142616.0
2008-06-17 13:00:00	ES	Futures	1261.32	1265.73	1260.16	1264.11	121559.0
2008-06-17 14:00:00	ES	Futures	1264.11	1264.8	1260.62	1262.48	126342.0
2008-06-17 15:00:00	ES	Futures	1262.48	1263.41	1257.13	1257.6	237150.0
2008-06-17 16:00:00	ES	Futures	1257.6	1258.53	1256.21	1258.3	70839.0
2008-06-17 17:00:00	ES	Futures	1258.06	1258.3	1257.13	1257.37	747.0
2008-06-17 18:00:00	ES	Futures	1257.13	1258.06	1255.97	1256.21	2411.0
2008-06-17 19:00:00	ES	Futures	1256.21	1257.37	1255.97	1257.37	955.0
2008-06-17 20:00:00	ES	Futures	1257.37	1257.83	1256.44	1257.6	1233.0
2008-06-17 21:00:00	ES	Futures	1257.83	1258.3	1257.37	1257.6	689.0
2008-06-17 22:00:00	ES	Futures	1257.83	1258.3	1257.13	1257.37	849.0
2008-06-17 23:00:00	ES	Futures	1257.13	1258.76	1257.13	1258.3	1132.0
2008-06-17 00:00:00	NQ	Futures	2236.53	2239.06	2236.25	2238.21	66.0
2008-06-17 01:00:00	NQ	Futures	2237.37	2237.93	2236.25	2237.93	51.0
2008-06-17 02:00:00	NQ	Futures	2238.21	2243.0	2238.21	2242.43	241.0
2008-06-17 03:00:00	NQ	Futures	2242.72	2245.25	2241.87	2242.72	1704.0
2008-06-17 04:00:00	NQ	Futures	2242.72	2247.5	2242.72	2246.93	1010.0
2008-06-17 05:00:00	NQ	Futures	2246.09	2248.62	2243.84	2248.06	810.0
2008-06-17 06:00:00	NQ	Futures	2247.78	2249.19	2247.22	2248.62	332.0
2008-06-17 07:00:00	NQ	Futures	2248.9	2250.03	2247.78	2249.19	2192.0
2008-06-17 08:00:00	NQ	Futures	2249.19	2256.78	2248.34	2254.53	10372.0
2008-06-17 09:00:00	NQ	Futures	2254.53	2254.81	2233.71	2243.56	55331.0
2008-06-17 10:00:00	NQ	Futures	2243.56	2253.4	2237.93	2250.87	68098.0
2008-06-17 11:00:00	NQ	Futures	2250.59	2254.81	2238.5	2240.75	53747.0
2008-06-17 12:00:00	NQ	Futures	2240.75	2245.25	2234.0	2237.65	30566.0
2008-06-17 13:00:00	NQ	Futures	2237.65	2245.81	2235.12	2244.12	25429.0
2008-06-17 14:00:00	NQ	Futures	2244.4	2247.22	2238.21	2241.31	22334.0
2008-06-17 15:00:00	NQ	Futures	2241.31	2242.72	2227.24	2230.9	56912.0
2008-06-17 16:00:00	NQ	Futures	2230.9	2235.4	2228.09	2234.0	15614.0
2008-06-17 17:00:00	NQ	Futures	2233.43	2233.43	2232.03	2232.03	71.0
2008-06-17 18:00:00	NQ	Futures	2232.03	2234.56	2231.75	2232.87	72.0
2008-06-17 19:00:00	NQ	Futures	2231.75	2233.15	2231.46	2232.59	65.0
2008-06-17 20:00:00	NQ	Futures	2232.59	2234.28	2232.03	2234.28	37.0
2008-06-17 21:00:00	NQ	Futures	2234.56	2234.56	2233.43	2233.43	62.0
2008-06-17 22:00:00	NQ	Futures	2233.71	2234.0	2232.31	2232.87	25.0
2008-06-17 23:00:00	NQ	Futures	2233.15	2234.84	2233.15	2234.28	87.0
2008-06-17 00:00:00	YM	Futures	11138.3	11152.8	11133.7	11144.6	116.0
2008-06-17 01:00:00	YM	Futures	11144.6	11145.5	11138.3	11145.5	70.0

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

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