PREVIEW / futures_30min / 2010-04-23

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-04-23.parquet
  size:    61 KB
  rows:    2,065

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-23 00:00:00	ES	Futures	1173.0	1173.98	1172.76	1173.73	2567.0
2010-04-23 00:30:00	ES	Futures	1173.98	1174.22	1173.49	1173.98	1209.0
2010-04-23 01:00:00	ES	Futures	1173.73	1174.47	1173.73	1174.47	1101.0
2010-04-23 01:30:00	ES	Futures	1174.22	1174.71	1173.98	1174.22	1119.0
2010-04-23 02:00:00	ES	Futures	1174.22	1174.96	1172.76	1173.25	6859.0
2010-04-23 02:30:00	ES	Futures	1173.0	1173.73	1172.02	1172.27	7410.0
2010-04-23 03:00:00	ES	Futures	1172.27	1172.76	1170.8	1172.51	23826.0
2010-04-23 03:30:00	ES	Futures	1172.51	1174.47	1172.51	1174.47	12525.0
2010-04-23 04:00:00	ES	Futures	1174.71	1176.18	1174.47	1175.69	13292.0
2010-04-23 04:30:00	ES	Futures	1175.69	1180.09	1175.2	1179.36	27814.0
2010-04-23 05:00:00	ES	Futures	1179.36	1179.85	1178.13	1179.36	15393.0
2010-04-23 05:30:00	ES	Futures	1179.36	1179.6	1177.4	1177.89	13427.0
2010-04-23 06:00:00	ES	Futures	1177.89	1179.11	1175.93	1178.38	14444.0
2010-04-23 06:30:00	ES	Futures	1178.38	1178.62	1176.91	1178.13	5851.0
2010-04-23 07:00:00	ES	Futures	1178.13	1179.85	1177.89	1178.62	9571.0
2010-04-23 07:30:00	ES	Futures	1178.62	1179.6	1178.13	1179.36	12232.0
2010-04-23 08:00:00	ES	Futures	1179.36	1180.09	1178.62	1179.36	23317.0
2010-04-23 08:30:00	ES	Futures	1179.11	1180.09	1176.67	1177.16	64663.0
2010-04-23 09:00:00	ES	Futures	1177.4	1178.62	1177.16	1177.65	27233.0
2010-04-23 09:30:00	ES	Futures	1177.65	1178.38	1174.47	1177.65	215931.0
2010-04-23 10:00:00	ES	Futures	1177.65	1183.27	1177.65	1179.6	242469.0
2010-04-23 10:30:00	ES	Futures	1179.36	1180.82	1176.91	1178.13	176336.0
2010-04-23 11:00:00	ES	Futures	1178.13	1179.6	1175.69	1176.91	143127.0
2010-04-23 11:30:00	ES	Futures	1176.91	1177.65	1174.71	1177.16	81049.0
2010-04-23 12:00:00	ES	Futures	1177.16	1178.87	1177.16	1178.38	54738.0
2010-04-23 12:30:00	ES	Futures	1178.62	1180.82	1177.89	1180.58	40502.0
2010-04-23 13:00:00	ES	Futures	1180.58	1181.56	1179.6	1180.09	59647.0
2010-04-23 13:30:00	ES	Futures	1180.33	1181.31	1179.36	1181.07	47031.0
2010-04-23 14:00:00	ES	Futures	1181.07	1182.29	1180.33	1181.8	41221.0
2010-04-23 14:30:00	ES	Futures	1181.56	1184.49	1180.82	1184.0	93604.0
2010-04-23 15:00:00	ES	Futures	1184.25	1185.22	1183.02	1184.0	70209.0
2010-04-23 15:30:00	ES	Futures	1184.25	1186.69	1183.51	1186.2	153000.0
2010-04-23 16:00:00	ES	Futures	1186.2	1186.45	1184.73	1185.71	103807.0
2010-04-23 00:00:00	NQ	Futures	2327.06	2328.78	2326.2	2328.78	113.0
2010-04-23 00:30:00	NQ	Futures	2328.78	2329.64	2328.21	2329.07	75.0
2010-04-23 01:00:00	NQ	Futures	2329.07	2329.64	2328.78	2329.64	81.0
2010-04-23 01:30:00	NQ	Futures	2329.64	2330.21	2329.35	2329.93	107.0
2010-04-23 02:00:00	NQ	Futures	2329.64	2330.21	2328.21	2328.5	288.0
2010-04-23 02:30:00	NQ	Futures	2328.78	2329.07	2327.06	2327.06	366.0
2010-04-23 03:00:00	NQ	Futures	2327.06	2327.92	2324.49	2326.78	1415.0
2010-04-23 03:30:00	NQ	Futures	2326.78	2330.21	2326.78	2329.93	905.0
2010-04-23 04:00:00	NQ	Futures	2329.93	2333.36	2329.35	2333.36	1578.0
2010-04-23 04:30:00	NQ	Futures	2333.08	2338.8	2333.08	2337.66	1899.0
2010-04-23 05:00:00	NQ	Futures	2337.66	2338.52	2335.37	2337.66	729.0
2010-04-23 05:30:00	NQ	Futures	2337.66	2337.95	2334.51	2336.8	894.0
2010-04-23 06:00:00	NQ	Futures	2336.8	2338.23	2334.51	2336.51	972.0
2010-04-23 06:30:00	NQ	Futures	2336.51	2336.8	2334.51	2335.37	398.0
2010-04-23 07:00:00	NQ	Futures	2335.37	2337.66	2335.37	2336.8	813.0
2010-04-23 07:30:00	NQ	Futures	2336.51	2338.8	2335.65	2338.52	710.0
2010-04-23 08:00:00	NQ	Futures	2338.52	2344.53	2338.23	2343.1	4166.0

> showing 50 of 2,065 rows — these rows as CSV

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