PREVIEW / futures_1hour / 2021-06-30

all futures 1-hour files

  file:    by_date/futures_1hour/2021/2021-06-30.parquet
  size:    63 KB
  rows:    1,936

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-30 00:00:00	ES	Futures	4828.85	4829.7	4827.73	4829.42	2408.0
2021-06-30 01:00:00	ES	Futures	4829.42	4829.7	4825.19	4825.47	3370.0
2021-06-30 02:00:00	ES	Futures	4825.47	4827.16	4823.5	4824.91	8224.0
2021-06-30 03:00:00	ES	Futures	4824.91	4828.57	4824.35	4828.01	13679.0
2021-06-30 04:00:00	ES	Futures	4828.01	4828.29	4813.65	4813.93	38372.0
2021-06-30 05:00:00	ES	Futures	4813.93	4816.46	4808.58	4814.77	26681.0
2021-06-30 06:00:00	ES	Futures	4814.77	4819.84	4814.49	4816.75	17983.0
2021-06-30 07:00:00	ES	Futures	4816.46	4824.91	4816.46	4821.53	21030.0
2021-06-30 08:00:00	ES	Futures	4821.25	4824.35	4817.31	4818.15	22915.0
2021-06-30 09:00:00	ES	Futures	4818.15	4826.32	4814.49	4821.53	137087.0
2021-06-30 10:00:00	ES	Futures	4821.53	4830.54	4821.25	4829.14	131476.0
2021-06-30 11:00:00	ES	Futures	4829.14	4831.11	4824.35	4826.32	83520.0
2021-06-30 12:00:00	ES	Futures	4826.32	4828.85	4823.78	4826.88	61822.0
2021-06-30 13:00:00	ES	Futures	4826.88	4828.01	4824.35	4825.47	40747.0
2021-06-30 14:00:00	ES	Futures	4825.47	4827.45	4822.1	4826.04	50308.0
2021-06-30 15:00:00	ES	Futures	4826.32	4836.17	4825.47	4828.01	279957.0
2021-06-30 16:00:00	ES	Futures	4828.01	4836.74	4826.6	4835.89	70406.0
2021-06-30 18:00:00	ES	Futures	4836.74	4838.43	4835.33	4837.86	4891.0
2021-06-30 19:00:00	ES	Futures	4837.58	4837.58	4835.61	4837.02	3839.0
2021-06-30 20:00:00	ES	Futures	4837.02	4840.4	4834.2	4839.84	10756.0
2021-06-30 21:00:00	ES	Futures	4839.55	4841.24	4838.15	4840.68	6655.0
2021-06-30 22:00:00	ES	Futures	4840.68	4840.68	4838.99	4838.99	3167.0
2021-06-30 23:00:00	ES	Futures	4839.27	4840.12	4837.58	4838.43	4309.0
2021-06-30 00:00:00	NQ	Futures	16894.79	16900.58	16889.58	16897.4	1201.0
2021-06-30 01:00:00	NQ	Futures	16897.69	16898.85	16882.33	16884.36	2030.0
2021-06-30 02:00:00	NQ	Futures	16883.78	16893.63	16878.57	16887.84	3212.0
2021-06-30 03:00:00	NQ	Futures	16886.97	16906.67	16886.1	16897.4	4979.0
2021-06-30 04:00:00	NQ	Futures	16897.4	16898.56	16861.77	16862.93	9559.0
2021-06-30 05:00:00	NQ	Futures	16862.93	16863.5	16832.8	16848.15	9355.0
2021-06-30 06:00:00	NQ	Futures	16848.44	16864.08	16846.99	16850.47	5404.0
2021-06-30 07:00:00	NQ	Futures	16850.76	16889.0	16850.76	16872.2	7504.0
2021-06-30 08:00:00	NQ	Futures	16871.91	16883.78	16854.81	16866.4	9533.0
2021-06-30 09:00:00	NQ	Futures	16866.4	16885.52	16824.4	16842.36	69374.0
2021-06-30 10:00:00	NQ	Futures	16842.36	16884.36	16834.25	16881.75	61815.0
2021-06-30 11:00:00	NQ	Futures	16881.75	16890.45	16845.25	16866.11	37967.0
2021-06-30 12:00:00	NQ	Futures	16866.69	16871.04	16822.66	16847.28	30248.0
2021-06-30 13:00:00	NQ	Futures	16847.28	16866.11	16845.54	16858.0	20801.0
2021-06-30 14:00:00	NQ	Futures	16857.71	16861.48	16834.83	16852.21	25703.0
2021-06-30 15:00:00	NQ	Futures	16852.5	16882.62	16843.23	16851.92	55357.0
2021-06-30 16:00:00	NQ	Futures	16851.92	16872.2	16849.6	16865.82	10984.0
2021-06-30 18:00:00	NQ	Futures	16869.3	16874.22	16864.37	16871.04	1827.0
2021-06-30 19:00:00	NQ	Futures	16870.75	16872.48	16863.22	16871.62	1100.0
2021-06-30 20:00:00	NQ	Futures	16871.62	16885.52	16864.08	16884.07	2922.0
2021-06-30 21:00:00	NQ	Futures	16883.78	16889.87	16875.67	16884.94	2603.0
2021-06-30 22:00:00	NQ	Futures	16884.07	16884.94	16876.83	16877.7	1469.0
2021-06-30 23:00:00	NQ	Futures	16877.99	16877.99	16865.82	16869.59	2149.0
2021-06-30 00:00:00	YM	Futures	38230.1	38231.2	38213.4	38223.4	592.0
2021-06-30 01:00:00	YM	Futures	38224.5	38229.0	38194.4	38194.4	850.0
2021-06-30 02:00:00	YM	Futures	38193.3	38204.4	38168.7	38184.3	1791.0
2021-06-30 03:00:00	YM	Futures	38185.4	38219.0	38179.9	38206.7	2194.0

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

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