PREVIEW / futures_1hour / 2020-01-07

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-07.parquet
  size:    61 KB
  rows:    1,893

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-01-07 00:00:00	ES	Futures	3524.8	3525.3	3522.1	3522.9	6687.0
2020-01-07 01:00:00	ES	Futures	3522.9	3524.0	3518.5	3521.5	11791.0
2020-01-07 02:00:00	ES	Futures	3521.2	3525.0	3515.3	3518.3	30265.0
2020-01-07 03:00:00	ES	Futures	3518.0	3527.8	3516.6	3523.4	35540.0
2020-01-07 04:00:00	ES	Futures	3523.7	3524.2	3517.5	3521.2	18511.0
2020-01-07 05:00:00	ES	Futures	3521.0	3523.1	3517.7	3520.2	14251.0
2020-01-07 06:00:00	ES	Futures	3519.9	3522.1	3515.8	3516.6	12951.0
2020-01-07 07:00:00	ES	Futures	3516.6	3519.9	3516.1	3519.6	13717.0
2020-01-07 08:00:00	ES	Futures	3519.6	3519.9	3510.7	3511.2	37337.0
2020-01-07 09:00:00	ES	Futures	3511.5	3514.5	3503.1	3506.6	252022.0
2020-01-07 10:00:00	ES	Futures	3506.9	3515.6	3505.3	3514.2	215930.0
2020-01-07 11:00:00	ES	Futures	3514.2	3517.2	3508.5	3509.9	110943.0
2020-01-07 12:00:00	ES	Futures	3509.9	3512.0	3508.0	3510.4	68775.0
2020-01-07 13:00:00	ES	Futures	3510.1	3513.1	3510.1	3513.1	44694.0
2020-01-07 14:00:00	ES	Futures	3513.1	3513.4	3507.4	3511.2	62040.0
2020-01-07 15:00:00	ES	Futures	3511.2	3515.3	3507.7	3509.1	144909.0
2020-01-07 16:00:00	ES	Futures	3508.8	3509.3	3496.9	3504.4	84627.0
2020-01-07 18:00:00	ES	Futures	3503.1	3505.3	3464.1	3472.2	131430.0
2020-01-07 19:00:00	ES	Futures	3472.5	3473.8	3448.1	3459.7	146695.0
2020-01-07 20:00:00	ES	Futures	3460.0	3482.5	3455.9	3474.9	119975.0
2020-01-07 21:00:00	ES	Futures	3474.6	3501.2	3473.6	3497.9	108702.0
2020-01-07 22:00:00	ES	Futures	3498.2	3499.3	3489.0	3498.5	47166.0
2020-01-07 23:00:00	ES	Futures	3498.8	3500.7	3494.1	3494.7	11201.0
2020-01-07 00:00:00	NQ	Futures	10273.75	10275.19	10263.63	10267.1	4270.0
2020-01-07 01:00:00	NQ	Futures	10266.81	10270.57	10249.75	10261.31	6267.0
2020-01-07 02:00:00	NQ	Futures	10261.02	10273.75	10239.34	10253.8	15191.0
2020-01-07 03:00:00	NQ	Futures	10253.8	10288.5	10244.83	10270.86	23551.0
2020-01-07 04:00:00	NQ	Futures	10271.15	10278.09	10256.98	10268.83	10349.0
2020-01-07 05:00:00	NQ	Futures	10268.25	10274.9	10257.27	10266.52	8331.0
2020-01-07 06:00:00	NQ	Futures	10266.52	10273.46	10252.93	10256.4	7361.0
2020-01-07 07:00:00	NQ	Futures	10256.11	10274.04	10254.37	10271.43	10316.0
2020-01-07 08:00:00	NQ	Futures	10271.72	10274.62	10240.2	10244.83	20120.0
2020-01-07 09:00:00	NQ	Futures	10244.54	10269.12	10218.81	10244.54	100160.0
2020-01-07 10:00:00	NQ	Futures	10244.83	10270.28	10228.35	10266.23	88283.0
2020-01-07 11:00:00	NQ	Futures	10266.52	10280.69	10253.51	10258.71	43679.0
2020-01-07 12:00:00	NQ	Futures	10259.0	10269.7	10253.22	10265.94	28541.0
2020-01-07 13:00:00	NQ	Futures	10265.65	10277.22	10265.65	10276.35	18908.0
2020-01-07 14:00:00	NQ	Futures	10276.35	10277.22	10249.17	10261.02	27078.0
2020-01-07 15:00:00	NQ	Futures	10261.02	10272.01	10244.25	10251.19	37517.0
2020-01-07 16:00:00	NQ	Futures	10251.19	10251.77	10208.68	10230.08	17714.0
2020-01-07 18:00:00	NQ	Futures	10226.9	10233.55	10094.46	10123.38	44922.0
2020-01-07 19:00:00	NQ	Futures	10123.67	10128.58	10037.78	10074.8	56327.0
2020-01-07 20:00:00	NQ	Futures	10075.09	10154.03	10063.23	10120.78	37713.0
2020-01-07 21:00:00	NQ	Futures	10120.49	10214.76	10116.44	10200.3	41863.0
2020-01-07 22:00:00	NQ	Futures	10200.01	10209.26	10166.75	10198.56	20969.0
2020-01-07 23:00:00	NQ	Futures	10198.56	10208.39	10184.39	10187.29	5741.0
2020-01-07 00:00:00	YM	Futures	31265.4	31270.9	31240.4	31249.1	1619.0
2020-01-07 01:00:00	YM	Futures	31246.9	31255.6	31207.7	31232.8	2406.0
2020-01-07 02:00:00	YM	Futures	31231.7	31267.6	31177.2	31196.8	7011.0
2020-01-07 03:00:00	YM	Futures	31196.8	31289.4	31185.9	31248.0	9771.0

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

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