PREVIEW / futures_1hour / 2020-06-12

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-12.parquet
  size:    51 KB
  rows:    1,476

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-06-12 00:00:00	ES	Futures	3341.27	3346.76	3338.25	3344.29	14001.0
2020-06-12 01:00:00	ES	Futures	3344.01	3351.42	3337.15	3350.6	17427.0
2020-06-12 02:00:00	ES	Futures	3350.32	3352.52	3322.88	3322.88	38230.0
2020-06-12 03:00:00	ES	Futures	3322.88	3354.99	3322.88	3339.62	51357.0
2020-06-12 04:00:00	ES	Futures	3339.62	3368.16	3339.35	3364.32	37084.0
2020-06-12 05:00:00	ES	Futures	3364.32	3371.73	3359.93	3371.18	28448.0
2020-06-12 06:00:00	ES	Futures	3371.18	3375.02	3354.44	3362.95	39918.0
2020-06-12 07:00:00	ES	Futures	3362.95	3371.73	3356.64	3356.64	41142.0
2020-06-12 08:00:00	ES	Futures	3356.64	3374.47	3348.68	3368.71	58529.0
2020-06-12 09:00:00	ES	Futures	3368.71	3389.29	3367.06	3373.38	158714.0
2020-06-12 10:00:00	ES	Futures	3373.38	3381.88	3318.77	3318.77	244516.0
2020-06-12 11:00:00	ES	Futures	3318.77	3347.31	3294.62	3346.76	304415.0
2020-06-12 12:00:00	ES	Futures	3346.76	3354.17	3317.67	3331.12	159085.0
2020-06-12 13:00:00	ES	Futures	3331.12	3333.59	3275.41	3276.23	206914.0
2020-06-12 14:00:00	ES	Futures	3276.51	3318.77	3273.21	3311.91	226825.0
2020-06-12 15:00:00	ES	Futures	3312.18	3344.84	3300.66	3335.78	296431.0
2020-06-12 16:00:00	ES	Futures	3335.78	3340.99	3326.72	3332.21	69329.0
2020-06-12 00:00:00	NQ	Futures	11103.14	11129.42	11082.29	11107.14	4143.0
2020-06-12 01:00:00	NQ	Futures	11107.14	11119.13	11078.29	11115.99	3458.0
2020-06-12 02:00:00	NQ	Futures	11116.28	11126.27	11041.44	11041.44	7924.0
2020-06-12 03:00:00	NQ	Futures	11042.58	11133.42	11042.58	11098.85	12330.0
2020-06-12 04:00:00	NQ	Futures	11098.28	11170.83	11090.85	11159.69	8405.0
2020-06-12 05:00:00	NQ	Futures	11159.69	11184.54	11139.41	11182.83	6870.0
2020-06-12 06:00:00	NQ	Futures	11180.83	11192.54	11128.84	11150.55	6719.0
2020-06-12 07:00:00	NQ	Futures	11151.7	11175.69	11141.13	11141.41	7364.0
2020-06-12 08:00:00	NQ	Futures	11141.98	11159.41	11104.57	11145.98	10850.0
2020-06-12 09:00:00	NQ	Futures	11147.7	11253.38	11146.27	11209.97	41215.0
2020-06-12 10:00:00	NQ	Futures	11210.25	11230.82	11017.73	11019.73	54941.0
2020-06-12 11:00:00	NQ	Futures	11018.59	11104.57	10932.61	11102.28	64778.0
2020-06-12 12:00:00	NQ	Futures	11102.28	11125.42	11002.88	11049.15	37476.0
2020-06-12 13:00:00	NQ	Futures	11050.01	11056.86	10854.34	10856.92	42980.0
2020-06-12 14:00:00	NQ	Futures	10857.77	10983.17	10848.35	10974.03	46597.0
2020-06-12 15:00:00	NQ	Futures	10974.31	11066.58	10927.18	11037.15	44816.0
2020-06-12 16:00:00	NQ	Futures	11036.87	11048.87	11010.02	11020.02	8123.0
2020-06-12 00:00:00	YM	Futures	27917.2	27974.5	27894.1	27943.6	908.0
2020-06-12 01:00:00	YM	Futures	27940.3	28016.3	27880.9	28004.2	980.0
2020-06-12 02:00:00	YM	Futures	28003.1	28028.4	27713.5	27717.9	4091.0
2020-06-12 03:00:00	YM	Futures	27720.1	28049.3	27711.3	27919.4	5135.0
2020-06-12 04:00:00	YM	Futures	27919.4	28211.2	27911.7	28176.0	2551.0
2020-06-12 05:00:00	YM	Futures	28171.6	28233.2	28122.0	28223.3	1234.0
2020-06-12 06:00:00	YM	Futures	28222.2	28267.4	28053.7	28128.6	1673.0
2020-06-12 07:00:00	YM	Futures	28131.9	28220.0	28073.6	28074.7	2142.0
2020-06-12 08:00:00	YM	Futures	28075.8	28215.6	27975.6	28166.1	4014.0
2020-06-12 09:00:00	YM	Futures	28163.9	28427.0	28151.7	28302.6	20999.0
2020-06-12 10:00:00	YM	Futures	28310.3	28401.7	27759.7	27759.7	25957.0
2020-06-12 11:00:00	YM	Futures	27757.5	28059.2	27562.6	28053.7	29214.0
2020-06-12 12:00:00	YM	Futures	28053.7	28126.4	27798.3	27920.5	16410.0
2020-06-12 13:00:00	YM	Futures	27930.4	27948.0	27455.8	27478.9	16714.0
2020-06-12 14:00:00	YM	Futures	27481.2	27832.4	27456.9	27779.6	17167.0
2020-06-12 15:00:00	YM	Futures	27779.6	28084.6	27710.2	28028.4	21123.0

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

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