PREVIEW / futures_1hour / 2019-10-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-25.parquet
  size:    49 KB
  rows:    1,481

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-25 00:00:00	ES	Futures	3264.46	3265.0	3262.83	3264.73	2905.0
2019-10-25 01:00:00	ES	Futures	3264.73	3267.45	3263.92	3267.18	4849.0
2019-10-25 02:00:00	ES	Futures	3267.18	3268.26	3266.36	3267.72	6916.0
2019-10-25 03:00:00	ES	Futures	3267.45	3270.17	3264.46	3264.46	16099.0
2019-10-25 04:00:00	ES	Futures	3264.46	3267.18	3264.19	3265.55	10050.0
2019-10-25 05:00:00	ES	Futures	3265.28	3267.72	3264.46	3266.63	9552.0
2019-10-25 06:00:00	ES	Futures	3266.36	3268.54	3266.36	3268.54	6649.0
2019-10-25 07:00:00	ES	Futures	3268.26	3268.54	3265.55	3265.55	8127.0
2019-10-25 08:00:00	ES	Futures	3265.55	3266.09	3260.39	3262.29	19404.0
2019-10-25 09:00:00	ES	Futures	3262.02	3269.35	3259.57	3268.26	118092.0
2019-10-25 10:00:00	ES	Futures	3268.26	3279.4	3267.18	3278.86	174662.0
2019-10-25 11:00:00	ES	Futures	3278.86	3288.36	3277.23	3286.19	187234.0
2019-10-25 12:00:00	ES	Futures	3286.46	3287.01	3281.3	3283.48	82358.0
2019-10-25 13:00:00	ES	Futures	3283.75	3285.38	3281.85	3282.93	55103.0
2019-10-25 14:00:00	ES	Futures	3282.93	3284.29	3277.77	3282.39	80605.0
2019-10-25 15:00:00	ES	Futures	3282.39	3284.29	3280.22	3282.39	175181.0
2019-10-25 16:00:00	ES	Futures	3282.39	3282.66	3279.67	3281.03	67605.0
2019-10-25 00:00:00	NQ	Futures	9219.06	9220.23	9213.25	9219.64	1245.0
2019-10-25 01:00:00	NQ	Futures	9219.35	9227.49	9216.16	9226.62	2346.0
2019-10-25 02:00:00	NQ	Futures	9226.91	9229.81	9222.84	9227.2	3546.0
2019-10-25 03:00:00	NQ	Futures	9227.49	9233.59	9215.87	9216.16	6755.0
2019-10-25 04:00:00	NQ	Futures	9216.16	9224.87	9216.16	9221.1	3914.0
2019-10-25 05:00:00	NQ	Futures	9221.1	9228.94	9218.19	9223.71	4287.0
2019-10-25 06:00:00	NQ	Futures	9223.71	9231.56	9223.13	9230.1	2755.0
2019-10-25 07:00:00	NQ	Futures	9230.1	9230.68	9221.68	9221.97	3925.0
2019-10-25 08:00:00	NQ	Futures	9221.97	9222.84	9203.96	9212.09	8694.0
2019-10-25 09:00:00	NQ	Futures	9212.09	9262.06	9208.32	9254.5	50430.0
2019-10-25 10:00:00	NQ	Futures	9254.5	9305.63	9252.47	9302.73	65275.0
2019-10-25 11:00:00	NQ	Futures	9302.73	9341.94	9300.4	9332.94	59640.0
2019-10-25 12:00:00	NQ	Futures	9332.65	9335.84	9315.8	9324.8	27575.0
2019-10-25 13:00:00	NQ	Futures	9324.8	9335.26	9321.03	9326.55	17631.0
2019-10-25 14:00:00	NQ	Futures	9326.55	9331.77	9311.44	9324.8	22391.0
2019-10-25 15:00:00	NQ	Futures	9324.8	9343.98	9319.57	9337.29	35401.0
2019-10-25 16:00:00	NQ	Futures	9337.0	9342.81	9330.9	9338.17	11600.0
2019-10-25 00:00:00	YM	Futures	29126.5	29129.7	29112.3	29126.5	530.0
2019-10-25 01:00:00	YM	Futures	29127.6	29148.3	29118.9	29147.2	1203.0
2019-10-25 02:00:00	YM	Futures	29148.3	29159.1	29142.8	29154.8	1623.0
2019-10-25 03:00:00	YM	Futures	29155.9	29176.5	29122.1	29122.1	3569.0
2019-10-25 04:00:00	YM	Futures	29122.1	29147.2	29116.7	29129.7	2084.0
2019-10-25 05:00:00	YM	Futures	29129.7	29157.0	29126.5	29146.1	2216.0
2019-10-25 06:00:00	YM	Futures	29145.0	29159.1	29138.5	29159.1	1919.0
2019-10-25 07:00:00	YM	Futures	29158.0	29159.1	29122.1	29125.4	1934.0
2019-10-25 08:00:00	YM	Futures	29125.4	29130.8	29080.8	29096.0	3999.0
2019-10-25 09:00:00	YM	Futures	29096.0	29197.2	29069.9	29173.3	19996.0
2019-10-25 10:00:00	YM	Futures	29172.2	29274.5	29153.7	29265.8	20979.0
2019-10-25 11:00:00	YM	Futures	29268.0	29349.6	29245.1	29337.6	21454.0
2019-10-25 12:00:00	YM	Futures	29337.6	29345.2	29294.1	29310.4	8901.0
2019-10-25 13:00:00	YM	Futures	29310.4	29324.6	29296.3	29301.7	5166.0
2019-10-25 14:00:00	YM	Futures	29302.8	29310.4	29254.9	29291.9	9232.0
2019-10-25 15:00:00	YM	Futures	29291.9	29313.7	29272.3	29282.1	12788.0

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

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