PREVIEW / futures_1hour / 2019-12-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-09.parquet
  size:    54 KB
  rows:    1,794

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-09 00:00:00	ES	Futures	3413.04	3413.31	3411.69	3413.04	3603.0
2019-12-09 01:00:00	ES	Futures	3413.04	3416.03	3412.23	3415.76	6261.0
2019-12-09 02:00:00	ES	Futures	3415.49	3417.66	3414.94	3416.85	8045.0
2019-12-09 03:00:00	ES	Futures	3416.85	3417.66	3414.94	3414.94	19976.0
2019-12-09 04:00:00	ES	Futures	3414.94	3415.22	3411.69	3415.22	13371.0
2019-12-09 05:00:00	ES	Futures	3414.94	3417.66	3414.13	3417.39	8485.0
2019-12-09 06:00:00	ES	Futures	3417.39	3417.66	3412.5	3413.31	9850.0
2019-12-09 07:00:00	ES	Futures	3413.31	3416.85	3413.04	3415.49	10893.0
2019-12-09 08:00:00	ES	Futures	3415.22	3416.57	3413.86	3414.67	14309.0
2019-12-09 09:00:00	ES	Futures	3414.4	3421.46	3412.77	3419.56	137936.0
2019-12-09 10:00:00	ES	Futures	3419.83	3422.01	3418.48	3420.11	133637.0
2019-12-09 11:00:00	ES	Futures	3420.38	3420.38	3415.22	3415.49	103548.0
2019-12-09 12:00:00	ES	Futures	3415.76	3416.85	3412.5	3414.94	76400.0
2019-12-09 13:00:00	ES	Futures	3414.67	3415.49	3412.5	3413.86	66112.0
2019-12-09 14:00:00	ES	Futures	3413.86	3414.13	3408.43	3412.23	101500.0
2019-12-09 15:00:00	ES	Futures	3412.5	3414.13	3406.8	3407.88	192173.0
2019-12-09 16:00:00	ES	Futures	3407.88	3408.15	3402.18	3404.08	83831.0
2019-12-09 18:00:00	ES	Futures	3404.62	3407.34	3404.35	3406.25	8607.0
2019-12-09 19:00:00	ES	Futures	3406.25	3407.88	3404.08	3405.17	14011.0
2019-12-09 20:00:00	ES	Futures	3405.17	3407.07	3403.26	3405.17	15101.0
2019-12-09 21:00:00	ES	Futures	3405.17	3409.51	3405.17	3409.24	9449.0
2019-12-09 22:00:00	ES	Futures	3409.24	3410.06	3407.88	3408.7	5961.0
2019-12-09 23:00:00	ES	Futures	3408.7	3408.97	3407.34	3407.34	5178.0
2019-12-09 00:00:00	NQ	Futures	9744.56	9746.31	9741.37	9745.44	1233.0
2019-12-09 01:00:00	NQ	Futures	9745.44	9754.15	9742.24	9751.54	2431.0
2019-12-09 02:00:00	NQ	Futures	9751.25	9758.22	9748.34	9755.31	3897.0
2019-12-09 03:00:00	NQ	Futures	9755.6	9757.93	9749.79	9750.08	5036.0
2019-12-09 04:00:00	NQ	Futures	9749.79	9750.96	9741.08	9750.96	4192.0
2019-12-09 05:00:00	NQ	Futures	9750.66	9757.35	9747.76	9757.06	3336.0
2019-12-09 06:00:00	NQ	Futures	9757.06	9757.64	9744.85	9747.76	3811.0
2019-12-09 07:00:00	NQ	Futures	9747.47	9756.77	9746.89	9752.7	3403.0
2019-12-09 08:00:00	NQ	Futures	9752.7	9753.86	9743.69	9746.31	4983.0
2019-12-09 09:00:00	NQ	Futures	9746.31	9792.21	9739.92	9782.91	49276.0
2019-12-09 10:00:00	NQ	Futures	9783.2	9789.01	9770.13	9775.65	33110.0
2019-12-09 11:00:00	NQ	Futures	9776.23	9776.81	9750.66	9755.02	34262.0
2019-12-09 12:00:00	NQ	Futures	9755.02	9759.96	9743.4	9750.08	21375.0
2019-12-09 13:00:00	NQ	Futures	9749.79	9754.15	9744.56	9748.34	17601.0
2019-12-09 14:00:00	NQ	Futures	9748.34	9749.79	9728.59	9739.34	27670.0
2019-12-09 15:00:00	NQ	Futures	9739.34	9744.56	9716.68	9719.87	33722.0
2019-12-09 16:00:00	NQ	Futures	9719.87	9721.62	9698.96	9703.9	13308.0
2019-12-09 18:00:00	NQ	Futures	9707.67	9716.68	9705.35	9712.03	3864.0
2019-12-09 19:00:00	NQ	Futures	9712.03	9716.1	9706.22	9708.83	4386.0
2019-12-09 20:00:00	NQ	Futures	9708.83	9713.77	9702.73	9708.54	5997.0
2019-12-09 21:00:00	NQ	Futures	9708.54	9723.94	9708.54	9723.07	4647.0
2019-12-09 22:00:00	NQ	Futures	9723.07	9725.97	9720.16	9721.33	2248.0
2019-12-09 23:00:00	NQ	Futures	9721.62	9723.94	9717.84	9719.58	3396.0
2019-12-09 00:00:00	YM	Futures	30454.3	30457.5	30443.4	30456.5	833.0
2019-12-09 01:00:00	YM	Futures	30456.5	30482.6	30448.8	30480.4	1350.0
2019-12-09 02:00:00	YM	Futures	30480.4	30498.9	30472.8	30491.3	1896.0
2019-12-09 03:00:00	YM	Futures	30491.3	30498.9	30459.7	30460.8	3954.0

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

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