PREVIEW / futures_1hour / 2012-02-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-02-01.parquet
  size:    50 KB
  rows:    1,516

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-02-01 00:00:00	ES	Futures	1316.13	1316.89	1315.63	1316.64	2970.0
2012-02-01 01:00:00	ES	Futures	1316.89	1317.14	1315.38	1315.63	4044.0
2012-02-01 02:00:00	ES	Futures	1315.38	1317.39	1314.12	1317.14	9854.0
2012-02-01 03:00:00	ES	Futures	1317.39	1324.2	1317.39	1323.44	40281.0
2012-02-01 04:00:00	ES	Futures	1323.44	1329.24	1323.44	1328.98	50250.0
2012-02-01 05:00:00	ES	Futures	1328.98	1329.24	1326.72	1328.23	19068.0
2012-02-01 06:00:00	ES	Futures	1328.23	1328.73	1326.97	1327.22	17760.0
2012-02-01 07:00:00	ES	Futures	1327.22	1330.75	1325.71	1328.23	52140.0
2012-02-01 08:00:00	ES	Futures	1327.98	1328.23	1325.96	1326.97	58923.0
2012-02-01 09:00:00	ES	Futures	1327.22	1331.25	1326.72	1328.73	201439.0
2012-02-01 10:00:00	ES	Futures	1328.73	1334.02	1327.22	1333.52	325987.0
2012-02-01 11:00:00	ES	Futures	1333.52	1334.53	1331.25	1333.02	230754.0
2012-02-01 12:00:00	ES	Futures	1333.27	1336.04	1333.02	1335.03	142713.0
2012-02-01 13:00:00	ES	Futures	1335.28	1337.55	1334.28	1334.53	157775.0
2012-02-01 14:00:00	ES	Futures	1334.53	1335.54	1333.27	1334.53	119158.0
2012-02-01 15:00:00	ES	Futures	1334.53	1336.29	1329.24	1330.75	324357.0
2012-02-01 16:00:00	ES	Futures	1330.5	1331.5	1329.74	1331.0	100578.0
2012-02-01 17:00:00	ES	Futures	1331.25	1332.01	1330.75	1331.76	1922.0
2012-02-01 18:00:00	ES	Futures	1331.76	1332.51	1331.25	1331.5	4385.0
2012-02-01 19:00:00	ES	Futures	1331.25	1335.28	1331.25	1333.77	10415.0
2012-02-01 20:00:00	ES	Futures	1334.02	1335.28	1333.02	1333.52	6909.0
2012-02-01 21:00:00	ES	Futures	1333.52	1333.77	1332.76	1333.02	2691.0
2012-02-01 22:00:00	ES	Futures	1333.02	1333.52	1332.51	1332.76	2019.0
2012-02-01 23:00:00	ES	Futures	1332.76	1333.77	1331.5	1331.76	2807.0
2012-02-01 00:00:00	NQ	Futures	2836.87	2837.73	2836.0	2837.73	131.0
2012-02-01 01:00:00	NQ	Futures	2838.02	2838.02	2835.71	2836.87	411.0
2012-02-01 02:00:00	NQ	Futures	2836.87	2840.04	2834.27	2840.04	710.0
2012-02-01 03:00:00	NQ	Futures	2839.75	2852.46	2839.75	2850.44	3006.0
2012-02-01 04:00:00	NQ	Futures	2850.15	2863.44	2850.15	2862.28	3607.0
2012-02-01 05:00:00	NQ	Futures	2862.86	2862.86	2857.66	2861.99	2097.0
2012-02-01 06:00:00	NQ	Futures	2861.7	2865.75	2859.97	2862.86	2638.0
2012-02-01 07:00:00	NQ	Futures	2862.86	2869.79	2859.68	2862.57	4952.0
2012-02-01 08:00:00	NQ	Futures	2862.86	2863.44	2858.24	2859.68	9048.0
2012-02-01 09:00:00	NQ	Futures	2859.68	2867.48	2855.06	2858.81	30946.0
2012-02-01 10:00:00	NQ	Futures	2859.1	2868.35	2853.91	2867.48	37511.0
2012-02-01 11:00:00	NQ	Futures	2867.77	2874.41	2862.86	2871.52	28411.0
2012-02-01 12:00:00	NQ	Futures	2871.52	2877.01	2871.23	2874.99	11870.0
2012-02-01 13:00:00	NQ	Futures	2875.28	2881.34	2874.7	2875.85	14450.0
2012-02-01 14:00:00	NQ	Futures	2876.14	2878.16	2873.54	2875.28	11773.0
2012-02-01 15:00:00	NQ	Futures	2875.57	2877.88	2867.48	2870.08	32085.0
2012-02-01 16:00:00	NQ	Futures	2870.37	2876.14	2869.79	2875.57	10048.0
2012-02-01 17:00:00	NQ	Futures	2875.57	2876.14	2874.99	2875.57	83.0
2012-02-01 18:00:00	NQ	Futures	2874.99	2877.01	2874.99	2876.43	404.0
2012-02-01 19:00:00	NQ	Futures	2876.14	2882.21	2876.14	2880.76	756.0
2012-02-01 20:00:00	NQ	Futures	2880.76	2882.5	2878.74	2879.61	461.0
2012-02-01 21:00:00	NQ	Futures	2879.32	2879.9	2878.16	2878.45	225.0
2012-02-01 22:00:00	NQ	Futures	2878.16	2879.32	2877.3	2877.3	186.0
2012-02-01 23:00:00	NQ	Futures	2877.59	2879.32	2875.85	2876.43	260.0
2012-02-01 00:00:00	YM	Futures	12451.6	12459.6	12449.7	12458.6	164.0
2012-02-01 01:00:00	YM	Futures	12459.6	12459.6	12446.7	12449.7	450.0

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

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