PREVIEW / futures_1hour / 2019-02-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-18.parquet
  size:    40 KB
  rows:    1,283

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-02-18 00:00:00	ES	Futures	3017.3	3017.85	3015.4	3016.76	4595.0
2019-02-18 01:00:00	ES	Futures	3016.49	3018.39	3015.95	3018.12	3789.0
2019-02-18 02:00:00	ES	Futures	3017.85	3018.93	3016.49	3016.76	3539.0
2019-02-18 03:00:00	ES	Futures	3016.76	3018.39	3014.32	3014.86	9607.0
2019-02-18 04:00:00	ES	Futures	3014.86	3015.68	3012.69	3013.23	6776.0
2019-02-18 05:00:00	ES	Futures	3013.5	3016.49	3012.69	3016.49	6365.0
2019-02-18 06:00:00	ES	Futures	3016.49	3017.58	3014.05	3014.86	6025.0
2019-02-18 07:00:00	ES	Futures	3014.86	3017.58	3014.59	3015.68	4758.0
2019-02-18 08:00:00	ES	Futures	3015.68	3017.58	3014.86	3015.68	5979.0
2019-02-18 09:00:00	ES	Futures	3015.68	3017.85	3013.77	3017.58	11846.0
2019-02-18 10:00:00	ES	Futures	3017.58	3018.12	3016.22	3016.49	9961.0
2019-02-18 11:00:00	ES	Futures	3016.49	3017.03	3015.68	3016.76	10460.0
2019-02-18 12:00:00	ES	Futures	3016.76	3018.66	3013.77	3018.12	7894.0
2019-02-18 18:00:00	ES	Futures	3017.3	3017.85	3014.59	3015.4	7301.0
2019-02-18 19:00:00	ES	Futures	3015.68	3018.39	3013.77	3016.22	6679.0
2019-02-18 20:00:00	ES	Futures	3016.49	3020.29	3015.4	3018.39	7088.0
2019-02-18 21:00:00	ES	Futures	3018.66	3018.93	3015.68	3018.39	4773.0
2019-02-18 22:00:00	ES	Futures	3018.39	3018.39	3015.95	3016.49	3397.0
2019-02-18 23:00:00	ES	Futures	3016.49	3017.3	3015.68	3016.22	1757.0
2019-02-18 00:00:00	NQ	Futures	8262.53	8265.16	8255.81	8260.19	2507.0
2019-02-18 01:00:00	NQ	Futures	8259.9	8266.91	8258.15	8266.62	1987.0
2019-02-18 02:00:00	NQ	Futures	8266.33	8269.83	8260.19	8261.07	2936.0
2019-02-18 03:00:00	NQ	Futures	8260.78	8264.87	8250.55	8253.76	5120.0
2019-02-18 04:00:00	NQ	Futures	8254.06	8255.81	8246.46	8249.97	3379.0
2019-02-18 05:00:00	NQ	Futures	8249.67	8257.27	8247.04	8256.39	3244.0
2019-02-18 06:00:00	NQ	Futures	8256.69	8264.28	8249.67	8254.64	3062.0
2019-02-18 07:00:00	NQ	Futures	8254.35	8259.9	8253.47	8255.81	1880.0
2019-02-18 08:00:00	NQ	Futures	8256.1	8260.19	8251.72	8255.81	2894.0
2019-02-18 09:00:00	NQ	Futures	8255.81	8266.33	8255.23	8265.45	5696.0
2019-02-18 10:00:00	NQ	Futures	8265.45	8270.71	8264.28	8267.79	6145.0
2019-02-18 11:00:00	NQ	Futures	8267.79	8269.83	8265.74	8268.08	4873.0
2019-02-18 12:00:00	NQ	Futures	8267.79	8278.02	8262.24	8275.68	4249.0
2019-02-18 18:00:00	NQ	Futures	8274.51	8274.51	8263.99	8268.08	2481.0
2019-02-18 19:00:00	NQ	Futures	8268.37	8274.8	8263.11	8268.67	3304.0
2019-02-18 20:00:00	NQ	Futures	8268.96	8282.4	8265.45	8276.85	3857.0
2019-02-18 21:00:00	NQ	Futures	8277.14	8278.02	8270.13	8277.43	2405.0
2019-02-18 22:00:00	NQ	Futures	8277.72	8278.02	8270.13	8271.59	1692.0
2019-02-18 23:00:00	NQ	Futures	8271.59	8273.93	8268.96	8271.3	984.0
2019-02-18 00:00:00	YM	Futures	28129.6	28136.1	28107.9	28118.7	2193.0
2019-02-18 01:00:00	YM	Futures	28117.6	28136.1	28115.5	28133.9	1151.0
2019-02-18 02:00:00	YM	Futures	28131.7	28145.9	28120.9	28123.1	1606.0
2019-02-18 03:00:00	YM	Futures	28122.0	28137.2	28082.9	28089.4	3920.0
2019-02-18 04:00:00	YM	Futures	28089.4	28098.1	28062.3	28074.2	2443.0
2019-02-18 05:00:00	YM	Futures	28075.3	28123.1	28067.7	28122.0	2460.0
2019-02-18 06:00:00	YM	Futures	28120.9	28136.1	28102.4	28110.0	2490.0
2019-02-18 07:00:00	YM	Futures	28110.0	28139.3	28105.7	28122.0	2059.0
2019-02-18 08:00:00	YM	Futures	28122.0	28139.3	28107.9	28120.9	2452.0
2019-02-18 09:00:00	YM	Futures	28122.0	28132.8	28104.6	28127.4	3357.0
2019-02-18 10:00:00	YM	Futures	28126.3	28128.5	28106.8	28112.2	1859.0
2019-02-18 11:00:00	YM	Futures	28113.3	28124.1	28100.3	28115.5	2231.0

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

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