PREVIEW / futures_1hour / 2019-04-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-25.parquet
  size:    55 KB
  rows:    1,764

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-04-25 00:00:00	ES	Futures	3181.66	3181.93	3180.57	3181.39	2633.0
2019-04-25 01:00:00	ES	Futures	3181.66	3183.28	3181.39	3183.01	3641.0
2019-04-25 02:00:00	ES	Futures	3183.01	3183.55	3179.49	3179.76	7486.0
2019-04-25 03:00:00	ES	Futures	3179.76	3180.03	3175.69	3177.05	20410.0
2019-04-25 04:00:00	ES	Futures	3177.05	3179.76	3175.15	3179.22	11276.0
2019-04-25 05:00:00	ES	Futures	3178.95	3180.57	3177.59	3178.13	11224.0
2019-04-25 06:00:00	ES	Futures	3178.13	3179.76	3174.07	3177.32	17186.0
2019-04-25 07:00:00	ES	Futures	3177.05	3180.57	3177.05	3180.57	16478.0
2019-04-25 08:00:00	ES	Futures	3180.3	3182.74	3179.49	3179.76	25277.0
2019-04-25 09:00:00	ES	Futures	3179.49	3180.03	3165.66	3172.17	230575.0
2019-04-25 10:00:00	ES	Futures	3172.44	3174.88	3160.24	3170.81	299270.0
2019-04-25 11:00:00	ES	Futures	3170.54	3182.74	3169.19	3180.84	222669.0
2019-04-25 12:00:00	ES	Futures	3180.84	3182.2	3176.78	3178.95	97725.0
2019-04-25 13:00:00	ES	Futures	3178.67	3180.57	3177.32	3180.03	78462.0
2019-04-25 14:00:00	ES	Futures	3180.3	3182.74	3180.03	3181.66	53731.0
2019-04-25 15:00:00	ES	Futures	3181.66	3182.47	3175.15	3175.15	145186.0
2019-04-25 16:00:00	ES	Futures	3175.15	3177.59	3169.73	3170.27	75213.0
2019-04-25 18:00:00	ES	Futures	3170.54	3173.52	3168.37	3170.81	6936.0
2019-04-25 19:00:00	ES	Futures	3171.08	3172.44	3169.73	3169.73	4313.0
2019-04-25 20:00:00	ES	Futures	3170.0	3171.35	3164.31	3165.39	17438.0
2019-04-25 21:00:00	ES	Futures	3165.39	3170.0	3163.49	3168.91	11782.0
2019-04-25 22:00:00	ES	Futures	3168.91	3171.63	3166.2	3169.46	7522.0
2019-04-25 23:00:00	ES	Futures	3169.46	3170.54	3168.64	3169.46	3955.0
2019-04-25 00:00:00	NQ	Futures	9167.05	9168.5	9162.39	9165.3	1906.0
2019-04-25 01:00:00	NQ	Futures	9165.59	9172.87	9164.43	9170.25	2869.0
2019-04-25 02:00:00	NQ	Futures	9170.25	9171.12	9150.45	9152.49	4871.0
2019-04-25 03:00:00	NQ	Futures	9152.78	9153.36	9143.17	9148.12	6345.0
2019-04-25 04:00:00	NQ	Futures	9148.12	9155.98	9142.3	9153.66	4740.0
2019-04-25 05:00:00	NQ	Futures	9153.36	9158.02	9146.67	9149.0	4365.0
2019-04-25 06:00:00	NQ	Futures	9149.0	9157.73	9146.96	9154.82	6233.0
2019-04-25 07:00:00	NQ	Futures	9155.11	9167.92	9154.53	9167.34	5461.0
2019-04-25 08:00:00	NQ	Futures	9167.05	9176.66	9165.3	9169.96	11272.0
2019-04-25 09:00:00	NQ	Futures	9170.25	9171.42	9119.88	9144.92	87816.0
2019-04-25 10:00:00	NQ	Futures	9145.21	9154.82	9074.75	9123.08	111264.0
2019-04-25 11:00:00	NQ	Futures	9123.37	9147.83	9104.45	9140.55	65452.0
2019-04-25 12:00:00	NQ	Futures	9140.84	9146.09	9124.54	9130.65	32698.0
2019-04-25 13:00:00	NQ	Futures	9130.65	9137.06	9122.21	9135.02	21637.0
2019-04-25 14:00:00	NQ	Futures	9135.31	9147.83	9135.02	9144.63	21560.0
2019-04-25 15:00:00	NQ	Futures	9144.34	9144.92	9120.17	9120.46	42835.0
2019-04-25 16:00:00	NQ	Futures	9120.46	9136.77	9077.37	9079.7	32577.0
2019-04-25 18:00:00	NQ	Futures	9083.2	9093.68	9073.0	9086.98	3629.0
2019-04-25 19:00:00	NQ	Futures	9087.27	9091.35	9082.32	9082.9	2100.0
2019-04-25 20:00:00	NQ	Futures	9083.2	9087.56	9061.94	9064.85	9171.0
2019-04-25 21:00:00	NQ	Futures	9064.85	9080.28	9058.74	9076.5	7458.0
2019-04-25 22:00:00	NQ	Futures	9076.79	9084.36	9067.47	9077.95	4611.0
2019-04-25 23:00:00	NQ	Futures	9077.95	9084.36	9075.92	9077.66	2666.0
2019-04-25 00:00:00	YM	Futures	28886.3	28890.6	28880.8	28890.6	762.0
2019-04-25 01:00:00	YM	Futures	28891.7	28906.9	28888.4	28900.4	1084.0
2019-04-25 02:00:00	YM	Futures	28900.4	28903.7	28855.8	28861.2	2466.0
2019-04-25 03:00:00	YM	Futures	28860.2	28863.4	28810.1	28829.7	3820.0

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

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