PREVIEW / futures_1hour / 2018-12-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-12-14.parquet
  size:    46 KB
  rows:    1,373

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-14 00:00:00	ES	Futures	2857.34	2859.24	2853.27	2854.35	4090.0
2018-12-14 01:00:00	ES	Futures	2854.35	2857.61	2853.0	2856.8	2895.0
2018-12-14 02:00:00	ES	Futures	2856.8	2859.79	2854.35	2856.25	6540.0
2018-12-14 03:00:00	ES	Futures	2856.53	2858.7	2845.39	2845.66	17034.0
2018-12-14 04:00:00	ES	Futures	2845.39	2849.19	2843.22	2846.48	10905.0
2018-12-14 05:00:00	ES	Futures	2846.48	2854.35	2846.48	2852.45	11837.0
2018-12-14 06:00:00	ES	Futures	2852.18	2856.53	2851.37	2854.35	8997.0
2018-12-14 07:00:00	ES	Futures	2854.35	2856.8	2850.82	2854.08	9982.0
2018-12-14 08:00:00	ES	Futures	2854.08	2858.7	2851.37	2857.07	18823.0
2018-12-14 09:00:00	ES	Futures	2856.8	2865.49	2851.64	2863.32	140785.0
2018-12-14 10:00:00	ES	Futures	2863.32	2867.66	2849.47	2856.53	165025.0
2018-12-14 11:00:00	ES	Futures	2856.53	2861.96	2834.8	2836.7	194187.0
2018-12-14 12:00:00	ES	Futures	2836.43	2849.47	2835.89	2842.13	132252.0
2018-12-14 13:00:00	ES	Futures	2842.13	2847.84	2832.63	2835.61	105896.0
2018-12-14 14:00:00	ES	Futures	2835.34	2840.77	2823.12	2831.27	146386.0
2018-12-14 15:00:00	ES	Futures	2831.54	2838.6	2821.49	2828.82	247658.0
2018-12-14 16:00:00	ES	Futures	2829.1	2832.63	2823.94	2824.75	59369.0
2018-12-14 00:00:00	NQ	Futures	7847.91	7855.22	7837.1	7840.9	1533.0
2018-12-14 01:00:00	NQ	Futures	7841.49	7849.08	7834.18	7846.45	1508.0
2018-12-14 02:00:00	NQ	Futures	7846.74	7857.85	7837.69	7846.16	2577.0
2018-12-14 03:00:00	NQ	Futures	7846.16	7854.34	7804.96	7807.59	6148.0
2018-12-14 04:00:00	NQ	Futures	7807.01	7818.99	7801.75	7813.43	3913.0
2018-12-14 05:00:00	NQ	Futures	7813.43	7843.53	7813.43	7836.81	4636.0
2018-12-14 06:00:00	NQ	Futures	7837.1	7851.42	7832.14	7844.99	3597.0
2018-12-14 07:00:00	NQ	Futures	7844.99	7854.63	7837.39	7842.95	3421.0
2018-12-14 08:00:00	NQ	Futures	7842.36	7857.26	7828.34	7847.91	8641.0
2018-12-14 09:00:00	NQ	Futures	7847.62	7858.43	7806.71	7848.21	47835.0
2018-12-14 10:00:00	NQ	Futures	7847.91	7875.38	7824.54	7854.05	73391.0
2018-12-14 11:00:00	NQ	Futures	7854.05	7874.21	7790.64	7797.36	67695.0
2018-12-14 12:00:00	NQ	Futures	7797.07	7830.09	7790.94	7805.55	47964.0
2018-12-14 13:00:00	NQ	Futures	7805.55	7822.79	7768.44	7779.25	34294.0
2018-12-14 14:00:00	NQ	Futures	7779.54	7794.15	7734.84	7761.43	43336.0
2018-12-14 15:00:00	NQ	Futures	7761.43	7778.66	7724.03	7734.84	53274.0
2018-12-14 16:00:00	NQ	Futures	7735.13	7748.86	7722.27	7722.27	10789.0
2018-12-14 00:00:00	YM	Futures	26519.5	26535.8	26478.2	26489.1	1048.0
2018-12-14 01:00:00	YM	Futures	26491.2	26511.9	26478.2	26507.5	809.0
2018-12-14 02:00:00	YM	Futures	26507.5	26531.4	26481.5	26503.2	1727.0
2018-12-14 03:00:00	YM	Futures	26501.0	26521.6	26394.6	26396.8	3855.0
2018-12-14 04:00:00	YM	Futures	26396.8	26423.9	26357.7	26395.7	2933.0
2018-12-14 05:00:00	YM	Futures	26395.7	26472.8	26394.6	26453.2	2871.0
2018-12-14 06:00:00	YM	Futures	26453.2	26498.8	26446.7	26480.4	2266.0
2018-12-14 07:00:00	YM	Futures	26481.5	26498.8	26444.6	26485.8	1891.0
2018-12-14 08:00:00	YM	Futures	26482.6	26518.4	26450.0	26504.3	3691.0
2018-12-14 09:00:00	YM	Futures	26504.3	26544.4	26427.2	26527.1	18338.0
2018-12-14 10:00:00	YM	Futures	26527.1	26555.3	26383.8	26406.6	21747.0
2018-12-14 11:00:00	YM	Futures	26407.6	26454.3	26213.3	26230.7	25518.0
2018-12-14 12:00:00	YM	Futures	26228.5	26334.9	26222.0	26282.8	14492.0
2018-12-14 13:00:00	YM	Futures	26281.7	26334.9	26198.1	26224.2	13245.0
2018-12-14 14:00:00	YM	Futures	26223.1	26280.6	26131.9	26214.4	16392.0
2018-12-14 15:00:00	YM	Futures	26216.6	26269.8	26118.8	26192.7	22779.0

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

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