PREVIEW / futures_1hour / 2020-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-18.parquet
  size:    60 KB
  rows:    1,889

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-02-18 00:00:00	ES	Futures	3655.7	3655.7	3652.7	3654.8	7072.0
2020-02-18 01:00:00	ES	Futures	3654.8	3655.7	3652.7	3653.2	8447.0
2020-02-18 02:00:00	ES	Futures	3652.9	3653.2	3645.6	3646.7	24775.0
2020-02-18 03:00:00	ES	Futures	3646.7	3654.8	3646.4	3650.5	35703.0
2020-02-18 04:00:00	ES	Futures	3650.5	3650.8	3643.5	3646.7	24133.0
2020-02-18 05:00:00	ES	Futures	3646.7	3652.9	3644.8	3651.6	30306.0
2020-02-18 06:00:00	ES	Futures	3651.9	3652.1	3646.2	3647.3	18725.0
2020-02-18 07:00:00	ES	Futures	3647.0	3651.1	3645.9	3648.3	21447.0
2020-02-18 08:00:00	ES	Futures	3648.3	3653.5	3647.0	3650.2	36701.0
2020-02-18 09:00:00	ES	Futures	3650.2	3657.8	3649.7	3656.2	229420.0
2020-02-18 10:00:00	ES	Futures	3656.2	3657.3	3644.8	3649.4	251199.0
2020-02-18 11:00:00	ES	Futures	3649.4	3650.5	3637.0	3637.2	196881.0
2020-02-18 12:00:00	ES	Futures	3637.2	3648.1	3637.0	3647.3	115737.0
2020-02-18 13:00:00	ES	Futures	3647.3	3651.1	3645.9	3647.8	73265.0
2020-02-18 14:00:00	ES	Futures	3647.8	3656.2	3644.8	3655.4	118980.0
2020-02-18 15:00:00	ES	Futures	3655.7	3658.4	3650.0	3652.9	184358.0
2020-02-18 16:00:00	ES	Futures	3652.9	3654.8	3651.3	3653.8	61657.0
2020-02-18 18:00:00	ES	Futures	3655.1	3662.4	3653.8	3661.6	12589.0
2020-02-18 19:00:00	ES	Futures	3661.6	3663.5	3658.4	3659.5	13341.0
2020-02-18 20:00:00	ES	Futures	3659.2	3660.8	3655.4	3660.3	15291.0
2020-02-18 21:00:00	ES	Futures	3660.5	3663.8	3659.7	3660.8	11198.0
2020-02-18 22:00:00	ES	Futures	3661.1	3665.4	3660.5	3664.6	9356.0
2020-02-18 23:00:00	ES	Futures	3664.3	3666.0	3662.4	3662.7	7446.0
2020-02-18 00:00:00	NQ	Futures	11079.67	11079.96	11070.42	11077.07	3351.0
2020-02-18 01:00:00	NQ	Futures	11076.78	11080.25	11065.22	11066.95	5112.0
2020-02-18 02:00:00	NQ	Futures	11066.66	11066.95	11028.2	11032.25	14816.0
2020-02-18 03:00:00	NQ	Futures	11032.25	11062.61	11032.25	11048.15	19698.0
2020-02-18 04:00:00	NQ	Futures	11047.86	11048.73	11029.07	11042.95	12124.0
2020-02-18 05:00:00	NQ	Futures	11042.95	11068.97	11036.3	11065.22	12807.0
2020-02-18 06:00:00	NQ	Futures	11065.5	11066.95	11049.89	11054.23	8302.0
2020-02-18 07:00:00	NQ	Futures	11053.65	11075.05	11053.65	11069.84	10624.0
2020-02-18 08:00:00	NQ	Futures	11070.42	11095.87	11065.22	11082.28	17861.0
2020-02-18 09:00:00	NQ	Futures	11082.28	11130.57	11074.76	11129.99	83490.0
2020-02-18 10:00:00	NQ	Futures	11129.99	11136.64	11097.02	11126.23	80695.0
2020-02-18 11:00:00	NQ	Futures	11125.94	11130.86	11079.1	11082.85	66690.0
2020-02-18 12:00:00	NQ	Futures	11082.85	11121.6	11079.1	11117.56	44845.0
2020-02-18 13:00:00	NQ	Futures	11117.84	11138.38	11116.98	11122.47	31747.0
2020-02-18 14:00:00	NQ	Futures	11122.47	11159.77	11113.8	11156.59	43746.0
2020-02-18 15:00:00	NQ	Futures	11156.59	11167.29	11137.8	11145.32	50283.0
2020-02-18 16:00:00	NQ	Futures	11145.32	11154.57	11142.42	11150.81	8376.0
2020-02-18 18:00:00	NQ	Futures	11154.28	11179.15	11151.97	11178.28	6441.0
2020-02-18 19:00:00	NQ	Futures	11178.57	11184.35	11171.63	11175.39	7202.0
2020-02-18 20:00:00	NQ	Futures	11175.68	11179.15	11159.2	11177.13	8334.0
2020-02-18 21:00:00	NQ	Futures	11177.41	11189.27	11173.94	11177.99	6794.0
2020-02-18 22:00:00	NQ	Futures	11177.99	11194.19	11176.55	11189.85	5502.0
2020-02-18 23:00:00	NQ	Futures	11189.85	11194.19	11180.6	11181.46	4162.0
2020-02-18 00:00:00	YM	Futures	31911.0	31911.0	31881.6	31903.4	2235.0
2020-02-18 01:00:00	YM	Futures	31903.4	31914.3	31887.1	31889.3	2972.0
2020-02-18 02:00:00	YM	Futures	31889.3	31891.4	31804.3	31817.4	6620.0
2020-02-18 03:00:00	YM	Futures	31817.4	31891.4	31816.3	31861.0	9323.0

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

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