PREVIEW / futures_1hour / 2019-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-19.parquet
  size:    58 KB
  rows:    1,824

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-19 00:00:00	ES	Futures	3259.03	3260.93	3258.76	3259.03	6262.0
2019-09-19 01:00:00	ES	Futures	3259.3	3260.66	3257.94	3260.39	6132.0
2019-09-19 02:00:00	ES	Futures	3260.39	3261.74	3256.86	3257.94	8670.0
2019-09-19 03:00:00	ES	Futures	3258.21	3264.73	3250.06	3262.56	41052.0
2019-09-19 04:00:00	ES	Futures	3262.83	3265.28	3260.66	3263.1	24701.0
2019-09-19 05:00:00	ES	Futures	3263.1	3265.28	3259.84	3260.39	18955.0
2019-09-19 06:00:00	ES	Futures	3260.39	3262.83	3259.57	3259.57	10972.0
2019-09-19 07:00:00	ES	Futures	3259.57	3265.82	3259.3	3264.46	14560.0
2019-09-19 08:00:00	ES	Futures	3264.46	3275.6	3263.65	3274.51	37701.0
2019-09-19 09:00:00	ES	Futures	3274.78	3281.3	3273.42	3278.04	146580.0
2019-09-19 10:00:00	ES	Futures	3277.77	3285.11	3277.77	3281.3	137044.0
2019-09-19 11:00:00	ES	Futures	3281.03	3286.19	3279.67	3282.66	98618.0
2019-09-19 12:00:00	ES	Futures	3282.66	3284.02	3274.24	3278.31	94713.0
2019-09-19 13:00:00	ES	Futures	3278.31	3280.49	3270.17	3276.68	115405.0
2019-09-19 14:00:00	ES	Futures	3276.68	3277.77	3272.07	3273.97	66232.0
2019-09-19 15:00:00	ES	Futures	3273.97	3275.33	3264.73	3268.54	204458.0
2019-09-19 16:00:00	ES	Futures	3268.54	3270.17	3266.63	3267.72	47530.0
2019-09-19 18:00:00	ES	Futures	3267.18	3271.52	3266.63	3270.71	4596.0
2019-09-19 19:00:00	ES	Futures	3270.71	3272.07	3270.44	3270.71	2664.0
2019-09-19 20:00:00	ES	Futures	3270.98	3270.98	3265.82	3270.44	7877.0
2019-09-19 21:00:00	ES	Futures	3270.71	3272.88	3270.17	3270.71	7106.0
2019-09-19 22:00:00	ES	Futures	3270.71	3272.07	3270.17	3271.25	4322.0
2019-09-19 23:00:00	ES	Futures	3271.25	3272.34	3270.44	3271.25	3072.0
2019-09-19 00:00:00	NQ	Futures	9150.8	9158.35	9150.51	9153.12	2965.0
2019-09-19 01:00:00	NQ	Futures	9152.83	9162.42	9148.47	9162.13	3143.0
2019-09-19 02:00:00	NQ	Futures	9162.42	9165.61	9151.96	9156.9	4011.0
2019-09-19 03:00:00	NQ	Futures	9156.9	9182.46	9124.36	9174.62	17292.0
2019-09-19 04:00:00	NQ	Futures	9174.91	9184.2	9167.36	9176.36	8520.0
2019-09-19 05:00:00	NQ	Futures	9176.36	9183.33	9160.97	9163.87	6950.0
2019-09-19 06:00:00	NQ	Futures	9163.87	9173.17	9158.06	9158.35	4620.0
2019-09-19 07:00:00	NQ	Futures	9158.35	9184.79	9156.61	9179.27	7057.0
2019-09-19 08:00:00	NQ	Futures	9178.98	9222.84	9177.23	9217.03	14616.0
2019-09-19 09:00:00	NQ	Futures	9217.03	9253.92	9206.57	9242.01	54306.0
2019-09-19 10:00:00	NQ	Futures	9242.01	9265.25	9241.72	9251.31	44603.0
2019-09-19 11:00:00	NQ	Futures	9251.31	9259.44	9233.88	9238.53	33965.0
2019-09-19 12:00:00	NQ	Futures	9238.53	9245.79	9203.96	9217.9	32370.0
2019-09-19 13:00:00	NQ	Futures	9217.9	9222.55	9188.85	9215.29	35999.0
2019-09-19 14:00:00	NQ	Futures	9215.0	9224.0	9205.99	9215.0	22178.0
2019-09-19 15:00:00	NQ	Futures	9214.71	9223.42	9195.24	9206.86	46822.0
2019-09-19 16:00:00	NQ	Futures	9207.15	9208.61	9196.7	9199.6	8301.0
2019-09-19 18:00:00	NQ	Futures	9203.96	9212.67	9196.11	9210.35	1517.0
2019-09-19 19:00:00	NQ	Futures	9210.93	9216.45	9210.35	9211.51	1175.0
2019-09-19 20:00:00	NQ	Futures	9211.8	9212.67	9194.95	9212.09	4071.0
2019-09-19 21:00:00	NQ	Futures	9212.09	9224.0	9210.06	9216.45	3671.0
2019-09-19 22:00:00	NQ	Futures	9215.87	9223.42	9214.71	9218.48	2103.0
2019-09-19 23:00:00	NQ	Futures	9217.9	9222.26	9214.71	9219.94	1697.0
2019-09-19 00:00:00	YM	Futures	29467.1	29486.7	29467.1	29470.4	1280.0
2019-09-19 01:00:00	YM	Futures	29472.6	29485.6	29461.7	29483.5	1502.0
2019-09-19 02:00:00	YM	Futures	29482.4	29492.2	29435.6	29448.6	2659.0
2019-09-19 03:00:00	YM	Futures	29448.6	29504.1	29375.7	29485.6	7964.0

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

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