PREVIEW / futures_1hour / 2013-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-25.parquet
  size:    49 KB
  rows:    1,540

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-04-25 00:00:00	ES	Futures	1624.07	1624.07	1623.04	1623.3	1248.0
2013-04-25 01:00:00	ES	Futures	1623.55	1623.81	1622.27	1622.27	3819.0
2013-04-25 02:00:00	ES	Futures	1622.52	1623.3	1621.49	1623.04	6680.0
2013-04-25 03:00:00	ES	Futures	1623.04	1624.58	1621.75	1623.04	27086.0
2013-04-25 04:00:00	ES	Futures	1622.78	1624.58	1622.27	1624.58	19657.0
2013-04-25 05:00:00	ES	Futures	1624.58	1626.65	1624.07	1625.1	22569.0
2013-04-25 06:00:00	ES	Futures	1625.1	1626.9	1625.1	1626.65	17199.0
2013-04-25 07:00:00	ES	Futures	1626.39	1628.96	1626.13	1627.68	35678.0
2013-04-25 08:00:00	ES	Futures	1627.68	1630.77	1627.68	1628.45	59004.0
2013-04-25 09:00:00	ES	Futures	1628.71	1628.96	1624.33	1627.16	222535.0
2013-04-25 10:00:00	ES	Futures	1627.42	1634.12	1626.9	1633.08	295262.0
2013-04-25 11:00:00	ES	Futures	1633.08	1634.12	1631.28	1631.8	128943.0
2013-04-25 12:00:00	ES	Futures	1631.8	1633.86	1631.02	1633.6	83681.0
2013-04-25 13:00:00	ES	Futures	1633.6	1636.18	1632.57	1635.4	122409.0
2013-04-25 14:00:00	ES	Futures	1635.66	1636.43	1629.74	1631.02	141130.0
2013-04-25 15:00:00	ES	Futures	1630.77	1631.02	1626.13	1628.96	294681.0
2013-04-25 16:00:00	ES	Futures	1628.96	1630.51	1628.71	1628.96	74244.0
2013-04-25 17:00:00	ES	Futures	1628.96	1629.74	1628.71	1629.22	2417.0
2013-04-25 18:00:00	ES	Futures	1629.48	1630.25	1628.71	1629.22	3959.0
2013-04-25 19:00:00	ES	Futures	1628.96	1629.22	1627.42	1627.68	2307.0
2013-04-25 20:00:00	ES	Futures	1627.42	1628.71	1626.9	1628.19	4550.0
2013-04-25 21:00:00	ES	Futures	1628.19	1630.51	1627.93	1630.25	5378.0
2013-04-25 22:00:00	ES	Futures	1630.25	1630.51	1624.84	1626.65	10314.0
2013-04-25 23:00:00	ES	Futures	1626.9	1626.9	1625.1	1625.36	4983.0
2013-04-25 00:00:00	NQ	Futures	3299.93	3300.51	3298.76	3299.64	136.0
2013-04-25 01:00:00	NQ	Futures	3299.93	3300.51	3297.6	3297.6	408.0
2013-04-25 02:00:00	NQ	Futures	3297.31	3299.64	3295.85	3297.89	449.0
2013-04-25 03:00:00	NQ	Futures	3298.18	3301.68	3296.43	3298.47	2941.0
2013-04-25 04:00:00	NQ	Futures	3297.89	3304.01	3296.72	3304.01	2143.0
2013-04-25 05:00:00	NQ	Futures	3304.01	3308.68	3301.68	3304.6	3169.0
2013-04-25 06:00:00	NQ	Futures	3304.89	3308.39	3304.01	3307.52	2191.0
2013-04-25 07:00:00	NQ	Futures	3307.81	3311.02	3306.64	3308.68	3720.0
2013-04-25 08:00:00	NQ	Futures	3308.68	3318.02	3308.1	3313.35	6741.0
2013-04-25 09:00:00	NQ	Futures	3313.35	3322.1	3307.81	3317.43	40461.0
2013-04-25 10:00:00	NQ	Futures	3317.43	3330.27	3314.81	3325.6	36406.0
2013-04-25 11:00:00	NQ	Futures	3325.6	3328.81	3319.18	3321.22	16829.0
2013-04-25 12:00:00	NQ	Futures	3321.22	3325.89	3319.47	3324.14	11226.0
2013-04-25 13:00:00	NQ	Futures	3324.14	3327.93	3322.39	3323.56	10101.0
2013-04-25 14:00:00	NQ	Futures	3323.85	3327.64	3315.97	3319.18	14153.0
2013-04-25 15:00:00	NQ	Futures	3319.18	3321.52	3308.97	3317.43	29361.0
2013-04-25 16:00:00	NQ	Futures	3317.43	3322.39	3313.06	3318.89	11767.0
2013-04-25 17:00:00	NQ	Futures	3318.89	3319.18	3315.1	3315.68	689.0
2013-04-25 18:00:00	NQ	Futures	3314.52	3315.68	3312.18	3313.35	719.0
2013-04-25 19:00:00	NQ	Futures	3313.35	3313.64	3311.6	3311.89	387.0
2013-04-25 20:00:00	NQ	Futures	3312.18	3314.22	3310.72	3313.35	654.0
2013-04-25 21:00:00	NQ	Futures	3313.64	3318.89	3313.06	3318.31	839.0
2013-04-25 22:00:00	NQ	Futures	3318.02	3318.6	3307.52	3311.31	1672.0
2013-04-25 23:00:00	NQ	Futures	3311.31	3311.31	3308.1	3308.39	634.0
2013-04-25 00:00:00	YM	Futures	14801.2	14801.2	14794.2	14797.2	238.0
2013-04-25 01:00:00	YM	Futures	14796.2	14801.2	14790.1	14790.1	288.0

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

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