PREVIEW / futures_1hour / 2018-11-22

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-22.parquet
  size:    38 KB
  rows:    1,176

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-11-22 00:00:00	ES	Futures	2885.9	2887.26	2884.0	2886.45	3124.0
2018-11-22 01:00:00	ES	Futures	2886.45	2889.98	2885.9	2888.08	2694.0
2018-11-22 02:00:00	ES	Futures	2888.08	2889.17	2883.18	2883.45	6362.0
2018-11-22 03:00:00	ES	Futures	2883.18	2883.73	2873.39	2874.48	16822.0
2018-11-22 04:00:00	ES	Futures	2874.48	2875.57	2867.41	2872.85	17041.0
2018-11-22 05:00:00	ES	Futures	2872.85	2879.37	2871.76	2872.3	14387.0
2018-11-22 06:00:00	ES	Futures	2872.57	2877.74	2871.49	2876.93	9808.0
2018-11-22 07:00:00	ES	Futures	2876.65	2879.1	2875.29	2876.93	6097.0
2018-11-22 08:00:00	ES	Futures	2876.93	2876.93	2873.39	2875.02	5959.0
2018-11-22 09:00:00	ES	Futures	2875.29	2876.38	2873.12	2875.29	9419.0
2018-11-22 10:00:00	ES	Futures	2875.57	2876.38	2866.05	2867.41	19974.0
2018-11-22 11:00:00	ES	Futures	2867.41	2868.22	2858.16	2867.95	29682.0
2018-11-22 12:00:00	ES	Futures	2867.95	2869.04	2863.87	2864.41	8326.0
2018-11-22 18:00:00	ES	Futures	2867.41	2873.93	2866.32	2873.39	4168.0
2018-11-22 19:00:00	ES	Futures	2873.39	2876.38	2872.3	2876.11	3550.0
2018-11-22 20:00:00	ES	Futures	2876.38	2877.74	2874.21	2875.02	3804.0
2018-11-22 21:00:00	ES	Futures	2875.02	2876.93	2873.39	2876.38	3768.0
2018-11-22 22:00:00	ES	Futures	2876.38	2876.65	2872.57	2874.21	3069.0
2018-11-22 23:00:00	ES	Futures	2874.48	2875.02	2870.94	2872.3	1706.0
2018-11-22 00:00:00	NQ	Futures	7722.96	7726.77	7713.28	7722.96	1985.0
2018-11-22 01:00:00	NQ	Futures	7722.67	7734.69	7721.49	7729.12	1524.0
2018-11-22 02:00:00	NQ	Futures	7729.71	7734.11	7713.58	7714.75	2891.0
2018-11-22 03:00:00	NQ	Futures	7714.75	7715.34	7681.31	7687.18	8243.0
2018-11-22 04:00:00	NQ	Futures	7686.88	7690.11	7663.71	7676.32	8978.0
2018-11-22 05:00:00	NQ	Futures	7675.74	7694.8	7669.87	7672.51	7353.0
2018-11-22 06:00:00	NQ	Futures	7672.22	7693.04	7669.87	7688.94	5542.0
2018-11-22 07:00:00	NQ	Futures	7689.23	7700.96	7683.95	7692.75	4680.0
2018-11-22 08:00:00	NQ	Futures	7693.34	7693.92	7673.68	7684.83	5779.0
2018-11-22 09:00:00	NQ	Futures	7684.83	7690.4	7679.26	7683.95	5028.0
2018-11-22 10:00:00	NQ	Futures	7684.54	7686.59	7644.06	7648.75	11988.0
2018-11-22 11:00:00	NQ	Futures	7648.75	7663.42	7633.79	7660.19	11664.0
2018-11-22 12:00:00	NQ	Futures	7660.19	7666.65	7648.75	7650.81	3815.0
2018-11-22 18:00:00	NQ	Futures	7655.5	7679.55	7652.57	7677.79	2435.0
2018-11-22 19:00:00	NQ	Futures	7677.79	7688.64	7674.27	7688.64	2563.0
2018-11-22 20:00:00	NQ	Futures	7688.94	7690.99	7677.79	7680.43	2662.0
2018-11-22 21:00:00	NQ	Futures	7680.14	7688.94	7676.32	7686.88	2383.0
2018-11-22 22:00:00	NQ	Futures	7686.88	7687.47	7676.62	7683.95	1493.0
2018-11-22 23:00:00	NQ	Futures	7684.54	7686.0	7669.58	7677.79	1429.0
2018-11-22 00:00:00	YM	Futures	26621.7	26630.4	26602.2	26619.6	979.0
2018-11-22 01:00:00	YM	Futures	26618.5	26654.3	26616.3	26639.1	864.0
2018-11-22 02:00:00	YM	Futures	26641.3	26650.0	26590.2	26591.3	2165.0
2018-11-22 03:00:00	YM	Futures	26592.4	26600.0	26517.4	26532.6	6601.0
2018-11-22 04:00:00	YM	Futures	26532.6	26539.2	26427.2	26480.5	8612.0
2018-11-22 05:00:00	YM	Futures	26480.5	26548.9	26478.3	26493.5	4342.0
2018-11-22 06:00:00	YM	Futures	26492.4	26540.2	26483.7	26529.4	2949.0
2018-11-22 07:00:00	YM	Futures	26530.5	26547.8	26512.0	26531.5	2151.0
2018-11-22 08:00:00	YM	Futures	26531.5	26531.5	26496.8	26509.8	2449.0
2018-11-22 09:00:00	YM	Futures	26508.7	26525.0	26493.5	26518.5	2514.0
2018-11-22 10:00:00	YM	Futures	26518.5	26528.3	26439.2	26452.2	7445.0
2018-11-22 11:00:00	YM	Futures	26451.1	26459.8	26389.2	26450.1	6952.0

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

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