PREVIEW / futures_1hour / 2013-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-22.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-03-22 00:00:00	ES	Futures	1586.2	1587.49	1585.95	1586.98	3379.0
2013-03-22 01:00:00	ES	Futures	1586.98	1587.23	1583.11	1584.14	9130.0
2013-03-22 02:00:00	ES	Futures	1583.89	1585.43	1581.57	1583.37	14167.0
2013-03-22 03:00:00	ES	Futures	1583.11	1585.95	1582.86	1585.17	9272.0
2013-03-22 04:00:00	ES	Futures	1585.17	1586.46	1583.63	1584.66	27333.0
2013-03-22 05:00:00	ES	Futures	1584.66	1586.46	1583.63	1585.69	23714.0
2013-03-22 06:00:00	ES	Futures	1585.69	1587.23	1585.17	1586.98	23223.0
2013-03-22 07:00:00	ES	Futures	1586.98	1590.58	1586.98	1589.3	30098.0
2013-03-22 08:00:00	ES	Futures	1589.3	1590.58	1588.52	1589.3	29420.0
2013-03-22 09:00:00	ES	Futures	1589.3	1593.16	1588.78	1591.87	215379.0
2013-03-22 10:00:00	ES	Futures	1592.13	1596.51	1591.87	1594.19	314612.0
2013-03-22 11:00:00	ES	Futures	1594.19	1597.8	1593.93	1594.96	197474.0
2013-03-22 12:00:00	ES	Futures	1594.96	1595.99	1593.42	1595.48	142077.0
2013-03-22 13:00:00	ES	Futures	1595.48	1598.83	1594.19	1595.73	125382.0
2013-03-22 14:00:00	ES	Futures	1595.73	1597.02	1594.96	1595.99	74482.0
2013-03-22 15:00:00	ES	Futures	1595.73	1598.05	1593.16	1598.05	184529.0
2013-03-22 16:00:00	ES	Futures	1598.05	1599.6	1597.28	1599.34	124013.0
2013-03-22 17:00:00	ES	Futures	1599.34	1601.14	1599.08	1600.89	5173.0
2013-03-22 00:00:00	NQ	Futures	3232.56	3234.6	3231.97	3234.01	220.0
2013-03-22 01:00:00	NQ	Futures	3234.01	3234.31	3226.72	3228.18	577.0
2013-03-22 02:00:00	NQ	Futures	3227.6	3231.1	3223.81	3227.01	1019.0
2013-03-22 03:00:00	NQ	Futures	3227.01	3231.1	3225.26	3230.51	1166.0
2013-03-22 04:00:00	NQ	Futures	3230.81	3233.14	3226.72	3228.76	1975.0
2013-03-22 05:00:00	NQ	Futures	3229.06	3233.14	3227.31	3231.97	1513.0
2013-03-22 06:00:00	NQ	Futures	3231.39	3234.89	3231.1	3233.72	1788.0
2013-03-22 07:00:00	NQ	Futures	3234.01	3240.72	3233.72	3239.56	3045.0
2013-03-22 08:00:00	NQ	Futures	3239.56	3240.72	3238.1	3239.56	2200.0
2013-03-22 09:00:00	NQ	Futures	3239.56	3247.14	3238.97	3243.35	25209.0
2013-03-22 10:00:00	NQ	Futures	3243.35	3251.51	3243.35	3247.14	31618.0
2013-03-22 11:00:00	NQ	Futures	3247.14	3252.1	3245.1	3247.72	19600.0
2013-03-22 12:00:00	NQ	Futures	3248.01	3255.6	3246.85	3255.31	18017.0
2013-03-22 13:00:00	NQ	Futures	3255.31	3264.06	3253.56	3259.39	23727.0
2013-03-22 14:00:00	NQ	Futures	3259.39	3261.72	3256.18	3257.35	12457.0
2013-03-22 15:00:00	NQ	Futures	3257.35	3260.26	3252.1	3260.26	25371.0
2013-03-22 16:00:00	NQ	Futures	3260.26	3263.47	3258.51	3263.18	8741.0
2013-03-22 17:00:00	NQ	Futures	3262.89	3266.1	3261.72	3266.1	484.0
2013-03-22 00:00:00	YM	Futures	14514.1	14524.2	14513.1	14521.2	311.0
2013-03-22 01:00:00	YM	Futures	14522.2	14523.2	14492.9	14498.0	943.0
2013-03-22 02:00:00	YM	Futures	14498.0	14509.1	14481.8	14491.9	1289.0
2013-03-22 03:00:00	YM	Futures	14491.9	14512.1	14490.9	14508.1	737.0
2013-03-22 04:00:00	YM	Futures	14509.1	14518.2	14493.9	14504.0	2501.0
2013-03-22 05:00:00	YM	Futures	14505.0	14518.2	14497.0	14514.1	1858.0
2013-03-22 06:00:00	YM	Futures	14513.1	14525.3	14509.1	14524.2	1793.0
2013-03-22 07:00:00	YM	Futures	14525.3	14548.5	14524.2	14540.4	3530.0
2013-03-22 08:00:00	YM	Futures	14540.4	14549.5	14535.4	14543.5	3348.0
2013-03-22 09:00:00	YM	Futures	14543.5	14577.8	14538.4	14562.7	22084.0
2013-03-22 10:00:00	YM	Futures	14562.7	14597.0	14562.7	14578.8	28280.0
2013-03-22 11:00:00	YM	Futures	14578.8	14606.1	14575.8	14582.9	18768.0
2013-03-22 12:00:00	YM	Futures	14582.9	14590.0	14572.8	14584.9	12313.0
2013-03-22 13:00:00	YM	Futures	14584.9	14605.1	14576.8	14585.9	11170.0

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

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