PREVIEW / futures_1hour / 2012-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-16.parquet
  size:    50 KB
  rows:    1,537

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-16 00:00:00	ES	Futures	1468.92	1469.43	1468.92	1469.17	2859.0
2012-10-16 01:00:00	ES	Futures	1468.92	1469.68	1468.41	1468.92	3841.0
2012-10-16 02:00:00	ES	Futures	1469.17	1470.19	1467.64	1467.89	13093.0
2012-10-16 03:00:00	ES	Futures	1467.89	1469.43	1467.13	1467.89	21240.0
2012-10-16 04:00:00	ES	Futures	1467.89	1468.92	1467.38	1468.41	19686.0
2012-10-16 05:00:00	ES	Futures	1468.41	1468.92	1466.87	1468.66	14849.0
2012-10-16 06:00:00	ES	Futures	1468.66	1470.7	1468.41	1470.7	15317.0
2012-10-16 07:00:00	ES	Futures	1470.7	1475.56	1469.94	1475.05	81111.0
2012-10-16 08:00:00	ES	Futures	1475.05	1475.3	1473.0	1474.28	60850.0
2012-10-16 09:00:00	ES	Futures	1474.28	1477.09	1472.24	1476.58	206743.0
2012-10-16 10:00:00	ES	Futures	1476.58	1478.88	1475.56	1477.86	291521.0
2012-10-16 11:00:00	ES	Futures	1477.86	1480.92	1476.84	1480.41	233420.0
2012-10-16 12:00:00	ES	Futures	1480.16	1482.46	1479.65	1480.67	142244.0
2012-10-16 13:00:00	ES	Futures	1480.41	1482.2	1480.41	1481.18	58496.0
2012-10-16 14:00:00	ES	Futures	1481.18	1481.69	1478.62	1479.65	108358.0
2012-10-16 15:00:00	ES	Futures	1479.39	1482.46	1477.86	1481.69	208337.0
2012-10-16 16:00:00	ES	Futures	1481.43	1483.22	1480.41	1481.69	114168.0
2012-10-16 17:00:00	ES	Futures	1481.69	1483.22	1481.18	1482.97	6261.0
2012-10-16 18:00:00	ES	Futures	1482.97	1483.22	1481.94	1482.71	4104.0
2012-10-16 19:00:00	ES	Futures	1482.46	1483.99	1481.94	1482.71	5293.0
2012-10-16 20:00:00	ES	Futures	1482.46	1483.99	1482.2	1483.73	4638.0
2012-10-16 21:00:00	ES	Futures	1483.73	1483.99	1481.94	1482.71	5886.0
2012-10-16 22:00:00	ES	Futures	1482.71	1483.48	1478.88	1479.13	12310.0
2012-10-16 23:00:00	ES	Futures	1479.13	1480.16	1478.37	1479.39	7417.0
2012-10-16 00:00:00	NQ	Futures	3179.49	3180.36	3179.2	3180.07	285.0
2012-10-16 01:00:00	NQ	Futures	3180.07	3183.85	3180.07	3181.52	1667.0
2012-10-16 02:00:00	NQ	Futures	3182.1	3184.72	3179.49	3180.07	2006.0
2012-10-16 03:00:00	NQ	Futures	3180.36	3183.55	3177.16	3178.03	1786.0
2012-10-16 04:00:00	NQ	Futures	3177.74	3181.81	3177.45	3180.36	1303.0
2012-10-16 05:00:00	NQ	Futures	3180.65	3181.52	3177.45	3180.36	881.0
2012-10-16 06:00:00	NQ	Futures	3180.94	3185.88	3180.36	3185.01	2196.0
2012-10-16 07:00:00	NQ	Futures	3185.01	3194.02	3182.97	3192.85	6242.0
2012-10-16 08:00:00	NQ	Futures	3193.14	3193.14	3187.91	3191.11	5906.0
2012-10-16 09:00:00	NQ	Futures	3191.4	3191.98	3180.07	3190.82	41292.0
2012-10-16 10:00:00	NQ	Futures	3190.82	3201.86	3187.62	3200.12	37929.0
2012-10-16 11:00:00	NQ	Futures	3200.12	3214.94	3196.63	3213.19	32588.0
2012-10-16 12:00:00	NQ	Futures	3213.19	3224.82	3211.74	3217.55	29353.0
2012-10-16 13:00:00	NQ	Futures	3217.55	3220.75	3215.81	3217.84	10901.0
2012-10-16 14:00:00	NQ	Futures	3217.55	3218.71	3211.74	3217.26	15908.0
2012-10-16 15:00:00	NQ	Futures	3217.55	3225.11	3214.07	3221.62	25392.0
2012-10-16 16:00:00	NQ	Futures	3221.91	3228.01	3212.03	3214.36	16369.0
2012-10-16 17:00:00	NQ	Futures	3214.36	3216.1	3213.48	3214.36	828.0
2012-10-16 18:00:00	NQ	Futures	3215.52	3215.52	3212.03	3213.77	598.0
2012-10-16 19:00:00	NQ	Futures	3213.48	3216.68	3212.9	3214.36	428.0
2012-10-16 20:00:00	NQ	Futures	3214.36	3217.26	3214.07	3216.97	512.0
2012-10-16 21:00:00	NQ	Futures	3216.97	3218.13	3213.19	3214.65	847.0
2012-10-16 22:00:00	NQ	Futures	3214.65	3216.1	3207.09	3207.67	1760.0
2012-10-16 23:00:00	NQ	Futures	3207.67	3207.96	3204.19	3205.93	1193.0
2012-10-16 00:00:00	YM	Futures	13375.9	13379.9	13375.9	13376.9	252.0
2012-10-16 01:00:00	YM	Futures	13377.9	13383.9	13373.9	13377.9	451.0

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

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