PREVIEW / futures_1hour / 2019-10-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-10-16.parquet
  size:    59 KB
  rows:    1,870

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-16 00:00:00	ES	Futures	3246.81	3247.62	3244.9	3247.08	6403.0
2019-10-16 01:00:00	ES	Futures	3247.35	3249.52	3245.99	3247.35	7439.0
2019-10-16 02:00:00	ES	Futures	3247.35	3254.95	3246.81	3251.15	14947.0
2019-10-16 03:00:00	ES	Futures	3250.88	3253.6	3245.99	3249.52	26419.0
2019-10-16 04:00:00	ES	Futures	3249.79	3250.06	3244.9	3247.89	16669.0
2019-10-16 05:00:00	ES	Futures	3247.62	3248.16	3243.0	3247.08	24266.0
2019-10-16 06:00:00	ES	Futures	3247.08	3251.15	3246.53	3248.98	19429.0
2019-10-16 07:00:00	ES	Futures	3248.98	3252.51	3246.81	3250.61	20037.0
2019-10-16 08:00:00	ES	Futures	3250.34	3256.31	3247.62	3250.88	47521.0
2019-10-16 09:00:00	ES	Futures	3250.88	3251.15	3244.36	3245.72	145838.0
2019-10-16 10:00:00	ES	Futures	3245.99	3255.5	3243.0	3255.23	156923.0
2019-10-16 11:00:00	ES	Futures	3254.95	3256.86	3248.98	3251.69	111431.0
2019-10-16 12:00:00	ES	Futures	3251.69	3253.6	3245.99	3246.53	68911.0
2019-10-16 13:00:00	ES	Futures	3246.53	3248.16	3244.09	3245.18	81327.0
2019-10-16 14:00:00	ES	Futures	3245.18	3251.97	3244.36	3250.34	72246.0
2019-10-16 15:00:00	ES	Futures	3250.06	3250.34	3245.45	3249.25	141890.0
2019-10-16 16:00:00	ES	Futures	3249.25	3251.42	3248.71	3251.15	67907.0
2019-10-16 18:00:00	ES	Futures	3251.15	3251.69	3247.08	3247.62	5639.0
2019-10-16 19:00:00	ES	Futures	3247.35	3249.25	3245.72	3246.26	3899.0
2019-10-16 20:00:00	ES	Futures	3246.53	3248.16	3244.09	3247.62	8906.0
2019-10-16 21:00:00	ES	Futures	3247.89	3250.61	3246.81	3250.06	9627.0
2019-10-16 22:00:00	ES	Futures	3250.06	3251.69	3249.25	3249.79	6176.0
2019-10-16 23:00:00	ES	Futures	3249.52	3250.06	3247.62	3248.71	3095.0
2019-10-16 00:00:00	NQ	Futures	9223.13	9225.16	9216.74	9223.42	2911.0
2019-10-16 01:00:00	NQ	Futures	9223.42	9229.81	9219.64	9224.87	2936.0
2019-10-16 02:00:00	NQ	Futures	9224.29	9247.82	9223.13	9237.36	6505.0
2019-10-16 03:00:00	NQ	Futures	9237.07	9245.21	9221.1	9231.85	10114.0
2019-10-16 04:00:00	NQ	Futures	9232.14	9233.88	9217.9	9224.87	6822.0
2019-10-16 05:00:00	NQ	Futures	9224.58	9228.65	9209.48	9224.87	7508.0
2019-10-16 06:00:00	NQ	Futures	9225.45	9235.91	9220.52	9225.45	6358.0
2019-10-16 07:00:00	NQ	Futures	9225.75	9231.85	9218.77	9223.42	7857.0
2019-10-16 08:00:00	NQ	Futures	9223.13	9242.59	9215.29	9223.71	14490.0
2019-10-16 09:00:00	NQ	Futures	9223.71	9225.45	9198.73	9203.67	51641.0
2019-10-16 10:00:00	NQ	Futures	9203.38	9235.04	9188.27	9232.43	52939.0
2019-10-16 11:00:00	NQ	Futures	9232.14	9241.14	9204.83	9215.87	34194.0
2019-10-16 12:00:00	NQ	Futures	9215.87	9223.42	9199.89	9200.76	21110.0
2019-10-16 13:00:00	NQ	Futures	9201.05	9211.22	9195.24	9199.02	24954.0
2019-10-16 14:00:00	NQ	Futures	9199.02	9219.94	9197.57	9216.74	18835.0
2019-10-16 15:00:00	NQ	Futures	9217.03	9224.87	9201.92	9218.77	32680.0
2019-10-16 16:00:00	NQ	Futures	9218.77	9242.01	9209.77	9242.01	16889.0
2019-10-16 18:00:00	NQ	Futures	9242.59	9247.53	9227.49	9229.52	2771.0
2019-10-16 19:00:00	NQ	Futures	9229.23	9232.43	9221.97	9225.16	1878.0
2019-10-16 20:00:00	NQ	Futures	9225.45	9230.1	9217.61	9230.1	3201.0
2019-10-16 21:00:00	NQ	Futures	9230.39	9236.2	9224.0	9234.75	5877.0
2019-10-16 22:00:00	NQ	Futures	9234.75	9241.43	9232.43	9235.04	2453.0
2019-10-16 23:00:00	NQ	Futures	9235.04	9237.07	9229.52	9232.43	1454.0
2019-10-16 00:00:00	YM	Futures	29302.8	29314.8	29289.7	29311.5	1537.0
2019-10-16 01:00:00	YM	Futures	29313.7	29326.7	29299.5	29313.7	1643.0
2019-10-16 02:00:00	YM	Futures	29312.6	29376.8	29310.4	29334.4	3549.0
2019-10-16 03:00:00	YM	Futures	29333.3	29357.2	29291.9	29323.5	6621.0

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

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