PREVIEW / futures_1hour / 2010-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-21.parquet
  size:    45 KB
  rows:    1,387

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-04-21 00:00:00	ES	Futures	1181.31	1182.29	1181.07	1182.05	2011.0
2010-04-21 01:00:00	ES	Futures	1182.05	1182.53	1181.8	1181.8	3189.0
2010-04-21 02:00:00	ES	Futures	1182.05	1182.05	1180.82	1181.07	9837.0
2010-04-21 03:00:00	ES	Futures	1180.82	1181.07	1178.87	1179.36	23398.0
2010-04-21 04:00:00	ES	Futures	1179.36	1180.09	1178.62	1178.87	11543.0
2010-04-21 05:00:00	ES	Futures	1178.87	1179.36	1178.38	1178.87	10917.0
2010-04-21 06:00:00	ES	Futures	1178.87	1179.11	1175.69	1176.18	38647.0
2010-04-21 07:00:00	ES	Futures	1175.93	1177.16	1174.96	1176.91	36893.0
2010-04-21 08:00:00	ES	Futures	1176.67	1178.13	1175.93	1177.16	66097.0
2010-04-21 09:00:00	ES	Futures	1177.16	1180.58	1176.67	1180.09	219809.0
2010-04-21 10:00:00	ES	Futures	1180.33	1180.33	1175.45	1176.42	308914.0
2010-04-21 11:00:00	ES	Futures	1176.18	1177.4	1171.54	1174.96	314251.0
2010-04-21 12:00:00	ES	Futures	1175.2	1178.13	1174.47	1175.69	157709.0
2010-04-21 13:00:00	ES	Futures	1175.93	1176.91	1173.98	1176.67	133977.0
2010-04-21 14:00:00	ES	Futures	1176.67	1176.67	1168.36	1171.54	319340.0
2010-04-21 15:00:00	ES	Futures	1171.54	1176.18	1171.29	1174.96	335997.0
2010-04-21 16:00:00	ES	Futures	1174.96	1175.2	1169.58	1170.8	112005.0
2010-04-21 17:00:00	ES	Futures	1170.8	1171.29	1170.31	1170.56	2956.0
2010-04-21 18:00:00	ES	Futures	1170.8	1171.29	1170.56	1171.05	1841.0
2010-04-21 19:00:00	ES	Futures	1171.05	1171.54	1170.31	1171.54	3365.0
2010-04-21 20:00:00	ES	Futures	1171.54	1171.78	1169.58	1170.8	4973.0
2010-04-21 21:00:00	ES	Futures	1170.8	1171.05	1169.09	1170.07	4609.0
2010-04-21 22:00:00	ES	Futures	1170.31	1170.31	1169.34	1170.07	4250.0
2010-04-21 23:00:00	ES	Futures	1170.31	1170.56	1169.82	1170.56	3998.0
2010-04-21 00:00:00	NQ	Futures	2334.8	2335.65	2334.22	2335.37	99.0
2010-04-21 01:00:00	NQ	Futures	2335.08	2335.94	2334.51	2334.51	146.0
2010-04-21 02:00:00	NQ	Futures	2334.51	2334.51	2331.93	2331.93	814.0
2010-04-21 03:00:00	NQ	Futures	2332.22	2332.5	2328.78	2329.64	1776.0
2010-04-21 04:00:00	NQ	Futures	2329.64	2331.36	2328.5	2329.07	728.0
2010-04-21 05:00:00	NQ	Futures	2329.07	2329.93	2328.5	2329.64	670.0
2010-04-21 06:00:00	NQ	Futures	2329.35	2329.35	2324.77	2325.06	1941.0
2010-04-21 07:00:00	NQ	Futures	2325.06	2326.78	2323.34	2326.78	2738.0
2010-04-21 08:00:00	NQ	Futures	2326.78	2329.93	2324.2	2329.64	6657.0
2010-04-21 09:00:00	NQ	Futures	2329.64	2334.51	2325.92	2332.22	44207.0
2010-04-21 10:00:00	NQ	Futures	2331.93	2332.5	2319.05	2321.91	62254.0
2010-04-21 11:00:00	NQ	Futures	2322.2	2323.34	2313.03	2320.19	38642.0
2010-04-21 12:00:00	NQ	Futures	2320.48	2326.78	2319.05	2323.34	21443.0
2010-04-21 13:00:00	NQ	Futures	2323.34	2326.78	2319.9	2326.2	17130.0
2010-04-21 14:00:00	NQ	Futures	2326.2	2326.49	2314.75	2321.05	32026.0
2010-04-21 15:00:00	NQ	Futures	2321.05	2329.64	2320.76	2327.06	41157.0
2010-04-21 16:00:00	NQ	Futures	2326.78	2328.78	2311.03	2313.6	14388.0
2010-04-21 17:00:00	NQ	Futures	2313.32	2314.18	2313.32	2313.32	637.0
2010-04-21 18:00:00	NQ	Futures	2313.89	2314.46	2313.6	2313.89	223.0
2010-04-21 19:00:00	NQ	Futures	2314.18	2315.61	2313.89	2315.61	238.0
2010-04-21 20:00:00	NQ	Futures	2315.32	2315.32	2312.75	2313.89	538.0
2010-04-21 21:00:00	NQ	Futures	2313.89	2314.18	2312.17	2314.18	527.0
2010-04-21 22:00:00	NQ	Futures	2313.89	2314.46	2313.32	2313.6	376.0
2010-04-21 23:00:00	NQ	Futures	2313.6	2315.04	2313.6	2315.04	205.0
2010-04-21 00:00:00	YM	Futures	10434.5	10440.2	10433.6	10439.2	125.0
2010-04-21 01:00:00	YM	Futures	10440.2	10441.1	10435.5	10436.4	271.0

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

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