PREVIEW / futures_1hour / 2020-03-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-10.parquet
  size:    61 KB
  rows:    1,760

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-03-10 00:00:00	ES	Futures	3055.14	3065.44	3047.56	3062.73	28598.0
2020-03-10 01:00:00	ES	Futures	3063.0	3089.02	3062.46	3086.31	24557.0
2020-03-10 02:00:00	ES	Futures	3086.04	3087.93	3072.49	3084.95	19526.0
2020-03-10 03:00:00	ES	Futures	3084.95	3085.22	3046.74	3054.06	36553.0
2020-03-10 04:00:00	ES	Futures	3054.33	3093.62	3040.78	3092.54	63729.0
2020-03-10 05:00:00	ES	Futures	3092.54	3119.37	3083.33	3115.57	61647.0
2020-03-10 06:00:00	ES	Futures	3115.85	3120.72	3103.65	3114.22	48102.0
2020-03-10 07:00:00	ES	Futures	3114.22	3115.03	3090.37	3094.98	45453.0
2020-03-10 08:00:00	ES	Futures	3094.98	3103.65	3054.06	3076.28	131740.0
2020-03-10 09:00:00	ES	Futures	3075.74	3084.95	3038.61	3057.58	253010.0
2020-03-10 10:00:00	ES	Futures	3057.31	3080.62	3012.87	3013.41	327520.0
2020-03-10 11:00:00	ES	Futures	3013.41	3032.38	2957.59	2979.54	450739.0
2020-03-10 12:00:00	ES	Futures	2979.81	3032.38	2979.54	3010.97	322544.0
2020-03-10 13:00:00	ES	Futures	3010.97	3038.88	2990.11	2997.97	252309.0
2020-03-10 14:00:00	ES	Futures	2998.24	3069.24	2986.31	3055.96	276544.0
2020-03-10 15:00:00	ES	Futures	3055.96	3123.98	3050.54	3123.16	484246.0
2020-03-10 16:00:00	ES	Futures	3122.89	3126.96	3099.86	3118.28	142001.0
2020-03-10 18:00:00	ES	Futures	3099.59	3110.43	3069.24	3075.2	40156.0
2020-03-10 19:00:00	ES	Futures	3075.47	3083.87	3047.83	3064.36	33373.0
2020-03-10 20:00:00	ES	Futures	3064.36	3077.64	3040.51	3054.6	42557.0
2020-03-10 21:00:00	ES	Futures	3054.87	3069.51	3026.96	3043.22	42927.0
2020-03-10 22:00:00	ES	Futures	3043.49	3055.69	3026.96	3040.78	33316.0
2020-03-10 23:00:00	ES	Futures	3040.78	3054.6	3032.65	3047.29	26832.0
2020-03-10 00:00:00	NQ	Futures	9466.95	9504.26	9443.24	9493.27	8204.0
2020-03-10 01:00:00	NQ	Futures	9493.85	9572.79	9493.27	9558.04	9642.0
2020-03-10 02:00:00	NQ	Futures	9557.75	9569.32	9517.56	9555.73	9018.0
2020-03-10 03:00:00	NQ	Futures	9555.15	9556.31	9442.95	9473.32	12969.0
2020-03-10 04:00:00	NQ	Futures	9472.16	9582.62	9429.65	9580.89	16704.0
2020-03-10 05:00:00	NQ	Futures	9580.89	9639.01	9542.72	9628.02	17387.0
2020-03-10 06:00:00	NQ	Futures	9628.02	9653.76	9598.24	9634.96	12216.0
2020-03-10 07:00:00	NQ	Futures	9634.68	9637.57	9551.39	9569.61	13874.0
2020-03-10 08:00:00	NQ	Futures	9570.19	9593.03	9452.21	9518.72	34411.0
2020-03-10 09:00:00	NQ	Futures	9517.85	9536.36	9409.7	9471.0	99829.0
2020-03-10 10:00:00	NQ	Futures	9470.71	9547.34	9349.55	9350.71	128111.0
2020-03-10 11:00:00	NQ	Futures	9350.42	9412.01	9174.02	9255.86	150864.0
2020-03-10 12:00:00	NQ	Futures	9256.73	9412.01	9256.73	9354.76	124067.0
2020-03-10 13:00:00	NQ	Futures	9353.89	9439.19	9293.45	9314.56	72647.0
2020-03-10 14:00:00	NQ	Futures	9315.14	9507.73	9265.98	9476.79	76343.0
2020-03-10 15:00:00	NQ	Futures	9478.81	9677.47	9464.35	9677.47	84322.0
2020-03-10 16:00:00	NQ	Futures	9677.47	9691.64	9614.43	9665.33	20972.0
2020-03-10 18:00:00	NQ	Futures	9620.22	9640.17	9508.88	9529.71	9238.0
2020-03-10 19:00:00	NQ	Futures	9528.55	9554.28	9443.24	9498.76	8859.0
2020-03-10 20:00:00	NQ	Futures	9497.61	9542.72	9431.1	9472.16	11052.0
2020-03-10 21:00:00	NQ	Futures	9472.45	9513.8	9389.17	9434.28	15273.0
2020-03-10 22:00:00	NQ	Futures	9435.15	9479.68	9387.14	9438.62	9564.0
2020-03-10 23:00:00	NQ	Futures	9438.9	9479.1	9411.14	9459.44	7555.0
2020-03-10 00:00:00	YM	Futures	26661.1	26747.7	26596.5	26713.7	14.0
2020-03-10 01:00:00	YM	Futures	26747.7	26955.8	26744.4	26914.1	149.0
2020-03-10 02:00:00	YM	Futures	26901.0	26926.2	26821.0	26912.0	45.0
2020-03-10 03:00:00	YM	Futures	26846.2	26883.5	26603.1	26695.1	54.0

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

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