PREVIEW / futures_1hour / 2011-09-16

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-09-16.parquet
  size:    41 KB
  rows:    1,170

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
2011-09-16 00:00:00	ES	Futures	1210.41	1210.66	1207.9	1209.41	5290.0
2011-09-16 01:00:00	ES	Futures	1209.41	1210.41	1207.9	1209.16	5388.0
2011-09-16 02:00:00	ES	Futures	1209.41	1209.41	1206.15	1207.65	16248.0
2011-09-16 03:00:00	ES	Futures	1207.9	1208.15	1201.13	1201.88	65215.0
2011-09-16 04:00:00	ES	Futures	1201.88	1202.13	1198.37	1200.38	49423.0
2011-09-16 05:00:00	ES	Futures	1200.38	1206.15	1200.38	1203.64	36935.0
2011-09-16 06:00:00	ES	Futures	1203.64	1207.9	1200.63	1204.89	45875.0
2011-09-16 07:00:00	ES	Futures	1204.64	1205.39	1200.38	1202.89	54241.0
2011-09-16 08:00:00	ES	Futures	1202.89	1207.65	1200.13	1206.65	89543.0
2011-09-16 09:00:00	ES	Futures	1206.4	1218.18	1205.39	1212.67	451058.0
2011-09-16 10:00:00	ES	Futures	1212.92	1217.43	1201.13	1204.39	536949.0
2011-09-16 11:00:00	ES	Futures	1204.64	1210.91	1201.88	1209.91	330380.0
2011-09-16 12:00:00	ES	Futures	1209.66	1214.67	1208.65	1212.42	170106.0
2011-09-16 13:00:00	ES	Futures	1212.42	1212.67	1206.15	1208.65	149136.0
2011-09-16 14:00:00	ES	Futures	1208.65	1212.67	1208.15	1212.42	113179.0
2011-09-16 15:00:00	ES	Futures	1212.42	1214.17	1207.65	1213.42	316182.0
2011-09-16 16:00:00	ES	Futures	1213.42	1216.43	1212.67	1215.42	107304.0
2011-09-16 00:00:00	NQ	Futures	2638.15	2638.73	2634.11	2635.84	361.0
2011-09-16 01:00:00	NQ	Futures	2636.42	2637.29	2633.25	2635.84	347.0
2011-09-16 02:00:00	NQ	Futures	2635.27	2636.42	2629.79	2632.67	1277.0
2011-09-16 03:00:00	NQ	Futures	2632.96	2633.83	2623.16	2624.02	4030.0
2011-09-16 04:00:00	NQ	Futures	2624.02	2624.89	2617.1	2620.85	3677.0
2011-09-16 05:00:00	NQ	Futures	2620.85	2630.94	2620.56	2626.04	2941.0
2011-09-16 06:00:00	NQ	Futures	2626.62	2634.69	2621.43	2630.65	4514.0
2011-09-16 07:00:00	NQ	Futures	2630.08	2632.38	2623.45	2626.91	4078.0
2011-09-16 08:00:00	NQ	Futures	2627.48	2635.56	2622.58	2634.4	6866.0
2011-09-16 09:00:00	NQ	Futures	2634.11	2651.41	2631.52	2643.34	62268.0
2011-09-16 10:00:00	NQ	Futures	2643.63	2657.18	2631.23	2636.42	71105.0
2011-09-16 11:00:00	NQ	Futures	2636.42	2650.84	2634.69	2648.24	41002.0
2011-09-16 12:00:00	NQ	Futures	2648.53	2656.03	2645.07	2651.7	28315.0
2011-09-16 13:00:00	NQ	Futures	2651.7	2651.99	2640.46	2644.21	16827.0
2011-09-16 14:00:00	NQ	Futures	2643.92	2651.99	2643.63	2651.7	13970.0
2011-09-16 15:00:00	NQ	Futures	2651.7	2653.43	2644.21	2653.43	33625.0
2011-09-16 16:00:00	NQ	Futures	2653.14	2662.08	2651.41	2660.64	11584.0
2011-09-16 00:00:00	YM	Futures	11221.0	11224.0	11204.3	11212.2	270.0
2011-09-16 01:00:00	YM	Futures	11212.2	11221.0	11202.3	11213.2	264.0
2011-09-16 02:00:00	YM	Futures	11210.2	11211.2	11185.6	11199.4	572.0
2011-09-16 03:00:00	YM	Futures	11199.4	11203.3	11147.2	11148.2	1357.0
2011-09-16 04:00:00	YM	Futures	11151.1	11153.1	11124.5	11143.3	1580.0
2011-09-16 05:00:00	YM	Futures	11142.3	11187.6	11142.3	11167.9	1136.0
2011-09-16 06:00:00	YM	Futures	11167.9	11200.4	11145.2	11177.7	1493.0
2011-09-16 07:00:00	YM	Futures	11175.7	11183.6	11140.3	11160.0	1203.0
2011-09-16 08:00:00	YM	Futures	11159.0	11196.4	11134.4	11191.5	2381.0
2011-09-16 09:00:00	YM	Futures	11192.5	11282.1	11181.7	11240.7	21626.0
2011-09-16 10:00:00	YM	Futures	11241.7	11283.1	11156.1	11182.6	25524.0
2011-09-16 11:00:00	YM	Futures	11182.6	11233.8	11162.9	11226.9	16737.0
2011-09-16 12:00:00	YM	Futures	11227.9	11278.1	11222.0	11259.4	8531.0
2011-09-16 13:00:00	YM	Futures	11259.4	11260.4	11208.2	11228.9	7177.0
2011-09-16 14:00:00	YM	Futures	11230.9	11262.4	11226.9	11262.4	5662.0
2011-09-16 15:00:00	YM	Futures	11262.4	11266.3	11214.1	11257.5	14326.0

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

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