PREVIEW / futures_30min / 2011-08-02

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-08-02.parquet
  size:    82 KB
  rows:    2,768

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
2011-08-02 00:00:00	ES	Futures	1273.46	1273.96	1272.72	1273.22	1046.0
2011-08-02 00:30:00	ES	Futures	1273.22	1273.46	1272.22	1272.47	2659.0
2011-08-02 01:00:00	ES	Futures	1272.47	1272.97	1269.97	1271.72	4719.0
2011-08-02 01:30:00	ES	Futures	1271.47	1273.46	1271.22	1272.97	2683.0
2011-08-02 02:00:00	ES	Futures	1272.97	1274.46	1271.72	1273.96	9498.0
2011-08-02 02:30:00	ES	Futures	1273.96	1273.96	1269.97	1270.22	14197.0
2011-08-02 03:00:00	ES	Futures	1270.22	1273.71	1267.48	1269.22	46297.0
2011-08-02 03:30:00	ES	Futures	1269.22	1270.72	1268.48	1269.72	23116.0
2011-08-02 04:00:00	ES	Futures	1269.72	1272.47	1269.47	1271.22	18037.0
2011-08-02 04:30:00	ES	Futures	1271.22	1271.72	1268.98	1269.72	12664.0
2011-08-02 05:00:00	ES	Futures	1269.47	1271.47	1267.73	1268.23	11985.0
2011-08-02 05:30:00	ES	Futures	1268.23	1271.22	1267.98	1269.22	16342.0
2011-08-02 06:00:00	ES	Futures	1269.22	1272.97	1268.73	1271.97	18189.0
2011-08-02 06:30:00	ES	Futures	1272.22	1272.72	1269.47	1270.97	13563.0
2011-08-02 07:00:00	ES	Futures	1270.97	1271.97	1268.23	1269.47	13798.0
2011-08-02 07:30:00	ES	Futures	1269.22	1270.47	1267.23	1269.72	37150.0
2011-08-02 08:00:00	ES	Futures	1269.97	1270.22	1262.99	1265.23	63593.0
2011-08-02 08:30:00	ES	Futures	1265.23	1271.47	1263.49	1270.72	76895.0
2011-08-02 09:00:00	ES	Futures	1270.97	1270.97	1267.98	1269.97	53337.0
2011-08-02 09:30:00	ES	Futures	1270.22	1276.21	1269.97	1275.46	261939.0
2011-08-02 10:00:00	ES	Futures	1275.46	1276.96	1270.47	1271.22	218141.0
2011-08-02 10:30:00	ES	Futures	1271.22	1273.46	1267.98	1268.73	183670.0
2011-08-02 11:00:00	ES	Futures	1268.48	1269.22	1264.24	1266.23	253628.0
2011-08-02 11:30:00	ES	Futures	1266.23	1267.73	1264.24	1265.73	145725.0
2011-08-02 12:00:00	ES	Futures	1265.73	1268.48	1263.99	1267.48	93601.0
2011-08-02 12:30:00	ES	Futures	1267.48	1267.73	1258.25	1260.0	233083.0
2011-08-02 13:00:00	ES	Futures	1260.0	1264.49	1260.0	1262.24	127946.0
2011-08-02 13:30:00	ES	Futures	1262.49	1262.99	1255.01	1256.01	182301.0
2011-08-02 14:00:00	ES	Futures	1256.01	1261.49	1255.76	1258.75	124164.0
2011-08-02 14:30:00	ES	Futures	1258.75	1261.24	1255.51	1260.5	107469.0
2011-08-02 15:00:00	ES	Futures	1260.5	1261.49	1253.26	1254.51	185108.0
2011-08-02 15:30:00	ES	Futures	1254.51	1255.76	1246.78	1246.78	482073.0
2011-08-02 16:00:00	ES	Futures	1247.03	1247.78	1243.79	1244.53	193983.0
2011-08-02 16:30:00	ES	Futures	1245.28	1245.78	1242.54	1243.29	16777.0
2011-08-02 17:00:00	ES	Futures	1243.29	1244.53	1242.29	1242.54	6313.0
2011-08-02 18:00:00	ES	Futures	1243.29	1244.53	1241.29	1243.29	9087.0
2011-08-02 18:30:00	ES	Futures	1243.29	1243.79	1242.29	1242.79	3547.0
2011-08-02 19:00:00	ES	Futures	1242.79	1244.28	1242.54	1243.79	2941.0
2011-08-02 19:30:00	ES	Futures	1243.79	1244.28	1242.79	1243.04	2829.0
2011-08-02 20:00:00	ES	Futures	1243.04	1244.28	1242.79	1244.03	4352.0
2011-08-02 20:30:00	ES	Futures	1244.28	1245.03	1243.54	1243.79	3647.0
2011-08-02 21:00:00	ES	Futures	1243.54	1244.78	1243.29	1243.54	4557.0
2011-08-02 21:30:00	ES	Futures	1243.54	1244.28	1242.29	1244.03	7648.0
2011-08-02 22:00:00	ES	Futures	1244.28	1245.28	1243.54	1244.78	3646.0
2011-08-02 22:30:00	ES	Futures	1244.78	1245.28	1244.03	1245.28	1982.0
2011-08-02 23:00:00	ES	Futures	1245.03	1245.78	1244.28	1245.28	3230.0
2011-08-02 23:30:00	ES	Futures	1245.53	1246.28	1245.28	1245.53	3507.0
2011-08-02 00:00:00	NQ	Futures	2690.89	2692.04	2689.45	2689.74	150.0
2011-08-02 00:30:00	NQ	Futures	2690.03	2690.61	2688.3	2688.3	136.0
2011-08-02 01:00:00	NQ	Futures	2688.88	2690.03	2684.56	2688.02	345.0

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

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