PREVIEW / futures_1hour / 2010-05-03

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-05-03.parquet
  size:    42 KB
  rows:    1,277

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-03 00:00:00	ES	Futures	1158.09	1159.07	1157.36	1158.82	2827.0
2010-05-03 01:00:00	ES	Futures	1159.07	1160.05	1158.09	1158.58	3660.0
2010-05-03 02:00:00	ES	Futures	1158.34	1161.76	1158.34	1161.76	12246.0
2010-05-03 03:00:00	ES	Futures	1161.76	1162.0	1157.85	1160.78	24150.0
2010-05-03 04:00:00	ES	Futures	1160.78	1161.76	1159.8	1160.54	19008.0
2010-05-03 05:00:00	ES	Futures	1160.54	1161.02	1158.09	1159.07	14417.0
2010-05-03 06:00:00	ES	Futures	1159.07	1162.0	1158.58	1161.76	10308.0
2010-05-03 07:00:00	ES	Futures	1161.76	1163.22	1161.27	1162.0	17403.0
2010-05-03 08:00:00	ES	Futures	1162.0	1163.47	1161.27	1162.25	29698.0
2010-05-03 09:00:00	ES	Futures	1162.0	1165.67	1161.51	1165.18	183187.0
2010-05-03 10:00:00	ES	Futures	1165.18	1166.65	1160.54	1162.0	302705.0
2010-05-03 11:00:00	ES	Futures	1161.76	1167.14	1161.51	1166.16	165280.0
2010-05-03 12:00:00	ES	Futures	1166.4	1173.98	1165.42	1173.98	275346.0
2010-05-03 13:00:00	ES	Futures	1173.73	1175.2	1171.54	1173.73	159309.0
2010-05-03 14:00:00	ES	Futures	1173.73	1175.2	1172.27	1174.47	135308.0
2010-05-03 15:00:00	ES	Futures	1174.71	1175.2	1170.31	1172.27	301351.0
2010-05-03 16:00:00	ES	Futures	1172.02	1172.76	1169.82	1171.05	104052.0
2010-05-03 17:00:00	ES	Futures	1171.05	1171.54	1170.56	1171.29	1261.0
2010-05-03 18:00:00	ES	Futures	1171.05	1171.78	1170.56	1171.54	2767.0
2010-05-03 19:00:00	ES	Futures	1171.29	1172.02	1170.8	1171.05	1705.0
2010-05-03 20:00:00	ES	Futures	1171.29	1173.0	1171.05	1172.76	3445.0
2010-05-03 21:00:00	ES	Futures	1172.51	1173.0	1171.54	1171.78	2698.0
2010-05-03 22:00:00	ES	Futures	1171.78	1171.78	1170.07	1170.31	3973.0
2010-05-03 23:00:00	ES	Futures	1170.56	1170.8	1170.31	1170.8	1041.0
2010-05-03 00:00:00	NQ	Futures	2293.27	2294.99	2292.99	2294.99	146.0
2010-05-03 01:00:00	NQ	Futures	2295.28	2295.85	2292.7	2292.99	458.0
2010-05-03 02:00:00	NQ	Futures	2293.56	2296.71	2293.56	2295.85	1432.0
2010-05-03 03:00:00	NQ	Futures	2296.14	2296.42	2290.12	2295.56	1724.0
2010-05-03 04:00:00	NQ	Futures	2295.28	2297.57	2293.27	2296.14	790.0
2010-05-03 05:00:00	NQ	Futures	2296.14	2296.14	2292.13	2293.56	555.0
2010-05-03 06:00:00	NQ	Futures	2293.27	2298.71	2292.7	2298.71	619.0
2010-05-03 07:00:00	NQ	Futures	2298.43	2301.58	2297.85	2298.43	1156.0
2010-05-03 08:00:00	NQ	Futures	2298.43	2300.72	2297.28	2299.29	3060.0
2010-05-03 09:00:00	NQ	Futures	2299.29	2307.3	2297.85	2305.01	27590.0
2010-05-03 10:00:00	NQ	Futures	2304.73	2314.46	2301.29	2308.45	40749.0
2010-05-03 11:00:00	NQ	Futures	2308.45	2321.34	2305.87	2319.9	31214.0
2010-05-03 12:00:00	NQ	Futures	2319.9	2333.94	2317.9	2333.65	40757.0
2010-05-03 13:00:00	NQ	Futures	2333.94	2334.51	2328.21	2332.5	25556.0
2010-05-03 14:00:00	NQ	Futures	2332.22	2332.79	2327.35	2329.64	25902.0
2010-05-03 15:00:00	NQ	Futures	2329.93	2330.5	2321.34	2321.91	41407.0
2010-05-03 16:00:00	NQ	Futures	2322.2	2323.63	2318.19	2319.62	11175.0
2010-05-03 17:00:00	NQ	Futures	2319.62	2320.19	2318.76	2320.19	378.0
2010-05-03 18:00:00	NQ	Futures	2319.33	2321.62	2319.05	2321.62	172.0
2010-05-03 19:00:00	NQ	Futures	2321.62	2321.91	2319.33	2320.48	167.0
2010-05-03 20:00:00	NQ	Futures	2320.48	2323.63	2318.47	2322.77	460.0
2010-05-03 21:00:00	NQ	Futures	2323.34	2323.34	2320.48	2320.76	154.0
2010-05-03 22:00:00	NQ	Futures	2320.76	2321.05	2318.19	2318.47	174.0
2010-05-03 23:00:00	NQ	Futures	2318.76	2319.33	2318.47	2319.33	100.0
2010-05-03 00:00:00	YM	Futures	10325.4	10331.0	10322.5	10330.1	209.0
2010-05-03 01:00:00	YM	Futures	10331.0	10338.5	10324.4	10325.4	272.0

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

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