PREVIEW / futures_1hour / 2020-10-15

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-15.parquet
  size:    63 KB
  rows:    1,895

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-10-15 00:00:00	ES	Futures	3883.51	3891.63	3880.15	3888.55	7269.0
2020-10-15 01:00:00	ES	Futures	3888.83	3894.43	3887.71	3889.11	6648.0
2020-10-15 02:00:00	ES	Futures	3889.11	3889.11	3877.63	3878.75	16568.0
2020-10-15 03:00:00	ES	Futures	3878.47	3882.95	3874.83	3880.15	44598.0
2020-10-15 04:00:00	ES	Futures	3879.87	3880.15	3855.22	3859.14	55362.0
2020-10-15 05:00:00	ES	Futures	3859.14	3861.1	3847.1	3856.62	51504.0
2020-10-15 06:00:00	ES	Futures	3856.62	3863.62	3851.58	3862.22	35770.0
2020-10-15 07:00:00	ES	Futures	3862.5	3866.98	3855.78	3858.86	24986.0
2020-10-15 08:00:00	ES	Futures	3858.58	3859.42	3847.1	3852.42	62967.0
2020-10-15 09:00:00	ES	Futures	3852.42	3872.87	3844.58	3872.87	212038.0
2020-10-15 10:00:00	ES	Futures	3872.87	3873.71	3852.42	3863.06	270772.0
2020-10-15 11:00:00	ES	Futures	3862.78	3880.99	3854.38	3872.31	187899.0
2020-10-15 12:00:00	ES	Futures	3872.03	3876.23	3863.34	3875.67	135738.0
2020-10-15 13:00:00	ES	Futures	3875.39	3886.31	3874.27	3882.67	106315.0
2020-10-15 14:00:00	ES	Futures	3882.95	3888.55	3880.15	3887.43	91429.0
2020-10-15 15:00:00	ES	Futures	3887.43	3900.04	3885.47	3894.15	195649.0
2020-10-15 16:00:00	ES	Futures	3893.87	3896.95	3893.03	3894.43	36118.0
2020-10-15 18:00:00	ES	Futures	3897.23	3898.92	3894.43	3894.99	5634.0
2020-10-15 19:00:00	ES	Futures	3895.27	3907.04	3894.71	3903.12	12496.0
2020-10-15 20:00:00	ES	Futures	3903.12	3906.76	3897.51	3903.12	10695.0
2020-10-15 21:00:00	ES	Futures	3903.12	3911.52	3902.56	3905.64	12248.0
2020-10-15 22:00:00	ES	Futures	3905.64	3906.76	3903.96	3905.08	4023.0
2020-10-15 23:00:00	ES	Futures	3905.08	3905.64	3889.95	3894.15	14111.0
2020-10-15 00:00:00	NQ	Futures	13752.08	13798.97	13734.42	13775.24	3948.0
2020-10-15 01:00:00	NQ	Futures	13773.5	13801.87	13770.03	13781.6	3083.0
2020-10-15 02:00:00	NQ	Futures	13782.18	13783.63	13706.92	13712.13	7166.0
2020-10-15 03:00:00	NQ	Futures	13711.84	13743.97	13709.82	13730.95	11158.0
2020-10-15 04:00:00	NQ	Futures	13731.53	13731.53	13606.77	13635.42	15359.0
2020-10-15 05:00:00	NQ	Futures	13634.84	13636.0	13589.4	13629.34	13144.0
2020-10-15 06:00:00	NQ	Futures	13629.34	13688.97	13623.55	13677.69	13437.0
2020-10-15 07:00:00	NQ	Futures	13677.98	13695.92	13651.63	13664.66	11282.0
2020-10-15 08:00:00	NQ	Futures	13664.95	13682.32	13624.71	13659.45	22993.0
2020-10-15 09:00:00	NQ	Futures	13658.58	13755.55	13609.08	13746.0	78289.0
2020-10-15 10:00:00	NQ	Futures	13746.0	13747.74	13601.27	13667.55	98657.0
2020-10-15 11:00:00	NQ	Futures	13667.55	13726.61	13619.5	13684.92	69578.0
2020-10-15 12:00:00	NQ	Futures	13684.92	13708.95	13629.63	13671.61	54178.0
2020-10-15 13:00:00	NQ	Futures	13671.32	13710.68	13641.5	13702.58	40757.0
2020-10-15 14:00:00	NQ	Futures	13702.87	13733.55	13683.76	13721.11	38156.0
2020-10-15 15:00:00	NQ	Futures	13721.11	13800.13	13715.9	13767.42	62305.0
2020-10-15 16:00:00	NQ	Futures	13767.13	13782.47	13746.0	13760.18	11083.0
2020-10-15 18:00:00	NQ	Futures	13768.29	13786.24	13764.53	13765.11	2461.0
2020-10-15 19:00:00	NQ	Futures	13765.97	13816.63	13765.97	13796.66	4951.0
2020-10-15 20:00:00	NQ	Futures	13797.53	13806.79	13774.66	13793.18	4564.0
2020-10-15 21:00:00	NQ	Futures	13794.63	13826.76	13785.95	13796.95	5446.0
2020-10-15 22:00:00	NQ	Futures	13796.08	13801.87	13791.16	13792.6	1781.0
2020-10-15 23:00:00	NQ	Futures	13793.47	13795.5	13692.45	13729.21	9327.0
2020-10-15 00:00:00	YM	Futures	31299.0	31347.6	31273.6	31327.7	1932.0
2020-10-15 01:00:00	YM	Futures	31327.7	31374.2	31318.9	31328.8	1987.0
2020-10-15 02:00:00	YM	Futures	31329.9	31331.0	31258.1	31271.3	4356.0
2020-10-15 03:00:00	YM	Futures	31270.2	31295.7	31206.1	31262.5	9689.0

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

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