PREVIEW / futures_30min / 2019-06-14

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-06-14.parquet
  size:    76 KB
  rows:    2,715

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-14 00:00:00	ES	Futures	3140.99	3141.53	3139.91	3140.45	1161.0
2019-06-14 00:30:00	ES	Futures	3140.45	3142.34	3140.18	3141.8	1435.0
2019-06-14 01:00:00	ES	Futures	3141.8	3141.8	3139.91	3140.45	2261.0
2019-06-14 01:30:00	ES	Futures	3140.45	3141.53	3139.37	3139.91	2205.0
2019-06-14 02:00:00	ES	Futures	3139.91	3139.91	3137.47	3137.74	4979.0
2019-06-14 02:30:00	ES	Futures	3137.47	3137.47	3132.33	3133.68	6411.0
2019-06-14 03:00:00	ES	Futures	3133.41	3136.93	3130.7	3130.97	9902.0
2019-06-14 03:30:00	ES	Futures	3130.97	3133.68	3130.16	3133.14	6064.0
2019-06-14 04:00:00	ES	Futures	3133.41	3134.49	3129.62	3129.89	5987.0
2019-06-14 04:30:00	ES	Futures	3129.89	3130.97	3128.54	3130.7	7169.0
2019-06-14 05:00:00	ES	Futures	3130.7	3132.6	3130.16	3131.25	4284.0
2019-06-14 05:30:00	ES	Futures	3131.25	3132.6	3127.73	3129.62	6429.0
2019-06-14 06:00:00	ES	Futures	3129.89	3130.7	3124.75	3125.29	6407.0
2019-06-14 06:30:00	ES	Futures	3125.56	3129.08	3125.02	3128.27	5977.0
2019-06-14 07:00:00	ES	Futures	3128.27	3130.97	3128.0	3128.81	5923.0
2019-06-14 07:30:00	ES	Futures	3128.81	3132.6	3128.0	3132.06	5074.0
2019-06-14 08:00:00	ES	Futures	3132.06	3132.6	3129.89	3130.97	5680.0
2019-06-14 08:30:00	ES	Futures	3130.97	3133.68	3129.89	3131.79	15879.0
2019-06-14 09:00:00	ES	Futures	3131.79	3135.58	3130.97	3132.6	12674.0
2019-06-14 09:30:00	ES	Futures	3132.6	3133.41	3123.12	3125.83	114465.0
2019-06-14 10:00:00	ES	Futures	3125.83	3129.89	3123.67	3127.46	80237.0
2019-06-14 10:30:00	ES	Futures	3127.18	3132.6	3125.02	3130.97	43411.0
2019-06-14 11:00:00	ES	Futures	3130.97	3131.79	3123.4	3130.16	47397.0
2019-06-14 11:30:00	ES	Futures	3130.16	3132.6	3128.0	3128.81	38094.0
2019-06-14 12:00:00	ES	Futures	3128.81	3128.81	3125.83	3127.73	26692.0
2019-06-14 12:30:00	ES	Futures	3128.0	3129.89	3127.73	3129.08	15316.0
2019-06-14 13:00:00	ES	Futures	3129.08	3130.16	3128.0	3128.27	15863.0
2019-06-14 13:30:00	ES	Futures	3128.27	3129.35	3126.64	3127.18	14737.0
2019-06-14 14:00:00	ES	Futures	3126.91	3132.06	3126.91	3131.52	23825.0
2019-06-14 14:30:00	ES	Futures	3131.52	3132.33	3130.7	3131.79	13766.0
2019-06-14 15:00:00	ES	Futures	3131.52	3138.83	3131.52	3137.47	37790.0
2019-06-14 15:30:00	ES	Futures	3137.74	3139.91	3131.52	3132.33	77515.0
2019-06-14 16:00:00	ES	Futures	3132.33	3135.85	3132.06	3134.49	31368.0
2019-06-14 16:30:00	ES	Futures	3134.49	3136.39	3133.95	3136.12	4254.0
2019-06-14 00:00:00	NQ	Futures	8750.99	8753.02	8746.92	8749.54	303.0
2019-06-14 00:30:00	NQ	Futures	8749.83	8756.79	8749.25	8753.89	458.0
2019-06-14 01:00:00	NQ	Futures	8753.6	8753.89	8744.89	8748.96	720.0
2019-06-14 01:30:00	NQ	Futures	8748.08	8751.57	8741.7	8744.6	541.0
2019-06-14 02:00:00	NQ	Futures	8744.02	8744.6	8730.68	8730.97	1501.0
2019-06-14 02:30:00	NQ	Futures	8730.68	8731.26	8713.27	8718.2	1676.0
2019-06-14 03:00:00	NQ	Futures	8717.91	8729.52	8706.01	8708.92	2751.0
2019-06-14 03:30:00	NQ	Futures	8708.04	8719.36	8706.59	8717.33	1255.0
2019-06-14 04:00:00	NQ	Futures	8718.49	8722.26	8702.82	8703.98	1299.0
2019-06-14 04:30:00	NQ	Futures	8704.27	8708.34	8696.73	8704.56	1762.0
2019-06-14 05:00:00	NQ	Futures	8704.56	8710.66	8702.24	8705.14	1010.0
2019-06-14 05:30:00	NQ	Futures	8705.43	8709.21	8691.22	8697.02	1652.0
2019-06-14 06:00:00	NQ	Futures	8697.31	8699.92	8678.45	8682.51	2031.0
2019-06-14 06:30:00	NQ	Futures	8682.51	8692.67	8678.74	8689.77	1385.0
2019-06-14 07:00:00	NQ	Futures	8690.06	8698.76	8688.03	8689.77	1620.0
2019-06-14 07:30:00	NQ	Futures	8690.35	8710.37	8689.19	8708.34	1342.0

> showing 50 of 2,715 rows — these rows as CSV

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