PREVIEW / futures_1hour / 2020-05-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-06.parquet
  size:    62 KB
  rows:    1,856

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-05-06 00:00:00	ES	Futures	3139.85	3141.49	3134.09	3138.75	4598.0
2020-05-06 01:00:00	ES	Futures	3139.03	3156.31	3138.48	3153.57	14239.0
2020-05-06 02:00:00	ES	Futures	3153.84	3167.56	3148.9	3162.08	19947.0
2020-05-06 03:00:00	ES	Futures	3162.08	3164.55	3150.83	3155.49	26183.0
2020-05-06 04:00:00	ES	Futures	3155.49	3161.25	3151.37	3158.23	27357.0
2020-05-06 05:00:00	ES	Futures	3158.23	3166.47	3155.49	3164.55	19964.0
2020-05-06 06:00:00	ES	Futures	3164.82	3168.11	3162.35	3165.09	17037.0
2020-05-06 07:00:00	ES	Futures	3165.09	3165.92	3155.22	3155.49	18447.0
2020-05-06 08:00:00	ES	Futures	3155.49	3158.51	3145.06	3152.75	46358.0
2020-05-06 09:00:00	ES	Futures	3152.75	3163.17	3133.54	3139.03	173211.0
2020-05-06 10:00:00	ES	Futures	3139.3	3156.04	3125.3	3148.36	212937.0
2020-05-06 11:00:00	ES	Futures	3148.36	3153.02	3130.24	3136.56	155242.0
2020-05-06 12:00:00	ES	Futures	3136.56	3146.98	3133.81	3142.59	98512.0
2020-05-06 13:00:00	ES	Futures	3142.59	3151.37	3134.91	3146.43	90956.0
2020-05-06 14:00:00	ES	Futures	3146.16	3146.43	3132.44	3138.2	123143.0
2020-05-06 15:00:00	ES	Futures	3138.2	3142.04	3114.88	3117.35	241296.0
2020-05-06 16:00:00	ES	Futures	3117.07	3118.44	3108.57	3110.76	64864.0
2020-05-06 18:00:00	ES	Futures	3108.57	3115.7	3098.69	3102.53	18170.0
2020-05-06 19:00:00	ES	Futures	3102.8	3110.21	3101.16	3110.21	11302.0
2020-05-06 20:00:00	ES	Futures	3109.94	3120.91	3109.94	3118.72	23731.0
2020-05-06 21:00:00	ES	Futures	3118.72	3123.38	3115.7	3117.07	12916.0
2020-05-06 22:00:00	ES	Futures	3117.35	3122.29	3114.05	3121.19	8580.0
2020-05-06 23:00:00	ES	Futures	3120.91	3129.97	3120.91	3128.32	13590.0
2020-05-06 00:00:00	NQ	Futures	10202.8	10211.65	10187.09	10204.8	2576.0
2020-05-06 01:00:00	NQ	Futures	10205.08	10259.64	10201.94	10249.64	6665.0
2020-05-06 02:00:00	NQ	Futures	10250.21	10293.92	10238.5	10279.92	8756.0
2020-05-06 03:00:00	NQ	Futures	10280.49	10283.06	10248.79	10257.07	7739.0
2020-05-06 04:00:00	NQ	Futures	10256.78	10275.07	10248.79	10264.78	6148.0
2020-05-06 05:00:00	NQ	Futures	10264.5	10289.63	10257.07	10284.49	5908.0
2020-05-06 06:00:00	NQ	Futures	10284.78	10294.49	10275.35	10279.35	4795.0
2020-05-06 07:00:00	NQ	Futures	10279.35	10283.06	10262.5	10265.07	6341.0
2020-05-06 08:00:00	NQ	Futures	10264.5	10273.64	10233.93	10258.21	13452.0
2020-05-06 09:00:00	NQ	Futures	10257.64	10316.2	10247.64	10268.21	53072.0
2020-05-06 10:00:00	NQ	Futures	10268.5	10335.91	10209.37	10314.77	69438.0
2020-05-06 11:00:00	NQ	Futures	10315.34	10332.19	10272.78	10296.2	45483.0
2020-05-06 12:00:00	NQ	Futures	10295.63	10331.62	10285.63	10315.63	28565.0
2020-05-06 13:00:00	NQ	Futures	10315.91	10347.62	10297.35	10331.05	27343.0
2020-05-06 14:00:00	NQ	Futures	10330.48	10331.62	10292.2	10302.77	31622.0
2020-05-06 15:00:00	NQ	Futures	10302.49	10321.62	10236.22	10250.79	49223.0
2020-05-06 16:00:00	NQ	Futures	10250.79	10252.21	10215.65	10221.65	11288.0
2020-05-06 18:00:00	NQ	Futures	10223.08	10247.07	10203.37	10216.79	4465.0
2020-05-06 19:00:00	NQ	Futures	10216.79	10243.64	10209.65	10243.64	3387.0
2020-05-06 20:00:00	NQ	Futures	10243.07	10277.64	10243.07	10271.07	6638.0
2020-05-06 21:00:00	NQ	Futures	10271.07	10290.78	10258.5	10270.49	5904.0
2020-05-06 22:00:00	NQ	Futures	10271.35	10284.78	10253.64	10283.92	4221.0
2020-05-06 23:00:00	NQ	Futures	10283.35	10315.63	10281.35	10309.06	5078.0
2020-05-06 00:00:00	YM	Futures	26047.7	26059.8	26000.6	26041.2	1347.0
2020-05-06 01:00:00	YM	Futures	26043.4	26185.8	26039.0	26167.1	4056.0
2020-05-06 02:00:00	YM	Futures	26167.1	26267.9	26125.5	26224.1	4832.0
2020-05-06 03:00:00	YM	Futures	26221.9	26253.7	26145.2	26170.4	5160.0

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

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