PREVIEW / futures_30min / 2011-06-03

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-06-03.parquet
  size:    64 KB
  rows:    2,162

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-06-03 00:00:00	ES	Futures	1301.53	1302.27	1301.03	1301.28	1932.0
2011-06-03 00:30:00	ES	Futures	1301.28	1302.77	1300.78	1302.77	3750.0
2011-06-03 01:00:00	ES	Futures	1302.77	1303.76	1302.27	1303.02	4102.0
2011-06-03 01:30:00	ES	Futures	1303.02	1303.02	1301.53	1301.78	2883.0
2011-06-03 02:00:00	ES	Futures	1301.53	1303.27	1301.53	1302.52	3609.0
2011-06-03 02:30:00	ES	Futures	1302.52	1302.77	1301.28	1301.53	4882.0
2011-06-03 03:00:00	ES	Futures	1301.53	1301.78	1299.04	1299.29	19752.0
2011-06-03 03:30:00	ES	Futures	1299.29	1301.28	1299.29	1301.03	11501.0
2011-06-03 04:00:00	ES	Futures	1301.03	1301.78	1300.29	1300.78	9436.0
2011-06-03 04:30:00	ES	Futures	1300.78	1302.27	1300.53	1301.53	8145.0
2011-06-03 05:00:00	ES	Futures	1301.53	1301.78	1300.04	1300.53	9609.0
2011-06-03 05:30:00	ES	Futures	1300.53	1301.28	1299.29	1299.79	8742.0
2011-06-03 06:00:00	ES	Futures	1299.79	1300.04	1298.3	1299.04	10873.0
2011-06-03 06:30:00	ES	Futures	1298.79	1299.29	1297.55	1299.29	15139.0
2011-06-03 07:00:00	ES	Futures	1299.04	1301.03	1299.04	1300.29	11477.0
2011-06-03 07:30:00	ES	Futures	1300.53	1301.03	1299.79	1300.53	11268.0
2011-06-03 08:00:00	ES	Futures	1300.53	1302.77	1299.04	1301.28	36751.0
2011-06-03 08:30:00	ES	Futures	1301.03	1301.53	1286.37	1289.11	236159.0
2011-06-03 09:00:00	ES	Futures	1288.86	1289.6	1286.87	1288.11	65076.0
2011-06-03 09:30:00	ES	Futures	1287.86	1292.83	1287.37	1291.84	309971.0
2011-06-03 10:00:00	ES	Futures	1291.84	1296.06	1291.34	1295.81	308112.0
2011-06-03 10:30:00	ES	Futures	1295.81	1299.29	1295.32	1296.81	253802.0
2011-06-03 11:00:00	ES	Futures	1296.81	1298.05	1293.58	1294.07	175162.0
2011-06-03 11:30:00	ES	Futures	1294.32	1296.56	1292.83	1296.31	125507.0
2011-06-03 12:00:00	ES	Futures	1296.56	1298.79	1295.32	1298.05	85946.0
2011-06-03 12:30:00	ES	Futures	1298.05	1300.78	1297.3	1298.55	100762.0
2011-06-03 13:00:00	ES	Futures	1298.79	1299.29	1296.56	1296.81	51438.0
2011-06-03 13:30:00	ES	Futures	1296.81	1298.55	1295.81	1296.06	48270.0
2011-06-03 14:00:00	ES	Futures	1295.81	1296.31	1294.32	1295.07	66893.0
2011-06-03 14:30:00	ES	Futures	1295.07	1295.32	1292.34	1292.83	88473.0
2011-06-03 15:00:00	ES	Futures	1292.58	1292.83	1289.11	1290.85	140736.0
2011-06-03 15:30:00	ES	Futures	1290.6	1294.57	1289.11	1290.85	261574.0
2011-06-03 16:00:00	ES	Futures	1290.6	1290.85	1287.37	1287.62	129540.0
2011-06-03 00:00:00	NQ	Futures	2668.87	2670.3	2668.58	2668.87	87.0
2011-06-03 00:30:00	NQ	Futures	2668.87	2671.17	2668.29	2670.3	173.0
2011-06-03 01:00:00	NQ	Futures	2670.3	2672.31	2670.02	2671.74	188.0
2011-06-03 01:30:00	NQ	Futures	2671.17	2671.17	2667.43	2668.01	195.0
2011-06-03 02:00:00	NQ	Futures	2668.29	2671.17	2668.01	2669.15	314.0
2011-06-03 02:30:00	NQ	Futures	2669.15	2670.3	2667.72	2668.29	172.0
2011-06-03 03:00:00	NQ	Futures	2668.29	2668.58	2663.12	2663.41	1480.0
2011-06-03 03:30:00	NQ	Futures	2663.41	2667.14	2663.12	2666.57	1199.0
2011-06-03 04:00:00	NQ	Futures	2666.28	2667.72	2665.13	2665.99	927.0
2011-06-03 04:30:00	NQ	Futures	2665.99	2668.58	2665.99	2667.72	528.0
2011-06-03 05:00:00	NQ	Futures	2667.43	2667.43	2664.84	2665.42	541.0
2011-06-03 05:30:00	NQ	Futures	2665.71	2666.86	2662.55	2663.98	621.0
2011-06-03 06:00:00	NQ	Futures	2663.7	2664.27	2660.25	2661.97	1374.0
2011-06-03 06:30:00	NQ	Futures	2661.97	2662.26	2658.52	2661.11	1026.0
2011-06-03 07:00:00	NQ	Futures	2661.11	2665.13	2661.11	2663.7	1230.0
2011-06-03 07:30:00	NQ	Futures	2663.98	2665.42	2663.12	2664.84	1079.0
2011-06-03 08:00:00	NQ	Futures	2664.84	2670.59	2661.11	2668.29	3912.0

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

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