PREVIEW / futures_1hour / 2011-04-08

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-04-08.parquet
  size:    40 KB
  rows:    1,170

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-08 00:00:00	ES	Futures	1322.64	1323.64	1320.91	1321.4	7515.0
2011-04-08 01:00:00	ES	Futures	1321.4	1323.14	1320.91	1322.64	4774.0
2011-04-08 02:00:00	ES	Futures	1322.64	1323.89	1322.4	1322.89	7467.0
2011-04-08 03:00:00	ES	Futures	1322.89	1326.12	1322.89	1325.13	30211.0
2011-04-08 04:00:00	ES	Futures	1325.13	1325.13	1322.89	1324.38	12881.0
2011-04-08 05:00:00	ES	Futures	1324.38	1325.87	1324.38	1325.13	9528.0
2011-04-08 06:00:00	ES	Futures	1325.38	1325.87	1324.63	1325.38	7225.0
2011-04-08 07:00:00	ES	Futures	1325.63	1327.36	1325.13	1326.62	28766.0
2011-04-08 08:00:00	ES	Futures	1326.62	1327.12	1325.63	1325.63	23026.0
2011-04-08 09:00:00	ES	Futures	1325.87	1327.36	1322.4	1323.89	184754.0
2011-04-08 10:00:00	ES	Futures	1323.89	1324.63	1320.16	1320.16	225957.0
2011-04-08 11:00:00	ES	Futures	1320.16	1322.15	1318.92	1320.91	218816.0
2011-04-08 12:00:00	ES	Futures	1321.15	1321.65	1318.17	1319.17	101026.0
2011-04-08 13:00:00	ES	Futures	1319.17	1319.91	1318.17	1319.17	92539.0
2011-04-08 14:00:00	ES	Futures	1319.41	1319.66	1310.47	1310.97	353319.0
2011-04-08 15:00:00	ES	Futures	1311.22	1316.93	1310.47	1315.44	395250.0
2011-04-08 16:00:00	ES	Futures	1315.69	1316.18	1314.45	1315.94	120738.0
2011-04-08 00:00:00	NQ	Futures	2682.08	2682.37	2674.61	2676.34	612.0
2011-04-08 01:00:00	NQ	Futures	2676.62	2680.36	2676.05	2678.64	312.0
2011-04-08 02:00:00	NQ	Futures	2678.92	2681.8	2678.64	2679.21	709.0
2011-04-08 03:00:00	NQ	Futures	2678.92	2687.83	2678.92	2685.82	2307.0
2011-04-08 04:00:00	NQ	Futures	2685.53	2685.53	2680.36	2683.52	786.0
2011-04-08 05:00:00	NQ	Futures	2683.81	2686.97	2683.23	2684.09	678.0
2011-04-08 06:00:00	NQ	Futures	2684.67	2684.96	2682.37	2684.67	784.0
2011-04-08 07:00:00	NQ	Futures	2684.38	2687.83	2682.95	2687.54	2611.0
2011-04-08 08:00:00	NQ	Futures	2687.26	2688.12	2684.96	2685.24	2703.0
2011-04-08 09:00:00	NQ	Futures	2685.53	2692.43	2675.48	2680.07	33542.0
2011-04-08 10:00:00	NQ	Futures	2680.36	2683.23	2669.44	2673.18	31973.0
2011-04-08 11:00:00	NQ	Futures	2673.18	2680.07	2670.88	2676.91	23373.0
2011-04-08 12:00:00	NQ	Futures	2676.91	2678.64	2670.3	2672.89	13034.0
2011-04-08 13:00:00	NQ	Futures	2672.6	2676.05	2671.45	2673.75	12723.0
2011-04-08 14:00:00	NQ	Futures	2674.04	2674.33	2650.19	2650.19	46272.0
2011-04-08 15:00:00	NQ	Futures	2650.48	2666.28	2648.76	2662.83	46873.0
2011-04-08 16:00:00	NQ	Futures	2662.55	2666.28	2661.68	2665.99	9400.0
2011-04-08 00:00:00	YM	Futures	11920.4	11928.1	11905.0	11907.9	348.0
2011-04-08 01:00:00	YM	Futures	11909.8	11919.4	11905.0	11915.6	254.0
2011-04-08 02:00:00	YM	Futures	11916.6	11926.2	11915.6	11919.4	684.0
2011-04-08 03:00:00	YM	Futures	11918.5	11942.6	11918.5	11934.9	2111.0
2011-04-08 04:00:00	YM	Futures	11934.9	11934.9	11921.4	11930.0	932.0
2011-04-08 05:00:00	YM	Futures	11930.0	11941.6	11930.0	11935.8	473.0
2011-04-08 06:00:00	YM	Futures	11935.8	11939.7	11932.0	11937.7	427.0
2011-04-08 07:00:00	YM	Futures	11936.8	11949.3	11933.9	11946.4	934.0
2011-04-08 08:00:00	YM	Futures	11946.4	11949.3	11932.0	11933.9	1266.0
2011-04-08 09:00:00	YM	Futures	11933.9	11942.6	11903.1	11912.7	9635.0
2011-04-08 10:00:00	YM	Futures	11912.7	11917.5	11880.0	11880.9	14927.0
2011-04-08 11:00:00	YM	Futures	11880.0	11901.1	11874.2	11890.6	12179.0
2011-04-08 12:00:00	YM	Futures	11890.6	11899.2	11875.1	11881.9	5414.0
2011-04-08 13:00:00	YM	Futures	11880.9	11886.7	11875.1	11883.8	5606.0
2011-04-08 14:00:00	YM	Futures	11883.8	11887.7	11814.5	11820.2	16371.0
2011-04-08 15:00:00	YM	Futures	11820.2	11882.8	11815.4	11873.2	19440.0

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

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