PREVIEW / futures_1hour / 2020-06-08

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-08.parquet
  size:    61 KB
  rows:    1,862

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
2020-06-08 00:00:00	ES	Futures	3505.37	3507.84	3504.0	3507.29	4968.0
2020-06-08 01:00:00	ES	Futures	3507.29	3508.39	3502.08	3508.39	8298.0
2020-06-08 02:00:00	ES	Futures	3508.39	3508.94	3499.33	3500.15	18408.0
2020-06-08 03:00:00	ES	Futures	3500.15	3504.0	3494.12	3497.14	42121.0
2020-06-08 04:00:00	ES	Futures	3497.14	3516.07	3496.86	3515.52	26324.0
2020-06-08 05:00:00	ES	Futures	3515.52	3520.19	3508.66	3510.86	31352.0
2020-06-08 06:00:00	ES	Futures	3510.86	3517.72	3507.56	3510.86	24108.0
2020-06-08 07:00:00	ES	Futures	3511.13	3521.01	3510.58	3518.27	32793.0
2020-06-08 08:00:00	ES	Futures	3518.27	3524.3	3514.42	3519.09	45242.0
2020-06-08 09:00:00	ES	Futures	3519.09	3524.58	3510.86	3518.27	210559.0
2020-06-08 10:00:00	ES	Futures	3518.27	3519.64	3505.37	3517.72	221109.0
2020-06-08 11:00:00	ES	Futures	3517.72	3524.58	3516.34	3518.81	151031.0
2020-06-08 12:00:00	ES	Futures	3519.09	3522.11	3514.7	3518.81	80273.0
2020-06-08 13:00:00	ES	Futures	3518.81	3530.61	3517.44	3528.97	117747.0
2020-06-08 14:00:00	ES	Futures	3528.97	3533.36	3527.32	3532.26	72343.0
2020-06-08 15:00:00	ES	Futures	3531.99	3546.8	3527.87	3545.16	223279.0
2020-06-08 16:00:00	ES	Futures	3545.16	3545.71	3538.3	3541.87	65561.0
2020-06-08 18:00:00	ES	Futures	3542.96	3544.06	3536.38	3537.2	10166.0
2020-06-08 19:00:00	ES	Futures	3536.93	3541.04	3536.1	3537.75	8031.0
2020-06-08 20:00:00	ES	Futures	3537.75	3544.34	3534.46	3536.93	20958.0
2020-06-08 21:00:00	ES	Futures	3536.93	3539.4	3531.16	3538.85	20120.0
2020-06-08 22:00:00	ES	Futures	3538.85	3541.04	3533.63	3537.47	10486.0
2020-06-08 23:00:00	ES	Futures	3537.47	3539.12	3534.73	3537.2	7185.0
2020-06-08 00:00:00	NQ	Futures	11242.24	11248.81	11236.25	11245.96	2780.0
2020-06-08 01:00:00	NQ	Futures	11245.1	11250.81	11229.68	11249.96	3132.0
2020-06-08 02:00:00	NQ	Futures	11249.67	11253.1	11223.11	11227.39	4958.0
2020-06-08 03:00:00	NQ	Futures	11227.68	11227.96	11193.11	11197.11	11721.0
2020-06-08 04:00:00	NQ	Futures	11197.4	11235.96	11195.68	11233.39	8016.0
2020-06-08 05:00:00	NQ	Futures	11234.25	11241.39	11208.82	11212.54	7015.0
2020-06-08 06:00:00	NQ	Futures	11211.11	11231.39	11201.68	11213.68	6043.0
2020-06-08 07:00:00	NQ	Futures	11213.97	11225.39	11198.26	11207.4	9483.0
2020-06-08 08:00:00	NQ	Futures	11206.25	11223.11	11180.26	11217.39	15483.0
2020-06-08 09:00:00	NQ	Futures	11217.68	11231.1	11161.98	11180.26	64884.0
2020-06-08 10:00:00	NQ	Futures	11180.26	11209.4	11136.56	11197.97	59660.0
2020-06-08 11:00:00	NQ	Futures	11198.54	11226.53	11194.54	11209.68	38083.0
2020-06-08 12:00:00	NQ	Futures	11209.68	11224.53	11190.26	11217.96	23505.0
2020-06-08 13:00:00	NQ	Futures	11217.96	11264.52	11208.25	11260.81	27307.0
2020-06-08 14:00:00	NQ	Futures	11260.81	11283.38	11256.24	11279.09	25255.0
2020-06-08 15:00:00	NQ	Futures	11278.81	11312.51	11261.38	11307.37	37476.0
2020-06-08 16:00:00	NQ	Futures	11307.08	11308.8	11283.09	11292.23	8523.0
2020-06-08 18:00:00	NQ	Futures	11296.8	11296.8	11280.52	11283.38	2114.0
2020-06-08 19:00:00	NQ	Futures	11282.81	11297.37	11282.81	11288.52	2246.0
2020-06-08 20:00:00	NQ	Futures	11288.23	11307.66	11280.52	11284.8	5344.0
2020-06-08 21:00:00	NQ	Futures	11284.23	11291.95	11264.52	11289.37	6320.0
2020-06-08 22:00:00	NQ	Futures	11289.95	11297.09	11274.81	11294.23	4290.0
2020-06-08 23:00:00	NQ	Futures	11294.8	11300.8	11286.8	11293.95	2762.0
2020-06-08 00:00:00	YM	Futures	29719.2	29736.8	29703.9	29735.7	1147.0
2020-06-08 01:00:00	YM	Futures	29733.5	29747.7	29685.3	29746.6	1751.0
2020-06-08 02:00:00	YM	Futures	29748.8	29756.5	29666.7	29673.2	3523.0
2020-06-08 03:00:00	YM	Futures	29674.3	29708.3	29607.5	29651.3	7636.0

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

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