PREVIEW / futures_1hour / 2021-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-10-28.parquet
  size:    65 KB
  rows:    2,018

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-10-28 00:00:00	ES	Futures	5138.52	5139.65	5137.39	5138.81	2625.0
2021-10-28 01:00:00	ES	Futures	5138.52	5140.5	5137.11	5137.68	4612.0
2021-10-28 02:00:00	ES	Futures	5137.68	5139.09	5130.9	5131.47	10645.0
2021-10-28 03:00:00	ES	Futures	5131.75	5142.47	5130.9	5139.37	19458.0
2021-10-28 04:00:00	ES	Futures	5139.65	5142.47	5133.44	5141.06	15856.0
2021-10-28 05:00:00	ES	Futures	5141.35	5141.63	5135.42	5138.81	9998.0
2021-10-28 06:00:00	ES	Futures	5138.81	5146.43	5136.83	5145.86	15440.0
2021-10-28 07:00:00	ES	Futures	5146.14	5148.68	5142.47	5143.32	17958.0
2021-10-28 08:00:00	ES	Futures	5143.32	5150.38	5141.63	5145.86	28518.0
2021-10-28 09:00:00	ES	Futures	5146.14	5163.92	5143.04	5161.66	191619.0
2021-10-28 10:00:00	ES	Futures	5161.66	5175.49	5153.48	5169.57	202959.0
2021-10-28 11:00:00	ES	Futures	5169.57	5175.49	5162.79	5165.33	108979.0
2021-10-28 12:00:00	ES	Futures	5165.33	5172.39	5158.56	5160.82	77928.0
2021-10-28 13:00:00	ES	Futures	5160.82	5169.85	5160.54	5168.16	59943.0
2021-10-28 14:00:00	ES	Futures	5168.44	5174.65	5168.16	5170.13	66821.0
2021-10-28 15:00:00	ES	Futures	5169.85	5180.01	5165.33	5178.88	198376.0
2021-10-28 16:00:00	ES	Futures	5178.6	5181.14	5160.54	5168.44	85581.0
2021-10-28 18:00:00	ES	Futures	5166.74	5169.85	5163.64	5164.77	7893.0
2021-10-28 19:00:00	ES	Futures	5164.77	5166.18	5161.66	5164.2	5177.0
2021-10-28 20:00:00	ES	Futures	5164.2	5166.46	5159.41	5160.25	8330.0
2021-10-28 21:00:00	ES	Futures	5160.54	5161.95	5156.58	5159.41	8045.0
2021-10-28 22:00:00	ES	Futures	5159.41	5162.23	5159.12	5160.82	4565.0
2021-10-28 23:00:00	ES	Futures	5161.1	5165.9	5159.97	5163.36	4824.0
2021-10-28 00:00:00	NQ	Futures	18102.27	18111.83	18096.76	18110.09	1618.0
2021-10-28 01:00:00	NQ	Futures	18109.8	18117.63	18097.92	18099.66	2452.0
2021-10-28 02:00:00	NQ	Futures	18100.82	18113.28	18075.9	18080.24	4621.0
2021-10-28 03:00:00	NQ	Futures	18080.82	18128.64	18075.03	18124.59	8015.0
2021-10-28 04:00:00	NQ	Futures	18125.45	18158.78	18107.78	18153.28	8531.0
2021-10-28 05:00:00	NQ	Futures	18153.28	18153.57	18128.06	18139.95	4735.0
2021-10-28 06:00:00	NQ	Futures	18139.95	18170.38	18135.02	18168.64	5656.0
2021-10-28 07:00:00	NQ	Futures	18168.64	18187.77	18159.94	18164.58	8956.0
2021-10-28 08:00:00	NQ	Futures	18164.87	18186.03	18144.29	18159.94	14723.0
2021-10-28 09:00:00	NQ	Futures	18160.23	18192.4	18125.74	18159.36	85202.0
2021-10-28 10:00:00	NQ	Futures	18159.36	18255.58	18148.64	18215.3	91015.0
2021-10-28 11:00:00	NQ	Futures	18215.3	18262.54	18207.18	18226.6	50405.0
2021-10-28 12:00:00	NQ	Futures	18226.89	18260.22	18185.45	18201.1	39543.0
2021-10-28 13:00:00	NQ	Futures	18201.1	18244.57	18195.59	18234.72	28705.0
2021-10-28 14:00:00	NQ	Futures	18234.72	18268.91	18233.27	18248.34	30418.0
2021-10-28 15:00:00	NQ	Futures	18248.05	18283.98	18218.78	18271.81	57643.0
2021-10-28 16:00:00	NQ	Futures	18271.81	18289.78	18114.44	18165.74	31617.0
2021-10-28 18:00:00	NQ	Futures	18177.04	18191.24	18162.26	18168.93	5298.0
2021-10-28 19:00:00	NQ	Futures	18168.35	18175.3	18160.81	18168.64	3696.0
2021-10-28 20:00:00	NQ	Futures	18168.06	18176.75	18150.09	18153.86	4399.0
2021-10-28 21:00:00	NQ	Futures	18154.73	18160.81	18135.6	18141.1	4627.0
2021-10-28 22:00:00	NQ	Futures	18140.53	18157.91	18138.79	18155.02	2814.0
2021-10-28 23:00:00	NQ	Futures	18155.02	18173.27	18150.38	18165.74	3174.0
2021-10-28 00:00:00	YM	Futures	39725.0	39733.9	39714.9	39728.3	638.0
2021-10-28 01:00:00	YM	Futures	39727.2	39741.8	39721.6	39729.4	928.0
2021-10-28 02:00:00	YM	Futures	39728.3	39736.2	39682.4	39686.8	2073.0
2021-10-28 03:00:00	YM	Futures	39686.8	39758.6	39681.2	39729.4	2801.0

> showing 50 of 2,018 rows — these rows as CSV

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