PREVIEW / futures_1hour / 2013-07-23

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-07-23.parquet
  size:    49 KB
  rows:    1,515

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-23 00:00:00	ES	Futures	1752.34	1753.11	1751.82	1752.34	5214.0
2013-07-23 01:00:00	ES	Futures	1752.34	1752.85	1751.56	1752.08	3925.0
2013-07-23 02:00:00	ES	Futures	1752.08	1752.85	1751.56	1752.08	4881.0
2013-07-23 03:00:00	ES	Futures	1752.34	1752.85	1749.23	1749.75	18328.0
2013-07-23 04:00:00	ES	Futures	1750.01	1751.3	1749.49	1751.04	12122.0
2013-07-23 05:00:00	ES	Futures	1750.79	1751.56	1749.75	1751.3	11522.0
2013-07-23 06:00:00	ES	Futures	1751.04	1752.08	1750.27	1751.56	11066.0
2013-07-23 07:00:00	ES	Futures	1751.56	1751.82	1749.23	1751.04	16223.0
2013-07-23 08:00:00	ES	Futures	1751.04	1751.3	1749.75	1750.27	15316.0
2013-07-23 09:00:00	ES	Futures	1750.27	1752.08	1748.46	1749.49	134486.0
2013-07-23 10:00:00	ES	Futures	1749.49	1749.75	1744.06	1744.58	189516.0
2013-07-23 11:00:00	ES	Futures	1744.32	1747.17	1743.29	1745.87	129001.0
2013-07-23 12:00:00	ES	Futures	1746.13	1746.91	1744.58	1745.62	54130.0
2013-07-23 13:00:00	ES	Futures	1745.62	1748.46	1745.36	1746.91	64447.0
2013-07-23 14:00:00	ES	Futures	1746.65	1749.23	1746.39	1748.72	61868.0
2013-07-23 15:00:00	ES	Futures	1748.72	1748.72	1743.81	1745.36	144929.0
2013-07-23 16:00:00	ES	Futures	1745.62	1748.72	1744.32	1747.68	71643.0
2013-07-23 17:00:00	ES	Futures	1747.68	1747.94	1746.39	1747.17	2597.0
2013-07-23 18:00:00	ES	Futures	1746.91	1747.17	1744.84	1746.39	4256.0
2013-07-23 19:00:00	ES	Futures	1746.39	1747.17	1746.13	1746.65	1002.0
2013-07-23 20:00:00	ES	Futures	1746.65	1746.91	1744.58	1744.84	4673.0
2013-07-23 21:00:00	ES	Futures	1744.58	1746.13	1744.32	1745.1	6313.0
2013-07-23 22:00:00	ES	Futures	1744.84	1745.36	1744.32	1744.84	2432.0
2013-07-23 23:00:00	ES	Futures	1744.84	1746.13	1744.32	1746.13	2083.0
2013-07-23 00:00:00	NQ	Futures	3574.92	3576.97	3574.63	3575.21	482.0
2013-07-23 01:00:00	NQ	Futures	3575.51	3576.67	3574.04	3574.63	452.0
2013-07-23 02:00:00	NQ	Futures	3574.63	3576.38	3574.04	3574.34	565.0
2013-07-23 03:00:00	NQ	Futures	3574.34	3575.21	3566.45	3567.91	3012.0
2013-07-23 04:00:00	NQ	Futures	3568.2	3571.12	3566.15	3570.25	1662.0
2013-07-23 05:00:00	NQ	Futures	3570.25	3570.83	3568.2	3570.54	1246.0
2013-07-23 06:00:00	NQ	Futures	3570.54	3573.46	3568.78	3572.58	1314.0
2013-07-23 07:00:00	NQ	Futures	3572.58	3573.46	3568.78	3570.83	1740.0
2013-07-23 08:00:00	NQ	Futures	3570.83	3571.12	3565.86	3567.03	2496.0
2013-07-23 09:00:00	NQ	Futures	3567.03	3570.83	3559.14	3559.14	19204.0
2013-07-23 10:00:00	NQ	Futures	3559.43	3559.73	3543.65	3545.11	30963.0
2013-07-23 11:00:00	NQ	Futures	3544.82	3551.54	3542.78	3548.91	16768.0
2013-07-23 12:00:00	NQ	Futures	3548.91	3550.67	3543.94	3545.99	9093.0
2013-07-23 13:00:00	NQ	Futures	3545.99	3555.05	3545.99	3550.67	11275.0
2013-07-23 14:00:00	NQ	Futures	3550.67	3552.42	3545.11	3550.37	10372.0
2013-07-23 15:00:00	NQ	Futures	3550.37	3550.67	3534.3	3538.1	31140.0
2013-07-23 16:00:00	NQ	Futures	3538.39	3558.85	3536.64	3557.68	16427.0
2013-07-23 17:00:00	NQ	Futures	3557.97	3557.97	3553.88	3554.17	418.0
2013-07-23 18:00:00	NQ	Futures	3551.25	3553.0	3548.33	3552.71	585.0
2013-07-23 19:00:00	NQ	Futures	3552.42	3553.88	3551.54	3552.71	189.0
2013-07-23 20:00:00	NQ	Futures	3552.71	3553.3	3549.2	3549.5	688.0
2013-07-23 21:00:00	NQ	Futures	3549.79	3552.42	3548.91	3550.67	890.0
2013-07-23 22:00:00	NQ	Futures	3550.37	3551.25	3548.91	3549.79	344.0
2013-07-23 23:00:00	NQ	Futures	3550.08	3553.59	3549.5	3553.59	299.0
2013-07-23 00:00:00	YM	Futures	15775.6	15783.7	15773.5	15775.6	589.0
2013-07-23 01:00:00	YM	Futures	15774.5	15777.6	15768.5	15771.5	708.0

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

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