PREVIEW / futures_30min / 2019-06-30

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-06-30.parquet
  size:    26 KB
  rows:    700

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-06-30 18:00:00	ES	Futures	3215.98	3224.1	3214.35	3220.31	29875.0
2019-06-30 18:30:00	ES	Futures	3220.04	3220.58	3216.25	3217.6	8794.0
2019-06-30 19:00:00	ES	Futures	3217.87	3218.68	3216.25	3216.52	3686.0
2019-06-30 19:30:00	ES	Futures	3216.52	3217.6	3215.71	3217.6	5324.0
2019-06-30 20:00:00	ES	Futures	3217.33	3217.6	3212.73	3213.0	12030.0
2019-06-30 20:30:00	ES	Futures	3213.27	3213.54	3208.4	3209.75	7905.0
2019-06-30 21:00:00	ES	Futures	3209.48	3214.08	3209.48	3213.27	8090.0
2019-06-30 21:30:00	ES	Futures	3213.0	3213.81	3209.75	3213.81	6904.0
2019-06-30 22:00:00	ES	Futures	3213.81	3215.98	3213.54	3214.89	5167.0
2019-06-30 22:30:00	ES	Futures	3214.89	3215.16	3214.08	3215.16	3105.0
2019-06-30 23:00:00	ES	Futures	3215.16	3215.16	3213.81	3213.81	2050.0
2019-06-30 23:30:00	ES	Futures	3214.08	3215.71	3213.81	3215.43	2502.0
2019-06-30 18:00:00	NQ	Futures	9030.97	9080.88	9030.97	9064.92	10379.0
2019-06-30 18:30:00	NQ	Futures	9065.21	9066.95	9048.96	9054.18	3580.0
2019-06-30 19:00:00	NQ	Futures	9054.18	9059.7	9049.54	9051.57	1308.0
2019-06-30 19:30:00	NQ	Futures	9051.57	9057.09	9048.38	9055.35	1422.0
2019-06-30 20:00:00	NQ	Futures	9055.35	9056.22	9039.1	9039.97	3376.0
2019-06-30 20:30:00	NQ	Futures	9039.68	9042.29	9020.82	9026.91	4005.0
2019-06-30 21:00:00	NQ	Futures	9026.91	9042.0	9026.91	9036.2	4311.0
2019-06-30 21:30:00	NQ	Futures	9036.2	9036.78	9025.75	9036.2	4148.0
2019-06-30 22:00:00	NQ	Futures	9035.91	9042.58	9035.62	9038.81	2285.0
2019-06-30 22:30:00	NQ	Futures	9038.52	9041.13	9036.2	9041.13	1166.0
2019-06-30 23:00:00	NQ	Futures	9040.84	9041.71	9035.91	9037.94	1080.0
2019-06-30 23:30:00	NQ	Futures	9038.23	9046.06	9037.94	9045.19	898.0
2019-06-30 18:00:00	YM	Futures	29162.4	29212.4	29135.2	29185.2	4598.0
2019-06-30 18:30:00	YM	Futures	29185.2	29188.5	29155.9	29166.8	1381.0
2019-06-30 19:00:00	YM	Futures	29166.8	29173.3	29158.1	29160.2	537.0
2019-06-30 19:30:00	YM	Futures	29160.2	29165.7	29145.0	29158.1	1307.0
2019-06-30 20:00:00	YM	Futures	29158.1	29158.1	29127.6	29129.8	2132.0
2019-06-30 20:30:00	YM	Futures	29129.8	29133.0	29087.4	29103.7	2537.0
2019-06-30 21:00:00	YM	Futures	29104.8	29137.4	29104.8	29129.8	2068.0
2019-06-30 21:30:00	YM	Futures	29128.7	29132.0	29100.4	29132.0	1682.0
2019-06-30 22:00:00	YM	Futures	29132.0	29153.7	29132.0	29143.9	1350.0
2019-06-30 22:30:00	YM	Futures	29143.9	29147.2	29136.3	29145.0	663.0
2019-06-30 23:00:00	YM	Futures	29145.0	29146.1	29134.1	29135.2	438.0
2019-06-30 23:30:00	YM	Futures	29135.2	29155.9	29135.2	29152.6	682.0
2019-06-30 18:00:00	CL	Futures	52.59	53.33	52.59	52.76	12042.0
2019-06-30 18:30:00	CL	Futures	52.76	52.79	52.63	52.7	3511.0
2019-06-30 19:00:00	CL	Futures	52.7	52.75	52.65	52.69	2242.0
2019-06-30 19:30:00	CL	Futures	52.69	52.84	52.65	52.84	2197.0
2019-06-30 20:00:00	CL	Futures	52.83	53.07	52.77	52.89	6707.0
2019-06-30 20:30:00	CL	Futures	52.89	52.9	52.74	52.75	2641.0
2019-06-30 21:00:00	CL	Futures	52.74	52.96	52.73	52.86	7783.0
2019-06-30 21:30:00	CL	Futures	52.87	52.98	52.79	52.97	7858.0
2019-06-30 22:00:00	CL	Futures	52.97	53.01	52.92	52.98	4433.0
2019-06-30 22:30:00	CL	Futures	52.99	53.01	52.92	52.96	2929.0
2019-06-30 23:00:00	CL	Futures	52.95	52.98	52.93	52.96	1505.0
2019-06-30 23:30:00	CL	Futures	52.97	53.16	52.96	53.13	4217.0
2019-06-30 18:00:00	GC	Futures	1792.1	1792.2	1773.1	1786.6	15633.0
2019-06-30 18:30:00	GC	Futures	1786.6	1790.8	1783.9	1788.5	4834.0

> showing 50 of 700 rows — these rows as CSV

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