PREVIEW / futures_1hour / 2019-04-24

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-24.parquet
  size:    56 KB
  rows:    1,770

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-24 00:00:00	ES	Futures	3180.3	3181.93	3179.76	3181.39	3817.0
2019-04-24 01:00:00	ES	Futures	3181.66	3183.01	3181.39	3182.74	5386.0
2019-04-24 02:00:00	ES	Futures	3182.74	3183.28	3181.11	3182.2	4585.0
2019-04-24 03:00:00	ES	Futures	3182.47	3183.28	3180.3	3182.47	13089.0
2019-04-24 04:00:00	ES	Futures	3182.2	3183.28	3179.22	3182.74	12879.0
2019-04-24 05:00:00	ES	Futures	3183.01	3186.54	3182.47	3185.72	13238.0
2019-04-24 06:00:00	ES	Futures	3185.72	3187.35	3184.91	3185.72	11986.0
2019-04-24 07:00:00	ES	Futures	3185.45	3186.54	3184.1	3185.99	16298.0
2019-04-24 08:00:00	ES	Futures	3185.72	3187.35	3184.64	3185.72	17250.0
2019-04-24 09:00:00	ES	Futures	3185.45	3185.72	3178.4	3182.2	187168.0
2019-04-24 10:00:00	ES	Futures	3182.2	3186.81	3180.57	3186.81	171869.0
2019-04-24 11:00:00	ES	Futures	3186.81	3187.62	3181.39	3182.2	91457.0
2019-04-24 12:00:00	ES	Futures	3182.2	3183.55	3178.67	3179.49	65743.0
2019-04-24 13:00:00	ES	Futures	3179.49	3181.39	3175.69	3179.76	88602.0
2019-04-24 14:00:00	ES	Futures	3179.49	3183.83	3178.67	3183.28	59638.0
2019-04-24 15:00:00	ES	Futures	3183.28	3184.91	3176.78	3177.59	184047.0
2019-04-24 16:00:00	ES	Futures	3177.86	3181.39	3174.88	3175.42	76725.0
2019-04-24 18:00:00	ES	Futures	3177.32	3180.03	3176.78	3179.49	5543.0
2019-04-24 19:00:00	ES	Futures	3179.49	3180.03	3178.95	3179.49	2485.0
2019-04-24 20:00:00	ES	Futures	3179.76	3181.39	3178.13	3179.49	6924.0
2019-04-24 21:00:00	ES	Futures	3179.22	3181.39	3178.4	3180.57	5968.0
2019-04-24 22:00:00	ES	Futures	3180.84	3182.47	3180.84	3181.66	6636.0
2019-04-24 23:00:00	ES	Futures	3181.66	3181.93	3180.57	3181.66	5116.0
2019-04-24 00:00:00	NQ	Futures	9103.87	9107.07	9102.7	9106.49	2059.0
2019-04-24 01:00:00	NQ	Futures	9106.78	9110.86	9105.03	9108.53	3268.0
2019-04-24 02:00:00	NQ	Futures	9108.53	9110.27	9103.29	9108.53	2866.0
2019-04-24 03:00:00	NQ	Futures	9108.82	9115.22	9106.2	9113.18	4453.0
2019-04-24 04:00:00	NQ	Futures	9113.48	9116.97	9105.03	9114.35	4827.0
2019-04-24 05:00:00	NQ	Futures	9114.06	9128.91	9112.6	9127.45	5155.0
2019-04-24 06:00:00	NQ	Futures	9128.03	9133.57	9125.7	9129.2	5385.0
2019-04-24 07:00:00	NQ	Futures	9129.2	9130.94	9123.37	9129.2	5832.0
2019-04-24 08:00:00	NQ	Futures	9128.91	9138.81	9125.41	9131.82	8446.0
2019-04-24 09:00:00	NQ	Futures	9131.82	9134.73	9098.34	9112.6	68217.0
2019-04-24 10:00:00	NQ	Futures	9112.6	9133.57	9104.16	9133.27	61334.0
2019-04-24 11:00:00	NQ	Futures	9133.27	9137.35	9112.31	9113.18	38678.0
2019-04-24 12:00:00	NQ	Futures	9113.18	9115.8	9093.68	9096.01	28796.0
2019-04-24 13:00:00	NQ	Futures	9096.01	9111.73	9092.22	9104.16	27507.0
2019-04-24 14:00:00	NQ	Futures	9104.16	9115.51	9100.66	9113.48	19836.0
2019-04-24 15:00:00	NQ	Futures	9113.48	9116.39	9086.69	9088.73	42708.0
2019-04-24 16:00:00	NQ	Futures	9089.02	9145.5	9086.98	9130.07	31832.0
2019-04-24 18:00:00	NQ	Futures	9148.41	9155.98	9144.34	9150.16	4682.0
2019-04-24 19:00:00	NQ	Futures	9149.87	9154.24	9147.54	9153.66	2089.0
2019-04-24 20:00:00	NQ	Futures	9153.66	9162.1	9151.03	9156.28	4333.0
2019-04-24 21:00:00	NQ	Futures	9156.28	9161.52	9153.95	9159.77	3555.0
2019-04-24 22:00:00	NQ	Futures	9160.06	9168.8	9159.19	9164.72	4521.0
2019-04-24 23:00:00	NQ	Futures	9164.72	9167.05	9162.39	9166.76	2495.0
2019-04-24 00:00:00	YM	Futures	28938.5	28955.9	28936.3	28954.8	1568.0
2019-04-24 01:00:00	YM	Futures	28954.8	28972.2	28949.3	28971.1	1736.0
2019-04-24 02:00:00	YM	Futures	28970.0	28975.5	28950.4	28961.3	1548.0
2019-04-24 03:00:00	YM	Futures	28963.5	28970.0	28940.6	28967.8	2725.0

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

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