PREVIEW / futures_1hour / 2020-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-05-29.parquet
  size:    51 KB
  rows:    1,509

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-29 00:00:00	ES	Futures	3322.33	3328.1	3315.47	3327.82	8917.0
2020-05-29 01:00:00	ES	Futures	3327.82	3331.66	3323.98	3323.98	12970.0
2020-05-29 02:00:00	ES	Futures	3324.53	3331.12	3313.55	3320.69	26915.0
2020-05-29 03:00:00	ES	Futures	3320.96	3328.1	3309.44	3313.55	43461.0
2020-05-29 04:00:00	ES	Futures	3313.83	3317.67	3307.79	3314.65	36186.0
2020-05-29 05:00:00	ES	Futures	3314.92	3326.45	3311.91	3325.9	28927.0
2020-05-29 06:00:00	ES	Futures	3325.9	3329.74	3323.43	3327.0	23349.0
2020-05-29 07:00:00	ES	Futures	3327.27	3331.66	3323.71	3327.0	27504.0
2020-05-29 08:00:00	ES	Futures	3327.0	3330.84	3316.02	3318.77	54244.0
2020-05-29 09:00:00	ES	Futures	3318.49	3324.25	3309.16	3313.83	205986.0
2020-05-29 10:00:00	ES	Futures	3313.83	3317.94	3296.54	3300.66	251808.0
2020-05-29 11:00:00	ES	Futures	3300.66	3312.18	3294.89	3308.06	192853.0
2020-05-29 12:00:00	ES	Futures	3308.06	3314.38	3284.19	3307.79	178376.0
2020-05-29 13:00:00	ES	Futures	3307.52	3309.99	3297.36	3302.03	121970.0
2020-05-29 14:00:00	ES	Futures	3302.03	3329.47	3290.23	3328.37	305149.0
2020-05-29 15:00:00	ES	Futures	3328.65	3343.74	3323.98	3334.96	455010.0
2020-05-29 16:00:00	ES	Futures	3335.23	3356.91	3333.31	3355.81	127006.0
2020-05-29 00:00:00	NQ	Futures	10780.93	10801.22	10764.08	10800.07	2813.0
2020-05-29 01:00:00	NQ	Futures	10801.22	10812.07	10780.65	10780.65	4993.0
2020-05-29 02:00:00	NQ	Futures	10781.51	10797.79	10746.37	10768.37	7617.0
2020-05-29 03:00:00	NQ	Futures	10768.37	10796.93	10735.23	10752.37	11006.0
2020-05-29 04:00:00	NQ	Futures	10752.66	10756.37	10721.52	10746.94	9484.0
2020-05-29 05:00:00	NQ	Futures	10747.8	10773.79	10728.38	10773.22	8069.0
2020-05-29 06:00:00	NQ	Futures	10772.65	10791.5	10769.51	10786.36	6831.0
2020-05-29 07:00:00	NQ	Futures	10787.22	10830.06	10775.22	10821.5	9782.0
2020-05-29 08:00:00	NQ	Futures	10821.21	10844.06	10789.79	10806.93	15923.0
2020-05-29 09:00:00	NQ	Futures	10806.36	10834.92	10763.22	10806.07	57166.0
2020-05-29 10:00:00	NQ	Futures	10806.36	10814.64	10717.52	10751.51	73684.0
2020-05-29 11:00:00	NQ	Futures	10751.23	10801.5	10708.1	10791.5	55904.0
2020-05-29 12:00:00	NQ	Futures	10792.07	10812.36	10712.67	10792.65	43897.0
2020-05-29 13:00:00	NQ	Futures	10792.65	10810.07	10762.37	10783.51	34141.0
2020-05-29 14:00:00	NQ	Futures	10783.51	10852.63	10730.66	10851.49	67585.0
2020-05-29 15:00:00	NQ	Futures	10851.49	10936.04	10844.06	10903.47	69028.0
2020-05-29 16:00:00	NQ	Futures	10903.47	10957.75	10902.33	10953.46	16314.0
2020-05-29 00:00:00	YM	Futures	27753.2	27793.7	27698.4	27790.4	2291.0
2020-05-29 01:00:00	YM	Futures	27790.4	27832.0	27771.8	27772.9	3118.0
2020-05-29 02:00:00	YM	Futures	27771.8	27830.9	27686.3	27749.9	5174.0
2020-05-29 03:00:00	YM	Futures	27748.8	27807.9	27668.8	27698.4	9514.0
2020-05-29 04:00:00	YM	Futures	27698.4	27729.1	27641.4	27691.8	6977.0
2020-05-29 05:00:00	YM	Futures	27691.8	27783.8	27665.5	27778.3	4767.0
2020-05-29 06:00:00	YM	Futures	27779.4	27821.1	27754.3	27784.9	4776.0
2020-05-29 07:00:00	YM	Futures	27786.0	27813.4	27752.1	27772.9	3966.0
2020-05-29 08:00:00	YM	Futures	27770.7	27797.0	27661.1	27686.3	7617.0
2020-05-29 09:00:00	YM	Futures	27683.1	27752.1	27619.5	27657.9	25370.0
2020-05-29 10:00:00	YM	Futures	27659.0	27690.7	27524.2	27540.7	27283.0
2020-05-29 11:00:00	YM	Futures	27540.7	27610.8	27507.8	27574.6	21432.0
2020-05-29 12:00:00	YM	Futures	27575.7	27636.0	27373.1	27573.5	22954.0
2020-05-29 13:00:00	YM	Futures	27572.4	27591.0	27482.6	27514.4	14795.0
2020-05-29 14:00:00	YM	Futures	27515.5	27772.9	27427.8	27767.4	39779.0
2020-05-29 15:00:00	YM	Futures	27766.3	27885.7	27697.3	27755.3	43360.0

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

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