PREVIEW / futures_1hour / 2020-08-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-08-27.parquet
  size:    62 KB
  rows:    1,874

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
2020-08-27 00:00:00	ES	Futures	3881.76	3884.56	3880.65	3881.21	5094.0
2020-08-27 01:00:00	ES	Futures	3881.21	3882.6	3878.41	3880.09	5405.0
2020-08-27 02:00:00	ES	Futures	3880.09	3883.16	3877.58	3882.88	7442.0
2020-08-27 03:00:00	ES	Futures	3882.6	3883.72	3876.46	3881.76	17736.0
2020-08-27 04:00:00	ES	Futures	3882.04	3882.04	3877.58	3879.53	16619.0
2020-08-27 05:00:00	ES	Futures	3879.25	3879.53	3874.22	3878.69	21964.0
2020-08-27 06:00:00	ES	Futures	3878.69	3879.81	3878.13	3879.25	8491.0
2020-08-27 07:00:00	ES	Futures	3878.97	3880.09	3876.74	3877.58	12349.0
2020-08-27 08:00:00	ES	Futures	3877.3	3886.23	3876.46	3880.93	28719.0
2020-08-27 09:00:00	ES	Futures	3880.93	3902.99	3874.5	3900.19	274974.0
2020-08-27 10:00:00	ES	Futures	3899.91	3904.66	3880.65	3903.27	243877.0
2020-08-27 11:00:00	ES	Futures	3903.55	3907.45	3892.65	3903.55	164295.0
2020-08-27 12:00:00	ES	Futures	3903.27	3903.55	3870.04	3875.34	233616.0
2020-08-27 13:00:00	ES	Futures	3875.62	3894.05	3870.87	3893.49	165862.0
2020-08-27 14:00:00	ES	Futures	3893.49	3903.27	3892.1	3898.52	99957.0
2020-08-27 15:00:00	ES	Futures	3898.52	3905.22	3888.19	3889.58	209133.0
2020-08-27 16:00:00	ES	Futures	3889.86	3896.28	3887.07	3895.73	54787.0
2020-08-27 18:00:00	ES	Futures	3896.01	3898.8	3894.61	3896.56	5060.0
2020-08-27 19:00:00	ES	Futures	3896.56	3901.03	3896.01	3900.47	4117.0
2020-08-27 20:00:00	ES	Futures	3900.19	3902.15	3894.33	3896.28	11342.0
2020-08-27 21:00:00	ES	Futures	3896.28	3903.27	3894.33	3902.71	10935.0
2020-08-27 22:00:00	ES	Futures	3902.43	3918.07	3902.43	3916.95	20532.0
2020-08-27 23:00:00	ES	Futures	3917.23	3920.02	3915.27	3916.95	13414.0
2020-08-27 00:00:00	NQ	Futures	13838.93	13849.63	13831.12	13834.01	2051.0
2020-08-27 01:00:00	NQ	Futures	13834.3	13841.24	13823.6	13831.41	2771.0
2020-08-27 02:00:00	NQ	Futures	13831.12	13851.07	13819.55	13848.76	4494.0
2020-08-27 03:00:00	NQ	Futures	13848.18	13858.59	13831.7	13847.6	8215.0
2020-08-27 04:00:00	NQ	Futures	13848.47	13848.76	13823.6	13836.33	5593.0
2020-08-27 05:00:00	NQ	Futures	13835.75	13850.78	13826.78	13845.0	4953.0
2020-08-27 06:00:00	NQ	Futures	13845.0	13848.76	13836.04	13840.95	2559.0
2020-08-27 07:00:00	NQ	Futures	13840.66	13853.68	13814.93	13827.65	6932.0
2020-08-27 08:00:00	NQ	Futures	13827.94	13855.41	13821.87	13842.98	14419.0
2020-08-27 09:00:00	NQ	Futures	13843.27	13925.1	13778.78	13855.12	132314.0
2020-08-27 10:00:00	NQ	Futures	13854.25	13895.03	13768.66	13886.64	110829.0
2020-08-27 11:00:00	NQ	Futures	13886.35	13933.78	13863.8	13901.68	63608.0
2020-08-27 12:00:00	NQ	Futures	13901.97	13902.84	13689.42	13730.2	104747.0
2020-08-27 13:00:00	NQ	Futures	13729.91	13819.26	13705.04	13816.66	80139.0
2020-08-27 14:00:00	NQ	Futures	13816.37	13866.69	13806.25	13835.46	53712.0
2020-08-27 15:00:00	NQ	Futures	13835.75	13864.95	13789.19	13797.0	71182.0
2020-08-27 16:00:00	NQ	Futures	13797.58	13832.86	13788.03	13818.97	11785.0
2020-08-27 18:00:00	NQ	Futures	13826.49	13835.46	13817.24	13829.67	1533.0
2020-08-27 19:00:00	NQ	Futures	13829.67	13848.47	13827.36	13845.29	1571.0
2020-08-27 20:00:00	NQ	Futures	13844.71	13851.07	13824.76	13829.39	4021.0
2020-08-27 21:00:00	NQ	Futures	13829.1	13839.22	13805.09	13836.61	6084.0
2020-08-27 22:00:00	NQ	Futures	13837.48	13885.2	13829.39	13883.17	6066.0
2020-08-27 23:00:00	NQ	Futures	13883.75	13899.94	13879.7	13889.82	4896.0
2020-08-27 00:00:00	YM	Futures	31121.5	31144.6	31111.6	31117.1	923.0
2020-08-27 01:00:00	YM	Futures	31118.2	31129.2	31098.4	31109.4	859.0
2020-08-27 02:00:00	YM	Futures	31109.4	31130.3	31085.2	31128.1	1490.0
2020-08-27 03:00:00	YM	Futures	31128.1	31132.5	31066.5	31116.0	3881.0

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

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