PREVIEW / futures_1hour / 2019-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-15.parquet
  size:    61 KB
  rows:    1,890

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-10-15 00:00:00	ES	Futures	3229.15	3231.32	3228.88	3230.78	3369.0
2019-10-15 01:00:00	ES	Futures	3230.78	3234.04	3229.42	3232.68	5850.0
2019-10-15 02:00:00	ES	Futures	3232.95	3240.56	3232.14	3238.93	20211.0
2019-10-15 03:00:00	ES	Futures	3239.2	3240.56	3236.48	3237.3	20368.0
2019-10-15 04:00:00	ES	Futures	3237.03	3240.56	3233.22	3234.85	21537.0
2019-10-15 05:00:00	ES	Futures	3234.85	3236.75	3232.95	3236.21	15560.0
2019-10-15 06:00:00	ES	Futures	3236.21	3237.84	3228.61	3231.87	25832.0
2019-10-15 07:00:00	ES	Futures	3232.14	3236.48	3229.42	3231.59	30384.0
2019-10-15 08:00:00	ES	Futures	3231.59	3233.22	3229.42	3231.59	12791.0
2019-10-15 09:00:00	ES	Futures	3231.59	3239.47	3230.51	3237.84	116128.0
2019-10-15 10:00:00	ES	Futures	3237.57	3260.11	3237.57	3259.84	256472.0
2019-10-15 11:00:00	ES	Futures	3260.11	3261.74	3253.6	3257.67	141803.0
2019-10-15 12:00:00	ES	Futures	3257.94	3259.57	3255.5	3259.57	63054.0
2019-10-15 13:00:00	ES	Futures	3259.57	3262.02	3256.31	3260.39	59968.0
2019-10-15 14:00:00	ES	Futures	3260.66	3263.1	3257.13	3258.76	61326.0
2019-10-15 15:00:00	ES	Futures	3258.49	3260.39	3253.87	3254.68	168663.0
2019-10-15 16:00:00	ES	Futures	3254.41	3258.21	3253.32	3255.77	68678.0
2019-10-15 18:00:00	ES	Futures	3255.77	3257.13	3253.87	3254.95	5208.0
2019-10-15 19:00:00	ES	Futures	3254.95	3254.95	3252.24	3253.87	5941.0
2019-10-15 20:00:00	ES	Futures	3253.87	3256.04	3246.81	3249.79	23021.0
2019-10-15 21:00:00	ES	Futures	3249.79	3251.97	3247.08	3251.69	12146.0
2019-10-15 22:00:00	ES	Futures	3251.69	3252.51	3249.52	3250.34	8183.0
2019-10-15 23:00:00	ES	Futures	3250.34	3250.61	3245.45	3246.53	9677.0
2019-10-15 00:00:00	NQ	Futures	9151.96	9157.48	9150.51	9155.74	1506.0
2019-10-15 01:00:00	NQ	Futures	9155.74	9169.68	9151.96	9165.03	2405.0
2019-10-15 02:00:00	NQ	Futures	9165.61	9188.27	9163.29	9182.17	7449.0
2019-10-15 03:00:00	NQ	Futures	9182.17	9189.14	9174.62	9176.07	7510.0
2019-10-15 04:00:00	NQ	Futures	9176.36	9188.27	9164.16	9169.68	8800.0
2019-10-15 05:00:00	NQ	Futures	9169.39	9176.07	9163.58	9173.75	5500.0
2019-10-15 06:00:00	NQ	Futures	9174.33	9178.69	9150.8	9156.03	9443.0
2019-10-15 07:00:00	NQ	Futures	9156.32	9164.16	9142.08	9152.54	12231.0
2019-10-15 08:00:00	NQ	Futures	9152.25	9160.38	9145.28	9152.83	7773.0
2019-10-15 09:00:00	NQ	Futures	9152.83	9182.46	9146.73	9173.75	43316.0
2019-10-15 10:00:00	NQ	Futures	9173.75	9242.3	9173.17	9241.72	67294.0
2019-10-15 11:00:00	NQ	Futures	9241.72	9246.37	9217.03	9235.62	43567.0
2019-10-15 12:00:00	NQ	Futures	9235.91	9242.59	9226.62	9238.82	21925.0
2019-10-15 13:00:00	NQ	Futures	9239.11	9258.57	9238.24	9255.08	20910.0
2019-10-15 14:00:00	NQ	Futures	9255.08	9262.93	9247.53	9251.6	19368.0
2019-10-15 15:00:00	NQ	Futures	9251.6	9254.79	9237.07	9241.14	35047.0
2019-10-15 16:00:00	NQ	Futures	9241.14	9252.18	9238.53	9248.69	10534.0
2019-10-15 18:00:00	NQ	Futures	9249.28	9249.57	9240.85	9242.59	2470.0
2019-10-15 19:00:00	NQ	Futures	9242.3	9243.17	9234.17	9239.69	3224.0
2019-10-15 20:00:00	NQ	Futures	9239.69	9248.11	9221.97	9229.52	7329.0
2019-10-15 21:00:00	NQ	Futures	9229.81	9235.33	9219.64	9233.3	5309.0
2019-10-15 22:00:00	NQ	Futures	9233.3	9238.53	9228.07	9232.72	4135.0
2019-10-15 23:00:00	NQ	Futures	9232.43	9233.88	9218.48	9222.55	5476.0
2019-10-15 00:00:00	YM	Futures	29163.5	29179.8	29159.1	29173.3	883.0
2019-10-15 01:00:00	YM	Futures	29174.4	29204.8	29163.5	29192.9	1299.0
2019-10-15 02:00:00	YM	Futures	29194.0	29260.4	29194.0	29246.2	4787.0
2019-10-15 03:00:00	YM	Futures	29246.2	29266.9	29229.9	29229.9	4466.0

> showing 50 of 1,890 rows — these rows as CSV

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