PREVIEW / futures_1hour / 2019-04-23

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-04-23.parquet
  size:    54 KB
  rows:    1,752

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-23 00:00:00	ES	Futures	3156.99	3158.07	3156.71	3157.8	1780.0
2019-04-23 01:00:00	ES	Futures	3157.8	3160.51	3157.8	3159.7	5347.0
2019-04-23 02:00:00	ES	Futures	3159.97	3160.51	3158.61	3158.61	4674.0
2019-04-23 03:00:00	ES	Futures	3158.61	3158.88	3154.55	3155.63	11947.0
2019-04-23 04:00:00	ES	Futures	3155.9	3158.07	3155.36	3157.26	7986.0
2019-04-23 05:00:00	ES	Futures	3156.99	3157.26	3154.55	3155.63	6265.0
2019-04-23 06:00:00	ES	Futures	3155.63	3156.44	3154.82	3155.9	6923.0
2019-04-23 07:00:00	ES	Futures	3155.9	3160.78	3155.9	3159.7	19249.0
2019-04-23 08:00:00	ES	Futures	3159.7	3162.95	3159.43	3159.43	25730.0
2019-04-23 09:00:00	ES	Futures	3159.7	3165.39	3158.07	3164.85	131065.0
2019-04-23 10:00:00	ES	Futures	3164.85	3171.35	3164.85	3170.81	187173.0
2019-04-23 11:00:00	ES	Futures	3170.81	3182.47	3170.54	3182.2	194959.0
2019-04-23 12:00:00	ES	Futures	3182.2	3187.89	3181.93	3184.64	127216.0
2019-04-23 13:00:00	ES	Futures	3184.64	3185.99	3183.55	3183.83	87388.0
2019-04-23 14:00:00	ES	Futures	3183.83	3186.54	3182.2	3185.18	73435.0
2019-04-23 15:00:00	ES	Futures	3185.45	3185.99	3181.39	3184.64	155345.0
2019-04-23 16:00:00	ES	Futures	3184.91	3187.89	3184.64	3185.72	66274.0
2019-04-23 18:00:00	ES	Futures	3185.18	3186.81	3184.91	3186.54	3707.0
2019-04-23 19:00:00	ES	Futures	3186.27	3187.62	3185.99	3187.08	4311.0
2019-04-23 20:00:00	ES	Futures	3186.81	3187.89	3185.99	3186.81	5220.0
2019-04-23 21:00:00	ES	Futures	3186.81	3187.62	3185.45	3185.72	7802.0
2019-04-23 22:00:00	ES	Futures	3185.72	3185.99	3183.28	3183.83	9849.0
2019-04-23 23:00:00	ES	Futures	3183.83	3184.37	3179.76	3180.03	8320.0
2019-04-23 00:00:00	NQ	Futures	9010.41	9015.06	9009.53	9013.32	1191.0
2019-04-23 01:00:00	NQ	Futures	9013.32	9024.09	9013.32	9020.31	2941.0
2019-04-23 02:00:00	NQ	Futures	9020.89	9024.09	9015.36	9015.65	2563.0
2019-04-23 03:00:00	NQ	Futures	9015.94	9016.23	9000.8	9004.87	4413.0
2019-04-23 04:00:00	NQ	Futures	9004.58	9010.12	9003.13	9004.0	2651.0
2019-04-23 05:00:00	NQ	Futures	9004.0	9005.46	8997.89	9000.8	2242.0
2019-04-23 06:00:00	NQ	Futures	9001.09	9003.42	8996.14	8998.47	3244.0
2019-04-23 07:00:00	NQ	Futures	8998.47	9014.19	8996.14	9011.86	7054.0
2019-04-23 08:00:00	NQ	Futures	9012.15	9022.93	9011.86	9014.19	10419.0
2019-04-23 09:00:00	NQ	Futures	9014.19	9063.4	9010.99	9057.86	67809.0
2019-04-23 10:00:00	NQ	Futures	9057.86	9077.37	9056.41	9066.89	72780.0
2019-04-23 11:00:00	NQ	Futures	9067.18	9105.03	9059.32	9103.58	69432.0
2019-04-23 12:00:00	NQ	Futures	9103.87	9117.84	9100.66	9113.18	44955.0
2019-04-23 13:00:00	NQ	Futures	9113.18	9118.72	9109.4	9113.18	24027.0
2019-04-23 14:00:00	NQ	Futures	9112.89	9125.7	9110.27	9123.67	26397.0
2019-04-23 15:00:00	NQ	Futures	9123.37	9130.36	9103.58	9117.55	51211.0
2019-04-23 16:00:00	NQ	Futures	9117.84	9135.02	9116.97	9121.63	13660.0
2019-04-23 18:00:00	NQ	Futures	9123.08	9125.7	9119.01	9123.96	2179.0
2019-04-23 19:00:00	NQ	Futures	9123.96	9127.74	9123.37	9125.41	1733.0
2019-04-23 20:00:00	NQ	Futures	9125.41	9128.32	9121.92	9124.83	2312.0
2019-04-23 21:00:00	NQ	Futures	9124.54	9127.74	9119.88	9123.96	3801.0
2019-04-23 22:00:00	NQ	Futures	9123.96	9125.12	9114.93	9116.68	4412.0
2019-04-23 23:00:00	NQ	Futures	9117.26	9119.01	9102.99	9103.87	4291.0
2019-04-23 00:00:00	YM	Futures	28830.8	28836.2	28821.0	28830.8	383.0
2019-04-23 01:00:00	YM	Futures	28831.9	28865.6	28831.9	28859.1	1472.0
2019-04-23 02:00:00	YM	Futures	28858.0	28867.8	28848.2	28848.2	1092.0
2019-04-23 03:00:00	YM	Futures	28848.2	28850.4	28811.2	28827.5	2572.0

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

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