PREVIEW / futures_1hour / 2020-05-20

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-20.parquet
  size:    61 KB
  rows:    1,854

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-20 00:00:00	ES	Futures	3222.17	3228.76	3219.98	3224.09	8867.0
2020-05-20 01:00:00	ES	Futures	3224.37	3227.66	3215.31	3217.51	10548.0
2020-05-20 02:00:00	ES	Futures	3217.51	3218.88	3210.65	3215.31	14399.0
2020-05-20 03:00:00	ES	Futures	3215.59	3226.29	3213.39	3216.96	30448.0
2020-05-20 04:00:00	ES	Futures	3216.96	3235.89	3216.68	3230.95	29213.0
2020-05-20 05:00:00	ES	Futures	3230.95	3242.21	3229.03	3240.83	26470.0
2020-05-20 06:00:00	ES	Futures	3240.56	3242.75	3236.17	3239.19	24724.0
2020-05-20 07:00:00	ES	Futures	3239.19	3241.66	3234.8	3239.74	25488.0
2020-05-20 08:00:00	ES	Futures	3239.74	3246.05	3237.81	3241.38	40477.0
2020-05-20 09:00:00	ES	Futures	3241.11	3254.0	3240.56	3252.08	170574.0
2020-05-20 10:00:00	ES	Futures	3252.08	3262.51	3250.71	3257.85	217048.0
2020-05-20 11:00:00	ES	Futures	3257.85	3266.35	3255.93	3263.06	121258.0
2020-05-20 12:00:00	ES	Futures	3263.06	3264.71	3246.32	3255.1	153439.0
2020-05-20 13:00:00	ES	Futures	3255.1	3256.47	3244.95	3251.26	105455.0
2020-05-20 14:00:00	ES	Futures	3251.26	3261.14	3243.58	3257.3	147101.0
2020-05-20 15:00:00	ES	Futures	3257.3	3260.04	3247.69	3255.93	236276.0
2020-05-20 16:00:00	ES	Futures	3255.93	3263.61	3255.65	3261.69	55396.0
2020-05-20 18:00:00	ES	Futures	3262.51	3263.88	3255.93	3256.47	11231.0
2020-05-20 19:00:00	ES	Futures	3256.75	3257.85	3253.46	3253.73	7050.0
2020-05-20 20:00:00	ES	Futures	3253.46	3254.0	3246.32	3252.36	14477.0
2020-05-20 21:00:00	ES	Futures	3252.08	3252.36	3239.19	3239.74	17703.0
2020-05-20 22:00:00	ES	Futures	3239.74	3242.21	3233.42	3240.01	15496.0
2020-05-20 23:00:00	ES	Futures	3240.28	3242.21	3235.62	3239.46	7680.0
2020-05-20 00:00:00	NQ	Futures	10676.1	10702.1	10666.96	10685.25	4109.0
2020-05-20 01:00:00	NQ	Futures	10685.82	10694.67	10663.82	10666.68	3487.0
2020-05-20 02:00:00	NQ	Futures	10666.96	10671.25	10650.97	10660.39	5890.0
2020-05-20 03:00:00	NQ	Futures	10661.25	10693.81	10654.68	10671.53	9766.0
2020-05-20 04:00:00	NQ	Futures	10671.53	10731.52	10669.82	10717.52	9396.0
2020-05-20 05:00:00	NQ	Futures	10717.52	10751.23	10711.52	10747.23	7858.0
2020-05-20 06:00:00	NQ	Futures	10746.66	10748.94	10728.95	10739.23	6718.0
2020-05-20 07:00:00	NQ	Futures	10738.95	10742.66	10723.81	10735.52	7016.0
2020-05-20 08:00:00	NQ	Futures	10735.52	10752.66	10729.52	10744.94	11103.0
2020-05-20 09:00:00	NQ	Futures	10744.94	10810.64	10736.95	10809.78	48131.0
2020-05-20 10:00:00	NQ	Futures	10809.78	10824.92	10791.5	10803.5	48724.0
2020-05-20 11:00:00	NQ	Futures	10803.5	10849.49	10802.07	10842.92	29228.0
2020-05-20 12:00:00	NQ	Futures	10842.92	10850.92	10774.36	10811.5	40113.0
2020-05-20 13:00:00	NQ	Futures	10811.5	10820.64	10779.22	10805.21	26903.0
2020-05-20 14:00:00	NQ	Futures	10805.21	10832.06	10775.51	10826.07	33137.0
2020-05-20 15:00:00	NQ	Futures	10826.64	10840.63	10797.5	10831.49	41224.0
2020-05-20 16:00:00	NQ	Futures	10832.06	10852.06	10829.49	10847.49	7622.0
2020-05-20 18:00:00	NQ	Futures	10848.35	10858.06	10833.78	10838.63	3121.0
2020-05-20 19:00:00	NQ	Futures	10839.21	10843.49	10831.78	10837.49	1863.0
2020-05-20 20:00:00	NQ	Futures	10838.06	10838.06	10809.5	10828.07	4836.0
2020-05-20 21:00:00	NQ	Futures	10827.78	10827.78	10788.65	10791.22	5196.0
2020-05-20 22:00:00	NQ	Futures	10791.22	10799.5	10769.79	10791.22	5659.0
2020-05-20 23:00:00	NQ	Futures	10791.79	10799.79	10775.79	10790.65	3058.0
2020-05-20 00:00:00	YM	Futures	26632.6	26689.6	26611.8	26658.9	1888.0
2020-05-20 01:00:00	YM	Futures	26658.9	26687.4	26570.2	26588.8	2286.0
2020-05-20 02:00:00	YM	Futures	26591.0	26598.7	26529.7	26565.8	3340.0
2020-05-20 03:00:00	YM	Futures	26568.0	26669.9	26550.5	26574.6	7501.0

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

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