PREVIEW / futures_1hour / 2011-11-20

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-20.parquet
  size:    13 KB
  rows:    258

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-11-20 18:00:00	ES	Futures	1211.66	1212.67	1204.64	1210.66	29104.0
2011-11-20 19:00:00	ES	Futures	1210.66	1210.91	1207.15	1207.15	10060.0
2011-11-20 20:00:00	ES	Futures	1207.15	1208.15	1205.64	1206.15	11054.0
2011-11-20 21:00:00	ES	Futures	1206.15	1208.65	1205.64	1208.4	7784.0
2011-11-20 22:00:00	ES	Futures	1208.4	1210.41	1208.15	1208.4	4961.0
2011-11-20 23:00:00	ES	Futures	1208.65	1210.41	1207.9	1209.66	3310.0
2011-11-20 18:00:00	NQ	Futures	2587.98	2587.98	2576.45	2583.37	1905.0
2011-11-20 19:00:00	NQ	Futures	2583.08	2583.37	2574.43	2575.3	812.0
2011-11-20 20:00:00	NQ	Futures	2575.01	2577.89	2572.99	2575.01	667.0
2011-11-20 21:00:00	NQ	Futures	2574.72	2579.33	2573.85	2578.76	721.0
2011-11-20 22:00:00	NQ	Futures	2578.76	2582.5	2577.89	2578.18	464.0
2011-11-20 23:00:00	NQ	Futures	2578.18	2581.64	2576.74	2580.77	279.0
2011-11-20 18:00:00	YM	Futures	11540.0	11540.0	11438.6	11529.2	1094.0
2011-11-20 19:00:00	YM	Futures	11528.2	11529.2	11500.6	11504.6	603.0
2011-11-20 20:00:00	YM	Futures	11502.6	11512.5	11492.8	11495.7	412.0
2011-11-20 21:00:00	YM	Futures	11494.7	11518.4	11492.8	11516.4	381.0
2011-11-20 22:00:00	YM	Futures	11518.4	11531.2	11513.4	11518.4	298.0
2011-11-20 23:00:00	YM	Futures	11516.4	11529.2	11510.5	11523.3	187.0
2011-11-20 18:00:00	CL	Futures	164.81	165.23	164.4	165.1	1163.0
2011-11-20 19:00:00	CL	Futures	165.1	165.1	164.0	164.13	1004.0
2011-11-20 20:00:00	CL	Futures	164.12	164.76	164.08	164.57	866.0
2011-11-20 21:00:00	CL	Futures	164.54	165.35	164.51	165.08	630.0
2011-11-20 22:00:00	CL	Futures	165.08	165.35	165.08	165.13	331.0
2011-11-20 23:00:00	CL	Futures	165.1	165.15	164.44	164.62	532.0
2011-11-20 18:00:00	GC	Futures	2402.4	2402.4	2390.4	2397.2	1409.0
2011-11-20 19:00:00	GC	Futures	2397.2	2397.4	2390.9	2392.8	1258.0
2011-11-20 20:00:00	GC	Futures	2392.9	2395.0	2385.8	2390.9	3108.0
2011-11-20 21:00:00	GC	Futures	2390.9	2399.3	2390.3	2396.9	1600.0
2011-11-20 22:00:00	GC	Futures	2396.8	2403.5	2395.4	2400.6	1340.0
2011-11-20 23:00:00	GC	Futures	2400.3	2401.0	2395.3	2398.3	1336.0
2011-11-20 18:00:00	ZN	Futures	113.075312	113.224398	113.061758	113.129525	6505.0
2011-11-20 19:00:00	ZN	Futures	113.129525	113.210845	113.129525	113.210845	3990.0
2011-11-20 20:00:00	ZN	Futures	113.210845	113.237951	113.170185	113.183738	3535.0
2011-11-20 21:00:00	ZN	Futures	113.183738	113.197291	113.170185	113.197291	940.0
2011-11-20 22:00:00	ZN	Futures	113.197291	113.197291	113.143078	113.170185	2041.0
2011-11-20 23:00:00	ZN	Futures	113.170185	113.183738	113.129525	113.143078	1230.0

> showing 36 of 258 rows — these rows as CSV

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