PREVIEW / futures_1hour / 2018-12-21

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-21.parquet
  size:    49 KB
  rows:    1,431

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
2018-12-21 00:00:00	ES	Futures	2691.95	2700.91	2691.67	2700.64	7732.0
2018-12-21 01:00:00	ES	Futures	2700.64	2703.35	2693.58	2702.54	9041.0
2018-12-21 02:00:00	ES	Futures	2702.54	2704.44	2697.92	2697.92	16793.0
2018-12-21 03:00:00	ES	Futures	2697.92	2699.28	2682.44	2682.44	36218.0
2018-12-21 04:00:00	ES	Futures	2682.71	2688.96	2680.27	2686.79	29160.0
2018-12-21 05:00:00	ES	Futures	2686.79	2690.32	2680.0	2689.5	34375.0
2018-12-21 06:00:00	ES	Futures	2689.23	2694.66	2687.33	2690.05	25885.0
2018-12-21 07:00:00	ES	Futures	2690.32	2693.03	2684.61	2690.59	31341.0
2018-12-21 08:00:00	ES	Futures	2690.59	2707.43	2688.14	2700.37	65494.0
2018-12-21 09:00:00	ES	Futures	2700.37	2707.15	2684.89	2691.95	361100.0
2018-12-21 10:00:00	ES	Futures	2692.22	2724.54	2683.8	2696.83	432077.0
2018-12-21 11:00:00	ES	Futures	2697.11	2697.38	2672.94	2675.92	316152.0
2018-12-21 12:00:00	ES	Futures	2676.19	2679.18	2645.51	2657.45	352619.0
2018-12-21 13:00:00	ES	Futures	2657.45	2671.31	2651.48	2657.73	201193.0
2018-12-21 14:00:00	ES	Futures	2657.73	2662.89	2644.42	2651.21	207651.0
2018-12-21 15:00:00	ES	Futures	2650.94	2655.83	2617.26	2623.78	529728.0
2018-12-21 16:00:00	ES	Futures	2624.05	2630.84	2618.08	2630.3	151214.0
2018-12-21 00:00:00	NQ	Futures	7357.91	7380.7	7357.33	7379.53	3926.0
2018-12-21 01:00:00	NQ	Futures	7379.83	7390.05	7359.96	7387.13	3835.0
2018-12-21 02:00:00	NQ	Futures	7386.84	7393.27	7373.69	7375.15	6383.0
2018-12-21 03:00:00	NQ	Futures	7375.44	7381.87	7328.11	7329.28	14144.0
2018-12-21 04:00:00	NQ	Futures	7329.28	7355.57	7322.85	7351.78	14007.0
2018-12-21 05:00:00	NQ	Futures	7351.19	7360.25	7331.03	7357.04	12102.0
2018-12-21 06:00:00	NQ	Futures	7356.74	7374.27	7351.48	7356.45	10159.0
2018-12-21 07:00:00	NQ	Futures	7356.74	7363.17	7334.54	7350.31	9798.0
2018-12-21 08:00:00	NQ	Futures	7350.02	7402.62	7344.76	7384.5	23042.0
2018-12-21 09:00:00	NQ	Futures	7384.5	7407.58	7307.95	7328.11	104170.0
2018-12-21 10:00:00	NQ	Futures	7328.11	7399.69	7275.51	7313.21	124873.0
2018-12-21 11:00:00	NQ	Futures	7313.21	7314.08	7219.41	7227.01	96847.0
2018-12-21 12:00:00	NQ	Futures	7226.43	7230.52	7118.9	7172.08	125935.0
2018-12-21 13:00:00	NQ	Futures	7172.08	7217.95	7155.13	7175.0	69832.0
2018-12-21 14:00:00	NQ	Futures	7175.0	7194.29	7134.68	7156.59	62068.0
2018-12-21 15:00:00	NQ	Futures	7156.3	7165.36	7047.61	7086.47	117241.0
2018-12-21 16:00:00	NQ	Futures	7086.47	7110.72	7075.07	7106.92	28370.0
2018-12-21 00:00:00	YM	Futures	24925.7	24997.3	24919.1	24997.3	1669.0
2018-12-21 01:00:00	YM	Futures	24997.3	25025.5	24936.5	25021.2	1497.0
2018-12-21 02:00:00	YM	Futures	25017.9	25039.7	24970.2	24978.9	3472.0
2018-12-21 03:00:00	YM	Futures	24978.9	24993.0	24823.6	24826.9	8892.0
2018-12-21 04:00:00	YM	Futures	24829.0	24870.3	24797.5	24850.7	7830.0
2018-12-21 05:00:00	YM	Futures	24849.7	24876.8	24785.6	24869.2	6458.0
2018-12-21 06:00:00	YM	Futures	24867.0	24934.3	24855.1	24890.9	5390.0
2018-12-21 07:00:00	YM	Futures	24890.9	24914.8	24834.5	24888.7	5620.0
2018-12-21 08:00:00	YM	Futures	24890.9	25032.1	24869.2	24974.5	11396.0
2018-12-21 09:00:00	YM	Futures	24974.5	25015.8	24827.9	24934.3	44856.0
2018-12-21 10:00:00	YM	Futures	24935.4	25241.6	24884.4	24997.3	65410.0
2018-12-21 11:00:00	YM	Futures	24999.5	25007.1	24786.7	24822.5	47297.0
2018-12-21 12:00:00	YM	Futures	24823.6	24859.4	24572.8	24661.8	53978.0
2018-12-21 13:00:00	YM	Futures	24661.8	24773.7	24594.5	24644.5	39065.0
2018-12-21 14:00:00	YM	Futures	24644.5	24667.3	24528.3	24578.2	39974.0
2018-12-21 15:00:00	YM	Futures	24576.1	24624.9	24313.3	24352.4	58598.0

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

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