PREVIEW / futures_30min / 2019-07-03

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-03.parquet
  size:    82 KB
  rows:    3,224

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-07-03 00:00:00	ES	Futures	3222.2	3222.47	3220.31	3221.39	2427.0
2019-07-03 00:30:00	ES	Futures	3221.12	3222.2	3220.58	3222.2	2320.0
2019-07-03 01:00:00	ES	Futures	3222.2	3224.37	3221.93	3223.83	5168.0
2019-07-03 01:30:00	ES	Futures	3223.83	3224.91	3222.74	3224.37	3149.0
2019-07-03 02:00:00	ES	Futures	3224.64	3225.18	3222.74	3223.29	4531.0
2019-07-03 02:30:00	ES	Futures	3223.01	3224.37	3222.47	3224.1	2476.0
2019-07-03 03:00:00	ES	Futures	3223.83	3228.43	3223.29	3227.08	10880.0
2019-07-03 03:30:00	ES	Futures	3227.08	3230.86	3226.8	3230.05	12362.0
2019-07-03 04:00:00	ES	Futures	3229.78	3232.22	3229.24	3230.05	11501.0
2019-07-03 04:30:00	ES	Futures	3230.05	3233.84	3229.51	3233.3	11148.0
2019-07-03 05:00:00	ES	Futures	3233.3	3235.47	3233.3	3234.11	9219.0
2019-07-03 05:30:00	ES	Futures	3234.38	3234.65	3233.3	3234.38	6823.0
2019-07-03 06:00:00	ES	Futures	3234.38	3235.74	3233.3	3234.65	5562.0
2019-07-03 06:30:00	ES	Futures	3234.65	3235.74	3234.38	3234.93	4748.0
2019-07-03 07:00:00	ES	Futures	3234.93	3235.2	3233.3	3233.57	5962.0
2019-07-03 07:30:00	ES	Futures	3233.57	3234.11	3232.49	3232.49	6928.0
2019-07-03 08:00:00	ES	Futures	3232.49	3234.11	3231.41	3233.3	9335.0
2019-07-03 08:30:00	ES	Futures	3233.3	3233.57	3231.41	3233.03	9323.0
2019-07-03 09:00:00	ES	Futures	3233.03	3233.57	3229.78	3230.32	12817.0
2019-07-03 09:30:00	ES	Futures	3230.32	3233.03	3228.43	3231.95	113906.0
2019-07-03 10:00:00	ES	Futures	3231.68	3235.47	3230.32	3235.47	72619.0
2019-07-03 10:30:00	ES	Futures	3235.2	3239.26	3234.65	3237.9	81157.0
2019-07-03 11:00:00	ES	Futures	3238.17	3239.8	3235.2	3237.36	57668.0
2019-07-03 11:30:00	ES	Futures	3237.09	3243.05	3236.82	3243.05	59179.0
2019-07-03 12:00:00	ES	Futures	3243.05	3244.94	3242.23	3244.13	42383.0
2019-07-03 12:30:00	ES	Futures	3244.4	3248.19	3242.78	3247.38	96548.0
2019-07-03 13:00:00	ES	Futures	3247.38	3250.09	3246.3	3249.54	54684.0
2019-07-03 18:00:00	ES	Futures	3249.27	3254.96	3248.73	3249.81	4958.0
2019-07-03 18:30:00	ES	Futures	3249.81	3250.36	3248.73	3249.27	668.0
2019-07-03 19:00:00	ES	Futures	3249.27	3249.27	3247.38	3247.92	1352.0
2019-07-03 19:30:00	ES	Futures	3247.92	3248.46	3247.11	3248.19	1528.0
2019-07-03 20:00:00	ES	Futures	3248.19	3249.27	3247.38	3247.92	3613.0
2019-07-03 20:30:00	ES	Futures	3247.92	3248.19	3247.11	3247.65	1034.0
2019-07-03 21:00:00	ES	Futures	3247.65	3248.46	3246.57	3247.65	1755.0
2019-07-03 21:30:00	ES	Futures	3247.65	3248.73	3247.65	3248.19	2211.0
2019-07-03 22:00:00	ES	Futures	3248.46	3248.73	3247.38	3247.92	1625.0
2019-07-03 22:30:00	ES	Futures	3247.65	3247.65	3246.3	3246.57	2175.0
2019-07-03 23:00:00	ES	Futures	3246.3	3247.65	3246.02	3247.11	1291.0
2019-07-03 23:30:00	ES	Futures	3247.38	3247.65	3246.84	3247.38	899.0
2019-07-03 00:00:00	NQ	Futures	9088.13	9088.13	9081.75	9084.36	721.0
2019-07-03 00:30:00	NQ	Futures	9084.07	9087.26	9082.33	9086.39	507.0
2019-07-03 01:00:00	NQ	Futures	9086.1	9091.9	9084.94	9090.16	1105.0
2019-07-03 01:30:00	NQ	Futures	9090.16	9092.19	9086.1	9091.03	807.0
2019-07-03 02:00:00	NQ	Futures	9090.74	9094.22	9087.55	9089.0	1460.0
2019-07-03 02:30:00	NQ	Futures	9089.58	9095.68	9087.26	9095.09	1369.0
2019-07-03 03:00:00	NQ	Futures	9095.39	9113.08	9092.19	9109.6	4693.0
2019-07-03 03:30:00	NQ	Futures	9109.6	9120.92	9109.6	9116.28	3605.0
2019-07-03 04:00:00	NQ	Futures	9116.28	9125.56	9113.95	9118.6	3316.0
2019-07-03 04:30:00	NQ	Futures	9118.31	9129.91	9115.7	9126.72	2742.0
2019-07-03 05:00:00	NQ	Futures	9127.01	9136.01	9125.85	9130.78	2631.0

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

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