PREVIEW / futures_1hour / 2013-04-26

all futures 1-hour files

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

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-26 00:00:00	ES	Futures	1625.61	1626.65	1625.1	1626.13	2894.0
2013-04-26 01:00:00	ES	Futures	1626.13	1626.9	1625.36	1626.9	4533.0
2013-04-26 02:00:00	ES	Futures	1626.9	1629.48	1626.13	1628.96	11166.0
2013-04-26 03:00:00	ES	Futures	1628.96	1629.74	1625.36	1626.39	25475.0
2013-04-26 04:00:00	ES	Futures	1626.39	1627.16	1624.33	1625.1	22264.0
2013-04-26 05:00:00	ES	Futures	1625.1	1625.87	1623.81	1625.61	18093.0
2013-04-26 06:00:00	ES	Futures	1625.36	1625.61	1623.04	1625.1	21006.0
2013-04-26 07:00:00	ES	Futures	1625.1	1626.9	1624.33	1625.1	20264.0
2013-04-26 08:00:00	ES	Futures	1625.1	1626.9	1622.27	1625.61	64248.0
2013-04-26 09:00:00	ES	Futures	1625.36	1629.22	1624.07	1628.71	175476.0
2013-04-26 10:00:00	ES	Futures	1628.71	1629.48	1622.27	1623.55	252720.0
2013-04-26 11:00:00	ES	Futures	1623.81	1625.87	1621.24	1621.75	175439.0
2013-04-26 12:00:00	ES	Futures	1621.75	1623.55	1620.21	1623.3	119796.0
2013-04-26 13:00:00	ES	Futures	1623.3	1626.9	1622.52	1625.87	92726.0
2013-04-26 14:00:00	ES	Futures	1625.61	1627.16	1624.58	1625.61	71115.0
2013-04-26 15:00:00	ES	Futures	1625.87	1629.22	1625.36	1625.87	156290.0
2013-04-26 16:00:00	ES	Futures	1625.87	1626.13	1623.81	1624.58	65419.0
2013-04-26 17:00:00	ES	Futures	1624.58	1625.1	1624.33	1624.58	1706.0
2013-04-26 00:00:00	NQ	Futures	3308.97	3311.02	3308.1	3310.43	557.0
2013-04-26 01:00:00	NQ	Futures	3310.72	3311.02	3308.1	3310.43	391.0
2013-04-26 02:00:00	NQ	Futures	3310.72	3316.27	3310.72	3314.81	1013.0
2013-04-26 03:00:00	NQ	Futures	3314.52	3316.56	3308.68	3310.72	3126.0
2013-04-26 04:00:00	NQ	Futures	3311.31	3312.77	3304.89	3307.52	2446.0
2013-04-26 05:00:00	NQ	Futures	3307.52	3310.14	3304.6	3309.27	2404.0
2013-04-26 06:00:00	NQ	Futures	3309.27	3309.56	3304.6	3307.81	3356.0
2013-04-26 07:00:00	NQ	Futures	3307.52	3310.43	3305.47	3305.77	3490.0
2013-04-26 08:00:00	NQ	Futures	3305.77	3310.72	3302.56	3309.85	6766.0
2013-04-26 09:00:00	NQ	Futures	3309.56	3313.93	3305.47	3313.06	25407.0
2013-04-26 10:00:00	NQ	Futures	3313.06	3314.22	3294.39	3302.85	33404.0
2013-04-26 11:00:00	NQ	Futures	3302.56	3305.77	3294.97	3297.01	17929.0
2013-04-26 12:00:00	NQ	Futures	3297.01	3301.68	3292.64	3300.81	13420.0
2013-04-26 13:00:00	NQ	Futures	3300.81	3308.97	3299.64	3307.52	10769.0
2013-04-26 14:00:00	NQ	Futures	3307.22	3311.31	3304.89	3309.85	9261.0
2013-04-26 15:00:00	NQ	Futures	3309.85	3316.56	3306.35	3306.64	21709.0
2013-04-26 16:00:00	NQ	Futures	3306.64	3307.52	3303.43	3306.64	4676.0
2013-04-26 17:00:00	NQ	Futures	3306.64	3307.22	3305.77	3306.06	79.0
2013-04-26 00:00:00	YM	Futures	14789.1	14798.2	14788.1	14796.2	378.0
2013-04-26 01:00:00	YM	Futures	14796.2	14799.2	14787.1	14796.2	442.0
2013-04-26 02:00:00	YM	Futures	14797.2	14817.4	14793.2	14813.4	689.0
2013-04-26 03:00:00	YM	Futures	14813.4	14821.5	14785.1	14794.2	2139.0
2013-04-26 04:00:00	YM	Futures	14794.2	14799.2	14777.0	14781.0	2512.0
2013-04-26 05:00:00	YM	Futures	14781.0	14783.0	14771.9	14781.0	2117.0
2013-04-26 06:00:00	YM	Futures	14781.0	14782.0	14764.9	14779.0	1903.0
2013-04-26 07:00:00	YM	Futures	14779.0	14792.1	14776.0	14781.0	1875.0
2013-04-26 08:00:00	YM	Futures	14781.0	14792.1	14756.8	14774.0	5005.0
2013-04-26 09:00:00	YM	Futures	14772.9	14830.6	14768.9	14830.6	17780.0
2013-04-26 10:00:00	YM	Futures	14830.6	14840.7	14792.1	14811.4	25082.0
2013-04-26 11:00:00	YM	Futures	14810.3	14830.6	14786.1	14799.2	15443.0
2013-04-26 12:00:00	YM	Futures	14798.2	14808.3	14785.1	14806.3	11747.0
2013-04-26 13:00:00	YM	Futures	14805.3	14828.5	14799.2	14817.4	8380.0

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

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