PREVIEW / futures_30min / 2019-04-07

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-04-07.parquet
  size:    23 KB
  rows:    640

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-04-07 18:00:00	ES	Futures	3140.72	3143.16	3140.45	3141.26	4337.0
2019-04-07 18:30:00	ES	Futures	3141.26	3142.35	3140.99	3141.8	919.0
2019-04-07 19:00:00	ES	Futures	3141.53	3142.35	3140.72	3140.99	1020.0
2019-04-07 19:30:00	ES	Futures	3140.99	3144.24	3140.99	3142.62	3825.0
2019-04-07 20:00:00	ES	Futures	3142.35	3142.35	3140.45	3140.99	5761.0
2019-04-07 20:30:00	ES	Futures	3140.99	3141.26	3138.01	3139.36	3825.0
2019-04-07 21:00:00	ES	Futures	3139.36	3139.36	3136.92	3138.01	4655.0
2019-04-07 21:30:00	ES	Futures	3138.01	3139.36	3137.74	3138.01	3985.0
2019-04-07 22:00:00	ES	Futures	3138.28	3138.55	3136.38	3136.38	4649.0
2019-04-07 22:30:00	ES	Futures	3136.65	3137.74	3136.38	3137.2	2576.0
2019-04-07 23:00:00	ES	Futures	3137.47	3137.47	3136.11	3136.11	3406.0
2019-04-07 23:30:00	ES	Futures	3136.38	3136.38	3133.4	3135.3	6048.0
2019-04-07 18:00:00	NQ	Futures	8860.17	8865.12	8856.97	8858.71	1965.0
2019-04-07 18:30:00	NQ	Futures	8859.01	8862.5	8858.71	8861.33	564.0
2019-04-07 19:00:00	NQ	Futures	8861.33	8864.25	8859.59	8861.04	643.0
2019-04-07 19:30:00	NQ	Futures	8860.75	8874.15	8860.75	8866.58	1978.0
2019-04-07 20:00:00	NQ	Futures	8866.58	8866.87	8859.88	8860.46	2539.0
2019-04-07 20:30:00	NQ	Futures	8861.04	8862.5	8850.56	8854.64	2350.0
2019-04-07 21:00:00	NQ	Futures	8854.64	8854.93	8847.36	8851.44	2517.0
2019-04-07 21:30:00	NQ	Futures	8851.14	8856.68	8850.27	8852.89	2063.0
2019-04-07 22:00:00	NQ	Futures	8852.6	8853.76	8845.61	8845.9	2632.0
2019-04-07 22:30:00	NQ	Futures	8845.9	8850.56	8845.61	8848.81	1737.0
2019-04-07 23:00:00	NQ	Futures	8848.81	8849.11	8843.28	8843.87	1836.0
2019-04-07 23:30:00	NQ	Futures	8843.57	8844.16	8837.17	8840.95	2587.0
2019-04-07 18:00:00	YM	Futures	28702.4	28712.2	28664.4	28698.1	1433.0
2019-04-07 18:30:00	YM	Futures	28698.1	28710.1	28697.0	28703.5	357.0
2019-04-07 19:00:00	YM	Futures	28703.5	28710.1	28694.8	28698.1	203.0
2019-04-07 19:30:00	YM	Futures	28699.2	28727.5	28699.2	28710.1	631.0
2019-04-07 20:00:00	YM	Futures	28712.2	28713.3	28692.7	28700.3	2331.0
2019-04-07 20:30:00	YM	Futures	28700.3	28703.5	28672.0	28684.0	1038.0
2019-04-07 21:00:00	YM	Futures	28682.9	28688.3	28666.6	28674.2	1366.0
2019-04-07 21:30:00	YM	Futures	28672.0	28686.1	28672.0	28675.3	1632.0
2019-04-07 22:00:00	YM	Futures	28675.3	28677.4	28642.6	28645.9	3215.0
2019-04-07 22:30:00	YM	Futures	28645.9	28662.2	28645.9	28658.9	642.0
2019-04-07 23:00:00	YM	Futures	28658.9	28660.0	28636.1	28638.3	1277.0
2019-04-07 23:30:00	YM	Futures	28639.4	28641.5	28614.3	28633.9	2276.0
2019-04-07 18:00:00	CL	Futures	56.74	56.87	56.71	56.85	4424.0
2019-04-07 18:30:00	CL	Futures	56.84	56.88	56.8	56.81	1363.0
2019-04-07 19:00:00	CL	Futures	56.82	56.86	56.81	56.82	943.0
2019-04-07 19:30:00	CL	Futures	56.82	56.87	56.81	56.81	1203.0
2019-04-07 20:00:00	CL	Futures	56.81	56.86	56.77	56.84	2354.0
2019-04-07 20:30:00	CL	Futures	56.83	56.88	56.82	56.84	2171.0
2019-04-07 21:00:00	CL	Futures	56.85	56.87	56.77	56.87	5072.0
2019-04-07 21:30:00	CL	Futures	56.87	56.88	56.83	56.86	3462.0
2019-04-07 22:00:00	CL	Futures	56.87	56.88	56.84	56.84	2087.0
2019-04-07 22:30:00	CL	Futures	56.84	56.87	56.84	56.85	1959.0
2019-04-07 23:00:00	CL	Futures	56.86	56.87	56.81	56.83	1820.0
2019-04-07 23:30:00	CL	Futures	56.83	56.83	56.8	56.82	1706.0
2019-04-07 18:00:00	GC	Futures	1662.9	1664.4	1662.7	1664.2	1873.0
2019-04-07 18:30:00	GC	Futures	1664.3	1666.2	1663.9	1664.7	1978.0

> showing 50 of 640 rows — these rows as CSV

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