PREVIEW / futures_30min / 2019-08-19

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-08-19.parquet
  size:    92 KB
  rows:    3,450

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-08-19 00:00:00	ES	Futures	3146.41	3147.22	3146.13	3146.95	920.0
2019-08-19 00:30:00	ES	Futures	3146.95	3147.76	3146.41	3147.49	1243.0
2019-08-19 01:00:00	ES	Futures	3147.49	3150.74	3146.95	3150.19	6374.0
2019-08-19 01:30:00	ES	Futures	3150.19	3151.55	3149.65	3149.92	4873.0
2019-08-19 02:00:00	ES	Futures	3149.65	3154.26	3148.84	3153.44	9563.0
2019-08-19 02:30:00	ES	Futures	3153.44	3159.4	3153.17	3159.13	12675.0
2019-08-19 03:00:00	ES	Futures	3159.13	3162.92	3156.69	3157.77	25884.0
2019-08-19 03:30:00	ES	Futures	3157.77	3158.32	3155.07	3156.96	13444.0
2019-08-19 04:00:00	ES	Futures	3156.69	3158.59	3152.9	3153.98	13581.0
2019-08-19 04:30:00	ES	Futures	3153.98	3154.8	3152.09	3152.9	10819.0
2019-08-19 05:00:00	ES	Futures	3152.9	3156.96	3152.63	3156.69	9373.0
2019-08-19 05:30:00	ES	Futures	3156.69	3158.86	3154.8	3158.05	9436.0
2019-08-19 06:00:00	ES	Futures	3158.32	3161.02	3157.23	3158.59	11562.0
2019-08-19 06:30:00	ES	Futures	3158.59	3165.35	3156.15	3161.29	19852.0
2019-08-19 07:00:00	ES	Futures	3161.29	3166.71	3159.4	3165.9	19742.0
2019-08-19 07:30:00	ES	Futures	3165.9	3171.04	3164.0	3164.81	29431.0
2019-08-19 08:00:00	ES	Futures	3164.81	3165.35	3159.94	3161.29	24279.0
2019-08-19 08:30:00	ES	Futures	3161.29	3167.79	3161.02	3165.35	24686.0
2019-08-19 09:00:00	ES	Futures	3165.63	3167.79	3163.46	3165.63	20766.0
2019-08-19 09:30:00	ES	Futures	3165.63	3168.33	3160.75	3163.46	138162.0
2019-08-19 10:00:00	ES	Futures	3163.46	3164.0	3156.96	3161.02	98267.0
2019-08-19 10:30:00	ES	Futures	3160.75	3165.9	3159.94	3164.0	65290.0
2019-08-19 11:00:00	ES	Futures	3164.0	3169.41	3164.0	3168.33	66005.0
2019-08-19 11:30:00	ES	Futures	3168.6	3171.04	3166.17	3167.25	57459.0
2019-08-19 12:00:00	ES	Futures	3167.25	3167.79	3165.08	3166.71	46125.0
2019-08-19 12:30:00	ES	Futures	3166.98	3171.04	3164.81	3170.5	40413.0
2019-08-19 13:00:00	ES	Futures	3170.77	3175.1	3170.23	3172.39	43530.0
2019-08-19 13:30:00	ES	Futures	3172.66	3172.66	3169.41	3170.5	33709.0
2019-08-19 14:00:00	ES	Futures	3170.5	3170.77	3167.52	3169.96	36281.0
2019-08-19 14:30:00	ES	Futures	3169.96	3172.66	3167.52	3169.69	42677.0
2019-08-19 15:00:00	ES	Futures	3169.96	3171.31	3167.25	3169.69	47525.0
2019-08-19 15:30:00	ES	Futures	3169.96	3173.2	3165.35	3166.71	129472.0
2019-08-19 16:00:00	ES	Futures	3166.71	3166.98	3163.73	3165.63	59224.0
2019-08-19 16:30:00	ES	Futures	3166.17	3166.98	3162.92	3164.27	9480.0
2019-08-19 18:00:00	ES	Futures	3163.19	3164.81	3161.29	3162.92	3852.0
2019-08-19 18:30:00	ES	Futures	3162.92	3165.35	3162.65	3164.54	2085.0
2019-08-19 19:00:00	ES	Futures	3164.54	3165.08	3162.65	3164.0	1409.0
2019-08-19 19:30:00	ES	Futures	3163.73	3164.0	3159.4	3160.48	4384.0
2019-08-19 20:00:00	ES	Futures	3160.48	3161.56	3158.86	3161.02	6974.0
2019-08-19 20:30:00	ES	Futures	3161.02	3161.84	3157.77	3158.59	5574.0
2019-08-19 21:00:00	ES	Futures	3158.86	3160.21	3157.5	3159.4	5044.0
2019-08-19 21:30:00	ES	Futures	3159.4	3163.73	3159.4	3163.73	5238.0
2019-08-19 22:00:00	ES	Futures	3163.73	3166.44	3163.46	3164.81	5170.0
2019-08-19 22:30:00	ES	Futures	3164.81	3169.14	3164.54	3168.87	5079.0
2019-08-19 23:00:00	ES	Futures	3169.14	3169.69	3166.71	3166.98	3764.0
2019-08-19 23:30:00	ES	Futures	3167.25	3171.04	3166.98	3169.14	2902.0
2019-08-19 00:00:00	NQ	Futures	8885.03	8888.51	8884.45	8888.22	631.0
2019-08-19 00:30:00	NQ	Futures	8888.51	8893.16	8887.64	8892.29	917.0
2019-08-19 01:00:00	NQ	Futures	8892.58	8901.86	8890.25	8900.12	2610.0
2019-08-19 01:30:00	NQ	Futures	8900.12	8905.05	8898.09	8898.38	2150.0

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

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