PREVIEW / futures_1hour / 2012-08-21

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-21.parquet
  size:    48 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-21 00:00:00	ES	Futures	1438.99	1440.01	1438.74	1439.5	2962.0
2012-08-21 01:00:00	ES	Futures	1439.5	1440.01	1438.74	1438.99	2385.0
2012-08-21 02:00:00	ES	Futures	1438.74	1440.26	1438.48	1439.75	4577.0
2012-08-21 03:00:00	ES	Futures	1439.75	1443.57	1439.24	1442.04	37444.0
2012-08-21 04:00:00	ES	Futures	1442.04	1443.57	1441.28	1441.79	16518.0
2012-08-21 05:00:00	ES	Futures	1441.79	1442.55	1441.02	1441.02	10883.0
2012-08-21 06:00:00	ES	Futures	1441.02	1442.55	1441.02	1442.04	12089.0
2012-08-21 07:00:00	ES	Futures	1442.04	1442.8	1441.28	1442.3	18873.0
2012-08-21 08:00:00	ES	Futures	1442.55	1444.33	1441.28	1444.08	48170.0
2012-08-21 09:00:00	ES	Futures	1444.08	1445.6	1442.55	1445.35	168162.0
2012-08-21 10:00:00	ES	Futures	1445.35	1449.16	1445.35	1447.13	325164.0
2012-08-21 11:00:00	ES	Futures	1447.13	1447.89	1441.79	1442.3	303297.0
2012-08-21 12:00:00	ES	Futures	1442.3	1443.31	1440.26	1441.28	139708.0
2012-08-21 13:00:00	ES	Futures	1441.02	1441.53	1436.7	1438.48	122371.0
2012-08-21 14:00:00	ES	Futures	1438.74	1439.5	1435.43	1436.7	125097.0
2012-08-21 15:00:00	ES	Futures	1436.7	1436.7	1432.12	1435.68	279432.0
2012-08-21 16:00:00	ES	Futures	1435.68	1437.72	1434.41	1436.19	96197.0
2012-08-21 17:00:00	ES	Futures	1436.19	1436.45	1435.43	1436.19	2288.0
2012-08-21 18:00:00	ES	Futures	1436.19	1436.45	1434.67	1434.92	5432.0
2012-08-21 19:00:00	ES	Futures	1434.92	1435.43	1434.41	1434.92	1747.0
2012-08-21 20:00:00	ES	Futures	1434.92	1434.92	1432.12	1432.89	9822.0
2012-08-21 21:00:00	ES	Futures	1432.89	1433.4	1430.6	1431.11	12697.0
2012-08-21 22:00:00	ES	Futures	1431.11	1432.89	1430.6	1432.38	6605.0
2012-08-21 23:00:00	ES	Futures	1432.38	1432.63	1430.6	1432.12	6765.0
2012-08-21 00:00:00	NQ	Futures	3225.26	3227.0	3224.97	3226.42	334.0
2012-08-21 01:00:00	NQ	Futures	3226.71	3227.0	3225.55	3225.55	186.0
2012-08-21 02:00:00	NQ	Futures	3225.84	3228.16	3225.55	3226.42	491.0
2012-08-21 03:00:00	NQ	Futures	3226.71	3233.67	3224.39	3231.64	4612.0
2012-08-21 04:00:00	NQ	Futures	3231.35	3234.83	3231.35	3231.64	1681.0
2012-08-21 05:00:00	NQ	Futures	3231.93	3232.51	3228.74	3229.61	1037.0
2012-08-21 06:00:00	NQ	Futures	3229.61	3233.67	3229.61	3231.35	1777.0
2012-08-21 07:00:00	NQ	Futures	3231.35	3233.09	3230.48	3232.8	1203.0
2012-08-21 08:00:00	NQ	Futures	3232.51	3239.17	3231.35	3236.57	4919.0
2012-08-21 09:00:00	NQ	Futures	3236.28	3243.52	3234.54	3242.65	26898.0
2012-08-21 10:00:00	NQ	Futures	3242.65	3249.61	3233.96	3235.41	40349.0
2012-08-21 11:00:00	NQ	Futures	3235.7	3238.3	3223.81	3224.1	41607.0
2012-08-21 12:00:00	NQ	Futures	3224.1	3225.26	3214.82	3217.14	24723.0
2012-08-21 13:00:00	NQ	Futures	3217.43	3217.72	3202.94	3211.06	24050.0
2012-08-21 14:00:00	NQ	Futures	3211.06	3219.17	3209.9	3213.08	24235.0
2012-08-21 15:00:00	NQ	Futures	3212.8	3215.4	3202.07	3215.11	33220.0
2012-08-21 16:00:00	NQ	Futures	3215.11	3220.33	3213.66	3217.14	9302.0
2012-08-21 17:00:00	NQ	Futures	3217.14	3217.72	3215.4	3216.85	76.0
2012-08-21 18:00:00	NQ	Futures	3217.14	3217.14	3212.8	3212.8	556.0
2012-08-21 19:00:00	NQ	Futures	3213.08	3214.24	3212.51	3213.95	141.0
2012-08-21 20:00:00	NQ	Futures	3213.08	3213.37	3209.03	3209.9	992.0
2012-08-21 21:00:00	NQ	Futures	3209.9	3210.77	3205.84	3206.71	1048.0
2012-08-21 22:00:00	NQ	Futures	3206.42	3209.9	3205.84	3209.32	529.0
2012-08-21 23:00:00	NQ	Futures	3209.32	3209.61	3205.84	3209.32	599.0
2012-08-21 00:00:00	YM	Futures	13157.9	13164.9	13157.9	13160.9	180.0
2012-08-21 01:00:00	YM	Futures	13160.9	13163.9	13157.9	13157.9	159.0

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

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