PREVIEW / futures_1hour / 2013-04-18

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-04-18.parquet
  size:    51 KB
  rows:    1,559

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-18 00:00:00	ES	Futures	1594.19	1594.45	1592.9	1594.19	3767.0
2013-04-18 01:00:00	ES	Futures	1594.19	1594.19	1592.39	1593.67	6558.0
2013-04-18 02:00:00	ES	Futures	1593.67	1594.19	1592.39	1593.93	8516.0
2013-04-18 03:00:00	ES	Futures	1593.93	1594.96	1591.36	1594.45	33425.0
2013-04-18 04:00:00	ES	Futures	1594.45	1596.77	1593.67	1596.25	23374.0
2013-04-18 05:00:00	ES	Futures	1596.51	1600.11	1595.73	1598.05	29931.0
2013-04-18 06:00:00	ES	Futures	1598.05	1599.08	1596.51	1597.8	25198.0
2013-04-18 07:00:00	ES	Futures	1597.54	1600.63	1597.54	1598.31	33888.0
2013-04-18 08:00:00	ES	Futures	1598.31	1599.6	1597.28	1597.28	40420.0
2013-04-18 09:00:00	ES	Futures	1597.28	1597.8	1586.98	1588.52	302915.0
2013-04-18 10:00:00	ES	Futures	1588.52	1594.19	1582.08	1592.39	555644.0
2013-04-18 11:00:00	ES	Futures	1592.13	1592.64	1583.63	1586.72	265782.0
2013-04-18 12:00:00	ES	Futures	1586.72	1589.3	1584.4	1588.27	136799.0
2013-04-18 13:00:00	ES	Futures	1588.52	1590.84	1584.92	1586.46	112421.0
2013-04-18 14:00:00	ES	Futures	1586.46	1586.72	1577.19	1578.99	283271.0
2013-04-18 15:00:00	ES	Futures	1578.99	1585.95	1578.73	1583.37	274805.0
2013-04-18 16:00:00	ES	Futures	1583.63	1584.92	1579.76	1584.4	123395.0
2013-04-18 17:00:00	ES	Futures	1584.14	1584.66	1583.63	1583.89	2854.0
2013-04-18 18:00:00	ES	Futures	1583.63	1585.43	1581.83	1584.4	10279.0
2013-04-18 19:00:00	ES	Futures	1584.4	1585.69	1583.89	1585.43	4171.0
2013-04-18 20:00:00	ES	Futures	1585.43	1586.72	1584.14	1585.43	8209.0
2013-04-18 21:00:00	ES	Futures	1585.43	1588.52	1585.17	1588.27	9720.0
2013-04-18 22:00:00	ES	Futures	1588.27	1589.81	1587.49	1587.75	11709.0
2013-04-18 23:00:00	ES	Futures	1587.75	1588.78	1586.98	1587.49	5209.0
2013-04-18 00:00:00	NQ	Futures	3242.76	3243.06	3238.97	3240.72	665.0
2013-04-18 01:00:00	NQ	Futures	3240.43	3241.89	3238.1	3240.43	617.0
2013-04-18 02:00:00	NQ	Futures	3240.43	3240.72	3237.51	3238.97	1024.0
2013-04-18 03:00:00	NQ	Futures	3239.26	3243.35	3234.31	3241.6	3227.0
2013-04-18 04:00:00	NQ	Futures	3241.6	3244.81	3238.39	3244.51	2150.0
2013-04-18 05:00:00	NQ	Futures	3244.22	3252.68	3243.64	3248.31	2480.0
2013-04-18 06:00:00	NQ	Futures	3248.6	3250.35	3244.81	3246.26	2086.0
2013-04-18 07:00:00	NQ	Futures	3245.97	3252.39	3245.39	3249.47	4173.0
2013-04-18 08:00:00	NQ	Futures	3249.76	3252.39	3247.43	3247.43	4300.0
2013-04-18 09:00:00	NQ	Futures	3247.43	3248.6	3217.97	3219.43	42780.0
2013-04-18 10:00:00	NQ	Futures	3219.72	3228.47	3197.85	3223.81	76246.0
2013-04-18 11:00:00	NQ	Futures	3223.81	3224.39	3194.93	3205.72	41260.0
2013-04-18 12:00:00	NQ	Futures	3205.14	3208.06	3199.31	3205.14	26507.0
2013-04-18 13:00:00	NQ	Futures	3205.14	3209.51	3196.68	3200.47	17854.0
2013-04-18 14:00:00	NQ	Futures	3200.18	3200.18	3178.01	3182.68	45936.0
2013-04-18 15:00:00	NQ	Futures	3182.68	3195.51	3179.18	3191.14	43152.0
2013-04-18 16:00:00	NQ	Futures	3191.43	3210.1	3189.39	3208.93	23551.0
2013-04-18 17:00:00	NQ	Futures	3209.22	3209.22	3206.6	3206.89	447.0
2013-04-18 18:00:00	NQ	Futures	3203.97	3210.97	3202.81	3208.06	1395.0
2013-04-18 19:00:00	NQ	Futures	3207.76	3208.93	3206.6	3208.06	443.0
2013-04-18 20:00:00	NQ	Futures	3207.76	3209.51	3206.01	3208.35	646.0
2013-04-18 21:00:00	NQ	Futures	3208.35	3212.72	3207.18	3212.72	1389.0
2013-04-18 22:00:00	NQ	Futures	3212.72	3215.64	3210.97	3211.85	1009.0
2013-04-18 23:00:00	NQ	Futures	3211.85	3213.6	3210.1	3210.39	399.0
2013-04-18 00:00:00	YM	Futures	14730.5	14732.5	14713.3	14722.4	828.0
2013-04-18 01:00:00	YM	Futures	14721.4	14725.4	14709.3	14719.4	610.0

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

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