PREVIEW / futures_1hour / 2020-09-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-09-10.parquet
  size:    57 KB
  rows:    1,756

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-09-10 00:00:00	ES	Futures	3785.98	3790.45	3784.87	3789.33	6097.0
2020-09-10 01:00:00	ES	Futures	3789.33	3804.41	3789.33	3802.18	9602.0
2020-09-10 02:00:00	ES	Futures	3802.18	3806.93	3798.27	3800.78	14263.0
2020-09-10 03:00:00	ES	Futures	3800.5	3801.9	3775.65	3777.33	40136.0
2020-09-10 04:00:00	ES	Futures	3777.33	3783.19	3769.51	3778.44	30860.0
2020-09-10 05:00:00	ES	Futures	3778.44	3790.73	3774.81	3789.06	16827.0
2020-09-10 06:00:00	ES	Futures	3789.06	3797.71	3773.14	3773.98	31183.0
2020-09-10 07:00:00	ES	Futures	3774.26	3790.45	3773.7	3788.22	27356.0
2020-09-10 08:00:00	ES	Futures	3787.94	3810.28	3784.59	3805.81	61630.0
2020-09-10 09:00:00	ES	Futures	3805.81	3823.96	3804.41	3814.75	183888.0
2020-09-10 10:00:00	ES	Futures	3814.75	3824.8	3781.24	3783.47	261555.0
2020-09-10 11:00:00	ES	Futures	3783.47	3805.81	3775.65	3789.89	240902.0
2020-09-10 12:00:00	ES	Futures	3790.17	3796.32	3766.72	3779.84	199536.0
2020-09-10 13:00:00	ES	Futures	3779.84	3792.13	3769.23	3771.46	135711.0
2020-09-10 14:00:00	ES	Futures	3771.18	3779.56	3730.13	3751.92	301734.0
2020-09-10 15:00:00	ES	Futures	3751.92	3753.03	3716.45	3728.46	338599.0
2020-09-10 16:00:00	ES	Futures	3728.46	3738.79	3723.99	3732.65	61862.0
2020-09-10 18:00:00	ES	Futures	3736.56	3743.82	3735.16	3739.63	6087.0
2020-09-10 19:00:00	ES	Futures	3739.91	3745.21	3737.95	3738.23	5142.0
2020-09-10 20:00:00	ES	Futures	3738.51	3749.4	3733.49	3746.89	11891.0
2020-09-10 21:00:00	ES	Futures	3746.61	3754.15	3746.05	3752.47	9101.0
2020-09-10 22:00:00	ES	Futures	3752.47	3755.83	3749.96	3751.08	6587.0
2020-09-10 23:00:00	ES	Futures	3751.08	3753.59	3749.68	3751.92	3049.0
2020-09-10 00:00:00	NQ	Futures	13133.62	13161.96	13132.46	13158.2	2273.0
2020-09-10 01:00:00	NQ	Futures	13159.65	13217.77	13157.05	13207.07	4392.0
2020-09-10 02:00:00	NQ	Futures	13209.68	13250.45	13199.27	13226.74	6057.0
2020-09-10 03:00:00	NQ	Futures	13225.87	13227.32	13051.21	13068.27	17378.0
2020-09-10 04:00:00	NQ	Futures	13069.42	13118.3	13028.07	13089.09	11331.0
2020-09-10 05:00:00	NQ	Futures	13089.38	13171.79	13076.65	13160.8	8242.0
2020-09-10 06:00:00	NQ	Futures	13160.52	13211.7	13094.0	13109.91	15136.0
2020-09-10 07:00:00	NQ	Futures	13109.91	13211.41	13106.73	13197.53	14446.0
2020-09-10 08:00:00	NQ	Futures	13196.37	13302.21	13182.78	13291.8	28438.0
2020-09-10 09:00:00	NQ	Futures	13292.67	13355.71	13251.9	13307.13	92391.0
2020-09-10 10:00:00	NQ	Futures	13307.13	13379.42	13161.67	13179.6	110432.0
2020-09-10 11:00:00	NQ	Futures	13179.6	13299.9	13133.33	13225.87	104908.0
2020-09-10 12:00:00	NQ	Futures	13226.45	13251.9	13099.21	13165.72	82612.0
2020-09-10 13:00:00	NQ	Futures	13166.59	13205.05	13087.64	13095.45	56361.0
2020-09-10 14:00:00	NQ	Futures	13095.45	13126.97	12885.8	12980.36	124434.0
2020-09-10 15:00:00	NQ	Futures	12980.36	12984.41	12825.65	12906.04	112354.0
2020-09-10 16:00:00	NQ	Futures	12905.17	12942.19	12874.52	12928.88	14530.0
2020-09-10 18:00:00	NQ	Futures	12940.16	12982.38	12940.16	12963.87	3762.0
2020-09-10 19:00:00	NQ	Futures	12967.34	12984.12	12957.22	12958.38	2246.0
2020-09-10 20:00:00	NQ	Futures	12958.67	13009.56	12932.06	12993.37	5330.0
2020-09-10 21:00:00	NQ	Futures	12992.5	13034.43	12989.9	13014.48	5932.0
2020-09-10 22:00:00	NQ	Futures	13015.06	13030.96	12998.0	13002.05	3078.0
2020-09-10 23:00:00	NQ	Futures	13001.76	13015.93	12995.11	13011.59	1568.0
2020-09-10 00:00:00	YM	Futures	30711.9	30727.4	30698.6	30698.6	30.0
2020-09-10 01:00:00	YM	Futures	30757.2	30856.7	30757.2	30849.0	88.0
2020-09-10 02:00:00	YM	Futures	30828.0	30853.4	30777.1	30781.6	25.0
2020-09-10 03:00:00	YM	Futures	30780.4	30807.0	30625.7	30645.6	185.0

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

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