PREVIEW / futures_1hour / 2012-12-18

all futures 1-hour files

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

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-12-18 00:00:00	ES	Futures	1468.98	1469.24	1467.96	1467.96	5218.0
2012-12-18 01:00:00	ES	Futures	1467.96	1469.75	1467.96	1469.5	4720.0
2012-12-18 02:00:00	ES	Futures	1469.5	1470.27	1468.98	1470.01	7995.0
2012-12-18 03:00:00	ES	Futures	1470.01	1470.01	1468.47	1469.75	16644.0
2012-12-18 04:00:00	ES	Futures	1469.5	1471.55	1469.5	1470.52	14498.0
2012-12-18 05:00:00	ES	Futures	1470.27	1471.29	1468.21	1468.47	13039.0
2012-12-18 06:00:00	ES	Futures	1468.47	1470.52	1467.96	1469.5	14456.0
2012-12-18 07:00:00	ES	Futures	1469.5	1470.78	1468.98	1470.52	15575.0
2012-12-18 08:00:00	ES	Futures	1470.52	1472.06	1465.39	1465.65	94233.0
2012-12-18 09:00:00	ES	Futures	1465.65	1467.44	1462.83	1464.11	225150.0
2012-12-18 10:00:00	ES	Futures	1463.85	1473.35	1463.08	1472.06	328305.0
2012-12-18 11:00:00	ES	Futures	1472.06	1476.43	1471.81	1473.86	251424.0
2012-12-18 12:00:00	ES	Futures	1473.86	1481.04	1473.35	1479.5	178588.0
2012-12-18 13:00:00	ES	Futures	1479.76	1480.02	1476.94	1477.96	100394.0
2012-12-18 14:00:00	ES	Futures	1477.96	1479.25	1474.89	1476.94	153168.0
2012-12-18 15:00:00	ES	Futures	1476.94	1481.56	1475.91	1479.76	295561.0
2012-12-18 16:00:00	ES	Futures	1480.02	1481.04	1477.96	1478.73	113479.0
2012-12-18 17:00:00	ES	Futures	1478.99	1479.25	1478.22	1478.48	1526.0
2012-12-18 18:00:00	ES	Futures	1478.48	1480.27	1477.96	1478.99	8344.0
2012-12-18 19:00:00	ES	Futures	1478.73	1479.76	1477.71	1479.76	3959.0
2012-12-18 20:00:00	ES	Futures	1479.76	1480.27	1478.99	1479.5	3553.0
2012-12-18 21:00:00	ES	Futures	1479.5	1479.76	1478.99	1479.5	2345.0
2012-12-18 22:00:00	ES	Futures	1479.5	1479.76	1478.73	1479.25	2200.0
2012-12-18 23:00:00	ES	Futures	1479.5	1479.76	1478.22	1478.48	2446.0
2012-12-18 00:00:00	NQ	Futures	3110.66	3111.53	3108.62	3108.91	543.0
2012-12-18 01:00:00	NQ	Futures	3108.91	3111.53	3108.91	3111.24	356.0
2012-12-18 02:00:00	NQ	Futures	3110.95	3115.6	3109.78	3115.31	1628.0
2012-12-18 03:00:00	NQ	Futures	3115.02	3115.02	3110.66	3112.69	2141.0
2012-12-18 04:00:00	NQ	Futures	3112.69	3116.19	3112.69	3115.02	2054.0
2012-12-18 05:00:00	NQ	Futures	3115.02	3116.48	3111.53	3113.27	2032.0
2012-12-18 06:00:00	NQ	Futures	3113.57	3115.89	3111.24	3115.31	2363.0
2012-12-18 07:00:00	NQ	Futures	3115.31	3122.3	3113.57	3119.97	5556.0
2012-12-18 08:00:00	NQ	Futures	3119.68	3122.88	3110.66	3112.4	11326.0
2012-12-18 09:00:00	NQ	Futures	3112.11	3115.02	3103.96	3106.0	35596.0
2012-12-18 10:00:00	NQ	Futures	3106.29	3128.41	3103.96	3124.92	51585.0
2012-12-18 11:00:00	NQ	Futures	3125.21	3140.05	3123.46	3135.69	40846.0
2012-12-18 12:00:00	NQ	Futures	3135.4	3149.95	3133.36	3148.79	29759.0
2012-12-18 13:00:00	NQ	Futures	3148.79	3149.08	3140.05	3141.8	22623.0
2012-12-18 14:00:00	NQ	Futures	3141.8	3146.46	3135.98	3142.09	30064.0
2012-12-18 15:00:00	NQ	Futures	3142.38	3151.7	3138.89	3147.33	47224.0
2012-12-18 16:00:00	NQ	Futures	3147.62	3151.11	3144.13	3145.58	10646.0
2012-12-18 17:00:00	NQ	Futures	3145.87	3147.04	3145.87	3147.04	88.0
2012-12-18 18:00:00	NQ	Futures	3145.87	3148.79	3145.29	3146.17	403.0
2012-12-18 19:00:00	NQ	Futures	3146.17	3147.33	3144.13	3147.04	358.0
2012-12-18 20:00:00	NQ	Futures	3147.33	3147.91	3145.0	3146.46	325.0
2012-12-18 21:00:00	NQ	Futures	3146.46	3147.04	3145.29	3146.17	333.0
2012-12-18 22:00:00	NQ	Futures	3146.17	3147.04	3145.58	3146.75	179.0
2012-12-18 23:00:00	NQ	Futures	3146.75	3147.04	3145.0	3146.75	388.0
2012-12-18 00:00:00	YM	Futures	13300.7	13302.7	13289.6	13289.6	697.0
2012-12-18 01:00:00	YM	Futures	13289.6	13303.7	13289.6	13302.7	485.0

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

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