PREVIEW / futures_1hour / 2012-01-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-01-18.parquet
  size:    48 KB
  rows:    1,477

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-18 00:00:00	ES	Futures	1303.79	1304.04	1302.27	1302.78	3349.0
2012-01-18 01:00:00	ES	Futures	1302.53	1303.03	1300.01	1301.01	4978.0
2012-01-18 02:00:00	ES	Futures	1301.01	1303.53	1300.76	1302.53	8594.0
2012-01-18 03:00:00	ES	Futures	1302.78	1303.03	1296.98	1299.5	33290.0
2012-01-18 04:00:00	ES	Futures	1299.5	1302.78	1298.75	1300.76	24382.0
2012-01-18 05:00:00	ES	Futures	1301.01	1308.32	1300.51	1304.29	63248.0
2012-01-18 06:00:00	ES	Futures	1304.54	1305.3	1303.03	1305.05	20410.0
2012-01-18 07:00:00	ES	Futures	1305.05	1305.3	1300.76	1302.02	45346.0
2012-01-18 08:00:00	ES	Futures	1302.27	1303.79	1298.49	1298.49	65501.0
2012-01-18 09:00:00	ES	Futures	1298.49	1304.79	1296.73	1303.79	288384.0
2012-01-18 10:00:00	ES	Futures	1304.04	1308.83	1303.79	1307.06	314341.0
2012-01-18 11:00:00	ES	Futures	1307.06	1308.07	1304.54	1305.55	287043.0
2012-01-18 12:00:00	ES	Futures	1305.55	1311.09	1305.55	1310.34	232578.0
2012-01-18 13:00:00	ES	Futures	1310.59	1311.6	1308.32	1308.83	115195.0
2012-01-18 14:00:00	ES	Futures	1308.83	1312.35	1308.57	1311.6	105558.0
2012-01-18 15:00:00	ES	Futures	1311.6	1314.62	1311.35	1313.87	274480.0
2012-01-18 16:00:00	ES	Futures	1313.87	1314.12	1312.35	1313.11	83191.0
2012-01-18 17:00:00	ES	Futures	1312.86	1313.61	1312.35	1313.61	1316.0
2012-01-18 18:00:00	ES	Futures	1313.61	1314.12	1312.86	1313.36	4503.0
2012-01-18 19:00:00	ES	Futures	1313.36	1313.87	1311.85	1312.61	6662.0
2012-01-18 20:00:00	ES	Futures	1312.61	1313.61	1311.6	1313.36	5379.0
2012-01-18 21:00:00	ES	Futures	1313.36	1317.9	1312.86	1314.87	12345.0
2012-01-18 22:00:00	ES	Futures	1314.87	1315.38	1313.11	1313.11	5726.0
2012-01-18 23:00:00	ES	Futures	1313.36	1313.61	1312.1	1312.61	3973.0
2012-01-18 00:00:00	NQ	Futures	2771.02	2771.31	2768.13	2768.71	270.0
2012-01-18 01:00:00	NQ	Futures	2768.71	2768.71	2764.96	2766.69	389.0
2012-01-18 02:00:00	NQ	Futures	2766.98	2770.73	2766.11	2769.29	442.0
2012-01-18 03:00:00	NQ	Futures	2769.58	2770.44	2758.31	2763.51	2199.0
2012-01-18 04:00:00	NQ	Futures	2763.22	2770.15	2761.78	2766.98	1425.0
2012-01-18 05:00:00	NQ	Futures	2767.55	2780.55	2766.4	2774.77	3713.0
2012-01-18 06:00:00	NQ	Futures	2774.77	2775.35	2771.02	2774.77	1075.0
2012-01-18 07:00:00	NQ	Futures	2775.06	2775.06	2767.84	2770.73	3203.0
2012-01-18 08:00:00	NQ	Futures	2770.73	2774.2	2765.24	2765.53	7139.0
2012-01-18 09:00:00	NQ	Futures	2765.82	2775.06	2761.49	2771.89	29144.0
2012-01-18 10:00:00	NQ	Futures	2772.18	2784.3	2772.18	2781.42	35459.0
2012-01-18 11:00:00	NQ	Futures	2781.71	2786.04	2779.11	2780.26	23793.0
2012-01-18 12:00:00	NQ	Futures	2780.55	2794.12	2779.4	2792.97	30406.0
2012-01-18 13:00:00	NQ	Futures	2793.26	2797.01	2789.79	2790.66	20753.0
2012-01-18 14:00:00	NQ	Futures	2790.37	2796.72	2790.37	2794.99	21335.0
2012-01-18 15:00:00	NQ	Futures	2795.28	2799.03	2794.12	2797.88	23191.0
2012-01-18 16:00:00	NQ	Futures	2797.88	2799.03	2793.26	2796.43	8731.0
2012-01-18 17:00:00	NQ	Futures	2796.43	2797.59	2794.7	2797.3	341.0
2012-01-18 18:00:00	NQ	Futures	2796.43	2797.59	2795.28	2796.43	546.0
2012-01-18 19:00:00	NQ	Futures	2796.72	2797.59	2794.99	2796.43	399.0
2012-01-18 20:00:00	NQ	Futures	2796.15	2798.74	2795.57	2798.46	277.0
2012-01-18 21:00:00	NQ	Futures	2798.17	2809.43	2797.59	2802.79	1103.0
2012-01-18 22:00:00	NQ	Futures	2803.08	2803.08	2799.32	2799.9	439.0
2012-01-18 23:00:00	NQ	Futures	2799.9	2799.9	2798.17	2799.03	281.0
2012-01-18 00:00:00	YM	Futures	12344.6	12344.6	12331.7	12334.7	243.0
2012-01-18 01:00:00	YM	Futures	12335.7	12335.7	12314.9	12319.8	365.0

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

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