PREVIEW / futures_1hour / 2011-10-14

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-10-14.parquet
  size:    42 KB
  rows:    1,187

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-10-14 00:00:00	ES	Futures	1199.63	1202.38	1199.38	1201.13	3831.0
2011-10-14 01:00:00	ES	Futures	1200.88	1204.89	1199.63	1204.64	7444.0
2011-10-14 02:00:00	ES	Futures	1204.64	1206.9	1203.64	1204.39	14083.0
2011-10-14 03:00:00	ES	Futures	1204.64	1204.89	1199.12	1203.64	39864.0
2011-10-14 04:00:00	ES	Futures	1203.64	1211.66	1203.39	1209.91	60147.0
2011-10-14 05:00:00	ES	Futures	1209.91	1213.92	1208.65	1212.42	55402.0
2011-10-14 06:00:00	ES	Futures	1212.42	1213.42	1211.16	1211.91	23324.0
2011-10-14 07:00:00	ES	Futures	1211.91	1212.92	1209.16	1212.16	46475.0
2011-10-14 08:00:00	ES	Futures	1212.16	1218.18	1211.91	1214.42	86725.0
2011-10-14 09:00:00	ES	Futures	1214.42	1220.94	1214.42	1218.18	307245.0
2011-10-14 10:00:00	ES	Futures	1218.18	1218.68	1212.42	1215.42	380306.0
2011-10-14 11:00:00	ES	Futures	1215.68	1216.68	1210.66	1211.66	220048.0
2011-10-14 12:00:00	ES	Futures	1211.91	1214.42	1210.41	1213.17	122179.0
2011-10-14 13:00:00	ES	Futures	1213.17	1217.68	1212.92	1217.43	123446.0
2011-10-14 14:00:00	ES	Futures	1217.43	1219.44	1214.67	1219.19	106871.0
2011-10-14 15:00:00	ES	Futures	1219.19	1224.45	1217.18	1223.95	416353.0
2011-10-14 16:00:00	ES	Futures	1223.95	1225.2	1222.45	1223.7	125330.0
2011-10-14 00:00:00	NQ	Futures	2685.15	2691.78	2685.15	2688.9	433.0
2011-10-14 01:00:00	NQ	Futures	2688.61	2697.26	2686.59	2696.1	669.0
2011-10-14 02:00:00	NQ	Futures	2696.39	2700.14	2693.22	2695.24	1900.0
2011-10-14 03:00:00	NQ	Futures	2695.24	2695.82	2680.25	2691.2	4503.0
2011-10-14 04:00:00	NQ	Futures	2691.49	2705.04	2690.63	2702.45	5103.0
2011-10-14 05:00:00	NQ	Futures	2702.45	2708.79	2699.27	2704.75	3918.0
2011-10-14 06:00:00	NQ	Futures	2704.75	2706.77	2702.45	2704.75	2438.0
2011-10-14 07:00:00	NQ	Futures	2704.75	2705.62	2696.68	2701.87	6977.0
2011-10-14 08:00:00	NQ	Futures	2701.87	2715.71	2701.58	2709.08	9653.0
2011-10-14 09:00:00	NQ	Futures	2709.08	2722.34	2708.79	2716.86	53152.0
2011-10-14 10:00:00	NQ	Futures	2716.86	2721.76	2705.62	2712.25	51591.0
2011-10-14 11:00:00	NQ	Futures	2712.54	2716.0	2697.55	2703.31	31076.0
2011-10-14 12:00:00	NQ	Futures	2703.02	2707.92	2699.27	2703.31	17689.0
2011-10-14 13:00:00	NQ	Futures	2703.6	2716.0	2703.02	2714.56	17183.0
2011-10-14 14:00:00	NQ	Futures	2714.56	2720.03	2710.81	2719.75	12733.0
2011-10-14 15:00:00	NQ	Futures	2719.46	2729.26	2715.13	2729.26	40751.0
2011-10-14 16:00:00	NQ	Futures	2729.26	2732.14	2726.67	2730.13	8255.0
2011-10-14 00:00:00	YM	Futures	11205.3	11226.9	11205.3	11218.1	345.0
2011-10-14 01:00:00	YM	Futures	11216.1	11246.6	11209.2	11242.7	487.0
2011-10-14 02:00:00	YM	Futures	11242.7	11261.4	11236.8	11243.7	691.0
2011-10-14 03:00:00	YM	Futures	11245.6	11246.6	11197.4	11239.7	2018.0
2011-10-14 04:00:00	YM	Futures	11240.7	11302.8	11238.8	11289.0	2002.0
2011-10-14 05:00:00	YM	Futures	11288.0	11325.4	11279.1	11311.6	2015.0
2011-10-14 06:00:00	YM	Futures	11312.6	11319.5	11302.8	11305.7	873.0
2011-10-14 07:00:00	YM	Futures	11305.7	11310.6	11286.0	11305.7	1553.0
2011-10-14 08:00:00	YM	Futures	11306.7	11366.7	11303.7	11324.4	2893.0
2011-10-14 09:00:00	YM	Futures	11323.4	11369.7	11322.4	11346.1	16769.0
2011-10-14 10:00:00	YM	Futures	11345.1	11357.9	11310.6	11334.3	17173.0
2011-10-14 11:00:00	YM	Futures	11332.3	11338.2	11284.0	11300.8	11470.0
2011-10-14 12:00:00	YM	Futures	11300.8	11326.4	11290.9	11315.6	7766.0
2011-10-14 13:00:00	YM	Futures	11315.6	11349.0	11314.6	11346.1	7060.0
2011-10-14 14:00:00	YM	Futures	11347.1	11360.8	11322.4	11359.9	6052.0
2011-10-14 15:00:00	YM	Futures	11358.9	11403.2	11343.1	11402.2	15099.0

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

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