PREVIEW / futures_1hour / 2011-05-12

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-12.parquet
  size:    50 KB
  rows:    1,491

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-05-12 00:00:00	ES	Futures	1330.35	1330.84	1329.6	1330.59	2067.0
2011-05-12 01:00:00	ES	Futures	1330.35	1330.59	1326.62	1326.62	7264.0
2011-05-12 02:00:00	ES	Futures	1326.87	1327.36	1324.88	1325.13	13107.0
2011-05-12 03:00:00	ES	Futures	1325.13	1327.36	1323.89	1326.12	32343.0
2011-05-12 04:00:00	ES	Futures	1326.12	1326.37	1321.9	1323.64	28967.0
2011-05-12 05:00:00	ES	Futures	1323.64	1324.13	1321.65	1322.4	27873.0
2011-05-12 06:00:00	ES	Futures	1322.4	1324.13	1320.66	1323.39	36931.0
2011-05-12 07:00:00	ES	Futures	1323.39	1325.38	1322.15	1324.88	32740.0
2011-05-12 08:00:00	ES	Futures	1324.63	1326.37	1321.9	1324.38	85961.0
2011-05-12 09:00:00	ES	Futures	1324.63	1328.36	1320.41	1323.64	355721.0
2011-05-12 10:00:00	ES	Futures	1323.64	1328.11	1320.91	1324.63	358187.0
2011-05-12 11:00:00	ES	Futures	1324.63	1332.33	1323.14	1329.1	339076.0
2011-05-12 12:00:00	ES	Futures	1329.1	1333.33	1328.11	1332.83	167204.0
2011-05-12 13:00:00	ES	Futures	1332.58	1339.04	1332.58	1337.8	282809.0
2011-05-12 14:00:00	ES	Futures	1338.05	1340.28	1335.31	1335.56	162990.0
2011-05-12 15:00:00	ES	Futures	1335.31	1339.04	1334.57	1337.55	196906.0
2011-05-12 16:00:00	ES	Futures	1337.55	1339.54	1337.3	1338.3	80533.0
2011-05-12 17:00:00	ES	Futures	1338.3	1339.54	1338.05	1339.04	1926.0
2011-05-12 18:00:00	ES	Futures	1339.29	1339.29	1338.05	1338.3	2829.0
2011-05-12 19:00:00	ES	Futures	1338.3	1339.54	1338.3	1338.79	1641.0
2011-05-12 20:00:00	ES	Futures	1338.79	1339.04	1337.3	1337.8	8614.0
2011-05-12 21:00:00	ES	Futures	1337.8	1338.54	1336.8	1338.05	7940.0
2011-05-12 22:00:00	ES	Futures	1338.05	1338.05	1336.8	1337.3	3332.0
2011-05-12 23:00:00	ES	Futures	1337.3	1337.3	1335.07	1336.31	12407.0
2011-05-12 00:00:00	NQ	Futures	2744.14	2746.44	2743.28	2746.15	270.0
2011-05-12 01:00:00	NQ	Futures	2745.87	2746.44	2737.82	2737.82	636.0
2011-05-12 02:00:00	NQ	Futures	2738.4	2738.97	2731.5	2732.94	1353.0
2011-05-12 03:00:00	NQ	Futures	2733.23	2737.54	2730.35	2734.95	2085.0
2011-05-12 04:00:00	NQ	Futures	2735.24	2735.24	2727.48	2731.21	2203.0
2011-05-12 05:00:00	NQ	Futures	2730.93	2732.08	2726.33	2728.92	2168.0
2011-05-12 06:00:00	NQ	Futures	2728.63	2732.94	2727.19	2731.79	2167.0
2011-05-12 07:00:00	NQ	Futures	2731.79	2734.66	2729.2	2733.8	4185.0
2011-05-12 08:00:00	NQ	Futures	2733.8	2736.67	2728.34	2734.37	8242.0
2011-05-12 09:00:00	NQ	Futures	2734.09	2742.13	2722.59	2733.8	56817.0
2011-05-12 10:00:00	NQ	Futures	2734.37	2747.3	2729.49	2736.96	58317.0
2011-05-12 11:00:00	NQ	Futures	2736.96	2752.76	2734.37	2745.87	38643.0
2011-05-12 12:00:00	NQ	Futures	2745.87	2753.91	2745.29	2752.76	17540.0
2011-05-12 13:00:00	NQ	Futures	2753.05	2763.39	2752.76	2761.38	27608.0
2011-05-12 14:00:00	NQ	Futures	2761.38	2767.7	2757.36	2758.8	25548.0
2011-05-12 15:00:00	NQ	Futures	2758.51	2765.69	2756.5	2763.39	28102.0
2011-05-12 16:00:00	NQ	Futures	2763.39	2768.85	2761.96	2766.27	7236.0
2011-05-12 17:00:00	NQ	Futures	2765.69	2767.13	2765.12	2765.98	66.0
2011-05-12 18:00:00	NQ	Futures	2766.27	2767.42	2764.54	2764.54	266.0
2011-05-12 19:00:00	NQ	Futures	2764.83	2766.27	2764.54	2765.4	183.0
2011-05-12 20:00:00	NQ	Futures	2765.12	2766.55	2762.53	2763.97	471.0
2011-05-12 21:00:00	NQ	Futures	2764.26	2765.12	2760.23	2761.67	689.0
2011-05-12 22:00:00	NQ	Futures	2761.67	2762.24	2760.52	2761.38	306.0
2011-05-12 23:00:00	NQ	Futures	2761.1	2761.67	2758.51	2759.95	663.0
2011-05-12 00:00:00	YM	Futures	12134.2	12137.1	12130.4	12137.1	119.0
2011-05-12 01:00:00	YM	Futures	12136.2	12137.1	12104.4	12107.3	412.0

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

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