PREVIEW / futures_1hour / 2019-05-29

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-05-29.parquet
  size:    59 KB
  rows:    1,849

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-05-29 00:00:00	ES	Futures	3032.01	3032.82	3030.11	3030.65	4121.0
2019-05-29 01:00:00	ES	Futures	3030.65	3036.35	3030.38	3033.36	11327.0
2019-05-29 02:00:00	ES	Futures	3033.36	3034.18	3021.43	3023.06	28583.0
2019-05-29 03:00:00	ES	Futures	3023.06	3025.23	3018.72	3022.52	40500.0
2019-05-29 04:00:00	ES	Futures	3022.52	3026.31	3020.62	3023.06	24064.0
2019-05-29 05:00:00	ES	Futures	3023.33	3023.87	3016.83	3021.71	26816.0
2019-05-29 06:00:00	ES	Futures	3021.98	3027.67	3021.16	3027.13	24541.0
2019-05-29 07:00:00	ES	Futures	3027.13	3027.94	3022.25	3024.42	26090.0
2019-05-29 08:00:00	ES	Futures	3024.15	3024.15	3018.99	3022.25	39902.0
2019-05-29 09:00:00	ES	Futures	3022.52	3025.23	3013.3	3018.72	244659.0
2019-05-29 10:00:00	ES	Futures	3018.45	3028.48	3014.93	3017.1	291383.0
2019-05-29 11:00:00	ES	Futures	3017.1	3024.15	2999.75	3002.73	345937.0
2019-05-29 12:00:00	ES	Futures	3002.73	3013.57	3000.83	3007.61	175697.0
2019-05-29 13:00:00	ES	Futures	3007.61	3020.62	3005.44	3016.01	165022.0
2019-05-29 14:00:00	ES	Futures	3016.01	3019.81	3004.08	3008.42	144514.0
2019-05-29 15:00:00	ES	Futures	3008.69	3022.79	3002.46	3017.64	281181.0
2019-05-29 16:00:00	ES	Futures	3017.64	3018.18	3013.84	3015.47	62477.0
2019-05-29 18:00:00	ES	Futures	3014.12	3020.89	3013.84	3020.08	7673.0
2019-05-29 19:00:00	ES	Futures	3020.08	3020.62	3015.74	3016.83	5207.0
2019-05-29 20:00:00	ES	Futures	3016.56	3021.98	3011.13	3011.95	14386.0
2019-05-29 21:00:00	ES	Futures	3011.68	3019.54	3011.4	3013.57	15400.0
2019-05-29 22:00:00	ES	Futures	3013.57	3017.37	3012.76	3016.83	8998.0
2019-05-29 23:00:00	ES	Futures	3016.56	3020.89	3016.28	3020.35	7090.0
2019-05-29 00:00:00	NQ	Futures	8447.31	8449.64	8441.78	8442.94	1600.0
2019-05-29 01:00:00	NQ	Futures	8443.23	8462.74	8442.94	8450.8	6041.0
2019-05-29 02:00:00	NQ	Futures	8450.8	8452.55	8416.45	8422.27	11520.0
2019-05-29 03:00:00	NQ	Futures	8421.98	8428.09	8406.84	8419.94	15365.0
2019-05-29 04:00:00	NQ	Futures	8419.65	8434.79	8418.78	8425.47	9100.0
2019-05-29 05:00:00	NQ	Futures	8425.47	8428.68	8406.55	8421.11	10551.0
2019-05-29 06:00:00	NQ	Futures	8421.4	8438.87	8419.36	8437.7	6978.0
2019-05-29 07:00:00	NQ	Futures	8437.99	8440.32	8423.44	8431.01	8820.0
2019-05-29 08:00:00	NQ	Futures	8431.3	8431.3	8414.7	8425.18	13738.0
2019-05-29 09:00:00	NQ	Futures	8425.18	8438.58	8399.85	8419.07	77458.0
2019-05-29 10:00:00	NQ	Futures	8418.78	8457.79	8406.84	8416.16	79844.0
2019-05-29 11:00:00	NQ	Futures	8416.45	8436.25	8365.79	8379.18	83898.0
2019-05-29 12:00:00	NQ	Futures	8378.89	8408.0	8371.32	8391.12	46090.0
2019-05-29 13:00:00	NQ	Futures	8390.83	8437.99	8384.71	8421.11	44684.0
2019-05-29 14:00:00	NQ	Futures	8421.11	8432.17	8377.43	8392.57	38275.0
2019-05-29 15:00:00	NQ	Futures	8392.57	8430.42	8374.23	8413.54	61324.0
2019-05-29 16:00:00	NQ	Futures	8413.25	8418.49	8401.02	8401.89	11075.0
2019-05-29 18:00:00	NQ	Futures	8402.47	8421.98	8399.56	8421.69	2561.0
2019-05-29 19:00:00	NQ	Futures	8421.69	8421.98	8407.71	8411.5	2141.0
2019-05-29 20:00:00	NQ	Futures	8411.79	8428.39	8395.19	8397.81	6271.0
2019-05-29 21:00:00	NQ	Futures	8396.94	8420.82	8396.65	8403.05	6701.0
2019-05-29 22:00:00	NQ	Futures	8403.05	8414.41	8400.43	8413.25	4413.0
2019-05-29 23:00:00	NQ	Futures	8413.54	8425.18	8412.08	8420.82	3314.0
2019-05-29 00:00:00	YM	Futures	27516.9	27523.4	27499.5	27500.6	1312.0
2019-05-29 01:00:00	YM	Futures	27501.7	27560.4	27500.6	27537.6	3668.0
2019-05-29 02:00:00	YM	Futures	27537.6	27541.9	27431.0	27444.0	8475.0
2019-05-29 03:00:00	YM	Futures	27445.1	27458.2	27394.0	27425.5	8398.0

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

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