PREVIEW / futures_1hour / 2019-08-12

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-12.parquet
  size:    60 KB
  rows:    1,862

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-08-12 00:00:00	ES	Futures	3167.25	3167.52	3163.73	3164.54	4194.0
2019-08-12 01:00:00	ES	Futures	3164.54	3168.33	3163.19	3168.06	4962.0
2019-08-12 02:00:00	ES	Futures	3168.06	3170.77	3166.71	3167.25	8895.0
2019-08-12 03:00:00	ES	Futures	3167.25	3173.75	3167.25	3168.87	25309.0
2019-08-12 04:00:00	ES	Futures	3168.87	3169.14	3145.59	3148.03	52570.0
2019-08-12 05:00:00	ES	Futures	3148.03	3150.19	3143.7	3145.86	34422.0
2019-08-12 06:00:00	ES	Futures	3145.59	3146.68	3135.04	3142.34	40496.0
2019-08-12 07:00:00	ES	Futures	3142.34	3145.05	3132.6	3139.1	35766.0
2019-08-12 08:00:00	ES	Futures	3139.1	3147.76	3137.47	3144.51	46650.0
2019-08-12 09:00:00	ES	Futures	3144.78	3147.76	3133.41	3136.66	217936.0
2019-08-12 10:00:00	ES	Futures	3136.39	3149.11	3133.14	3140.99	223065.0
2019-08-12 11:00:00	ES	Futures	3140.99	3141.26	3127.46	3137.47	171382.0
2019-08-12 12:00:00	ES	Futures	3137.74	3143.16	3132.33	3134.76	122762.0
2019-08-12 13:00:00	ES	Futures	3134.49	3136.39	3125.02	3126.37	108844.0
2019-08-12 14:00:00	ES	Futures	3126.37	3129.35	3110.4	3114.19	195107.0
2019-08-12 15:00:00	ES	Futures	3114.19	3123.94	3113.11	3122.31	231132.0
2019-08-12 16:00:00	ES	Futures	3122.58	3123.4	3116.9	3120.96	77341.0
2019-08-12 18:00:00	ES	Futures	3120.96	3123.94	3118.79	3122.85	6570.0
2019-08-12 19:00:00	ES	Futures	3122.85	3126.1	3120.42	3126.1	8630.0
2019-08-12 20:00:00	ES	Futures	3125.83	3127.73	3122.58	3125.56	17233.0
2019-08-12 21:00:00	ES	Futures	3125.56	3128.81	3120.69	3121.23	20809.0
2019-08-12 22:00:00	ES	Futures	3121.23	3126.91	3119.61	3125.29	11270.0
2019-08-12 23:00:00	ES	Futures	3125.29	3126.37	3122.85	3123.67	4711.0
2019-08-12 00:00:00	NQ	Futures	8918.69	8921.3	8909.98	8911.43	2659.0
2019-08-12 01:00:00	NQ	Futures	8911.72	8926.52	8905.05	8925.36	4087.0
2019-08-12 02:00:00	NQ	Futures	8925.65	8935.23	8919.85	8923.33	5853.0
2019-08-12 03:00:00	NQ	Futures	8923.33	8947.99	8923.33	8932.03	9105.0
2019-08-12 04:00:00	NQ	Futures	8932.03	8932.62	8840.93	8852.25	22980.0
2019-08-12 05:00:00	NQ	Futures	8851.96	8863.56	8838.03	8846.44	13217.0
2019-08-12 06:00:00	NQ	Futures	8846.44	8849.92	8807.56	8833.1	15894.0
2019-08-12 07:00:00	NQ	Futures	8833.39	8842.67	8801.76	8821.2	15092.0
2019-08-12 08:00:00	NQ	Futures	8820.62	8845.57	8811.63	8835.71	19048.0
2019-08-12 09:00:00	NQ	Futures	8836.0	8853.7	8797.7	8816.85	68289.0
2019-08-12 10:00:00	NQ	Futures	8816.85	8856.89	8801.18	8838.03	67452.0
2019-08-12 11:00:00	NQ	Futures	8838.03	8849.92	8794.51	8841.51	56509.0
2019-08-12 12:00:00	NQ	Futures	8841.51	8858.92	8823.81	8833.1	46882.0
2019-08-12 13:00:00	NQ	Futures	8832.81	8838.32	8803.21	8807.85	34885.0
2019-08-12 14:00:00	NQ	Futures	8807.56	8813.08	8744.6	8756.21	56481.0
2019-08-12 15:00:00	NQ	Futures	8755.92	8793.35	8752.15	8786.38	62871.0
2019-08-12 16:00:00	NQ	Futures	8786.38	8788.41	8773.91	8786.96	11879.0
2019-08-12 18:00:00	NQ	Futures	8785.8	8795.67	8779.42	8792.48	3301.0
2019-08-12 19:00:00	NQ	Futures	8791.9	8801.18	8785.8	8800.89	3519.0
2019-08-12 20:00:00	NQ	Futures	8800.6	8808.72	8791.03	8802.34	8647.0
2019-08-12 21:00:00	NQ	Futures	8802.34	8813.66	8786.67	8788.41	11732.0
2019-08-12 22:00:00	NQ	Futures	8787.83	8806.4	8783.77	8799.44	6153.0
2019-08-12 23:00:00	NQ	Futures	8799.73	8802.63	8792.48	8792.77	3021.0
2019-08-12 00:00:00	YM	Futures	28603.4	28605.6	28575.2	28579.5	1136.0
2019-08-12 01:00:00	YM	Futures	28580.6	28610.0	28569.7	28605.6	1348.0
2019-08-12 02:00:00	YM	Futures	28606.7	28628.4	28594.7	28596.9	2403.0
2019-08-12 03:00:00	YM	Futures	28598.0	28658.9	28596.9	28616.5	4977.0

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

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