PREVIEW / futures_1hour / 2012-03-15

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-03-15.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-03-15 00:00:00	ES	Futures	1407.6	1410.13	1407.1	1408.87	8057.0
2012-03-15 01:00:00	ES	Futures	1408.87	1409.38	1405.58	1405.83	6984.0
2012-03-15 02:00:00	ES	Futures	1405.83	1407.86	1405.83	1407.86	5010.0
2012-03-15 03:00:00	ES	Futures	1407.6	1408.87	1406.34	1408.36	9601.0
2012-03-15 04:00:00	ES	Futures	1408.36	1408.62	1406.09	1407.86	35784.0
2012-03-15 05:00:00	ES	Futures	1407.86	1410.39	1406.85	1408.11	35196.0
2012-03-15 06:00:00	ES	Futures	1408.36	1408.62	1406.34	1406.85	26683.0
2012-03-15 07:00:00	ES	Futures	1406.85	1409.38	1406.85	1409.38	36199.0
2012-03-15 08:00:00	ES	Futures	1409.12	1409.88	1408.11	1408.36	58305.0
2012-03-15 09:00:00	ES	Futures	1408.62	1408.87	1403.81	1406.34	224670.0
2012-03-15 10:00:00	ES	Futures	1406.34	1410.13	1404.57	1407.6	350677.0
2012-03-15 11:00:00	ES	Futures	1407.86	1409.63	1406.34	1409.12	216403.0
2012-03-15 12:00:00	ES	Futures	1409.38	1413.68	1408.87	1412.41	180533.0
2012-03-15 13:00:00	ES	Futures	1412.41	1413.42	1410.39	1410.89	120000.0
2012-03-15 14:00:00	ES	Futures	1410.89	1413.17	1409.88	1412.66	110051.0
2012-03-15 15:00:00	ES	Futures	1412.41	1414.18	1411.65	1412.92	186445.0
2012-03-15 16:00:00	ES	Futures	1412.92	1413.68	1411.15	1411.91	76845.0
2012-03-15 17:00:00	ES	Futures	1411.91	1412.16	1411.4	1412.16	2208.0
2012-03-15 18:00:00	ES	Futures	1412.16	1412.66	1411.15	1411.65	5742.0
2012-03-15 19:00:00	ES	Futures	1411.4	1412.41	1411.15	1411.91	1711.0
2012-03-15 20:00:00	ES	Futures	1411.91	1412.16	1410.64	1411.15	4893.0
2012-03-15 21:00:00	ES	Futures	1411.15	1412.41	1410.89	1412.16	2706.0
2012-03-15 22:00:00	ES	Futures	1412.16	1412.66	1411.91	1412.16	2565.0
2012-03-15 23:00:00	ES	Futures	1412.41	1412.41	1411.4	1411.4	1983.0
2012-03-15 00:00:00	NQ	Futures	3134.36	3137.83	3132.91	3135.8	880.0
2012-03-15 01:00:00	NQ	Futures	3135.8	3136.67	3129.15	3129.73	951.0
2012-03-15 02:00:00	NQ	Futures	3130.02	3134.64	3130.02	3134.64	457.0
2012-03-15 03:00:00	NQ	Futures	3134.36	3135.51	3130.89	3134.07	745.0
2012-03-15 04:00:00	NQ	Futures	3133.49	3135.8	3129.15	3134.93	3240.0
2012-03-15 05:00:00	NQ	Futures	3134.36	3140.43	3133.2	3134.64	3058.0
2012-03-15 06:00:00	NQ	Futures	3134.64	3135.22	3129.15	3131.17	2955.0
2012-03-15 07:00:00	NQ	Futures	3131.46	3136.96	3130.89	3136.96	5026.0
2012-03-15 08:00:00	NQ	Futures	3136.96	3138.98	3135.51	3137.54	9668.0
2012-03-15 09:00:00	NQ	Futures	3137.54	3138.12	3127.13	3134.93	33017.0
2012-03-15 10:00:00	NQ	Futures	3134.93	3141.01	3121.34	3131.75	60815.0
2012-03-15 11:00:00	NQ	Futures	3131.75	3139.85	3127.41	3136.38	25311.0
2012-03-15 12:00:00	NQ	Futures	3136.38	3143.32	3135.51	3138.98	19095.0
2012-03-15 13:00:00	NQ	Futures	3138.98	3141.01	3125.1	3127.7	25117.0
2012-03-15 14:00:00	NQ	Futures	3127.7	3138.4	3121.92	3136.09	25132.0
2012-03-15 15:00:00	NQ	Futures	3136.09	3139.85	3130.6	3136.38	33854.0
2012-03-15 16:00:00	NQ	Futures	3136.38	3137.54	3133.78	3134.93	7954.0
2012-03-15 17:00:00	NQ	Futures	3134.93	3135.8	3134.07	3135.8	264.0
2012-03-15 18:00:00	NQ	Futures	3135.51	3136.09	3134.07	3134.64	274.0
2012-03-15 19:00:00	NQ	Futures	3134.64	3136.38	3133.78	3135.22	154.0
2012-03-15 20:00:00	NQ	Futures	3135.22	3135.22	3133.2	3133.49	364.0
2012-03-15 21:00:00	NQ	Futures	3133.49	3136.67	3133.49	3136.38	405.0
2012-03-15 22:00:00	NQ	Futures	3136.09	3137.54	3135.8	3136.38	402.0
2012-03-15 23:00:00	NQ	Futures	3136.38	3136.67	3135.22	3135.51	220.0
2012-03-15 00:00:00	YM	Futures	13097.4	13119.3	13095.4	13111.3	707.0
2012-03-15 01:00:00	YM	Futures	13111.3	13114.3	13070.5	13080.4	1874.0

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

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