PREVIEW / futures_1hour / 2021-06-28

all futures 1-hour files

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

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-06-28 00:00:00	ES	Futures	4813.37	4813.65	4811.96	4813.08	2563.0
2021-06-28 01:00:00	ES	Futures	4813.37	4817.03	4812.24	4817.03	5501.0
2021-06-28 02:00:00	ES	Futures	4817.03	4817.03	4812.52	4813.37	6280.0
2021-06-28 03:00:00	ES	Futures	4813.65	4817.87	4811.68	4813.65	16135.0
2021-06-28 04:00:00	ES	Futures	4813.93	4814.77	4808.58	4813.37	14265.0
2021-06-28 05:00:00	ES	Futures	4813.37	4814.49	4810.83	4813.08	6378.0
2021-06-28 06:00:00	ES	Futures	4813.08	4813.37	4807.73	4811.68	8599.0
2021-06-28 07:00:00	ES	Futures	4811.4	4816.46	4810.83	4813.37	18918.0
2021-06-28 08:00:00	ES	Futures	4813.65	4819.0	4811.68	4818.43	17160.0
2021-06-28 09:00:00	ES	Futures	4818.43	4820.12	4804.64	4811.96	127924.0
2021-06-28 10:00:00	ES	Futures	4812.24	4814.49	4808.3	4809.99	105493.0
2021-06-28 11:00:00	ES	Futures	4809.99	4813.37	4806.05	4810.27	80269.0
2021-06-28 12:00:00	ES	Futures	4810.55	4811.96	4806.05	4806.05	48226.0
2021-06-28 13:00:00	ES	Futures	4806.05	4810.27	4802.95	4809.71	69071.0
2021-06-28 14:00:00	ES	Futures	4809.71	4815.34	4809.42	4814.77	57732.0
2021-06-28 15:00:00	ES	Futures	4814.77	4822.94	4812.8	4820.97	144728.0
2021-06-28 16:00:00	ES	Futures	4820.97	4822.66	4819.0	4822.1	43313.0
2021-06-28 18:00:00	ES	Futures	4821.25	4821.25	4817.59	4818.15	3893.0
2021-06-28 19:00:00	ES	Futures	4818.15	4819.28	4816.75	4817.59	3132.0
2021-06-28 20:00:00	ES	Futures	4817.59	4817.87	4814.21	4815.34	7334.0
2021-06-28 21:00:00	ES	Futures	4815.34	4816.18	4811.4	4813.65	8495.0
2021-06-28 22:00:00	ES	Futures	4813.65	4813.93	4812.24	4813.65	3446.0
2021-06-28 23:00:00	ES	Futures	4813.65	4813.93	4812.24	4813.65	2991.0
2021-06-28 00:00:00	NQ	Futures	16628.86	16638.71	16626.55	16635.82	1333.0
2021-06-28 01:00:00	NQ	Futures	16636.1	16645.09	16631.18	16641.03	2761.0
2021-06-28 02:00:00	NQ	Futures	16641.32	16641.9	16627.12	16635.82	3045.0
2021-06-28 03:00:00	NQ	Futures	16635.82	16670.29	16630.02	16657.54	7346.0
2021-06-28 04:00:00	NQ	Futures	16657.54	16659.57	16632.92	16654.64	5651.0
2021-06-28 05:00:00	NQ	Futures	16654.35	16661.31	16646.82	16655.22	3169.0
2021-06-28 06:00:00	NQ	Futures	16655.22	16656.38	16636.1	16652.91	3738.0
2021-06-28 07:00:00	NQ	Futures	16652.62	16672.89	16646.82	16665.94	7188.0
2021-06-28 08:00:00	NQ	Futures	16666.52	16677.53	16656.67	16676.37	6275.0
2021-06-28 09:00:00	NQ	Futures	16676.37	16753.43	16670.29	16744.74	67718.0
2021-06-28 10:00:00	NQ	Futures	16745.6	16787.61	16744.74	16755.16	64797.0
2021-06-28 11:00:00	NQ	Futures	16755.45	16780.66	16749.37	16770.52	32513.0
2021-06-28 12:00:00	NQ	Futures	16770.23	16795.72	16765.59	16771.1	29923.0
2021-06-28 13:00:00	NQ	Futures	16771.1	16774.57	16752.56	16759.22	24994.0
2021-06-28 14:00:00	NQ	Futures	16758.93	16808.18	16754.58	16805.86	28062.0
2021-06-28 15:00:00	NQ	Futures	16806.15	16824.4	16788.77	16814.55	55289.0
2021-06-28 16:00:00	NQ	Futures	16814.26	16815.42	16797.46	16804.7	11543.0
2021-06-28 18:00:00	NQ	Futures	16806.73	16806.73	16791.37	16793.11	2020.0
2021-06-28 19:00:00	NQ	Futures	16793.4	16797.46	16786.74	16791.66	1906.0
2021-06-28 20:00:00	NQ	Futures	16791.95	16792.82	16779.21	16782.1	3354.0
2021-06-28 21:00:00	NQ	Futures	16781.81	16785.29	16767.91	16779.21	3667.0
2021-06-28 22:00:00	NQ	Futures	16778.63	16786.74	16774.28	16785.0	1992.0
2021-06-28 23:00:00	NQ	Futures	16785.29	16785.58	16774.57	16778.92	1815.0
2021-06-28 00:00:00	YM	Futures	38378.7	38382.1	38364.2	38374.3	535.0
2021-06-28 01:00:00	YM	Futures	38376.5	38408.9	38365.3	38408.9	943.0
2021-06-28 02:00:00	YM	Futures	38407.8	38408.9	38362.0	38362.0	1509.0
2021-06-28 03:00:00	YM	Futures	38364.2	38397.7	38343.0	38345.2	2369.0

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

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