PREVIEW / futures_1hour / 2019-10-24

all futures 1-hour files

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

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-24 00:00:00	ES	Futures	3265.82	3266.36	3264.73	3265.0	1417.0
2019-10-24 01:00:00	ES	Futures	3265.0	3265.82	3263.1	3264.73	4812.0
2019-10-24 02:00:00	ES	Futures	3264.73	3268.81	3264.19	3268.54	8504.0
2019-10-24 03:00:00	ES	Futures	3268.54	3272.88	3266.09	3269.08	32084.0
2019-10-24 04:00:00	ES	Futures	3269.08	3269.08	3262.83	3268.26	17735.0
2019-10-24 05:00:00	ES	Futures	3268.26	3269.89	3267.45	3269.08	8940.0
2019-10-24 06:00:00	ES	Futures	3269.08	3270.44	3268.26	3269.89	9818.0
2019-10-24 07:00:00	ES	Futures	3269.89	3272.88	3268.81	3272.88	17172.0
2019-10-24 08:00:00	ES	Futures	3272.88	3273.7	3269.89	3272.07	21139.0
2019-10-24 09:00:00	ES	Futures	3272.34	3276.14	3262.29	3263.1	155429.0
2019-10-24 10:00:00	ES	Futures	3263.1	3265.0	3258.21	3263.65	169097.0
2019-10-24 11:00:00	ES	Futures	3263.37	3272.34	3263.37	3270.44	133934.0
2019-10-24 12:00:00	ES	Futures	3270.44	3272.34	3259.3	3265.82	132554.0
2019-10-24 13:00:00	ES	Futures	3265.82	3266.09	3259.84	3261.74	65194.0
2019-10-24 14:00:00	ES	Futures	3261.47	3266.91	3260.66	3265.82	45011.0
2019-10-24 15:00:00	ES	Futures	3265.82	3271.52	3265.55	3268.81	112448.0
2019-10-24 16:00:00	ES	Futures	3269.08	3271.25	3261.74	3262.56	68362.0
2019-10-24 18:00:00	ES	Futures	3263.65	3264.46	3261.74	3263.1	4993.0
2019-10-24 19:00:00	ES	Futures	3263.1	3263.92	3259.57	3261.47	3973.0
2019-10-24 20:00:00	ES	Futures	3261.47	3266.09	3260.66	3264.46	9008.0
2019-10-24 21:00:00	ES	Futures	3264.46	3265.82	3260.66	3262.56	8266.0
2019-10-24 22:00:00	ES	Futures	3262.56	3264.73	3261.47	3263.92	5393.0
2019-10-24 23:00:00	ES	Futures	3263.92	3264.73	3263.1	3264.73	2299.0
2019-10-24 00:00:00	NQ	Futures	9202.22	9205.12	9200.47	9200.47	631.0
2019-10-24 01:00:00	NQ	Futures	9200.76	9205.41	9194.95	9201.05	2120.0
2019-10-24 02:00:00	NQ	Futures	9201.05	9216.16	9199.89	9215.0	3427.0
2019-10-24 03:00:00	NQ	Futures	9214.71	9226.62	9205.41	9213.83	12299.0
2019-10-24 04:00:00	NQ	Futures	9213.83	9216.16	9198.73	9214.71	7528.0
2019-10-24 05:00:00	NQ	Futures	9214.71	9219.35	9211.51	9217.32	3002.0
2019-10-24 06:00:00	NQ	Futures	9217.32	9224.29	9215.29	9221.97	3334.0
2019-10-24 07:00:00	NQ	Futures	9222.26	9237.36	9218.19	9237.07	8057.0
2019-10-24 08:00:00	NQ	Futures	9237.07	9240.56	9227.49	9234.17	9939.0
2019-10-24 09:00:00	NQ	Futures	9234.17	9250.73	9211.22	9216.16	61411.0
2019-10-24 10:00:00	NQ	Futures	9216.16	9230.1	9199.02	9227.78	54077.0
2019-10-24 11:00:00	NQ	Futures	9227.78	9266.7	9227.78	9262.93	53287.0
2019-10-24 12:00:00	NQ	Futures	9262.93	9270.19	9226.04	9251.89	48042.0
2019-10-24 13:00:00	NQ	Futures	9251.89	9253.34	9233.01	9237.36	21531.0
2019-10-24 14:00:00	NQ	Futures	9237.07	9255.67	9234.46	9249.57	16898.0
2019-10-24 15:00:00	NQ	Futures	9249.28	9266.7	9248.4	9264.38	26936.0
2019-10-24 16:00:00	NQ	Futures	9264.67	9277.16	9205.12	9208.03	27531.0
2019-10-24 18:00:00	NQ	Futures	9212.67	9216.45	9209.19	9212.38	2933.0
2019-10-24 19:00:00	NQ	Futures	9211.8	9216.16	9201.05	9207.73	2571.0
2019-10-24 20:00:00	NQ	Futures	9207.44	9224.29	9204.83	9219.06	3854.0
2019-10-24 21:00:00	NQ	Futures	9219.35	9223.42	9206.57	9211.8	3520.0
2019-10-24 22:00:00	NQ	Futures	9212.09	9220.23	9210.64	9218.77	2267.0
2019-10-24 23:00:00	NQ	Futures	9218.48	9220.23	9215.58	9219.35	1133.0
2019-10-24 00:00:00	YM	Futures	29167.8	29172.2	29160.2	29160.2	334.0
2019-10-24 01:00:00	YM	Futures	29160.2	29167.8	29147.2	29159.1	869.0
2019-10-24 02:00:00	YM	Futures	29159.1	29189.6	29158.0	29186.3	2476.0
2019-10-24 03:00:00	YM	Futures	29186.3	29221.2	29166.8	29196.1	5862.0

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

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