PREVIEW / futures_1hour / 2021-07-05

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-07-05.parquet
  size:    45 KB
  rows:    1,403

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-07-05 00:00:00	ES	Futures	4884.33	4886.58	4884.04	4885.45	1399.0
2021-07-05 01:00:00	ES	Futures	4885.45	4886.01	4882.92	4884.33	3641.0
2021-07-05 02:00:00	ES	Futures	4884.33	4884.89	4882.07	4884.89	4613.0
2021-07-05 03:00:00	ES	Futures	4885.17	4885.45	4880.38	4882.64	11387.0
2021-07-05 04:00:00	ES	Futures	4882.64	4888.55	4881.51	4885.73	8582.0
2021-07-05 05:00:00	ES	Futures	4885.73	4889.68	4885.17	4887.99	5560.0
2021-07-05 06:00:00	ES	Futures	4888.27	4890.24	4886.58	4889.68	5707.0
2021-07-05 07:00:00	ES	Futures	4889.68	4892.21	4889.11	4889.39	5558.0
2021-07-05 08:00:00	ES	Futures	4889.39	4892.49	4889.11	4892.21	4014.0
2021-07-05 09:00:00	ES	Futures	4891.93	4892.77	4889.96	4892.21	5078.0
2021-07-05 10:00:00	ES	Futures	4892.21	4894.46	4890.52	4893.62	5720.0
2021-07-05 11:00:00	ES	Futures	4893.62	4895.03	4893.05	4893.62	3901.0
2021-07-05 12:00:00	ES	Futures	4893.62	4894.74	4889.11	4889.96	5305.0
2021-07-05 18:00:00	ES	Futures	4889.96	4894.74	4889.96	4894.46	3410.0
2021-07-05 19:00:00	ES	Futures	4894.46	4896.71	4894.18	4895.31	2739.0
2021-07-05 20:00:00	ES	Futures	4895.59	4897.28	4893.34	4896.71	6689.0
2021-07-05 21:00:00	ES	Futures	4897.0	4897.0	4891.65	4893.34	6943.0
2021-07-05 22:00:00	ES	Futures	4893.34	4895.03	4890.8	4890.8	4368.0
2021-07-05 23:00:00	ES	Futures	4891.08	4891.93	4889.68	4890.8	2660.0
2021-07-05 00:00:00	NQ	Futures	17036.73	17042.82	17034.42	17037.6	942.0
2021-07-05 01:00:00	NQ	Futures	17037.31	17038.18	17022.83	17030.07	1977.0
2021-07-05 02:00:00	NQ	Futures	17029.2	17029.49	17020.51	17026.31	1942.0
2021-07-05 03:00:00	NQ	Futures	17025.73	17030.65	17003.71	17016.46	4378.0
2021-07-05 04:00:00	NQ	Futures	17015.59	17029.78	17013.56	17020.51	4088.0
2021-07-05 05:00:00	NQ	Futures	17020.22	17038.47	17017.04	17031.23	2601.0
2021-07-05 06:00:00	NQ	Futures	17031.23	17038.76	17026.6	17036.44	1874.0
2021-07-05 07:00:00	NQ	Futures	17036.15	17045.42	17028.91	17032.1	2446.0
2021-07-05 08:00:00	NQ	Futures	17032.97	17043.69	17029.2	17041.08	1980.0
2021-07-05 09:00:00	NQ	Futures	17041.37	17049.48	17024.57	17028.04	5536.0
2021-07-05 10:00:00	NQ	Futures	17027.75	17036.15	17025.15	17034.42	4246.0
2021-07-05 11:00:00	NQ	Futures	17034.13	17035.29	17024.57	17026.31	3244.0
2021-07-05 12:00:00	NQ	Futures	17026.6	17029.78	17020.8	17025.44	1817.0
2021-07-05 18:00:00	NQ	Futures	17027.17	17049.48	17025.44	17042.24	2072.0
2021-07-05 19:00:00	NQ	Futures	17041.66	17053.54	17040.79	17049.77	1704.0
2021-07-05 20:00:00	NQ	Futures	17050.06	17061.07	17045.42	17051.51	3074.0
2021-07-05 21:00:00	NQ	Futures	17051.22	17052.67	17022.25	17025.44	3695.0
2021-07-05 22:00:00	NQ	Futures	17024.86	17034.13	17013.27	17014.43	3405.0
2021-07-05 23:00:00	NQ	Futures	17015.01	17019.06	17011.24	17016.17	2129.0
2021-07-05 00:00:00	YM	Futures	38681.5	38689.3	38669.2	38681.5	287.0
2021-07-05 01:00:00	YM	Futures	38681.5	38693.8	38667.0	38680.4	1071.0
2021-07-05 02:00:00	YM	Futures	38678.1	38689.3	38649.1	38687.1	1360.0
2021-07-05 03:00:00	YM	Futures	38688.2	38698.3	38650.2	38668.1	1741.0
2021-07-05 04:00:00	YM	Futures	38667.0	38748.5	38658.0	38721.7	2528.0
2021-07-05 05:00:00	YM	Futures	38724.0	38754.1	38720.6	38740.7	1217.0
2021-07-05 06:00:00	YM	Futures	38741.8	38764.2	38726.2	38758.6	1187.0
2021-07-05 07:00:00	YM	Futures	38757.5	38783.2	38756.4	38761.9	1463.0
2021-07-05 08:00:00	YM	Futures	38763.1	38782.1	38758.6	38772.0	965.0
2021-07-05 09:00:00	YM	Futures	38769.8	38806.6	38758.6	38802.2	1934.0
2021-07-05 10:00:00	YM	Futures	38802.2	38804.4	38763.1	38799.9	1950.0
2021-07-05 11:00:00	YM	Futures	38799.9	38822.3	38795.5	38797.7	1525.0

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

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