PREVIEW / futures_1hour / 2011-07-04

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-07-04.parquet
  size:    32 KB
  rows:    951

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-04 00:00:00	ES	Futures	1330.83	1331.08	1329.58	1330.58	2664.0
2011-07-04 01:00:00	ES	Futures	1330.58	1330.83	1325.09	1327.09	16298.0
2011-07-04 02:00:00	ES	Futures	1327.09	1329.83	1326.84	1328.08	11595.0
2011-07-04 03:00:00	ES	Futures	1328.33	1328.33	1326.84	1327.34	13680.0
2011-07-04 04:00:00	ES	Futures	1327.34	1329.83	1327.09	1329.08	9881.0
2011-07-04 05:00:00	ES	Futures	1329.33	1329.83	1328.33	1329.08	4898.0
2011-07-04 06:00:00	ES	Futures	1329.08	1329.33	1327.59	1328.58	6081.0
2011-07-04 07:00:00	ES	Futures	1328.83	1328.83	1327.09	1327.34	6790.0
2011-07-04 08:00:00	ES	Futures	1327.59	1329.33	1327.34	1328.58	7965.0
2011-07-04 09:00:00	ES	Futures	1328.83	1330.08	1328.58	1329.58	10777.0
2011-07-04 10:00:00	ES	Futures	1329.58	1330.83	1329.58	1330.33	10309.0
2011-07-04 11:00:00	ES	Futures	1330.33	1331.33	1330.08	1330.58	6244.0
2011-07-04 18:00:00	ES	Futures	1330.83	1331.58	1330.08	1331.58	4720.0
2011-07-04 19:00:00	ES	Futures	1331.58	1332.32	1331.08	1332.07	3582.0
2011-07-04 20:00:00	ES	Futures	1331.83	1332.82	1330.83	1332.57	6938.0
2011-07-04 21:00:00	ES	Futures	1332.57	1332.82	1329.33	1329.58	9682.0
2011-07-04 22:00:00	ES	Futures	1329.58	1330.83	1328.58	1330.33	7085.0
2011-07-04 23:00:00	ES	Futures	1330.33	1331.83	1330.08	1331.08	3102.0
2011-07-04 00:00:00	NQ	Futures	2714.78	2715.64	2713.05	2715.07	231.0
2011-07-04 01:00:00	NQ	Futures	2714.78	2714.78	2707.01	2708.73	1113.0
2011-07-04 02:00:00	NQ	Futures	2709.31	2714.2	2709.31	2710.17	652.0
2011-07-04 03:00:00	NQ	Futures	2710.17	2711.32	2706.72	2709.6	2274.0
2011-07-04 04:00:00	NQ	Futures	2709.89	2713.34	2709.02	2711.61	1560.0
2011-07-04 05:00:00	NQ	Futures	2711.61	2712.48	2710.17	2710.75	521.0
2011-07-04 06:00:00	NQ	Futures	2711.04	2712.19	2709.89	2711.9	680.0
2011-07-04 07:00:00	NQ	Futures	2711.9	2712.48	2709.02	2709.31	822.0
2011-07-04 08:00:00	NQ	Futures	2709.6	2712.76	2709.31	2712.76	738.0
2011-07-04 09:00:00	NQ	Futures	2713.05	2720.25	2711.61	2719.09	3394.0
2011-07-04 10:00:00	NQ	Futures	2719.09	2721.97	2717.08	2721.68	2693.0
2011-07-04 11:00:00	NQ	Futures	2721.68	2726.0	2720.53	2722.55	2419.0
2011-07-04 18:00:00	NQ	Futures	2723.41	2724.56	2718.23	2721.68	634.0
2011-07-04 19:00:00	NQ	Futures	2721.11	2722.26	2720.53	2721.97	209.0
2011-07-04 20:00:00	NQ	Futures	2721.97	2724.27	2718.81	2722.84	927.0
2011-07-04 21:00:00	NQ	Futures	2722.84	2723.7	2715.93	2716.79	639.0
2011-07-04 22:00:00	NQ	Futures	2716.79	2718.52	2714.78	2717.94	627.0
2011-07-04 23:00:00	NQ	Futures	2717.94	2720.82	2717.66	2720.53	187.0
2011-07-04 00:00:00	YM	Futures	12129.2	12131.1	12122.4	12126.3	79.0
2011-07-04 01:00:00	YM	Futures	12125.3	12126.3	12087.6	12102.1	696.0
2011-07-04 02:00:00	YM	Futures	12103.1	12126.3	12102.1	12112.7	791.0
2011-07-04 03:00:00	YM	Futures	12110.8	12110.8	12096.3	12102.1	1289.0
2011-07-04 04:00:00	YM	Futures	12103.1	12122.4	12101.1	12115.6	648.0
2011-07-04 05:00:00	YM	Futures	12117.6	12122.4	12109.8	12116.6	254.0
2011-07-04 06:00:00	YM	Futures	12117.6	12118.6	12107.9	12115.6	527.0
2011-07-04 07:00:00	YM	Futures	12115.6	12115.6	12105.0	12107.9	390.0
2011-07-04 08:00:00	YM	Futures	12106.0	12118.6	12105.0	12117.6	570.0
2011-07-04 09:00:00	YM	Futures	12117.6	12140.8	12114.7	12129.2	1573.0
2011-07-04 10:00:00	YM	Futures	12129.2	12140.8	12129.2	12138.9	941.0
2011-07-04 11:00:00	YM	Futures	12137.9	12144.7	12136.9	12140.8	472.0
2011-07-04 18:00:00	YM	Futures	12137.9	12140.8	12128.2	12139.9	206.0
2011-07-04 19:00:00	YM	Futures	12138.9	12149.5	12137.9	12148.6	116.0

> showing 50 of 951 rows — these rows as CSV

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