PREVIEW / futures_1hour / 2013-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-03-12.parquet
  size:    47 KB
  rows:    1,519

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-12 00:00:00	ES	Futures	1595.48	1596.25	1595.48	1595.74	743.0
2013-03-12 01:00:00	ES	Futures	1595.74	1595.74	1594.97	1595.23	986.0
2013-03-12 02:00:00	ES	Futures	1595.23	1595.23	1594.46	1594.97	1771.0
2013-03-12 03:00:00	ES	Futures	1594.71	1595.23	1594.2	1594.46	3058.0
2013-03-12 04:00:00	ES	Futures	1594.46	1595.74	1593.94	1595.48	4197.0
2013-03-12 05:00:00	ES	Futures	1595.74	1596.51	1594.2	1594.97	6489.0
2013-03-12 06:00:00	ES	Futures	1594.97	1595.23	1593.43	1594.46	3824.0
2013-03-12 07:00:00	ES	Futures	1594.71	1594.97	1593.17	1593.69	5486.0
2013-03-12 08:00:00	ES	Futures	1593.69	1595.74	1593.69	1595.23	5681.0
2013-03-12 09:00:00	ES	Futures	1595.23	1596.25	1593.69	1595.48	17251.0
2013-03-12 10:00:00	ES	Futures	1595.48	1597.54	1594.71	1594.71	25177.0
2013-03-12 11:00:00	ES	Futures	1594.71	1594.97	1589.33	1593.69	40427.0
2013-03-12 12:00:00	ES	Futures	1593.17	1593.69	1590.35	1592.92	22663.0
2013-03-12 13:00:00	ES	Futures	1593.17	1593.17	1590.09	1590.61	13072.0
2013-03-12 14:00:00	ES	Futures	1590.35	1591.38	1588.3	1590.35	19377.0
2013-03-12 15:00:00	ES	Futures	1590.35	1594.2	1590.09	1593.43	21411.0
2013-03-12 16:00:00	ES	Futures	1593.43	1594.46	1591.89	1594.46	11282.0
2013-03-12 17:00:00	ES	Futures	1594.46	1594.46	1593.94	1594.2	111.0
2013-03-12 18:00:00	ES	Futures	1593.94	1594.2	1593.17	1593.17	334.0
2013-03-12 19:00:00	ES	Futures	1593.43	1594.2	1593.43	1593.94	475.0
2013-03-12 20:00:00	ES	Futures	1593.69	1595.74	1593.69	1595.48	597.0
2013-03-12 21:00:00	ES	Futures	1595.74	1596.51	1594.97	1595.48	1699.0
2013-03-12 22:00:00	ES	Futures	1595.23	1595.23	1593.69	1593.94	549.0
2013-03-12 23:00:00	ES	Futures	1593.69	1593.94	1592.66	1593.43	542.0
2013-03-12 00:00:00	NQ	Futures	3267.54	3269.29	3267.25	3267.54	281.0
2013-03-12 01:00:00	NQ	Futures	3267.25	3267.83	3265.5	3265.8	324.0
2013-03-12 02:00:00	NQ	Futures	3265.5	3266.38	3264.34	3265.5	313.0
2013-03-12 03:00:00	NQ	Futures	3265.21	3266.09	3264.63	3265.5	102.0
2013-03-12 04:00:00	NQ	Futures	3265.8	3267.54	3263.47	3266.38	340.0
2013-03-12 05:00:00	NQ	Futures	3267.25	3267.54	3264.34	3265.5	275.0
2013-03-12 06:00:00	NQ	Futures	3265.21	3265.8	3262.59	3265.5	192.0
2013-03-12 07:00:00	NQ	Futures	3265.21	3265.5	3261.72	3262.3	277.0
2013-03-12 08:00:00	NQ	Futures	3262.3	3265.8	3262.3	3264.05	311.0
2013-03-12 09:00:00	NQ	Futures	3264.05	3271.33	3259.39	3268.12	2963.0
2013-03-12 10:00:00	NQ	Futures	3268.12	3270.16	3257.35	3261.14	3122.0
2013-03-12 11:00:00	NQ	Futures	3261.72	3261.72	3245.71	3255.61	7621.0
2013-03-12 12:00:00	NQ	Futures	3255.9	3259.97	3251.53	3258.52	1841.0
2013-03-12 13:00:00	NQ	Futures	3258.52	3260.85	3251.82	3253.28	2351.0
2013-03-12 14:00:00	NQ	Futures	3253.28	3255.32	3248.33	3251.82	1187.0
2013-03-12 15:00:00	NQ	Futures	3252.11	3263.18	3252.11	3261.14	4622.0
2013-03-12 16:00:00	NQ	Futures	3261.43	3264.05	3259.68	3264.05	1015.0
2013-03-12 17:00:00	NQ	Futures	3264.05	3264.92	3263.76	3264.92	93.0
2013-03-12 18:00:00	NQ	Futures	3263.47	3263.47	3262.3	3262.88	9.0
2013-03-12 19:00:00	NQ	Futures	3263.18	3263.47	3263.18	3263.18	13.0
2013-03-12 20:00:00	NQ	Futures	3263.47	3267.54	3263.47	3267.54	90.0
2013-03-12 21:00:00	NQ	Futures	3266.96	3268.41	3266.67	3266.67	56.0
2013-03-12 22:00:00	NQ	Futures	3266.38	3266.38	3264.05	3264.05	17.0
2013-03-12 23:00:00	NQ	Futures	3264.05	3264.63	3262.3	3264.05	108.0
2013-03-12 00:00:00	YM	Futures	14529.3	14533.3	14527.3	14528.3	237.0
2013-03-12 01:00:00	YM	Futures	14530.3	14530.3	14523.2	14523.2	247.0

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

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