PREVIEW / futures_1hour / 2019-12-16

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-16.parquet
  size:    58 KB
  rows:    1,838

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-12-16 00:00:00	ES	Futures	3451.6	3451.6	3450.2	3450.2	3137.0
2019-12-16 01:00:00	ES	Futures	3450.2	3452.7	3448.9	3451.1	7605.0
2019-12-16 02:00:00	ES	Futures	3451.3	3452.7	3450.0	3450.0	8794.0
2019-12-16 03:00:00	ES	Futures	3450.2	3454.6	3450.0	3453.0	29148.0
2019-12-16 04:00:00	ES	Futures	3453.0	3453.5	3451.1	3453.0	10254.0
2019-12-16 05:00:00	ES	Futures	3453.0	3453.5	3450.8	3451.9	6993.0
2019-12-16 06:00:00	ES	Futures	3452.1	3455.7	3452.1	3453.5	11976.0
2019-12-16 07:00:00	ES	Futures	3453.5	3457.6	3453.5	3457.3	20456.0
2019-12-16 08:00:00	ES	Futures	3457.3	3461.1	3457.0	3460.3	24582.0
2019-12-16 09:00:00	ES	Futures	3460.5	3465.7	3459.7	3462.4	188739.0
2019-12-16 10:00:00	ES	Futures	3462.7	3469.8	3462.2	3467.6	163741.0
2019-12-16 11:00:00	ES	Futures	3467.9	3470.0	3466.2	3469.8	91124.0
2019-12-16 12:00:00	ES	Futures	3469.8	3471.1	3468.9	3469.5	45971.0
2019-12-16 13:00:00	ES	Futures	3469.5	3471.4	3468.1	3470.3	42162.0
2019-12-16 14:00:00	ES	Futures	3470.6	3471.4	3466.0	3466.2	64119.0
2019-12-16 15:00:00	ES	Futures	3466.2	3468.9	3464.1	3464.3	167112.0
2019-12-16 16:00:00	ES	Futures	3464.1	3468.7	3463.5	3466.2	57615.0
2019-12-16 18:00:00	ES	Futures	3464.9	3466.2	3462.7	3463.0	7888.0
2019-12-16 19:00:00	ES	Futures	3462.7	3463.8	3461.1	3462.2	7932.0
2019-12-16 20:00:00	ES	Futures	3462.2	3464.3	3461.6	3463.0	7527.0
2019-12-16 21:00:00	ES	Futures	3463.0	3465.2	3461.6	3465.2	5071.0
2019-12-16 22:00:00	ES	Futures	3464.9	3467.0	3464.6	3466.8	4482.0
2019-12-16 23:00:00	ES	Futures	3466.5	3468.7	3466.2	3466.5	5431.0
2019-12-16 00:00:00	NQ	Futures	9885.97	9886.83	9881.63	9882.21	1053.0
2019-12-16 01:00:00	NQ	Futures	9882.21	9893.77	9878.74	9890.02	3232.0
2019-12-16 02:00:00	NQ	Futures	9890.02	9895.22	9885.39	9885.39	3656.0
2019-12-16 03:00:00	NQ	Futures	9885.68	9899.85	9884.52	9893.49	11050.0
2019-12-16 04:00:00	NQ	Futures	9893.49	9896.38	9890.02	9894.06	4449.0
2019-12-16 05:00:00	NQ	Futures	9894.06	9895.22	9886.83	9889.73	3095.0
2019-12-16 06:00:00	NQ	Futures	9890.02	9899.56	9889.73	9895.8	4926.0
2019-12-16 07:00:00	NQ	Futures	9896.09	9908.52	9895.22	9907.94	6152.0
2019-12-16 08:00:00	NQ	Futures	9908.23	9917.78	9906.79	9915.75	7905.0
2019-12-16 09:00:00	NQ	Futures	9916.04	9952.19	9914.31	9942.93	46303.0
2019-12-16 10:00:00	NQ	Futures	9943.51	9965.49	9940.33	9959.13	35002.0
2019-12-16 11:00:00	NQ	Futures	9958.84	9962.89	9952.77	9960.86	19890.0
2019-12-16 12:00:00	NQ	Futures	9960.57	9967.51	9958.55	9961.73	13692.0
2019-12-16 13:00:00	NQ	Futures	9961.73	9966.07	9955.66	9964.91	11250.0
2019-12-16 14:00:00	NQ	Futures	9964.91	9967.8	9953.34	9955.95	14320.0
2019-12-16 15:00:00	NQ	Futures	9955.95	9963.75	9948.72	9949.3	33695.0
2019-12-16 16:00:00	NQ	Futures	9949.58	9962.02	9947.85	9956.24	7108.0
2019-12-16 18:00:00	NQ	Futures	9952.77	9955.37	9945.83	9946.11	2753.0
2019-12-16 19:00:00	NQ	Futures	9946.11	9947.85	9939.17	9942.07	3135.0
2019-12-16 20:00:00	NQ	Futures	9941.78	9951.32	9940.62	9947.56	2720.0
2019-12-16 21:00:00	NQ	Futures	9947.56	9953.05	9944.38	9952.77	2217.0
2019-12-16 22:00:00	NQ	Futures	9953.05	9959.13	9951.32	9957.39	1888.0
2019-12-16 23:00:00	NQ	Futures	9957.68	9963.75	9957.68	9960.28	1936.0
2019-12-16 00:00:00	YM	Futures	30679.7	30680.8	30657.9	30660.1	773.0
2019-12-16 01:00:00	YM	Futures	30660.1	30691.6	30652.5	30679.7	1654.0
2019-12-16 02:00:00	YM	Futures	30679.7	30690.6	30661.2	30666.6	3010.0
2019-12-16 03:00:00	YM	Futures	30666.6	30734.1	30664.4	30717.8	8993.0

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

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