PREVIEW / futures_30min / 2010-07-18

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-07-18.parquet
  size:    17 KB
  rows:    413

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
2010-07-18 18:00:00	ES	Futures	1042.13	1042.86	1040.41	1041.39	6699.0
2010-07-18 18:30:00	ES	Futures	1041.39	1042.62	1041.15	1041.88	1047.0
2010-07-18 19:00:00	ES	Futures	1041.88	1043.35	1041.88	1042.37	968.0
2010-07-18 19:30:00	ES	Futures	1042.37	1042.62	1041.88	1041.88	2073.0
2010-07-18 20:00:00	ES	Futures	1042.13	1043.35	1041.15	1041.64	2608.0
2010-07-18 20:30:00	ES	Futures	1041.64	1041.88	1040.9	1041.15	3258.0
2010-07-18 21:00:00	ES	Futures	1040.9	1043.35	1040.9	1042.62	2214.0
2010-07-18 21:30:00	ES	Futures	1042.86	1043.84	1041.39	1043.6	2459.0
2010-07-18 22:00:00	ES	Futures	1043.35	1045.32	1043.35	1044.83	3751.0
2010-07-18 22:30:00	ES	Futures	1045.07	1045.81	1044.83	1045.07	2039.0
2010-07-18 23:00:00	ES	Futures	1045.32	1045.32	1044.58	1044.83	1045.0
2010-07-18 23:30:00	ES	Futures	1045.07	1045.07	1044.09	1044.34	922.0
2010-07-18 18:00:00	NQ	Futures	2063.85	2064.71	2043.22	2059.55	1809.0
2010-07-18 18:30:00	NQ	Futures	2060.12	2062.99	2060.12	2061.84	206.0
2010-07-18 19:00:00	NQ	Futures	2061.84	2064.99	2061.84	2062.99	194.0
2010-07-18 19:30:00	NQ	Futures	2062.7	2062.7	2061.84	2062.13	105.0
2010-07-18 20:00:00	NQ	Futures	2062.7	2064.42	2061.56	2062.42	320.0
2010-07-18 20:30:00	NQ	Futures	2062.42	2062.7	2060.41	2060.98	365.0
2010-07-18 21:00:00	NQ	Futures	2061.27	2065.57	2060.98	2063.85	265.0
2010-07-18 21:30:00	NQ	Futures	2063.85	2065.28	2060.98	2065.28	196.0
2010-07-18 22:00:00	NQ	Futures	2065.28	2068.43	2065.28	2068.15	340.0
2010-07-18 22:30:00	NQ	Futures	2068.43	2070.15	2067.57	2068.72	136.0
2010-07-18 23:00:00	NQ	Futures	2068.72	2068.72	2067.57	2068.15	81.0
2010-07-18 23:30:00	NQ	Futures	2068.72	2068.72	2067.29	2067.29	55.0
2010-07-18 18:00:00	YM	Futures	9509.6	9520.0	9492.6	9500.1	371.0
2010-07-18 18:30:00	YM	Futures	9501.1	9511.5	9501.1	9507.7	103.0
2010-07-18 19:00:00	YM	Futures	9507.7	9519.1	9507.7	9511.5	62.0
2010-07-18 19:30:00	YM	Futures	9511.5	9511.5	9507.7	9509.6	82.0
2010-07-18 20:00:00	YM	Futures	9508.7	9518.1	9504.9	9507.7	310.0
2010-07-18 20:30:00	YM	Futures	9506.8	9509.6	9500.1	9503.9	277.0
2010-07-18 21:00:00	YM	Futures	9503.0	9520.0	9502.0	9515.3	206.0
2010-07-18 21:30:00	YM	Futures	9514.3	9521.0	9504.9	9521.0	245.0
2010-07-18 22:00:00	YM	Futures	9520.0	9535.2	9519.1	9533.3	293.0
2010-07-18 22:30:00	YM	Futures	9533.3	9540.8	9532.3	9535.2	194.0
2010-07-18 23:00:00	YM	Futures	9535.2	9535.2	9531.4	9534.2	96.0
2010-07-18 23:30:00	YM	Futures	9534.2	9534.2	9528.5	9529.5	59.0
2010-07-18 18:00:00	CL	Futures	146.0	146.25	145.58	146.02	467.0
2010-07-18 18:30:00	CL	Futures	146.0	146.25	145.96	146.0	93.0
2010-07-18 19:00:00	CL	Futures	146.02	146.17	145.88	146.04	90.0
2010-07-18 19:30:00	CL	Futures	145.96	145.96	145.69	145.79	73.0
2010-07-18 20:00:00	CL	Futures	145.73	146.13	145.71	145.96	151.0
2010-07-18 20:30:00	CL	Futures	146.0	146.0	145.81	145.98	112.0
2010-07-18 21:00:00	CL	Futures	145.98	146.27	145.98	146.15	101.0
2010-07-18 21:30:00	CL	Futures	146.13	146.21	145.73	145.86	335.0
2010-07-18 22:00:00	CL	Futures	145.9	146.27	145.9	146.23	242.0
2010-07-18 22:30:00	CL	Futures	146.19	146.34	146.13	146.27	101.0
2010-07-18 23:00:00	CL	Futures	146.29	146.38	146.23	146.34	64.0
2010-07-18 23:30:00	CL	Futures	146.32	146.32	146.11	146.17	103.0
2010-07-18 18:00:00	GC	Futures	1675.4	1675.5	1671.1	1673.7	708.0
2010-07-18 18:30:00	GC	Futures	1673.5	1675.4	1673.1	1674.9	155.0

> showing 50 of 413 rows — these rows as CSV

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