PREVIEW / futures_1hour / 2020-03-02

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-02.parquet
  size:    67 KB
  rows:    1,941

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-02 00:00:00	ES	Futures	3213.4	3221.5	3209.3	3219.1	15735.0
2020-03-02 01:00:00	ES	Futures	3218.8	3219.1	3206.6	3215.6	18856.0
2020-03-02 02:00:00	ES	Futures	3215.6	3261.1	3210.2	3257.3	66761.0
2020-03-02 03:00:00	ES	Futures	3257.3	3274.6	3246.2	3248.6	100143.0
2020-03-02 04:00:00	ES	Futures	3248.1	3256.5	3207.7	3222.9	86664.0
2020-03-02 05:00:00	ES	Futures	3222.6	3227.8	3206.1	3206.4	49885.0
2020-03-02 06:00:00	ES	Futures	3206.1	3207.7	3147.6	3153.0	93016.0
2020-03-02 07:00:00	ES	Futures	3153.0	3194.2	3150.8	3188.5	95603.0
2020-03-02 08:00:00	ES	Futures	3188.5	3210.4	3167.6	3208.5	117037.0
2020-03-02 09:00:00	ES	Futures	3208.8	3240.2	3205.0	3211.8	378631.0
2020-03-02 10:00:00	ES	Futures	3211.8	3250.8	3189.6	3233.5	384628.0
2020-03-02 11:00:00	ES	Futures	3233.5	3292.3	3229.7	3289.0	389584.0
2020-03-02 12:00:00	ES	Futures	3288.7	3294.2	3265.7	3289.3	229716.0
2020-03-02 13:00:00	ES	Futures	3289.3	3293.3	3258.4	3277.6	183363.0
2020-03-02 14:00:00	ES	Futures	3277.4	3287.1	3238.6	3250.5	236744.0
2020-03-02 15:00:00	ES	Futures	3250.5	3350.3	3248.9	3348.9	526914.0
2020-03-02 16:00:00	ES	Futures	3348.9	3353.0	3319.1	3329.7	187848.0
2020-03-02 18:00:00	ES	Futures	3335.3	3343.7	3325.1	3343.5	30572.0
2020-03-02 19:00:00	ES	Futures	3343.5	3355.4	3341.9	3352.7	41841.0
2020-03-02 20:00:00	ES	Futures	3352.7	3354.9	3331.6	3332.4	31396.0
2020-03-02 21:00:00	ES	Futures	3332.6	3340.2	3324.5	3331.0	28460.0
2020-03-02 22:00:00	ES	Futures	3331.0	3345.1	3330.2	3336.2	22620.0
2020-03-02 23:00:00	ES	Futures	3336.2	3336.7	3313.1	3322.9	37893.0
2020-03-02 00:00:00	NQ	Futures	9828.42	9861.97	9815.12	9846.64	14983.0
2020-03-02 01:00:00	NQ	Futures	9846.64	9847.8	9807.89	9839.7	15502.0
2020-03-02 02:00:00	NQ	Futures	9840.28	9980.82	9826.4	9971.56	35118.0
2020-03-02 03:00:00	NQ	Futures	9970.69	10036.92	9936.86	9949.87	49560.0
2020-03-02 04:00:00	NQ	Futures	9949.01	9988.62	9837.96	9880.76	44685.0
2020-03-02 05:00:00	NQ	Futures	9880.18	9899.85	9829.0	9834.2	25979.0
2020-03-02 06:00:00	NQ	Futures	9834.78	9836.52	9674.0	9694.24	42012.0
2020-03-02 07:00:00	NQ	Futures	9695.11	9790.25	9689.62	9775.5	40752.0
2020-03-02 08:00:00	NQ	Futures	9775.5	9851.84	9720.85	9842.88	48620.0
2020-03-02 09:00:00	NQ	Futures	9843.46	9942.93	9814.54	9848.95	127704.0
2020-03-02 10:00:00	NQ	Futures	9848.37	9944.67	9765.96	9897.82	162560.0
2020-03-02 11:00:00	NQ	Futures	9897.24	10098.51	9892.91	10091.57	129152.0
2020-03-02 12:00:00	NQ	Futures	10091.86	10105.16	10010.6	10093.88	85170.0
2020-03-02 13:00:00	NQ	Futures	10094.17	10104.0	9984.29	10038.07	80434.0
2020-03-02 14:00:00	NQ	Futures	10037.49	10070.17	9916.62	9960.86	90775.0
2020-03-02 15:00:00	NQ	Futures	9959.99	10271.15	9955.08	10267.1	132237.0
2020-03-02 16:00:00	NQ	Futures	10266.23	10275.19	10157.5	10202.03	36241.0
2020-03-02 18:00:00	NQ	Futures	10214.18	10248.3	10178.9	10248.01	13080.0
2020-03-02 19:00:00	NQ	Futures	10246.85	10285.03	10241.36	10274.33	19745.0
2020-03-02 20:00:00	NQ	Futures	10274.04	10281.27	10195.38	10200.01	19231.0
2020-03-02 21:00:00	NQ	Futures	10200.01	10225.17	10166.75	10203.77	19340.0
2020-03-02 22:00:00	NQ	Futures	10203.77	10248.88	10200.01	10215.91	10986.0
2020-03-02 23:00:00	NQ	Futures	10216.2	10216.78	10138.13	10165.6	18525.0
2020-03-02 00:00:00	YM	Futures	27781.4	27856.6	27744.4	27848.9	4583.0
2020-03-02 01:00:00	YM	Futures	27846.8	27853.3	27741.2	27828.3	4636.0
2020-03-02 02:00:00	YM	Futures	27829.3	28225.6	27781.4	28177.7	16656.0
2020-03-02 03:00:00	YM	Futures	28174.5	28307.3	28060.2	28095.0	28330.0

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

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