PREVIEW / futures_1hour / 2011-05-05

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-05-05.parquet
  size:    52 KB
  rows:    1,498

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-05 00:00:00	ES	Futures	1339.04	1340.03	1338.54	1339.79	5011.0
2011-05-05 01:00:00	ES	Futures	1339.79	1340.28	1339.04	1339.54	3419.0
2011-05-05 02:00:00	ES	Futures	1339.54	1339.79	1336.8	1337.3	9422.0
2011-05-05 03:00:00	ES	Futures	1337.05	1339.04	1336.31	1337.8	20306.0
2011-05-05 04:00:00	ES	Futures	1337.8	1339.29	1334.32	1335.31	31211.0
2011-05-05 05:00:00	ES	Futures	1335.31	1335.81	1331.84	1332.33	36851.0
2011-05-05 06:00:00	ES	Futures	1332.08	1332.83	1327.86	1328.85	57464.0
2011-05-05 07:00:00	ES	Futures	1328.85	1330.59	1328.11	1329.85	29603.0
2011-05-05 08:00:00	ES	Futures	1329.85	1330.35	1324.38	1326.62	103340.0
2011-05-05 09:00:00	ES	Futures	1326.87	1330.35	1323.64	1329.1	310976.0
2011-05-05 10:00:00	ES	Futures	1329.35	1331.84	1326.37	1328.61	365854.0
2011-05-05 11:00:00	ES	Futures	1328.61	1333.82	1323.64	1333.08	456738.0
2011-05-05 12:00:00	ES	Futures	1332.83	1336.31	1331.84	1333.08	248196.0
2011-05-05 13:00:00	ES	Futures	1333.08	1334.82	1330.35	1331.84	115950.0
2011-05-05 14:00:00	ES	Futures	1331.84	1334.32	1328.36	1328.61	185648.0
2011-05-05 15:00:00	ES	Futures	1328.61	1329.1	1316.93	1323.14	770155.0
2011-05-05 16:00:00	ES	Futures	1323.14	1327.12	1323.14	1326.62	137247.0
2011-05-05 17:00:00	ES	Futures	1326.87	1328.11	1326.37	1327.86	2733.0
2011-05-05 18:00:00	ES	Futures	1327.61	1328.85	1326.87	1327.12	5352.0
2011-05-05 19:00:00	ES	Futures	1327.12	1327.36	1324.38	1325.38	7534.0
2011-05-05 20:00:00	ES	Futures	1325.63	1328.61	1325.13	1326.87	10697.0
2011-05-05 21:00:00	ES	Futures	1327.12	1328.11	1325.38	1327.61	6815.0
2011-05-05 22:00:00	ES	Futures	1327.36	1328.85	1327.12	1327.61	5794.0
2011-05-05 23:00:00	ES	Futures	1327.36	1328.36	1326.62	1326.87	4173.0
2011-05-05 00:00:00	NQ	Futures	2748.17	2751.33	2747.3	2750.18	624.0
2011-05-05 01:00:00	NQ	Futures	2749.89	2751.9	2749.32	2749.89	285.0
2011-05-05 02:00:00	NQ	Futures	2750.18	2751.9	2746.73	2748.45	1725.0
2011-05-05 03:00:00	NQ	Futures	2748.17	2752.19	2746.73	2751.04	2665.0
2011-05-05 04:00:00	NQ	Futures	2751.04	2753.05	2743.28	2744.43	2990.0
2011-05-05 05:00:00	NQ	Futures	2744.72	2746.15	2736.96	2737.25	2311.0
2011-05-05 06:00:00	NQ	Futures	2737.25	2737.82	2727.48	2729.49	3869.0
2011-05-05 07:00:00	NQ	Futures	2729.78	2732.36	2728.05	2732.36	2329.0
2011-05-05 08:00:00	NQ	Futures	2732.08	2733.8	2722.02	2727.48	10071.0
2011-05-05 09:00:00	NQ	Futures	2727.19	2740.7	2718.86	2738.97	56974.0
2011-05-05 10:00:00	NQ	Futures	2739.26	2746.44	2732.36	2739.55	69873.0
2011-05-05 11:00:00	NQ	Futures	2739.55	2751.61	2728.63	2750.75	60349.0
2011-05-05 12:00:00	NQ	Futures	2750.46	2757.93	2742.71	2746.73	35679.0
2011-05-05 13:00:00	NQ	Futures	2746.73	2751.9	2743.57	2748.74	17846.0
2011-05-05 14:00:00	NQ	Futures	2748.74	2753.62	2737.54	2738.68	26014.0
2011-05-05 15:00:00	NQ	Futures	2738.4	2739.83	2716.27	2726.04	87117.0
2011-05-05 16:00:00	NQ	Futures	2725.76	2735.81	2724.61	2732.94	10772.0
2011-05-05 17:00:00	NQ	Futures	2732.94	2734.95	2732.36	2734.95	218.0
2011-05-05 18:00:00	NQ	Futures	2734.37	2736.67	2731.21	2731.21	467.0
2011-05-05 19:00:00	NQ	Futures	2731.79	2731.79	2727.48	2729.49	540.0
2011-05-05 20:00:00	NQ	Futures	2729.78	2736.1	2729.2	2733.8	536.0
2011-05-05 21:00:00	NQ	Futures	2733.51	2735.52	2729.49	2734.66	548.0
2011-05-05 22:00:00	NQ	Futures	2734.66	2737.25	2732.08	2732.08	467.0
2011-05-05 23:00:00	NQ	Futures	2732.08	2734.37	2730.64	2731.21	257.0
2011-05-05 00:00:00	YM	Futures	12241.2	12251.7	12239.2	12249.8	354.0
2011-05-05 01:00:00	YM	Futures	12249.8	12251.7	12243.1	12244.0	372.0

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

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