PREVIEW / futures_30min / 2014-06-29

all futures 30-min files

  file:    by_date/futures_30min/2014/2014-06-29.parquet
  size:    17 KB
  rows:    478

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
2014-06-29 18:00:00	ES	Futures	2034.61	2036.7	2033.83	2035.66	2968.0
2014-06-29 18:30:00	ES	Futures	2035.66	2036.18	2035.4	2035.4	662.0
2014-06-29 19:00:00	ES	Futures	2035.66	2035.66	2035.13	2035.4	209.0
2014-06-29 19:30:00	ES	Futures	2035.4	2036.18	2035.13	2036.18	873.0
2014-06-29 20:00:00	ES	Futures	2036.44	2036.44	2034.87	2035.13	1735.0
2014-06-29 20:30:00	ES	Futures	2035.13	2035.66	2034.09	2034.35	2729.0
2014-06-29 21:00:00	ES	Futures	2034.61	2034.87	2033.83	2034.35	2511.0
2014-06-29 21:30:00	ES	Futures	2034.09	2034.87	2033.57	2034.09	3416.0
2014-06-29 22:00:00	ES	Futures	2034.09	2035.66	2034.09	2034.87	1462.0
2014-06-29 22:30:00	ES	Futures	2034.87	2035.13	2034.87	2034.87	433.0
2014-06-29 23:00:00	ES	Futures	2035.13	2035.4	2034.61	2034.87	646.0
2014-06-29 23:30:00	ES	Futures	2035.13	2035.92	2035.13	2035.92	1437.0
2014-06-29 18:00:00	NQ	Futures	4475.42	4480.67	4474.83	4478.34	543.0
2014-06-29 18:30:00	NQ	Futures	4478.34	4479.21	4478.34	4478.34	115.0
2014-06-29 19:00:00	NQ	Futures	4478.05	4478.92	4477.75	4478.34	107.0
2014-06-29 19:30:00	NQ	Futures	4478.34	4479.21	4477.75	4478.92	173.0
2014-06-29 20:00:00	NQ	Futures	4479.21	4479.51	4476.59	4477.17	169.0
2014-06-29 20:30:00	NQ	Futures	4477.17	4477.75	4475.42	4477.17	284.0
2014-06-29 21:00:00	NQ	Futures	4476.59	4477.46	4475.71	4476.59	220.0
2014-06-29 21:30:00	NQ	Futures	4476.59	4476.88	4474.83	4476.29	263.0
2014-06-29 22:00:00	NQ	Futures	4476.0	4479.21	4476.0	4477.75	245.0
2014-06-29 22:30:00	NQ	Futures	4478.05	4478.05	4477.46	4477.75	52.0
2014-06-29 23:00:00	NQ	Futures	4477.75	4478.05	4477.17	4477.75	116.0
2014-06-29 23:30:00	NQ	Futures	4477.75	4479.51	4477.75	4479.21	127.0
2014-06-29 18:00:00	YM	Futures	17331.1	17348.7	17326.9	17341.4	329.0
2014-06-29 18:30:00	YM	Futures	17340.4	17346.6	17338.3	17344.5	67.0
2014-06-29 19:00:00	YM	Futures	17341.4	17343.5	17339.4	17339.4	48.0
2014-06-29 19:30:00	YM	Futures	17340.4	17345.6	17339.4	17345.6	40.0
2014-06-29 20:00:00	YM	Futures	17346.6	17347.6	17335.2	17336.3	120.0
2014-06-29 20:30:00	YM	Futures	17339.4	17342.5	17332.1	17336.3	220.0
2014-06-29 21:00:00	YM	Futures	17336.3	17337.3	17332.1	17333.1	220.0
2014-06-29 21:30:00	YM	Futures	17333.1	17338.3	17328.0	17333.1	321.0
2014-06-29 22:00:00	YM	Futures	17332.1	17342.5	17332.1	17339.4	175.0
2014-06-29 22:30:00	YM	Futures	17339.4	17341.4	17338.3	17339.4	35.0
2014-06-29 23:00:00	YM	Futures	17339.4	17341.4	17338.3	17341.4	93.0
2014-06-29 23:30:00	YM	Futures	17341.4	17345.6	17340.4	17344.5	171.0
2014-06-29 18:00:00	CL	Futures	171.91	172.02	171.65	171.68	634.0
2014-06-29 18:30:00	CL	Futures	171.68	171.7	171.44	171.57	576.0
2014-06-29 19:00:00	CL	Futures	171.57	171.6	171.46	171.59	256.0
2014-06-29 19:30:00	CL	Futures	171.6	171.6	171.54	171.6	146.0
2014-06-29 20:00:00	CL	Futures	171.6	171.6	171.49	171.54	273.0
2014-06-29 20:30:00	CL	Futures	171.55	171.57	171.47	171.52	224.0
2014-06-29 21:00:00	CL	Futures	171.5	171.54	171.47	171.49	129.0
2014-06-29 21:30:00	CL	Futures	171.5	171.63	171.49	171.57	276.0
2014-06-29 22:00:00	CL	Futures	171.57	171.62	171.49	171.54	255.0
2014-06-29 22:30:00	CL	Futures	171.52	171.59	171.52	171.54	168.0
2014-06-29 23:00:00	CL	Futures	171.54	171.55	171.46	171.5	140.0
2014-06-29 23:30:00	CL	Futures	171.5	171.59	171.49	171.59	144.0
2014-06-29 18:00:00	GC	Futures	1803.6	1804.7	1802.0	1802.6	591.0
2014-06-29 18:30:00	GC	Futures	1802.6	1803.6	1802.2	1802.9	216.0

> showing 50 of 478 rows — these rows as CSV

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