PREVIEW / futures_1hour / 2012-10-02

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-02.parquet
  size:    48 KB
  rows:    1,490

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-10-02 00:00:00	ES	Futures	1469.43	1469.94	1468.15	1469.17	4800.0
2012-10-02 01:00:00	ES	Futures	1469.17	1469.94	1468.41	1469.68	2784.0
2012-10-02 02:00:00	ES	Futures	1469.68	1471.47	1468.92	1469.94	7927.0
2012-10-02 03:00:00	ES	Futures	1470.19	1472.49	1468.15	1471.73	30577.0
2012-10-02 04:00:00	ES	Futures	1471.73	1475.3	1471.47	1475.05	24684.0
2012-10-02 05:00:00	ES	Futures	1475.05	1476.32	1474.03	1475.05	26060.0
2012-10-02 06:00:00	ES	Futures	1475.05	1477.6	1475.05	1476.58	29140.0
2012-10-02 07:00:00	ES	Futures	1476.58	1476.58	1474.79	1476.07	19977.0
2012-10-02 08:00:00	ES	Futures	1476.07	1477.09	1474.03	1475.05	33212.0
2012-10-02 09:00:00	ES	Futures	1474.79	1477.35	1472.75	1473.0	175105.0
2012-10-02 10:00:00	ES	Futures	1473.0	1475.3	1468.66	1469.43	278457.0
2012-10-02 11:00:00	ES	Futures	1469.68	1471.47	1464.32	1466.11	339252.0
2012-10-02 12:00:00	ES	Futures	1466.36	1469.43	1465.08	1467.38	120705.0
2012-10-02 13:00:00	ES	Futures	1467.38	1470.19	1465.08	1466.62	89868.0
2012-10-02 14:00:00	ES	Futures	1466.62	1467.89	1463.55	1464.32	101213.0
2012-10-02 15:00:00	ES	Futures	1464.32	1471.22	1463.81	1470.45	211424.0
2012-10-02 16:00:00	ES	Futures	1470.45	1473.26	1470.19	1471.47	84685.0
2012-10-02 17:00:00	ES	Futures	1471.47	1472.49	1471.47	1471.98	1952.0
2012-10-02 18:00:00	ES	Futures	1471.98	1472.24	1470.96	1471.47	2135.0
2012-10-02 19:00:00	ES	Futures	1471.22	1471.47	1470.45	1471.22	2711.0
2012-10-02 20:00:00	ES	Futures	1470.96	1472.24	1470.96	1471.98	2395.0
2012-10-02 21:00:00	ES	Futures	1471.98	1472.24	1469.94	1470.45	5883.0
2012-10-02 22:00:00	ES	Futures	1470.19	1471.22	1469.17	1469.68	4959.0
2012-10-02 23:00:00	ES	Futures	1469.68	1469.94	1468.66	1469.17	2424.0
2012-10-02 00:00:00	NQ	Futures	3241.67	3242.25	3238.76	3240.51	668.0
2012-10-02 01:00:00	NQ	Futures	3240.22	3241.96	3239.05	3241.67	269.0
2012-10-02 02:00:00	NQ	Futures	3241.67	3246.61	3240.22	3243.99	536.0
2012-10-02 03:00:00	NQ	Futures	3243.7	3248.64	3239.05	3246.9	1680.0
2012-10-02 04:00:00	NQ	Futures	3246.9	3254.46	3246.9	3254.46	2650.0
2012-10-02 05:00:00	NQ	Futures	3254.46	3257.94	3252.71	3253.87	1462.0
2012-10-02 06:00:00	NQ	Futures	3253.87	3259.69	3253.58	3255.91	1852.0
2012-10-02 07:00:00	NQ	Futures	3255.62	3256.49	3252.42	3255.91	1395.0
2012-10-02 08:00:00	NQ	Futures	3255.62	3259.1	3252.71	3254.16	2965.0
2012-10-02 09:00:00	NQ	Futures	3254.16	3263.46	3246.61	3253.58	32234.0
2012-10-02 10:00:00	NQ	Futures	3253.29	3262.01	3240.8	3249.23	39654.0
2012-10-02 11:00:00	NQ	Futures	3248.93	3251.55	3233.24	3235.86	33414.0
2012-10-02 12:00:00	NQ	Futures	3235.86	3243.41	3233.24	3235.57	16783.0
2012-10-02 13:00:00	NQ	Futures	3235.28	3240.51	3230.05	3232.66	18300.0
2012-10-02 14:00:00	NQ	Futures	3232.95	3235.28	3222.49	3224.53	21615.0
2012-10-02 15:00:00	NQ	Futures	3224.24	3248.06	3222.78	3248.06	37370.0
2012-10-02 16:00:00	NQ	Futures	3247.77	3252.42	3247.48	3248.64	6600.0
2012-10-02 17:00:00	NQ	Futures	3248.64	3250.39	3248.64	3250.39	67.0
2012-10-02 18:00:00	NQ	Futures	3250.1	3250.39	3247.77	3248.06	207.0
2012-10-02 19:00:00	NQ	Futures	3248.06	3248.64	3246.61	3246.9	377.0
2012-10-02 20:00:00	NQ	Futures	3247.19	3250.97	3247.19	3250.1	469.0
2012-10-02 21:00:00	NQ	Futures	3250.39	3250.68	3246.03	3246.61	329.0
2012-10-02 22:00:00	NQ	Futures	3246.61	3248.64	3245.16	3245.45	466.0
2012-10-02 23:00:00	NQ	Futures	3245.45	3245.74	3244.29	3244.29	183.0
2012-10-02 00:00:00	YM	Futures	13446.9	13450.9	13437.9	13447.9	806.0
2012-10-02 01:00:00	YM	Futures	13446.9	13452.9	13440.9	13450.9	423.0

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

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