PREVIEW / futures_1hour / 2011-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-11-27.parquet
  size:    14 KB
  rows:    260

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-27 18:00:00	ES	Futures	1175.55	1179.82	1172.8	1174.8	40928.0
2011-11-27 19:00:00	ES	Futures	1174.8	1178.56	1174.8	1178.06	16348.0
2011-11-27 20:00:00	ES	Futures	1177.81	1183.58	1177.81	1181.57	23828.0
2011-11-27 21:00:00	ES	Futures	1181.82	1182.32	1179.06	1181.57	8090.0
2011-11-27 22:00:00	ES	Futures	1181.57	1183.33	1174.05	1178.81	23713.0
2011-11-27 23:00:00	ES	Futures	1178.81	1179.57	1176.81	1178.31	6692.0
2011-11-27 18:00:00	NQ	Futures	2517.63	2524.84	2512.15	2515.33	3211.0
2011-11-27 19:00:00	NQ	Futures	2515.33	2520.8	2515.04	2520.23	959.0
2011-11-27 20:00:00	NQ	Futures	2520.52	2528.59	2520.23	2524.26	1341.0
2011-11-27 21:00:00	NQ	Futures	2524.55	2526.28	2519.94	2526.28	653.0
2011-11-27 22:00:00	NQ	Futures	2526.28	2528.88	2514.46	2522.82	1736.0
2011-11-27 23:00:00	NQ	Futures	2522.82	2523.97	2519.07	2521.67	616.0
2011-11-27 18:00:00	YM	Futures	11180.7	11202.3	11136.4	11148.2	2535.0
2011-11-27 19:00:00	YM	Futures	11148.2	11176.7	11148.2	11173.8	978.0
2011-11-27 20:00:00	YM	Futures	11174.8	11214.1	11173.8	11198.4	947.0
2011-11-27 21:00:00	YM	Futures	11200.4	11204.3	11179.7	11197.4	323.0
2011-11-27 22:00:00	YM	Futures	11198.4	11209.2	11142.3	11176.7	1218.0
2011-11-27 23:00:00	YM	Futures	11177.7	11182.6	11162.0	11172.8	235.0
2011-11-27 18:00:00	CL	Futures	164.74	166.2	164.71	165.84	3213.0
2011-11-27 19:00:00	CL	Futures	165.84	166.26	165.54	166.01	929.0
2011-11-27 20:00:00	CL	Futures	166.06	166.5	166.04	166.23	1449.0
2011-11-27 21:00:00	CL	Futures	166.26	166.26	165.96	166.25	631.0
2011-11-27 22:00:00	CL	Futures	166.25	166.5	165.6	165.76	1758.0
2011-11-27 23:00:00	CL	Futures	165.77	166.18	165.72	166.16	678.0
2011-11-27 18:00:00	GC	Futures	2346.1	2362.3	2345.3	2360.3	1359.0
2011-11-27 19:00:00	GC	Futures	2359.6	2368.8	2357.7	2368.0	1440.0
2011-11-27 20:00:00	GC	Futures	2368.0	2380.1	2367.8	2378.2	3498.0
2011-11-27 21:00:00	GC	Futures	2378.7	2380.5	2373.5	2376.4	2514.0
2011-11-27 22:00:00	GC	Futures	2376.4	2379.2	2372.4	2377.4	1568.0
2011-11-27 23:00:00	GC	Futures	2377.4	2378.7	2373.1	2377.4	1030.0
2011-11-27 18:00:00	ZN	Futures	112.993992	113.075312	112.912672	112.953332	19729.0
2011-11-27 19:00:00	ZN	Futures	112.953332	113.048205	112.926225	113.021098	12027.0
2011-11-27 20:00:00	ZN	Futures	113.021098	113.021098	112.966885	113.007545	6114.0
2011-11-27 21:00:00	ZN	Futures	112.993992	113.034652	112.980438	112.993992	4594.0
2011-11-27 22:00:00	ZN	Futures	112.980438	113.183738	112.980438	113.129525	14179.0
2011-11-27 23:00:00	ZN	Futures	113.115971	113.129525	113.088865	113.102418	2136.0

> showing 36 of 260 rows — these rows as CSV

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