PREVIEW / futures_1hour / 2012-03-13

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-13.parquet
  size:    47 KB
  rows:    1,457

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-03-13 00:00:00	ES	Futures	1390.22	1390.72	1389.97	1389.97	981.0
2012-03-13 01:00:00	ES	Futures	1389.97	1390.22	1388.2	1389.21	1489.0
2012-03-13 02:00:00	ES	Futures	1389.21	1390.72	1388.96	1390.22	1348.0
2012-03-13 03:00:00	ES	Futures	1390.22	1390.72	1388.45	1388.71	3841.0
2012-03-13 04:00:00	ES	Futures	1388.96	1390.47	1388.2	1388.96	6579.0
2012-03-13 05:00:00	ES	Futures	1388.96	1391.98	1388.96	1391.98	5556.0
2012-03-13 06:00:00	ES	Futures	1391.98	1392.49	1390.97	1391.73	7493.0
2012-03-13 07:00:00	ES	Futures	1391.73	1391.98	1390.47	1390.47	6388.0
2012-03-13 08:00:00	ES	Futures	1390.47	1391.48	1388.71	1388.96	12602.0
2012-03-13 09:00:00	ES	Futures	1388.96	1390.22	1387.19	1387.7	28361.0
2012-03-13 10:00:00	ES	Futures	1387.7	1391.73	1386.94	1390.72	35837.0
2012-03-13 11:00:00	ES	Futures	1390.97	1394.75	1390.97	1393.49	27190.0
2012-03-13 12:00:00	ES	Futures	1393.49	1395.26	1393.24	1395.26	16812.0
2012-03-13 13:00:00	ES	Futures	1395.01	1396.01	1394.0	1394.25	12148.0
2012-03-13 14:00:00	ES	Futures	1394.25	1396.77	1391.98	1393.75	34050.0
2012-03-13 15:00:00	ES	Futures	1393.75	1407.6	1393.75	1406.85	75350.0
2012-03-13 16:00:00	ES	Futures	1407.1	1409.87	1402.82	1408.86	31954.0
2012-03-13 17:00:00	ES	Futures	1408.61	1409.37	1407.35	1407.6	1289.0
2012-03-13 18:00:00	ES	Futures	1407.1	1408.61	1406.6	1408.11	858.0
2012-03-13 19:00:00	ES	Futures	1408.11	1408.11	1406.6	1406.6	630.0
2012-03-13 20:00:00	ES	Futures	1406.85	1406.85	1404.33	1405.59	1934.0
2012-03-13 21:00:00	ES	Futures	1405.34	1406.35	1404.58	1405.34	1003.0
2012-03-13 22:00:00	ES	Futures	1405.59	1405.59	1404.83	1405.34	445.0
2012-03-13 23:00:00	ES	Futures	1405.09	1407.86	1405.09	1407.6	1476.0
2012-03-13 00:00:00	NQ	Futures	3077.72	3078.88	3076.86	3077.15	196.0
2012-03-13 01:00:00	NQ	Futures	3077.15	3077.15	3073.1	3075.12	69.0
2012-03-13 02:00:00	NQ	Futures	3075.41	3077.44	3074.84	3076.57	46.0
2012-03-13 03:00:00	NQ	Futures	3077.15	3077.44	3072.53	3073.97	129.0
2012-03-13 04:00:00	NQ	Futures	3074.26	3077.44	3071.37	3074.55	369.0
2012-03-13 05:00:00	NQ	Futures	3074.84	3080.32	3074.84	3080.32	485.0
2012-03-13 06:00:00	NQ	Futures	3080.61	3082.06	3078.59	3080.9	653.0
2012-03-13 07:00:00	NQ	Futures	3080.61	3082.06	3078.01	3078.59	1066.0
2012-03-13 08:00:00	NQ	Futures	3078.01	3079.17	3073.68	3075.12	1028.0
2012-03-13 09:00:00	NQ	Futures	3075.12	3081.19	3071.95	3076.57	4880.0
2012-03-13 10:00:00	NQ	Futures	3076.28	3083.5	3069.93	3082.63	3642.0
2012-03-13 11:00:00	NQ	Futures	3082.34	3093.61	3081.48	3090.14	3649.0
2012-03-13 12:00:00	NQ	Futures	3090.14	3095.05	3088.7	3094.76	3091.0
2012-03-13 13:00:00	NQ	Futures	3094.76	3096.21	3093.32	3094.47	1329.0
2012-03-13 14:00:00	NQ	Futures	3094.19	3098.52	3089.85	3094.47	3836.0
2012-03-13 15:00:00	NQ	Futures	3094.47	3117.0	3094.19	3116.71	8801.0
2012-03-13 16:00:00	NQ	Futures	3117.0	3121.62	3107.76	3119.6	1608.0
2012-03-13 17:00:00	NQ	Futures	3118.73	3119.6	3115.27	3116.13	62.0
2012-03-13 18:00:00	NQ	Futures	3115.27	3116.42	3114.11	3116.42	87.0
2012-03-13 19:00:00	NQ	Futures	3115.56	3115.56	3114.4	3114.4	25.0
2012-03-13 20:00:00	NQ	Futures	3114.11	3114.11	3110.07	3111.8	130.0
2012-03-13 21:00:00	NQ	Futures	3111.8	3113.54	3110.94	3112.38	74.0
2012-03-13 22:00:00	NQ	Futures	3111.51	3112.38	3110.36	3110.36	117.0
2012-03-13 23:00:00	NQ	Futures	3111.8	3115.56	3111.8	3114.98	110.0
2012-03-13 00:00:00	YM	Futures	12908.1	12915.0	12907.1	12908.1	217.0
2012-03-13 01:00:00	YM	Futures	12909.1	12911.0	12892.1	12901.1	465.0

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

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