PREVIEW / futures_1hour / 2019-10-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-18.parquet
  size:    50 KB
  rows:    1,506

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
2019-10-18 00:00:00	ES	Futures	3252.51	3253.6	3251.69	3252.78	2685.0
2019-10-18 01:00:00	ES	Futures	3252.78	3254.41	3248.43	3249.25	8598.0
2019-10-18 02:00:00	ES	Futures	3249.25	3253.05	3248.98	3252.24	9272.0
2019-10-18 03:00:00	ES	Futures	3252.24	3255.23	3247.62	3254.14	25178.0
2019-10-18 04:00:00	ES	Futures	3254.14	3256.58	3252.51	3255.5	11913.0
2019-10-18 05:00:00	ES	Futures	3255.23	3258.49	3253.6	3258.21	16681.0
2019-10-18 06:00:00	ES	Futures	3258.21	3258.76	3255.77	3258.49	12235.0
2019-10-18 07:00:00	ES	Futures	3258.49	3260.93	3257.67	3259.57	15703.0
2019-10-18 08:00:00	ES	Futures	3259.57	3260.66	3256.86	3257.13	16468.0
2019-10-18 09:00:00	ES	Futures	3257.13	3258.49	3248.43	3257.67	178325.0
2019-10-18 10:00:00	ES	Futures	3257.4	3257.67	3244.9	3250.06	185609.0
2019-10-18 11:00:00	ES	Futures	3250.06	3253.6	3243.0	3243.55	132821.0
2019-10-18 12:00:00	ES	Futures	3243.27	3245.72	3232.41	3241.92	167371.0
2019-10-18 13:00:00	ES	Futures	3241.64	3250.61	3241.37	3249.79	98804.0
2019-10-18 14:00:00	ES	Futures	3249.79	3251.42	3246.81	3250.06	77471.0
2019-10-18 15:00:00	ES	Futures	3250.34	3253.6	3243.27	3243.27	189726.0
2019-10-18 16:00:00	ES	Futures	3243.55	3248.43	3243.0	3247.89	69075.0
2019-10-18 00:00:00	NQ	Futures	9221.1	9225.16	9218.77	9222.55	1239.0
2019-10-18 01:00:00	NQ	Futures	9222.55	9226.04	9208.03	9210.64	3618.0
2019-10-18 02:00:00	NQ	Futures	9210.64	9223.13	9208.32	9217.9	4064.0
2019-10-18 03:00:00	NQ	Futures	9217.9	9228.07	9199.6	9224.0	8787.0
2019-10-18 04:00:00	NQ	Futures	9224.29	9231.56	9219.06	9226.62	5010.0
2019-10-18 05:00:00	NQ	Futures	9226.62	9235.33	9221.68	9233.88	4898.0
2019-10-18 06:00:00	NQ	Futures	9234.17	9236.78	9227.2	9236.2	3294.0
2019-10-18 07:00:00	NQ	Futures	9235.33	9246.37	9233.59	9242.3	6843.0
2019-10-18 08:00:00	NQ	Futures	9242.01	9246.08	9236.2	9237.07	7539.0
2019-10-18 09:00:00	NQ	Futures	9237.07	9247.53	9220.23	9237.95	50115.0
2019-10-18 10:00:00	NQ	Futures	9237.66	9238.82	9176.36	9194.66	64159.0
2019-10-18 11:00:00	NQ	Futures	9194.66	9200.76	9138.02	9140.92	57997.0
2019-10-18 12:00:00	NQ	Futures	9140.63	9155.16	9104.9	9140.05	71077.0
2019-10-18 13:00:00	NQ	Futures	9139.76	9173.46	9138.31	9168.81	34877.0
2019-10-18 14:00:00	NQ	Futures	9169.1	9178.98	9160.97	9174.33	28296.0
2019-10-18 15:00:00	NQ	Futures	9174.62	9192.34	9150.8	9151.38	47695.0
2019-10-18 16:00:00	NQ	Futures	9151.67	9161.84	9148.76	9159.8	12256.0
2019-10-18 00:00:00	YM	Futures	29347.4	29354.0	29339.8	29346.3	592.0
2019-10-18 01:00:00	YM	Futures	29346.3	29359.4	29307.2	29312.6	1907.0
2019-10-18 02:00:00	YM	Futures	29313.7	29343.1	29309.3	29335.4	2235.0
2019-10-18 03:00:00	YM	Futures	29335.4	29356.1	29289.7	29347.4	4990.0
2019-10-18 04:00:00	YM	Futures	29346.3	29364.8	29326.7	29351.8	3043.0
2019-10-18 05:00:00	YM	Futures	29352.9	29380.1	29340.9	29377.9	3150.0
2019-10-18 06:00:00	YM	Futures	29377.9	29383.3	29360.5	29381.2	2289.0
2019-10-18 07:00:00	YM	Futures	29381.2	29410.5	29375.7	29402.9	3426.0
2019-10-18 08:00:00	YM	Futures	29401.8	29408.4	29356.1	29358.3	3584.0
2019-10-18 09:00:00	YM	Futures	29358.3	29364.8	29258.2	29347.4	20635.0
2019-10-18 10:00:00	YM	Futures	29346.3	29347.4	29231.0	29279.9	19673.0
2019-10-18 11:00:00	YM	Futures	29279.9	29303.9	29233.1	29237.5	13483.0
2019-10-18 12:00:00	YM	Futures	29236.4	29256.0	29123.2	29171.1	20044.0
2019-10-18 13:00:00	YM	Futures	29170.0	29216.8	29160.2	29207.0	10787.0
2019-10-18 14:00:00	YM	Futures	29208.1	29216.8	29133.0	29172.2	8643.0
2019-10-18 15:00:00	YM	Futures	29173.3	29201.6	29093.8	29094.9	16612.0

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

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