PREVIEW / futures_1hour / 2013-10-04

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-04.parquet
  size:    41 KB
  rows:    1,249

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-10-04 00:00:00	ES	Futures	1724.21	1724.47	1721.37	1722.14	3725.0
2013-10-04 01:00:00	ES	Futures	1722.14	1722.4	1720.6	1721.63	3313.0
2013-10-04 02:00:00	ES	Futures	1721.63	1724.98	1721.63	1724.47	8764.0
2013-10-04 03:00:00	ES	Futures	1724.21	1725.5	1723.18	1724.47	14836.0
2013-10-04 04:00:00	ES	Futures	1724.21	1727.82	1723.43	1726.79	15460.0
2013-10-04 05:00:00	ES	Futures	1727.04	1728.08	1726.27	1727.56	12087.0
2013-10-04 06:00:00	ES	Futures	1727.3	1728.08	1726.53	1727.82	11254.0
2013-10-04 07:00:00	ES	Futures	1728.08	1728.59	1726.01	1726.79	18392.0
2013-10-04 08:00:00	ES	Futures	1726.79	1727.56	1724.98	1727.3	37687.0
2013-10-04 09:00:00	ES	Futures	1727.04	1731.17	1723.43	1730.14	216362.0
2013-10-04 10:00:00	ES	Futures	1730.4	1735.3	1729.11	1731.17	340201.0
2013-10-04 11:00:00	ES	Futures	1730.91	1733.24	1728.08	1732.46	191870.0
2013-10-04 12:00:00	ES	Futures	1732.46	1737.62	1731.95	1736.33	165386.0
2013-10-04 13:00:00	ES	Futures	1736.33	1737.11	1734.78	1735.04	71967.0
2013-10-04 14:00:00	ES	Futures	1735.04	1739.43	1735.04	1738.4	99914.0
2013-10-04 15:00:00	ES	Futures	1738.65	1739.69	1735.3	1737.62	168631.0
2013-10-04 16:00:00	ES	Futures	1737.36	1738.65	1734.53	1736.33	90387.0
2013-10-04 17:00:00	ES	Futures	1736.33	1736.59	1734.78	1735.56	2496.0
2013-10-04 00:00:00	NQ	Futures	3724.8	3725.38	3718.7	3719.57	493.0
2013-10-04 01:00:00	NQ	Futures	3720.15	3720.44	3716.96	3718.41	855.0
2013-10-04 02:00:00	NQ	Futures	3718.99	3726.25	3718.7	3724.51	1002.0
2013-10-04 03:00:00	NQ	Futures	3724.51	3727.41	3720.44	3723.64	2372.0
2013-10-04 04:00:00	NQ	Futures	3723.64	3731.77	3722.18	3730.32	1961.0
2013-10-04 05:00:00	NQ	Futures	3730.61	3733.51	3729.15	3732.35	1450.0
2013-10-04 06:00:00	NQ	Futures	3732.64	3733.51	3730.61	3732.64	1003.0
2013-10-04 07:00:00	NQ	Futures	3732.93	3734.09	3727.99	3729.15	2224.0
2013-10-04 08:00:00	NQ	Futures	3729.44	3730.61	3724.51	3729.44	4655.0
2013-10-04 09:00:00	NQ	Futures	3729.15	3743.97	3722.18	3739.61	35839.0
2013-10-04 10:00:00	NQ	Futures	3739.9	3750.35	3736.7	3741.93	42119.0
2013-10-04 11:00:00	NQ	Futures	3741.93	3746.29	3736.7	3745.13	23681.0
2013-10-04 12:00:00	NQ	Futures	3744.84	3758.2	3743.97	3755.0	23146.0
2013-10-04 13:00:00	NQ	Futures	3755.29	3757.91	3752.97	3754.42	10918.0
2013-10-04 14:00:00	NQ	Futures	3754.42	3763.13	3752.97	3760.81	14410.0
2013-10-04 15:00:00	NQ	Futures	3760.81	3763.42	3755.0	3757.91	24185.0
2013-10-04 16:00:00	NQ	Futures	3757.62	3762.26	3753.55	3757.91	6692.0
2013-10-04 17:00:00	NQ	Futures	3757.62	3758.78	3755.29	3755.87	219.0
2013-10-04 00:00:00	YM	Futures	15236.0	15236.0	15211.5	15216.6	616.0
2013-10-04 01:00:00	YM	Futures	15217.6	15218.6	15207.4	15212.5	565.0
2013-10-04 02:00:00	YM	Futures	15213.5	15238.0	15213.5	15232.9	982.0
2013-10-04 03:00:00	YM	Futures	15230.9	15241.1	15221.7	15232.9	1685.0
2013-10-04 04:00:00	YM	Futures	15230.9	15252.3	15225.8	15243.1	1958.0
2013-10-04 05:00:00	YM	Futures	15244.2	15252.3	15240.1	15248.2	1036.0
2013-10-04 06:00:00	YM	Futures	15249.3	15255.4	15246.2	15253.3	1074.0
2013-10-04 07:00:00	YM	Futures	15254.4	15259.5	15241.1	15247.2	1117.0
2013-10-04 08:00:00	YM	Futures	15246.2	15254.4	15235.0	15251.3	2824.0
2013-10-04 09:00:00	YM	Futures	15250.3	15270.7	15211.5	15265.6	23423.0
2013-10-04 10:00:00	YM	Futures	15265.6	15298.3	15255.4	15270.7	26701.0
2013-10-04 11:00:00	YM	Futures	15270.7	15287.0	15248.2	15283.0	17828.0
2013-10-04 12:00:00	YM	Futures	15283.0	15319.7	15275.8	15305.4	13167.0
2013-10-04 13:00:00	YM	Futures	15306.5	15311.6	15294.2	15297.3	6903.0

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

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