PREVIEW / futures_1hour / 2013-08-14

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-08-14.parquet
  size:    48 KB
  rows:    1,508

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-14 00:00:00	ES	Futures	1745.62	1745.62	1744.84	1745.62	3229.0
2013-08-14 01:00:00	ES	Futures	1745.62	1746.91	1745.62	1746.91	2840.0
2013-08-14 02:00:00	ES	Futures	1746.65	1747.42	1745.62	1745.87	5349.0
2013-08-14 03:00:00	ES	Futures	1745.87	1746.65	1742.77	1743.81	19200.0
2013-08-14 04:00:00	ES	Futures	1743.81	1745.1	1742.51	1744.32	15672.0
2013-08-14 05:00:00	ES	Futures	1744.06	1745.1	1743.29	1744.84	9918.0
2013-08-14 06:00:00	ES	Futures	1744.84	1746.39	1744.84	1746.13	8851.0
2013-08-14 07:00:00	ES	Futures	1746.13	1746.39	1745.36	1746.13	10590.0
2013-08-14 08:00:00	ES	Futures	1746.13	1746.13	1742.77	1745.62	33514.0
2013-08-14 09:00:00	ES	Futures	1745.62	1750.79	1745.36	1748.46	211795.0
2013-08-14 10:00:00	ES	Futures	1748.46	1749.23	1740.96	1742.77	260232.0
2013-08-14 11:00:00	ES	Futures	1742.77	1744.58	1740.96	1742.0	203970.0
2013-08-14 12:00:00	ES	Futures	1742.0	1745.1	1741.74	1742.77	107667.0
2013-08-14 13:00:00	ES	Futures	1742.77	1744.06	1739.15	1741.22	178830.0
2013-08-14 14:00:00	ES	Futures	1741.22	1742.77	1739.41	1741.74	119720.0
2013-08-14 15:00:00	ES	Futures	1742.0	1744.58	1739.15	1739.67	198692.0
2013-08-14 16:00:00	ES	Futures	1739.93	1740.19	1738.12	1739.15	79446.0
2013-08-14 17:00:00	ES	Futures	1739.15	1739.41	1738.12	1738.12	4519.0
2013-08-14 18:00:00	ES	Futures	1737.6	1737.86	1733.98	1735.53	11284.0
2013-08-14 19:00:00	ES	Futures	1735.53	1736.05	1734.76	1735.02	2755.0
2013-08-14 20:00:00	ES	Futures	1734.76	1736.83	1734.76	1736.57	5448.0
2013-08-14 21:00:00	ES	Futures	1736.31	1738.64	1736.31	1738.12	8481.0
2013-08-14 22:00:00	ES	Futures	1738.38	1739.15	1737.6	1738.38	5851.0
2013-08-14 23:00:00	ES	Futures	1738.12	1738.38	1736.31	1738.12	5002.0
2013-08-14 00:00:00	NQ	Futures	3665.51	3666.1	3664.93	3665.51	303.0
2013-08-14 01:00:00	NQ	Futures	3665.81	3668.44	3665.51	3667.56	582.0
2013-08-14 02:00:00	NQ	Futures	3667.85	3669.61	3665.51	3666.1	858.0
2013-08-14 03:00:00	NQ	Futures	3666.1	3667.85	3660.25	3662.01	3301.0
2013-08-14 04:00:00	NQ	Futures	3662.3	3665.81	3661.72	3664.64	2353.0
2013-08-14 05:00:00	NQ	Futures	3664.35	3666.68	3661.42	3666.39	1570.0
2013-08-14 06:00:00	NQ	Futures	3666.68	3669.31	3666.39	3669.02	1555.0
2013-08-14 07:00:00	NQ	Futures	3668.73	3669.31	3667.56	3668.44	1225.0
2013-08-14 08:00:00	NQ	Futures	3668.44	3668.44	3661.13	3666.68	3575.0
2013-08-14 09:00:00	NQ	Futures	3666.98	3674.87	3662.88	3671.36	36685.0
2013-08-14 10:00:00	NQ	Futures	3671.36	3673.4	3651.78	3659.96	43667.0
2013-08-14 11:00:00	NQ	Futures	3659.67	3664.05	3656.75	3659.96	20169.0
2013-08-14 12:00:00	NQ	Futures	3659.96	3669.31	3659.67	3664.05	15250.0
2013-08-14 13:00:00	NQ	Futures	3663.76	3666.1	3654.41	3658.21	25201.0
2013-08-14 14:00:00	NQ	Futures	3657.92	3665.22	3656.75	3664.05	27082.0
2013-08-14 15:00:00	NQ	Futures	3664.35	3668.14	3656.46	3657.04	35847.0
2013-08-14 16:00:00	NQ	Futures	3657.04	3657.92	3644.77	3646.23	9571.0
2013-08-14 17:00:00	NQ	Futures	3645.93	3645.93	3640.38	3641.84	2049.0
2013-08-14 18:00:00	NQ	Futures	3638.92	3640.38	3631.62	3633.08	1512.0
2013-08-14 19:00:00	NQ	Futures	3633.08	3633.95	3631.03	3632.2	569.0
2013-08-14 20:00:00	NQ	Futures	3632.2	3636.0	3631.91	3636.0	678.0
2013-08-14 21:00:00	NQ	Futures	3636.29	3640.09	3635.41	3639.21	1000.0
2013-08-14 22:00:00	NQ	Futures	3639.51	3640.97	3638.63	3638.92	702.0
2013-08-14 23:00:00	NQ	Futures	3638.92	3639.21	3634.83	3638.92	688.0
2013-08-14 00:00:00	YM	Futures	15633.4	15635.4	15629.3	15632.4	351.0
2013-08-14 01:00:00	YM	Futures	15633.4	15643.5	15633.4	15639.5	548.0

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

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