PREVIEW / futures_1hour / 2013-05-08

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-05-08.parquet
  size:    49 KB
  rows:    1,544

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-05-08 00:00:00	ES	Futures	1669.66	1669.66	1668.63	1669.15	2190.0
2013-05-08 01:00:00	ES	Futures	1669.15	1669.66	1668.89	1669.15	3344.0
2013-05-08 02:00:00	ES	Futures	1669.15	1669.4	1667.6	1667.86	7722.0
2013-05-08 03:00:00	ES	Futures	1667.86	1669.92	1667.34	1667.86	20263.0
2013-05-08 04:00:00	ES	Futures	1667.86	1669.66	1667.34	1669.4	13496.0
2013-05-08 05:00:00	ES	Futures	1669.4	1670.69	1669.15	1670.43	12637.0
2013-05-08 06:00:00	ES	Futures	1670.43	1671.21	1669.92	1670.69	14843.0
2013-05-08 07:00:00	ES	Futures	1670.69	1670.95	1669.66	1669.66	13987.0
2013-05-08 08:00:00	ES	Futures	1669.92	1670.69	1666.06	1666.83	48000.0
2013-05-08 09:00:00	ES	Futures	1666.83	1672.24	1666.57	1671.98	211700.0
2013-05-08 10:00:00	ES	Futures	1672.24	1675.33	1671.46	1674.04	311156.0
2013-05-08 11:00:00	ES	Futures	1673.78	1676.62	1673.78	1676.1	150608.0
2013-05-08 12:00:00	ES	Futures	1676.36	1676.87	1674.3	1675.59	110824.0
2013-05-08 13:00:00	ES	Futures	1675.59	1676.87	1674.56	1675.07	132119.0
2013-05-08 14:00:00	ES	Futures	1675.07	1676.1	1671.72	1674.04	173481.0
2013-05-08 15:00:00	ES	Futures	1674.04	1678.68	1673.53	1678.16	240112.0
2013-05-08 16:00:00	ES	Futures	1677.9	1678.93	1677.65	1678.16	81235.0
2013-05-08 17:00:00	ES	Futures	1678.16	1678.16	1677.65	1677.9	1993.0
2013-05-08 18:00:00	ES	Futures	1677.65	1677.9	1676.62	1676.87	6669.0
2013-05-08 19:00:00	ES	Futures	1676.87	1677.39	1676.62	1677.39	1463.0
2013-05-08 20:00:00	ES	Futures	1677.39	1677.65	1676.87	1677.39	2627.0
2013-05-08 21:00:00	ES	Futures	1677.39	1680.48	1677.13	1679.45	11882.0
2013-05-08 22:00:00	ES	Futures	1679.71	1679.97	1678.68	1678.93	3363.0
2013-05-08 23:00:00	ES	Futures	1678.93	1679.19	1677.9	1678.42	2445.0
2013-05-08 00:00:00	NQ	Futures	3439.64	3440.22	3437.89	3439.06	348.0
2013-05-08 01:00:00	NQ	Futures	3438.77	3440.22	3438.18	3439.64	279.0
2013-05-08 02:00:00	NQ	Futures	3439.35	3439.35	3435.56	3435.56	760.0
2013-05-08 03:00:00	NQ	Futures	3435.85	3439.93	3434.68	3435.85	1537.0
2013-05-08 04:00:00	NQ	Futures	3435.56	3439.06	3435.27	3439.06	1064.0
2013-05-08 05:00:00	NQ	Futures	3439.06	3440.81	3438.18	3439.93	1435.0
2013-05-08 06:00:00	NQ	Futures	3440.22	3442.27	3439.64	3441.39	2527.0
2013-05-08 07:00:00	NQ	Futures	3441.68	3441.68	3440.22	3440.22	2007.0
2013-05-08 08:00:00	NQ	Futures	3440.22	3441.39	3434.68	3435.27	4403.0
2013-05-08 09:00:00	NQ	Futures	3435.56	3446.64	3432.06	3446.35	25833.0
2013-05-08 10:00:00	NQ	Futures	3446.64	3456.56	3444.31	3453.35	27957.0
2013-05-08 11:00:00	NQ	Futures	3453.35	3457.14	3452.47	3455.68	11744.0
2013-05-08 12:00:00	NQ	Futures	3455.68	3457.72	3451.89	3454.81	9709.0
2013-05-08 13:00:00	NQ	Futures	3455.1	3457.72	3452.77	3454.22	9517.0
2013-05-08 14:00:00	NQ	Futures	3454.22	3455.97	3444.31	3449.56	16589.0
2013-05-08 15:00:00	NQ	Futures	3449.56	3459.18	3448.68	3455.68	21139.0
2013-05-08 16:00:00	NQ	Futures	3455.68	3458.6	3454.22	3455.39	4913.0
2013-05-08 17:00:00	NQ	Futures	3455.68	3455.97	3454.81	3455.1	72.0
2013-05-08 18:00:00	NQ	Futures	3454.52	3454.81	3453.35	3453.64	322.0
2013-05-08 19:00:00	NQ	Futures	3453.93	3454.81	3453.35	3454.22	101.0
2013-05-08 20:00:00	NQ	Futures	3454.22	3455.39	3454.22	3455.1	230.0
2013-05-08 21:00:00	NQ	Futures	3455.1	3462.1	3455.1	3460.64	1023.0
2013-05-08 22:00:00	NQ	Futures	3460.93	3461.52	3459.47	3459.77	298.0
2013-05-08 23:00:00	NQ	Futures	3459.77	3460.06	3457.43	3458.02	264.0
2013-05-08 00:00:00	YM	Futures	15157.1	15158.1	15149.0	15152.0	421.0
2013-05-08 01:00:00	YM	Futures	15151.0	15157.1	15150.0	15155.1	439.0

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

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