PREVIEW / futures_1hour / 2021-12-28

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-12-28.parquet
  size:    61 KB
  rows:    1,922

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-28 00:00:00	ES	Futures	5404.07	5408.59	5403.22	5408.59	3079.0
2021-12-28 01:00:00	ES	Futures	5408.87	5409.72	5404.91	5408.59	3909.0
2021-12-28 02:00:00	ES	Futures	5408.59	5409.16	5401.8	5404.07	3412.0
2021-12-28 03:00:00	ES	Futures	5403.78	5417.92	5403.5	5416.79	11046.0
2021-12-28 04:00:00	ES	Futures	5416.79	5424.14	5415.09	5423.3	11731.0
2021-12-28 05:00:00	ES	Futures	5423.3	5426.69	5421.6	5423.86	8886.0
2021-12-28 06:00:00	ES	Futures	5423.86	5424.71	5419.9	5421.32	5100.0
2021-12-28 07:00:00	ES	Futures	5421.03	5426.12	5419.9	5424.14	8745.0
2021-12-28 08:00:00	ES	Futures	5424.14	5425.56	5417.07	5417.64	17110.0
2021-12-28 09:00:00	ES	Futures	5417.64	5427.54	5409.72	5423.86	143211.0
2021-12-28 10:00:00	ES	Futures	5424.14	5426.97	5408.02	5416.51	155441.0
2021-12-28 11:00:00	ES	Futures	5416.23	5420.47	5409.16	5419.05	97187.0
2021-12-28 12:00:00	ES	Futures	5418.77	5419.62	5396.43	5404.63	103264.0
2021-12-28 13:00:00	ES	Futures	5404.63	5409.44	5400.95	5409.16	63751.0
2021-12-28 14:00:00	ES	Futures	5409.44	5409.44	5398.69	5406.89	68968.0
2021-12-28 15:00:00	ES	Futures	5407.18	5415.38	5401.52	5407.18	152413.0
2021-12-28 16:00:00	ES	Futures	5407.18	5412.83	5406.61	5408.31	32838.0
2021-12-28 18:00:00	ES	Futures	5408.31	5415.66	5408.31	5414.25	5611.0
2021-12-28 19:00:00	ES	Futures	5413.96	5415.94	5411.42	5414.81	5547.0
2021-12-28 20:00:00	ES	Futures	5414.81	5416.51	5403.22	5403.78	8780.0
2021-12-28 21:00:00	ES	Futures	5403.78	5409.44	5402.09	5409.44	4765.0
2021-12-28 22:00:00	ES	Futures	5409.72	5412.27	5407.18	5411.14	2880.0
2021-12-28 23:00:00	ES	Futures	5411.14	5411.14	5408.87	5410.57	1565.0
2021-12-28 00:00:00	NQ	Futures	19187.05	19200.97	19182.71	19200.68	2552.0
2021-12-28 01:00:00	NQ	Futures	19200.97	19208.79	19189.66	19199.52	2648.0
2021-12-28 02:00:00	NQ	Futures	19199.23	19202.13	19176.62	19186.19	2638.0
2021-12-28 03:00:00	NQ	Futures	19186.19	19254.58	19183.29	19251.39	7998.0
2021-12-28 04:00:00	NQ	Futures	19250.81	19289.07	19244.15	19287.91	7936.0
2021-12-28 05:00:00	NQ	Futures	19288.49	19305.3	19286.75	19299.5	5454.0
2021-12-28 06:00:00	NQ	Futures	19300.08	19300.66	19277.48	19285.3	3367.0
2021-12-28 07:00:00	NQ	Futures	19285.3	19312.84	19274.0	19293.13	6390.0
2021-12-28 08:00:00	NQ	Futures	19293.42	19298.63	19252.55	19256.61	9642.0
2021-12-28 09:00:00	NQ	Futures	19256.9	19261.25	19152.28	19215.75	72233.0
2021-12-28 10:00:00	NQ	Futures	19215.17	19227.63	19118.08	19181.55	85895.0
2021-12-28 11:00:00	NQ	Futures	19181.84	19203.86	19122.72	19190.24	48808.0
2021-12-28 12:00:00	NQ	Futures	19190.53	19196.91	19090.26	19129.09	42969.0
2021-12-28 13:00:00	NQ	Futures	19129.38	19140.1	19093.44	19118.66	32874.0
2021-12-28 14:00:00	NQ	Futures	19118.08	19131.99	19072.58	19120.98	37920.0
2021-12-28 15:00:00	NQ	Futures	19120.98	19160.97	19097.79	19121.85	52120.0
2021-12-28 16:00:00	NQ	Futures	19120.98	19161.55	19118.66	19142.42	9444.0
2021-12-28 18:00:00	NQ	Futures	19143.58	19179.52	19142.13	19173.43	3239.0
2021-12-28 19:00:00	NQ	Futures	19172.27	19182.42	19163.0	19178.65	2717.0
2021-12-28 20:00:00	NQ	Futures	19178.94	19188.79	19130.54	19134.89	5045.0
2021-12-28 21:00:00	NQ	Futures	19135.47	19176.91	19125.9	19173.14	4007.0
2021-12-28 22:00:00	NQ	Futures	19174.01	19180.1	19159.81	19174.01	2058.0
2021-12-28 23:00:00	NQ	Futures	19173.43	19178.36	19165.9	19176.91	1116.0
2021-12-28 00:00:00	YM	Futures	40618.6	40656.8	40614.1	40655.7	762.0
2021-12-28 01:00:00	YM	Futures	40656.8	40667.0	40623.1	40664.7	1192.0
2021-12-28 02:00:00	YM	Futures	40662.5	40669.2	40604.0	40620.9	1433.0
2021-12-28 03:00:00	YM	Futures	40620.9	40725.4	40613.0	40716.4	4535.0

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

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