PREVIEW / futures_1hour / 2019-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-12.parquet
  size:    53 KB
  rows:    1,684

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-03-12 00:00:00	ES	Futures	3033.6	3033.6	3031.97	3032.78	1003.0
2019-03-12 01:00:00	ES	Futures	3032.51	3033.33	3030.34	3030.61	1939.0
2019-03-12 02:00:00	ES	Futures	3030.34	3031.43	3028.71	3030.88	2757.0
2019-03-12 03:00:00	ES	Futures	3030.88	3033.06	3030.61	3032.51	3344.0
2019-03-12 04:00:00	ES	Futures	3032.51	3032.78	3027.08	3029.25	8318.0
2019-03-12 05:00:00	ES	Futures	3028.98	3031.97	3027.62	3027.9	6465.0
2019-03-12 06:00:00	ES	Futures	3027.9	3027.9	3025.18	3025.45	5958.0
2019-03-12 07:00:00	ES	Futures	3025.45	3026.54	3020.56	3023.28	13228.0
2019-03-12 08:00:00	ES	Futures	3023.55	3031.7	3023.01	3030.61	11627.0
2019-03-12 09:00:00	ES	Futures	3030.34	3034.69	3026.27	3031.7	40276.0
2019-03-12 10:00:00	ES	Futures	3031.97	3039.3	3028.98	3036.32	33665.0
2019-03-12 11:00:00	ES	Futures	3036.32	3039.03	3030.34	3038.76	27600.0
2019-03-12 12:00:00	ES	Futures	3038.49	3039.03	3032.78	3035.5	20030.0
2019-03-12 13:00:00	ES	Futures	3035.5	3039.3	3033.33	3037.94	14374.0
2019-03-12 14:00:00	ES	Futures	3037.94	3039.85	3034.41	3036.59	17315.0
2019-03-12 15:00:00	ES	Futures	3036.86	3036.86	3027.9	3033.06	45223.0
2019-03-12 16:00:00	ES	Futures	3033.06	3035.77	3031.16	3034.96	11369.0
2019-03-12 18:00:00	ES	Futures	3033.33	3034.69	3030.61	3032.24	1915.0
2019-03-12 19:00:00	ES	Futures	3032.24	3033.06	3028.17	3031.43	1910.0
2019-03-12 20:00:00	ES	Futures	3031.7	3033.87	3030.34	3030.61	2570.0
2019-03-12 21:00:00	ES	Futures	3030.88	3031.7	3024.37	3026.54	5858.0
2019-03-12 22:00:00	ES	Futures	3026.27	3027.9	3023.28	3024.91	3012.0
2019-03-12 23:00:00	ES	Futures	3024.91	3027.35	3024.64	3027.08	1711.0
2019-03-12 00:00:00	NQ	Futures	8412.72	8413.59	8405.7	8407.16	347.0
2019-03-12 01:00:00	NQ	Futures	8407.46	8409.5	8400.74	8401.9	652.0
2019-03-12 02:00:00	NQ	Futures	8402.2	8405.99	8395.18	8402.2	773.0
2019-03-12 03:00:00	NQ	Futures	8402.2	8412.42	8400.44	8410.09	1463.0
2019-03-12 04:00:00	NQ	Futures	8410.09	8410.09	8390.22	8400.15	2715.0
2019-03-12 05:00:00	NQ	Futures	8400.15	8407.75	8391.39	8392.55	1815.0
2019-03-12 06:00:00	NQ	Futures	8392.26	8392.26	8384.08	8387.59	1158.0
2019-03-12 07:00:00	NQ	Futures	8387.29	8390.22	8372.1	8383.79	3045.0
2019-03-12 08:00:00	NQ	Futures	8383.79	8405.99	8380.57	8401.61	4017.0
2019-03-12 09:00:00	NQ	Futures	8401.03	8405.12	8374.73	8398.11	19448.0
2019-03-12 10:00:00	NQ	Futures	8398.4	8431.42	8384.67	8423.23	16124.0
2019-03-12 11:00:00	NQ	Futures	8422.36	8438.14	8401.32	8437.26	15446.0
2019-03-12 12:00:00	NQ	Futures	8436.38	8441.93	8422.65	8433.75	9437.0
2019-03-12 13:00:00	NQ	Futures	8434.63	8438.43	8422.94	8435.21	4111.0
2019-03-12 14:00:00	NQ	Futures	8434.92	8439.3	8422.07	8430.54	4145.0
2019-03-12 15:00:00	NQ	Futures	8429.66	8430.54	8403.07	8419.73	11386.0
2019-03-12 16:00:00	NQ	Futures	8419.73	8431.71	8414.76	8428.79	3107.0
2019-03-12 18:00:00	NQ	Futures	8425.86	8429.37	8415.35	8422.36	315.0
2019-03-12 19:00:00	NQ	Futures	8422.36	8424.11	8409.5	8419.44	969.0
2019-03-12 20:00:00	NQ	Futures	8419.44	8426.16	8414.47	8415.05	971.0
2019-03-12 21:00:00	NQ	Futures	8415.35	8419.14	8397.23	8405.7	1460.0
2019-03-12 22:00:00	NQ	Futures	8405.12	8409.21	8396.06	8400.15	870.0
2019-03-12 23:00:00	NQ	Futures	8400.44	8411.25	8399.86	8408.04	532.0
2019-03-12 00:00:00	YM	Futures	28032.4	28041.1	28025.9	28032.4	569.0
2019-03-12 01:00:00	YM	Futures	28032.4	28040.1	28010.7	28014.0	1228.0
2019-03-12 02:00:00	YM	Futures	28014.0	28024.8	27991.1	28010.7	1267.0
2019-03-12 03:00:00	YM	Futures	28010.7	28032.4	28006.3	28024.8	1578.0

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

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