PREVIEW / futures_1hour / 2012-07-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-18.parquet
  size:    50 KB
  rows:    1,525

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-07-18 00:00:00	ES	Futures	1378.47	1379.49	1378.22	1379.49	1910.0
2012-07-18 01:00:00	ES	Futures	1379.49	1379.49	1376.18	1376.44	9349.0
2012-07-18 02:00:00	ES	Futures	1376.44	1378.22	1376.44	1377.96	6920.0
2012-07-18 03:00:00	ES	Futures	1377.96	1378.98	1376.94	1377.45	18166.0
2012-07-18 04:00:00	ES	Futures	1377.71	1380.5	1376.94	1379.74	15563.0
2012-07-18 05:00:00	ES	Futures	1379.74	1380.0	1376.44	1376.69	23371.0
2012-07-18 06:00:00	ES	Futures	1376.69	1378.22	1375.93	1377.2	19423.0
2012-07-18 07:00:00	ES	Futures	1377.2	1378.22	1376.18	1377.45	19301.0
2012-07-18 08:00:00	ES	Futures	1377.45	1378.98	1375.67	1376.69	41834.0
2012-07-18 09:00:00	ES	Futures	1376.69	1386.86	1375.67	1385.34	286970.0
2012-07-18 10:00:00	ES	Futures	1385.08	1390.17	1384.83	1389.66	345128.0
2012-07-18 11:00:00	ES	Futures	1389.91	1390.93	1387.88	1389.91	201452.0
2012-07-18 12:00:00	ES	Futures	1390.17	1393.98	1389.91	1392.71	172691.0
2012-07-18 13:00:00	ES	Futures	1392.96	1393.22	1389.66	1390.93	123805.0
2012-07-18 14:00:00	ES	Futures	1390.68	1392.2	1386.86	1388.64	150158.0
2012-07-18 15:00:00	ES	Futures	1388.64	1392.2	1388.39	1391.18	240349.0
2012-07-18 16:00:00	ES	Futures	1390.93	1393.98	1389.4	1393.47	95522.0
2012-07-18 17:00:00	ES	Futures	1393.47	1395.51	1393.47	1395.0	7215.0
2012-07-18 18:00:00	ES	Futures	1395.25	1395.25	1392.96	1393.22	3652.0
2012-07-18 19:00:00	ES	Futures	1393.22	1393.22	1392.46	1392.96	2246.0
2012-07-18 20:00:00	ES	Futures	1393.22	1394.74	1393.22	1394.49	6169.0
2012-07-18 21:00:00	ES	Futures	1394.24	1394.74	1393.22	1394.49	5896.0
2012-07-18 22:00:00	ES	Futures	1394.24	1395.51	1393.98	1395.25	4390.0
2012-07-18 23:00:00	ES	Futures	1395.0	1395.51	1394.49	1395.0	2368.0
2012-07-18 00:00:00	NQ	Futures	2994.22	2996.54	2993.93	2996.25	253.0
2012-07-18 01:00:00	NQ	Futures	2996.25	2996.25	2989.58	2990.45	567.0
2012-07-18 02:00:00	NQ	Futures	2990.74	2993.64	2990.16	2993.06	537.0
2012-07-18 03:00:00	NQ	Futures	2993.06	2995.38	2991.61	2993.93	2812.0
2012-07-18 04:00:00	NQ	Futures	2993.64	3000.02	2992.77	2998.57	1787.0
2012-07-18 05:00:00	NQ	Futures	2998.57	2998.86	2990.16	2991.03	2446.0
2012-07-18 06:00:00	NQ	Futures	2990.74	2993.35	2989.29	2991.32	2192.0
2012-07-18 07:00:00	NQ	Futures	2991.03	2993.06	2988.71	2991.03	2449.0
2012-07-18 08:00:00	NQ	Futures	2991.03	2994.22	2987.84	2990.74	3657.0
2012-07-18 09:00:00	NQ	Futures	2990.74	3024.08	2987.84	3021.76	43795.0
2012-07-18 10:00:00	NQ	Futures	3021.76	3032.2	3020.31	3030.75	43851.0
2012-07-18 11:00:00	NQ	Futures	3031.04	3039.15	3027.27	3037.41	25499.0
2012-07-18 12:00:00	NQ	Futures	3037.12	3047.85	3037.12	3043.79	25718.0
2012-07-18 13:00:00	NQ	Futures	3044.08	3045.53	3035.39	3037.41	17748.0
2012-07-18 14:00:00	NQ	Futures	3037.7	3040.89	3027.27	3031.62	21303.0
2012-07-18 15:00:00	NQ	Futures	3031.62	3041.18	3031.62	3038.57	32762.0
2012-07-18 16:00:00	NQ	Futures	3038.57	3049.59	3032.78	3048.72	15478.0
2012-07-18 17:00:00	NQ	Futures	3049.3	3053.07	3048.72	3053.07	1530.0
2012-07-18 18:00:00	NQ	Futures	3053.07	3053.65	3048.43	3049.01	1164.0
2012-07-18 19:00:00	NQ	Futures	3048.72	3049.01	3047.27	3048.72	309.0
2012-07-18 20:00:00	NQ	Futures	3049.01	3052.49	3048.72	3051.62	588.0
2012-07-18 21:00:00	NQ	Futures	3051.33	3052.49	3049.59	3051.62	594.0
2012-07-18 22:00:00	NQ	Futures	3051.33	3054.81	3051.04	3053.94	893.0
2012-07-18 23:00:00	NQ	Futures	3053.94	3057.13	3052.2	3056.84	1404.0
2012-07-18 00:00:00	YM	Futures	12638.9	12647.8	12637.9	12647.8	219.0
2012-07-18 01:00:00	YM	Futures	12645.8	12645.8	12621.0	12625.9	659.0

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

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