PREVIEW / futures_30min / 2013-07-05

all futures 30-min files

  file:    by_date/futures_30min/2013/2013-07-05.parquet
  size:    65 KB
  rows:    2,144

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-07-05 00:00:00	ES	Futures	1679.44	1679.7	1678.92	1679.44	1124.0
2013-07-05 00:30:00	ES	Futures	1679.44	1679.96	1678.92	1679.18	1311.0
2013-07-05 01:00:00	ES	Futures	1679.18	1680.22	1679.18	1679.96	1456.0
2013-07-05 01:30:00	ES	Futures	1679.96	1680.22	1679.44	1680.22	866.0
2013-07-05 02:00:00	ES	Futures	1679.96	1680.99	1679.7	1679.96	3414.0
2013-07-05 02:30:00	ES	Futures	1679.7	1680.47	1679.44	1679.96	2412.0
2013-07-05 03:00:00	ES	Futures	1679.7	1682.03	1678.41	1681.77	18512.0
2013-07-05 03:30:00	ES	Futures	1681.77	1682.03	1679.96	1681.25	7949.0
2013-07-05 04:00:00	ES	Futures	1680.99	1681.25	1678.67	1679.18	7251.0
2013-07-05 04:30:00	ES	Futures	1678.92	1679.96	1677.63	1678.92	6862.0
2013-07-05 05:00:00	ES	Futures	1678.92	1679.7	1677.89	1678.41	5736.0
2013-07-05 05:30:00	ES	Futures	1678.67	1679.44	1678.15	1678.67	6588.0
2013-07-05 06:00:00	ES	Futures	1678.41	1679.96	1677.89	1678.92	5628.0
2013-07-05 06:30:00	ES	Futures	1679.18	1679.44	1677.63	1678.15	6543.0
2013-07-05 07:00:00	ES	Futures	1678.15	1678.41	1675.82	1676.6	14837.0
2013-07-05 07:30:00	ES	Futures	1676.6	1677.37	1675.3	1676.6	10918.0
2013-07-05 08:00:00	ES	Futures	1676.6	1683.84	1675.82	1680.73	32505.0
2013-07-05 08:30:00	ES	Futures	1680.22	1686.16	1676.08	1678.41	149092.0
2013-07-05 09:00:00	ES	Futures	1678.67	1678.67	1670.91	1675.05	114198.0
2013-07-05 09:30:00	ES	Futures	1674.79	1676.86	1671.17	1671.43	175274.0
2013-07-05 10:00:00	ES	Futures	1671.43	1672.2	1662.9	1665.74	184120.0
2013-07-05 10:30:00	ES	Futures	1665.74	1669.36	1663.93	1669.1	101933.0
2013-07-05 11:00:00	ES	Futures	1669.1	1670.39	1667.55	1668.07	59548.0
2013-07-05 11:30:00	ES	Futures	1667.81	1673.75	1665.48	1673.24	69582.0
2013-07-05 12:00:00	ES	Futures	1673.24	1675.82	1673.24	1674.01	65827.0
2013-07-05 12:30:00	ES	Futures	1674.27	1675.82	1672.98	1674.27	38809.0
2013-07-05 13:00:00	ES	Futures	1674.53	1676.08	1671.94	1674.01	48333.0
2013-07-05 13:30:00	ES	Futures	1673.75	1675.05	1673.24	1674.27	25163.0
2013-07-05 14:00:00	ES	Futures	1674.01	1678.67	1674.01	1678.41	60528.0
2013-07-05 14:30:00	ES	Futures	1678.67	1679.7	1676.08	1677.63	55189.0
2013-07-05 15:00:00	ES	Futures	1677.37	1677.63	1672.46	1674.27	52581.0
2013-07-05 15:30:00	ES	Futures	1674.01	1681.51	1673.75	1680.47	100414.0
2013-07-05 16:00:00	ES	Futures	1680.47	1683.84	1679.96	1683.58	77289.0
2013-07-05 16:30:00	ES	Futures	1683.58	1684.61	1683.58	1684.61	7227.0
2013-07-05 17:00:00	ES	Futures	1684.61	1684.87	1684.09	1684.61	2629.0
2013-07-05 00:00:00	NQ	Futures	3467.38	3467.67	3466.79	3467.67	51.0
2013-07-05 00:30:00	NQ	Futures	3467.38	3468.55	3466.79	3466.79	142.0
2013-07-05 01:00:00	NQ	Futures	3467.09	3468.84	3466.5	3468.55	107.0
2013-07-05 01:30:00	NQ	Futures	3468.55	3469.13	3467.96	3468.55	78.0
2013-07-05 02:00:00	NQ	Futures	3468.55	3470.59	3467.96	3468.55	361.0
2013-07-05 02:30:00	NQ	Futures	3468.84	3469.72	3467.09	3467.09	284.0
2013-07-05 03:00:00	NQ	Futures	3467.09	3471.47	3464.46	3470.01	2581.0
2013-07-05 03:30:00	NQ	Futures	3470.3	3471.18	3467.09	3470.59	1176.0
2013-07-05 04:00:00	NQ	Futures	3470.3	3470.59	3465.33	3466.21	990.0
2013-07-05 04:30:00	NQ	Futures	3465.92	3467.67	3464.16	3466.21	1329.0
2013-07-05 05:00:00	NQ	Futures	3466.5	3467.09	3462.99	3464.16	1008.0
2013-07-05 05:30:00	NQ	Futures	3464.46	3466.21	3463.58	3465.04	927.0
2013-07-05 06:00:00	NQ	Futures	3465.04	3468.26	3464.16	3466.5	900.0
2013-07-05 06:30:00	NQ	Futures	3466.79	3467.09	3463.87	3464.16	804.0
2013-07-05 07:00:00	NQ	Futures	3463.87	3465.04	3461.24	3462.41	1280.0

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

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