PREVIEW / futures_1hour / 2019-09-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-12.parquet
  size:    57 KB
  rows:    1,763

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-09-12 00:00:00	ES	Futures	3264.97	3265.79	3262.0	3263.35	7125.0
2019-09-12 01:00:00	ES	Futures	3263.35	3263.62	3256.58	3256.85	12064.0
2019-09-12 02:00:00	ES	Futures	3256.85	3260.91	3255.5	3257.94	17979.0
2019-09-12 03:00:00	ES	Futures	3257.94	3262.27	3254.42	3257.94	32165.0
2019-09-12 04:00:00	ES	Futures	3257.94	3258.48	3254.69	3255.77	15075.0
2019-09-12 05:00:00	ES	Futures	3255.77	3256.85	3254.42	3255.77	12873.0
2019-09-12 06:00:00	ES	Futures	3255.5	3256.58	3252.79	3253.87	17355.0
2019-09-12 07:00:00	ES	Futures	3253.87	3262.27	3251.17	3259.02	43333.0
2019-09-12 08:00:00	ES	Futures	3258.75	3261.73	3255.23	3258.21	55202.0
2019-09-12 09:00:00	ES	Futures	3258.21	3263.35	3249.54	3254.96	235703.0
2019-09-12 10:00:00	ES	Futures	3254.96	3270.66	3250.09	3254.69	384918.0
2019-09-12 11:00:00	ES	Futures	3254.42	3265.52	3252.25	3264.97	126480.0
2019-09-12 12:00:00	ES	Futures	3264.97	3268.49	3260.91	3267.68	70189.0
2019-09-12 13:00:00	ES	Futures	3267.68	3272.01	3266.87	3269.03	73082.0
2019-09-12 14:00:00	ES	Futures	3269.31	3271.74	3265.79	3268.49	58856.0
2019-09-12 15:00:00	ES	Futures	3268.76	3269.31	3257.66	3259.02	143598.0
2019-09-12 16:00:00	ES	Futures	3259.29	3262.27	3257.12	3257.66	40454.0
2019-09-12 18:00:00	ES	Futures	3259.29	3264.43	3259.29	3263.62	5400.0
2019-09-12 19:00:00	ES	Futures	3263.62	3264.7	3262.54	3264.43	1860.0
2019-09-12 20:00:00	ES	Futures	3264.43	3266.06	3260.91	3265.52	5830.0
2019-09-12 21:00:00	ES	Futures	3265.24	3266.87	3264.43	3264.7	4051.0
2019-09-12 22:00:00	ES	Futures	3264.7	3265.24	3261.73	3264.7	4240.0
2019-09-12 23:00:00	ES	Futures	3264.7	3265.52	3264.43	3264.97	1613.0
2019-09-12 00:00:00	NQ	Futures	9220.73	9224.5	9212.02	9216.95	2738.0
2019-09-12 01:00:00	NQ	Futures	9216.95	9217.83	9193.16	9193.74	4335.0
2019-09-12 02:00:00	NQ	Futures	9193.74	9207.09	9186.2	9197.52	7134.0
2019-09-12 03:00:00	NQ	Futures	9197.81	9209.7	9180.98	9198.97	11787.0
2019-09-12 04:00:00	NQ	Futures	9198.39	9199.55	9183.01	9186.2	5059.0
2019-09-12 05:00:00	NQ	Futures	9186.2	9191.71	9181.56	9187.94	3395.0
2019-09-12 06:00:00	NQ	Futures	9187.36	9191.42	9175.75	9182.43	5103.0
2019-09-12 07:00:00	NQ	Futures	9182.14	9217.54	9175.75	9206.51	12648.0
2019-09-12 08:00:00	NQ	Futures	9206.51	9224.5	9197.52	9212.6	21861.0
2019-09-12 09:00:00	NQ	Futures	9212.31	9234.07	9179.53	9205.64	74541.0
2019-09-12 10:00:00	NQ	Futures	9205.35	9264.54	9186.78	9209.12	94806.0
2019-09-12 11:00:00	NQ	Futures	9208.83	9230.01	9195.48	9224.5	35646.0
2019-09-12 12:00:00	NQ	Futures	9225.08	9231.75	9205.93	9229.43	22214.0
2019-09-12 13:00:00	NQ	Futures	9229.43	9244.81	9223.05	9231.17	22528.0
2019-09-12 14:00:00	NQ	Futures	9231.46	9240.75	9219.57	9231.17	18692.0
2019-09-12 15:00:00	NQ	Futures	9231.46	9231.75	9189.97	9192.29	36071.0
2019-09-12 16:00:00	NQ	Futures	9192.29	9198.1	9180.4	9181.85	8860.0
2019-09-12 18:00:00	NQ	Futures	9187.36	9203.9	9187.36	9203.61	1473.0
2019-09-12 19:00:00	NQ	Futures	9203.61	9207.67	9199.26	9206.51	1095.0
2019-09-12 20:00:00	NQ	Futures	9206.22	9212.89	9197.52	9209.99	3159.0
2019-09-12 21:00:00	NQ	Futures	9209.7	9217.24	9206.22	9208.83	2589.0
2019-09-12 22:00:00	NQ	Futures	9208.83	9208.83	9198.39	9207.09	1925.0
2019-09-12 23:00:00	NQ	Futures	9206.8	9210.86	9205.93	9208.83	664.0
2019-09-12 00:00:00	YM	Futures	29678.3	29684.8	29648.9	29657.6	84.0
2019-09-12 01:00:00	YM	Futures	29659.8	29659.8	29602.1	29608.6	114.0
2019-09-12 02:00:00	YM	Futures	29599.9	29635.8	29591.2	29614.1	325.0
2019-09-12 03:00:00	YM	Futures	29615.2	29646.7	29580.3	29611.9	237.0

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

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