PREVIEW / futures_1hour / 2013-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-11.parquet
  size:    51 KB
  rows:    1,560

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-11 00:00:00	ES	Futures	1721.58	1722.35	1720.8	1722.09	4426.0
2013-07-11 01:00:00	ES	Futures	1721.83	1724.16	1721.58	1723.9	10255.0
2013-07-11 02:00:00	ES	Futures	1723.9	1724.16	1720.54	1720.8	19491.0
2013-07-11 03:00:00	ES	Futures	1720.8	1722.35	1719.51	1721.06	38882.0
2013-07-11 04:00:00	ES	Futures	1721.06	1722.87	1720.02	1722.61	21432.0
2013-07-11 05:00:00	ES	Futures	1722.87	1723.13	1719.77	1721.32	18253.0
2013-07-11 06:00:00	ES	Futures	1721.06	1722.09	1719.25	1720.8	21435.0
2013-07-11 07:00:00	ES	Futures	1720.54	1724.16	1720.28	1722.35	31592.0
2013-07-11 08:00:00	ES	Futures	1722.35	1723.38	1719.77	1720.54	47914.0
2013-07-11 09:00:00	ES	Futures	1720.8	1723.64	1718.73	1720.28	210888.0
2013-07-11 10:00:00	ES	Futures	1720.28	1721.32	1717.18	1720.54	223950.0
2013-07-11 11:00:00	ES	Futures	1720.54	1722.61	1720.28	1721.83	115745.0
2013-07-11 12:00:00	ES	Futures	1721.83	1721.83	1719.51	1720.8	75820.0
2013-07-11 13:00:00	ES	Futures	1720.54	1721.58	1719.51	1721.32	66592.0
2013-07-11 14:00:00	ES	Futures	1721.32	1727.0	1720.8	1725.19	157052.0
2013-07-11 15:00:00	ES	Futures	1724.94	1728.55	1724.42	1726.49	189035.0
2013-07-11 16:00:00	ES	Futures	1726.49	1728.04	1726.23	1726.75	107267.0
2013-07-11 17:00:00	ES	Futures	1726.75	1726.75	1725.97	1726.23	1864.0
2013-07-11 18:00:00	ES	Futures	1725.71	1727.52	1725.45	1725.71	4209.0
2013-07-11 19:00:00	ES	Futures	1725.71	1725.97	1724.16	1724.42	3303.0
2013-07-11 20:00:00	ES	Futures	1724.42	1724.68	1722.87	1723.38	7147.0
2013-07-11 21:00:00	ES	Futures	1723.38	1725.45	1723.13	1725.19	4563.0
2013-07-11 22:00:00	ES	Futures	1725.19	1725.71	1724.42	1725.19	1582.0
2013-07-11 23:00:00	ES	Futures	1725.19	1725.45	1723.64	1724.42	2621.0
2013-07-11 00:00:00	NQ	Futures	3535.18	3536.93	3534.59	3535.76	627.0
2013-07-11 01:00:00	NQ	Futures	3535.47	3539.56	3535.18	3538.68	906.0
2013-07-11 02:00:00	NQ	Futures	3538.68	3540.15	3534.01	3534.59	1952.0
2013-07-11 03:00:00	NQ	Futures	3534.3	3541.9	3531.96	3539.56	7161.0
2013-07-11 04:00:00	NQ	Futures	3539.85	3541.9	3535.76	3538.98	3045.0
2013-07-11 05:00:00	NQ	Futures	3539.27	3539.56	3531.96	3534.01	2551.0
2013-07-11 06:00:00	NQ	Futures	3534.01	3535.76	3530.5	3532.25	2677.0
2013-07-11 07:00:00	NQ	Futures	3532.25	3539.27	3531.67	3536.05	4719.0
2013-07-11 08:00:00	NQ	Futures	3535.76	3538.1	3531.96	3532.55	7621.0
2013-07-11 09:00:00	NQ	Futures	3532.84	3545.7	3532.55	3542.78	33009.0
2013-07-11 10:00:00	NQ	Futures	3542.78	3550.96	3537.81	3549.5	30907.0
2013-07-11 11:00:00	NQ	Futures	3549.5	3556.51	3548.62	3555.93	20510.0
2013-07-11 12:00:00	NQ	Futures	3555.93	3559.14	3553.0	3559.14	13689.0
2013-07-11 13:00:00	NQ	Futures	3559.14	3561.19	3555.05	3559.73	11602.0
2013-07-11 14:00:00	NQ	Futures	3559.73	3570.25	3557.68	3565.86	18212.0
2013-07-11 15:00:00	NQ	Futures	3565.57	3572.0	3564.99	3571.71	25440.0
2013-07-11 16:00:00	NQ	Futures	3571.71	3574.63	3568.2	3570.25	8494.0
2013-07-11 17:00:00	NQ	Futures	3570.25	3570.25	3569.66	3570.25	157.0
2013-07-11 18:00:00	NQ	Futures	3568.78	3572.58	3568.2	3570.54	653.0
2013-07-11 19:00:00	NQ	Futures	3570.25	3570.54	3567.32	3567.62	342.0
2013-07-11 20:00:00	NQ	Futures	3567.62	3568.2	3564.99	3567.03	1003.0
2013-07-11 21:00:00	NQ	Futures	3566.74	3570.83	3566.45	3570.54	559.0
2013-07-11 22:00:00	NQ	Futures	3570.54	3570.83	3569.08	3569.95	284.0
2013-07-11 23:00:00	NQ	Futures	3570.25	3571.12	3567.91	3568.78	443.0
2013-07-11 00:00:00	YM	Futures	15623.2	15630.3	15620.2	15626.3	559.0
2013-07-11 01:00:00	YM	Futures	15626.3	15641.5	15625.2	15639.5	770.0

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

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