PREVIEW / futures_1hour / 2012-12-04

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-04.parquet
  size:    46 KB
  rows:    1,474

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-12-04 00:00:00	ES	Futures	1433.66	1434.94	1433.15	1434.43	5360.0
2012-12-04 01:00:00	ES	Futures	1434.68	1435.96	1434.17	1435.71	5045.0
2012-12-04 02:00:00	ES	Futures	1435.96	1436.98	1435.2	1435.45	11082.0
2012-12-04 03:00:00	ES	Futures	1435.2	1438.77	1434.17	1438.01	31968.0
2012-12-04 04:00:00	ES	Futures	1438.01	1439.54	1437.75	1438.52	20415.0
2012-12-04 05:00:00	ES	Futures	1438.52	1440.05	1437.49	1438.26	20713.0
2012-12-04 06:00:00	ES	Futures	1438.26	1439.54	1438.01	1438.77	13488.0
2012-12-04 07:00:00	ES	Futures	1439.03	1440.56	1438.01	1439.79	26713.0
2012-12-04 08:00:00	ES	Futures	1439.79	1440.3	1436.47	1436.73	48185.0
2012-12-04 09:00:00	ES	Futures	1436.73	1441.58	1436.22	1438.52	230793.0
2012-12-04 10:00:00	ES	Futures	1438.52	1442.6	1435.96	1437.24	253837.0
2012-12-04 11:00:00	ES	Futures	1436.98	1438.52	1433.92	1437.24	219766.0
2012-12-04 12:00:00	ES	Futures	1437.24	1437.24	1432.9	1434.43	165766.0
2012-12-04 13:00:00	ES	Futures	1434.68	1438.77	1432.13	1437.75	143306.0
2012-12-04 14:00:00	ES	Futures	1437.75	1439.03	1435.45	1436.22	104809.0
2012-12-04 15:00:00	ES	Futures	1436.47	1439.54	1435.45	1435.96	187773.0
2012-12-04 16:00:00	ES	Futures	1435.71	1436.47	1434.17	1434.43	55983.0
2012-12-04 17:00:00	ES	Futures	1434.43	1434.43	1433.41	1433.92	2567.0
2012-12-04 18:00:00	ES	Futures	1433.41	1434.17	1432.13	1433.66	6255.0
2012-12-04 19:00:00	ES	Futures	1433.66	1435.45	1432.9	1434.68	5043.0
2012-12-04 20:00:00	ES	Futures	1434.68	1435.2	1433.41	1434.94	3895.0
2012-12-04 21:00:00	ES	Futures	1434.68	1439.79	1433.92	1439.03	11808.0
2012-12-04 22:00:00	ES	Futures	1438.77	1441.33	1438.52	1440.82	9327.0
2012-12-04 23:00:00	ES	Futures	1440.82	1443.88	1440.82	1441.84	9158.0
2012-12-04 00:00:00	NQ	Futures	3096.38	3097.83	3095.22	3096.67	515.0
2012-12-04 01:00:00	NQ	Futures	3096.38	3099.87	3096.09	3099.29	347.0
2012-12-04 02:00:00	NQ	Futures	3099.58	3102.48	3096.96	3098.13	1084.0
2012-12-04 03:00:00	NQ	Futures	3098.13	3106.84	3095.8	3105.1	3152.0
2012-12-04 04:00:00	NQ	Futures	3105.1	3108.01	3104.52	3106.84	1927.0
2012-12-04 05:00:00	NQ	Futures	3107.13	3109.46	3105.1	3105.97	2010.0
2012-12-04 06:00:00	NQ	Futures	3105.68	3108.88	3105.1	3108.01	2347.0
2012-12-04 07:00:00	NQ	Futures	3108.01	3110.04	3105.68	3108.01	3009.0
2012-12-04 08:00:00	NQ	Futures	3107.71	3108.59	3099.29	3099.29	6572.0
2012-12-04 09:00:00	NQ	Futures	3099.29	3105.1	3095.51	3096.96	39230.0
2012-12-04 10:00:00	NQ	Futures	3096.96	3105.39	3083.89	3089.41	50696.0
2012-12-04 11:00:00	NQ	Futures	3089.41	3100.16	3080.4	3095.51	37679.0
2012-12-04 12:00:00	NQ	Futures	3095.51	3095.8	3085.05	3089.12	26512.0
2012-12-04 13:00:00	NQ	Futures	3089.12	3101.61	3085.05	3100.74	26369.0
2012-12-04 14:00:00	NQ	Futures	3100.74	3102.77	3092.9	3098.13	21061.0
2012-12-04 15:00:00	NQ	Futures	3098.13	3106.55	3097.25	3097.83	26703.0
2012-12-04 16:00:00	NQ	Futures	3097.83	3099.29	3096.09	3096.38	4886.0
2012-12-04 17:00:00	NQ	Futures	3096.38	3096.38	3092.6	3093.48	314.0
2012-12-04 18:00:00	NQ	Futures	3092.9	3093.19	3088.83	3092.9	598.0
2012-12-04 19:00:00	NQ	Futures	3092.6	3095.22	3090.28	3094.06	623.0
2012-12-04 20:00:00	NQ	Futures	3094.35	3094.93	3092.02	3094.64	478.0
2012-12-04 21:00:00	NQ	Futures	3094.64	3103.94	3092.9	3101.61	1401.0
2012-12-04 22:00:00	NQ	Futures	3101.9	3107.42	3101.03	3107.13	897.0
2012-12-04 23:00:00	NQ	Futures	3107.13	3113.24	3107.13	3109.75	1344.0
2012-12-04 00:00:00	YM	Futures	12925.7	12934.7	12921.6	12930.7	702.0
2012-12-04 01:00:00	YM	Futures	12930.7	12940.7	12927.7	12938.7	656.0

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

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