PREVIEW / futures_1hour / 2011-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-16.parquet
  size:    40 KB
  rows:    1,190

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-12-16 00:00:00	ES	Futures	1228.44	1229.2	1224.91	1225.92	5840.0
2011-12-16 01:00:00	ES	Futures	1225.92	1230.21	1225.42	1229.95	7012.0
2011-12-16 02:00:00	ES	Futures	1229.95	1232.22	1228.69	1229.45	16156.0
2011-12-16 03:00:00	ES	Futures	1229.45	1229.45	1225.67	1227.43	35554.0
2011-12-16 04:00:00	ES	Futures	1227.18	1229.7	1226.68	1227.43	20737.0
2011-12-16 05:00:00	ES	Futures	1227.18	1231.47	1225.92	1228.69	23714.0
2011-12-16 06:00:00	ES	Futures	1228.95	1229.45	1226.43	1228.44	29280.0
2011-12-16 07:00:00	ES	Futures	1228.44	1231.72	1226.93	1229.95	44888.0
2011-12-16 08:00:00	ES	Futures	1230.21	1231.97	1228.95	1229.7	57834.0
2011-12-16 09:00:00	ES	Futures	1229.7	1230.96	1225.67	1229.45	343043.0
2011-12-16 10:00:00	ES	Futures	1229.45	1234.74	1228.19	1231.97	337846.0
2011-12-16 11:00:00	ES	Futures	1231.97	1232.98	1223.91	1224.16	267731.0
2011-12-16 12:00:00	ES	Futures	1223.91	1224.66	1217.86	1220.88	268020.0
2011-12-16 13:00:00	ES	Futures	1221.13	1223.91	1219.87	1220.88	158087.0
2011-12-16 14:00:00	ES	Futures	1220.88	1223.15	1218.61	1221.64	112728.0
2011-12-16 15:00:00	ES	Futures	1221.64	1223.91	1220.13	1221.39	243374.0
2011-12-16 16:00:00	ES	Futures	1221.39	1224.16	1219.37	1219.62	113859.0
2011-12-16 00:00:00	NQ	Futures	2582.15	2583.01	2574.35	2575.79	305.0
2011-12-16 01:00:00	NQ	Futures	2575.79	2584.75	2575.21	2584.17	344.0
2011-12-16 02:00:00	NQ	Futures	2584.17	2588.79	2581.57	2583.88	874.0
2011-12-16 03:00:00	NQ	Futures	2583.01	2583.01	2575.21	2578.1	2398.0
2011-12-16 04:00:00	NQ	Futures	2578.1	2582.43	2576.66	2578.68	1364.0
2011-12-16 05:00:00	NQ	Futures	2578.39	2587.34	2576.08	2582.43	1290.0
2011-12-16 06:00:00	NQ	Futures	2582.15	2583.88	2577.53	2582.15	1671.0
2011-12-16 07:00:00	NQ	Futures	2582.15	2587.63	2579.26	2585.32	1954.0
2011-12-16 08:00:00	NQ	Futures	2585.03	2593.12	2585.03	2589.65	7594.0
2011-12-16 09:00:00	NQ	Futures	2589.65	2600.63	2579.84	2599.47	39100.0
2011-12-16 10:00:00	NQ	Futures	2599.76	2615.65	2596.3	2611.03	34295.0
2011-12-16 11:00:00	NQ	Futures	2611.31	2612.76	2587.92	2588.5	22368.0
2011-12-16 12:00:00	NQ	Futures	2588.5	2589.08	2575.5	2581.57	30449.0
2011-12-16 13:00:00	NQ	Futures	2581.57	2588.79	2580.41	2582.15	18903.0
2011-12-16 14:00:00	NQ	Futures	2582.15	2586.48	2578.1	2581.86	12012.0
2011-12-16 15:00:00	NQ	Futures	2581.86	2585.9	2576.66	2579.84	24631.0
2011-12-16 16:00:00	NQ	Futures	2579.84	2587.63	2578.68	2579.26	10889.0
2011-12-16 00:00:00	YM	Futures	11770.7	11777.7	11740.0	11748.9	429.0
2011-12-16 01:00:00	YM	Futures	11746.9	11782.6	11745.9	11780.6	581.0
2011-12-16 02:00:00	YM	Futures	11781.6	11803.4	11772.7	11777.7	1183.0
2011-12-16 03:00:00	YM	Futures	11776.7	11777.7	11745.0	11761.8	2512.0
2011-12-16 04:00:00	YM	Futures	11759.8	11781.6	11755.9	11760.8	1205.0
2011-12-16 05:00:00	YM	Futures	11760.8	11793.5	11750.9	11770.7	1771.0
2011-12-16 06:00:00	YM	Futures	11771.7	11772.7	11747.9	11763.8	2180.0
2011-12-16 07:00:00	YM	Futures	11762.8	11792.5	11753.9	11780.6	1865.0
2011-12-16 08:00:00	YM	Futures	11779.6	11799.5	11774.7	11783.6	2927.0
2011-12-16 09:00:00	YM	Futures	11784.6	11789.6	11737.0	11756.8	16909.0
2011-12-16 10:00:00	YM	Futures	11757.8	11793.5	11745.0	11777.7	16139.0
2011-12-16 11:00:00	YM	Futures	11778.7	11782.6	11694.4	11697.4	11299.0
2011-12-16 12:00:00	YM	Futures	11697.4	11704.3	11641.9	11672.6	15021.0
2011-12-16 13:00:00	YM	Futures	11670.6	11704.3	11665.7	11674.6	10492.0
2011-12-16 14:00:00	YM	Futures	11675.6	11699.4	11659.7	11683.5	6265.0
2011-12-16 15:00:00	YM	Futures	11683.5	11700.4	11671.6	11679.5	10643.0

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

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