PREVIEW / futures_1hour / 2013-07-26

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-26.parquet
  size:    42 KB
  rows:    1,228

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-07-26 00:00:00	ES	Futures	1744.84	1746.39	1744.58	1745.36	4000.0
2013-07-26 01:00:00	ES	Futures	1745.1	1745.36	1743.55	1743.81	4246.0
2013-07-26 02:00:00	ES	Futures	1743.81	1744.32	1742.26	1743.29	7057.0
2013-07-26 03:00:00	ES	Futures	1743.29	1745.36	1739.15	1739.93	25626.0
2013-07-26 04:00:00	ES	Futures	1739.93	1741.48	1739.15	1741.22	16646.0
2013-07-26 05:00:00	ES	Futures	1741.22	1741.48	1735.79	1736.31	19808.0
2013-07-26 06:00:00	ES	Futures	1736.31	1737.34	1735.02	1736.83	17899.0
2013-07-26 07:00:00	ES	Futures	1736.57	1737.34	1733.47	1734.24	24981.0
2013-07-26 08:00:00	ES	Futures	1733.98	1735.28	1731.92	1731.92	34265.0
2013-07-26 09:00:00	ES	Futures	1732.17	1737.09	1731.92	1736.57	164295.0
2013-07-26 10:00:00	ES	Futures	1736.57	1738.12	1727.26	1729.07	288268.0
2013-07-26 11:00:00	ES	Futures	1728.81	1733.72	1727.26	1733.21	162334.0
2013-07-26 12:00:00	ES	Futures	1733.21	1736.57	1733.21	1735.02	90314.0
2013-07-26 13:00:00	ES	Futures	1735.28	1739.41	1735.02	1738.12	102428.0
2013-07-26 14:00:00	ES	Futures	1738.12	1740.96	1736.31	1739.67	121606.0
2013-07-26 15:00:00	ES	Futures	1739.67	1744.58	1738.89	1744.32	209387.0
2013-07-26 16:00:00	ES	Futures	1744.32	1745.1	1743.29	1744.32	70588.0
2013-07-26 17:00:00	ES	Futures	1744.06	1744.84	1743.81	1744.32	2086.0
2013-07-26 00:00:00	NQ	Futures	3572.29	3574.63	3572.0	3572.88	491.0
2013-07-26 01:00:00	NQ	Futures	3573.17	3573.46	3569.95	3570.25	550.0
2013-07-26 02:00:00	NQ	Futures	3569.66	3573.17	3568.2	3570.83	749.0
2013-07-26 03:00:00	NQ	Futures	3570.83	3575.51	3562.06	3563.23	4033.0
2013-07-26 04:00:00	NQ	Futures	3562.94	3567.62	3561.19	3566.15	2867.0
2013-07-26 05:00:00	NQ	Futures	3566.45	3567.32	3555.05	3555.93	2985.0
2013-07-26 06:00:00	NQ	Futures	3555.63	3558.26	3553.88	3558.26	2764.0
2013-07-26 07:00:00	NQ	Futures	3557.97	3560.02	3555.93	3557.09	2645.0
2013-07-26 08:00:00	NQ	Futures	3557.09	3560.31	3553.0	3553.0	3545.0
2013-07-26 09:00:00	NQ	Futures	3553.0	3569.08	3551.83	3567.62	26506.0
2013-07-26 10:00:00	NQ	Futures	3567.91	3569.37	3550.67	3556.8	33299.0
2013-07-26 11:00:00	NQ	Futures	3556.51	3569.95	3553.3	3568.49	20429.0
2013-07-26 12:00:00	NQ	Futures	3568.78	3574.92	3568.2	3572.0	16765.0
2013-07-26 13:00:00	NQ	Futures	3572.0	3581.64	3571.41	3577.26	14807.0
2013-07-26 14:00:00	NQ	Futures	3577.26	3582.23	3572.29	3580.18	13606.0
2013-07-26 15:00:00	NQ	Futures	3579.89	3590.12	3577.55	3590.12	26924.0
2013-07-26 16:00:00	NQ	Futures	3589.83	3592.75	3588.36	3591.87	6905.0
2013-07-26 17:00:00	NQ	Futures	3591.58	3592.46	3591.58	3592.46	195.0
2013-07-26 00:00:00	YM	Futures	15751.2	15764.4	15750.2	15755.2	722.0
2013-07-26 01:00:00	YM	Futures	15754.2	15758.3	15745.1	15745.1	593.0
2013-07-26 02:00:00	YM	Futures	15745.1	15753.2	15737.0	15742.0	797.0
2013-07-26 03:00:00	YM	Futures	15743.1	15765.4	15717.7	15724.8	3032.0
2013-07-26 04:00:00	YM	Futures	15723.8	15737.0	15717.7	15732.9	1977.0
2013-07-26 05:00:00	YM	Futures	15732.9	15734.9	15691.3	15697.4	3228.0
2013-07-26 06:00:00	YM	Futures	15695.3	15700.4	15682.1	15692.3	2849.0
2013-07-26 07:00:00	YM	Futures	15691.3	15696.3	15673.0	15676.0	2547.0
2013-07-26 08:00:00	YM	Futures	15676.0	15678.1	15643.5	15644.5	4466.0
2013-07-26 09:00:00	YM	Futures	15643.5	15678.1	15642.5	15673.0	14516.0
2013-07-26 10:00:00	YM	Futures	15674.0	15688.2	15586.6	15596.8	25867.0
2013-07-26 11:00:00	YM	Futures	15595.8	15635.4	15583.6	15630.3	12836.0
2013-07-26 12:00:00	YM	Futures	15630.3	15666.9	15630.3	15653.7	9232.0
2013-07-26 13:00:00	YM	Futures	15653.7	15697.4	15652.7	15686.2	9897.0

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

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