PREVIEW / futures_1hour / 2013-03-25

all futures 1-hour files

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

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-25 00:00:00	ES	Futures	1605.52	1606.81	1605.01	1605.78	3227.0
2013-03-25 01:00:00	ES	Futures	1605.52	1606.3	1605.01	1605.78	2654.0
2013-03-25 02:00:00	ES	Futures	1605.52	1606.3	1605.01	1606.04	4401.0
2013-03-25 03:00:00	ES	Futures	1606.04	1606.3	1603.46	1603.98	14006.0
2013-03-25 04:00:00	ES	Futures	1603.98	1605.01	1603.46	1605.01	26928.0
2013-03-25 05:00:00	ES	Futures	1605.01	1607.58	1604.49	1607.58	23677.0
2013-03-25 06:00:00	ES	Futures	1607.33	1607.84	1605.52	1605.52	19793.0
2013-03-25 07:00:00	ES	Futures	1605.52	1606.3	1604.49	1605.78	18331.0
2013-03-25 08:00:00	ES	Futures	1605.78	1606.04	1602.17	1602.69	48727.0
2013-03-25 09:00:00	ES	Futures	1602.69	1605.52	1601.14	1605.52	206001.0
2013-03-25 10:00:00	ES	Futures	1605.52	1605.78	1595.48	1595.73	310216.0
2013-03-25 11:00:00	ES	Futures	1595.99	1597.02	1590.58	1594.45	427781.0
2013-03-25 12:00:00	ES	Futures	1594.45	1595.48	1588.27	1588.78	195983.0
2013-03-25 13:00:00	ES	Futures	1589.04	1596.51	1585.69	1594.7	324455.0
2013-03-25 14:00:00	ES	Futures	1594.7	1596.25	1591.36	1592.9	184303.0
2013-03-25 15:00:00	ES	Futures	1593.16	1594.45	1588.01	1592.64	277288.0
2013-03-25 16:00:00	ES	Futures	1592.64	1595.48	1592.39	1595.48	88771.0
2013-03-25 17:00:00	ES	Futures	1595.22	1595.99	1594.45	1595.48	3730.0
2013-03-25 18:00:00	ES	Futures	1595.22	1595.73	1593.67	1595.73	7876.0
2013-03-25 19:00:00	ES	Futures	1595.73	1595.73	1594.96	1595.48	3247.0
2013-03-25 20:00:00	ES	Futures	1595.22	1596.25	1594.96	1595.48	4679.0
2013-03-25 21:00:00	ES	Futures	1595.22	1598.31	1595.22	1596.77	9282.0
2013-03-25 22:00:00	ES	Futures	1596.77	1596.77	1595.22	1595.48	2197.0
2013-03-25 23:00:00	ES	Futures	1595.48	1596.51	1595.48	1596.51	1359.0
2013-03-25 00:00:00	NQ	Futures	3276.01	3276.89	3274.56	3276.01	290.0
2013-03-25 01:00:00	NQ	Futures	3275.72	3276.6	3274.56	3275.43	156.0
2013-03-25 02:00:00	NQ	Futures	3275.14	3276.89	3274.56	3276.31	293.0
2013-03-25 03:00:00	NQ	Futures	3276.6	3277.76	3271.35	3271.64	1282.0
2013-03-25 04:00:00	NQ	Futures	3272.22	3273.39	3270.76	3272.81	2715.0
2013-03-25 05:00:00	NQ	Futures	3273.1	3278.35	3272.51	3278.35	2251.0
2013-03-25 06:00:00	NQ	Futures	3278.35	3280.1	3275.43	3275.72	1822.0
2013-03-25 07:00:00	NQ	Futures	3275.43	3277.18	3274.26	3275.72	1916.0
2013-03-25 08:00:00	NQ	Futures	3275.72	3276.6	3270.76	3271.35	3968.0
2013-03-25 09:00:00	NQ	Futures	3271.35	3274.56	3266.97	3273.97	25813.0
2013-03-25 10:00:00	NQ	Futures	3273.97	3278.93	3252.68	3253.26	39656.0
2013-03-25 11:00:00	NQ	Futures	3253.26	3254.14	3239.26	3248.01	43226.0
2013-03-25 12:00:00	NQ	Futures	3248.01	3250.93	3238.1	3238.97	21747.0
2013-03-25 13:00:00	NQ	Futures	3238.97	3258.51	3232.85	3254.72	37693.0
2013-03-25 14:00:00	NQ	Futures	3255.01	3257.93	3245.97	3249.47	23351.0
2013-03-25 15:00:00	NQ	Futures	3249.76	3250.35	3237.81	3247.43	30680.0
2013-03-25 16:00:00	NQ	Futures	3247.43	3251.81	3246.85	3251.81	6270.0
2013-03-25 17:00:00	NQ	Futures	3251.51	3252.39	3249.76	3252.39	123.0
2013-03-25 18:00:00	NQ	Futures	3252.97	3253.26	3248.6	3250.93	621.0
2013-03-25 19:00:00	NQ	Futures	3251.22	3251.81	3249.76	3251.81	217.0
2013-03-25 20:00:00	NQ	Futures	3251.22	3252.39	3250.64	3251.22	241.0
2013-03-25 21:00:00	NQ	Futures	3251.22	3255.31	3251.22	3253.56	815.0
2013-03-25 22:00:00	NQ	Futures	3253.26	3253.26	3251.22	3252.1	162.0
2013-03-25 23:00:00	NQ	Futures	3251.81	3253.56	3251.51	3253.56	96.0
2013-03-25 00:00:00	YM	Futures	14661.7	14666.8	14656.7	14660.7	409.0
2013-03-25 01:00:00	YM	Futures	14659.7	14663.8	14655.7	14657.7	409.0

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

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