PREVIEW / futures_1hour / 2013-06-07

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-06-07.parquet
  size:    43 KB
  rows:    1,240

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-06-07 00:00:00	ES	Futures	1669.66	1673.01	1669.15	1672.24	8954.0
2013-06-07 01:00:00	ES	Futures	1672.24	1673.01	1670.18	1670.69	7473.0
2013-06-07 02:00:00	ES	Futures	1670.43	1672.75	1667.09	1671.72	27075.0
2013-06-07 03:00:00	ES	Futures	1671.46	1672.24	1667.34	1669.15	33421.0
2013-06-07 04:00:00	ES	Futures	1669.15	1671.72	1668.37	1670.69	20696.0
2013-06-07 05:00:00	ES	Futures	1670.43	1672.24	1669.15	1671.46	16879.0
2013-06-07 06:00:00	ES	Futures	1671.72	1672.24	1667.6	1671.72	36601.0
2013-06-07 07:00:00	ES	Futures	1671.72	1672.5	1670.18	1671.21	38558.0
2013-06-07 08:00:00	ES	Futures	1671.21	1682.8	1668.37	1680.74	237585.0
2013-06-07 09:00:00	ES	Futures	1680.74	1683.06	1675.07	1682.28	381963.0
2013-06-07 10:00:00	ES	Futures	1682.03	1689.24	1682.03	1686.4	425019.0
2013-06-07 11:00:00	ES	Futures	1686.4	1692.07	1686.4	1688.21	284005.0
2013-06-07 12:00:00	ES	Futures	1688.21	1688.72	1684.09	1687.18	123108.0
2013-06-07 13:00:00	ES	Futures	1687.18	1688.47	1685.12	1685.37	111093.0
2013-06-07 14:00:00	ES	Futures	1685.63	1688.47	1681.25	1687.69	161307.0
2013-06-07 15:00:00	ES	Futures	1687.43	1693.87	1686.15	1692.33	265325.0
2013-06-07 16:00:00	ES	Futures	1692.33	1692.33	1687.95	1689.75	104904.0
2013-06-07 17:00:00	ES	Futures	1689.5	1689.5	1688.72	1688.72	1653.0
2013-06-07 00:00:00	NQ	Futures	3437.31	3443.43	3435.85	3441.1	1085.0
2013-06-07 01:00:00	NQ	Futures	3440.52	3443.43	3437.02	3437.89	1001.0
2013-06-07 02:00:00	NQ	Futures	3437.6	3441.97	3431.77	3439.64	2321.0
2013-06-07 03:00:00	NQ	Futures	3439.64	3440.52	3434.39	3439.35	4969.0
2013-06-07 04:00:00	NQ	Futures	3439.35	3444.02	3435.27	3439.64	3631.0
2013-06-07 05:00:00	NQ	Futures	3439.64	3443.14	3435.27	3441.39	2240.0
2013-06-07 06:00:00	NQ	Futures	3441.68	3442.85	3432.64	3439.64	3109.0
2013-06-07 07:00:00	NQ	Futures	3439.64	3441.1	3436.43	3438.18	2585.0
2013-06-07 08:00:00	NQ	Futures	3438.18	3463.85	3430.02	3455.39	20519.0
2013-06-07 09:00:00	NQ	Futures	3455.39	3460.35	3444.89	3460.06	48551.0
2013-06-07 10:00:00	NQ	Futures	3460.06	3476.39	3457.72	3469.39	44740.0
2013-06-07 11:00:00	NQ	Futures	3469.39	3482.22	3469.1	3476.39	25922.0
2013-06-07 12:00:00	NQ	Futures	3476.39	3481.06	3470.85	3480.18	14628.0
2013-06-07 13:00:00	NQ	Futures	3480.18	3482.81	3475.52	3476.1	23108.0
2013-06-07 14:00:00	NQ	Futures	3476.39	3480.77	3469.1	3479.02	18626.0
2013-06-07 15:00:00	NQ	Futures	3478.72	3490.68	3478.14	3487.18	35023.0
2013-06-07 16:00:00	NQ	Futures	3486.89	3486.89	3478.14	3482.22	8531.0
2013-06-07 17:00:00	NQ	Futures	3482.22	3482.52	3480.18	3482.52	87.0
2013-06-07 00:00:00	YM	Futures	15181.4	15204.6	15177.3	15197.5	1793.0
2013-06-07 01:00:00	YM	Futures	15196.5	15204.6	15182.4	15183.4	1338.0
2013-06-07 02:00:00	YM	Futures	15182.4	15202.6	15162.2	15192.5	2682.0
2013-06-07 03:00:00	YM	Futures	15191.5	15194.5	15160.1	15177.3	2683.0
2013-06-07 04:00:00	YM	Futures	15176.3	15191.5	15168.2	15184.4	2114.0
2013-06-07 05:00:00	YM	Futures	15185.4	15195.5	15173.3	15188.4	1349.0
2013-06-07 06:00:00	YM	Futures	15190.5	15194.5	15163.2	15194.5	2238.0
2013-06-07 07:00:00	YM	Futures	15193.5	15199.6	15179.3	15188.4	2548.0
2013-06-07 08:00:00	YM	Futures	15187.4	15275.4	15173.3	15257.2	20224.0
2013-06-07 09:00:00	YM	Futures	15258.2	15299.6	15232.9	15299.6	39330.0
2013-06-07 10:00:00	YM	Futures	15298.6	15389.6	15298.6	15364.3	44739.0
2013-06-07 11:00:00	YM	Futures	15364.3	15408.8	15364.3	15370.4	29255.0
2013-06-07 12:00:00	YM	Futures	15370.4	15387.6	15348.2	15367.4	13874.0
2013-06-07 13:00:00	YM	Futures	15366.4	15376.5	15349.2	15351.2	12036.0

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

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