PREVIEW / futures_1hour / 2020-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-21.parquet
  size:    63 KB
  rows:    1,864

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-21 00:00:00	ES	Futures	3062.19	3072.34	3057.8	3065.48	9056.0
2020-04-21 01:00:00	ES	Futures	3065.76	3072.34	3057.8	3062.46	9587.0
2020-04-21 02:00:00	ES	Futures	3062.46	3078.65	3062.46	3074.26	18880.0
2020-04-21 03:00:00	ES	Futures	3073.99	3081.95	3054.78	3060.27	30101.0
2020-04-21 04:00:00	ES	Futures	3060.27	3073.99	3059.45	3065.21	22648.0
2020-04-21 05:00:00	ES	Futures	3065.48	3072.34	3042.98	3050.12	47980.0
2020-04-21 06:00:00	ES	Futures	3050.12	3056.98	3033.1	3039.41	48855.0
2020-04-21 07:00:00	ES	Futures	3039.69	3044.08	3023.5	3028.71	47325.0
2020-04-21 08:00:00	ES	Futures	3028.71	3032.55	3016.09	3018.83	66474.0
2020-04-21 09:00:00	ES	Futures	3018.83	3048.74	3015.54	3044.35	211839.0
2020-04-21 10:00:00	ES	Futures	3044.08	3046.27	3005.39	3006.21	242180.0
2020-04-21 11:00:00	ES	Futures	3005.93	3008.13	2983.43	2999.62	264635.0
2020-04-21 12:00:00	ES	Futures	2999.35	3002.09	2982.61	2997.7	135694.0
2020-04-21 13:00:00	ES	Futures	2997.7	3015.26	2995.51	3004.29	142462.0
2020-04-21 14:00:00	ES	Futures	3004.29	3022.95	2995.78	2998.25	170864.0
2020-04-21 15:00:00	ES	Futures	2998.53	3021.03	2987.55	2993.31	266801.0
2020-04-21 16:00:00	ES	Futures	2993.59	3002.09	2993.31	3000.17	66539.0
2020-04-21 18:00:00	ES	Futures	3004.56	3016.09	3001.54	3006.48	12077.0
2020-04-21 19:00:00	ES	Futures	3006.21	3010.05	2996.88	3009.23	9241.0
2020-04-21 20:00:00	ES	Futures	3009.23	3017.46	2982.61	3002.09	27584.0
2020-04-21 21:00:00	ES	Futures	3002.09	3010.05	2994.13	3004.01	15953.0
2020-04-21 22:00:00	ES	Futures	3003.74	3010.05	2996.6	3009.78	12146.0
2020-04-21 23:00:00	ES	Futures	3010.05	3010.05	2997.43	3005.93	10343.0
2020-04-21 00:00:00	NQ	Futures	9880.31	9910.59	9867.17	9893.45	4161.0
2020-04-21 01:00:00	NQ	Futures	9894.31	9915.73	9875.17	9888.59	4736.0
2020-04-21 02:00:00	NQ	Futures	9889.74	9937.15	9889.74	9926.01	7375.0
2020-04-21 03:00:00	NQ	Futures	9925.16	9950.86	9879.45	9896.88	11720.0
2020-04-21 04:00:00	NQ	Futures	9896.88	9932.87	9894.88	9917.73	9164.0
2020-04-21 05:00:00	NQ	Futures	9918.3	9937.72	9876.6	9896.88	14811.0
2020-04-21 06:00:00	NQ	Futures	9897.16	9913.73	9836.61	9850.6	13756.0
2020-04-21 07:00:00	NQ	Futures	9851.75	9867.17	9830.89	9835.75	12045.0
2020-04-21 08:00:00	NQ	Futures	9835.18	9857.46	9820.33	9834.32	20066.0
2020-04-21 09:00:00	NQ	Futures	9834.61	9885.45	9746.34	9807.47	64678.0
2020-04-21 10:00:00	NQ	Futures	9807.47	9814.9	9583.81	9590.96	81338.0
2020-04-21 11:00:00	NQ	Futures	9591.53	9612.38	9531.26	9602.1	76643.0
2020-04-21 12:00:00	NQ	Futures	9600.1	9612.95	9542.68	9587.81	42340.0
2020-04-21 13:00:00	NQ	Futures	9588.38	9685.79	9580.67	9660.65	45207.0
2020-04-21 14:00:00	NQ	Futures	9660.65	9730.92	9613.52	9622.95	48199.0
2020-04-21 15:00:00	NQ	Futures	9622.95	9689.79	9572.67	9586.96	55938.0
2020-04-21 16:00:00	NQ	Futures	9587.24	9645.51	9584.96	9637.52	16385.0
2020-04-21 18:00:00	NQ	Futures	9651.23	9683.5	9640.37	9659.22	4268.0
2020-04-21 19:00:00	NQ	Futures	9659.51	9667.79	9627.52	9664.08	3905.0
2020-04-21 20:00:00	NQ	Futures	9663.51	9700.93	9597.53	9648.66	10212.0
2020-04-21 21:00:00	NQ	Futures	9649.8	9680.93	9628.66	9656.37	5738.0
2020-04-21 22:00:00	NQ	Futures	9655.8	9669.22	9630.09	9668.65	3293.0
2020-04-21 23:00:00	NQ	Futures	9668.65	9673.22	9641.23	9662.08	3325.0
2020-04-21 00:00:00	YM	Futures	25491.3	25578.9	25456.3	25516.5	2813.0
2020-04-21 01:00:00	YM	Futures	25522.0	25576.8	25467.2	25509.9	1882.0
2020-04-21 02:00:00	YM	Futures	25509.9	25651.2	25509.9	25605.2	4476.0
2020-04-21 03:00:00	YM	Futures	25606.3	25666.6	25433.3	25472.7	6441.0

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

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