PREVIEW / futures_1hour / 2012-12-20

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-12-20.parquet
  size:    50 KB
  rows:    1,545

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-20 00:00:00	ES	Futures	1465.39	1465.65	1464.88	1465.39	3419.0
2012-12-20 01:00:00	ES	Futures	1465.39	1466.67	1465.14	1466.67	2552.0
2012-12-20 02:00:00	ES	Futures	1466.42	1467.7	1465.9	1465.9	6058.0
2012-12-20 03:00:00	ES	Futures	1466.16	1470.01	1465.65	1469.24	19083.0
2012-12-20 04:00:00	ES	Futures	1469.24	1470.27	1468.21	1469.24	10082.0
2012-12-20 05:00:00	ES	Futures	1469.24	1471.04	1468.73	1470.01	8714.0
2012-12-20 06:00:00	ES	Futures	1470.01	1471.81	1469.75	1471.29	11890.0
2012-12-20 07:00:00	ES	Futures	1471.55	1472.58	1470.01	1471.04	19452.0
2012-12-20 08:00:00	ES	Futures	1470.78	1472.06	1466.93	1470.52	59058.0
2012-12-20 09:00:00	ES	Futures	1470.52	1472.32	1465.9	1466.16	176392.0
2012-12-20 10:00:00	ES	Futures	1466.16	1472.58	1465.9	1471.04	223863.0
2012-12-20 11:00:00	ES	Futures	1471.04	1472.06	1467.96	1470.01	183465.0
2012-12-20 12:00:00	ES	Futures	1470.27	1471.04	1468.73	1470.78	79414.0
2012-12-20 13:00:00	ES	Futures	1470.52	1475.14	1468.21	1474.63	134893.0
2012-12-20 14:00:00	ES	Futures	1474.63	1476.17	1472.83	1475.66	136585.0
2012-12-20 15:00:00	ES	Futures	1475.4	1477.45	1472.58	1476.68	212927.0
2012-12-20 16:00:00	ES	Futures	1476.94	1479.25	1476.43	1478.22	97545.0
2012-12-20 17:00:00	ES	Futures	1478.22	1478.99	1477.96	1478.73	2141.0
2012-12-20 18:00:00	ES	Futures	1478.99	1479.25	1477.19	1477.45	7935.0
2012-12-20 19:00:00	ES	Futures	1477.71	1477.96	1473.6	1474.37	16382.0
2012-12-20 20:00:00	ES	Futures	1474.37	1474.63	1427.93	1459.23	108218.0
2012-12-20 21:00:00	ES	Futures	1458.98	1459.49	1452.56	1454.1	34847.0
2012-12-20 22:00:00	ES	Futures	1454.1	1457.18	1453.85	1456.67	16643.0
2012-12-20 23:00:00	ES	Futures	1456.92	1456.92	1454.1	1455.9	15047.0
2012-12-20 00:00:00	NQ	Futures	3128.12	3128.7	3126.66	3127.54	409.0
2012-12-20 01:00:00	NQ	Futures	3127.54	3129.57	3127.54	3128.7	213.0
2012-12-20 02:00:00	NQ	Futures	3128.7	3131.9	3128.7	3130.16	749.0
2012-12-20 03:00:00	NQ	Futures	3130.45	3136.56	3128.7	3135.4	1940.0
2012-12-20 04:00:00	NQ	Futures	3135.11	3137.14	3133.36	3135.11	1123.0
2012-12-20 05:00:00	NQ	Futures	3135.11	3139.47	3133.94	3136.85	1304.0
2012-12-20 06:00:00	NQ	Futures	3136.85	3140.64	3136.27	3139.18	1141.0
2012-12-20 07:00:00	NQ	Futures	3139.18	3142.38	3136.85	3139.47	1880.0
2012-12-20 08:00:00	NQ	Futures	3139.18	3142.09	3132.19	3141.22	8293.0
2012-12-20 09:00:00	NQ	Futures	3141.22	3146.17	3118.22	3119.97	37894.0
2012-12-20 10:00:00	NQ	Futures	3119.97	3135.11	3119.97	3126.08	36395.0
2012-12-20 11:00:00	NQ	Futures	3126.08	3130.16	3119.68	3124.92	26154.0
2012-12-20 12:00:00	NQ	Futures	3125.21	3128.41	3121.72	3125.79	17640.0
2012-12-20 13:00:00	NQ	Futures	3125.5	3134.23	3119.1	3133.07	24386.0
2012-12-20 14:00:00	NQ	Futures	3133.07	3139.47	3128.41	3136.27	21263.0
2012-12-20 15:00:00	NQ	Futures	3136.56	3136.56	3126.96	3131.03	27877.0
2012-12-20 16:00:00	NQ	Futures	3131.32	3135.4	3130.16	3133.07	6162.0
2012-12-20 17:00:00	NQ	Futures	3133.36	3135.4	3132.78	3134.81	135.0
2012-12-20 18:00:00	NQ	Futures	3134.81	3138.02	3132.49	3133.36	453.0
2012-12-20 19:00:00	NQ	Futures	3133.65	3134.23	3127.25	3128.7	1161.0
2012-12-20 20:00:00	NQ	Futures	3128.41	3128.7	3070.2	3094.06	13930.0
2012-12-20 21:00:00	NQ	Futures	3093.77	3095.52	3082.13	3084.17	4099.0
2012-12-20 22:00:00	NQ	Futures	3084.46	3087.08	3083.29	3086.5	1750.0
2012-12-20 23:00:00	NQ	Futures	3086.5	3086.5	3080.09	3082.71	1303.0
2012-12-20 00:00:00	YM	Futures	13259.4	13262.4	13254.4	13258.4	531.0
2012-12-20 01:00:00	YM	Futures	13259.4	13266.5	13257.4	13265.4	363.0

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

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