PREVIEW / futures_1hour / 2011-04-01

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-01.parquet
  size:    41 KB
  rows:    1,175

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-04-01 00:00:00	ES	Futures	1313.95	1315.19	1313.2	1313.45	3172.0
2011-04-01 01:00:00	ES	Futures	1313.45	1315.19	1312.71	1312.96	5903.0
2011-04-01 02:00:00	ES	Futures	1312.96	1314.69	1312.71	1314.2	10791.0
2011-04-01 03:00:00	ES	Futures	1314.45	1316.43	1313.95	1315.94	27203.0
2011-04-01 04:00:00	ES	Futures	1316.18	1316.43	1315.19	1315.94	12124.0
2011-04-01 05:00:00	ES	Futures	1315.69	1316.18	1314.2	1316.18	10423.0
2011-04-01 06:00:00	ES	Futures	1316.18	1317.43	1315.69	1317.18	9208.0
2011-04-01 07:00:00	ES	Futures	1316.93	1318.67	1316.93	1318.17	29251.0
2011-04-01 08:00:00	ES	Futures	1318.17	1321.9	1317.18	1320.16	102099.0
2011-04-01 09:00:00	ES	Futures	1320.16	1322.64	1317.43	1318.42	215135.0
2011-04-01 10:00:00	ES	Futures	1318.42	1324.38	1318.17	1323.14	290610.0
2011-04-01 11:00:00	ES	Futures	1323.14	1325.38	1322.4	1324.38	211050.0
2011-04-01 12:00:00	ES	Futures	1324.63	1325.13	1322.64	1323.14	73204.0
2011-04-01 13:00:00	ES	Futures	1323.14	1323.39	1321.9	1323.14	66563.0
2011-04-01 14:00:00	ES	Futures	1323.14	1323.89	1318.92	1319.91	119049.0
2011-04-01 15:00:00	ES	Futures	1319.91	1320.66	1315.94	1318.92	328573.0
2011-04-01 16:00:00	ES	Futures	1318.92	1319.66	1318.67	1319.17	98625.0
2011-04-01 00:00:00	NQ	Futures	2690.7	2692.71	2689.27	2689.84	243.0
2011-04-01 01:00:00	NQ	Futures	2689.55	2692.43	2687.83	2688.4	254.0
2011-04-01 02:00:00	NQ	Futures	2688.12	2691.56	2687.83	2690.7	347.0
2011-04-01 03:00:00	NQ	Futures	2690.7	2696.45	2690.42	2696.16	2706.0
2011-04-01 04:00:00	NQ	Futures	2696.16	2697.31	2694.73	2695.59	1156.0
2011-04-01 05:00:00	NQ	Futures	2694.73	2695.87	2692.14	2695.3	613.0
2011-04-01 06:00:00	NQ	Futures	2695.59	2697.89	2694.73	2697.6	538.0
2011-04-01 07:00:00	NQ	Futures	2697.6	2699.9	2697.31	2699.04	3039.0
2011-04-01 08:00:00	NQ	Futures	2698.75	2703.92	2697.02	2699.04	9159.0
2011-04-01 09:00:00	NQ	Futures	2699.04	2703.06	2689.27	2692.14	39770.0
2011-04-01 10:00:00	NQ	Futures	2692.14	2705.36	2690.99	2701.91	34773.0
2011-04-01 11:00:00	NQ	Futures	2701.91	2709.95	2700.47	2707.65	23270.0
2011-04-01 12:00:00	NQ	Futures	2707.65	2708.23	2703.06	2704.78	11541.0
2011-04-01 13:00:00	NQ	Futures	2704.49	2705.07	2701.62	2703.63	11863.0
2011-04-01 14:00:00	NQ	Futures	2703.34	2704.49	2690.42	2693.58	22544.0
2011-04-01 15:00:00	NQ	Futures	2693.29	2693.58	2681.51	2688.69	51874.0
2011-04-01 16:00:00	NQ	Futures	2688.98	2692.71	2686.39	2686.68	9121.0
2011-04-01 00:00:00	YM	Futures	11821.2	11830.8	11818.3	11819.3	340.0
2011-04-01 01:00:00	YM	Futures	11818.3	11830.8	11811.6	11815.4	326.0
2011-04-01 02:00:00	YM	Futures	11815.4	11826.0	11812.5	11826.0	585.0
2011-04-01 03:00:00	YM	Futures	11827.0	11839.5	11822.2	11837.6	2012.0
2011-04-01 04:00:00	YM	Futures	11835.7	11843.4	11832.8	11839.5	895.0
2011-04-01 05:00:00	YM	Futures	11837.6	11839.5	11827.9	11839.5	1002.0
2011-04-01 06:00:00	YM	Futures	11839.5	11846.2	11835.7	11846.2	313.0
2011-04-01 07:00:00	YM	Futures	11847.2	11855.9	11845.3	11851.1	1176.0
2011-04-01 08:00:00	YM	Futures	11851.1	11877.1	11849.1	11864.5	3741.0
2011-04-01 09:00:00	YM	Futures	11865.5	11880.9	11825.1	11838.5	13732.0
2011-04-01 10:00:00	YM	Futures	11838.5	11899.2	11833.7	11887.7	17106.0
2011-04-01 11:00:00	YM	Futures	11887.7	11903.1	11883.8	11898.3	9025.0
2011-04-01 12:00:00	YM	Futures	11897.3	11903.1	11885.7	11888.6	3602.0
2011-04-01 13:00:00	YM	Futures	11888.6	11890.6	11878.0	11887.7	2996.0
2011-04-01 14:00:00	YM	Futures	11887.7	11892.5	11854.0	11857.8	6699.0
2011-04-01 15:00:00	YM	Futures	11857.8	11870.3	11828.9	11855.9	15994.0

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

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