PREVIEW / futures_1hour / 2020-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-30.parquet
  size:    60 KB
  rows:    1,818

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-30 00:00:00	ES	Futures	3410.12	3412.36	3409.56	3410.96	4423.0
2020-06-30 01:00:00	ES	Futures	3410.96	3414.59	3397.84	3397.84	17419.0
2020-06-30 02:00:00	ES	Futures	3397.56	3402.86	3391.13	3397.56	19273.0
2020-06-30 03:00:00	ES	Futures	3397.28	3406.77	3390.02	3395.04	31339.0
2020-06-30 04:00:00	ES	Futures	3395.04	3397.56	3386.11	3389.46	24466.0
2020-06-30 05:00:00	ES	Futures	3389.18	3399.23	3384.71	3398.11	31651.0
2020-06-30 06:00:00	ES	Futures	3397.84	3403.42	3396.16	3398.67	20218.0
2020-06-30 07:00:00	ES	Futures	3398.39	3412.64	3396.44	3402.3	31996.0
2020-06-30 08:00:00	ES	Futures	3402.3	3403.14	3390.3	3395.04	34588.0
2020-06-30 09:00:00	ES	Futures	3395.32	3409.84	3390.3	3402.86	171623.0
2020-06-30 10:00:00	ES	Futures	3403.14	3424.64	3402.3	3423.25	216247.0
2020-06-30 11:00:00	ES	Futures	3423.25	3431.9	3419.9	3426.04	137906.0
2020-06-30 12:00:00	ES	Futures	3426.04	3434.14	3419.34	3420.45	105947.0
2020-06-30 13:00:00	ES	Futures	3420.45	3424.08	3413.47	3422.69	86169.0
2020-06-30 14:00:00	ES	Futures	3422.69	3433.02	3417.1	3432.74	97476.0
2020-06-30 15:00:00	ES	Futures	3433.02	3464.02	3424.64	3443.63	450114.0
2020-06-30 16:00:00	ES	Futures	3445.31	3450.89	3440.84	3445.59	95482.0
2020-06-30 18:00:00	ES	Futures	3446.14	3449.5	3441.96	3442.51	11272.0
2020-06-30 19:00:00	ES	Futures	3442.79	3448.1	3440.0	3442.23	14154.0
2020-06-30 20:00:00	ES	Futures	3442.23	3447.82	3438.88	3444.75	13131.0
2020-06-30 21:00:00	ES	Futures	3445.03	3448.94	3441.4	3446.42	12455.0
2020-06-30 22:00:00	ES	Futures	3446.42	3447.82	3439.72	3442.79	7769.0
2020-06-30 23:00:00	ES	Futures	3442.79	3447.54	3441.96	3445.86	5181.0
2020-06-30 00:00:00	NQ	Futures	11576.97	11583.34	11576.97	11580.73	1328.0
2020-06-30 01:00:00	NQ	Futures	11581.31	11599.82	11541.98	11544.01	6614.0
2020-06-30 02:00:00	NQ	Futures	11543.72	11558.47	11526.37	11549.79	5916.0
2020-06-30 03:00:00	NQ	Futures	11550.37	11572.64	11517.4	11537.36	9736.0
2020-06-30 04:00:00	NQ	Futures	11536.49	11543.72	11513.07	11524.34	7173.0
2020-06-30 05:00:00	NQ	Futures	11522.9	11545.74	11510.46	11541.98	6725.0
2020-06-30 06:00:00	NQ	Futures	11542.27	11549.5	11525.21	11525.5	5434.0
2020-06-30 07:00:00	NQ	Futures	11525.21	11559.04	11520.29	11534.18	8170.0
2020-06-30 08:00:00	NQ	Futures	11534.46	11536.78	11498.03	11510.17	11315.0
2020-06-30 09:00:00	NQ	Futures	11510.46	11608.2	11498.32	11594.61	61671.0
2020-06-30 10:00:00	NQ	Futures	11594.32	11644.64	11589.12	11639.15	61354.0
2020-06-30 11:00:00	NQ	Futures	11639.44	11668.35	11635.1	11656.21	39043.0
2020-06-30 12:00:00	NQ	Futures	11655.92	11686.28	11632.21	11641.17	32259.0
2020-06-30 13:00:00	NQ	Futures	11642.04	11654.76	11612.25	11646.95	25816.0
2020-06-30 14:00:00	NQ	Futures	11647.53	11684.26	11627.29	11683.68	27441.0
2020-06-30 15:00:00	NQ	Futures	11683.68	11765.52	11652.45	11721.56	68211.0
2020-06-30 16:00:00	NQ	Futures	11721.85	11741.23	11709.71	11728.21	15286.0
2020-06-30 18:00:00	NQ	Futures	11730.24	11738.91	11716.94	11721.56	2641.0
2020-06-30 19:00:00	NQ	Futures	11721.85	11730.24	11710.0	11717.51	2221.0
2020-06-30 20:00:00	NQ	Futures	11717.51	11732.84	11707.68	11726.19	2315.0
2020-06-30 21:00:00	NQ	Futures	11726.48	11746.43	11715.78	11731.97	3535.0
2020-06-30 22:00:00	NQ	Futures	11730.82	11735.44	11713.75	11722.14	2082.0
2020-06-30 23:00:00	NQ	Futures	11720.98	11732.26	11718.96	11729.08	1515.0
2020-06-30 00:00:00	YM	Futures	28128.6	28156.1	28126.4	28145.1	1205.0
2020-06-30 01:00:00	YM	Futures	28141.8	28179.3	28004.2	28004.2	3982.0
2020-06-30 02:00:00	YM	Futures	28002.0	28054.8	27942.5	27996.5	3706.0
2020-06-30 03:00:00	YM	Futures	27994.3	28087.9	27937.0	27973.4	6331.0

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

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