PREVIEW / futures_1hour / 2012-04-03

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-04-03.parquet
  size:    49 KB
  rows:    1,478

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-04-03 00:00:00	ES	Futures	1429.11	1429.87	1428.1	1429.87	4036.0
2012-04-03 01:00:00	ES	Futures	1429.61	1430.63	1429.61	1430.37	4882.0
2012-04-03 02:00:00	ES	Futures	1430.63	1430.88	1429.11	1429.61	5410.0
2012-04-03 03:00:00	ES	Futures	1429.36	1430.12	1427.84	1428.6	23485.0
2012-04-03 04:00:00	ES	Futures	1428.86	1430.12	1426.58	1427.34	24206.0
2012-04-03 05:00:00	ES	Futures	1427.34	1428.6	1426.33	1426.83	20679.0
2012-04-03 06:00:00	ES	Futures	1426.83	1427.59	1426.07	1427.08	18297.0
2012-04-03 07:00:00	ES	Futures	1427.08	1427.84	1424.55	1425.57	46582.0
2012-04-03 08:00:00	ES	Futures	1425.57	1427.34	1425.06	1427.34	32672.0
2012-04-03 09:00:00	ES	Futures	1427.34	1430.12	1426.58	1428.35	173048.0
2012-04-03 10:00:00	ES	Futures	1428.35	1431.13	1425.82	1429.87	242936.0
2012-04-03 11:00:00	ES	Futures	1429.87	1429.87	1424.05	1425.57	183411.0
2012-04-03 12:00:00	ES	Futures	1425.57	1425.82	1422.03	1425.06	114703.0
2012-04-03 13:00:00	ES	Futures	1425.06	1426.33	1423.54	1425.82	63651.0
2012-04-03 14:00:00	ES	Futures	1425.82	1425.82	1416.21	1418.99	367909.0
2012-04-03 15:00:00	ES	Futures	1418.99	1425.31	1418.74	1425.06	254825.0
2012-04-03 16:00:00	ES	Futures	1424.81	1425.82	1424.3	1424.81	68543.0
2012-04-03 17:00:00	ES	Futures	1424.55	1425.06	1424.3	1424.55	908.0
2012-04-03 18:00:00	ES	Futures	1424.55	1424.81	1423.54	1423.8	2315.0
2012-04-03 19:00:00	ES	Futures	1423.8	1424.3	1423.54	1423.54	2087.0
2012-04-03 20:00:00	ES	Futures	1423.8	1424.05	1422.28	1422.78	8214.0
2012-04-03 21:00:00	ES	Futures	1422.53	1423.04	1421.01	1421.52	7147.0
2012-04-03 22:00:00	ES	Futures	1421.27	1421.52	1419.75	1421.01	6137.0
2012-04-03 23:00:00	ES	Futures	1421.01	1421.01	1419.75	1420.0	3939.0
2012-04-03 00:00:00	NQ	Futures	3212.73	3213.6	3210.7	3213.31	543.0
2012-04-03 01:00:00	NQ	Futures	3213.31	3215.04	3213.31	3215.04	202.0
2012-04-03 02:00:00	NQ	Futures	3215.04	3215.04	3211.86	3212.15	751.0
2012-04-03 03:00:00	NQ	Futures	3212.15	3215.33	3209.84	3212.44	2570.0
2012-04-03 04:00:00	NQ	Futures	3212.73	3215.33	3208.68	3210.13	2389.0
2012-04-03 05:00:00	NQ	Futures	3209.84	3212.73	3208.1	3209.55	1816.0
2012-04-03 06:00:00	NQ	Futures	3209.26	3210.99	3208.1	3210.42	1662.0
2012-04-03 07:00:00	NQ	Futures	3210.42	3212.73	3206.37	3208.97	4645.0
2012-04-03 08:00:00	NQ	Futures	3209.26	3215.91	3209.26	3215.91	5656.0
2012-04-03 09:00:00	NQ	Futures	3215.33	3225.45	3214.46	3222.85	36155.0
2012-04-03 10:00:00	NQ	Futures	3223.14	3228.92	3216.78	3228.63	36627.0
2012-04-03 11:00:00	NQ	Futures	3228.63	3229.21	3212.73	3213.89	36272.0
2012-04-03 12:00:00	NQ	Futures	3214.17	3214.75	3202.61	3213.31	22460.0
2012-04-03 13:00:00	NQ	Futures	3213.31	3216.78	3208.97	3215.91	15855.0
2012-04-03 14:00:00	NQ	Futures	3215.91	3215.91	3196.24	3202.61	40908.0
2012-04-03 15:00:00	NQ	Futures	3202.32	3214.46	3198.85	3214.46	34669.0
2012-04-03 16:00:00	NQ	Futures	3214.46	3217.07	3213.02	3213.31	7639.0
2012-04-03 17:00:00	NQ	Futures	3213.31	3213.31	3211.57	3212.73	109.0
2012-04-03 18:00:00	NQ	Futures	3213.31	3213.89	3210.42	3210.99	186.0
2012-04-03 19:00:00	NQ	Futures	3211.28	3212.15	3210.13	3210.7	192.0
2012-04-03 20:00:00	NQ	Futures	3210.99	3211.57	3207.23	3208.39	864.0
2012-04-03 21:00:00	NQ	Futures	3208.39	3209.55	3205.79	3206.08	518.0
2012-04-03 22:00:00	NQ	Futures	3206.37	3206.66	3202.61	3206.08	632.0
2012-04-03 23:00:00	NQ	Futures	3206.08	3206.08	3203.19	3204.05	272.0
2012-04-03 00:00:00	YM	Futures	13136.2	13142.2	13128.2	13141.2	376.0
2012-04-03 01:00:00	YM	Futures	13141.2	13147.2	13140.2	13145.2	190.0

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

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