PREVIEW / futures_1hour / 2012-01-31

all futures 1-hour files

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

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-01-31 00:00:00	ES	Futures	1321.17	1321.43	1319.41	1321.43	6025.0
2012-01-31 01:00:00	ES	Futures	1321.17	1322.43	1320.67	1321.93	4613.0
2012-01-31 02:00:00	ES	Futures	1321.68	1324.2	1321.43	1322.18	9209.0
2012-01-31 03:00:00	ES	Futures	1322.18	1325.2	1322.18	1324.2	31286.0
2012-01-31 04:00:00	ES	Futures	1323.94	1327.22	1323.69	1326.21	27842.0
2012-01-31 05:00:00	ES	Futures	1325.96	1327.72	1324.95	1327.47	16959.0
2012-01-31 06:00:00	ES	Futures	1327.22	1327.98	1324.95	1325.46	21105.0
2012-01-31 07:00:00	ES	Futures	1325.46	1326.46	1324.2	1325.2	23993.0
2012-01-31 08:00:00	ES	Futures	1325.2	1326.21	1324.2	1325.2	47777.0
2012-01-31 09:00:00	ES	Futures	1324.95	1327.98	1322.18	1322.18	311798.0
2012-01-31 10:00:00	ES	Futures	1322.18	1322.69	1314.62	1315.88	402038.0
2012-01-31 11:00:00	ES	Futures	1315.88	1316.89	1312.61	1314.62	268426.0
2012-01-31 12:00:00	ES	Futures	1314.62	1317.14	1313.87	1316.13	108792.0
2012-01-31 13:00:00	ES	Futures	1315.88	1318.65	1314.37	1315.38	78331.0
2012-01-31 14:00:00	ES	Futures	1315.38	1319.41	1314.62	1318.65	95353.0
2012-01-31 15:00:00	ES	Futures	1318.91	1320.17	1317.14	1318.4	281466.0
2012-01-31 16:00:00	ES	Futures	1318.15	1318.91	1316.39	1316.64	116856.0
2012-01-31 17:00:00	ES	Futures	1316.64	1317.65	1316.64	1317.65	2032.0
2012-01-31 18:00:00	ES	Futures	1317.65	1318.4	1316.39	1316.89	6381.0
2012-01-31 19:00:00	ES	Futures	1316.64	1318.15	1316.39	1318.15	5573.0
2012-01-31 20:00:00	ES	Futures	1318.4	1321.43	1318.15	1319.66	14868.0
2012-01-31 21:00:00	ES	Futures	1319.66	1320.67	1315.88	1316.13	9000.0
2012-01-31 22:00:00	ES	Futures	1316.39	1318.15	1315.88	1317.14	4564.0
2012-01-31 23:00:00	ES	Futures	1316.89	1318.15	1315.88	1316.39	3429.0
2012-01-31 00:00:00	NQ	Futures	2850.73	2851.31	2846.69	2850.15	436.0
2012-01-31 01:00:00	NQ	Futures	2850.15	2853.62	2849.0	2851.59	355.0
2012-01-31 02:00:00	NQ	Futures	2851.59	2856.79	2851.02	2852.17	1965.0
2012-01-31 03:00:00	NQ	Futures	2852.17	2858.24	2852.17	2856.5	1794.0
2012-01-31 04:00:00	NQ	Futures	2856.22	2861.7	2855.93	2860.55	2015.0
2012-01-31 05:00:00	NQ	Futures	2860.26	2862.28	2857.66	2861.41	1070.0
2012-01-31 06:00:00	NQ	Futures	2861.41	2862.57	2857.95	2858.24	1045.0
2012-01-31 07:00:00	NQ	Futures	2858.24	2858.24	2851.59	2853.91	3518.0
2012-01-31 08:00:00	NQ	Futures	2853.62	2857.37	2851.88	2856.22	12763.0
2012-01-31 09:00:00	NQ	Futures	2855.93	2863.15	2849.28	2855.64	88527.0
2012-01-31 10:00:00	NQ	Futures	2855.06	2856.79	2834.84	2836.87	45723.0
2012-01-31 11:00:00	NQ	Futures	2836.87	2839.75	2828.78	2833.98	31449.0
2012-01-31 12:00:00	NQ	Futures	2833.98	2841.49	2832.25	2838.89	13858.0
2012-01-31 13:00:00	NQ	Futures	2838.6	2845.82	2837.73	2839.18	11309.0
2012-01-31 14:00:00	NQ	Futures	2839.18	2849.86	2837.15	2846.97	13529.0
2012-01-31 15:00:00	NQ	Futures	2846.97	2849.57	2842.64	2846.4	24455.0
2012-01-31 16:00:00	NQ	Futures	2846.4	2848.13	2834.27	2836.87	15290.0
2012-01-31 17:00:00	NQ	Futures	2836.29	2837.44	2835.13	2837.44	106.0
2012-01-31 18:00:00	NQ	Futures	2838.6	2840.91	2836.87	2836.87	592.0
2012-01-31 19:00:00	NQ	Futures	2836.87	2839.75	2836.29	2838.31	469.0
2012-01-31 20:00:00	NQ	Futures	2838.31	2844.37	2838.02	2842.64	926.0
2012-01-31 21:00:00	NQ	Futures	2842.35	2844.66	2835.71	2836.58	525.0
2012-01-31 22:00:00	NQ	Futures	2836.29	2840.04	2835.71	2837.73	251.0
2012-01-31 23:00:00	NQ	Futures	2837.73	2839.75	2836.58	2836.87	204.0
2012-01-31 00:00:00	YM	Futures	12512.1	12512.1	12496.2	12506.1	592.0
2012-01-31 01:00:00	YM	Futures	12506.1	12519.0	12501.2	12510.1	433.0

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

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