PREVIEW / futures_1hour / 2012-08-28

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-28.parquet
  size:    45 KB
  rows:    1,427

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-28 00:00:00	ES	Futures	1429.07	1429.84	1428.82	1429.33	1923.0
2012-08-28 01:00:00	ES	Futures	1429.33	1432.63	1429.33	1432.38	6891.0
2012-08-28 02:00:00	ES	Futures	1432.63	1432.63	1431.11	1432.12	5571.0
2012-08-28 03:00:00	ES	Futures	1432.38	1434.16	1429.84	1433.9	27268.0
2012-08-28 04:00:00	ES	Futures	1433.65	1434.16	1431.36	1433.14	17334.0
2012-08-28 05:00:00	ES	Futures	1433.14	1435.18	1433.14	1433.4	20365.0
2012-08-28 06:00:00	ES	Futures	1433.4	1434.67	1432.89	1433.14	8236.0
2012-08-28 07:00:00	ES	Futures	1433.14	1433.14	1431.62	1431.62	19679.0
2012-08-28 08:00:00	ES	Futures	1431.87	1432.63	1428.31	1428.82	39501.0
2012-08-28 09:00:00	ES	Futures	1429.07	1433.4	1428.06	1428.56	200875.0
2012-08-28 10:00:00	ES	Futures	1428.31	1436.19	1427.29	1432.38	296711.0
2012-08-28 11:00:00	ES	Futures	1432.12	1433.9	1430.6	1433.9	157021.0
2012-08-28 12:00:00	ES	Futures	1433.65	1435.43	1433.4	1434.92	89177.0
2012-08-28 13:00:00	ES	Futures	1434.92	1435.18	1431.62	1432.12	44143.0
2012-08-28 14:00:00	ES	Futures	1432.12	1435.18	1432.12	1433.4	52932.0
2012-08-28 15:00:00	ES	Futures	1433.4	1435.94	1430.85	1431.87	144095.0
2012-08-28 16:00:00	ES	Futures	1431.87	1432.12	1431.11	1431.36	56015.0
2012-08-28 17:00:00	ES	Futures	1431.62	1433.14	1431.36	1432.89	2735.0
2012-08-28 18:00:00	ES	Futures	1432.12	1433.65	1431.87	1433.14	2920.0
2012-08-28 19:00:00	ES	Futures	1433.4	1433.65	1432.89	1433.14	543.0
2012-08-28 20:00:00	ES	Futures	1433.14	1433.4	1432.38	1432.63	2356.0
2012-08-28 21:00:00	ES	Futures	1432.89	1433.4	1431.62	1432.63	2296.0
2012-08-28 22:00:00	ES	Futures	1432.63	1433.4	1432.38	1433.14	1581.0
2012-08-28 23:00:00	ES	Futures	1433.14	1433.14	1432.12	1433.14	1625.0
2012-08-28 00:00:00	NQ	Futures	3220.04	3222.36	3220.04	3220.91	470.0
2012-08-28 01:00:00	NQ	Futures	3221.2	3228.45	3220.62	3227.29	1053.0
2012-08-28 02:00:00	NQ	Futures	3227.0	3228.74	3224.97	3227.87	804.0
2012-08-28 03:00:00	NQ	Futures	3228.16	3231.64	3222.94	3231.35	3129.0
2012-08-28 04:00:00	NQ	Futures	3231.64	3231.64	3226.13	3229.61	933.0
2012-08-28 05:00:00	NQ	Futures	3229.9	3234.25	3229.32	3230.48	1716.0
2012-08-28 06:00:00	NQ	Futures	3230.77	3233.38	3229.61	3229.9	741.0
2012-08-28 07:00:00	NQ	Futures	3229.61	3229.9	3226.13	3226.13	1498.0
2012-08-28 08:00:00	NQ	Futures	3226.13	3228.16	3220.33	3221.49	4396.0
2012-08-28 09:00:00	NQ	Futures	3221.2	3230.19	3216.85	3218.01	31598.0
2012-08-28 10:00:00	NQ	Futures	3218.01	3232.8	3213.08	3222.65	38052.0
2012-08-28 11:00:00	NQ	Futures	3222.65	3231.64	3218.3	3231.06	21612.0
2012-08-28 12:00:00	NQ	Futures	3231.06	3235.7	3230.19	3232.22	18393.0
2012-08-28 13:00:00	NQ	Futures	3232.51	3232.8	3225.26	3227.29	10632.0
2012-08-28 14:00:00	NQ	Futures	3227.58	3231.35	3225.55	3227.58	11253.0
2012-08-28 15:00:00	NQ	Futures	3227.87	3232.8	3224.97	3226.71	19960.0
2012-08-28 16:00:00	NQ	Futures	3226.71	3227.87	3224.68	3225.26	3731.0
2012-08-28 17:00:00	NQ	Futures	3224.97	3227.87	3224.39	3227.87	173.0
2012-08-28 18:00:00	NQ	Futures	3226.13	3229.03	3226.13	3228.45	190.0
2012-08-28 19:00:00	NQ	Futures	3228.45	3229.03	3228.16	3228.45	91.0
2012-08-28 20:00:00	NQ	Futures	3228.45	3229.03	3227.0	3227.58	177.0
2012-08-28 21:00:00	NQ	Futures	3227.58	3228.74	3226.13	3227.29	269.0
2012-08-28 22:00:00	NQ	Futures	3227.29	3229.03	3227.29	3228.45	208.0
2012-08-28 23:00:00	NQ	Futures	3228.16	3228.74	3227.0	3228.16	141.0
2012-08-28 00:00:00	YM	Futures	13010.8	13017.7	13010.8	13014.7	198.0
2012-08-28 01:00:00	YM	Futures	13014.7	13038.6	13011.8	13038.6	792.0

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

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