PREVIEW / futures_1hour / 2019-02-20

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-02-20.parquet
  size:    56 KB
  rows:    1,766

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-20 00:00:00	ES	Futures	3015.95	3017.3	3014.59	3017.03	3942.0
2019-02-20 01:00:00	ES	Futures	3017.03	3019.21	3016.76	3017.85	4857.0
2019-02-20 02:00:00	ES	Futures	3017.85	3020.56	3015.95	3016.22	8026.0
2019-02-20 03:00:00	ES	Futures	3016.22	3020.84	3016.22	3018.12	19867.0
2019-02-20 04:00:00	ES	Futures	3018.12	3020.02	3012.69	3013.5	22622.0
2019-02-20 05:00:00	ES	Futures	3013.5	3017.3	3013.23	3017.03	10513.0
2019-02-20 06:00:00	ES	Futures	3017.3	3017.3	3014.05	3017.03	7859.0
2019-02-20 07:00:00	ES	Futures	3017.03	3018.12	3016.22	3016.76	10605.0
2019-02-20 08:00:00	ES	Futures	3016.76	3019.21	3014.86	3017.85	17417.0
2019-02-20 09:00:00	ES	Futures	3017.85	3022.46	3017.58	3021.65	133726.0
2019-02-20 10:00:00	ES	Futures	3021.65	3026.0	3018.66	3022.74	126641.0
2019-02-20 11:00:00	ES	Futures	3022.74	3027.35	3021.38	3025.45	114591.0
2019-02-20 12:00:00	ES	Futures	3025.18	3025.72	3015.4	3017.58	134102.0
2019-02-20 13:00:00	ES	Futures	3017.58	3028.17	3017.03	3026.0	93434.0
2019-02-20 14:00:00	ES	Futures	3026.0	3031.7	3013.23	3026.27	275088.0
2019-02-20 15:00:00	ES	Futures	3026.27	3027.9	3022.74	3026.54	167522.0
2019-02-20 16:00:00	ES	Futures	3026.54	3028.71	3024.91	3027.35	40398.0
2019-02-20 18:00:00	ES	Futures	3027.62	3027.62	3025.18	3026.54	5142.0
2019-02-20 19:00:00	ES	Futures	3026.27	3028.17	3024.37	3024.91	8350.0
2019-02-20 20:00:00	ES	Futures	3025.18	3025.72	3021.65	3025.45	13730.0
2019-02-20 21:00:00	ES	Futures	3025.45	3034.14	3024.64	3033.87	14352.0
2019-02-20 22:00:00	ES	Futures	3033.87	3039.57	3032.24	3038.22	19025.0
2019-02-20 23:00:00	ES	Futures	3038.22	3039.03	3036.59	3037.67	6428.0
2019-02-20 00:00:00	NQ	Futures	8259.61	8261.95	8255.23	8261.36	1910.0
2019-02-20 01:00:00	NQ	Futures	8261.07	8271.0	8259.9	8267.5	2451.0
2019-02-20 02:00:00	NQ	Futures	8266.62	8275.68	8259.32	8260.19	3798.0
2019-02-20 03:00:00	NQ	Futures	8260.48	8272.76	8258.73	8261.95	6189.0
2019-02-20 04:00:00	NQ	Futures	8262.24	8268.37	8248.21	8250.26	5826.0
2019-02-20 05:00:00	NQ	Futures	8250.26	8264.28	8249.97	8263.11	3508.0
2019-02-20 06:00:00	NQ	Futures	8263.7	8263.99	8250.55	8261.65	3677.0
2019-02-20 07:00:00	NQ	Futures	8261.36	8267.5	8259.32	8260.78	5461.0
2019-02-20 08:00:00	NQ	Futures	8260.78	8274.8	8256.39	8271.3	7029.0
2019-02-20 09:00:00	NQ	Futures	8271.59	8294.38	8268.96	8290.0	48417.0
2019-02-20 10:00:00	NQ	Futures	8290.0	8304.02	8278.02	8292.33	48847.0
2019-02-20 11:00:00	NQ	Futures	8292.33	8296.42	8283.28	8286.49	33926.0
2019-02-20 12:00:00	NQ	Futures	8286.49	8288.83	8225.42	8235.36	55915.0
2019-02-20 13:00:00	NQ	Futures	8235.06	8273.93	8233.31	8268.08	29934.0
2019-02-20 14:00:00	NQ	Futures	8268.67	8286.2	8218.99	8258.44	86363.0
2019-02-20 15:00:00	NQ	Futures	8258.73	8269.54	8249.38	8265.16	45545.0
2019-02-20 16:00:00	NQ	Futures	8264.87	8269.83	8262.24	8264.87	7910.0
2019-02-20 18:00:00	NQ	Futures	8263.99	8266.04	8257.27	8261.95	2062.0
2019-02-20 19:00:00	NQ	Futures	8261.95	8268.08	8254.06	8257.56	3992.0
2019-02-20 20:00:00	NQ	Futures	8257.27	8259.32	8247.34	8257.27	5376.0
2019-02-20 21:00:00	NQ	Futures	8257.85	8290.0	8256.1	8289.7	6115.0
2019-02-20 22:00:00	NQ	Futures	8289.7	8314.25	8282.69	8304.31	9512.0
2019-02-20 23:00:00	NQ	Futures	8304.31	8309.57	8299.05	8302.85	2890.0
2019-02-20 00:00:00	YM	Futures	28072.0	28092.7	28056.8	28090.5	1149.0
2019-02-20 01:00:00	YM	Futures	28090.5	28107.9	28087.2	28094.8	1223.0
2019-02-20 02:00:00	YM	Futures	28095.9	28119.8	28065.5	28067.7	2904.0
2019-02-20 03:00:00	YM	Futures	28067.7	28111.1	28066.6	28090.5	5088.0

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

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