PREVIEW / futures_1hour / 2019-07-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-11.parquet
  size:    59 KB
  rows:    1,843

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-07-11 00:00:00	ES	Futures	3254.42	3254.96	3253.87	3254.42	3450.0
2019-07-11 01:00:00	ES	Futures	3254.42	3254.96	3253.6	3254.15	5251.0
2019-07-11 02:00:00	ES	Futures	3254.15	3254.96	3251.44	3252.79	10123.0
2019-07-11 03:00:00	ES	Futures	3252.52	3253.06	3249.54	3252.25	18335.0
2019-07-11 04:00:00	ES	Futures	3251.98	3253.06	3250.63	3251.44	10397.0
2019-07-11 05:00:00	ES	Futures	3251.44	3255.77	3250.9	3254.96	19427.0
2019-07-11 06:00:00	ES	Futures	3254.96	3255.23	3249.81	3254.42	22032.0
2019-07-11 07:00:00	ES	Futures	3254.42	3254.69	3251.71	3253.06	15715.0
2019-07-11 08:00:00	ES	Futures	3252.79	3254.96	3247.38	3251.17	46123.0
2019-07-11 09:00:00	ES	Futures	3251.17	3255.23	3248.73	3251.98	166046.0
2019-07-11 10:00:00	ES	Futures	3252.25	3253.87	3243.59	3246.3	190881.0
2019-07-11 11:00:00	ES	Futures	3246.3	3254.42	3245.48	3253.6	112693.0
2019-07-11 12:00:00	ES	Futures	3253.87	3254.69	3250.9	3252.79	55443.0
2019-07-11 13:00:00	ES	Futures	3252.79	3253.06	3241.15	3243.32	142287.0
2019-07-11 14:00:00	ES	Futures	3243.32	3247.38	3240.34	3246.57	80804.0
2019-07-11 15:00:00	ES	Futures	3246.57	3252.52	3245.75	3252.25	147141.0
2019-07-11 16:00:00	ES	Futures	3251.98	3253.87	3251.44	3252.79	50462.0
2019-07-11 18:00:00	ES	Futures	3251.71	3253.33	3251.17	3252.52	3625.0
2019-07-11 19:00:00	ES	Futures	3252.52	3254.96	3250.9	3254.42	3848.0
2019-07-11 20:00:00	ES	Futures	3254.42	3261.45	3253.6	3261.45	19682.0
2019-07-11 21:00:00	ES	Futures	3261.45	3262.0	3256.85	3260.91	18637.0
2019-07-11 22:00:00	ES	Futures	3260.91	3261.45	3258.21	3259.56	8621.0
2019-07-11 23:00:00	ES	Futures	3259.83	3262.0	3259.29	3260.37	6963.0
2019-07-11 00:00:00	NQ	Futures	9233.78	9239.88	9232.33	9236.68	1990.0
2019-07-11 01:00:00	NQ	Futures	9237.26	9239.59	9232.33	9236.39	2629.0
2019-07-11 02:00:00	NQ	Futures	9236.39	9238.72	9225.08	9231.46	4360.0
2019-07-11 03:00:00	NQ	Futures	9231.17	9232.33	9217.54	9225.95	5753.0
2019-07-11 04:00:00	NQ	Futures	9225.66	9228.27	9220.73	9223.05	3458.0
2019-07-11 05:00:00	NQ	Futures	9223.34	9241.91	9221.6	9238.14	6034.0
2019-07-11 06:00:00	NQ	Futures	9238.14	9238.72	9216.66	9231.17	6323.0
2019-07-11 07:00:00	NQ	Futures	9230.88	9233.49	9216.95	9224.21	5424.0
2019-07-11 08:00:00	NQ	Futures	9224.5	9233.49	9200.42	9214.34	15423.0
2019-07-11 09:00:00	NQ	Futures	9214.34	9226.53	9203.32	9222.76	56813.0
2019-07-11 10:00:00	NQ	Futures	9222.18	9231.17	9193.74	9208.83	66752.0
2019-07-11 11:00:00	NQ	Futures	9208.83	9232.62	9204.77	9229.72	42503.0
2019-07-11 12:00:00	NQ	Futures	9230.01	9235.52	9217.83	9225.08	24291.0
2019-07-11 13:00:00	NQ	Futures	9225.08	9226.82	9171.98	9181.85	53566.0
2019-07-11 14:00:00	NQ	Futures	9181.85	9187.36	9161.83	9184.17	37897.0
2019-07-11 15:00:00	NQ	Futures	9184.46	9198.39	9174.59	9190.84	41203.0
2019-07-11 16:00:00	NQ	Futures	9190.84	9195.48	9186.2	9189.1	8918.0
2019-07-11 18:00:00	NQ	Futures	9188.52	9191.42	9183.3	9186.2	1357.0
2019-07-11 19:00:00	NQ	Futures	9185.91	9194.61	9182.14	9193.74	1606.0
2019-07-11 20:00:00	NQ	Futures	9193.45	9216.66	9189.97	9216.08	6158.0
2019-07-11 21:00:00	NQ	Futures	9216.37	9218.7	9201.87	9215.21	6631.0
2019-07-11 22:00:00	NQ	Futures	9215.79	9216.66	9205.93	9209.7	2794.0
2019-07-11 23:00:00	NQ	Futures	9209.99	9217.83	9209.7	9211.73	2602.0
2019-07-11 00:00:00	YM	Futures	29276.6	29284.2	29272.2	29275.5	923.0
2019-07-11 01:00:00	YM	Futures	29275.5	29282.0	29264.6	29269.0	1437.0
2019-07-11 02:00:00	YM	Futures	29267.9	29275.5	29250.5	29265.7	2292.0
2019-07-11 03:00:00	YM	Futures	29266.8	29269.0	29238.5	29258.1	3260.0

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

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