PREVIEW / futures_1hour / 2020-07-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-07-27.parquet
  size:    60 KB
  rows:    1,823

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-07-27 00:00:00	ES	Futures	3596.94	3598.61	3594.7	3594.98	4656.0
2020-07-27 01:00:00	ES	Futures	3594.98	3596.66	3590.51	3590.79	7285.0
2020-07-27 02:00:00	ES	Futures	3590.79	3594.42	3588.0	3592.19	11292.0
2020-07-27 03:00:00	ES	Futures	3591.91	3595.26	3584.37	3590.79	24376.0
2020-07-27 04:00:00	ES	Futures	3590.79	3596.66	3590.23	3590.79	14819.0
2020-07-27 05:00:00	ES	Futures	3590.79	3598.33	3589.4	3596.38	14746.0
2020-07-27 06:00:00	ES	Futures	3596.38	3600.01	3593.86	3597.21	14664.0
2020-07-27 07:00:00	ES	Futures	3597.21	3600.29	3591.63	3600.01	17737.0
2020-07-27 08:00:00	ES	Futures	3600.01	3600.57	3589.4	3593.58	30364.0
2020-07-27 09:00:00	ES	Futures	3593.31	3604.48	3582.42	3603.08	175225.0
2020-07-27 10:00:00	ES	Futures	3603.36	3606.99	3600.29	3603.08	149028.0
2020-07-27 11:00:00	ES	Futures	3602.8	3603.36	3586.88	3595.26	164461.0
2020-07-27 12:00:00	ES	Futures	3595.26	3601.4	3593.31	3600.29	60989.0
2020-07-27 13:00:00	ES	Futures	3600.57	3604.48	3599.45	3601.4	51201.0
2020-07-27 14:00:00	ES	Futures	3601.68	3606.15	3597.77	3600.29	84251.0
2020-07-27 15:00:00	ES	Futures	3600.29	3612.01	3599.73	3608.94	291647.0
2020-07-27 16:00:00	ES	Futures	3608.94	3613.41	3608.11	3612.85	37323.0
2020-07-27 18:00:00	ES	Futures	3613.41	3616.76	3612.57	3613.97	6200.0
2020-07-27 19:00:00	ES	Futures	3613.97	3616.48	3610.06	3614.53	7073.0
2020-07-27 20:00:00	ES	Futures	3614.81	3620.67	3613.41	3620.11	11958.0
2020-07-27 21:00:00	ES	Futures	3620.11	3626.54	3620.11	3621.51	22777.0
2020-07-27 22:00:00	ES	Futures	3621.51	3625.98	3620.11	3621.51	8857.0
2020-07-27 23:00:00	ES	Futures	3621.51	3621.79	3609.5	3612.57	23081.0
2020-07-27 00:00:00	NQ	Futures	12179.62	12194.37	12175.57	12177.89	2598.0
2020-07-27 01:00:00	NQ	Futures	12177.31	12182.51	12155.04	12157.93	4151.0
2020-07-27 02:00:00	NQ	Futures	12157.07	12183.09	12153.02	12176.44	6717.0
2020-07-27 03:00:00	NQ	Futures	12176.44	12180.49	12138.85	12166.61	10093.0
2020-07-27 04:00:00	NQ	Futures	12167.19	12180.2	12158.51	12167.48	4498.0
2020-07-27 05:00:00	NQ	Futures	12168.05	12205.65	12164.3	12199.86	5661.0
2020-07-27 06:00:00	NQ	Futures	12199.57	12245.27	12188.01	12225.31	9056.0
2020-07-27 07:00:00	NQ	Futures	12225.02	12233.41	12201.6	12232.25	7799.0
2020-07-27 08:00:00	NQ	Futures	12232.25	12232.25	12188.59	12202.47	11496.0
2020-07-27 09:00:00	NQ	Futures	12201.89	12295.29	12161.4	12284.02	67502.0
2020-07-27 10:00:00	NQ	Futures	12284.3	12302.52	12229.94	12258.57	63633.0
2020-07-27 11:00:00	NQ	Futures	12258.57	12264.06	12158.8	12213.74	54840.0
2020-07-27 12:00:00	NQ	Futures	12213.46	12254.23	12201.6	12251.05	31924.0
2020-07-27 13:00:00	NQ	Futures	12251.63	12278.23	12249.31	12273.03	21311.0
2020-07-27 14:00:00	NQ	Futures	12273.03	12325.08	12271.0	12292.11	39295.0
2020-07-27 15:00:00	NQ	Futures	12291.53	12353.13	12290.38	12331.15	53745.0
2020-07-27 16:00:00	NQ	Futures	12331.15	12358.33	12327.39	12356.02	7490.0
2020-07-27 18:00:00	NQ	Futures	12356.6	12382.62	12353.71	12373.95	3831.0
2020-07-27 19:00:00	NQ	Futures	12374.53	12384.94	12355.73	12374.82	3650.0
2020-07-27 20:00:00	NQ	Futures	12375.68	12417.62	12368.17	12414.43	5450.0
2020-07-27 21:00:00	NQ	Futures	12414.15	12444.51	12413.86	12426.29	9276.0
2020-07-27 22:00:00	NQ	Futures	12425.13	12440.17	12415.88	12422.24	4551.0
2020-07-27 23:00:00	NQ	Futures	12422.53	12423.11	12359.49	12372.21	8921.0
2020-07-27 00:00:00	YM	Futures	29135.1	29147.2	29117.4	29121.8	697.0
2020-07-27 01:00:00	YM	Futures	29120.7	29126.3	29084.4	29086.6	1582.0
2020-07-27 02:00:00	YM	Futures	29086.6	29113.0	29056.9	29087.7	1969.0
2020-07-27 03:00:00	YM	Futures	29087.7	29115.2	29007.3	29066.8	4611.0

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

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