PREVIEW / futures_30min / 2010-04-27

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-04-27.parquet
  size:    77 KB
  rows:    2,622

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-27 00:00:00	ES	Futures	1182.53	1182.78	1182.29	1182.78	1181.0
2010-04-27 00:30:00	ES	Futures	1182.78	1183.02	1182.29	1182.29	1438.0
2010-04-27 01:00:00	ES	Futures	1182.29	1182.53	1181.8	1182.29	1587.0
2010-04-27 01:30:00	ES	Futures	1182.29	1182.53	1181.31	1181.31	1390.0
2010-04-27 02:00:00	ES	Futures	1181.31	1182.05	1181.31	1182.05	2915.0
2010-04-27 02:30:00	ES	Futures	1181.8	1182.29	1181.56	1181.56	3991.0
2010-04-27 03:00:00	ES	Futures	1181.8	1182.78	1179.36	1179.36	16371.0
2010-04-27 03:30:00	ES	Futures	1179.36	1180.58	1179.11	1179.85	9374.0
2010-04-27 04:00:00	ES	Futures	1179.85	1180.33	1179.11	1179.85	6769.0
2010-04-27 04:30:00	ES	Futures	1179.85	1181.31	1179.6	1180.33	6373.0
2010-04-27 05:00:00	ES	Futures	1180.58	1181.31	1179.6	1179.6	7683.0
2010-04-27 05:30:00	ES	Futures	1179.6	1179.85	1178.13	1178.13	20007.0
2010-04-27 06:00:00	ES	Futures	1178.13	1178.62	1177.16	1177.16	16807.0
2010-04-27 06:30:00	ES	Futures	1177.4	1177.4	1175.45	1175.93	20712.0
2010-04-27 07:00:00	ES	Futures	1175.93	1177.65	1175.93	1176.42	18662.0
2010-04-27 07:30:00	ES	Futures	1176.42	1178.13	1175.93	1176.42	17084.0
2010-04-27 08:00:00	ES	Futures	1176.18	1177.4	1175.69	1176.18	23681.0
2010-04-27 08:30:00	ES	Futures	1176.18	1176.91	1175.45	1175.93	36527.0
2010-04-27 09:00:00	ES	Futures	1176.18	1176.18	1173.98	1174.96	59674.0
2010-04-27 09:30:00	ES	Futures	1174.96	1178.13	1174.47	1178.13	227698.0
2010-04-27 10:00:00	ES	Futures	1177.89	1179.36	1175.93	1178.87	201685.0
2010-04-27 10:30:00	ES	Futures	1178.87	1181.07	1177.4	1179.11	266083.0
2010-04-27 11:00:00	ES	Futures	1179.11	1179.6	1163.96	1164.69	454698.0
2010-04-27 11:30:00	ES	Futures	1164.94	1164.94	1160.54	1161.27	409874.0
2010-04-27 12:00:00	ES	Futures	1161.51	1163.71	1157.11	1159.8	232817.0
2010-04-27 12:30:00	ES	Futures	1159.8	1163.22	1159.07	1162.98	107397.0
2010-04-27 13:00:00	ES	Futures	1162.98	1167.87	1162.49	1167.87	164550.0
2010-04-27 13:30:00	ES	Futures	1167.87	1168.11	1164.94	1166.16	112501.0
2010-04-27 14:00:00	ES	Futures	1166.16	1166.4	1162.74	1163.47	125342.0
2010-04-27 14:30:00	ES	Futures	1163.71	1163.71	1159.31	1160.29	157157.0
2010-04-27 15:00:00	ES	Futures	1160.29	1164.2	1159.56	1161.51	181253.0
2010-04-27 15:30:00	ES	Futures	1161.51	1161.51	1151.25	1153.45	483214.0
2010-04-27 16:00:00	ES	Futures	1153.45	1156.14	1152.96	1154.67	152886.0
2010-04-27 16:30:00	ES	Futures	1155.16	1155.65	1152.96	1154.91	13786.0
2010-04-27 17:00:00	ES	Futures	1154.91	1155.4	1153.45	1153.69	3158.0
2010-04-27 18:00:00	ES	Futures	1153.94	1154.91	1153.45	1154.18	2823.0
2010-04-27 18:30:00	ES	Futures	1154.43	1154.67	1153.94	1154.43	1935.0
2010-04-27 19:00:00	ES	Futures	1154.67	1154.91	1154.43	1154.67	1184.0
2010-04-27 19:30:00	ES	Futures	1154.67	1156.38	1153.94	1156.38	4077.0
2010-04-27 20:00:00	ES	Futures	1156.14	1156.63	1155.65	1156.14	4555.0
2010-04-27 20:30:00	ES	Futures	1156.14	1156.38	1153.94	1154.91	6756.0
2010-04-27 21:00:00	ES	Futures	1154.91	1155.65	1154.43	1154.91	3096.0
2010-04-27 21:30:00	ES	Futures	1155.16	1156.63	1154.67	1156.38	4504.0
2010-04-27 22:00:00	ES	Futures	1156.63	1156.87	1156.14	1156.63	4390.0
2010-04-27 22:30:00	ES	Futures	1156.38	1157.36	1156.38	1156.63	7893.0
2010-04-27 23:00:00	ES	Futures	1156.38	1157.36	1156.38	1157.36	1584.0
2010-04-27 23:30:00	ES	Futures	1157.11	1157.36	1155.89	1156.87	2200.0
2010-04-27 00:00:00	NQ	Futures	2348.26	2348.54	2348.26	2348.54	32.0
2010-04-27 00:30:00	NQ	Futures	2348.83	2348.83	2348.26	2348.54	52.0
2010-04-27 01:00:00	NQ	Futures	2348.54	2348.54	2347.68	2348.26	63.0

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

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