PREVIEW / futures_30min / 2019-07-07

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-07.parquet
  size:    24 KB
  rows:    663

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
2019-07-07 18:00:00	ES	Futures	3238.44	3242.78	3238.17	3240.34	4796.0
2019-07-07 18:30:00	ES	Futures	3240.34	3240.61	3239.53	3239.8	1190.0
2019-07-07 19:00:00	ES	Futures	3240.07	3240.34	3239.8	3240.34	645.0
2019-07-07 19:30:00	ES	Futures	3240.07	3240.34	3236.01	3236.28	4149.0
2019-07-07 20:00:00	ES	Futures	3236.55	3237.09	3234.65	3235.2	7443.0
2019-07-07 20:30:00	ES	Futures	3235.47	3236.28	3233.57	3235.47	4682.0
2019-07-07 21:00:00	ES	Futures	3235.47	3236.82	3234.65	3235.2	4217.0
2019-07-07 21:30:00	ES	Futures	3235.47	3235.74	3232.49	3233.57	6791.0
2019-07-07 22:00:00	ES	Futures	3233.3	3234.65	3232.49	3232.76	3940.0
2019-07-07 22:30:00	ES	Futures	3232.76	3234.38	3231.14	3232.22	5709.0
2019-07-07 23:00:00	ES	Futures	3231.95	3234.11	3231.68	3233.57	4537.0
2019-07-07 23:30:00	ES	Futures	3233.84	3234.11	3231.14	3231.95	3839.0
2019-07-07 18:00:00	NQ	Futures	9116.28	9126.14	9113.95	9115.4	1841.0
2019-07-07 18:30:00	NQ	Futures	9115.99	9116.86	9112.5	9115.4	622.0
2019-07-07 19:00:00	NQ	Futures	9115.4	9118.6	9114.82	9117.73	425.0
2019-07-07 19:30:00	NQ	Futures	9117.15	9117.15	9101.77	9102.06	1388.0
2019-07-07 20:00:00	NQ	Futures	9102.35	9104.67	9095.68	9100.32	2551.0
2019-07-07 20:30:00	NQ	Futures	9100.03	9102.35	9093.35	9099.74	1547.0
2019-07-07 21:00:00	NQ	Futures	9099.74	9105.83	9095.68	9097.42	1968.0
2019-07-07 21:30:00	NQ	Futures	9097.71	9098.87	9088.42	9090.45	2596.0
2019-07-07 22:00:00	NQ	Futures	9090.74	9094.51	9086.39	9088.71	1594.0
2019-07-07 22:30:00	NQ	Futures	9088.42	9094.8	9083.49	9086.39	2223.0
2019-07-07 23:00:00	NQ	Futures	9086.1	9093.35	9084.94	9091.32	1741.0
2019-07-07 23:30:00	NQ	Futures	9091.32	9092.48	9085.23	9086.39	957.0
2019-07-07 18:00:00	YM	Futures	29242.9	29279.9	29240.7	29253.8	1090.0
2019-07-07 18:30:00	YM	Futures	29253.8	29255.9	29244.0	29247.2	259.0
2019-07-07 19:00:00	YM	Futures	29247.2	29253.8	29246.1	29250.5	133.0
2019-07-07 19:30:00	YM	Futures	29250.5	29250.5	29213.5	29215.7	795.0
2019-07-07 20:00:00	YM	Futures	29215.7	29217.9	29198.3	29203.7	1480.0
2019-07-07 20:30:00	YM	Futures	29207.0	29213.5	29190.7	29205.9	1015.0
2019-07-07 21:00:00	YM	Futures	29207.0	29221.1	29199.4	29203.7	978.0
2019-07-07 21:30:00	YM	Futures	29205.9	29209.2	29180.9	29186.3	1571.0
2019-07-07 22:00:00	YM	Futures	29187.4	29200.5	29179.8	29184.2	846.0
2019-07-07 22:30:00	YM	Futures	29184.2	29202.6	29168.9	29176.5	1446.0
2019-07-07 23:00:00	YM	Futures	29175.5	29195.0	29174.4	29189.6	1676.0
2019-07-07 23:30:00	YM	Futures	29188.5	29191.8	29174.4	29177.6	603.0
2019-07-07 18:00:00	CL	Futures	51.26	51.34	51.12	51.15	2890.0
2019-07-07 18:30:00	CL	Futures	51.14	51.25	51.12	51.23	1259.0
2019-07-07 19:00:00	CL	Futures	51.23	51.27	51.19	51.23	1078.0
2019-07-07 19:30:00	CL	Futures	51.23	51.24	51.14	51.16	971.0
2019-07-07 20:00:00	CL	Futures	51.15	51.19	51.08	51.15	2501.0
2019-07-07 20:30:00	CL	Futures	51.15	51.22	51.15	51.18	1463.0
2019-07-07 21:00:00	CL	Futures	51.17	51.2	51.07	51.15	7070.0
2019-07-07 21:30:00	CL	Futures	51.15	51.19	51.09	51.15	2646.0
2019-07-07 22:00:00	CL	Futures	51.15	51.24	51.14	51.18	2210.0
2019-07-07 22:30:00	CL	Futures	51.18	51.2	51.03	51.08	6650.0
2019-07-07 23:00:00	CL	Futures	51.07	51.13	51.06	51.1	2145.0
2019-07-07 23:30:00	CL	Futures	51.1	51.13	51.08	51.1	1083.0
2019-07-07 18:00:00	GC	Futures	1791.0	1794.9	1783.4	1785.8	4729.0
2019-07-07 18:30:00	GC	Futures	1785.9	1787.5	1784.1	1787.1	2004.0

> showing 50 of 663 rows — these rows as CSV

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