PREVIEW / futures_30min / 2013-06-23

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-06-23.parquet
  size:    20 KB
  rows:    501

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-06-23 18:00:00	ES	Futures	1637.56	1637.82	1631.88	1632.14	8261.0
2013-06-23 18:30:00	ES	Futures	1632.14	1634.46	1632.14	1634.2	2644.0
2013-06-23 19:00:00	ES	Futures	1634.2	1635.76	1633.69	1635.76	2175.0
2013-06-23 19:30:00	ES	Futures	1636.01	1640.15	1635.76	1638.34	6665.0
2013-06-23 20:00:00	ES	Futures	1638.6	1638.86	1635.5	1636.27	3735.0
2013-06-23 20:30:00	ES	Futures	1636.27	1636.53	1634.2	1634.2	3346.0
2013-06-23 21:00:00	ES	Futures	1634.2	1634.46	1630.07	1632.14	8203.0
2013-06-23 21:30:00	ES	Futures	1632.39	1634.46	1630.07	1632.65	5113.0
2013-06-23 22:00:00	ES	Futures	1632.65	1633.95	1629.81	1632.65	6471.0
2013-06-23 22:30:00	ES	Futures	1632.91	1632.91	1630.33	1631.1	3076.0
2013-06-23 23:00:00	ES	Futures	1631.1	1631.1	1626.97	1629.29	6191.0
2013-06-23 23:30:00	ES	Futures	1629.55	1631.36	1629.03	1630.84	2163.0
2013-06-23 18:00:00	NQ	Futures	3350.78	3350.78	3339.09	3339.38	499.0
2013-06-23 18:30:00	NQ	Futures	3339.67	3345.22	3339.67	3344.05	140.0
2013-06-23 19:00:00	NQ	Futures	3344.64	3347.27	3343.47	3347.27	174.0
2013-06-23 19:30:00	NQ	Futures	3347.56	3355.74	3347.56	3353.11	436.0
2013-06-23 20:00:00	NQ	Futures	3352.82	3353.7	3345.81	3347.85	421.0
2013-06-23 20:30:00	NQ	Futures	3348.15	3349.61	3342.89	3343.18	354.0
2013-06-23 21:00:00	NQ	Futures	3343.18	3343.47	3337.63	3341.13	983.0
2013-06-23 21:30:00	NQ	Futures	3341.13	3344.93	3336.46	3340.84	817.0
2013-06-23 22:00:00	NQ	Futures	3340.84	3343.47	3335.58	3341.42	1184.0
2013-06-23 22:30:00	NQ	Futures	3341.72	3341.72	3336.75	3338.21	474.0
2013-06-23 23:00:00	NQ	Futures	3338.21	3338.21	3331.49	3335.58	721.0
2013-06-23 23:30:00	NQ	Futures	3335.87	3339.67	3334.41	3338.5	444.0
2013-06-23 18:00:00	YM	Futures	14945.8	14945.8	14894.0	14900.0	704.0
2013-06-23 18:30:00	YM	Futures	14901.1	14917.3	14900.0	14916.3	276.0
2013-06-23 19:00:00	YM	Futures	14917.3	14927.5	14913.2	14926.5	244.0
2013-06-23 19:30:00	YM	Futures	14928.5	14962.0	14928.5	14949.8	721.0
2013-06-23 20:00:00	YM	Futures	14950.8	14951.8	14926.5	14932.5	688.0
2013-06-23 20:30:00	YM	Futures	14933.6	14933.6	14912.2	14912.2	471.0
2013-06-23 21:00:00	YM	Futures	14913.2	14915.3	14880.7	14897.0	1220.0
2013-06-23 21:30:00	YM	Futures	14896.0	14915.3	14881.8	14901.1	1099.0
2013-06-23 22:00:00	YM	Futures	14900.0	14910.2	14877.7	14903.1	1556.0
2013-06-23 22:30:00	YM	Futures	14905.1	14905.1	14882.8	14887.9	682.0
2013-06-23 23:00:00	YM	Futures	14887.9	14887.9	14860.4	14875.7	933.0
2013-06-23 23:30:00	YM	Futures	14876.7	14891.9	14872.6	14888.9	506.0
2013-06-23 18:00:00	CL	Futures	146.72	146.86	146.08	146.59	1367.0
2013-06-23 18:30:00	CL	Futures	146.55	146.62	146.47	146.62	380.0
2013-06-23 19:00:00	CL	Futures	146.58	146.61	146.5	146.56	202.0
2013-06-23 19:30:00	CL	Futures	146.58	146.73	146.56	146.73	335.0
2013-06-23 20:00:00	CL	Futures	146.69	146.69	146.42	146.55	356.0
2013-06-23 20:30:00	CL	Futures	146.56	146.59	146.39	146.48	308.0
2013-06-23 21:00:00	CL	Futures	146.48	146.48	146.08	146.25	831.0
2013-06-23 21:30:00	CL	Futures	146.23	146.39	146.01	146.19	631.0
2013-06-23 22:00:00	CL	Futures	146.17	146.45	146.09	146.37	551.0
2013-06-23 22:30:00	CL	Futures	146.37	146.4	146.19	146.26	388.0
2013-06-23 23:00:00	CL	Futures	146.25	146.26	146.09	146.26	358.0
2013-06-23 23:30:00	CL	Futures	146.26	146.45	146.17	146.33	245.0
2013-06-23 18:00:00	GC	Futures	1777.9	1781.1	1777.4	1780.3	856.0
2013-06-23 18:30:00	GC	Futures	1779.8	1782.0	1779.6	1781.8	393.0

> showing 50 of 501 rows — these rows as CSV

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