PREVIEW / futures_1hour / 2019-09-26

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-26.parquet
  size:    59 KB
  rows:    1,854

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-26 00:00:00	ES	Futures	3241.37	3241.92	3238.93	3240.01	4357.0
2019-09-26 01:00:00	ES	Futures	3240.01	3241.37	3236.21	3240.29	13998.0
2019-09-26 02:00:00	ES	Futures	3240.56	3242.46	3237.3	3237.57	10457.0
2019-09-26 03:00:00	ES	Futures	3237.57	3247.62	3237.3	3247.08	22838.0
2019-09-26 04:00:00	ES	Futures	3246.81	3254.14	3245.18	3250.88	23127.0
2019-09-26 05:00:00	ES	Futures	3250.61	3251.97	3248.71	3249.25	11463.0
2019-09-26 06:00:00	ES	Futures	3248.98	3251.42	3248.16	3249.79	7995.0
2019-09-26 07:00:00	ES	Futures	3250.06	3252.78	3248.71	3252.24	11503.0
2019-09-26 08:00:00	ES	Futures	3252.24	3252.78	3244.63	3248.71	35870.0
2019-09-26 09:00:00	ES	Futures	3248.71	3249.25	3232.41	3234.85	173935.0
2019-09-26 10:00:00	ES	Futures	3235.12	3240.29	3229.69	3232.95	209337.0
2019-09-26 11:00:00	ES	Futures	3232.68	3232.95	3220.73	3225.07	198458.0
2019-09-26 12:00:00	ES	Futures	3225.07	3235.67	3222.36	3233.22	104352.0
2019-09-26 13:00:00	ES	Futures	3233.22	3236.48	3227.79	3236.48	82240.0
2019-09-26 14:00:00	ES	Futures	3236.21	3243.82	3236.21	3237.3	110614.0
2019-09-26 15:00:00	ES	Futures	3237.3	3247.08	3234.31	3237.57	196571.0
2019-09-26 16:00:00	ES	Futures	3237.57	3240.83	3236.21	3237.3	51698.0
2019-09-26 18:00:00	ES	Futures	3237.57	3241.1	3236.75	3239.2	4582.0
2019-09-26 19:00:00	ES	Futures	3238.93	3240.01	3235.94	3236.21	2784.0
2019-09-26 20:00:00	ES	Futures	3235.94	3237.3	3231.32	3233.77	13026.0
2019-09-26 21:00:00	ES	Futures	3233.77	3235.67	3228.61	3230.51	16921.0
2019-09-26 22:00:00	ES	Futures	3230.78	3235.12	3228.88	3234.31	9594.0
2019-09-26 23:00:00	ES	Futures	3234.31	3234.58	3231.32	3233.22	5999.0
2019-09-26 00:00:00	NQ	Futures	9070.33	9070.91	9057.55	9061.62	2846.0
2019-09-26 01:00:00	NQ	Futures	9061.91	9064.52	9044.48	9063.36	6251.0
2019-09-26 02:00:00	NQ	Futures	9063.36	9070.04	9052.61	9054.35	4222.0
2019-09-26 03:00:00	NQ	Futures	9055.23	9092.41	9053.48	9087.47	9429.0
2019-09-26 04:00:00	NQ	Futures	9087.47	9113.03	9081.66	9100.25	8629.0
2019-09-26 05:00:00	NQ	Futures	9099.38	9105.19	9090.67	9092.99	4393.0
2019-09-26 06:00:00	NQ	Futures	9092.7	9100.25	9088.05	9093.86	3621.0
2019-09-26 07:00:00	NQ	Futures	9093.86	9103.74	9088.34	9102.0	4463.0
2019-09-26 08:00:00	NQ	Futures	9102.0	9104.32	9077.3	9092.12	13564.0
2019-09-26 09:00:00	NQ	Futures	9092.12	9093.86	9024.43	9033.15	63991.0
2019-09-26 10:00:00	NQ	Futures	9033.15	9059.87	9014.85	9030.53	69775.0
2019-09-26 11:00:00	NQ	Futures	9030.53	9032.86	8987.54	9008.46	62698.0
2019-09-26 12:00:00	NQ	Futures	9008.75	9043.03	8997.71	9026.18	39652.0
2019-09-26 13:00:00	NQ	Futures	9026.18	9039.83	9008.75	9039.25	41579.0
2019-09-26 14:00:00	NQ	Futures	9039.54	9064.23	9039.54	9043.9	61704.0
2019-09-26 15:00:00	NQ	Futures	9043.61	9084.57	9042.44	9054.35	53731.0
2019-09-26 16:00:00	NQ	Futures	9054.35	9065.1	9041.86	9046.51	11927.0
2019-09-26 18:00:00	NQ	Futures	9048.25	9056.39	9043.9	9049.13	2029.0
2019-09-26 19:00:00	NQ	Futures	9048.84	9051.74	9037.22	9037.51	1869.0
2019-09-26 20:00:00	NQ	Futures	9037.51	9040.12	9020.08	9027.63	5657.0
2019-09-26 21:00:00	NQ	Futures	9027.92	9034.89	9009.33	9015.43	7784.0
2019-09-26 22:00:00	NQ	Futures	9014.85	9030.53	9010.2	9027.34	4708.0
2019-09-26 23:00:00	NQ	Futures	9027.05	9027.92	9017.46	9021.24	1961.0
2019-09-26 00:00:00	YM	Futures	29321.3	29322.4	29296.3	29306.1	1132.0
2019-09-26 01:00:00	YM	Futures	29306.1	29316.9	29278.9	29312.6	2532.0
2019-09-26 02:00:00	YM	Futures	29312.6	29325.7	29281.0	29283.2	2360.0
2019-09-26 03:00:00	YM	Futures	29285.4	29371.4	29282.1	29361.6	8769.0

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

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