PREVIEW / futures_1hour / 2012-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-09-13.parquet
  size:    48 KB
  rows:    1,436

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-09-13 00:00:00	ES	Futures	1462.64	1463.15	1462.13	1462.38	1324.0
2012-09-13 01:00:00	ES	Futures	1462.38	1462.64	1461.37	1461.37	3759.0
2012-09-13 02:00:00	ES	Futures	1461.62	1462.89	1461.37	1461.88	4702.0
2012-09-13 03:00:00	ES	Futures	1461.88	1462.38	1459.59	1460.35	21706.0
2012-09-13 04:00:00	ES	Futures	1460.1	1462.13	1459.59	1460.6	19454.0
2012-09-13 05:00:00	ES	Futures	1460.6	1462.13	1460.35	1460.86	16581.0
2012-09-13 06:00:00	ES	Futures	1460.86	1461.88	1460.6	1461.62	11319.0
2012-09-13 07:00:00	ES	Futures	1461.62	1462.89	1461.37	1461.37	15866.0
2012-09-13 08:00:00	ES	Futures	1461.37	1462.89	1460.6	1462.89	39865.0
2012-09-13 09:00:00	ES	Futures	1462.64	1462.89	1459.59	1461.11	132146.0
2012-09-13 10:00:00	ES	Futures	1460.86	1462.64	1460.35	1461.88	136391.0
2012-09-13 11:00:00	ES	Futures	1461.88	1464.67	1461.88	1462.38	126430.0
2012-09-13 12:00:00	ES	Futures	1462.38	1473.83	1460.6	1472.81	492984.0
2012-09-13 13:00:00	ES	Futures	1472.81	1480.69	1471.79	1479.17	314648.0
2012-09-13 14:00:00	ES	Futures	1479.17	1489.34	1478.4	1484.0	336559.0
2012-09-13 15:00:00	ES	Futures	1483.74	1487.3	1482.47	1485.27	253379.0
2012-09-13 16:00:00	ES	Futures	1485.27	1485.78	1481.46	1481.96	87612.0
2012-09-13 17:00:00	ES	Futures	1482.22	1482.98	1481.96	1482.98	3186.0
2012-09-13 18:00:00	ES	Futures	1482.98	1484.51	1482.73	1484.25	4505.0
2012-09-13 19:00:00	ES	Futures	1484.25	1485.02	1484.0	1484.25	3217.0
2012-09-13 20:00:00	ES	Futures	1484.25	1485.52	1484.0	1485.52	6286.0
2012-09-13 21:00:00	ES	Futures	1485.52	1486.29	1485.02	1485.27	4393.0
2012-09-13 22:00:00	ES	Futures	1485.27	1485.78	1484.51	1485.27	3323.0
2012-09-13 23:00:00	ES	Futures	1485.52	1486.54	1485.02	1486.03	2482.0
2012-09-13 00:00:00	NQ	Futures	3239.75	3241.2	3238.3	3238.88	129.0
2012-09-13 01:00:00	NQ	Futures	3238.59	3239.46	3235.7	3235.7	388.0
2012-09-13 02:00:00	NQ	Futures	3235.99	3239.46	3235.99	3236.86	648.0
2012-09-13 03:00:00	NQ	Futures	3237.15	3237.73	3231.35	3231.93	2361.0
2012-09-13 04:00:00	NQ	Futures	3231.93	3234.54	3230.19	3230.19	3230.0
2012-09-13 05:00:00	NQ	Futures	3230.19	3233.67	3229.61	3230.77	2072.0
2012-09-13 06:00:00	NQ	Futures	3230.77	3233.09	3230.19	3232.22	1269.0
2012-09-13 07:00:00	NQ	Futures	3232.8	3238.02	3232.22	3234.25	4109.0
2012-09-13 08:00:00	NQ	Futures	3234.25	3240.04	3232.22	3239.17	7031.0
2012-09-13 09:00:00	NQ	Futures	3238.88	3244.39	3236.28	3242.36	30381.0
2012-09-13 10:00:00	NQ	Futures	3242.36	3249.61	3240.04	3244.1	22821.0
2012-09-13 11:00:00	NQ	Futures	3244.1	3249.03	3244.1	3245.55	17361.0
2012-09-13 12:00:00	NQ	Futures	3245.26	3270.77	3239.17	3265.26	67703.0
2012-09-13 13:00:00	NQ	Futures	3265.26	3284.11	3265.26	3277.44	37267.0
2012-09-13 14:00:00	NQ	Futures	3277.73	3295.41	3275.41	3287.3	45942.0
2012-09-13 15:00:00	NQ	Futures	3287.01	3291.06	3278.6	3281.21	56564.0
2012-09-13 16:00:00	NQ	Futures	3281.21	3281.5	3276.28	3278.6	8011.0
2012-09-13 17:00:00	NQ	Futures	3278.89	3281.21	3278.89	3280.92	62.0
2012-09-13 18:00:00	NQ	Futures	3281.21	3284.4	3281.21	3284.4	187.0
2012-09-13 19:00:00	NQ	Futures	3284.4	3285.85	3283.82	3284.4	192.0
2012-09-13 20:00:00	NQ	Futures	3284.4	3288.17	3283.82	3287.59	281.0
2012-09-13 21:00:00	NQ	Futures	3288.17	3289.32	3287.01	3287.59	279.0
2012-09-13 22:00:00	NQ	Futures	3287.3	3287.88	3285.56	3287.3	172.0
2012-09-13 23:00:00	NQ	Futures	3287.3	3289.32	3287.01	3289.32	163.0
2012-09-13 00:00:00	YM	Futures	13277.8	13282.8	13276.8	13280.8	9.0
2012-09-13 01:00:00	YM	Futures	13274.8	13274.8	13271.8	13271.8	6.0

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

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