PREVIEW / futures_1hour / 2019-03-25

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-25.parquet
  size:    56 KB
  rows:    1,755

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-03-25 00:00:00	ES	Futures	3034.45	3034.99	3032.28	3034.72	4440.0
2019-03-25 01:00:00	ES	Futures	3034.72	3035.53	3032.01	3032.82	5554.0
2019-03-25 02:00:00	ES	Futures	3032.82	3033.91	3025.77	3027.13	12170.0
2019-03-25 03:00:00	ES	Futures	3027.13	3034.72	3027.13	3034.18	14739.0
2019-03-25 04:00:00	ES	Futures	3034.18	3040.41	3032.82	3035.26	26727.0
2019-03-25 05:00:00	ES	Futures	3035.26	3045.56	3035.26	3043.39	29283.0
2019-03-25 06:00:00	ES	Futures	3043.12	3047.46	3040.41	3043.67	16098.0
2019-03-25 07:00:00	ES	Futures	3043.67	3043.94	3038.79	3039.06	17803.0
2019-03-25 08:00:00	ES	Futures	3039.06	3045.83	3037.97	3045.02	28895.0
2019-03-25 09:00:00	ES	Futures	3045.02	3050.98	3028.21	3029.03	280451.0
2019-03-25 10:00:00	ES	Futures	3029.03	3046.65	3025.77	3043.94	301606.0
2019-03-25 11:00:00	ES	Futures	3043.67	3052.88	3039.06	3039.06	199941.0
2019-03-25 12:00:00	ES	Futures	3039.33	3045.83	3032.55	3040.68	152434.0
2019-03-25 13:00:00	ES	Futures	3040.68	3044.48	3029.3	3030.92	154114.0
2019-03-25 14:00:00	ES	Futures	3030.65	3037.7	3024.96	3037.16	141185.0
2019-03-25 15:00:00	ES	Futures	3037.16	3044.75	3034.99	3040.14	193063.0
2019-03-25 16:00:00	ES	Futures	3039.87	3046.11	3038.79	3045.29	52651.0
2019-03-25 18:00:00	ES	Futures	3045.56	3046.11	3043.12	3043.12	6119.0
2019-03-25 19:00:00	ES	Futures	3043.12	3048.82	3042.85	3047.19	7305.0
2019-03-25 20:00:00	ES	Futures	3047.19	3051.8	3046.11	3049.9	12955.0
2019-03-25 21:00:00	ES	Futures	3050.17	3053.42	3049.09	3049.63	18732.0
2019-03-25 22:00:00	ES	Futures	3049.9	3054.78	3049.9	3053.15	8301.0
2019-03-25 23:00:00	ES	Futures	3053.42	3053.7	3050.98	3053.42	8966.0
2019-03-25 00:00:00	NQ	Futures	8522.72	8523.88	8513.99	8522.43	2114.0
2019-03-25 01:00:00	NQ	Futures	8523.3	8527.67	8514.57	8517.19	3088.0
2019-03-25 02:00:00	NQ	Futures	8517.77	8520.39	8490.11	8495.35	5871.0
2019-03-25 03:00:00	NQ	Futures	8495.64	8517.77	8495.06	8515.15	6803.0
2019-03-25 04:00:00	NQ	Futures	8515.15	8539.9	8515.15	8522.43	12808.0
2019-03-25 05:00:00	NQ	Futures	8522.14	8553.87	8521.85	8547.76	12932.0
2019-03-25 06:00:00	NQ	Futures	8547.47	8558.53	8540.77	8547.76	7147.0
2019-03-25 07:00:00	NQ	Futures	8548.05	8548.92	8532.04	8535.82	7551.0
2019-03-25 08:00:00	NQ	Futures	8535.82	8573.38	8530.58	8568.14	13746.0
2019-03-25 09:00:00	NQ	Futures	8568.14	8585.03	8504.67	8510.78	99285.0
2019-03-25 10:00:00	NQ	Futures	8511.36	8560.86	8494.19	8551.84	99979.0
2019-03-25 11:00:00	NQ	Futures	8551.84	8580.95	8540.77	8542.23	64173.0
2019-03-25 12:00:00	NQ	Futures	8542.23	8569.01	8524.76	8547.18	47619.0
2019-03-25 13:00:00	NQ	Futures	8547.47	8559.41	8507.87	8514.28	45424.0
2019-03-25 14:00:00	NQ	Futures	8514.28	8539.9	8500.59	8539.02	43801.0
2019-03-25 15:00:00	NQ	Futures	8538.44	8567.85	8533.78	8556.49	54122.0
2019-03-25 16:00:00	NQ	Futures	8556.49	8575.71	8550.38	8573.67	9774.0
2019-03-25 18:00:00	NQ	Futures	8575.13	8575.13	8563.19	8563.77	2196.0
2019-03-25 19:00:00	NQ	Futures	8563.77	8581.24	8562.9	8577.46	3301.0
2019-03-25 20:00:00	NQ	Futures	8577.17	8598.42	8574.84	8594.34	6557.0
2019-03-25 21:00:00	NQ	Futures	8594.34	8603.95	8585.61	8587.07	6253.0
2019-03-25 22:00:00	NQ	Futures	8587.07	8598.71	8585.03	8591.72	3787.0
2019-03-25 23:00:00	NQ	Futures	8591.72	8593.18	8585.03	8592.02	2875.0
2019-03-25 00:00:00	YM	Futures	27697.4	27701.8	27671.3	27694.2	1019.0
2019-03-25 01:00:00	YM	Futures	27695.3	27700.7	27662.6	27669.2	1482.0
2019-03-25 02:00:00	YM	Futures	27670.3	27681.1	27601.7	27619.1	3592.0
2019-03-25 03:00:00	YM	Futures	27619.1	27687.7	27617.0	27682.2	3967.0

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

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