PREVIEW / futures_1hour / 2019-07-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-07-15.parquet
  size:    56 KB
  rows:    1,813

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-15 00:00:00	ES	Futures	3268.22	3268.49	3267.41	3268.49	1352.0
2019-07-15 01:00:00	ES	Futures	3268.49	3268.76	3267.14	3268.49	2513.0
2019-07-15 02:00:00	ES	Futures	3268.49	3270.12	3266.87	3269.85	7739.0
2019-07-15 03:00:00	ES	Futures	3269.85	3273.91	3269.31	3272.55	26950.0
2019-07-15 04:00:00	ES	Futures	3272.55	3273.37	3267.41	3269.85	21896.0
2019-07-15 05:00:00	ES	Futures	3269.85	3270.12	3266.33	3268.49	16975.0
2019-07-15 06:00:00	ES	Futures	3268.49	3271.2	3267.95	3270.12	12125.0
2019-07-15 07:00:00	ES	Futures	3270.39	3272.28	3269.85	3271.74	11875.0
2019-07-15 08:00:00	ES	Futures	3271.74	3273.09	3270.66	3272.55	20416.0
2019-07-15 09:00:00	ES	Futures	3272.28	3272.82	3264.16	3266.06	109898.0
2019-07-15 10:00:00	ES	Futures	3265.79	3268.76	3263.62	3267.14	122520.0
2019-07-15 11:00:00	ES	Futures	3267.14	3267.95	3263.35	3263.89	76423.0
2019-07-15 12:00:00	ES	Futures	3264.16	3264.7	3262.0	3263.08	54830.0
2019-07-15 13:00:00	ES	Futures	3263.08	3265.79	3262.0	3264.43	41803.0
2019-07-15 14:00:00	ES	Futures	3264.43	3268.22	3264.16	3266.33	54106.0
2019-07-15 15:00:00	ES	Futures	3266.33	3267.95	3264.16	3267.95	132806.0
2019-07-15 16:00:00	ES	Futures	3267.68	3269.03	3266.06	3267.41	45062.0
2019-07-15 18:00:00	ES	Futures	3267.14	3267.68	3265.79	3266.87	3139.0
2019-07-15 19:00:00	ES	Futures	3267.14	3270.39	3266.6	3269.58	4043.0
2019-07-15 20:00:00	ES	Futures	3269.58	3270.66	3268.22	3268.49	7155.0
2019-07-15 21:00:00	ES	Futures	3268.49	3269.58	3266.87	3267.95	7770.0
2019-07-15 22:00:00	ES	Futures	3267.68	3270.39	3266.87	3270.12	5226.0
2019-07-15 23:00:00	ES	Futures	3270.39	3270.39	3269.58	3269.85	3215.0
2019-07-15 00:00:00	NQ	Futures	9243.07	9245.1	9241.33	9243.36	879.0
2019-07-15 01:00:00	NQ	Futures	9243.65	9244.81	9238.14	9242.49	1273.0
2019-07-15 02:00:00	NQ	Futures	9242.2	9253.22	9239.3	9251.77	3000.0
2019-07-15 03:00:00	NQ	Futures	9251.77	9263.96	9250.9	9257.86	5849.0
2019-07-15 04:00:00	NQ	Futures	9257.86	9260.48	9239.88	9249.45	5688.0
2019-07-15 05:00:00	NQ	Futures	9249.74	9251.48	9235.81	9243.07	4070.0
2019-07-15 06:00:00	NQ	Futures	9243.07	9250.61	9240.46	9250.03	3230.0
2019-07-15 07:00:00	NQ	Futures	9249.74	9259.9	9247.71	9257.86	3874.0
2019-07-15 08:00:00	NQ	Futures	9257.57	9267.15	9256.12	9265.12	6284.0
2019-07-15 09:00:00	NQ	Futures	9265.12	9269.18	9240.75	9250.32	39456.0
2019-07-15 10:00:00	NQ	Futures	9250.32	9257.57	9239.59	9252.35	39939.0
2019-07-15 11:00:00	NQ	Futures	9252.64	9261.93	9245.39	9249.16	27330.0
2019-07-15 12:00:00	NQ	Futures	9249.16	9253.51	9239.88	9243.65	16837.0
2019-07-15 13:00:00	NQ	Futures	9243.65	9257.86	9241.04	9255.54	14722.0
2019-07-15 14:00:00	NQ	Futures	9255.54	9267.73	9255.54	9265.99	19155.0
2019-07-15 15:00:00	NQ	Futures	9266.28	9275.27	9262.22	9270.63	29206.0
2019-07-15 16:00:00	NQ	Futures	9270.63	9272.66	9262.51	9265.7	7531.0
2019-07-15 18:00:00	NQ	Futures	9264.54	9268.89	9262.8	9267.73	1132.0
2019-07-15 19:00:00	NQ	Futures	9267.73	9283.4	9264.54	9278.17	2277.0
2019-07-15 20:00:00	NQ	Futures	9277.88	9283.98	9275.27	9276.43	2622.0
2019-07-15 21:00:00	NQ	Futures	9276.72	9282.24	9271.21	9273.82	3220.0
2019-07-15 22:00:00	NQ	Futures	9273.53	9281.66	9270.63	9281.08	1960.0
2019-07-15 23:00:00	NQ	Futures	9281.08	9282.24	9278.17	9281.66	1413.0
2019-07-15 00:00:00	YM	Futures	29731.2	29733.3	29725.7	29732.3	467.0
2019-07-15 01:00:00	YM	Futures	29733.3	29734.4	29719.2	29730.1	832.0
2019-07-15 02:00:00	YM	Futures	29730.1	29751.8	29722.5	29749.7	1989.0
2019-07-15 03:00:00	YM	Futures	29749.7	29794.2	29746.4	29777.9	6169.0

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

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