PREVIEW / futures_1hour / 2021-12-29

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-29.parquet
  size:    64 KB
  rows:    2,004

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-12-29 00:00:00	ES	Futures	5410.85	5415.38	5407.74	5413.68	3303.0
2021-12-29 01:00:00	ES	Futures	5413.68	5415.38	5410.0	5413.11	2915.0
2021-12-29 02:00:00	ES	Futures	5413.4	5418.49	5413.11	5417.07	4965.0
2021-12-29 03:00:00	ES	Futures	5417.07	5418.49	5413.4	5415.94	9315.0
2021-12-29 04:00:00	ES	Futures	5416.23	5418.21	5413.96	5417.07	5117.0
2021-12-29 05:00:00	ES	Futures	5417.36	5419.05	5413.11	5415.38	6200.0
2021-12-29 06:00:00	ES	Futures	5415.38	5415.38	5408.87	5410.57	6329.0
2021-12-29 07:00:00	ES	Futures	5410.29	5410.57	5405.76	5406.04	8420.0
2021-12-29 08:00:00	ES	Futures	5406.04	5408.31	5401.52	5406.61	21199.0
2021-12-29 09:00:00	ES	Futures	5406.61	5420.47	5406.04	5413.96	127433.0
2021-12-29 10:00:00	ES	Futures	5414.25	5415.94	5395.86	5410.0	176805.0
2021-12-29 11:00:00	ES	Futures	5409.72	5412.55	5401.24	5402.65	77524.0
2021-12-29 12:00:00	ES	Futures	5402.93	5405.2	5397.84	5404.91	51587.0
2021-12-29 13:00:00	ES	Futures	5404.91	5410.57	5402.93	5409.16	48914.0
2021-12-29 14:00:00	ES	Futures	5409.16	5414.25	5407.46	5413.68	47976.0
2021-12-29 15:00:00	ES	Futures	5413.68	5425.28	5411.14	5412.27	156164.0
2021-12-29 16:00:00	ES	Futures	5412.55	5415.66	5410.57	5411.7	38060.0
2021-12-29 18:00:00	ES	Futures	5412.55	5414.53	5405.48	5407.74	9470.0
2021-12-29 19:00:00	ES	Futures	5407.74	5408.02	5402.09	5407.46	6270.0
2021-12-29 20:00:00	ES	Futures	5407.74	5412.83	5406.04	5411.7	4583.0
2021-12-29 21:00:00	ES	Futures	5411.98	5414.25	5408.59	5409.72	3379.0
2021-12-29 22:00:00	ES	Futures	5409.72	5411.14	5408.02	5408.31	2027.0
2021-12-29 23:00:00	ES	Futures	5408.31	5410.57	5407.74	5410.29	1848.0
2021-12-29 00:00:00	NQ	Futures	19176.91	19190.82	19161.26	19184.45	2228.0
2021-12-29 01:00:00	NQ	Futures	19184.74	19188.79	19169.67	19178.94	2116.0
2021-12-29 02:00:00	NQ	Futures	19178.65	19202.42	19178.07	19195.75	3187.0
2021-12-29 03:00:00	NQ	Futures	19194.59	19200.39	19160.68	19178.36	6225.0
2021-12-29 04:00:00	NQ	Futures	19178.94	19197.2	19174.3	19186.77	2669.0
2021-12-29 05:00:00	NQ	Futures	19186.48	19193.72	19168.22	19178.65	2636.0
2021-12-29 06:00:00	NQ	Futures	19178.36	19178.36	19146.19	19157.49	3794.0
2021-12-29 07:00:00	NQ	Futures	19156.91	19159.52	19126.77	19129.96	5158.0
2021-12-29 08:00:00	NQ	Futures	19130.25	19139.81	19093.15	19111.7	10084.0
2021-12-29 09:00:00	NQ	Futures	19111.7	19185.32	19101.85	19140.1	62412.0
2021-12-29 10:00:00	NQ	Futures	19139.52	19147.64	18997.51	19085.91	82821.0
2021-12-29 11:00:00	NQ	Futures	19085.91	19112.28	19042.73	19050.84	36853.0
2021-12-29 12:00:00	NQ	Futures	19051.42	19063.59	19029.1	19058.67	23200.0
2021-12-29 13:00:00	NQ	Futures	19058.67	19094.02	19054.9	19086.78	21606.0
2021-12-29 14:00:00	NQ	Futures	19086.49	19131.7	19078.66	19126.48	19365.0
2021-12-29 15:00:00	NQ	Futures	19125.9	19156.33	19103.01	19114.6	40733.0
2021-12-29 16:00:00	NQ	Futures	19114.6	19122.43	19100.11	19106.49	7634.0
2021-12-29 18:00:00	NQ	Futures	19109.96	19119.82	19076.05	19085.62	4024.0
2021-12-29 19:00:00	NQ	Futures	19085.91	19086.49	19060.69	19081.27	3552.0
2021-12-29 20:00:00	NQ	Futures	19082.14	19111.99	19075.48	19108.22	3063.0
2021-12-29 21:00:00	NQ	Futures	19107.93	19119.24	19097.5	19101.85	2081.0
2021-12-29 22:00:00	NQ	Futures	19101.27	19106.2	19097.5	19100.11	1123.0
2021-12-29 23:00:00	NQ	Futures	19100.4	19112.57	19099.53	19111.41	975.0
2021-12-29 00:00:00	YM	Futures	40789.5	40819.8	40768.1	40807.4	780.0
2021-12-29 01:00:00	YM	Futures	40810.8	40824.3	40782.7	40805.2	552.0
2021-12-29 02:00:00	YM	Futures	40807.4	40836.7	40800.7	40823.2	1226.0
2021-12-29 03:00:00	YM	Futures	40823.2	40851.3	40811.9	40841.1	3204.0

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

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