PREVIEW / futures_1hour / 2020-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-04.parquet
  size:    62 KB
  rows:    1,877

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-03-04 00:00:00	ES	Futures	3286.3	3296.6	3282.8	3291.2	15715.0
2020-03-04 01:00:00	ES	Futures	3291.4	3297.4	3285.5	3288.5	17885.0
2020-03-04 02:00:00	ES	Futures	3288.2	3303.4	3287.7	3298.8	29810.0
2020-03-04 03:00:00	ES	Futures	3298.8	3306.1	3285.5	3304.5	56128.0
2020-03-04 04:00:00	ES	Futures	3304.5	3317.7	3299.8	3311.8	45722.0
2020-03-04 05:00:00	ES	Futures	3311.8	3318.3	3308.5	3310.7	25923.0
2020-03-04 06:00:00	ES	Futures	3310.4	3317.7	3305.0	3316.4	29148.0
2020-03-04 07:00:00	ES	Futures	3316.4	3332.1	3309.9	3316.9	71925.0
2020-03-04 08:00:00	ES	Futures	3317.2	3320.4	3299.0	3311.8	110231.0
2020-03-04 09:00:00	ES	Futures	3311.8	3328.0	3285.2	3295.0	285923.0
2020-03-04 10:00:00	ES	Futures	3295.2	3328.6	3286.8	3300.1	335534.0
2020-03-04 11:00:00	ES	Futures	3300.4	3318.8	3293.3	3303.4	225892.0
2020-03-04 12:00:00	ES	Futures	3303.4	3336.2	3303.4	3335.6	154740.0
2020-03-04 13:00:00	ES	Futures	3335.6	3352.4	3333.7	3347.3	168716.0
2020-03-04 14:00:00	ES	Futures	3347.3	3358.4	3338.6	3351.1	163550.0
2020-03-04 15:00:00	ES	Futures	3351.1	3391.7	3349.4	3389.5	385464.0
2020-03-04 16:00:00	ES	Futures	3389.8	3392.3	3367.1	3371.9	123098.0
2020-03-04 18:00:00	ES	Futures	3370.3	3375.2	3359.2	3367.6	26509.0
2020-03-04 19:00:00	ES	Futures	3368.1	3369.8	3356.8	3362.2	24024.0
2020-03-04 20:00:00	ES	Futures	3362.2	3364.6	3348.1	3351.3	24507.0
2020-03-04 21:00:00	ES	Futures	3351.6	3358.7	3347.0	3358.1	17696.0
2020-03-04 22:00:00	ES	Futures	3358.1	3359.5	3344.0	3344.3	24351.0
2020-03-04 23:00:00	ES	Futures	3344.0	3349.4	3344.0	3348.1	6762.0
2020-03-04 00:00:00	NQ	Futures	10056.0	10083.76	10042.7	10069.88	10810.0
2020-03-04 01:00:00	NQ	Futures	10070.17	10088.39	10048.48	10060.34	11677.0
2020-03-04 02:00:00	NQ	Futures	10059.76	10108.34	10058.31	10085.21	17441.0
2020-03-04 03:00:00	NQ	Futures	10085.21	10114.12	10043.28	10108.63	26542.0
2020-03-04 04:00:00	NQ	Futures	10108.34	10151.14	10093.01	10134.94	21762.0
2020-03-04 05:00:00	NQ	Futures	10134.08	10156.92	10121.93	10128.87	12646.0
2020-03-04 06:00:00	NQ	Futures	10128.0	10143.91	10111.52	10137.55	12035.0
2020-03-04 07:00:00	NQ	Futures	10137.84	10189.31	10113.26	10144.49	25408.0
2020-03-04 08:00:00	NQ	Futures	10145.07	10151.14	10087.52	10112.68	36545.0
2020-03-04 09:00:00	NQ	Futures	10112.68	10158.66	10023.03	10057.16	115824.0
2020-03-04 10:00:00	NQ	Futures	10057.16	10177.45	10040.1	10086.36	138951.0
2020-03-04 11:00:00	NQ	Futures	10086.07	10145.64	10062.65	10086.36	95527.0
2020-03-04 12:00:00	NQ	Futures	10086.65	10199.72	10086.65	10199.14	55803.0
2020-03-04 13:00:00	NQ	Futures	10198.85	10249.17	10195.09	10219.67	59320.0
2020-03-04 14:00:00	NQ	Futures	10220.25	10255.53	10189.02	10217.65	52398.0
2020-03-04 15:00:00	NQ	Futures	10217.36	10352.4	10210.71	10345.17	99661.0
2020-03-04 16:00:00	NQ	Futures	10345.75	10347.78	10269.12	10282.13	19796.0
2020-03-04 18:00:00	NQ	Futures	10281.84	10294.28	10246.85	10274.62	10349.0
2020-03-04 19:00:00	NQ	Futures	10275.19	10280.11	10239.91	10256.4	15375.0
2020-03-04 20:00:00	NQ	Futures	10256.98	10265.65	10210.13	10220.25	14955.0
2020-03-04 21:00:00	NQ	Futures	10220.25	10243.1	10204.06	10241.65	12273.0
2020-03-04 22:00:00	NQ	Futures	10241.94	10246.57	10197.7	10199.72	14928.0
2020-03-04 23:00:00	NQ	Futures	10199.72	10217.65	10199.43	10211.0	6072.0
2020-03-04 00:00:00	YM	Futures	28541.4	28630.7	28508.7	28588.2	3670.0
2020-03-04 01:00:00	YM	Futures	28587.1	28633.9	28533.8	28557.7	3632.0
2020-03-04 02:00:00	YM	Futures	28550.1	28685.1	28545.7	28635.0	6898.0
2020-03-04 03:00:00	YM	Futures	28633.9	28715.6	28521.8	28699.3	11835.0

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

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