PREVIEW / futures_30min / 2019-06-19

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-06-19.parquet
  size:    97 KB
  rows:    3,534

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-19 00:00:00	ES	Futures	3169.96	3170.5	3169.69	3169.69	1916.0
2019-06-19 00:30:00	ES	Futures	3169.69	3169.96	3168.87	3169.69	1593.0
2019-06-19 01:00:00	ES	Futures	3169.69	3171.04	3169.14	3170.5	3103.0
2019-06-19 01:30:00	ES	Futures	3170.5	3170.77	3169.41	3169.41	2898.0
2019-06-19 02:00:00	ES	Futures	3169.41	3170.5	3168.33	3169.96	4688.0
2019-06-19 02:30:00	ES	Futures	3169.96	3170.23	3167.79	3167.79	3281.0
2019-06-19 03:00:00	ES	Futures	3167.79	3170.77	3167.52	3169.41	9190.0
2019-06-19 03:30:00	ES	Futures	3169.14	3170.77	3168.6	3168.87	6221.0
2019-06-19 04:00:00	ES	Futures	3169.14	3170.23	3166.98	3167.52	7972.0
2019-06-19 04:30:00	ES	Futures	3167.52	3168.33	3163.73	3165.35	10382.0
2019-06-19 05:00:00	ES	Futures	3165.35	3168.33	3164.81	3165.9	12291.0
2019-06-19 05:30:00	ES	Futures	3166.17	3168.6	3165.9	3168.06	9621.0
2019-06-19 06:00:00	ES	Futures	3168.33	3169.69	3166.71	3169.41	8048.0
2019-06-19 06:30:00	ES	Futures	3169.41	3170.5	3168.06	3169.14	7120.0
2019-06-19 07:00:00	ES	Futures	3169.14	3169.41	3166.71	3167.25	6997.0
2019-06-19 07:30:00	ES	Futures	3167.25	3169.41	3166.71	3169.41	6879.0
2019-06-19 08:00:00	ES	Futures	3169.14	3169.69	3167.79	3168.6	12675.0
2019-06-19 08:30:00	ES	Futures	3168.87	3170.77	3168.33	3169.41	11026.0
2019-06-19 09:00:00	ES	Futures	3169.14	3169.41	3167.52	3167.79	14038.0
2019-06-19 09:30:00	ES	Futures	3167.79	3169.69	3162.38	3168.6	154201.0
2019-06-19 10:00:00	ES	Futures	3168.33	3169.14	3163.46	3163.73	63466.0
2019-06-19 10:30:00	ES	Futures	3164.0	3165.35	3162.38	3164.27	61622.0
2019-06-19 11:00:00	ES	Futures	3164.27	3166.17	3163.73	3166.17	38973.0
2019-06-19 11:30:00	ES	Futures	3165.9	3167.52	3164.0	3165.9	37804.0
2019-06-19 12:00:00	ES	Futures	3166.17	3166.44	3163.73	3164.54	27530.0
2019-06-19 12:30:00	ES	Futures	3164.27	3164.54	3163.46	3163.73	24531.0
2019-06-19 13:00:00	ES	Futures	3163.73	3164.0	3160.75	3162.65	33437.0
2019-06-19 13:30:00	ES	Futures	3162.92	3165.63	3161.29	3164.81	32170.0
2019-06-19 14:00:00	ES	Futures	3164.81	3178.35	3156.69	3169.14	186714.0
2019-06-19 14:30:00	ES	Futures	3168.87	3176.45	3165.35	3171.58	115549.0
2019-06-19 15:00:00	ES	Futures	3171.31	3178.35	3170.5	3175.64	92413.0
2019-06-19 15:30:00	ES	Futures	3175.37	3179.97	3171.58	3173.75	171922.0
2019-06-19 16:00:00	ES	Futures	3173.75	3176.99	3172.66	3176.18	46776.0
2019-06-19 16:30:00	ES	Futures	3175.37	3176.45	3174.02	3174.29	6771.0
2019-06-19 18:00:00	ES	Futures	3173.48	3177.27	3173.2	3176.72	5071.0
2019-06-19 18:30:00	ES	Futures	3176.72	3181.33	3175.91	3180.24	5003.0
2019-06-19 19:00:00	ES	Futures	3180.51	3182.68	3179.97	3182.14	2843.0
2019-06-19 19:30:00	ES	Futures	3182.41	3186.74	3181.33	3184.57	7557.0
2019-06-19 20:00:00	ES	Futures	3184.85	3186.2	3183.49	3183.76	12227.0
2019-06-19 20:30:00	ES	Futures	3184.03	3186.47	3184.03	3184.57	8312.0
2019-06-19 21:00:00	ES	Futures	3184.57	3188.91	3183.76	3185.93	13615.0
2019-06-19 21:30:00	ES	Futures	3185.66	3187.01	3185.12	3187.01	9158.0
2019-06-19 22:00:00	ES	Futures	3186.74	3188.64	3185.66	3187.28	7283.0
2019-06-19 22:30:00	ES	Futures	3187.55	3188.64	3186.47	3186.47	4433.0
2019-06-19 23:00:00	ES	Futures	3186.47	3188.91	3186.47	3188.09	4939.0
2019-06-19 23:30:00	ES	Futures	3188.36	3189.45	3188.09	3188.64	3198.0
2019-06-19 00:00:00	NQ	Futures	8911.14	8911.72	8907.95	8908.24	590.0
2019-06-19 00:30:00	NQ	Futures	8908.53	8910.27	8905.34	8909.98	838.0
2019-06-19 01:00:00	NQ	Futures	8909.69	8915.21	8907.95	8913.47	881.0
2019-06-19 01:30:00	NQ	Futures	8913.47	8914.92	8908.82	8909.69	1076.0

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

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