PREVIEW / futures_30min / 2013-04-19

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-04-19.parquet
  size:    65 KB
  rows:    2,360

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-19 00:00:00	ES	Futures	1587.49	1587.75	1586.98	1587.75	937.0
2013-04-19 00:30:00	ES	Futures	1587.49	1588.01	1586.98	1587.23	1175.0
2013-04-19 01:00:00	ES	Futures	1586.98	1588.01	1586.98	1587.75	2398.0
2013-04-19 01:30:00	ES	Futures	1587.75	1589.3	1587.23	1588.52	4076.0
2013-04-19 02:00:00	ES	Futures	1588.27	1590.58	1588.27	1589.55	11084.0
2013-04-19 02:30:00	ES	Futures	1589.55	1589.81	1588.52	1589.55	5871.0
2013-04-19 03:00:00	ES	Futures	1589.3	1589.55	1586.98	1588.52	18772.0
2013-04-19 03:30:00	ES	Futures	1588.52	1590.07	1588.01	1589.81	13599.0
2013-04-19 04:00:00	ES	Futures	1589.81	1590.07	1589.04	1589.55	12855.0
2013-04-19 04:30:00	ES	Futures	1589.55	1591.61	1589.3	1591.36	14335.0
2013-04-19 05:00:00	ES	Futures	1591.1	1591.36	1589.55	1590.33	10473.0
2013-04-19 05:30:00	ES	Futures	1590.58	1592.39	1590.33	1591.1	12468.0
2013-04-19 06:00:00	ES	Futures	1590.84	1592.64	1590.58	1591.36	12676.0
2013-04-19 06:30:00	ES	Futures	1591.61	1592.39	1590.84	1591.36	9725.0
2013-04-19 07:00:00	ES	Futures	1591.36	1591.61	1590.07	1590.07	16579.0
2013-04-19 07:30:00	ES	Futures	1590.33	1591.36	1588.78	1590.33	12658.0
2013-04-19 08:00:00	ES	Futures	1590.33	1591.1	1587.49	1588.78	32450.0
2013-04-19 08:30:00	ES	Futures	1588.52	1589.3	1585.17	1587.23	43760.0
2013-04-19 09:00:00	ES	Futures	1587.23	1588.27	1585.43	1586.98	54073.0
2013-04-19 09:30:00	ES	Futures	1586.72	1589.55	1582.86	1586.46	243162.0
2013-04-19 10:00:00	ES	Futures	1586.46	1591.61	1586.2	1588.27	201872.0
2013-04-19 10:30:00	ES	Futures	1588.52	1591.36	1587.75	1590.58	128464.0
2013-04-19 11:00:00	ES	Futures	1590.84	1595.99	1589.81	1594.19	180150.0
2013-04-19 11:30:00	ES	Futures	1594.19	1597.02	1593.93	1595.22	80608.0
2013-04-19 12:00:00	ES	Futures	1595.22	1596.25	1593.16	1593.67	86647.0
2013-04-19 12:30:00	ES	Futures	1593.42	1594.45	1591.36	1592.39	55611.0
2013-04-19 13:00:00	ES	Futures	1592.39	1594.7	1590.84	1594.7	52284.0
2013-04-19 13:30:00	ES	Futures	1594.45	1594.45	1592.64	1593.16	40518.0
2013-04-19 14:00:00	ES	Futures	1593.42	1595.99	1592.9	1595.22	58436.0
2013-04-19 14:30:00	ES	Futures	1595.22	1596.25	1592.39	1593.42	64104.0
2013-04-19 15:00:00	ES	Futures	1593.42	1596.25	1592.13	1595.73	71858.0
2013-04-19 15:30:00	ES	Futures	1595.73	1597.8	1595.48	1596.25	153929.0
2013-04-19 16:00:00	ES	Futures	1596.51	1597.28	1593.93	1594.19	91856.0
2013-04-19 16:30:00	ES	Futures	1594.45	1595.48	1594.19	1595.22	6124.0
2013-04-19 17:00:00	ES	Futures	1595.48	1595.73	1594.96	1595.48	2267.0
2013-04-19 00:00:00	NQ	Futures	3210.1	3210.97	3210.1	3210.68	107.0
2013-04-19 00:30:00	NQ	Futures	3210.97	3211.56	3210.1	3210.39	109.0
2013-04-19 01:00:00	NQ	Futures	3210.39	3212.43	3210.1	3212.14	214.0
2013-04-19 01:30:00	NQ	Futures	3212.14	3214.47	3211.85	3213.89	225.0
2013-04-19 02:00:00	NQ	Futures	3213.31	3216.81	3213.01	3215.35	887.0
2013-04-19 02:30:00	NQ	Futures	3215.35	3215.64	3213.31	3215.06	441.0
2013-04-19 03:00:00	NQ	Futures	3215.06	3215.06	3209.51	3211.56	3020.0
2013-04-19 03:30:00	NQ	Futures	3212.14	3215.35	3211.26	3215.06	1299.0
2013-04-19 04:00:00	NQ	Futures	3215.35	3215.35	3212.72	3214.76	999.0
2013-04-19 04:30:00	NQ	Futures	3214.76	3217.97	3214.47	3217.39	1076.0
2013-04-19 05:00:00	NQ	Futures	3217.39	3217.39	3210.68	3215.35	2502.0
2013-04-19 05:30:00	NQ	Futures	3215.35	3218.56	3215.06	3215.93	1108.0
2013-04-19 06:00:00	NQ	Futures	3216.22	3217.97	3215.35	3216.51	1448.0
2013-04-19 06:30:00	NQ	Futures	3216.51	3218.56	3215.35	3217.1	1164.0
2013-04-19 07:00:00	NQ	Futures	3217.1	3217.97	3215.35	3216.22	2200.0

> showing 50 of 2,360 rows — these rows as CSV

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