PREVIEW / futures_1hour / 2020-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-03.parquet
  size:    66 KB
  rows:    1,913

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-03-03 00:00:00	ES	Futures	3322.9	3329.1	3310.7	3311.0	21149.0
2020-03-03 01:00:00	ES	Futures	3311.2	3328.8	3301.2	3327.8	28388.0
2020-03-03 02:00:00	ES	Futures	3327.5	3335.9	3317.2	3332.1	37379.0
2020-03-03 03:00:00	ES	Futures	3331.8	3360.0	3315.3	3345.1	81522.0
2020-03-03 04:00:00	ES	Futures	3345.1	3359.7	3337.0	3357.0	50634.0
2020-03-03 05:00:00	ES	Futures	3357.3	3360.3	3348.9	3354.6	45581.0
2020-03-03 06:00:00	ES	Futures	3354.6	3354.9	3331.3	3334.3	54679.0
2020-03-03 07:00:00	ES	Futures	3334.5	3356.8	3307.2	3323.7	128654.0
2020-03-03 08:00:00	ES	Futures	3323.7	3341.9	3307.2	3333.5	122347.0
2020-03-03 09:00:00	ES	Futures	3333.2	3355.9	3302.6	3314.5	303366.0
2020-03-03 10:00:00	ES	Futures	3314.2	3400.4	3313.1	3362.4	596457.0
2020-03-03 11:00:00	ES	Futures	3362.4	3365.7	3277.4	3328.8	432042.0
2020-03-03 12:00:00	ES	Futures	3328.8	3339.7	3298.8	3305.0	214463.0
2020-03-03 13:00:00	ES	Futures	3305.0	3305.0	3249.4	3251.3	283435.0
2020-03-03 14:00:00	ES	Futures	3251.3	3269.5	3222.6	3263.8	383412.0
2020-03-03 15:00:00	ES	Futures	3264.1	3294.7	3241.3	3252.2	503199.0
2020-03-03 16:00:00	ES	Futures	3252.2	3271.7	3240.2	3240.5	110702.0
2020-03-03 18:00:00	ES	Futures	3239.1	3247.5	3226.4	3241.9	31634.0
2020-03-03 19:00:00	ES	Futures	3241.9	3276.5	3240.2	3272.2	49780.0
2020-03-03 20:00:00	ES	Futures	3272.2	3280.6	3263.3	3269.0	33153.0
2020-03-03 21:00:00	ES	Futures	3268.7	3285.5	3264.1	3284.9	27156.0
2020-03-03 22:00:00	ES	Futures	3284.9	3293.1	3282.0	3287.7	30416.0
2020-03-03 23:00:00	ES	Futures	3287.4	3288.2	3278.2	3286.6	22627.0
2020-03-03 00:00:00	NQ	Futures	10166.18	10191.62	10127.43	10130.03	11991.0
2020-03-03 01:00:00	NQ	Futures	10130.61	10195.38	10107.76	10190.18	16258.0
2020-03-03 02:00:00	NQ	Futures	10190.76	10215.33	10160.1	10206.95	18681.0
2020-03-03 03:00:00	NQ	Futures	10205.79	10300.35	10155.48	10254.08	39335.0
2020-03-03 04:00:00	NQ	Futures	10254.37	10302.38	10232.97	10291.1	26295.0
2020-03-03 05:00:00	NQ	Futures	10291.68	10306.71	10267.39	10296.3	21361.0
2020-03-03 06:00:00	NQ	Futures	10296.59	10297.75	10221.12	10236.44	27145.0
2020-03-03 07:00:00	NQ	Futures	10237.02	10314.81	10169.36	10213.89	49897.0
2020-03-03 08:00:00	NQ	Futures	10213.89	10278.66	10161.84	10237.6	48943.0
2020-03-03 09:00:00	NQ	Futures	10237.02	10305.85	10114.99	10155.77	122425.0
2020-03-03 10:00:00	NQ	Futures	10156.05	10413.13	10150.56	10328.98	192492.0
2020-03-03 11:00:00	NQ	Futures	10328.98	10338.52	10069.01	10217.36	133295.0
2020-03-03 12:00:00	NQ	Futures	10217.94	10252.06	10117.59	10137.55	78149.0
2020-03-03 13:00:00	NQ	Futures	10136.68	10137.55	9930.21	9936.28	111756.0
2020-03-03 14:00:00	NQ	Futures	9936.28	9985.73	9844.61	9967.8	126261.0
2020-03-03 15:00:00	NQ	Futures	9968.96	10068.43	9902.16	9943.8	132185.0
2020-03-03 16:00:00	NQ	Futures	9942.64	10010.02	9896.67	9900.14	20754.0
2020-03-03 18:00:00	NQ	Futures	9898.4	9922.11	9841.43	9904.47	13453.0
2020-03-03 19:00:00	NQ	Futures	9903.32	10021.01	9897.53	10003.66	31506.0
2020-03-03 20:00:00	NQ	Futures	10003.95	10033.16	9981.1	9996.72	19153.0
2020-03-03 21:00:00	NQ	Futures	9995.85	10054.84	9975.03	10049.06	17949.0
2020-03-03 22:00:00	NQ	Futures	10049.64	10079.71	10040.1	10059.18	17900.0
2020-03-03 23:00:00	NQ	Futures	10058.89	10062.36	10025.64	10056.0	13970.0
2020-03-03 00:00:00	YM	Futures	28837.5	28893.0	28737.4	28740.6	4501.0
2020-03-03 01:00:00	YM	Futures	28741.7	28889.8	28637.2	28876.7	8079.0
2020-03-03 02:00:00	YM	Futures	28874.5	28966.0	28790.7	28938.8	9863.0
2020-03-03 03:00:00	YM	Futures	28935.5	29163.1	28783.1	29045.5	20487.0

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

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