PREVIEW / futures_1hour / 2018-02-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-02-09.parquet
  size:    50 KB
  rows:    1,424

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-02-09 00:00:00	ES	Futures	2847.53	2849.44	2834.68	2848.08	12055.0
2018-02-09 01:00:00	ES	Futures	2848.08	2850.54	2837.14	2842.06	9046.0
2018-02-09 02:00:00	ES	Futures	2841.52	2857.92	2840.7	2855.18	27583.0
2018-02-09 03:00:00	ES	Futures	2855.18	2861.2	2852.45	2856.55	43086.0
2018-02-09 04:00:00	ES	Futures	2856.55	2856.82	2848.9	2854.09	23980.0
2018-02-09 05:00:00	ES	Futures	2854.09	2859.28	2848.62	2854.91	31293.0
2018-02-09 06:00:00	ES	Futures	2854.64	2856.55	2834.96	2844.25	47325.0
2018-02-09 07:00:00	ES	Futures	2844.52	2850.81	2821.29	2825.12	70854.0
2018-02-09 08:00:00	ES	Futures	2825.67	2855.46	2825.12	2852.45	84626.0
2018-02-09 09:00:00	ES	Futures	2852.45	2862.84	2836.32	2852.45	360803.0
2018-02-09 10:00:00	ES	Futures	2852.45	2857.1	2805.44	2827.85	479218.0
2018-02-09 11:00:00	ES	Futures	2827.85	2840.42	2807.63	2808.45	279598.0
2018-02-09 12:00:00	ES	Futures	2808.45	2812.0	2775.37	2804.07	486751.0
2018-02-09 13:00:00	ES	Futures	2804.07	2809.81	2766.35	2796.97	414867.0
2018-02-09 14:00:00	ES	Futures	2796.97	2852.72	2795.6	2827.31	483410.0
2018-02-09 15:00:00	ES	Futures	2827.03	2883.88	2805.99	2862.84	668145.0
2018-02-09 16:00:00	ES	Futures	2862.84	2868.85	2856.82	2866.12	141181.0
2018-02-09 00:00:00	NQ	Futures	7508.28	7521.04	7465.28	7517.48	4466.0
2018-02-09 01:00:00	NQ	Futures	7516.29	7523.11	7489.3	7507.39	2381.0
2018-02-09 02:00:00	NQ	Futures	7507.1	7549.81	7504.43	7545.36	5449.0
2018-02-09 03:00:00	NQ	Futures	7546.25	7567.31	7533.2	7556.92	7991.0
2018-02-09 04:00:00	NQ	Futures	7556.92	7562.26	7533.2	7555.44	4053.0
2018-02-09 05:00:00	NQ	Futures	7555.15	7565.53	7533.79	7546.84	5428.0
2018-02-09 06:00:00	NQ	Futures	7546.25	7550.7	7499.68	7534.38	11102.0
2018-02-09 07:00:00	NQ	Futures	7534.09	7545.36	7486.04	7501.76	15163.0
2018-02-09 08:00:00	NQ	Futures	7502.06	7569.09	7502.06	7559.89	24207.0
2018-02-09 09:00:00	NQ	Futures	7559.59	7621.29	7534.98	7593.41	78102.0
2018-02-09 10:00:00	NQ	Futures	7593.41	7615.65	7456.38	7512.44	100813.0
2018-02-09 11:00:00	NQ	Futures	7512.44	7556.92	7450.74	7454.01	60078.0
2018-02-09 12:00:00	NQ	Futures	7453.41	7465.87	7319.95	7425.53	102495.0
2018-02-09 13:00:00	NQ	Futures	7425.53	7448.07	7312.83	7412.78	81504.0
2018-02-09 14:00:00	NQ	Futures	7412.48	7585.99	7408.63	7518.66	100778.0
2018-02-09 15:00:00	NQ	Futures	7517.77	7658.66	7451.93	7604.08	113938.0
2018-02-09 16:00:00	NQ	Futures	7604.68	7626.33	7596.08	7623.36	16520.0
2018-02-09 00:00:00	YM	Futures	26165.6	26193.8	26061.2	26178.6	4385.0
2018-02-09 01:00:00	YM	Futures	26177.5	26197.1	26080.8	26131.9	1788.0
2018-02-09 02:00:00	YM	Futures	26129.7	26240.5	26123.2	26222.1	4642.0
2018-02-09 03:00:00	YM	Futures	26219.9	26264.5	26180.8	26194.9	7513.0
2018-02-09 04:00:00	YM	Futures	26192.7	26197.1	26124.3	26173.2	3707.0
2018-02-09 05:00:00	YM	Futures	26169.9	26218.8	26127.5	26184.0	3189.0
2018-02-09 06:00:00	YM	Futures	26187.3	26202.5	25954.7	26066.6	9353.0
2018-02-09 07:00:00	YM	Futures	26068.8	26103.6	25871.0	25902.5	12059.0
2018-02-09 08:00:00	YM	Futures	25899.3	26191.6	25899.3	26161.2	19155.0
2018-02-09 09:00:00	YM	Futures	26157.9	26278.6	26025.3	26169.9	54967.0
2018-02-09 10:00:00	YM	Futures	26174.2	26201.4	25640.6	25904.7	77182.0
2018-02-09 11:00:00	YM	Futures	25904.7	26037.3	25717.8	25730.8	45546.0
2018-02-09 12:00:00	YM	Futures	25730.8	25772.1	25455.8	25691.7	52046.0
2018-02-09 13:00:00	YM	Futures	25687.3	25747.1	25351.5	25613.4	56047.0
2018-02-09 14:00:00	YM	Futures	25610.2	26151.4	25601.5	25927.5	67037.0
2018-02-09 15:00:00	YM	Futures	25925.4	26465.5	25727.5	26263.4	57989.0

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

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