PREVIEW / futures_1hour / 2012-08-29

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-29.parquet
  size:    46 KB
  rows:    1,440

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-08-29 00:00:00	ES	Futures	1433.14	1433.65	1432.63	1433.4	828.0
2012-08-29 01:00:00	ES	Futures	1433.65	1433.65	1432.89	1432.89	1535.0
2012-08-29 02:00:00	ES	Futures	1433.14	1434.16	1432.63	1433.65	3015.0
2012-08-29 03:00:00	ES	Futures	1433.65	1433.65	1429.58	1430.34	23239.0
2012-08-29 04:00:00	ES	Futures	1430.34	1431.62	1429.33	1429.84	15700.0
2012-08-29 05:00:00	ES	Futures	1429.84	1431.36	1429.33	1430.09	12885.0
2012-08-29 06:00:00	ES	Futures	1430.09	1431.87	1430.09	1431.62	9424.0
2012-08-29 07:00:00	ES	Futures	1431.62	1432.38	1430.34	1431.11	16159.0
2012-08-29 08:00:00	ES	Futures	1431.11	1434.92	1430.85	1434.16	45767.0
2012-08-29 09:00:00	ES	Futures	1434.16	1434.67	1431.11	1431.36	121483.0
2012-08-29 10:00:00	ES	Futures	1431.62	1434.16	1428.82	1429.58	171070.0
2012-08-29 11:00:00	ES	Futures	1429.84	1433.65	1429.33	1432.89	158949.0
2012-08-29 12:00:00	ES	Futures	1432.89	1434.16	1432.12	1433.65	38362.0
2012-08-29 13:00:00	ES	Futures	1433.4	1436.7	1433.4	1435.94	89049.0
2012-08-29 14:00:00	ES	Futures	1435.68	1436.19	1433.9	1434.16	55361.0
2012-08-29 15:00:00	ES	Futures	1434.16	1435.18	1432.38	1432.63	113660.0
2012-08-29 16:00:00	ES	Futures	1432.63	1433.4	1430.34	1431.11	68144.0
2012-08-29 17:00:00	ES	Futures	1431.11	1431.62	1430.85	1431.36	1731.0
2012-08-29 18:00:00	ES	Futures	1431.11	1431.87	1430.6	1430.85	3034.0
2012-08-29 19:00:00	ES	Futures	1430.85	1431.11	1430.34	1430.85	1248.0
2012-08-29 20:00:00	ES	Futures	1430.85	1431.11	1427.29	1427.29	8984.0
2012-08-29 21:00:00	ES	Futures	1427.29	1428.56	1426.53	1427.04	7034.0
2012-08-29 22:00:00	ES	Futures	1427.04	1427.55	1426.28	1426.53	5861.0
2012-08-29 23:00:00	ES	Futures	1426.53	1426.78	1425.26	1425.77	4721.0
2012-08-29 00:00:00	NQ	Futures	3228.16	3231.35	3227.87	3230.48	436.0
2012-08-29 01:00:00	NQ	Futures	3230.77	3231.64	3229.9	3230.77	168.0
2012-08-29 02:00:00	NQ	Futures	3230.48	3233.09	3229.61	3230.77	516.0
2012-08-29 03:00:00	NQ	Futures	3230.77	3230.77	3220.62	3222.65	3127.0
2012-08-29 04:00:00	NQ	Futures	3222.65	3225.26	3220.04	3220.91	1797.0
2012-08-29 05:00:00	NQ	Futures	3220.91	3223.81	3220.33	3221.78	826.0
2012-08-29 06:00:00	NQ	Futures	3221.49	3224.68	3221.49	3223.81	831.0
2012-08-29 07:00:00	NQ	Futures	3224.1	3226.42	3221.49	3224.39	1235.0
2012-08-29 08:00:00	NQ	Futures	3224.39	3232.8	3223.81	3229.61	4737.0
2012-08-29 09:00:00	NQ	Futures	3229.61	3234.54	3225.84	3226.71	20238.0
2012-08-29 10:00:00	NQ	Futures	3226.42	3232.22	3213.37	3215.4	29009.0
2012-08-29 11:00:00	NQ	Futures	3215.11	3225.84	3214.82	3223.23	17959.0
2012-08-29 12:00:00	NQ	Futures	3223.52	3228.45	3222.36	3226.13	7254.0
2012-08-29 13:00:00	NQ	Futures	3225.84	3235.7	3225.84	3233.96	16578.0
2012-08-29 14:00:00	NQ	Futures	3234.25	3234.54	3229.03	3229.61	8691.0
2012-08-29 15:00:00	NQ	Futures	3229.9	3231.35	3226.13	3226.71	13092.0
2012-08-29 16:00:00	NQ	Futures	3226.71	3228.16	3223.81	3224.39	5884.0
2012-08-29 17:00:00	NQ	Futures	3224.68	3225.26	3224.1	3224.97	104.0
2012-08-29 18:00:00	NQ	Futures	3224.39	3226.42	3223.81	3224.68	187.0
2012-08-29 19:00:00	NQ	Futures	3224.39	3225.84	3224.1	3224.97	211.0
2012-08-29 20:00:00	NQ	Futures	3224.68	3225.26	3218.3	3218.3	908.0
2012-08-29 21:00:00	NQ	Futures	3218.59	3220.62	3216.85	3218.01	583.0
2012-08-29 22:00:00	NQ	Futures	3218.3	3218.59	3216.56	3217.43	615.0
2012-08-29 23:00:00	NQ	Futures	3217.14	3217.14	3214.24	3215.4	369.0
2012-08-29 00:00:00	YM	Futures	13018.7	13025.7	13016.7	13025.7	112.0
2012-08-29 01:00:00	YM	Futures	13025.7	13027.7	13019.7	13022.7	140.0

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

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