PREVIEW / futures_1hour / 2011-05-11

all futures 1-hour files

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

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-11 00:00:00	ES	Futures	1346.49	1346.99	1345.75	1345.75	2861.0
2011-05-11 01:00:00	ES	Futures	1345.75	1346.49	1345.5	1346.25	4232.0
2011-05-11 02:00:00	ES	Futures	1346.25	1346.99	1345.75	1346.49	5509.0
2011-05-11 03:00:00	ES	Futures	1346.49	1346.49	1344.26	1346.49	21809.0
2011-05-11 04:00:00	ES	Futures	1346.25	1347.24	1345.5	1346.25	13634.0
2011-05-11 05:00:00	ES	Futures	1346.25	1349.72	1346.0	1348.73	21908.0
2011-05-11 06:00:00	ES	Futures	1348.73	1349.47	1346.99	1347.49	14148.0
2011-05-11 07:00:00	ES	Futures	1347.49	1348.73	1345.25	1345.5	27348.0
2011-05-11 08:00:00	ES	Futures	1345.5	1346.25	1343.51	1345.0	43719.0
2011-05-11 09:00:00	ES	Futures	1345.0	1346.0	1339.79	1341.03	218717.0
2011-05-11 10:00:00	ES	Futures	1340.78	1341.28	1337.3	1339.54	283632.0
2011-05-11 11:00:00	ES	Futures	1339.29	1340.78	1335.07	1336.06	184322.0
2011-05-11 12:00:00	ES	Futures	1336.06	1336.31	1326.37	1330.59	434177.0
2011-05-11 13:00:00	ES	Futures	1330.59	1331.34	1324.63	1328.11	283113.0
2011-05-11 14:00:00	ES	Futures	1328.11	1329.85	1325.13	1328.11	168486.0
2011-05-11 15:00:00	ES	Futures	1328.11	1332.33	1326.87	1331.09	339106.0
2011-05-11 16:00:00	ES	Futures	1331.09	1331.59	1327.12	1327.36	104059.0
2011-05-11 17:00:00	ES	Futures	1327.12	1327.86	1326.37	1326.87	4633.0
2011-05-11 18:00:00	ES	Futures	1327.36	1328.61	1326.37	1328.36	4864.0
2011-05-11 19:00:00	ES	Futures	1328.36	1328.61	1327.36	1327.61	3423.0
2011-05-11 20:00:00	ES	Futures	1327.61	1330.35	1327.12	1330.35	8575.0
2011-05-11 21:00:00	ES	Futures	1330.35	1331.09	1327.12	1327.61	9876.0
2011-05-11 22:00:00	ES	Futures	1327.61	1330.35	1327.12	1329.6	4549.0
2011-05-11 23:00:00	ES	Futures	1329.6	1330.84	1329.35	1330.1	3017.0
2011-05-11 00:00:00	NQ	Futures	2773.16	2773.74	2770.0	2770.58	363.0
2011-05-11 01:00:00	NQ	Futures	2770.86	2772.88	2770.86	2772.88	321.0
2011-05-11 02:00:00	NQ	Futures	2772.59	2773.74	2769.71	2772.3	745.0
2011-05-11 03:00:00	NQ	Futures	2772.3	2772.3	2767.42	2771.44	1231.0
2011-05-11 04:00:00	NQ	Futures	2771.44	2772.88	2769.43	2770.58	1044.0
2011-05-11 05:00:00	NQ	Futures	2770.58	2775.17	2770.58	2772.59	2267.0
2011-05-11 06:00:00	NQ	Futures	2772.59	2774.02	2769.43	2770.86	1599.0
2011-05-11 07:00:00	NQ	Futures	2770.86	2772.88	2767.42	2767.99	2695.0
2011-05-11 08:00:00	NQ	Futures	2767.7	2768.85	2763.97	2765.69	3840.0
2011-05-11 09:00:00	NQ	Futures	2765.69	2773.74	2760.52	2768.57	37640.0
2011-05-11 10:00:00	NQ	Futures	2768.57	2772.3	2762.53	2765.98	30451.0
2011-05-11 11:00:00	NQ	Futures	2766.27	2768.28	2752.76	2754.2	27147.0
2011-05-11 12:00:00	NQ	Futures	2753.91	2754.49	2734.37	2743.86	56537.0
2011-05-11 13:00:00	NQ	Futures	2743.86	2744.72	2728.34	2734.37	63943.0
2011-05-11 14:00:00	NQ	Futures	2734.66	2742.42	2731.5	2738.97	17861.0
2011-05-11 15:00:00	NQ	Futures	2738.68	2750.75	2737.25	2747.88	36072.0
2011-05-11 16:00:00	NQ	Futures	2747.88	2752.19	2738.11	2738.11	11106.0
2011-05-11 17:00:00	NQ	Futures	2738.68	2739.83	2733.23	2737.54	1272.0
2011-05-11 18:00:00	NQ	Futures	2737.82	2741.56	2736.96	2740.98	241.0
2011-05-11 19:00:00	NQ	Futures	2740.7	2740.7	2738.97	2738.97	288.0
2011-05-11 20:00:00	NQ	Futures	2739.26	2745.01	2738.68	2744.72	1002.0
2011-05-11 21:00:00	NQ	Futures	2744.72	2745.58	2738.4	2739.26	501.0
2011-05-11 22:00:00	NQ	Futures	2738.97	2744.43	2738.68	2742.99	278.0
2011-05-11 23:00:00	NQ	Futures	2742.71	2745.58	2742.42	2744.43	248.0
2011-05-11 00:00:00	YM	Futures	12249.8	12251.7	12238.3	12238.3	299.0
2011-05-11 01:00:00	YM	Futures	12239.2	12247.9	12239.2	12245.0	157.0

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

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