PREVIEW / futures_1hour / 2019-12-11

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-11.parquet
  size:    52 KB
  rows:    1,668

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-12-11 00:00:00	ES	Futures	3404.89	3407.34	3404.35	3407.07	4110.0
2019-12-11 01:00:00	ES	Futures	3407.07	3407.88	3405.71	3407.07	4004.0
2019-12-11 02:00:00	ES	Futures	3407.34	3408.15	3404.08	3405.17	8601.0
2019-12-11 03:00:00	ES	Futures	3405.44	3415.49	3403.26	3403.26	42752.0
2019-12-11 04:00:00	ES	Futures	3403.26	3406.8	3402.18	3405.44	17583.0
2019-12-11 05:00:00	ES	Futures	3405.71	3407.61	3403.54	3405.98	12350.0
2019-12-11 06:00:00	ES	Futures	3405.98	3408.97	3404.08	3408.43	11435.0
2019-12-11 07:00:00	ES	Futures	3408.7	3411.14	3407.07	3409.78	15498.0
2019-12-11 08:00:00	ES	Futures	3409.78	3413.04	3409.24	3411.96	24113.0
2019-12-11 09:00:00	ES	Futures	3411.96	3414.13	3405.71	3413.86	132043.0
2019-12-11 10:00:00	ES	Futures	3413.86	3414.94	3407.07	3407.61	127430.0
2019-12-11 11:00:00	ES	Futures	3407.61	3410.06	3404.89	3406.25	103083.0
2019-12-11 12:00:00	ES	Futures	3406.25	3407.61	3404.89	3406.8	56693.0
2019-12-11 13:00:00	ES	Futures	3406.8	3407.88	3404.62	3407.61	47075.0
2019-12-11 14:00:00	ES	Futures	3407.61	3416.3	3405.98	3416.03	145941.0
2019-12-11 15:00:00	ES	Futures	3416.03	3416.57	3409.78	3413.59	201245.0
2019-12-11 16:00:00	ES	Futures	3413.59	3416.57	3412.23	3416.3	46620.0
2019-12-11 18:00:00	ES	Futures	3416.03	3418.48	3415.49	3418.2	5695.0
2019-12-11 19:00:00	ES	Futures	3418.2	3418.48	3414.67	3416.03	11207.0
2019-12-11 20:00:00	ES	Futures	3416.03	3419.56	3415.76	3419.02	10456.0
2019-12-11 21:00:00	ES	Futures	3419.02	3420.11	3417.93	3418.75	7384.0
2019-12-11 22:00:00	ES	Futures	3418.48	3419.02	3417.66	3418.48	3630.0
2019-12-11 23:00:00	ES	Futures	3418.48	3419.02	3418.2	3418.48	1637.0
2019-12-11 00:00:00	NQ	Futures	9713.48	9721.33	9711.16	9719.87	1922.0
2019-12-11 01:00:00	NQ	Futures	9719.87	9725.1	9716.1	9723.36	2203.0
2019-12-11 02:00:00	NQ	Futures	9723.36	9726.26	9712.32	9716.97	3775.0
2019-12-11 03:00:00	NQ	Futures	9716.68	9753.57	9710.87	9712.61	16883.0
2019-12-11 04:00:00	NQ	Futures	9712.03	9723.65	9707.96	9718.13	7935.0
2019-12-11 05:00:00	NQ	Futures	9718.42	9725.68	9712.03	9720.74	5647.0
2019-12-11 06:00:00	NQ	Futures	9720.74	9732.36	9716.1	9730.91	5562.0
2019-12-11 07:00:00	NQ	Futures	9731.49	9739.34	9726.26	9735.27	6550.0
2019-12-11 08:00:00	NQ	Futures	9735.27	9746.02	9733.24	9742.82	9508.0
2019-12-11 09:00:00	NQ	Futures	9743.11	9748.34	9718.13	9748.05	38992.0
2019-12-11 10:00:00	NQ	Futures	9747.76	9755.89	9734.69	9736.43	38157.0
2019-12-11 11:00:00	NQ	Futures	9735.85	9746.02	9726.55	9734.98	25660.0
2019-12-11 12:00:00	NQ	Futures	9734.98	9738.46	9727.13	9734.69	13193.0
2019-12-11 13:00:00	NQ	Futures	9734.69	9742.24	9731.2	9741.37	11307.0
2019-12-11 14:00:00	NQ	Futures	9741.37	9769.26	9732.65	9769.26	39953.0
2019-12-11 15:00:00	NQ	Futures	9769.26	9773.32	9754.15	9765.77	40021.0
2019-12-11 16:00:00	NQ	Futures	9765.48	9770.71	9760.83	9769.55	7596.0
2019-12-11 18:00:00	NQ	Futures	9769.26	9778.55	9766.35	9777.68	2309.0
2019-12-11 19:00:00	NQ	Futures	9777.39	9778.26	9765.77	9769.55	3527.0
2019-12-11 20:00:00	NQ	Futures	9769.55	9780.59	9767.51	9780.0	3623.0
2019-12-11 21:00:00	NQ	Futures	9780.29	9782.33	9776.81	9777.68	2551.0
2019-12-11 22:00:00	NQ	Futures	9777.68	9778.26	9774.49	9777.1	1378.0
2019-12-11 23:00:00	NQ	Futures	9776.81	9778.26	9775.94	9775.94	725.0
2019-12-11 00:00:00	YM	Futures	30362.8	30377.0	30360.7	30377.0	8.0
2019-12-11 01:00:00	YM	Futures	30377.0	30384.6	30373.7	30383.5	34.0
2019-12-11 02:00:00	YM	Futures	30383.5	30383.5	30353.0	30361.8	27.0
2019-12-11 03:00:00	YM	Futures	30363.9	30455.4	30335.6	30335.6	194.0

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

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