PREVIEW / futures_1hour / 2019-02-25

all futures 1-hour files

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

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-02-25 00:00:00	ES	Futures	3040.12	3040.93	3037.67	3038.76	7230.0
2019-02-25 01:00:00	ES	Futures	3038.76	3042.29	3038.22	3041.48	7572.0
2019-02-25 02:00:00	ES	Futures	3041.75	3043.11	3040.66	3042.02	7435.0
2019-02-25 03:00:00	ES	Futures	3042.29	3044.73	3039.3	3041.75	15741.0
2019-02-25 04:00:00	ES	Futures	3041.75	3044.46	3041.48	3042.56	10615.0
2019-02-25 05:00:00	ES	Futures	3042.83	3046.64	3042.29	3046.36	11477.0
2019-02-25 06:00:00	ES	Futures	3046.09	3047.72	3045.28	3046.09	14733.0
2019-02-25 07:00:00	ES	Futures	3046.36	3046.64	3044.73	3046.36	15985.0
2019-02-25 08:00:00	ES	Futures	3046.64	3050.17	3046.09	3049.89	26143.0
2019-02-25 09:00:00	ES	Futures	3050.17	3054.24	3049.08	3049.35	206306.0
2019-02-25 10:00:00	ES	Futures	3049.35	3056.68	3046.91	3055.87	198550.0
2019-02-25 11:00:00	ES	Futures	3055.6	3056.96	3050.98	3052.61	107005.0
2019-02-25 12:00:00	ES	Futures	3052.61	3053.15	3043.38	3045.28	116592.0
2019-02-25 13:00:00	ES	Futures	3045.55	3047.18	3042.02	3044.73	81885.0
2019-02-25 14:00:00	ES	Futures	3045.01	3047.18	3043.11	3043.92	58760.0
2019-02-25 15:00:00	ES	Futures	3043.65	3044.73	3036.32	3037.94	195294.0
2019-02-25 16:00:00	ES	Futures	3037.94	3039.03	3036.04	3036.86	53439.0
2019-02-25 18:00:00	ES	Futures	3037.13	3037.4	3032.51	3035.77	12755.0
2019-02-25 19:00:00	ES	Futures	3035.77	3037.13	3033.33	3033.6	19549.0
2019-02-25 20:00:00	ES	Futures	3033.33	3035.5	3026.81	3027.9	21883.0
2019-02-25 21:00:00	ES	Futures	3027.9	3028.98	3023.55	3025.45	15394.0
2019-02-25 22:00:00	ES	Futures	3025.18	3027.62	3025.18	3027.08	7051.0
2019-02-25 23:00:00	ES	Futures	3027.35	3027.62	3024.64	3027.35	4807.0
2019-02-25 00:00:00	NQ	Futures	8312.49	8315.12	8305.77	8309.28	2539.0
2019-02-25 01:00:00	NQ	Futures	8309.28	8322.43	8308.11	8320.97	2707.0
2019-02-25 02:00:00	NQ	Futures	8321.26	8326.23	8317.46	8321.84	3149.0
2019-02-25 03:00:00	NQ	Futures	8321.84	8329.15	8312.49	8318.63	5361.0
2019-02-25 04:00:00	NQ	Futures	8318.34	8328.86	8317.75	8325.94	3992.0
2019-02-25 05:00:00	NQ	Futures	8325.94	8337.04	8324.47	8336.45	4219.0
2019-02-25 06:00:00	NQ	Futures	8336.45	8342.59	8334.12	8338.5	4355.0
2019-02-25 07:00:00	NQ	Futures	8338.5	8342.59	8332.95	8340.54	4336.0
2019-02-25 08:00:00	NQ	Futures	8340.54	8355.15	8336.75	8353.69	7802.0
2019-02-25 09:00:00	NQ	Futures	8354.28	8377.36	8351.94	8354.57	58345.0
2019-02-25 10:00:00	NQ	Futures	8354.57	8376.78	8347.56	8372.39	54407.0
2019-02-25 11:00:00	NQ	Futures	8372.69	8378.24	8358.37	8361.29	32063.0
2019-02-25 12:00:00	NQ	Futures	8361.29	8362.46	8318.34	8329.44	39362.0
2019-02-25 13:00:00	NQ	Futures	8329.44	8339.38	8325.64	8336.16	21847.0
2019-02-25 14:00:00	NQ	Futures	8336.16	8348.73	8333.53	8341.13	20737.0
2019-02-25 15:00:00	NQ	Futures	8340.84	8348.43	8316.88	8322.14	44363.0
2019-02-25 16:00:00	NQ	Futures	8322.14	8329.44	8317.46	8322.72	9705.0
2019-02-25 18:00:00	NQ	Futures	8323.89	8324.47	8306.07	8313.66	4192.0
2019-02-25 19:00:00	NQ	Futures	8313.37	8316.29	8302.56	8302.85	7019.0
2019-02-25 20:00:00	NQ	Futures	8303.14	8309.28	8281.52	8287.37	7852.0
2019-02-25 21:00:00	NQ	Futures	8287.66	8289.41	8274.51	8278.6	4657.0
2019-02-25 22:00:00	NQ	Futures	8278.6	8286.78	8278.02	8284.15	2847.0
2019-02-25 23:00:00	NQ	Futures	8284.44	8286.2	8266.91	8279.48	3993.0
2019-02-25 00:00:00	YM	Futures	28314.1	28325.0	28285.9	28298.9	2470.0
2019-02-25 01:00:00	YM	Futures	28298.9	28333.7	28292.4	28330.4	1554.0
2019-02-25 02:00:00	YM	Futures	28330.4	28354.3	28322.8	28343.5	2452.0
2019-02-25 03:00:00	YM	Futures	28343.5	28372.8	28323.9	28343.5	4233.0

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

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