PREVIEW / futures_1hour / 2019-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-21.parquet
  size:    58 KB
  rows:    1,849

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-21 00:00:00	ES	Futures	3254.68	3255.23	3253.87	3253.87	1793.0
2019-10-21 01:00:00	ES	Futures	3254.14	3254.41	3250.88	3251.15	4518.0
2019-10-21 02:00:00	ES	Futures	3251.15	3253.87	3250.61	3250.88	7322.0
2019-10-21 03:00:00	ES	Futures	3250.88	3256.86	3248.16	3253.32	22259.0
2019-10-21 04:00:00	ES	Futures	3253.6	3255.77	3251.69	3252.51	12854.0
2019-10-21 05:00:00	ES	Futures	3252.51	3255.5	3251.15	3254.14	11774.0
2019-10-21 06:00:00	ES	Futures	3254.14	3256.58	3252.51	3254.41	10398.0
2019-10-21 07:00:00	ES	Futures	3254.14	3256.04	3253.05	3256.04	8065.0
2019-10-21 08:00:00	ES	Futures	3255.77	3261.74	3255.23	3259.84	32995.0
2019-10-21 09:00:00	ES	Futures	3259.84	3263.65	3254.68	3256.04	145450.0
2019-10-21 10:00:00	ES	Futures	3256.04	3260.93	3253.6	3260.66	124573.0
2019-10-21 11:00:00	ES	Futures	3260.39	3263.1	3259.3	3261.2	87925.0
2019-10-21 12:00:00	ES	Futures	3261.2	3264.73	3258.76	3263.65	63788.0
2019-10-21 13:00:00	ES	Futures	3263.37	3264.19	3260.66	3262.02	40882.0
2019-10-21 14:00:00	ES	Futures	3261.74	3266.09	3261.74	3264.73	47273.0
2019-10-21 15:00:00	ES	Futures	3264.73	3267.72	3263.37	3265.82	131098.0
2019-10-21 16:00:00	ES	Futures	3265.82	3267.18	3264.73	3266.63	53624.0
2019-10-21 18:00:00	ES	Futures	3266.63	3267.18	3265.0	3265.55	2324.0
2019-10-21 19:00:00	ES	Futures	3265.55	3266.09	3265.0	3265.28	1544.0
2019-10-21 20:00:00	ES	Futures	3265.55	3274.24	3265.0	3272.07	11674.0
2019-10-21 21:00:00	ES	Futures	3272.07	3275.05	3270.98	3270.98	7471.0
2019-10-21 22:00:00	ES	Futures	3270.98	3272.61	3270.17	3271.52	3658.0
2019-10-21 23:00:00	ES	Futures	3271.52	3272.88	3270.71	3272.61	2226.0
2019-10-21 00:00:00	NQ	Futures	9185.37	9188.27	9182.17	9183.33	1772.0
2019-10-21 01:00:00	NQ	Futures	9183.91	9184.2	9173.17	9173.46	2697.0
2019-10-21 02:00:00	NQ	Futures	9173.46	9182.75	9170.55	9172.88	3489.0
2019-10-21 03:00:00	NQ	Futures	9172.59	9195.24	9163.58	9182.46	9566.0
2019-10-21 04:00:00	NQ	Futures	9183.33	9190.01	9174.91	9177.81	5902.0
2019-10-21 05:00:00	NQ	Futures	9177.81	9187.11	9174.33	9183.33	4484.0
2019-10-21 06:00:00	NQ	Futures	9183.62	9192.34	9178.69	9184.79	4242.0
2019-10-21 07:00:00	NQ	Futures	9184.79	9189.14	9178.69	9188.27	4455.0
2019-10-21 08:00:00	NQ	Futures	9187.98	9209.48	9186.24	9200.76	12216.0
2019-10-21 09:00:00	NQ	Futures	9200.47	9221.68	9183.33	9189.14	52848.0
2019-10-21 10:00:00	NQ	Futures	9188.85	9217.61	9172.0	9210.93	47152.0
2019-10-21 11:00:00	NQ	Futures	9211.22	9224.87	9207.15	9213.54	28966.0
2019-10-21 12:00:00	NQ	Futures	9213.54	9229.52	9209.19	9220.81	20435.0
2019-10-21 13:00:00	NQ	Futures	9221.1	9227.49	9217.61	9220.81	11935.0
2019-10-21 14:00:00	NQ	Futures	9221.1	9232.14	9220.23	9227.2	12716.0
2019-10-21 15:00:00	NQ	Futures	9227.49	9239.69	9223.71	9233.59	23721.0
2019-10-21 16:00:00	NQ	Futures	9233.88	9237.66	9228.94	9235.33	7622.0
2019-10-21 18:00:00	NQ	Futures	9236.78	9238.24	9230.68	9233.88	1297.0
2019-10-21 19:00:00	NQ	Futures	9233.88	9235.62	9231.26	9232.72	598.0
2019-10-21 20:00:00	NQ	Futures	9232.72	9268.74	9230.97	9259.73	5882.0
2019-10-21 21:00:00	NQ	Futures	9259.73	9271.64	9255.38	9255.96	4213.0
2019-10-21 22:00:00	NQ	Futures	9256.25	9260.89	9253.05	9256.54	2899.0
2019-10-21 23:00:00	NQ	Futures	9256.83	9259.44	9251.89	9258.28	1432.0
2019-10-21 00:00:00	YM	Futures	29182.0	29187.4	29172.2	29173.3	558.0
2019-10-21 01:00:00	YM	Futures	29174.4	29175.5	29153.7	29154.8	1226.0
2019-10-21 02:00:00	YM	Futures	29155.9	29183.1	29147.2	29153.7	2097.0
2019-10-21 03:00:00	YM	Futures	29152.6	29208.1	29128.7	29183.1	5470.0

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

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