PREVIEW / futures_1hour / 2011-08-03

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-08-03.parquet
  size:    50 KB
  rows:    1,493

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-08-03 00:00:00	ES	Futures	1245.28	1246.28	1244.53	1245.53	3477.0
2011-08-03 01:00:00	ES	Futures	1245.78	1245.78	1244.28	1245.28	3810.0
2011-08-03 02:00:00	ES	Futures	1245.53	1247.03	1241.29	1244.03	35870.0
2011-08-03 03:00:00	ES	Futures	1244.03	1253.76	1242.54	1250.77	108836.0
2011-08-03 04:00:00	ES	Futures	1251.02	1254.76	1250.02	1251.52	45761.0
2011-08-03 05:00:00	ES	Futures	1252.02	1253.26	1249.27	1251.27	25422.0
2011-08-03 06:00:00	ES	Futures	1251.27	1254.26	1250.27	1252.51	26544.0
2011-08-03 07:00:00	ES	Futures	1252.27	1252.51	1247.28	1249.52	62194.0
2011-08-03 08:00:00	ES	Futures	1249.77	1252.27	1245.28	1250.77	114513.0
2011-08-03 09:00:00	ES	Futures	1250.77	1251.77	1242.54	1248.03	322667.0
2011-08-03 10:00:00	ES	Futures	1248.27	1251.02	1227.32	1238.55	912954.0
2011-08-03 11:00:00	ES	Futures	1238.55	1245.78	1235.8	1240.79	620689.0
2011-08-03 12:00:00	ES	Futures	1240.79	1241.29	1233.81	1239.55	272220.0
2011-08-03 13:00:00	ES	Futures	1239.3	1252.51	1236.55	1248.03	299437.0
2011-08-03 14:00:00	ES	Futures	1248.27	1251.27	1243.54	1248.03	259103.0
2011-08-03 15:00:00	ES	Futures	1248.27	1255.01	1245.78	1254.01	518171.0
2011-08-03 16:00:00	ES	Futures	1254.26	1254.26	1249.02	1251.77	113725.0
2011-08-03 17:00:00	ES	Futures	1251.77	1253.01	1251.27	1252.02	3967.0
2011-08-03 18:00:00	ES	Futures	1253.01	1254.51	1251.77	1254.26	7430.0
2011-08-03 19:00:00	ES	Futures	1254.51	1256.26	1254.26	1255.76	5986.0
2011-08-03 20:00:00	ES	Futures	1256.01	1256.51	1253.51	1256.01	10215.0
2011-08-03 21:00:00	ES	Futures	1256.01	1261.24	1256.01	1258.5	32300.0
2011-08-03 22:00:00	ES	Futures	1258.25	1259.25	1254.51	1255.76	10083.0
2011-08-03 23:00:00	ES	Futures	1255.76	1258.0	1255.01	1257.75	5460.0
2011-08-03 00:00:00	NQ	Futures	2633.92	2637.66	2632.19	2635.07	447.0
2011-08-03 01:00:00	NQ	Futures	2635.07	2635.64	2632.48	2633.63	270.0
2011-08-03 02:00:00	NQ	Futures	2633.92	2637.37	2621.25	2631.04	3017.0
2011-08-03 03:00:00	NQ	Futures	2630.75	2644.85	2628.16	2640.82	9266.0
2011-08-03 04:00:00	NQ	Futures	2640.82	2647.15	2640.53	2645.43	4499.0
2011-08-03 05:00:00	NQ	Futures	2645.43	2648.88	2642.26	2645.43	2440.0
2011-08-03 06:00:00	NQ	Futures	2645.71	2651.47	2643.41	2648.3	2571.0
2011-08-03 07:00:00	NQ	Futures	2648.02	2648.02	2637.94	2641.11	4558.0
2011-08-03 08:00:00	NQ	Futures	2641.11	2646.29	2635.64	2643.7	10171.0
2011-08-03 09:00:00	NQ	Futures	2643.99	2648.3	2629.6	2647.44	48438.0
2011-08-03 10:00:00	NQ	Futures	2648.02	2651.47	2593.34	2621.25	109220.0
2011-08-03 11:00:00	NQ	Futures	2621.25	2643.99	2616.07	2634.2	79036.0
2011-08-03 12:00:00	NQ	Futures	2634.2	2635.07	2617.23	2630.75	32153.0
2011-08-03 13:00:00	NQ	Futures	2630.46	2658.66	2623.56	2650.32	36581.0
2011-08-03 14:00:00	NQ	Futures	2650.61	2657.51	2642.84	2653.2	30435.0
2011-08-03 15:00:00	NQ	Futures	2653.2	2664.13	2648.59	2660.1	60996.0
2011-08-03 16:00:00	NQ	Futures	2659.81	2660.39	2650.61	2653.2	9795.0
2011-08-03 17:00:00	NQ	Futures	2652.62	2655.21	2652.04	2653.2	67.0
2011-08-03 18:00:00	NQ	Futures	2654.06	2657.8	2653.77	2657.51	300.0
2011-08-03 19:00:00	NQ	Futures	2657.8	2660.97	2656.94	2660.68	369.0
2011-08-03 20:00:00	NQ	Futures	2660.1	2660.97	2655.21	2660.39	559.0
2011-08-03 21:00:00	NQ	Futures	2660.39	2669.89	2660.1	2664.71	1875.0
2011-08-03 22:00:00	NQ	Futures	2664.42	2665.57	2655.79	2658.95	936.0
2011-08-03 23:00:00	NQ	Futures	2658.66	2662.98	2657.8	2662.4	317.0
2011-08-03 00:00:00	YM	Futures	11429.0	11434.9	11421.3	11428.1	216.0
2011-08-03 01:00:00	YM	Futures	11428.1	11434.9	11424.2	11430.0	362.0

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

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