PREVIEW / futures_1hour / 2020-02-19

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-02-19.parquet
  size:    59 KB
  rows:    1,890

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-19 00:00:00	ES	Futures	3663.0	3663.8	3661.9	3662.4	6229.0
2020-02-19 01:00:00	ES	Futures	3662.4	3662.7	3660.8	3661.9	5278.0
2020-02-19 02:00:00	ES	Futures	3661.9	3664.6	3660.8	3663.8	13285.0
2020-02-19 03:00:00	ES	Futures	3663.8	3663.8	3657.3	3659.7	26026.0
2020-02-19 04:00:00	ES	Futures	3659.7	3662.2	3659.2	3660.0	18497.0
2020-02-19 05:00:00	ES	Futures	3660.0	3661.6	3659.2	3661.1	10217.0
2020-02-19 06:00:00	ES	Futures	3660.8	3661.6	3658.4	3661.3	12441.0
2020-02-19 07:00:00	ES	Futures	3661.3	3664.3	3660.8	3663.8	24613.0
2020-02-19 08:00:00	ES	Futures	3663.8	3664.6	3661.1	3663.8	26426.0
2020-02-19 09:00:00	ES	Futures	3664.1	3671.6	3661.3	3668.7	204145.0
2020-02-19 10:00:00	ES	Futures	3668.4	3672.7	3666.5	3671.6	149648.0
2020-02-19 11:00:00	ES	Futures	3671.6	3676.3	3671.4	3674.1	120495.0
2020-02-19 12:00:00	ES	Futures	3674.4	3677.1	3673.0	3675.2	61994.0
2020-02-19 13:00:00	ES	Futures	3675.2	3676.3	3672.7	3674.1	43285.0
2020-02-19 14:00:00	ES	Futures	3674.1	3678.7	3672.5	3676.5	68551.0
2020-02-19 15:00:00	ES	Futures	3676.5	3677.1	3669.5	3670.3	183775.0
2020-02-19 16:00:00	ES	Futures	3670.6	3674.1	3670.0	3672.7	67203.0
2020-02-19 18:00:00	ES	Futures	3676.5	3676.8	3673.3	3676.3	14659.0
2020-02-19 19:00:00	ES	Futures	3676.5	3682.8	3676.3	3680.0	22514.0
2020-02-19 20:00:00	ES	Futures	3680.3	3681.1	3673.0	3673.0	19052.0
2020-02-19 21:00:00	ES	Futures	3673.0	3674.6	3665.1	3667.3	28319.0
2020-02-19 22:00:00	ES	Futures	3667.3	3669.2	3660.3	3661.9	23267.0
2020-02-19 23:00:00	ES	Futures	3661.9	3667.0	3660.0	3666.5	13233.0
2020-02-19 00:00:00	NQ	Futures	11181.75	11187.82	11178.86	11182.91	3383.0
2020-02-19 01:00:00	NQ	Futures	11182.91	11183.2	11174.81	11178.57	2955.0
2020-02-19 02:00:00	NQ	Futures	11178.57	11189.56	11175.39	11188.11	7120.0
2020-02-19 03:00:00	NQ	Futures	11187.82	11188.11	11164.69	11173.66	11986.0
2020-02-19 04:00:00	NQ	Futures	11173.66	11188.4	11173.66	11181.17	8608.0
2020-02-19 05:00:00	NQ	Futures	11180.88	11188.69	11178.57	11185.22	4188.0
2020-02-19 06:00:00	NQ	Futures	11184.93	11187.82	11176.84	11186.38	4315.0
2020-02-19 07:00:00	NQ	Futures	11186.38	11203.73	11184.35	11202.28	8798.0
2020-02-19 08:00:00	NQ	Futures	11201.99	11203.15	11193.03	11200.26	10614.0
2020-02-19 09:00:00	NQ	Futures	11199.97	11239.88	11198.52	11233.22	77733.0
2020-02-19 10:00:00	NQ	Futures	11232.65	11246.82	11226.28	11244.21	53413.0
2020-02-19 11:00:00	NQ	Futures	11244.21	11264.74	11243.35	11259.54	41939.0
2020-02-19 12:00:00	NQ	Futures	11259.54	11270.53	11253.47	11263.01	28525.0
2020-02-19 13:00:00	NQ	Futures	11263.01	11265.03	11257.23	11260.41	18330.0
2020-02-19 14:00:00	NQ	Futures	11260.12	11276.31	11253.76	11268.21	28242.0
2020-02-19 15:00:00	NQ	Futures	11268.5	11270.24	11242.77	11252.6	55975.0
2020-02-19 16:00:00	NQ	Futures	11252.6	11263.59	11251.44	11259.54	11037.0
2020-02-19 18:00:00	NQ	Futures	11271.68	11273.13	11260.12	11271.4	8176.0
2020-02-19 19:00:00	NQ	Futures	11271.68	11292.79	11271.68	11285.85	9626.0
2020-02-19 20:00:00	NQ	Futures	11286.14	11289.9	11260.7	11260.99	10119.0
2020-02-19 21:00:00	NQ	Futures	11260.7	11267.35	11230.62	11232.65	14404.0
2020-02-19 22:00:00	NQ	Futures	11232.36	11244.21	11206.33	11211.83	14837.0
2020-02-19 23:00:00	NQ	Futures	11211.54	11236.69	11204.31	11232.94	13905.0
2020-02-19 00:00:00	YM	Futures	31898.0	31906.7	31891.4	31898.0	1262.0
2020-02-19 01:00:00	YM	Futures	31896.9	31901.2	31887.1	31893.6	1364.0
2020-02-19 02:00:00	YM	Futures	31892.5	31916.5	31883.8	31907.8	3579.0
2020-02-19 03:00:00	YM	Futures	31908.9	31908.9	31849.0	31871.8	5953.0

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

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