PREVIEW / futures_1hour / 2019-09-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-11.parquet
  size:    54 KB
  rows:    1,717

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-11 00:00:00	ES	Futures	3225.45	3234.38	3225.45	3228.7	18283.0
2019-09-11 01:00:00	ES	Futures	3228.7	3232.22	3226.8	3228.43	12741.0
2019-09-11 02:00:00	ES	Futures	3228.43	3230.86	3226.26	3228.7	12199.0
2019-09-11 03:00:00	ES	Futures	3228.7	3231.68	3223.56	3230.86	26907.0
2019-09-11 04:00:00	ES	Futures	3230.59	3231.95	3225.72	3227.35	30446.0
2019-09-11 05:00:00	ES	Futures	3227.35	3227.35	3221.66	3225.72	27386.0
2019-09-11 06:00:00	ES	Futures	3225.72	3228.16	3224.1	3224.64	13911.0
2019-09-11 07:00:00	ES	Futures	3224.91	3231.41	3224.1	3230.86	26397.0
2019-09-11 08:00:00	ES	Futures	3230.86	3231.68	3228.16	3229.78	21396.0
2019-09-11 09:00:00	ES	Futures	3229.78	3234.38	3221.12	3230.59	204421.0
2019-09-11 10:00:00	ES	Futures	3230.32	3236.01	3229.51	3235.74	197247.0
2019-09-11 11:00:00	ES	Futures	3235.47	3240.07	3233.84	3239.8	138612.0
2019-09-11 12:00:00	ES	Futures	3239.8	3244.67	3239.53	3243.05	99548.0
2019-09-11 13:00:00	ES	Futures	3243.05	3244.94	3240.88	3241.42	73915.0
2019-09-11 14:00:00	ES	Futures	3241.42	3241.96	3238.17	3240.07	61437.0
2019-09-11 15:00:00	ES	Futures	3239.8	3249.54	3239.8	3249.0	205475.0
2019-09-11 16:00:00	ES	Futures	3249.0	3253.06	3247.65	3250.9	72122.0
2019-09-11 18:00:00	ES	Futures	3251.71	3252.25	3250.09	3250.36	4479.0
2019-09-11 19:00:00	ES	Futures	3250.36	3270.12	3250.09	3268.22	40367.0
2019-09-11 20:00:00	ES	Futures	3268.22	3269.03	3263.62	3267.68	26611.0
2019-09-11 21:00:00	ES	Futures	3267.68	3268.76	3262.0	3262.81	15305.0
2019-09-11 22:00:00	ES	Futures	3262.81	3263.62	3260.64	3263.35	10249.0
2019-09-11 23:00:00	ES	Futures	3263.35	3268.49	3262.0	3265.24	9449.0
2019-09-11 00:00:00	NQ	Futures	9067.24	9107.57	9066.08	9083.78	8122.0
2019-09-11 01:00:00	NQ	Futures	9083.78	9098.29	9075.95	9084.36	5738.0
2019-09-11 02:00:00	NQ	Futures	9084.65	9092.77	9076.24	9083.78	4667.0
2019-09-11 03:00:00	NQ	Futures	9084.07	9094.22	9062.31	9089.58	10132.0
2019-09-11 04:00:00	NQ	Futures	9089.87	9094.22	9074.2	9082.33	7889.0
2019-09-11 05:00:00	NQ	Futures	9081.75	9081.75	9043.16	9066.66	12806.0
2019-09-11 06:00:00	NQ	Futures	9066.66	9074.79	9058.25	9061.15	5476.0
2019-09-11 07:00:00	NQ	Futures	9061.15	9096.26	9058.83	9093.06	9261.0
2019-09-11 08:00:00	NQ	Futures	9092.77	9095.09	9081.75	9089.29	9291.0
2019-09-11 09:00:00	NQ	Futures	9089.0	9114.53	9065.79	9107.28	75544.0
2019-09-11 10:00:00	NQ	Futures	9107.57	9133.97	9102.93	9124.4	58264.0
2019-09-11 11:00:00	NQ	Futures	9124.4	9146.16	9117.73	9143.55	36494.0
2019-09-11 12:00:00	NQ	Futures	9143.55	9160.09	9143.55	9150.22	24817.0
2019-09-11 13:00:00	NQ	Futures	9150.51	9155.15	9132.52	9136.01	18985.0
2019-09-11 14:00:00	NQ	Futures	9136.3	9137.17	9120.34	9131.36	19300.0
2019-09-11 15:00:00	NQ	Futures	9131.36	9162.41	9130.2	9156.61	40176.0
2019-09-11 16:00:00	NQ	Futures	9156.61	9174.3	9152.25	9160.38	10247.0
2019-09-11 18:00:00	NQ	Futures	9160.67	9162.7	9153.12	9155.73	1662.0
2019-09-11 19:00:00	NQ	Futures	9155.44	9240.46	9153.7	9230.01	14096.0
2019-09-11 20:00:00	NQ	Futures	9229.72	9232.62	9217.24	9228.85	8105.0
2019-09-11 21:00:00	NQ	Futures	9228.85	9234.36	9207.09	9209.41	6479.0
2019-09-11 22:00:00	NQ	Futures	9209.7	9214.05	9201.29	9213.18	4324.0
2019-09-11 23:00:00	NQ	Futures	9213.47	9235.23	9205.93	9221.02	4155.0
2019-09-11 00:00:00	YM	Futures	29265.8	29330.0	29265.8	29286.5	79.0
2019-09-11 01:00:00	YM	Futures	29279.9	29319.1	29279.9	29288.6	62.0
2019-09-11 02:00:00	YM	Futures	29276.7	29309.3	29272.3	29272.3	15.0
2019-09-11 03:00:00	YM	Futures	29285.4	29323.5	29256.0	29316.9	76.0

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

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