PREVIEW / futures_1hour / 2012-08-22

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-08-22.parquet
  size:    48 KB
  rows:    1,451

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-22 00:00:00	ES	Futures	1432.38	1433.4	1432.12	1433.14	2729.0
2012-08-22 01:00:00	ES	Futures	1433.4	1433.4	1432.38	1432.89	2705.0
2012-08-22 02:00:00	ES	Futures	1433.14	1434.16	1432.38	1434.16	6839.0
2012-08-22 03:00:00	ES	Futures	1434.16	1434.16	1431.62	1432.63	31730.0
2012-08-22 04:00:00	ES	Futures	1432.63	1435.68	1431.87	1434.67	22741.0
2012-08-22 05:00:00	ES	Futures	1434.67	1434.92	1432.89	1433.9	12728.0
2012-08-22 06:00:00	ES	Futures	1433.9	1435.18	1432.12	1432.63	15486.0
2012-08-22 07:00:00	ES	Futures	1432.38	1433.14	1431.87	1432.89	21778.0
2012-08-22 08:00:00	ES	Futures	1432.89	1434.67	1431.11	1432.63	40542.0
2012-08-22 09:00:00	ES	Futures	1432.63	1435.18	1430.09	1433.9	214513.0
2012-08-22 10:00:00	ES	Futures	1433.9	1435.43	1430.85	1431.11	271458.0
2012-08-22 11:00:00	ES	Futures	1430.85	1432.89	1429.58	1432.12	210107.0
2012-08-22 12:00:00	ES	Futures	1431.87	1432.38	1428.31	1428.82	100409.0
2012-08-22 13:00:00	ES	Futures	1428.82	1431.87	1428.56	1430.34	59549.0
2012-08-22 14:00:00	ES	Futures	1430.09	1437.97	1430.09	1437.46	310215.0
2012-08-22 15:00:00	ES	Futures	1437.46	1438.48	1434.92	1435.94	226969.0
2012-08-22 16:00:00	ES	Futures	1435.94	1437.21	1435.43	1436.45	67322.0
2012-08-22 17:00:00	ES	Futures	1436.45	1436.96	1435.94	1436.19	2435.0
2012-08-22 18:00:00	ES	Futures	1436.19	1436.7	1435.43	1436.45	3482.0
2012-08-22 19:00:00	ES	Futures	1436.45	1437.46	1435.68	1437.21	2221.0
2012-08-22 20:00:00	ES	Futures	1437.21	1438.74	1435.94	1438.48	7674.0
2012-08-22 21:00:00	ES	Futures	1438.48	1441.53	1438.23	1441.28	13568.0
2012-08-22 22:00:00	ES	Futures	1441.28	1441.53	1438.74	1440.01	13056.0
2012-08-22 23:00:00	ES	Futures	1440.01	1441.79	1439.75	1441.53	5488.0
2012-08-22 00:00:00	NQ	Futures	3209.32	3211.93	3209.32	3211.93	409.0
2012-08-22 01:00:00	NQ	Futures	3211.64	3211.64	3209.61	3210.77	258.0
2012-08-22 02:00:00	NQ	Futures	3211.06	3213.37	3209.03	3213.37	587.0
2012-08-22 03:00:00	NQ	Futures	3213.37	3213.37	3205.55	3209.61	4047.0
2012-08-22 04:00:00	NQ	Futures	3209.32	3215.69	3207.87	3214.53	2108.0
2012-08-22 05:00:00	NQ	Futures	3214.24	3214.82	3209.32	3211.64	1437.0
2012-08-22 06:00:00	NQ	Futures	3211.64	3213.66	3207.0	3207.29	1512.0
2012-08-22 07:00:00	NQ	Futures	3207.29	3209.61	3205.84	3209.03	2078.0
2012-08-22 08:00:00	NQ	Futures	3209.03	3213.66	3206.71	3209.9	3891.0
2012-08-22 09:00:00	NQ	Futures	3210.19	3215.98	3199.17	3214.24	41590.0
2012-08-22 10:00:00	NQ	Futures	3214.24	3219.46	3207.87	3211.06	33246.0
2012-08-22 11:00:00	NQ	Futures	3211.06	3216.27	3207.58	3215.11	20308.0
2012-08-22 12:00:00	NQ	Futures	3214.82	3217.14	3205.26	3206.71	15936.0
2012-08-22 13:00:00	NQ	Futures	3206.71	3217.72	3205.26	3211.35	12330.0
2012-08-22 14:00:00	NQ	Futures	3211.35	3230.77	3211.35	3229.61	46164.0
2012-08-22 15:00:00	NQ	Futures	3229.9	3234.83	3224.39	3227.29	49485.0
2012-08-22 16:00:00	NQ	Futures	3227.29	3229.32	3224.1	3226.13	7936.0
2012-08-22 17:00:00	NQ	Futures	3226.42	3227.58	3225.84	3226.71	215.0
2012-08-22 18:00:00	NQ	Futures	3225.84	3227.29	3224.68	3226.42	313.0
2012-08-22 19:00:00	NQ	Futures	3226.42	3228.16	3224.68	3227.87	157.0
2012-08-22 20:00:00	NQ	Futures	3227.87	3229.9	3224.97	3229.9	505.0
2012-08-22 21:00:00	NQ	Futures	3229.9	3237.44	3229.03	3236.28	1222.0
2012-08-22 22:00:00	NQ	Futures	3235.99	3236.28	3230.19	3232.51	1298.0
2012-08-22 23:00:00	NQ	Futures	3232.8	3236.57	3232.51	3236.28	412.0
2012-08-22 00:00:00	YM	Futures	13094.3	13104.2	13093.3	13102.2	419.0
2012-08-22 01:00:00	YM	Futures	13103.2	13103.2	13093.3	13098.3	629.0

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

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