PREVIEW / futures_1hour / 2011-10-07

all futures 1-hour files

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

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-07 00:00:00	ES	Futures	1162.77	1162.77	1160.76	1161.01	3572.0
2011-10-07 01:00:00	ES	Futures	1160.76	1161.51	1158.5	1159.25	6301.0
2011-10-07 02:00:00	ES	Futures	1159.25	1163.27	1158.5	1160.76	17589.0
2011-10-07 03:00:00	ES	Futures	1160.76	1163.27	1158.25	1162.51	38741.0
2011-10-07 04:00:00	ES	Futures	1162.51	1163.77	1156.75	1157.25	31031.0
2011-10-07 05:00:00	ES	Futures	1157.5	1159.76	1155.99	1159.0	23947.0
2011-10-07 06:00:00	ES	Futures	1159.25	1160.01	1157.0	1158.25	15948.0
2011-10-07 07:00:00	ES	Futures	1158.5	1160.76	1155.99	1157.25	44913.0
2011-10-07 08:00:00	ES	Futures	1157.25	1177.31	1157.0	1171.54	250269.0
2011-10-07 09:00:00	ES	Futures	1171.54	1172.29	1161.01	1166.02	360625.0
2011-10-07 10:00:00	ES	Futures	1166.02	1170.04	1161.51	1162.01	398778.0
2011-10-07 11:00:00	ES	Futures	1162.01	1163.27	1156.5	1163.02	311611.0
2011-10-07 12:00:00	ES	Futures	1163.02	1164.02	1149.98	1151.23	462662.0
2011-10-07 13:00:00	ES	Futures	1151.23	1154.99	1148.22	1153.74	190532.0
2011-10-07 14:00:00	ES	Futures	1153.99	1159.76	1152.23	1158.0	174913.0
2011-10-07 15:00:00	ES	Futures	1158.0	1168.03	1152.23	1154.74	400506.0
2011-10-07 16:00:00	ES	Futures	1154.74	1160.26	1153.74	1159.25	93292.0
2011-10-07 00:00:00	NQ	Futures	2547.62	2547.62	2544.16	2544.16	176.0
2011-10-07 01:00:00	NQ	Futures	2544.16	2545.31	2539.54	2540.99	391.0
2011-10-07 02:00:00	NQ	Futures	2540.99	2549.35	2539.83	2544.16	1043.0
2011-10-07 03:00:00	NQ	Futures	2544.16	2549.06	2538.97	2547.62	3452.0
2011-10-07 04:00:00	NQ	Futures	2547.62	2550.21	2533.2	2534.07	3185.0
2011-10-07 05:00:00	NQ	Futures	2534.07	2539.26	2530.89	2537.81	1963.0
2011-10-07 06:00:00	NQ	Futures	2537.81	2539.26	2534.35	2537.24	1575.0
2011-10-07 07:00:00	NQ	Futures	2537.53	2542.43	2531.47	2533.78	5245.0
2011-10-07 08:00:00	NQ	Futures	2534.07	2568.38	2533.2	2558.86	24287.0
2011-10-07 09:00:00	NQ	Futures	2558.86	2560.3	2536.08	2547.33	45603.0
2011-10-07 10:00:00	NQ	Futures	2547.33	2554.54	2536.95	2538.97	50326.0
2011-10-07 11:00:00	NQ	Futures	2538.68	2541.56	2518.5	2541.27	55458.0
2011-10-07 12:00:00	NQ	Futures	2541.56	2543.87	2519.36	2524.84	51578.0
2011-10-07 13:00:00	NQ	Futures	2524.55	2538.68	2520.52	2536.66	28154.0
2011-10-07 14:00:00	NQ	Futures	2536.95	2546.46	2532.34	2541.27	25576.0
2011-10-07 15:00:00	NQ	Futures	2541.27	2562.9	2530.03	2534.35	44124.0
2011-10-07 16:00:00	NQ	Futures	2534.35	2544.16	2532.62	2542.43	8704.0
2011-10-07 00:00:00	YM	Futures	10885.3	10886.3	10867.6	10871.5	296.0
2011-10-07 01:00:00	YM	Futures	10871.5	10876.4	10850.8	10859.7	503.0
2011-10-07 02:00:00	YM	Futures	10858.7	10892.2	10853.8	10869.5	1413.0
2011-10-07 03:00:00	YM	Futures	10870.5	10890.2	10853.8	10883.3	1969.0
2011-10-07 04:00:00	YM	Futures	10883.3	10895.1	10840.0	10843.0	1791.0
2011-10-07 05:00:00	YM	Futures	10843.0	10864.6	10833.1	10856.7	995.0
2011-10-07 06:00:00	YM	Futures	10858.7	10863.6	10838.0	10849.9	778.0
2011-10-07 07:00:00	YM	Futures	10851.8	10870.5	10835.1	10843.0	2308.0
2011-10-07 08:00:00	YM	Futures	10843.9	11005.4	10841.0	10968.0	9046.0
2011-10-07 09:00:00	YM	Futures	10969.0	10975.9	10911.9	10959.1	19249.0
2011-10-07 10:00:00	YM	Futures	10959.1	10993.6	10921.7	10932.6	22636.0
2011-10-07 11:00:00	YM	Futures	10931.6	10943.4	10883.3	10943.4	19234.0
2011-10-07 12:00:00	YM	Futures	10943.4	10950.3	10824.3	10838.0	24663.0
2011-10-07 13:00:00	YM	Futures	10836.1	10872.5	10813.4	10862.7	11617.0
2011-10-07 14:00:00	YM	Futures	10863.6	10912.9	10848.9	10902.0	13270.0
2011-10-07 15:00:00	YM	Futures	10899.1	10983.8	10846.9	10874.5	18382.0

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

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