PREVIEW / futures_1hour / 2019-09-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-20.parquet
  size:    50 KB
  rows:    1,503

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-20 00:00:00	ES	Futures	3271.25	3271.8	3269.89	3270.17	2434.0
2019-09-20 01:00:00	ES	Futures	3270.44	3270.71	3267.18	3267.72	4864.0
2019-09-20 02:00:00	ES	Futures	3267.45	3273.42	3267.45	3273.15	7623.0
2019-09-20 03:00:00	ES	Futures	3273.15	3274.78	3269.89	3274.24	14960.0
2019-09-20 04:00:00	ES	Futures	3274.24	3274.51	3270.44	3270.71	15196.0
2019-09-20 05:00:00	ES	Futures	3270.71	3275.6	3270.44	3275.33	14554.0
2019-09-20 06:00:00	ES	Futures	3275.05	3277.5	3273.15	3273.7	18553.0
2019-09-20 07:00:00	ES	Futures	3273.7	3275.33	3272.07	3275.33	14970.0
2019-09-20 08:00:00	ES	Futures	3275.05	3275.87	3270.44	3275.05	31766.0
2019-09-20 09:00:00	ES	Futures	3275.05	3279.13	3272.07	3274.78	178846.0
2019-09-20 10:00:00	ES	Futures	3274.78	3278.59	3272.34	3274.24	139096.0
2019-09-20 11:00:00	ES	Futures	3274.24	3275.6	3268.26	3273.15	100723.0
2019-09-20 12:00:00	ES	Futures	3273.15	3274.51	3268.81	3271.8	66419.0
2019-09-20 13:00:00	ES	Futures	3271.52	3272.34	3243.55	3257.13	295132.0
2019-09-20 14:00:00	ES	Futures	3256.86	3263.1	3254.95	3260.11	118428.0
2019-09-20 15:00:00	ES	Futures	3259.84	3262.56	3250.34	3251.15	221218.0
2019-09-20 16:00:00	ES	Futures	3251.15	3253.87	3245.18	3247.89	106391.0
2019-09-20 00:00:00	NQ	Futures	9219.94	9222.55	9215.29	9216.45	1294.0
2019-09-20 01:00:00	NQ	Futures	9216.74	9217.61	9205.7	9207.15	2239.0
2019-09-20 02:00:00	NQ	Futures	9206.86	9224.58	9206.57	9221.97	3207.0
2019-09-20 03:00:00	NQ	Futures	9222.55	9227.78	9209.77	9224.87	6899.0
2019-09-20 04:00:00	NQ	Futures	9225.16	9226.33	9212.67	9214.71	4185.0
2019-09-20 05:00:00	NQ	Futures	9214.42	9228.07	9213.25	9226.91	4876.0
2019-09-20 06:00:00	NQ	Futures	9226.62	9234.17	9221.68	9223.42	4818.0
2019-09-20 07:00:00	NQ	Futures	9223.71	9227.2	9216.16	9226.62	4189.0
2019-09-20 08:00:00	NQ	Futures	9226.62	9234.17	9212.38	9229.52	9601.0
2019-09-20 09:00:00	NQ	Futures	9229.81	9240.27	9210.06	9210.35	53320.0
2019-09-20 10:00:00	NQ	Futures	9210.64	9223.71	9192.63	9198.15	47436.0
2019-09-20 11:00:00	NQ	Futures	9197.86	9201.34	9159.22	9177.81	42879.0
2019-09-20 12:00:00	NQ	Futures	9177.81	9183.62	9151.38	9167.94	32028.0
2019-09-20 13:00:00	NQ	Futures	9167.94	9171.13	9075.85	9116.23	84691.0
2019-09-20 14:00:00	NQ	Futures	9115.94	9148.47	9111.29	9133.08	41978.0
2019-09-20 15:00:00	NQ	Futures	9133.37	9144.41	9106.06	9108.68	44540.0
2019-09-20 16:00:00	NQ	Futures	9108.68	9115.36	9092.41	9100.25	16721.0
2019-09-20 00:00:00	YM	Futures	29493.3	29500.9	29484.6	29488.9	655.0
2019-09-20 01:00:00	YM	Futures	29488.9	29491.1	29462.8	29465.0	1395.0
2019-09-20 02:00:00	YM	Futures	29463.9	29517.2	29462.8	29511.8	2006.0
2019-09-20 03:00:00	YM	Futures	29512.8	29527.0	29486.7	29523.7	3288.0
2019-09-20 04:00:00	YM	Futures	29523.7	29527.0	29494.3	29497.6	2672.0
2019-09-20 05:00:00	YM	Futures	29496.5	29536.8	29492.2	29530.3	2868.0
2019-09-20 06:00:00	YM	Futures	29530.3	29552.0	29520.5	29522.6	3158.0
2019-09-20 07:00:00	YM	Futures	29523.7	29531.4	29506.3	29530.3	1941.0
2019-09-20 08:00:00	YM	Futures	29530.3	29537.9	29497.6	29536.8	3571.0
2019-09-20 09:00:00	YM	Futures	29535.7	29557.5	29496.5	29531.4	20354.0
2019-09-20 10:00:00	YM	Futures	29531.4	29577.1	29527.0	29544.4	18859.0
2019-09-20 11:00:00	YM	Futures	29543.3	29549.9	29497.6	29530.3	11172.0
2019-09-20 12:00:00	YM	Futures	29530.3	29548.8	29500.9	29521.6	7865.0
2019-09-20 13:00:00	YM	Futures	29523.7	29530.3	29285.4	29363.7	35616.0
2019-09-20 14:00:00	YM	Futures	29363.7	29431.2	29355.0	29388.8	14272.0
2019-09-20 15:00:00	YM	Futures	29388.8	29402.9	29289.7	29293.0	14488.0

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

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