PREVIEW / futures_1hour / 2013-08-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-23.parquet
  size:    42 KB
  rows:    1,233

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-08-23 00:00:00	ES	Futures	1713.3	1713.82	1713.05	1713.82	1338.0
2013-08-23 01:00:00	ES	Futures	1713.56	1714.08	1710.98	1711.75	9110.0
2013-08-23 02:00:00	ES	Futures	1711.75	1712.01	1710.2	1711.49	9230.0
2013-08-23 03:00:00	ES	Futures	1711.49	1711.49	1706.58	1708.91	28057.0
2013-08-23 04:00:00	ES	Futures	1708.65	1710.98	1707.62	1707.88	17069.0
2013-08-23 05:00:00	ES	Futures	1707.88	1709.68	1707.62	1709.68	10848.0
2013-08-23 06:00:00	ES	Futures	1709.68	1710.2	1708.65	1709.94	7308.0
2013-08-23 07:00:00	ES	Futures	1709.68	1712.27	1709.43	1712.01	19195.0
2013-08-23 08:00:00	ES	Futures	1712.01	1713.3	1710.98	1712.53	31754.0
2013-08-23 09:00:00	ES	Futures	1712.27	1717.7	1710.72	1712.27	261172.0
2013-08-23 10:00:00	ES	Futures	1712.01	1716.15	1708.39	1714.85	300593.0
2013-08-23 11:00:00	ES	Futures	1714.85	1716.15	1711.75	1713.05	158197.0
2013-08-23 12:00:00	ES	Futures	1713.05	1715.37	1712.79	1715.11	78711.0
2013-08-23 13:00:00	ES	Futures	1715.11	1715.89	1713.56	1714.85	49830.0
2013-08-23 14:00:00	ES	Futures	1714.85	1715.63	1713.56	1715.11	52703.0
2013-08-23 15:00:00	ES	Futures	1715.11	1719.25	1714.34	1716.92	177906.0
2013-08-23 16:00:00	ES	Futures	1716.66	1718.73	1716.66	1717.96	68014.0
2013-08-23 17:00:00	ES	Futures	1717.7	1718.21	1717.44	1717.7	1145.0
2013-08-23 00:00:00	NQ	Futures	3634.25	3635.12	3633.66	3634.83	135.0
2013-08-23 01:00:00	NQ	Futures	3634.54	3635.12	3629.28	3630.15	853.0
2013-08-23 02:00:00	NQ	Futures	3630.15	3631.03	3628.11	3628.98	904.0
2013-08-23 03:00:00	NQ	Futures	3628.98	3628.98	3619.63	3623.43	4216.0
2013-08-23 04:00:00	NQ	Futures	3623.72	3628.98	3621.09	3621.09	2729.0
2013-08-23 05:00:00	NQ	Futures	3621.09	3625.77	3620.22	3625.48	2087.0
2013-08-23 06:00:00	NQ	Futures	3625.77	3626.06	3623.14	3625.48	1382.0
2013-08-23 07:00:00	NQ	Futures	3625.48	3631.03	3624.89	3629.86	2388.0
2013-08-23 08:00:00	NQ	Futures	3629.86	3631.62	3627.23	3629.57	3474.0
2013-08-23 09:00:00	NQ	Futures	3629.57	3655.29	3628.69	3645.06	57920.0
2013-08-23 10:00:00	NQ	Futures	3644.77	3650.61	3637.46	3647.1	37169.0
2013-08-23 11:00:00	NQ	Futures	3647.1	3648.86	3639.51	3643.3	17252.0
2013-08-23 12:00:00	NQ	Futures	3643.3	3649.73	3642.43	3648.56	10342.0
2013-08-23 13:00:00	NQ	Futures	3648.56	3650.32	3645.93	3647.1	6580.0
2013-08-23 14:00:00	NQ	Futures	3646.81	3650.32	3644.77	3648.56	7079.0
2013-08-23 15:00:00	NQ	Futures	3648.56	3654.7	3646.52	3649.44	29417.0
2013-08-23 16:00:00	NQ	Futures	3649.15	3652.07	3647.4	3649.73	8103.0
2013-08-23 17:00:00	NQ	Futures	3649.15	3649.73	3648.56	3648.56	44.0
2013-08-23 00:00:00	YM	Futures	15189.5	15192.6	15187.5	15191.5	196.0
2013-08-23 01:00:00	YM	Futures	15191.5	15194.6	15172.2	15176.3	1137.0
2013-08-23 02:00:00	YM	Futures	15176.3	15178.3	15165.1	15172.2	1095.0
2013-08-23 03:00:00	YM	Futures	15172.2	15172.2	15137.7	15149.9	4093.0
2013-08-23 04:00:00	YM	Futures	15148.9	15166.2	15140.8	15140.8	2609.0
2013-08-23 05:00:00	YM	Futures	15140.8	15158.0	15138.7	15156.0	1891.0
2013-08-23 06:00:00	YM	Futures	15158.0	15159.0	15148.9	15159.0	798.0
2013-08-23 07:00:00	YM	Futures	15158.0	15175.3	15156.0	15172.2	2330.0
2013-08-23 08:00:00	YM	Futures	15172.2	15181.4	15166.2	15175.3	2231.0
2013-08-23 09:00:00	YM	Futures	15174.3	15208.8	15172.2	15180.4	22378.0
2013-08-23 10:00:00	YM	Futures	15179.4	15206.8	15144.8	15201.7	28390.0
2013-08-23 11:00:00	YM	Futures	15201.7	15207.8	15173.3	15183.4	13859.0
2013-08-23 12:00:00	YM	Futures	15184.4	15204.7	15180.4	15202.7	5253.0
2013-08-23 13:00:00	YM	Futures	15202.7	15208.8	15190.5	15202.7	4776.0

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

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