PREVIEW / futures_1hour / 2013-11-27

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-11-27.parquet
  size:    46 KB
  rows:    1,439

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
2013-11-27 00:00:00	ES	Futures	1859.38	1860.15	1858.86	1859.38	3777.0
2013-11-27 01:00:00	ES	Futures	1859.38	1859.89	1858.86	1859.38	2475.0
2013-11-27 02:00:00	ES	Futures	1859.64	1860.67	1859.64	1859.89	4563.0
2013-11-27 03:00:00	ES	Futures	1859.89	1860.67	1858.86	1859.64	10568.0
2013-11-27 04:00:00	ES	Futures	1859.89	1862.22	1859.64	1861.96	12427.0
2013-11-27 05:00:00	ES	Futures	1861.7	1861.96	1860.67	1860.93	12903.0
2013-11-27 06:00:00	ES	Futures	1861.18	1861.96	1860.15	1861.7	20662.0
2013-11-27 07:00:00	ES	Futures	1861.7	1861.96	1860.15	1860.67	19890.0
2013-11-27 08:00:00	ES	Futures	1860.93	1861.96	1859.64	1861.7	27271.0
2013-11-27 09:00:00	ES	Futures	1861.7	1865.05	1859.89	1863.76	133044.0
2013-11-27 10:00:00	ES	Futures	1863.76	1864.8	1862.47	1863.25	110409.0
2013-11-27 11:00:00	ES	Futures	1862.99	1864.8	1862.73	1863.25	75521.0
2013-11-27 12:00:00	ES	Futures	1863.25	1863.25	1858.86	1859.12	78593.0
2013-11-27 13:00:00	ES	Futures	1859.12	1861.7	1858.6	1860.93	61814.0
2013-11-27 14:00:00	ES	Futures	1860.93	1864.02	1860.67	1863.51	48407.0
2013-11-27 15:00:00	ES	Futures	1863.51	1864.54	1862.73	1863.51	125528.0
2013-11-27 16:00:00	ES	Futures	1863.51	1863.76	1861.44	1861.96	60600.0
2013-11-27 17:00:00	ES	Futures	1861.96	1862.22	1861.44	1861.7	1185.0
2013-11-27 18:00:00	ES	Futures	1861.96	1865.05	1861.7	1863.76	4502.0
2013-11-27 19:00:00	ES	Futures	1863.51	1863.76	1862.99	1863.25	2351.0
2013-11-27 20:00:00	ES	Futures	1863.25	1864.02	1862.99	1863.76	2206.0
2013-11-27 21:00:00	ES	Futures	1863.51	1864.28	1863.51	1863.76	1632.0
2013-11-27 22:00:00	ES	Futures	1863.51	1863.76	1862.99	1862.99	1116.0
2013-11-27 23:00:00	ES	Futures	1863.25	1863.76	1862.99	1863.51	1399.0
2013-11-27 00:00:00	NQ	Futures	4006.23	4007.39	4005.35	4006.23	555.0
2013-11-27 01:00:00	NQ	Futures	4006.23	4007.1	4005.35	4006.52	197.0
2013-11-27 02:00:00	NQ	Futures	4006.52	4008.55	4006.52	4007.39	375.0
2013-11-27 03:00:00	NQ	Futures	4007.39	4008.84	4005.35	4007.1	3132.0
2013-11-27 04:00:00	NQ	Futures	4007.39	4011.74	4007.39	4011.45	2320.0
2013-11-27 05:00:00	NQ	Futures	4011.45	4011.74	4009.42	4010.58	1414.0
2013-11-27 06:00:00	NQ	Futures	4010.58	4012.03	4007.97	4010.58	1621.0
2013-11-27 07:00:00	NQ	Futures	4010.29	4011.74	4008.26	4010.0	1841.0
2013-11-27 08:00:00	NQ	Futures	4010.29	4012.03	4007.39	4012.03	2678.0
2013-11-27 09:00:00	NQ	Futures	4012.03	4028.3	4010.0	4024.81	28565.0
2013-11-27 10:00:00	NQ	Futures	4025.1	4028.88	4021.04	4023.65	25667.0
2013-11-27 11:00:00	NQ	Futures	4023.65	4030.04	4022.49	4026.56	16571.0
2013-11-27 12:00:00	NQ	Futures	4026.56	4026.85	4020.75	4021.33	12166.0
2013-11-27 13:00:00	NQ	Futures	4021.04	4024.81	4019.88	4023.07	9754.0
2013-11-27 14:00:00	NQ	Futures	4023.07	4029.75	4022.49	4029.17	9725.0
2013-11-27 15:00:00	NQ	Futures	4029.46	4033.82	4026.85	4032.66	22613.0
2013-11-27 16:00:00	NQ	Futures	4032.36	4032.66	4029.17	4031.49	4447.0
2013-11-27 17:00:00	NQ	Futures	4031.49	4032.07	4030.91	4030.91	140.0
2013-11-27 18:00:00	NQ	Futures	4030.04	4035.27	4029.75	4033.82	607.0
2013-11-27 19:00:00	NQ	Futures	4033.53	4034.11	4032.95	4033.82	161.0
2013-11-27 20:00:00	NQ	Futures	4033.82	4034.98	4033.24	4034.69	202.0
2013-11-27 21:00:00	NQ	Futures	4034.98	4036.43	4034.69	4036.43	335.0
2013-11-27 22:00:00	NQ	Futures	4035.56	4036.43	4034.98	4035.27	80.0
2013-11-27 23:00:00	NQ	Futures	4035.56	4036.72	4035.56	4036.72	146.0
2013-11-27 00:00:00	YM	Futures	16404.3	16411.4	16402.2	16404.3	468.0
2013-11-27 01:00:00	YM	Futures	16404.3	16409.4	16402.2	16407.4	304.0

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

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