PREVIEW / futures_30min / 2010-06-27

all futures 30-min files

  file:    by_date/futures_30min/2010/2010-06-27.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-06-27 18:00:00	ES	Futures	1054.4	1057.59	1054.4	1055.13	6696.0
2010-06-27 18:30:00	ES	Futures	1055.13	1056.11	1054.4	1055.62	2139.0
2010-06-27 19:00:00	ES	Futures	1055.38	1056.36	1055.13	1056.36	684.0
2010-06-27 19:30:00	ES	Futures	1056.6	1056.6	1055.38	1055.62	1453.0
2010-06-27 20:00:00	ES	Futures	1055.38	1056.11	1053.66	1054.15	4964.0
2010-06-27 20:30:00	ES	Futures	1054.4	1055.87	1053.41	1054.64	4497.0
2010-06-27 21:00:00	ES	Futures	1054.64	1057.09	1053.41	1056.85	5244.0
2010-06-27 21:30:00	ES	Futures	1056.85	1058.08	1056.36	1056.6	3766.0
2010-06-27 22:00:00	ES	Futures	1056.6	1058.08	1056.36	1057.83	1691.0
2010-06-27 22:30:00	ES	Futures	1057.83	1058.57	1057.09	1057.83	1581.0
2010-06-27 23:00:00	ES	Futures	1057.59	1057.59	1056.6	1056.6	1256.0
2010-06-27 23:30:00	ES	Futures	1056.6	1057.59	1056.36	1056.85	1326.0
2010-06-27 18:00:00	NQ	Futures	2107.98	2113.42	2107.41	2109.13	461.0
2010-06-27 18:30:00	NQ	Futures	2108.84	2109.99	2107.98	2109.41	49.0
2010-06-27 19:00:00	NQ	Futures	2109.7	2111.13	2109.41	2111.13	60.0
2010-06-27 19:30:00	NQ	Futures	2111.71	2111.99	2110.56	2110.56	40.0
2010-06-27 20:00:00	NQ	Futures	2110.27	2111.13	2106.83	2107.98	270.0
2010-06-27 20:30:00	NQ	Futures	2107.69	2110.56	2106.26	2108.55	461.0
2010-06-27 21:00:00	NQ	Futures	2108.55	2112.56	2106.55	2112.28	435.0
2010-06-27 21:30:00	NQ	Futures	2112.28	2114.0	2111.42	2111.71	219.0
2010-06-27 22:00:00	NQ	Futures	2111.99	2114.86	2111.71	2114.57	111.0
2010-06-27 22:30:00	NQ	Futures	2114.57	2116.0	2113.42	2114.86	193.0
2010-06-27 23:00:00	NQ	Futures	2114.28	2114.28	2112.28	2112.28	53.0
2010-06-27 23:30:00	NQ	Futures	2112.28	2113.71	2111.71	2112.56	77.0
2010-06-27 18:00:00	YM	Futures	9564.5	9588.2	9564.5	9570.2	176.0
2010-06-27 18:30:00	YM	Futures	9571.1	9574.9	9565.5	9574.9	51.0
2010-06-27 19:00:00	YM	Futures	9572.1	9579.7	9571.1	9579.7	41.0
2010-06-27 19:30:00	YM	Futures	9578.7	9579.7	9573.0	9573.0	93.0
2010-06-27 20:00:00	YM	Futures	9572.1	9575.9	9557.9	9561.7	421.0
2010-06-27 20:30:00	YM	Futures	9560.7	9573.0	9555.0	9562.6	307.0
2010-06-27 21:00:00	YM	Futures	9562.6	9574.9	9554.1	9574.9	793.0
2010-06-27 21:30:00	YM	Futures	9574.9	9581.6	9571.1	9571.1	247.0
2010-06-27 22:00:00	YM	Futures	9571.1	9584.4	9571.1	9583.4	75.0
2010-06-27 22:30:00	YM	Futures	9585.3	9588.2	9578.7	9582.5	316.0
2010-06-27 23:00:00	YM	Futures	9581.6	9581.6	9573.0	9574.0	104.0
2010-06-27 23:30:00	YM	Futures	9571.1	9578.7	9570.2	9574.0	102.0
2010-06-27 18:00:00	CL	Futures	152.51	152.51	151.7	151.91	1443.0
2010-06-27 18:30:00	CL	Futures	151.89	152.18	151.85	152.03	430.0
2010-06-27 19:00:00	CL	Futures	152.03	152.32	152.01	152.3	264.0
2010-06-27 19:30:00	CL	Futures	152.32	152.41	152.22	152.3	235.0
2010-06-27 20:00:00	CL	Futures	152.28	152.39	152.08	152.34	645.0
2010-06-27 20:30:00	CL	Futures	152.34	153.24	152.3	153.01	1268.0
2010-06-27 21:00:00	CL	Futures	152.99	153.18	152.76	153.09	516.0
2010-06-27 21:30:00	CL	Futures	153.09	153.24	152.86	152.86	354.0
2010-06-27 22:00:00	CL	Futures	152.89	153.07	152.86	152.91	236.0
2010-06-27 22:30:00	CL	Futures	152.88	152.99	152.86	152.89	331.0
2010-06-27 23:00:00	CL	Futures	152.88	152.88	152.03	152.05	810.0
2010-06-27 23:30:00	CL	Futures	152.05	152.18	151.99	152.08	392.0
2010-06-27 18:00:00	GC	Futures	1762.5	1763.6	1760.7	1762.2	377.0
2010-06-27 18:30:00	GC	Futures	1762.8	1763.5	1761.4	1763.1	162.0

> showing 50 of 413 rows — these rows as CSV

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