PREVIEW / futures_1hour / 2019-10-17

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-17.parquet
  size:    60 KB
  rows:    1,870

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-17 00:00:00	ES	Futures	3248.43	3249.79	3247.89	3248.71	2325.0
2019-10-17 01:00:00	ES	Futures	3248.98	3249.25	3244.63	3244.9	5321.0
2019-10-17 02:00:00	ES	Futures	3244.63	3246.26	3243.55	3244.36	9062.0
2019-10-17 03:00:00	ES	Futures	3244.63	3252.78	3244.36	3251.15	17420.0
2019-10-17 04:00:00	ES	Futures	3251.15	3256.86	3250.34	3253.32	18273.0
2019-10-17 05:00:00	ES	Futures	3253.32	3266.63	3250.61	3263.1	65085.0
2019-10-17 06:00:00	ES	Futures	3263.37	3266.91	3260.11	3261.74	26685.0
2019-10-17 07:00:00	ES	Futures	3261.47	3263.92	3257.4	3260.11	25377.0
2019-10-17 08:00:00	ES	Futures	3260.39	3262.56	3255.77	3260.93	31777.0
2019-10-17 09:00:00	ES	Futures	3260.93	3267.99	3258.76	3266.36	136958.0
2019-10-17 10:00:00	ES	Futures	3266.63	3268.26	3256.58	3257.4	162615.0
2019-10-17 11:00:00	ES	Futures	3257.67	3260.93	3250.61	3253.6	160822.0
2019-10-17 12:00:00	ES	Futures	3253.87	3257.94	3249.25	3257.67	70561.0
2019-10-17 13:00:00	ES	Futures	3257.94	3260.11	3255.5	3258.76	50577.0
2019-10-17 14:00:00	ES	Futures	3258.76	3261.74	3254.68	3260.93	64992.0
2019-10-17 15:00:00	ES	Futures	3260.93	3261.74	3255.23	3257.13	126190.0
2019-10-17 16:00:00	ES	Futures	3257.13	3258.49	3255.77	3257.67	46661.0
2019-10-17 18:00:00	ES	Futures	3257.13	3257.67	3254.14	3256.04	7367.0
2019-10-17 19:00:00	ES	Futures	3256.31	3256.86	3254.95	3255.77	3754.0
2019-10-17 20:00:00	ES	Futures	3256.04	3257.67	3252.51	3254.95	8765.0
2019-10-17 21:00:00	ES	Futures	3254.68	3256.58	3252.78	3253.32	8083.0
2019-10-17 22:00:00	ES	Futures	3253.05	3258.76	3251.42	3253.32	13143.0
2019-10-17 23:00:00	ES	Futures	3253.32	3254.41	3250.61	3252.78	7072.0
2019-10-17 00:00:00	NQ	Futures	9232.14	9236.49	9229.81	9233.3	893.0
2019-10-17 01:00:00	NQ	Futures	9233.01	9235.04	9217.61	9217.9	2583.0
2019-10-17 02:00:00	NQ	Futures	9218.19	9226.04	9215.0	9220.23	3076.0
2019-10-17 03:00:00	NQ	Futures	9220.52	9245.79	9219.06	9239.98	7237.0
2019-10-17 04:00:00	NQ	Futures	9239.98	9257.99	9236.2	9246.37	7872.0
2019-10-17 05:00:00	NQ	Futures	9246.37	9287.91	9236.49	9279.2	20767.0
2019-10-17 06:00:00	NQ	Futures	9279.49	9289.65	9267.29	9270.19	10297.0
2019-10-17 07:00:00	NQ	Futures	9270.19	9282.68	9259.15	9271.93	12065.0
2019-10-17 08:00:00	NQ	Futures	9272.22	9280.07	9260.02	9276.58	12787.0
2019-10-17 09:00:00	NQ	Futures	9276.29	9286.75	9257.41	9277.74	48921.0
2019-10-17 10:00:00	NQ	Futures	9277.45	9279.2	9223.71	9232.72	60121.0
2019-10-17 11:00:00	NQ	Futures	9232.72	9244.63	9210.35	9222.26	51870.0
2019-10-17 12:00:00	NQ	Futures	9222.55	9237.66	9205.12	9237.36	24714.0
2019-10-17 13:00:00	NQ	Futures	9237.07	9245.79	9227.2	9242.59	19977.0
2019-10-17 14:00:00	NQ	Futures	9242.59	9250.73	9227.2	9246.08	22386.0
2019-10-17 15:00:00	NQ	Futures	9246.66	9253.05	9235.62	9242.3	34414.0
2019-10-17 16:00:00	NQ	Futures	9241.43	9245.5	9236.2	9242.01	6524.0
2019-10-17 18:00:00	NQ	Futures	9242.01	9242.01	9229.81	9236.49	2346.0
2019-10-17 19:00:00	NQ	Futures	9236.49	9237.95	9232.72	9235.04	1317.0
2019-10-17 20:00:00	NQ	Futures	9235.62	9241.43	9226.04	9232.14	3125.0
2019-10-17 21:00:00	NQ	Futures	9231.85	9236.49	9224.58	9226.33	3954.0
2019-10-17 22:00:00	NQ	Futures	9226.33	9242.88	9219.64	9223.13	7088.0
2019-10-17 23:00:00	NQ	Futures	9223.13	9228.65	9215.58	9221.97	3423.0
2019-10-17 00:00:00	YM	Futures	29298.4	29306.1	29294.1	29298.4	598.0
2019-10-17 01:00:00	YM	Futures	29300.6	29300.6	29261.4	29262.5	1237.0
2019-10-17 02:00:00	YM	Futures	29263.6	29276.7	29251.6	29259.3	1963.0
2019-10-17 03:00:00	YM	Futures	29260.4	29330.0	29258.2	29316.9	4667.0

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

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