PREVIEW / futures_1hour / 2020-01-22

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-22.parquet
  size:    60 KB
  rows:    1,899

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-01-22 00:00:00	ES	Futures	3614.5	3616.4	3614.5	3615.3	5513.0
2020-01-22 01:00:00	ES	Futures	3615.3	3616.4	3614.7	3615.3	6819.0
2020-01-22 02:00:00	ES	Futures	3615.6	3615.6	3613.7	3613.9	9097.0
2020-01-22 03:00:00	ES	Futures	3613.9	3615.0	3610.9	3611.2	24622.0
2020-01-22 04:00:00	ES	Futures	3611.2	3613.4	3609.3	3611.5	25185.0
2020-01-22 05:00:00	ES	Futures	3611.5	3613.1	3610.9	3611.8	11873.0
2020-01-22 06:00:00	ES	Futures	3611.8	3613.4	3610.4	3612.6	12989.0
2020-01-22 07:00:00	ES	Futures	3612.8	3615.0	3612.3	3612.3	20553.0
2020-01-22 08:00:00	ES	Futures	3612.3	3613.7	3609.9	3611.2	22054.0
2020-01-22 09:00:00	ES	Futures	3611.2	3615.6	3607.4	3614.5	192423.0
2020-01-22 10:00:00	ES	Futures	3614.5	3617.7	3610.1	3611.2	213367.0
2020-01-22 11:00:00	ES	Futures	3610.9	3611.8	3605.3	3607.7	189540.0
2020-01-22 12:00:00	ES	Futures	3607.4	3609.0	3603.4	3608.8	111225.0
2020-01-22 13:00:00	ES	Futures	3609.0	3611.5	3607.7	3607.7	82162.0
2020-01-22 14:00:00	ES	Futures	3607.7	3610.1	3606.3	3607.4	60642.0
2020-01-22 15:00:00	ES	Futures	3607.4	3607.7	3598.2	3600.4	304168.0
2020-01-22 16:00:00	ES	Futures	3600.4	3600.6	3593.6	3595.8	71195.0
2020-01-22 18:00:00	ES	Futures	3595.8	3598.2	3592.0	3592.8	20211.0
2020-01-22 19:00:00	ES	Futures	3592.8	3597.4	3591.2	3596.3	22787.0
2020-01-22 20:00:00	ES	Futures	3596.3	3599.3	3593.9	3598.2	16743.0
2020-01-22 21:00:00	ES	Futures	3598.2	3600.1	3596.3	3597.7	9286.0
2020-01-22 22:00:00	ES	Futures	3597.9	3598.8	3592.5	3593.1	10877.0
2020-01-22 23:00:00	ES	Futures	3593.1	3596.6	3592.2	3594.4	7688.0
2020-01-22 00:00:00	NQ	Futures	10674.83	10682.06	10673.39	10678.01	2900.0
2020-01-22 01:00:00	NQ	Futures	10678.3	10684.66	10677.14	10679.75	3172.0
2020-01-22 02:00:00	NQ	Futures	10679.75	10681.19	10674.83	10677.14	3943.0
2020-01-22 03:00:00	NQ	Futures	10676.86	10682.35	10666.73	10667.6	11271.0
2020-01-22 04:00:00	NQ	Futures	10667.6	10675.99	10660.66	10669.63	10287.0
2020-01-22 05:00:00	NQ	Futures	10669.63	10678.3	10665.87	10673.67	5581.0
2020-01-22 06:00:00	NQ	Futures	10673.39	10680.9	10670.2	10678.88	5198.0
2020-01-22 07:00:00	NQ	Futures	10679.17	10687.84	10678.59	10680.33	8607.0
2020-01-22 08:00:00	NQ	Futures	10680.33	10682.64	10669.05	10671.65	11193.0
2020-01-22 09:00:00	NQ	Futures	10671.65	10693.05	10655.17	10686.98	64782.0
2020-01-22 10:00:00	NQ	Futures	10687.27	10704.04	10670.78	10685.24	67928.0
2020-01-22 11:00:00	NQ	Futures	10684.95	10689.58	10662.98	10677.43	67098.0
2020-01-22 12:00:00	NQ	Futures	10677.14	10688.42	10664.13	10687.84	44458.0
2020-01-22 13:00:00	NQ	Futures	10688.13	10695.65	10674.25	10674.25	32076.0
2020-01-22 14:00:00	NQ	Futures	10674.54	10684.08	10667.6	10674.25	27022.0
2020-01-22 15:00:00	NQ	Futures	10673.96	10674.83	10629.43	10642.73	83488.0
2020-01-22 16:00:00	NQ	Futures	10642.44	10649.38	10619.31	10627.7	15617.0
2020-01-22 18:00:00	NQ	Futures	10630.01	10639.26	10615.55	10620.76	8795.0
2020-01-22 19:00:00	NQ	Futures	10621.05	10637.24	10615.84	10631.74	12186.0
2020-01-22 20:00:00	NQ	Futures	10632.03	10645.91	10624.8	10644.47	12871.0
2020-01-22 21:00:00	NQ	Futures	10644.18	10652.28	10636.95	10641.58	6485.0
2020-01-22 22:00:00	NQ	Futures	10641.29	10644.76	10621.62	10623.65	6054.0
2020-01-22 23:00:00	NQ	Futures	10623.94	10636.95	10621.05	10628.27	5015.0
2020-01-22 00:00:00	YM	Futures	31880.6	31910.0	31879.5	31896.9	1469.0
2020-01-22 01:00:00	YM	Futures	31898.0	31910.0	31892.5	31892.5	1266.0
2020-01-22 02:00:00	YM	Futures	31893.6	31898.0	31870.8	31872.9	2432.0
2020-01-22 03:00:00	YM	Futures	31871.8	31886.0	31844.6	31852.2	5566.0

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

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