PREVIEW / futures_1hour / 2019-09-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-23.parquet
  size:    59 KB
  rows:    1,836

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-09-23 00:00:00	ES	Futures	3260.93	3261.74	3259.57	3259.84	2375.0
2019-09-23 01:00:00	ES	Futures	3259.84	3262.56	3259.3	3262.02	3052.0
2019-09-23 02:00:00	ES	Futures	3262.29	3263.92	3260.39	3262.56	8021.0
2019-09-23 03:00:00	ES	Futures	3262.29	3265.82	3248.71	3249.52	40110.0
2019-09-23 04:00:00	ES	Futures	3249.25	3250.88	3240.01	3241.37	38978.0
2019-09-23 05:00:00	ES	Futures	3241.1	3249.52	3240.56	3248.16	31055.0
2019-09-23 06:00:00	ES	Futures	3247.89	3250.88	3246.81	3250.06	15732.0
2019-09-23 07:00:00	ES	Futures	3250.06	3250.61	3246.81	3247.08	11949.0
2019-09-23 08:00:00	ES	Futures	3247.08	3249.25	3244.63	3248.43	19309.0
2019-09-23 09:00:00	ES	Futures	3248.43	3253.87	3241.64	3250.06	161458.0
2019-09-23 10:00:00	ES	Futures	3250.34	3251.42	3243.55	3246.26	150967.0
2019-09-23 11:00:00	ES	Futures	3246.26	3256.04	3245.99	3254.41	112814.0
2019-09-23 12:00:00	ES	Futures	3254.41	3257.4	3252.78	3254.41	53358.0
2019-09-23 13:00:00	ES	Futures	3254.41	3258.21	3253.6	3257.67	50895.0
2019-09-23 14:00:00	ES	Futures	3257.67	3257.94	3254.95	3256.31	44705.0
2019-09-23 15:00:00	ES	Futures	3256.58	3260.39	3251.69	3252.51	161436.0
2019-09-23 16:00:00	ES	Futures	3252.78	3261.2	3251.69	3260.66	60996.0
2019-09-23 18:00:00	ES	Futures	3260.66	3263.1	3260.39	3262.83	6322.0
2019-09-23 19:00:00	ES	Futures	3262.83	3272.88	3262.83	3267.99	19471.0
2019-09-23 20:00:00	ES	Futures	3267.72	3270.44	3267.45	3267.45	12001.0
2019-09-23 21:00:00	ES	Futures	3267.45	3269.62	3263.65	3263.92	10623.0
2019-09-23 22:00:00	ES	Futures	3263.65	3267.45	3263.65	3266.36	6058.0
2019-09-23 23:00:00	ES	Futures	3266.36	3266.63	3264.19	3264.73	3554.0
2019-09-23 00:00:00	NQ	Futures	9141.5	9144.99	9137.73	9138.89	1307.0
2019-09-23 01:00:00	NQ	Futures	9139.47	9151.09	9137.73	9148.47	1731.0
2019-09-23 02:00:00	NQ	Futures	9148.76	9153.7	9141.79	9150.22	2950.0
2019-09-23 03:00:00	NQ	Futures	9149.64	9163.0	9102.87	9105.19	13332.0
2019-09-23 04:00:00	NQ	Futures	9105.19	9113.32	9079.63	9085.15	14342.0
2019-09-23 05:00:00	NQ	Futures	9084.57	9113.91	9082.82	9108.1	9329.0
2019-09-23 06:00:00	NQ	Futures	9107.81	9119.13	9105.48	9115.94	6167.0
2019-09-23 07:00:00	NQ	Futures	9115.65	9120.01	9105.19	9106.06	5269.0
2019-09-23 08:00:00	NQ	Futures	9106.06	9113.62	9095.02	9109.55	8835.0
2019-09-23 09:00:00	NQ	Futures	9109.55	9119.13	9085.15	9104.32	63074.0
2019-09-23 10:00:00	NQ	Futures	9104.61	9113.03	9072.37	9086.6	57541.0
2019-09-23 11:00:00	NQ	Futures	9086.02	9125.53	9083.98	9114.78	37753.0
2019-09-23 12:00:00	NQ	Futures	9114.78	9131.63	9111.0	9117.97	21095.0
2019-09-23 13:00:00	NQ	Futures	9117.68	9134.82	9113.91	9128.14	19505.0
2019-09-23 14:00:00	NQ	Futures	9128.43	9130.46	9117.1	9125.23	14486.0
2019-09-23 15:00:00	NQ	Futures	9125.23	9139.76	9108.1	9109.84	32093.0
2019-09-23 16:00:00	NQ	Futures	9109.84	9144.12	9108.68	9142.66	10380.0
2019-09-23 18:00:00	NQ	Futures	9143.54	9149.06	9139.18	9148.18	2906.0
2019-09-23 19:00:00	NQ	Futures	9148.47	9185.08	9147.6	9161.84	7388.0
2019-09-23 20:00:00	NQ	Futures	9162.42	9169.68	9158.93	9159.8	4606.0
2019-09-23 21:00:00	NQ	Futures	9159.22	9167.94	9145.28	9145.57	5227.0
2019-09-23 22:00:00	NQ	Futures	9146.15	9158.35	9145.86	9153.7	2920.0
2019-09-23 23:00:00	NQ	Futures	9154.28	9155.45	9147.89	9149.35	2040.0
2019-09-23 00:00:00	YM	Futures	29376.8	29384.4	29368.1	29370.3	627.0
2019-09-23 01:00:00	YM	Futures	29371.4	29387.7	29365.9	29384.4	986.0
2019-09-23 02:00:00	YM	Futures	29385.5	29401.8	29373.5	29388.8	2282.0
2019-09-23 03:00:00	YM	Futures	29388.8	29420.3	29269.1	29274.5	7785.0

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

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