PREVIEW / futures_30min / 2011-07-29

all futures 30-min files

  file:    by_date/futures_30min/2011/2011-07-29.parquet
  size:    65 KB
  rows:    2,149

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-07-29 00:00:00	ES	Futures	1285.44	1286.93	1284.44	1286.68	2016.0
2011-07-29 00:30:00	ES	Futures	1286.93	1286.93	1285.19	1286.18	1798.0
2011-07-29 01:00:00	ES	Futures	1286.18	1286.93	1282.44	1283.19	5109.0
2011-07-29 01:30:00	ES	Futures	1283.19	1285.69	1282.94	1285.69	4681.0
2011-07-29 02:00:00	ES	Futures	1285.69	1288.43	1284.94	1285.19	10900.0
2011-07-29 02:30:00	ES	Futures	1285.44	1287.43	1284.69	1287.18	5509.0
2011-07-29 03:00:00	ES	Futures	1287.18	1288.93	1284.94	1288.68	23466.0
2011-07-29 03:30:00	ES	Futures	1288.68	1291.42	1286.93	1287.18	18694.0
2011-07-29 04:00:00	ES	Futures	1287.43	1289.18	1285.44	1288.93	13125.0
2011-07-29 04:30:00	ES	Futures	1288.93	1290.67	1288.18	1289.93	9674.0
2011-07-29 05:00:00	ES	Futures	1290.17	1290.17	1287.68	1287.68	9244.0
2011-07-29 05:30:00	ES	Futures	1287.93	1290.42	1287.43	1290.17	8375.0
2011-07-29 06:00:00	ES	Futures	1290.42	1290.42	1287.93	1288.68	8602.0
2011-07-29 06:30:00	ES	Futures	1288.43	1288.43	1285.93	1286.68	23873.0
2011-07-29 07:00:00	ES	Futures	1286.43	1289.18	1285.93	1287.68	10825.0
2011-07-29 07:30:00	ES	Futures	1287.68	1288.93	1287.18	1287.43	7547.0
2011-07-29 08:00:00	ES	Futures	1287.68	1288.93	1286.93	1287.43	22767.0
2011-07-29 08:30:00	ES	Futures	1287.43	1287.43	1278.95	1281.94	128607.0
2011-07-29 09:00:00	ES	Futures	1281.7	1282.94	1279.7	1281.2	49354.0
2011-07-29 09:30:00	ES	Futures	1281.45	1285.19	1275.46	1283.19	365765.0
2011-07-29 10:00:00	ES	Futures	1283.44	1286.93	1280.95	1285.19	251055.0
2011-07-29 10:30:00	ES	Futures	1285.19	1293.67	1282.44	1291.42	328961.0
2011-07-29 11:00:00	ES	Futures	1291.42	1297.66	1289.43	1293.17	224732.0
2011-07-29 11:30:00	ES	Futures	1292.92	1294.17	1290.92	1292.67	110925.0
2011-07-29 12:00:00	ES	Futures	1292.67	1293.42	1288.18	1289.18	152410.0
2011-07-29 12:30:00	ES	Futures	1289.18	1291.17	1287.18	1287.68	89195.0
2011-07-29 13:00:00	ES	Futures	1287.43	1290.17	1286.43	1288.93	76061.0
2011-07-29 13:30:00	ES	Futures	1289.18	1292.67	1287.93	1291.67	66507.0
2011-07-29 14:00:00	ES	Futures	1291.92	1293.92	1289.43	1290.17	75001.0
2011-07-29 14:30:00	ES	Futures	1289.93	1293.17	1289.18	1289.93	71338.0
2011-07-29 15:00:00	ES	Futures	1289.93	1291.92	1287.18	1288.43	92390.0
2011-07-29 15:30:00	ES	Futures	1288.43	1289.43	1284.19	1285.19	351270.0
2011-07-29 16:00:00	ES	Futures	1285.19	1291.17	1282.19	1289.43	168292.0
2011-07-29 00:00:00	NQ	Futures	2713.63	2717.66	2713.05	2717.08	84.0
2011-07-29 00:30:00	NQ	Futures	2716.5	2716.79	2713.05	2715.93	99.0
2011-07-29 01:00:00	NQ	Futures	2715.35	2716.5	2704.99	2710.46	443.0
2011-07-29 01:30:00	NQ	Futures	2709.6	2715.07	2708.45	2715.07	660.0
2011-07-29 02:00:00	NQ	Futures	2714.78	2719.96	2713.05	2714.49	598.0
2011-07-29 02:30:00	NQ	Futures	2714.49	2717.37	2712.48	2717.08	584.0
2011-07-29 03:00:00	NQ	Futures	2716.5	2719.67	2712.48	2719.38	2367.0
2011-07-29 03:30:00	NQ	Futures	2719.09	2723.12	2716.79	2717.66	1698.0
2011-07-29 04:00:00	NQ	Futures	2717.37	2721.97	2714.2	2721.4	1136.0
2011-07-29 04:30:00	NQ	Futures	2721.4	2725.14	2720.25	2723.7	1111.0
2011-07-29 05:00:00	NQ	Futures	2723.7	2724.56	2719.09	2719.09	790.0
2011-07-29 05:30:00	NQ	Futures	2718.81	2723.41	2718.81	2723.41	694.0
2011-07-29 06:00:00	NQ	Futures	2722.84	2723.7	2719.09	2720.25	894.0
2011-07-29 06:30:00	NQ	Futures	2720.25	2720.25	2714.78	2716.79	1297.0
2011-07-29 07:00:00	NQ	Futures	2716.5	2720.53	2714.78	2718.23	1026.0
2011-07-29 07:30:00	NQ	Futures	2717.66	2719.09	2715.93	2715.93	697.0
2011-07-29 08:00:00	NQ	Futures	2715.93	2722.55	2715.64	2718.81	2802.0

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

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