PREVIEW / futures_1hour / 2020-04-14

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-14.parquet
  size:    59 KB
  rows:    1,776

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-04-14 00:00:00	ES	Futures	3069.05	3081.12	3067.13	3079.48	10646.0
2020-04-14 01:00:00	ES	Futures	3079.75	3082.22	3066.85	3070.97	13589.0
2020-04-14 02:00:00	ES	Futures	3070.7	3076.73	3060.54	3075.64	19960.0
2020-04-14 03:00:00	ES	Futures	3075.91	3075.91	3056.15	3061.91	25525.0
2020-04-14 04:00:00	ES	Futures	3061.64	3063.84	3052.86	3055.88	14110.0
2020-04-14 05:00:00	ES	Futures	3056.15	3068.23	3055.05	3062.19	12491.0
2020-04-14 06:00:00	ES	Futures	3062.19	3065.48	3052.04	3058.07	15277.0
2020-04-14 07:00:00	ES	Futures	3058.35	3072.07	3053.68	3066.85	20203.0
2020-04-14 08:00:00	ES	Futures	3066.58	3079.75	3064.66	3076.18	53668.0
2020-04-14 09:00:00	ES	Futures	3076.18	3102.25	3069.32	3102.25	216303.0
2020-04-14 10:00:00	ES	Futures	3102.25	3113.23	3088.53	3088.81	241904.0
2020-04-14 11:00:00	ES	Futures	3088.81	3094.3	3071.52	3083.87	195044.0
2020-04-14 12:00:00	ES	Futures	3084.14	3107.74	3084.14	3103.35	158862.0
2020-04-14 13:00:00	ES	Futures	3103.63	3115.7	3096.49	3112.68	113026.0
2020-04-14 14:00:00	ES	Futures	3112.68	3118.72	3107.47	3114.6	114646.0
2020-04-14 15:00:00	ES	Futures	3114.88	3123.93	3099.24	3114.05	264181.0
2020-04-14 16:00:00	ES	Futures	3114.05	3122.29	3111.86	3122.29	64971.0
2020-04-14 18:00:00	ES	Futures	3121.46	3123.38	3113.78	3115.15	11570.0
2020-04-14 19:00:00	ES	Futures	3115.43	3117.9	3106.64	3108.57	10325.0
2020-04-14 20:00:00	ES	Futures	3108.57	3110.49	3098.96	3103.63	15959.0
2020-04-14 21:00:00	ES	Futures	3103.63	3105.27	3096.49	3105.27	15038.0
2020-04-14 22:00:00	ES	Futures	3105.27	3107.47	3094.84	3097.04	11339.0
2020-04-14 23:00:00	ES	Futures	3097.31	3106.92	3096.77	3103.35	7145.0
2020-04-14 00:00:00	NQ	Futures	9653.51	9693.5	9647.51	9687.5	4031.0
2020-04-14 01:00:00	NQ	Futures	9688.36	9698.07	9650.08	9658.08	5662.0
2020-04-14 02:00:00	NQ	Futures	9659.51	9678.36	9636.37	9676.65	5797.0
2020-04-14 03:00:00	NQ	Futures	9677.22	9679.79	9630.37	9638.94	6900.0
2020-04-14 04:00:00	NQ	Futures	9638.66	9651.23	9614.95	9626.95	5340.0
2020-04-14 05:00:00	NQ	Futures	9627.23	9660.65	9621.8	9650.08	3626.0
2020-04-14 06:00:00	NQ	Futures	9649.8	9659.8	9625.23	9638.09	4091.0
2020-04-14 07:00:00	NQ	Futures	9638.94	9678.08	9622.09	9668.94	7319.0
2020-04-14 08:00:00	NQ	Futures	9668.08	9702.64	9656.37	9695.79	14579.0
2020-04-14 09:00:00	NQ	Futures	9695.5	9818.33	9662.65	9814.33	61510.0
2020-04-14 10:00:00	NQ	Futures	9814.33	9837.18	9789.48	9804.33	62653.0
2020-04-14 11:00:00	NQ	Futures	9804.61	9825.18	9761.77	9806.61	54476.0
2020-04-14 12:00:00	NQ	Futures	9807.19	9897.16	9807.19	9885.45	41672.0
2020-04-14 13:00:00	NQ	Futures	9885.74	9929.15	9867.17	9922.3	27746.0
2020-04-14 14:00:00	NQ	Futures	9922.3	9937.44	9901.73	9926.58	27927.0
2020-04-14 15:00:00	NQ	Futures	9926.87	9951.72	9877.45	9919.73	50496.0
2020-04-14 16:00:00	NQ	Futures	9919.44	9945.44	9906.87	9944.01	10457.0
2020-04-14 18:00:00	NQ	Futures	9947.44	9948.86	9920.87	9928.01	3471.0
2020-04-14 19:00:00	NQ	Futures	9928.01	9935.44	9905.45	9910.3	2993.0
2020-04-14 20:00:00	NQ	Futures	9910.87	9919.44	9889.16	9902.02	4329.0
2020-04-14 21:00:00	NQ	Futures	9901.45	9904.59	9878.88	9901.45	4162.0
2020-04-14 22:00:00	NQ	Futures	9902.59	9909.16	9864.89	9874.31	3772.0
2020-04-14 23:00:00	NQ	Futures	9874.31	9896.02	9872.6	9889.16	3692.0
2020-04-14 00:00:00	YM	Futures	25872.5	25979.8	25856.1	25974.4	2983.0
2020-04-14 01:00:00	YM	Futures	25975.5	26001.7	25879.1	25913.0	3734.0
2020-04-14 02:00:00	YM	Futures	25910.8	25962.3	25819.9	25954.6	4091.0
2020-04-14 03:00:00	YM	Futures	25956.8	25962.3	25804.6	25841.8	5159.0

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

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