PREVIEW / futures_1hour / 2018-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-11-09.parquet
  size:    48 KB
  rows:    1,428

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-09 00:00:00	ES	Futures	3055.9	3056.99	3052.09	3052.36	4563.0
2018-11-09 01:00:00	ES	Futures	3052.36	3053.72	3051.55	3051.82	3012.0
2018-11-09 02:00:00	ES	Futures	3052.09	3052.09	3043.93	3045.56	12113.0
2018-11-09 03:00:00	ES	Futures	3045.56	3046.11	3039.04	3041.48	25254.0
2018-11-09 04:00:00	ES	Futures	3041.48	3045.56	3039.31	3043.66	15126.0
2018-11-09 05:00:00	ES	Futures	3043.93	3044.75	3036.86	3037.68	14860.0
2018-11-09 06:00:00	ES	Futures	3037.68	3040.67	3034.96	3038.76	23450.0
2018-11-09 07:00:00	ES	Futures	3038.49	3041.76	3036.32	3041.21	17727.0
2018-11-09 08:00:00	ES	Futures	3041.21	3043.66	3037.4	3040.67	28678.0
2018-11-09 09:00:00	ES	Futures	3040.4	3042.3	3028.97	3032.24	198316.0
2018-11-09 10:00:00	ES	Futures	3032.24	3034.96	3022.72	3027.34	227160.0
2018-11-09 11:00:00	ES	Futures	3027.34	3031.15	3016.46	3018.36	210169.0
2018-11-09 12:00:00	ES	Futures	3018.36	3025.16	3014.83	3020.0	135987.0
2018-11-09 13:00:00	ES	Futures	3020.0	3021.9	3011.56	3014.01	100539.0
2018-11-09 14:00:00	ES	Futures	3014.01	3027.61	3007.76	3022.99	186830.0
2018-11-09 15:00:00	ES	Futures	3023.26	3036.86	3021.08	3025.71	317362.0
2018-11-09 16:00:00	ES	Futures	3025.98	3027.34	3020.81	3023.26	82909.0
2018-11-09 00:00:00	NQ	Futures	8396.41	8398.46	8379.11	8382.92	3163.0
2018-11-09 01:00:00	NQ	Futures	8382.92	8388.49	8380.28	8382.62	1409.0
2018-11-09 02:00:00	NQ	Futures	8382.62	8382.92	8354.47	8362.68	6104.0
2018-11-09 03:00:00	NQ	Futures	8362.39	8363.56	8339.51	8351.24	9648.0
2018-11-09 04:00:00	NQ	Futures	8350.95	8365.32	8345.08	8360.33	5629.0
2018-11-09 05:00:00	NQ	Futures	8360.33	8363.56	8334.52	8337.16	5788.0
2018-11-09 06:00:00	NQ	Futures	8337.45	8347.13	8322.2	8335.4	9621.0
2018-11-09 07:00:00	NQ	Futures	8335.11	8344.79	8325.43	8341.85	8543.0
2018-11-09 08:00:00	NQ	Futures	8341.85	8352.12	8328.07	8339.51	15214.0
2018-11-09 09:00:00	NQ	Futures	8339.51	8349.19	8293.46	8311.64	75510.0
2018-11-09 10:00:00	NQ	Futures	8311.06	8324.84	8268.53	8280.55	89555.0
2018-11-09 11:00:00	NQ	Futures	8280.26	8293.46	8236.26	8240.95	77881.0
2018-11-09 12:00:00	NQ	Futures	8240.95	8259.14	8230.39	8243.3	45275.0
2018-11-09 13:00:00	NQ	Futures	8243.3	8254.74	8214.85	8219.84	41042.0
2018-11-09 14:00:00	NQ	Futures	8219.84	8267.06	8199.89	8253.86	72889.0
2018-11-09 15:00:00	NQ	Futures	8253.86	8292.58	8250.05	8266.77	81343.0
2018-11-09 16:00:00	NQ	Futures	8266.47	8269.11	8240.37	8246.82	14937.0
2018-11-09 00:00:00	YM	Futures	28480.7	28487.3	28453.6	28457.9	1819.0
2018-11-09 01:00:00	YM	Futures	28457.9	28463.4	28437.3	28438.4	1676.0
2018-11-09 02:00:00	YM	Futures	28439.5	28441.6	28381.9	28396.0	4921.0
2018-11-09 03:00:00	YM	Futures	28397.1	28399.3	28338.4	28358.0	6385.0
2018-11-09 04:00:00	YM	Futures	28355.8	28392.7	28339.5	28380.8	3464.0
2018-11-09 05:00:00	YM	Futures	28381.9	28392.7	28303.6	28317.8	4322.0
2018-11-09 06:00:00	YM	Futures	28317.8	28337.3	28288.4	28325.4	4547.0
2018-11-09 07:00:00	YM	Futures	28323.2	28353.6	28309.1	28338.4	3416.0
2018-11-09 08:00:00	YM	Futures	28339.5	28363.4	28301.5	28331.9	5328.0
2018-11-09 09:00:00	YM	Futures	28330.8	28367.8	28251.5	28289.5	27160.0
2018-11-09 10:00:00	YM	Futures	28288.4	28334.1	28234.1	28259.1	23524.0
2018-11-09 11:00:00	YM	Futures	28258.0	28290.6	28162.4	28180.9	26344.0
2018-11-09 12:00:00	YM	Futures	28182.0	28231.9	28151.5	28193.9	16920.0
2018-11-09 13:00:00	YM	Futures	28193.9	28203.7	28141.8	28161.3	11599.0
2018-11-09 14:00:00	YM	Futures	28160.2	28247.1	28112.4	28206.9	20473.0
2018-11-09 15:00:00	YM	Futures	28209.1	28331.9	28195.0	28230.9	26406.0

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

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