PREVIEW / futures_1hour / 2012-07-31

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-07-31.parquet
  size:    49 KB
  rows:    1,500

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-31 00:00:00	ES	Futures	1407.97	1408.48	1406.95	1408.48	3280.0
2012-07-31 01:00:00	ES	Futures	1408.48	1410.26	1407.97	1408.98	8340.0
2012-07-31 02:00:00	ES	Futures	1408.98	1409.49	1405.93	1406.44	7979.0
2012-07-31 03:00:00	ES	Futures	1406.7	1408.48	1404.66	1405.93	31227.0
2012-07-31 04:00:00	ES	Futures	1405.68	1408.48	1404.92	1406.7	30190.0
2012-07-31 05:00:00	ES	Futures	1406.95	1408.73	1406.19	1408.73	21620.0
2012-07-31 06:00:00	ES	Futures	1408.73	1409.75	1406.19	1406.7	21062.0
2012-07-31 07:00:00	ES	Futures	1406.7	1407.71	1405.42	1406.95	19560.0
2012-07-31 08:00:00	ES	Futures	1406.7	1407.2	1404.15	1405.17	49264.0
2012-07-31 09:00:00	ES	Futures	1405.17	1406.19	1401.36	1403.39	247398.0
2012-07-31 10:00:00	ES	Futures	1403.39	1405.42	1400.08	1403.9	342860.0
2012-07-31 11:00:00	ES	Futures	1403.9	1406.7	1402.63	1404.15	215704.0
2012-07-31 12:00:00	ES	Futures	1404.15	1404.41	1398.81	1399.32	129272.0
2012-07-31 13:00:00	ES	Futures	1399.32	1401.86	1398.56	1399.83	92157.0
2012-07-31 14:00:00	ES	Futures	1399.83	1404.15	1399.58	1400.85	121129.0
2012-07-31 15:00:00	ES	Futures	1401.1	1402.12	1397.03	1397.29	251953.0
2012-07-31 16:00:00	ES	Futures	1397.03	1397.8	1394.49	1396.52	149243.0
2012-07-31 17:00:00	ES	Futures	1396.27	1396.78	1395.51	1396.27	1879.0
2012-07-31 18:00:00	ES	Futures	1396.52	1396.52	1395.25	1395.76	3084.0
2012-07-31 19:00:00	ES	Futures	1396.02	1396.27	1395.51	1396.02	2279.0
2012-07-31 20:00:00	ES	Futures	1396.02	1396.27	1394.49	1395.0	8904.0
2012-07-31 21:00:00	ES	Futures	1395.0	1395.0	1393.73	1394.49	6644.0
2012-07-31 22:00:00	ES	Futures	1394.24	1396.52	1393.73	1395.51	7642.0
2012-07-31 23:00:00	ES	Futures	1395.51	1397.54	1395.25	1397.29	4602.0
2012-07-31 00:00:00	NQ	Futures	3068.43	3069.01	3065.24	3068.43	859.0
2012-07-31 01:00:00	NQ	Futures	3068.43	3072.2	3067.27	3069.88	595.0
2012-07-31 02:00:00	NQ	Futures	3069.59	3070.75	3063.5	3064.95	594.0
2012-07-31 03:00:00	NQ	Futures	3064.66	3068.14	3060.03	3062.92	3368.0
2012-07-31 04:00:00	NQ	Futures	3062.92	3069.01	3060.9	3064.37	3410.0
2012-07-31 05:00:00	NQ	Futures	3064.66	3068.72	3062.92	3068.72	1644.0
2012-07-31 06:00:00	NQ	Futures	3068.72	3071.04	3064.08	3065.53	1182.0
2012-07-31 07:00:00	NQ	Futures	3065.82	3068.14	3063.5	3067.56	2226.0
2012-07-31 08:00:00	NQ	Futures	3067.56	3069.3	3062.63	3064.95	6133.0
2012-07-31 09:00:00	NQ	Futures	3064.66	3075.68	3057.42	3063.21	40384.0
2012-07-31 10:00:00	NQ	Futures	3063.79	3073.07	3054.52	3067.85	47207.0
2012-07-31 11:00:00	NQ	Futures	3067.56	3073.94	3063.79	3066.98	20039.0
2012-07-31 12:00:00	NQ	Futures	3067.27	3067.56	3054.81	3056.55	20343.0
2012-07-31 13:00:00	NQ	Futures	3056.55	3065.53	3054.52	3061.48	12855.0
2012-07-31 14:00:00	NQ	Futures	3061.48	3070.46	3060.32	3062.05	13437.0
2012-07-31 15:00:00	NQ	Futures	3062.05	3064.95	3056.26	3056.84	25008.0
2012-07-31 16:00:00	NQ	Futures	3056.84	3058.58	3050.75	3056.26	11850.0
2012-07-31 17:00:00	NQ	Futures	3056.26	3057.42	3054.81	3056.84	134.0
2012-07-31 18:00:00	NQ	Futures	3056.55	3056.84	3054.81	3055.39	409.0
2012-07-31 19:00:00	NQ	Futures	3055.1	3056.26	3054.81	3055.97	185.0
2012-07-31 20:00:00	NQ	Futures	3056.26	3057.13	3052.78	3053.07	1129.0
2012-07-31 21:00:00	NQ	Futures	3053.07	3053.36	3049.59	3053.07	1133.0
2012-07-31 22:00:00	NQ	Futures	3052.78	3056.84	3051.04	3055.1	1087.0
2012-07-31 23:00:00	NQ	Futures	3055.1	3058.87	3054.81	3058.87	1006.0
2012-07-31 00:00:00	YM	Futures	12963.0	12968.0	12958.1	12968.0	620.0
2012-07-31 01:00:00	YM	Futures	12967.0	12982.9	12966.0	12969.0	487.0

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

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