PREVIEW / futures_1hour / 2021-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-01-21.parquet
  size:    62 KB
  rows:    1,945

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
2021-01-21 00:00:00	ES	Futures	4329.56	4332.37	4328.72	4330.96	5353.0
2021-01-21 01:00:00	ES	Futures	4330.96	4331.8	4325.35	4327.88	5196.0
2021-01-21 02:00:00	ES	Futures	4327.59	4330.68	4326.47	4329.56	4300.0
2021-01-21 03:00:00	ES	Futures	4329.56	4331.24	4319.74	4323.1	16882.0
2021-01-21 04:00:00	ES	Futures	4322.82	4325.63	4320.86	4323.39	11669.0
2021-01-21 05:00:00	ES	Futures	4323.39	4325.63	4320.58	4324.51	8683.0
2021-01-21 06:00:00	ES	Futures	4324.79	4329.0	4323.67	4329.0	10132.0
2021-01-21 07:00:00	ES	Futures	4328.72	4330.68	4324.23	4325.91	17007.0
2021-01-21 08:00:00	ES	Futures	4325.91	4327.03	4314.12	4317.21	38567.0
2021-01-21 09:00:00	ES	Futures	4316.93	4322.82	4307.11	4313.84	184215.0
2021-01-21 10:00:00	ES	Futures	4313.84	4325.91	4310.76	4324.51	156589.0
2021-01-21 11:00:00	ES	Futures	4324.51	4326.47	4311.88	4317.21	116835.0
2021-01-21 12:00:00	ES	Futures	4316.93	4317.77	4307.95	4314.97	85995.0
2021-01-21 13:00:00	ES	Futures	4314.97	4319.74	4313.56	4317.49	54642.0
2021-01-21 14:00:00	ES	Futures	4317.77	4325.35	4316.93	4324.79	69965.0
2021-01-21 15:00:00	ES	Futures	4325.07	4326.47	4316.37	4318.05	150440.0
2021-01-21 16:00:00	ES	Futures	4318.33	4321.14	4314.68	4318.33	38082.0
2021-01-21 18:00:00	ES	Futures	4318.61	4321.14	4313.56	4315.53	7228.0
2021-01-21 19:00:00	ES	Futures	4315.53	4320.58	4311.04	4313.28	11286.0
2021-01-21 20:00:00	ES	Futures	4313.28	4315.81	4309.91	4312.16	8511.0
2021-01-21 21:00:00	ES	Futures	4312.16	4313.0	4301.49	4304.58	15489.0
2021-01-21 22:00:00	ES	Futures	4304.58	4307.11	4300.65	4304.02	8698.0
2021-01-21 23:00:00	ES	Futures	4304.02	4311.04	4302.9	4306.55	6242.0
2021-01-21 00:00:00	NQ	Futures	15489.34	15498.02	15480.36	15489.05	2478.0
2021-01-21 01:00:00	NQ	Futures	15488.76	15493.68	15449.97	15465.31	5141.0
2021-01-21 02:00:00	NQ	Futures	15465.02	15478.34	15458.37	15471.97	2583.0
2021-01-21 03:00:00	NQ	Futures	15471.68	15482.68	15438.4	15455.76	6851.0
2021-01-21 04:00:00	NQ	Futures	15455.76	15470.81	15449.1	15455.76	4480.0
2021-01-21 05:00:00	NQ	Futures	15455.47	15462.42	15439.84	15458.08	3775.0
2021-01-21 06:00:00	NQ	Futures	15458.08	15460.97	15445.05	15460.1	3076.0
2021-01-21 07:00:00	NQ	Futures	15460.1	15468.79	15445.63	15457.21	5716.0
2021-01-21 08:00:00	NQ	Futures	15457.79	15476.02	15403.66	15418.42	15848.0
2021-01-21 09:00:00	NQ	Futures	15419.0	15448.53	15378.48	15417.85	72125.0
2021-01-21 10:00:00	NQ	Futures	15417.56	15501.2	15407.72	15497.15	73577.0
2021-01-21 11:00:00	NQ	Futures	15497.44	15505.25	15452.87	15476.6	44545.0
2021-01-21 12:00:00	NQ	Futures	15476.89	15480.65	15416.11	15467.63	39657.0
2021-01-21 13:00:00	NQ	Futures	15467.63	15497.73	15467.05	15473.13	27732.0
2021-01-21 14:00:00	NQ	Futures	15473.13	15521.46	15470.81	15519.44	28781.0
2021-01-21 15:00:00	NQ	Futures	15519.73	15540.86	15502.65	15510.46	45348.0
2021-01-21 16:00:00	NQ	Futures	15509.89	15519.73	15502.65	15510.18	8261.0
2021-01-21 18:00:00	NQ	Futures	15506.7	15516.25	15487.89	15495.12	3094.0
2021-01-21 19:00:00	NQ	Futures	15495.7	15506.12	15474.57	15482.1	3928.0
2021-01-21 20:00:00	NQ	Futures	15482.39	15487.02	15468.79	15479.21	3152.0
2021-01-21 21:00:00	NQ	Futures	15479.21	15483.55	15435.79	15458.37	5984.0
2021-01-21 22:00:00	NQ	Futures	15458.95	15469.65	15440.71	15453.45	2888.0
2021-01-21 23:00:00	NQ	Futures	15453.45	15471.68	15449.39	15461.55	1995.0
2021-01-21 00:00:00	YM	Futures	34544.8	34568.1	34542.6	34567.0	1020.0
2021-01-21 01:00:00	YM	Futures	34565.8	34573.6	34529.2	34542.6	1656.0
2021-01-21 02:00:00	YM	Futures	34542.6	34570.3	34537.0	34561.4	1512.0
2021-01-21 03:00:00	YM	Futures	34562.5	34580.3	34491.5	34500.4	3829.0

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

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