PREVIEW / futures_1hour / 2011-12-13

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-12-13.parquet
  size:    47 KB
  rows:    1,426

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-13 00:00:00	ES	Futures	1241.5	1241.75	1237.99	1239.75	1390.0
2011-12-13 01:00:00	ES	Futures	1239.75	1241.25	1238.24	1241.25	1036.0
2011-12-13 02:00:00	ES	Futures	1241.25	1242.26	1238.24	1241.75	3280.0
2011-12-13 03:00:00	ES	Futures	1241.75	1245.26	1237.49	1240.0	12330.0
2011-12-13 04:00:00	ES	Futures	1240.0	1244.51	1236.74	1243.51	7571.0
2011-12-13 05:00:00	ES	Futures	1244.01	1246.52	1243.01	1245.26	6510.0
2011-12-13 06:00:00	ES	Futures	1245.52	1248.27	1245.01	1246.77	7088.0
2011-12-13 07:00:00	ES	Futures	1246.77	1248.02	1243.01	1247.77	7094.0
2011-12-13 08:00:00	ES	Futures	1247.77	1248.02	1243.76	1246.52	19383.0
2011-12-13 09:00:00	ES	Futures	1246.52	1253.04	1245.52	1251.28	33774.0
2011-12-13 10:00:00	ES	Futures	1251.28	1253.54	1242.76	1244.51	41150.0
2011-12-13 11:00:00	ES	Futures	1244.26	1246.77	1240.25	1246.52	38061.0
2011-12-13 12:00:00	ES	Futures	1246.52	1247.02	1242.76	1246.02	16390.0
2011-12-13 13:00:00	ES	Futures	1246.02	1246.77	1243.26	1245.77	20181.0
2011-12-13 14:00:00	ES	Futures	1245.77	1249.03	1233.98	1236.74	50056.0
2011-12-13 15:00:00	ES	Futures	1236.24	1239.25	1222.19	1228.46	69751.0
2011-12-13 16:00:00	ES	Futures	1228.46	1231.47	1227.96	1230.47	12729.0
2011-12-13 17:00:00	ES	Futures	1230.47	1230.72	1229.72	1229.97	308.0
2011-12-13 18:00:00	ES	Futures	1229.97	1231.97	1229.47	1229.97	839.0
2011-12-13 19:00:00	ES	Futures	1229.97	1232.23	1229.97	1231.47	922.0
2011-12-13 20:00:00	ES	Futures	1231.47	1231.97	1229.97	1231.72	901.0
2011-12-13 21:00:00	ES	Futures	1231.72	1232.73	1231.22	1232.23	915.0
2011-12-13 22:00:00	ES	Futures	1232.23	1233.48	1231.97	1232.73	531.0
2011-12-13 23:00:00	ES	Futures	1232.73	1233.48	1232.48	1232.98	234.0
2011-12-13 00:00:00	NQ	Futures	2650.55	2650.55	2645.36	2646.22	43.0
2011-12-13 01:00:00	NQ	Futures	2646.51	2650.26	2644.78	2650.26	33.0
2011-12-13 02:00:00	NQ	Futures	2650.26	2653.72	2644.21	2651.99	236.0
2011-12-13 03:00:00	NQ	Futures	2649.68	2658.91	2642.48	2646.22	572.0
2011-12-13 04:00:00	NQ	Futures	2647.38	2655.74	2641.32	2653.43	268.0
2011-12-13 05:00:00	NQ	Futures	2653.43	2659.49	2653.43	2657.76	238.0
2011-12-13 06:00:00	NQ	Futures	2659.2	2663.81	2657.47	2662.95	212.0
2011-12-13 07:00:00	NQ	Futures	2660.06	2664.96	2653.14	2664.39	467.0
2011-12-13 08:00:00	NQ	Futures	2665.25	2666.12	2655.16	2663.23	789.0
2011-12-13 09:00:00	NQ	Futures	2663.52	2673.33	2660.93	2664.1	4277.0
2011-12-13 10:00:00	NQ	Futures	2665.25	2669.58	2643.92	2644.21	3377.0
2011-12-13 11:00:00	NQ	Futures	2643.92	2647.95	2634.4	2647.95	2358.0
2011-12-13 12:00:00	NQ	Futures	2647.95	2648.82	2641.03	2647.95	1107.0
2011-12-13 13:00:00	NQ	Futures	2647.38	2648.82	2641.61	2648.24	1334.0
2011-12-13 14:00:00	NQ	Futures	2648.53	2657.47	2626.33	2631.52	3907.0
2011-12-13 15:00:00	NQ	Futures	2629.79	2636.13	2604.42	2615.95	5847.0
2011-12-13 16:00:00	NQ	Futures	2615.37	2621.14	2613.93	2619.99	782.0
2011-12-13 17:00:00	NQ	Futures	2619.41	2619.41	2618.26	2618.83	3.0
2011-12-13 18:00:00	NQ	Futures	2617.39	2619.7	2615.66	2616.53	26.0
2011-12-13 19:00:00	NQ	Futures	2617.39	2623.16	2617.39	2621.72	22.0
2011-12-13 20:00:00	NQ	Futures	2622.0	2622.58	2619.7	2622.58	31.0
2011-12-13 21:00:00	NQ	Futures	2623.73	2624.6	2621.43	2624.6	38.0
2011-12-13 22:00:00	NQ	Futures	2624.6	2626.04	2623.16	2625.75	47.0
2011-12-13 23:00:00	NQ	Futures	2625.18	2625.18	2624.31	2624.6	5.0
2011-12-13 00:00:00	YM	Futures	11861.9	11861.9	11829.2	11842.1	600.0
2011-12-13 01:00:00	YM	Futures	11841.1	11857.0	11832.2	11855.0	320.0

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

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