PREVIEW / futures_1hour / 2019-12-06

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-06.parquet
  size:    49 KB
  rows:    1,476

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-12-06 00:00:00	ES	Futures	3391.31	3392.13	3389.68	3390.5	3616.0
2019-12-06 01:00:00	ES	Futures	3390.23	3398.1	3390.23	3394.57	19385.0
2019-12-06 02:00:00	ES	Futures	3394.57	3395.66	3392.94	3394.3	13122.0
2019-12-06 03:00:00	ES	Futures	3394.03	3395.39	3391.31	3394.84	17493.0
2019-12-06 04:00:00	ES	Futures	3394.84	3397.02	3394.03	3395.93	9468.0
2019-12-06 05:00:00	ES	Futures	3395.93	3396.2	3393.76	3394.57	8666.0
2019-12-06 06:00:00	ES	Futures	3394.3	3397.02	3394.03	3396.47	10965.0
2019-12-06 07:00:00	ES	Futures	3396.47	3396.75	3392.94	3394.03	13246.0
2019-12-06 08:00:00	ES	Futures	3393.76	3410.6	3390.23	3408.7	104962.0
2019-12-06 09:00:00	ES	Futures	3408.7	3416.85	3407.88	3416.03	239656.0
2019-12-06 10:00:00	ES	Futures	3415.76	3420.65	3414.13	3419.29	203070.0
2019-12-06 11:00:00	ES	Futures	3419.02	3423.09	3418.48	3421.46	99812.0
2019-12-06 12:00:00	ES	Futures	3421.46	3423.37	3420.38	3422.55	65050.0
2019-12-06 13:00:00	ES	Futures	3422.55	3423.64	3420.92	3420.92	55554.0
2019-12-06 14:00:00	ES	Futures	3421.19	3422.01	3419.29	3419.83	54075.0
2019-12-06 15:00:00	ES	Futures	3419.56	3423.09	3416.3	3418.2	186574.0
2019-12-06 16:00:00	ES	Futures	3418.48	3419.29	3417.12	3418.75	64393.0
2019-12-06 00:00:00	NQ	Futures	9670.78	9673.39	9665.55	9667.58	1471.0
2019-12-06 01:00:00	NQ	Futures	9667.29	9697.21	9667.0	9685.3	7515.0
2019-12-06 02:00:00	NQ	Futures	9685.3	9689.37	9679.49	9685.3	5729.0
2019-12-06 03:00:00	NQ	Futures	9685.3	9689.37	9676.01	9687.05	6336.0
2019-12-06 04:00:00	NQ	Futures	9687.05	9695.18	9684.72	9691.11	3915.0
2019-12-06 05:00:00	NQ	Futures	9691.11	9693.44	9685.3	9687.63	3193.0
2019-12-06 06:00:00	NQ	Futures	9687.63	9694.89	9686.76	9694.31	2986.0
2019-12-06 07:00:00	NQ	Futures	9694.31	9694.89	9679.2	9685.01	4708.0
2019-12-06 08:00:00	NQ	Futures	9684.72	9739.05	9669.33	9731.49	30497.0
2019-12-06 09:00:00	NQ	Futures	9731.49	9751.83	9723.36	9744.56	56850.0
2019-12-06 10:00:00	NQ	Futures	9744.56	9755.02	9732.36	9746.89	47654.0
2019-12-06 11:00:00	NQ	Futures	9747.18	9756.47	9745.73	9750.37	22332.0
2019-12-06 12:00:00	NQ	Futures	9750.37	9763.45	9749.5	9760.54	17970.0
2019-12-06 13:00:00	NQ	Futures	9760.54	9767.8	9759.67	9761.41	14159.0
2019-12-06 14:00:00	NQ	Futures	9761.41	9766.35	9758.51	9761.12	12544.0
2019-12-06 15:00:00	NQ	Futures	9761.12	9771.58	9755.31	9760.25	34499.0
2019-12-06 16:00:00	NQ	Futures	9760.25	9766.35	9755.31	9766.35	10204.0
2019-12-06 00:00:00	YM	Futures	30158.2	30163.7	30145.2	30149.5	815.0
2019-12-06 01:00:00	YM	Futures	30148.4	30221.4	30147.4	30186.5	3509.0
2019-12-06 02:00:00	YM	Futures	30186.5	30197.4	30171.3	30183.3	2302.0
2019-12-06 03:00:00	YM	Futures	30184.4	30195.2	30159.3	30189.8	3639.0
2019-12-06 04:00:00	YM	Futures	30189.8	30208.3	30185.5	30199.6	2272.0
2019-12-06 05:00:00	YM	Futures	30198.5	30202.9	30178.9	30186.5	1774.0
2019-12-06 06:00:00	YM	Futures	30186.5	30212.7	30184.4	30209.4	2002.0
2019-12-06 07:00:00	YM	Futures	30209.4	30211.6	30175.7	30185.5	2448.0
2019-12-06 08:00:00	YM	Futures	30184.4	30333.5	30143.0	30316.1	17568.0
2019-12-06 09:00:00	YM	Futures	30316.1	30435.8	30311.7	30435.8	30152.0
2019-12-06 10:00:00	YM	Futures	30435.8	30467.3	30406.4	30448.8	22550.0
2019-12-06 11:00:00	YM	Futures	30448.8	30496.7	30445.6	30485.8	11990.0
2019-12-06 12:00:00	YM	Futures	30488.0	30509.8	30475.0	30501.1	7170.0
2019-12-06 13:00:00	YM	Futures	30501.1	30508.7	30484.7	30486.9	6576.0
2019-12-06 14:00:00	YM	Futures	30486.9	30503.3	30478.2	30492.4	7234.0
2019-12-06 15:00:00	YM	Futures	30492.4	30516.3	30473.9	30492.4	15591.0

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

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