PREVIEW / futures_30min / 2017-04-30

all futures 30-min files

  file:    by_date/futures_30min/2017/2017-04-30.parquet
  size:    21 KB
  rows:    536

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
2017-04-30 18:00:00	ES	Futures	2601.96	2601.96	2597.04	2598.41	6907.0
2017-04-30 18:30:00	ES	Futures	2598.41	2598.96	2598.14	2598.41	1159.0
2017-04-30 19:00:00	ES	Futures	2598.68	2598.96	2598.14	2598.41	472.0
2017-04-30 19:30:00	ES	Futures	2598.41	2598.96	2598.14	2598.96	1662.0
2017-04-30 20:00:00	ES	Futures	2598.96	2600.32	2598.68	2599.77	2359.0
2017-04-30 20:30:00	ES	Futures	2600.05	2600.32	2599.5	2599.5	1260.0
2017-04-30 21:00:00	ES	Futures	2599.77	2599.77	2598.68	2599.5	1146.0
2017-04-30 21:30:00	ES	Futures	2599.5	2603.6	2599.23	2602.23	6894.0
2017-04-30 22:00:00	ES	Futures	2602.23	2603.05	2601.69	2603.05	1748.0
2017-04-30 22:30:00	ES	Futures	2602.78	2603.05	2601.96	2601.96	1139.0
2017-04-30 23:00:00	ES	Futures	2601.96	2602.23	2601.69	2601.96	848.0
2017-04-30 23:30:00	ES	Futures	2601.96	2602.78	2601.96	2602.23	712.0
2017-04-30 18:00:00	NQ	Futures	6655.68	6658.66	6646.74	6649.42	1169.0
2017-04-30 18:30:00	NQ	Futures	6649.42	6652.4	6649.42	6651.21	313.0
2017-04-30 19:00:00	NQ	Futures	6651.51	6652.4	6650.61	6652.1	128.0
2017-04-30 19:30:00	NQ	Futures	6651.51	6653.0	6650.61	6653.0	255.0
2017-04-30 20:00:00	NQ	Futures	6653.0	6657.77	6652.4	6656.28	667.0
2017-04-30 20:30:00	NQ	Futures	6656.28	6657.47	6654.79	6655.98	201.0
2017-04-30 21:00:00	NQ	Futures	6655.98	6657.47	6653.89	6655.98	359.0
2017-04-30 21:30:00	NQ	Futures	6655.98	6665.82	6655.38	6663.14	1440.0
2017-04-30 22:00:00	NQ	Futures	6662.84	6664.63	6661.94	6664.33	314.0
2017-04-30 22:30:00	NQ	Futures	6664.33	6664.63	6662.54	6662.54	206.0
2017-04-30 23:00:00	NQ	Futures	6662.54	6663.14	6661.94	6662.54	213.0
2017-04-30 23:30:00	NQ	Futures	6662.54	6664.03	6662.54	6662.84	155.0
2017-04-30 18:00:00	YM	Futures	22707.4	22707.4	22666.1	22673.7	925.0
2017-04-30 18:30:00	YM	Futures	22673.7	22679.2	22672.6	22675.9	366.0
2017-04-30 19:00:00	YM	Futures	22674.8	22679.2	22672.6	22675.9	111.0
2017-04-30 19:30:00	YM	Futures	22674.8	22674.8	22668.3	22674.8	324.0
2017-04-30 20:00:00	YM	Futures	22674.8	22690.0	22673.7	22687.9	494.0
2017-04-30 20:30:00	YM	Futures	22686.8	22688.9	22682.4	22685.7	165.0
2017-04-30 21:00:00	YM	Futures	22684.6	22686.8	22678.1	22683.5	152.0
2017-04-30 21:30:00	YM	Futures	22682.4	22715.0	22681.3	22703.1	1019.0
2017-04-30 22:00:00	YM	Futures	22704.2	22707.4	22699.8	22706.3	279.0
2017-04-30 22:30:00	YM	Futures	22706.3	22707.4	22700.9	22700.9	139.0
2017-04-30 23:00:00	YM	Futures	22700.9	22703.1	22699.8	22702.0	125.0
2017-04-30 23:30:00	YM	Futures	22702.0	22707.4	22702.0	22705.2	86.0
2017-04-30 18:00:00	CL	Futures	45.33	45.41	45.3	45.33	1806.0
2017-04-30 18:30:00	CL	Futures	45.33	45.34	45.31	45.32	444.0
2017-04-30 19:00:00	CL	Futures	45.32	45.34	45.31	45.34	269.0
2017-04-30 19:30:00	CL	Futures	45.34	45.41	45.34	45.41	678.0
2017-04-30 20:00:00	CL	Futures	45.4	45.41	45.36	45.38	653.0
2017-04-30 20:30:00	CL	Futures	45.38	45.39	45.34	45.35	405.0
2017-04-30 21:00:00	CL	Futures	45.34	45.36	45.33	45.34	515.0
2017-04-30 21:30:00	CL	Futures	45.34	45.41	45.33	45.38	1111.0
2017-04-30 22:00:00	CL	Futures	45.38	45.41	45.38	45.4	391.0
2017-04-30 22:30:00	CL	Futures	45.39	45.47	45.39	45.41	1797.0
2017-04-30 23:00:00	CL	Futures	45.41	45.41	45.37	45.39	1122.0
2017-04-30 23:30:00	CL	Futures	45.39	45.39	45.38	45.39	235.0
2017-04-30 18:00:00	GC	Futures	1704.4	1707.5	1703.8	1707.3	3096.0
2017-04-30 18:30:00	GC	Futures	1707.4	1708.2	1706.9	1707.7	1042.0

> showing 50 of 536 rows — these rows as CSV

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