PREVIEW / futures_1hour / 2012-05-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-05-18.parquet
  size:    42 KB
  rows:    1,215

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
2012-05-18 00:00:00	ES	Futures	1317.04	1317.29	1312.99	1313.24	14109.0
2012-05-18 01:00:00	ES	Futures	1313.24	1313.75	1308.94	1311.47	23888.0
2012-05-18 02:00:00	ES	Futures	1311.47	1315.01	1310.96	1314.25	25313.0
2012-05-18 03:00:00	ES	Futures	1314.25	1320.33	1312.74	1318.3	65085.0
2012-05-18 04:00:00	ES	Futures	1318.05	1321.59	1317.29	1318.81	41526.0
2012-05-18 05:00:00	ES	Futures	1318.81	1322.86	1315.77	1322.1	41168.0
2012-05-18 06:00:00	ES	Futures	1322.35	1323.61	1321.08	1322.1	35021.0
2012-05-18 07:00:00	ES	Futures	1322.1	1325.39	1321.84	1322.6	60924.0
2012-05-18 08:00:00	ES	Futures	1322.35	1324.88	1321.84	1322.35	68100.0
2012-05-18 09:00:00	ES	Futures	1322.35	1324.37	1319.06	1320.33	334447.0
2012-05-18 10:00:00	ES	Futures	1320.58	1326.14	1318.55	1324.12	340083.0
2012-05-18 11:00:00	ES	Futures	1323.87	1324.88	1311.72	1314.51	526904.0
2012-05-18 12:00:00	ES	Futures	1314.51	1321.34	1314.25	1318.3	238252.0
2012-05-18 13:00:00	ES	Futures	1318.3	1319.82	1312.99	1313.24	138295.0
2012-05-18 14:00:00	ES	Futures	1313.49	1314.25	1307.93	1309.7	225623.0
2012-05-18 15:00:00	ES	Futures	1309.7	1314.0	1305.15	1307.93	395423.0
2012-05-18 16:00:00	ES	Futures	1307.93	1308.44	1305.15	1305.91	123364.0
2012-05-18 00:00:00	NQ	Futures	2899.52	2900.1	2892.01	2894.03	1492.0
2012-05-18 01:00:00	NQ	Futures	2893.74	2894.32	2883.04	2886.8	2412.0
2012-05-18 02:00:00	NQ	Futures	2886.8	2896.34	2885.93	2894.61	2905.0
2012-05-18 03:00:00	NQ	Futures	2894.32	2908.49	2892.58	2901.55	7231.0
2012-05-18 04:00:00	NQ	Futures	2901.84	2910.51	2900.1	2904.44	3660.0
2012-05-18 05:00:00	NQ	Futures	2905.02	2911.67	2896.92	2908.78	3852.0
2012-05-18 06:00:00	NQ	Futures	2909.07	2912.83	2906.18	2911.96	2815.0
2012-05-18 07:00:00	NQ	Futures	2911.96	2917.17	2908.2	2909.36	5875.0
2012-05-18 08:00:00	NQ	Futures	2909.36	2912.25	2903.86	2904.44	11366.0
2012-05-18 09:00:00	NQ	Futures	2904.15	2912.54	2889.98	2895.77	58062.0
2012-05-18 10:00:00	NQ	Futures	2896.05	2916.59	2892.01	2913.41	57868.0
2012-05-18 11:00:00	NQ	Futures	2913.41	2914.85	2872.34	2883.62	88731.0
2012-05-18 12:00:00	NQ	Futures	2883.62	2909.94	2883.62	2898.95	50175.0
2012-05-18 13:00:00	NQ	Futures	2898.95	2900.39	2880.44	2883.04	23538.0
2012-05-18 14:00:00	NQ	Futures	2883.04	2887.96	2869.74	2875.81	31223.0
2012-05-18 15:00:00	NQ	Futures	2875.52	2883.33	2860.77	2864.24	51671.0
2012-05-18 16:00:00	NQ	Futures	2864.24	2865.98	2854.99	2857.01	12465.0
2012-05-18 00:00:00	YM	Futures	12373.0	12376.0	12339.2	12341.2	996.0
2012-05-18 01:00:00	YM	Futures	12343.2	12345.1	12306.3	12326.2	1482.0
2012-05-18 02:00:00	YM	Futures	12325.2	12356.1	12325.2	12350.1	1929.0
2012-05-18 03:00:00	YM	Futures	12349.1	12398.9	12340.2	12385.0	7418.0
2012-05-18 04:00:00	YM	Futures	12386.0	12406.9	12377.0	12384.0	3466.0
2012-05-18 05:00:00	YM	Futures	12383.0	12414.9	12362.1	12409.9	3265.0
2012-05-18 06:00:00	YM	Futures	12410.9	12421.9	12399.9	12411.9	1989.0
2012-05-18 07:00:00	YM	Futures	12410.9	12433.8	12404.9	12407.9	3824.0
2012-05-18 08:00:00	YM	Futures	12408.9	12427.8	12403.9	12410.9	3562.0
2012-05-18 09:00:00	YM	Futures	12408.9	12422.9	12372.0	12379.0	23076.0
2012-05-18 10:00:00	YM	Futures	12380.0	12424.9	12368.1	12404.9	23898.0
2012-05-18 11:00:00	YM	Futures	12404.9	12411.9	12319.2	12338.2	32174.0
2012-05-18 12:00:00	YM	Futures	12339.2	12386.0	12339.2	12369.1	17378.0
2012-05-18 13:00:00	YM	Futures	12369.1	12381.0	12329.2	12331.2	9456.0
2012-05-18 14:00:00	YM	Futures	12330.2	12340.2	12296.3	12312.3	16091.0
2012-05-18 15:00:00	YM	Futures	12311.3	12348.1	12272.4	12298.3	25382.0

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

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