PREVIEW / futures_1hour / 2019-03-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-11.parquet
  size:    51 KB
  rows:    1,622

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-11 00:00:00	ES	Futures	2984.99	2988.52	2984.71	2984.99	2762.0
2019-03-11 01:00:00	ES	Futures	2985.26	2986.34	2983.36	2984.17	1956.0
2019-03-11 02:00:00	ES	Futures	2984.44	2986.34	2983.63	2986.34	1500.0
2019-03-11 03:00:00	ES	Futures	2986.34	2991.23	2985.53	2989.6	5846.0
2019-03-11 04:00:00	ES	Futures	2989.87	2990.15	2984.17	2984.17	10957.0
2019-03-11 05:00:00	ES	Futures	2984.17	2987.7	2983.63	2987.7	4467.0
2019-03-11 06:00:00	ES	Futures	2987.7	2988.52	2985.53	2987.43	6176.0
2019-03-11 07:00:00	ES	Futures	2987.43	2990.69	2986.34	2987.97	7037.0
2019-03-11 08:00:00	ES	Futures	2987.97	2993.13	2986.34	2990.96	14307.0
2019-03-11 09:00:00	ES	Futures	2991.23	2999.38	2987.43	2999.11	42787.0
2019-03-11 10:00:00	ES	Futures	2998.84	3009.97	2998.57	3009.43	60744.0
2019-03-11 11:00:00	ES	Futures	3009.43	3015.68	3008.07	3015.4	49105.0
2019-03-11 12:00:00	ES	Futures	3015.4	3017.58	3012.96	3014.05	33297.0
2019-03-11 13:00:00	ES	Futures	3014.05	3020.56	3013.77	3020.02	24536.0
2019-03-11 14:00:00	ES	Futures	3020.02	3021.65	3017.3	3019.48	23044.0
2019-03-11 15:00:00	ES	Futures	3019.48	3024.64	3018.12	3023.28	55143.0
2019-03-11 16:00:00	ES	Futures	3023.28	3028.17	3021.38	3026.54	28726.0
2019-03-11 18:00:00	ES	Futures	3025.18	3035.23	3024.64	3034.69	6965.0
2019-03-11 19:00:00	ES	Futures	3034.69	3034.96	3031.97	3032.51	3852.0
2019-03-11 20:00:00	ES	Futures	3032.78	3034.14	3030.34	3031.7	4855.0
2019-03-11 21:00:00	ES	Futures	3031.97	3033.33	3031.43	3033.06	3209.0
2019-03-11 22:00:00	ES	Futures	3033.06	3034.69	3032.78	3033.6	1962.0
2019-03-11 23:00:00	ES	Futures	3033.33	3034.14	3032.24	3033.6	1685.0
2019-03-11 00:00:00	NQ	Futures	8217.53	8230.1	8217.53	8218.41	1133.0
2019-03-11 01:00:00	NQ	Futures	8218.7	8223.67	8213.73	8218.7	585.0
2019-03-11 02:00:00	NQ	Futures	8218.12	8226.88	8214.61	8226.01	600.0
2019-03-11 03:00:00	NQ	Futures	8226.3	8239.74	8222.79	8235.06	1562.0
2019-03-11 04:00:00	NQ	Futures	8234.77	8237.69	8219.87	8220.16	2512.0
2019-03-11 05:00:00	NQ	Futures	8219.58	8231.27	8216.95	8230.68	2219.0
2019-03-11 06:00:00	NQ	Futures	8230.68	8238.86	8227.47	8232.43	2663.0
2019-03-11 07:00:00	NQ	Futures	8233.02	8246.17	8229.22	8237.11	2696.0
2019-03-11 08:00:00	NQ	Futures	8237.4	8254.35	8230.97	8248.21	3629.0
2019-03-11 09:00:00	NQ	Futures	8247.92	8294.38	8233.6	8291.46	21005.0
2019-03-11 10:00:00	NQ	Futures	8291.46	8322.43	8291.16	8321.26	22799.0
2019-03-11 11:00:00	NQ	Futures	8321.26	8348.14	8317.17	8345.8	17154.0
2019-03-11 12:00:00	NQ	Futures	8345.22	8358.37	8339.08	8347.26	10512.0
2019-03-11 13:00:00	NQ	Futures	8347.56	8366.84	8344.93	8364.5	7553.0
2019-03-11 14:00:00	NQ	Futures	8364.5	8370.06	8352.52	8365.67	7097.0
2019-03-11 15:00:00	NQ	Futures	8365.67	8379.41	8360.71	8374.15	11596.0
2019-03-11 16:00:00	NQ	Futures	8374.15	8387.88	8367.43	8383.5	5460.0
2019-03-11 18:00:00	NQ	Futures	8387.0	8412.13	8375.61	8410.09	1415.0
2019-03-11 19:00:00	NQ	Futures	8410.38	8411.25	8401.03	8405.99	1216.0
2019-03-11 20:00:00	NQ	Futures	8405.7	8412.72	8398.98	8407.46	1660.0
2019-03-11 21:00:00	NQ	Futures	8407.16	8411.84	8404.83	8410.09	1143.0
2019-03-11 22:00:00	NQ	Futures	8411.25	8417.97	8409.5	8411.25	1228.0
2019-03-11 23:00:00	NQ	Futures	8412.13	8414.76	8407.75	8412.72	616.0
2019-03-11 00:00:00	YM	Futures	27664.8	27683.3	27660.5	27665.9	1034.0
2019-03-11 01:00:00	YM	Futures	27667.0	27677.9	27655.0	27658.3	1035.0
2019-03-11 02:00:00	YM	Futures	27658.3	27677.9	27650.7	27677.9	811.0
2019-03-11 03:00:00	YM	Futures	27677.9	27684.4	27650.7	27668.1	3395.0

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

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