PREVIEW / futures_30min / 2019-07-05

all futures 30-min files

  file:    by_date/futures_30min/2019/2019-07-05.parquet
  size:    79 KB
  rows:    2,680

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-05 00:00:00	ES	Futures	3251.44	3251.98	3251.44	3251.71	879.0
2019-07-05 00:30:00	ES	Futures	3251.71	3252.79	3251.17	3252.25	2371.0
2019-07-05 01:00:00	ES	Futures	3252.25	3252.79	3251.71	3252.52	1023.0
2019-07-05 01:30:00	ES	Futures	3252.79	3252.79	3251.98	3252.25	1979.0
2019-07-05 02:00:00	ES	Futures	3252.25	3252.52	3251.17	3251.17	2510.0
2019-07-05 02:30:00	ES	Futures	3251.17	3251.71	3249.81	3250.63	2529.0
2019-07-05 03:00:00	ES	Futures	3250.63	3250.63	3246.3	3247.65	10257.0
2019-07-05 03:30:00	ES	Futures	3247.38	3247.92	3245.48	3247.11	8008.0
2019-07-05 04:00:00	ES	Futures	3247.38	3247.65	3244.67	3244.94	7260.0
2019-07-05 04:30:00	ES	Futures	3244.94	3246.3	3241.69	3241.96	9251.0
2019-07-05 05:00:00	ES	Futures	3242.23	3244.13	3241.69	3243.32	7420.0
2019-07-05 05:30:00	ES	Futures	3243.32	3244.13	3241.15	3241.69	4534.0
2019-07-05 06:00:00	ES	Futures	3241.96	3244.13	3241.69	3243.59	5556.0
2019-07-05 06:30:00	ES	Futures	3243.86	3244.4	3242.78	3243.32	5428.0
2019-07-05 07:00:00	ES	Futures	3243.32	3244.94	3242.78	3242.78	6003.0
2019-07-05 07:30:00	ES	Futures	3242.78	3243.32	3241.96	3242.51	5220.0
2019-07-05 08:00:00	ES	Futures	3242.23	3242.78	3240.34	3241.69	9857.0
2019-07-05 08:30:00	ES	Futures	3241.42	3245.48	3231.14	3235.47	83614.0
2019-07-05 09:00:00	ES	Futures	3235.2	3235.2	3230.05	3232.76	35374.0
2019-07-05 09:30:00	ES	Futures	3233.03	3234.65	3224.37	3224.91	146626.0
2019-07-05 10:00:00	ES	Futures	3224.64	3228.97	3221.93	3222.47	102235.0
2019-07-05 10:30:00	ES	Futures	3222.2	3224.1	3217.33	3223.56	97933.0
2019-07-05 11:00:00	ES	Futures	3223.83	3228.7	3221.12	3228.16	73618.0
2019-07-05 11:30:00	ES	Futures	3227.89	3229.78	3223.83	3229.78	49398.0
2019-07-05 12:00:00	ES	Futures	3229.51	3234.38	3226.8	3233.3	50832.0
2019-07-05 12:30:00	ES	Futures	3233.3	3237.09	3233.03	3235.74	39557.0
2019-07-05 13:00:00	ES	Futures	3235.47	3238.72	3233.57	3238.44	35630.0
2019-07-05 13:30:00	ES	Futures	3238.44	3241.15	3237.63	3239.26	37407.0
2019-07-05 14:00:00	ES	Futures	3238.99	3240.88	3237.9	3239.8	24485.0
2019-07-05 14:30:00	ES	Futures	3239.53	3246.02	3239.53	3245.75	35496.0
2019-07-05 15:00:00	ES	Futures	3245.48	3246.02	3239.53	3242.51	46435.0
2019-07-05 15:30:00	ES	Futures	3242.51	3244.13	3235.74	3243.05	140340.0
2019-07-05 16:00:00	ES	Futures	3243.05	3243.86	3237.36	3238.17	58979.0
2019-07-05 16:30:00	ES	Futures	3238.17	3240.07	3237.63	3239.53	7262.0
2019-07-05 00:00:00	NQ	Futures	9171.4	9173.72	9170.82	9173.43	304.0
2019-07-05 00:30:00	NQ	Futures	9173.72	9174.59	9171.4	9173.72	524.0
2019-07-05 01:00:00	NQ	Futures	9173.72	9177.79	9172.85	9176.92	765.0
2019-07-05 01:30:00	NQ	Futures	9177.21	9178.08	9175.46	9177.5	662.0
2019-07-05 02:00:00	NQ	Futures	9177.5	9178.08	9171.98	9173.14	1114.0
2019-07-05 02:30:00	NQ	Futures	9172.85	9173.72	9168.21	9169.66	1069.0
2019-07-05 03:00:00	NQ	Futures	9169.66	9169.66	9157.19	9159.51	2789.0
2019-07-05 03:30:00	NQ	Futures	9159.22	9161.25	9153.99	9158.06	2448.0
2019-07-05 04:00:00	NQ	Futures	9158.06	9159.22	9143.84	9144.71	3333.0
2019-07-05 04:30:00	NQ	Futures	9145.0	9150.8	9136.3	9137.46	2850.0
2019-07-05 05:00:00	NQ	Futures	9137.46	9143.84	9136.59	9142.1	2027.0
2019-07-05 05:30:00	NQ	Futures	9142.39	9143.84	9129.91	9131.36	2233.0
2019-07-05 06:00:00	NQ	Futures	9131.36	9140.65	9130.49	9138.91	1442.0
2019-07-05 06:30:00	NQ	Futures	9139.2	9139.78	9133.97	9139.2	1629.0
2019-07-05 07:00:00	NQ	Futures	9139.2	9143.55	9134.84	9134.84	1628.0
2019-07-05 07:30:00	NQ	Futures	9135.13	9136.88	9131.07	9132.81	1741.0

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

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