PREVIEW / futures_1hour / 2018-09-19

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-09-19.parquet
  size:    53 KB
  rows:    1,667

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-09-19 00:00:00	ES	Futures	3166.6	3167.69	3166.33	3167.69	2109.0
2018-09-19 01:00:00	ES	Futures	3167.42	3168.51	3166.6	3168.24	3177.0
2018-09-19 02:00:00	ES	Futures	3167.96	3170.14	3167.69	3168.51	4346.0
2018-09-19 03:00:00	ES	Futures	3168.78	3169.87	3166.6	3166.6	11744.0
2018-09-19 04:00:00	ES	Futures	3166.88	3168.51	3165.52	3166.06	11123.0
2018-09-19 05:00:00	ES	Futures	3166.06	3166.88	3165.52	3166.33	6086.0
2018-09-19 06:00:00	ES	Futures	3166.06	3167.15	3165.24	3166.33	6943.0
2018-09-19 07:00:00	ES	Futures	3166.06	3166.6	3163.88	3164.43	14225.0
2018-09-19 08:00:00	ES	Futures	3164.16	3165.24	3161.44	3164.43	24129.0
2018-09-19 09:00:00	ES	Futures	3164.43	3173.95	3163.88	3170.14	194856.0
2018-09-19 10:00:00	ES	Futures	3169.87	3173.13	3166.06	3168.78	180203.0
2018-09-19 11:00:00	ES	Futures	3168.78	3175.58	3167.96	3173.13	155939.0
2018-09-19 12:00:00	ES	Futures	3173.4	3174.22	3168.51	3172.04	87395.0
2018-09-19 13:00:00	ES	Futures	3172.32	3172.59	3169.05	3170.68	49187.0
2018-09-19 14:00:00	ES	Futures	3170.68	3172.04	3169.05	3169.05	39178.0
2018-09-19 15:00:00	ES	Futures	3169.32	3172.86	3168.78	3170.68	102176.0
2018-09-19 16:00:00	ES	Futures	3170.68	3173.13	3170.14	3173.13	39324.0
2018-09-19 18:00:00	ES	Futures	3173.13	3173.4	3172.32	3172.86	2485.0
2018-09-19 19:00:00	ES	Futures	3172.86	3174.76	3172.59	3174.22	2874.0
2018-09-19 20:00:00	ES	Futures	3173.95	3174.49	3172.04	3173.13	4156.0
2018-09-19 21:00:00	ES	Futures	3173.13	3173.95	3171.5	3173.4	5217.0
2018-09-19 22:00:00	ES	Futures	3173.13	3173.95	3172.04	3172.86	3646.0
2018-09-19 23:00:00	ES	Futures	3172.86	3173.4	3170.68	3170.96	2808.0
2018-09-19 00:00:00	NQ	Futures	8827.88	8833.16	8826.41	8832.57	1094.0
2018-09-19 01:00:00	NQ	Futures	8832.28	8835.21	8826.41	8834.33	1457.0
2018-09-19 02:00:00	NQ	Futures	8834.33	8839.32	8832.86	8834.62	1665.0
2018-09-19 03:00:00	NQ	Futures	8834.62	8843.13	8831.4	8832.28	3570.0
2018-09-19 04:00:00	NQ	Futures	8832.28	8838.44	8829.05	8829.93	2817.0
2018-09-19 05:00:00	NQ	Futures	8829.64	8832.86	8828.17	8830.81	1480.0
2018-09-19 06:00:00	NQ	Futures	8830.52	8831.69	8825.53	8827.88	2108.0
2018-09-19 07:00:00	NQ	Futures	8827.88	8830.22	8813.5	8814.97	4493.0
2018-09-19 08:00:00	NQ	Futures	8815.26	8826.41	8807.05	8823.18	7175.0
2018-09-19 09:00:00	NQ	Futures	8822.89	8853.39	8790.33	8798.54	82133.0
2018-09-19 10:00:00	NQ	Futures	8798.54	8813.5	8765.11	8775.96	77159.0
2018-09-19 11:00:00	NQ	Futures	8775.96	8820.54	8770.39	8808.22	51243.0
2018-09-19 12:00:00	NQ	Futures	8807.64	8812.04	8780.95	8798.25	31794.0
2018-09-19 13:00:00	NQ	Futures	8798.25	8805.88	8785.05	8803.82	25728.0
2018-09-19 14:00:00	NQ	Futures	8803.53	8811.45	8798.54	8803.53	16985.0
2018-09-19 15:00:00	NQ	Futures	8803.53	8832.86	8803.53	8823.48	33882.0
2018-09-19 16:00:00	NQ	Futures	8823.77	8834.62	8821.13	8833.45	6851.0
2018-09-19 18:00:00	NQ	Futures	8834.33	8836.38	8830.81	8832.28	1024.0
2018-09-19 19:00:00	NQ	Futures	8832.57	8841.95	8832.28	8840.49	1300.0
2018-09-19 20:00:00	NQ	Futures	8840.2	8840.78	8831.4	8834.33	1618.0
2018-09-19 21:00:00	NQ	Futures	8834.33	8838.14	8827.58	8837.26	1992.0
2018-09-19 22:00:00	NQ	Futures	8837.26	8839.61	8831.4	8834.33	2817.0
2018-09-19 23:00:00	NQ	Futures	8834.04	8835.5	8823.48	8823.48	1305.0
2018-09-19 00:00:00	YM	Futures	28581.8	28590.5	28579.6	28590.5	614.0
2018-09-19 01:00:00	YM	Futures	28588.3	28597.0	28579.6	28592.7	922.0
2018-09-19 02:00:00	YM	Futures	28591.6	28623.1	28591.6	28603.5	1832.0
2018-09-19 03:00:00	YM	Futures	28604.6	28615.5	28578.5	28585.1	3446.0

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

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