PREVIEW / futures_1hour / 2012-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-18.parquet
  size:    49 KB
  rows:    1,516

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-18 00:00:00	ES	Futures	1488.59	1489.35	1488.08	1488.59	2381.0
2012-10-18 01:00:00	ES	Futures	1488.33	1488.84	1487.57	1488.59	3390.0
2012-10-18 02:00:00	ES	Futures	1488.59	1489.86	1488.33	1488.33	4791.0
2012-10-18 03:00:00	ES	Futures	1488.08	1488.84	1485.52	1486.29	26231.0
2012-10-18 04:00:00	ES	Futures	1486.03	1489.1	1486.03	1488.33	16277.0
2012-10-18 05:00:00	ES	Futures	1488.33	1489.61	1487.82	1488.59	19863.0
2012-10-18 06:00:00	ES	Futures	1488.59	1488.84	1486.8	1487.05	11739.0
2012-10-18 07:00:00	ES	Futures	1486.8	1487.31	1485.52	1486.03	23158.0
2012-10-18 08:00:00	ES	Futures	1486.29	1487.82	1484.24	1484.5	57808.0
2012-10-18 09:00:00	ES	Futures	1484.76	1486.29	1483.22	1486.03	149691.0
2012-10-18 10:00:00	ES	Futures	1485.78	1488.33	1482.46	1486.29	295322.0
2012-10-18 11:00:00	ES	Futures	1486.29	1490.63	1486.03	1490.12	203435.0
2012-10-18 12:00:00	ES	Futures	1490.38	1491.65	1485.01	1486.03	253488.0
2012-10-18 13:00:00	ES	Futures	1486.03	1486.54	1481.43	1481.94	172040.0
2012-10-18 14:00:00	ES	Futures	1482.2	1485.52	1479.39	1482.71	184576.0
2012-10-18 15:00:00	ES	Futures	1482.71	1486.29	1481.18	1484.76	272816.0
2012-10-18 16:00:00	ES	Futures	1485.01	1485.01	1481.69	1482.71	88439.0
2012-10-18 17:00:00	ES	Futures	1482.71	1483.22	1482.2	1482.97	1114.0
2012-10-18 18:00:00	ES	Futures	1482.97	1483.48	1482.46	1483.22	3428.0
2012-10-18 19:00:00	ES	Futures	1483.48	1484.5	1483.22	1484.24	2240.0
2012-10-18 20:00:00	ES	Futures	1484.24	1485.27	1483.99	1484.5	4139.0
2012-10-18 21:00:00	ES	Futures	1484.5	1484.5	1482.46	1483.99	5933.0
2012-10-18 22:00:00	ES	Futures	1483.99	1484.76	1483.22	1483.22	2420.0
2012-10-18 23:00:00	ES	Futures	1483.22	1483.22	1482.2	1482.97	3430.0
2012-10-18 00:00:00	NQ	Futures	3221.62	3222.49	3220.46	3221.04	307.0
2012-10-18 01:00:00	NQ	Futures	3221.04	3221.04	3217.26	3218.42	792.0
2012-10-18 02:00:00	NQ	Futures	3218.42	3221.04	3217.84	3217.84	834.0
2012-10-18 03:00:00	NQ	Futures	3218.13	3219.59	3210.87	3213.48	3004.0
2012-10-18 04:00:00	NQ	Futures	3213.19	3221.33	3212.32	3219.59	1602.0
2012-10-18 05:00:00	NQ	Futures	3219.59	3221.33	3215.23	3218.71	1665.0
2012-10-18 06:00:00	NQ	Futures	3218.42	3219.01	3215.81	3216.1	879.0
2012-10-18 07:00:00	NQ	Futures	3216.39	3216.97	3211.45	3212.9	2234.0
2012-10-18 08:00:00	NQ	Futures	3212.61	3214.65	3205.64	3206.22	5669.0
2012-10-18 09:00:00	NQ	Futures	3206.22	3213.48	3202.73	3212.61	27333.0
2012-10-18 10:00:00	NQ	Futures	3212.61	3216.97	3197.21	3205.93	43052.0
2012-10-18 11:00:00	NQ	Futures	3205.64	3216.68	3204.77	3216.39	25193.0
2012-10-18 12:00:00	NQ	Futures	3216.39	3219.59	3185.3	3189.08	69959.0
2012-10-18 13:00:00	NQ	Futures	3189.37	3190.24	3171.06	3173.38	47624.0
2012-10-18 14:00:00	NQ	Futures	3173.38	3182.1	3170.19	3176.87	33285.0
2012-10-18 15:00:00	NQ	Futures	3176.87	3187.04	3172.8	3182.97	55521.0
2012-10-18 16:00:00	NQ	Futures	3182.97	3185.01	3171.93	3174.84	12733.0
2012-10-18 17:00:00	NQ	Futures	3175.42	3176.87	3175.42	3176.87	208.0
2012-10-18 18:00:00	NQ	Futures	3176.58	3178.32	3176.0	3177.45	436.0
2012-10-18 19:00:00	NQ	Futures	3178.03	3180.36	3177.45	3180.07	388.0
2012-10-18 20:00:00	NQ	Futures	3180.07	3181.81	3178.91	3180.36	662.0
2012-10-18 21:00:00	NQ	Futures	3180.36	3180.65	3176.58	3180.07	684.0
2012-10-18 22:00:00	NQ	Futures	3180.36	3181.52	3178.03	3178.03	261.0
2012-10-18 23:00:00	NQ	Futures	3178.03	3178.03	3174.84	3176.58	833.0
2012-10-18 00:00:00	YM	Futures	13497.9	13501.9	13492.9	13495.9	311.0
2012-10-18 01:00:00	YM	Futures	13496.9	13498.9	13489.9	13497.9	321.0

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

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