PREVIEW / futures_30min / 2019-06-25

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-06-25.parquet
  size:    92 KB
  rows:    3,462

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-25 00:00:00	ES	Futures	3189.45	3190.53	3187.28	3187.82	4998.0
2019-06-25 00:30:00	ES	Futures	3187.55	3188.36	3185.93	3186.47	6405.0
2019-06-25 01:00:00	ES	Futures	3186.47	3188.36	3185.93	3187.28	4940.0
2019-06-25 01:30:00	ES	Futures	3187.28	3189.45	3186.47	3189.45	5786.0
2019-06-25 02:00:00	ES	Futures	3189.45	3191.07	3188.09	3188.64	7645.0
2019-06-25 02:30:00	ES	Futures	3188.64	3188.64	3187.01	3188.09	4894.0
2019-06-25 03:00:00	ES	Futures	3188.36	3192.15	3187.82	3190.8	13165.0
2019-06-25 03:30:00	ES	Futures	3190.8	3192.15	3188.36	3189.99	8324.0
2019-06-25 04:00:00	ES	Futures	3189.99	3191.88	3188.91	3190.53	7792.0
2019-06-25 04:30:00	ES	Futures	3190.53	3193.78	3189.45	3190.53	10027.0
2019-06-25 05:00:00	ES	Futures	3190.26	3191.88	3188.91	3190.8	6979.0
2019-06-25 05:30:00	ES	Futures	3190.53	3193.78	3190.53	3191.34	7826.0
2019-06-25 06:00:00	ES	Futures	3191.34	3192.15	3189.72	3191.07	5893.0
2019-06-25 06:30:00	ES	Futures	3191.34	3192.7	3189.72	3192.7	6401.0
2019-06-25 07:00:00	ES	Futures	3192.42	3193.78	3192.15	3192.97	6886.0
2019-06-25 07:30:00	ES	Futures	3192.97	3193.51	3191.07	3192.97	9640.0
2019-06-25 08:00:00	ES	Futures	3192.97	3194.05	3191.07	3192.15	8074.0
2019-06-25 08:30:00	ES	Futures	3192.42	3195.94	3191.88	3195.13	11493.0
2019-06-25 09:00:00	ES	Futures	3195.13	3197.57	3194.86	3195.4	13626.0
2019-06-25 09:30:00	ES	Futures	3195.4	3195.67	3184.03	3188.64	168105.0
2019-06-25 10:00:00	ES	Futures	3188.64	3189.45	3181.06	3185.39	112684.0
2019-06-25 10:30:00	ES	Futures	3185.66	3187.01	3179.43	3181.33	90650.0
2019-06-25 11:00:00	ES	Futures	3181.33	3186.2	3179.16	3183.49	71397.0
2019-06-25 11:30:00	ES	Futures	3183.76	3184.85	3181.33	3182.68	38875.0
2019-06-25 12:00:00	ES	Futures	3182.68	3185.66	3181.06	3182.68	34542.0
2019-06-25 12:30:00	ES	Futures	3182.95	3183.49	3174.29	3176.18	82176.0
2019-06-25 13:00:00	ES	Futures	3175.91	3178.89	3169.14	3178.08	101929.0
2019-06-25 13:30:00	ES	Futures	3178.08	3182.14	3175.1	3175.37	68731.0
2019-06-25 14:00:00	ES	Futures	3175.37	3176.72	3170.77	3171.31	47163.0
2019-06-25 14:30:00	ES	Futures	3171.04	3171.85	3162.92	3169.14	91491.0
2019-06-25 15:00:00	ES	Futures	3169.14	3172.12	3165.35	3169.14	71182.0
2019-06-25 15:30:00	ES	Futures	3169.41	3170.5	3161.84	3164.0	139723.0
2019-06-25 16:00:00	ES	Futures	3164.0	3166.17	3163.46	3164.27	55258.0
2019-06-25 16:30:00	ES	Futures	3163.73	3165.63	3163.46	3165.08	5975.0
2019-06-25 18:00:00	ES	Futures	3164.54	3166.17	3164.0	3166.17	3036.0
2019-06-25 18:30:00	ES	Futures	3166.44	3167.25	3165.63	3167.25	1430.0
2019-06-25 19:00:00	ES	Futures	3167.25	3167.52	3162.92	3163.73	2766.0
2019-06-25 19:30:00	ES	Futures	3163.73	3163.73	3159.13	3162.65	6185.0
2019-06-25 20:00:00	ES	Futures	3162.65	3167.25	3162.38	3166.98	7535.0
2019-06-25 20:30:00	ES	Futures	3166.98	3168.33	3165.63	3166.71	3587.0
2019-06-25 21:00:00	ES	Futures	3166.44	3166.98	3163.46	3164.27	3973.0
2019-06-25 21:30:00	ES	Futures	3164.54	3167.52	3163.73	3165.08	5475.0
2019-06-25 22:00:00	ES	Futures	3165.08	3167.25	3164.0	3166.98	5404.0
2019-06-25 22:30:00	ES	Futures	3166.98	3167.52	3164.27	3165.35	3137.0
2019-06-25 23:00:00	ES	Futures	3165.35	3166.98	3164.54	3166.71	2389.0
2019-06-25 23:30:00	ES	Futures	3166.71	3166.71	3165.35	3165.63	2058.0
2019-06-25 00:00:00	NQ	Futures	8970.33	8974.4	8955.54	8956.7	2856.0
2019-06-25 00:30:00	NQ	Futures	8956.41	8963.95	8952.93	8956.99	2579.0
2019-06-25 01:00:00	NQ	Futures	8956.99	8963.66	8955.25	8960.47	2071.0
2019-06-25 01:30:00	NQ	Futures	8960.18	8969.75	8958.15	8968.88	2320.0

> showing 50 of 3,462 rows — these rows as CSV

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