PREVIEW / futures_1hour / 2019-09-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-24.parquet
  size:    60 KB
  rows:    1,878

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-24 00:00:00	ES	Futures	3264.73	3267.72	3263.65	3266.91	5020.0
2019-09-24 01:00:00	ES	Futures	3266.91	3268.81	3265.0	3265.82	6920.0
2019-09-24 02:00:00	ES	Futures	3266.09	3266.09	3262.29	3263.37	10096.0
2019-09-24 03:00:00	ES	Futures	3263.65	3264.46	3261.2	3263.37	12662.0
2019-09-24 04:00:00	ES	Futures	3263.1	3265.82	3262.83	3264.73	13241.0
2019-09-24 05:00:00	ES	Futures	3264.73	3268.26	3264.19	3267.18	10545.0
2019-09-24 06:00:00	ES	Futures	3267.45	3267.45	3264.19	3266.91	10685.0
2019-09-24 07:00:00	ES	Futures	3266.91	3270.17	3266.63	3267.45	14272.0
2019-09-24 08:00:00	ES	Futures	3267.45	3267.45	3262.29	3263.92	17034.0
2019-09-24 09:00:00	ES	Futures	3264.19	3269.62	3261.2	3266.91	120150.0
2019-09-24 10:00:00	ES	Futures	3266.63	3266.91	3256.04	3259.3	228161.0
2019-09-24 11:00:00	ES	Futures	3259.03	3259.57	3240.83	3244.09	203396.0
2019-09-24 12:00:00	ES	Futures	3243.82	3248.16	3217.74	3219.37	322273.0
2019-09-24 13:00:00	ES	Futures	3219.1	3225.89	3214.48	3221.54	185150.0
2019-09-24 14:00:00	ES	Futures	3221.54	3237.57	3214.48	3224.8	321639.0
2019-09-24 15:00:00	ES	Futures	3224.53	3229.15	3216.93	3225.62	269896.0
2019-09-24 16:00:00	ES	Futures	3225.62	3231.05	3225.35	3229.15	75215.0
2019-09-24 18:00:00	ES	Futures	3228.06	3230.78	3223.99	3229.42	12264.0
2019-09-24 19:00:00	ES	Futures	3229.42	3234.04	3229.42	3233.22	8405.0
2019-09-24 20:00:00	ES	Futures	3233.22	3234.31	3224.8	3227.79	19548.0
2019-09-24 21:00:00	ES	Futures	3227.79	3232.95	3227.52	3228.61	10851.0
2019-09-24 22:00:00	ES	Futures	3228.61	3236.75	3228.61	3235.12	10490.0
2019-09-24 23:00:00	ES	Futures	3235.12	3235.4	3232.95	3234.31	5303.0
2019-09-24 00:00:00	NQ	Futures	9149.93	9156.03	9144.41	9153.7	2504.0
2019-09-24 01:00:00	NQ	Futures	9153.7	9161.55	9147.31	9153.12	2979.0
2019-09-24 02:00:00	NQ	Futures	9152.83	9152.83	9139.47	9145.86	5109.0
2019-09-24 03:00:00	NQ	Futures	9146.15	9151.38	9136.27	9143.83	5720.0
2019-09-24 04:00:00	NQ	Futures	9143.83	9155.16	9142.08	9152.83	5264.0
2019-09-24 05:00:00	NQ	Futures	9152.83	9160.38	9150.51	9158.06	3571.0
2019-09-24 06:00:00	NQ	Futures	9157.77	9158.06	9148.18	9155.16	3019.0
2019-09-24 07:00:00	NQ	Futures	9155.74	9166.78	9154.28	9156.9	4388.0
2019-09-24 08:00:00	NQ	Futures	9156.9	9157.19	9141.21	9146.15	6652.0
2019-09-24 09:00:00	NQ	Futures	9146.44	9172.59	9141.21	9163.29	47940.0
2019-09-24 10:00:00	NQ	Futures	9163.0	9164.16	9102.87	9112.45	80104.0
2019-09-24 11:00:00	NQ	Futures	9112.45	9114.49	9036.05	9052.61	73316.0
2019-09-24 12:00:00	NQ	Futures	9052.32	9066.85	8961.11	8967.5	91198.0
2019-09-24 13:00:00	NQ	Futures	8967.5	8991.03	8952.97	8970.98	57762.0
2019-09-24 14:00:00	NQ	Futures	8970.98	9030.53	8949.2	8984.06	97851.0
2019-09-24 15:00:00	NQ	Futures	8984.06	8997.42	8959.94	8984.35	65099.0
2019-09-24 16:00:00	NQ	Futures	8984.06	9003.23	8984.06	8990.45	15784.0
2019-09-24 18:00:00	NQ	Futures	8991.61	9001.49	8972.73	8995.97	6273.0
2019-09-24 19:00:00	NQ	Futures	8995.97	9011.07	8995.97	9008.17	3947.0
2019-09-24 20:00:00	NQ	Futures	9008.75	9011.65	8973.89	8983.18	9893.0
2019-09-24 21:00:00	NQ	Futures	8983.18	9004.68	8982.02	8987.83	6383.0
2019-09-24 22:00:00	NQ	Futures	8988.12	9016.01	8987.54	9010.78	4355.0
2019-09-24 23:00:00	NQ	Futures	9011.07	9011.94	9002.94	9010.2	3162.0
2019-09-24 00:00:00	YM	Futures	29421.4	29442.1	29410.5	29435.6	1353.0
2019-09-24 01:00:00	YM	Futures	29436.7	29453.0	29422.5	29431.2	1386.0
2019-09-24 02:00:00	YM	Futures	29430.1	29430.1	29395.3	29408.4	2790.0
2019-09-24 03:00:00	YM	Futures	29410.5	29414.9	29387.7	29401.8	3184.0

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

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