PREVIEW / futures_1hour / 2011-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-20.parquet
  size:    40 KB
  rows:    1,152

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-05-20 00:00:00	ES	Futures	1333.33	1333.58	1332.58	1333.08	1625.0
2011-05-20 01:00:00	ES	Futures	1333.08	1333.33	1332.58	1332.83	3794.0
2011-05-20 02:00:00	ES	Futures	1332.83	1333.08	1332.58	1332.58	4260.0
2011-05-20 03:00:00	ES	Futures	1332.58	1334.57	1331.84	1333.82	22102.0
2011-05-20 04:00:00	ES	Futures	1334.07	1335.56	1333.33	1334.57	16149.0
2011-05-20 05:00:00	ES	Futures	1334.57	1335.56	1332.83	1333.33	15639.0
2011-05-20 06:00:00	ES	Futures	1333.08	1333.33	1328.85	1329.6	53538.0
2011-05-20 07:00:00	ES	Futures	1329.6	1330.1	1328.11	1329.6	38385.0
2011-05-20 08:00:00	ES	Futures	1329.6	1331.34	1328.85	1330.84	40429.0
2011-05-20 09:00:00	ES	Futures	1331.09	1331.84	1324.63	1325.63	288542.0
2011-05-20 10:00:00	ES	Futures	1325.38	1325.87	1320.16	1321.9	451674.0
2011-05-20 11:00:00	ES	Futures	1321.9	1326.87	1321.15	1323.89	265435.0
2011-05-20 12:00:00	ES	Futures	1323.89	1330.84	1323.14	1327.86	291894.0
2011-05-20 13:00:00	ES	Futures	1328.11	1331.84	1327.86	1329.6	157103.0
2011-05-20 14:00:00	ES	Futures	1329.6	1330.59	1326.37	1326.62	123509.0
2011-05-20 15:00:00	ES	Futures	1326.62	1327.61	1321.65	1322.89	316238.0
2011-05-20 16:00:00	ES	Futures	1322.64	1323.14	1318.67	1320.16	134433.0
2011-05-20 00:00:00	NQ	Futures	2721.73	2721.73	2720.58	2720.58	46.0
2011-05-20 01:00:00	NQ	Futures	2721.16	2721.45	2719.72	2719.72	160.0
2011-05-20 02:00:00	NQ	Futures	2720.3	2721.16	2719.72	2719.72	177.0
2011-05-20 03:00:00	NQ	Futures	2719.72	2723.46	2718.57	2723.17	1208.0
2011-05-20 04:00:00	NQ	Futures	2722.88	2726.9	2721.73	2724.89	1239.0
2011-05-20 05:00:00	NQ	Futures	2724.89	2726.62	2721.45	2721.73	895.0
2011-05-20 06:00:00	NQ	Futures	2721.73	2722.31	2713.98	2715.7	2711.0
2011-05-20 07:00:00	NQ	Futures	2715.99	2716.27	2711.68	2715.7	3724.0
2011-05-20 08:00:00	NQ	Futures	2715.41	2719.15	2714.55	2718.0	3938.0
2011-05-20 09:00:00	NQ	Futures	2718.29	2721.73	2708.8	2709.95	42683.0
2011-05-20 10:00:00	NQ	Futures	2709.95	2710.53	2697.31	2699.9	51468.0
2011-05-20 11:00:00	NQ	Futures	2699.61	2704.21	2698.46	2700.18	27242.0
2011-05-20 12:00:00	NQ	Futures	2700.18	2716.56	2699.61	2710.53	33279.0
2011-05-20 13:00:00	NQ	Futures	2710.53	2721.16	2710.24	2716.85	20576.0
2011-05-20 14:00:00	NQ	Futures	2716.85	2718.57	2707.37	2707.65	15680.0
2011-05-20 15:00:00	NQ	Futures	2707.37	2709.09	2698.75	2700.47	35546.0
2011-05-20 16:00:00	NQ	Futures	2700.47	2701.62	2691.85	2695.3	15497.0
2011-05-20 00:00:00	YM	Futures	12123.6	12124.6	12119.8	12120.8	32.0
2011-05-20 01:00:00	YM	Futures	12119.8	12122.7	12117.9	12117.9	147.0
2011-05-20 02:00:00	YM	Futures	12117.9	12120.8	12116.9	12117.9	311.0
2011-05-20 03:00:00	YM	Futures	12116.9	12134.2	12110.2	12129.4	1455.0
2011-05-20 04:00:00	YM	Futures	12130.4	12139.1	12125.6	12131.3	933.0
2011-05-20 05:00:00	YM	Futures	12130.4	12139.1	12116.9	12117.9	783.0
2011-05-20 06:00:00	YM	Futures	12117.9	12117.9	12085.1	12090.9	2063.0
2011-05-20 07:00:00	YM	Futures	12090.9	12100.5	12085.1	12097.6	2265.0
2011-05-20 08:00:00	YM	Futures	12097.6	12110.2	12091.9	12105.3	2102.0
2011-05-20 09:00:00	YM	Futures	12107.3	12112.1	12043.7	12052.4	18008.0
2011-05-20 10:00:00	YM	Futures	12052.4	12054.3	12007.1	12020.6	26580.0
2011-05-20 11:00:00	YM	Futures	12020.6	12059.1	12013.8	12030.2	12303.0
2011-05-20 12:00:00	YM	Futures	12029.3	12103.4	12028.3	12082.2	17774.0
2011-05-20 13:00:00	YM	Futures	12083.2	12114.0	12077.4	12095.7	8726.0
2011-05-20 14:00:00	YM	Futures	12095.7	12104.4	12060.1	12061.0	7562.0
2011-05-20 15:00:00	YM	Futures	12061.0	12070.7	12017.7	12031.2	15984.0

> showing 50 of 1,152 rows — these rows as CSV

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