PREVIEW / futures_1hour / 2012-02-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-03.parquet
  size:    41 KB
  rows:    1,201

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-02-03 00:00:00	ES	Futures	1331.25	1333.52	1330.75	1333.52	2442.0
2012-02-03 01:00:00	ES	Futures	1333.27	1334.28	1332.76	1333.02	2350.0
2012-02-03 02:00:00	ES	Futures	1333.27	1333.27	1331.25	1331.76	5898.0
2012-02-03 03:00:00	ES	Futures	1332.01	1333.27	1330.75	1332.26	17942.0
2012-02-03 04:00:00	ES	Futures	1332.01	1335.79	1332.01	1335.54	23817.0
2012-02-03 05:00:00	ES	Futures	1335.28	1336.8	1335.03	1336.04	13146.0
2012-02-03 06:00:00	ES	Futures	1336.04	1336.8	1334.78	1335.79	18102.0
2012-02-03 07:00:00	ES	Futures	1335.79	1336.54	1333.27	1333.77	31327.0
2012-02-03 08:00:00	ES	Futures	1333.52	1347.38	1332.51	1345.36	221112.0
2012-02-03 09:00:00	ES	Futures	1345.62	1346.88	1343.85	1346.62	218886.0
2012-02-03 10:00:00	ES	Futures	1346.37	1350.4	1346.37	1348.89	320531.0
2012-02-03 11:00:00	ES	Futures	1348.64	1350.4	1347.63	1348.89	191294.0
2012-02-03 12:00:00	ES	Futures	1348.89	1351.92	1348.39	1350.91	160710.0
2012-02-03 13:00:00	ES	Futures	1350.91	1351.16	1349.4	1349.9	56309.0
2012-02-03 14:00:00	ES	Futures	1349.9	1351.66	1349.65	1351.41	64091.0
2012-02-03 15:00:00	ES	Futures	1351.41	1352.67	1349.14	1351.92	214288.0
2012-02-03 16:00:00	ES	Futures	1351.92	1352.42	1349.14	1350.15	111966.0
2012-02-03 00:00:00	NQ	Futures	2877.01	2880.76	2876.72	2880.47	202.0
2012-02-03 01:00:00	NQ	Futures	2880.76	2882.21	2879.9	2879.9	248.0
2012-02-03 02:00:00	NQ	Futures	2880.19	2880.19	2876.72	2878.45	455.0
2012-02-03 03:00:00	NQ	Futures	2878.45	2881.92	2877.01	2879.9	1320.0
2012-02-03 04:00:00	NQ	Futures	2879.32	2886.25	2879.32	2885.38	1486.0
2012-02-03 05:00:00	NQ	Futures	2884.81	2889.43	2884.81	2888.27	1035.0
2012-02-03 06:00:00	NQ	Futures	2887.98	2888.56	2884.81	2888.27	1237.0
2012-02-03 07:00:00	NQ	Futures	2888.27	2889.43	2884.81	2885.67	2798.0
2012-02-03 08:00:00	NQ	Futures	2885.67	2909.93	2884.81	2905.6	15115.0
2012-02-03 09:00:00	NQ	Futures	2905.6	2911.66	2901.27	2910.22	33895.0
2012-02-03 10:00:00	NQ	Futures	2910.8	2918.02	2907.91	2916.0	36861.0
2012-02-03 11:00:00	NQ	Futures	2916.0	2919.46	2912.82	2914.84	16139.0
2012-02-03 12:00:00	NQ	Futures	2914.55	2922.64	2913.4	2920.62	14547.0
2012-02-03 13:00:00	NQ	Futures	2920.91	2921.48	2916.86	2917.15	6501.0
2012-02-03 14:00:00	NQ	Futures	2917.15	2920.91	2917.15	2919.75	7987.0
2012-02-03 15:00:00	NQ	Futures	2919.75	2920.62	2914.55	2918.6	21154.0
2012-02-03 16:00:00	NQ	Futures	2918.88	2919.17	2913.11	2915.13	6037.0
2012-02-03 00:00:00	YM	Futures	12536.9	12553.7	12534.9	12551.7	238.0
2012-02-03 01:00:00	YM	Futures	12551.7	12559.7	12548.8	12549.8	180.0
2012-02-03 02:00:00	YM	Futures	12549.8	12549.8	12535.9	12541.8	403.0
2012-02-03 03:00:00	YM	Futures	12540.8	12555.7	12534.9	12547.8	1581.0
2012-02-03 04:00:00	YM	Futures	12545.8	12571.6	12545.8	12569.6	1517.0
2012-02-03 05:00:00	YM	Futures	12569.6	12582.5	12565.6	12576.5	1027.0
2012-02-03 06:00:00	YM	Futures	12577.5	12582.5	12565.6	12571.6	1185.0
2012-02-03 07:00:00	YM	Futures	12572.6	12583.5	12557.7	12562.6	3923.0
2012-02-03 08:00:00	YM	Futures	12561.6	12678.6	12557.7	12657.8	11189.0
2012-02-03 09:00:00	YM	Futures	12658.8	12673.6	12644.9	12668.7	11859.0
2012-02-03 10:00:00	YM	Futures	12670.7	12719.2	12668.7	12683.6	21890.0
2012-02-03 11:00:00	YM	Futures	12683.6	12690.5	12666.7	12676.6	7407.0
2012-02-03 12:00:00	YM	Futures	12676.6	12703.4	12672.7	12693.5	5725.0
2012-02-03 13:00:00	YM	Futures	12693.5	12696.4	12677.6	12683.6	2478.0
2012-02-03 14:00:00	YM	Futures	12683.6	12695.5	12681.6	12693.5	2830.0
2012-02-03 15:00:00	YM	Futures	12693.5	12701.4	12671.7	12698.4	9221.0

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

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