PREVIEW / futures_1hour / 2020-04-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-09.parquet
  size:    53 KB
  rows:    1,497

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
2020-04-09 00:00:00	ES	Futures	3001.27	3011.97	2995.23	3010.87	16376.0
2020-04-09 01:00:00	ES	Futures	3011.15	3011.42	2999.07	3004.01	10208.0
2020-04-09 02:00:00	ES	Futures	3004.29	3027.06	3004.01	3027.06	21629.0
2020-04-09 03:00:00	ES	Futures	3027.34	3039.69	3022.4	3036.67	44875.0
2020-04-09 04:00:00	ES	Futures	3036.67	3038.86	3002.64	3002.92	40140.0
2020-04-09 05:00:00	ES	Futures	3002.64	3009.5	2992.21	2994.96	44446.0
2020-04-09 06:00:00	ES	Futures	2995.23	3002.64	2979.59	2990.84	33345.0
2020-04-09 07:00:00	ES	Futures	2990.84	3005.66	2972.73	2981.79	50772.0
2020-04-09 08:00:00	ES	Futures	2981.79	3040.51	2964.77	3036.94	160718.0
2020-04-09 09:00:00	ES	Futures	3037.22	3077.28	3032.55	3075.91	298267.0
2020-04-09 10:00:00	ES	Futures	3075.91	3077.01	3038.04	3063.84	320731.0
2020-04-09 11:00:00	ES	Futures	3063.56	3068.23	3038.86	3064.66	218909.0
2020-04-09 12:00:00	ES	Futures	3064.93	3082.22	3061.09	3077.56	170648.0
2020-04-09 13:00:00	ES	Futures	3077.56	3083.87	3058.62	3069.87	154528.0
2020-04-09 14:00:00	ES	Futures	3069.6	3070.97	3021.03	3032.83	237303.0
2020-04-09 15:00:00	ES	Futures	3033.1	3059.17	3026.52	3051.49	319680.0
2020-04-09 16:00:00	ES	Futures	3051.21	3060.27	3046.55	3059.17	67500.0
2020-04-09 00:00:00	NQ	Futures	9332.74	9365.87	9311.88	9362.73	4975.0
2020-04-09 01:00:00	NQ	Futures	9363.59	9366.16	9328.17	9349.59	4078.0
2020-04-09 02:00:00	NQ	Futures	9350.16	9423.28	9349.59	9420.71	6251.0
2020-04-09 03:00:00	NQ	Futures	9421.57	9452.42	9407.0	9438.71	9194.0
2020-04-09 04:00:00	NQ	Futures	9437.28	9444.71	9346.45	9349.59	9720.0
2020-04-09 05:00:00	NQ	Futures	9349.59	9368.73	9314.17	9325.02	10403.0
2020-04-09 06:00:00	NQ	Futures	9325.02	9348.16	9291.32	9325.02	9676.0
2020-04-09 07:00:00	NQ	Futures	9325.6	9363.01	9276.75	9301.03	15004.0
2020-04-09 08:00:00	NQ	Futures	9300.17	9452.99	9256.76	9444.14	28272.0
2020-04-09 09:00:00	NQ	Futures	9445.56	9513.26	9411.86	9491.55	61574.0
2020-04-09 10:00:00	NQ	Futures	9492.98	9494.69	9319.6	9399.86	78504.0
2020-04-09 11:00:00	NQ	Futures	9399.58	9428.14	9328.17	9414.14	57776.0
2020-04-09 12:00:00	NQ	Futures	9415.0	9461.56	9393.29	9450.71	39311.0
2020-04-09 13:00:00	NQ	Futures	9451.28	9464.13	9403.0	9425.28	34899.0
2020-04-09 14:00:00	NQ	Futures	9425.57	9428.43	9314.46	9345.02	47913.0
2020-04-09 15:00:00	NQ	Futures	9344.73	9401.58	9325.88	9398.72	64891.0
2020-04-09 16:00:00	NQ	Futures	9398.72	9422.43	9383.58	9413.29	12267.0
2020-04-09 00:00:00	YM	Futures	25484.8	25582.2	25436.6	25575.7	3161.0
2020-04-09 01:00:00	YM	Futures	25572.4	25585.5	25477.1	25531.9	2669.0
2020-04-09 02:00:00	YM	Futures	25532.9	25766.2	25530.8	25766.2	3766.0
2020-04-09 03:00:00	YM	Futures	25764.1	25849.5	25695.1	25818.8	8742.0
2020-04-09 04:00:00	YM	Futures	25817.7	25838.5	25518.7	25518.7	7329.0
2020-04-09 05:00:00	YM	Futures	25516.5	25571.3	25420.1	25440.9	8190.0
2020-04-09 06:00:00	YM	Futures	25438.7	25520.9	25352.2	25439.8	7367.0
2020-04-09 07:00:00	YM	Futures	25438.7	25565.8	25262.4	25357.7	10365.0
2020-04-09 08:00:00	YM	Futures	25358.8	25864.8	25214.2	25837.4	18845.0
2020-04-09 09:00:00	YM	Futures	25838.5	26148.5	25802.4	26138.7	32810.0
2020-04-09 10:00:00	YM	Futures	26138.7	26147.4	25791.4	25989.7	33934.0
2020-04-09 11:00:00	YM	Futures	25989.7	26078.4	25807.9	26033.5	26116.0
2020-04-09 12:00:00	YM	Futures	26034.6	26156.2	25985.3	26109.1	17481.0
2020-04-09 13:00:00	YM	Futures	26109.1	26166.0	25934.9	26040.1	15649.0
2020-04-09 14:00:00	YM	Futures	26043.4	26058.7	25607.4	25717.0	18571.0
2020-04-09 15:00:00	YM	Futures	25718.1	25954.6	25675.3	25849.5	25459.0

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

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