PREVIEW / futures_1hour / 2019-08-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-08-19.parquet
  size:    58 KB
  rows:    1,831

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-08-19 00:00:00	ES	Futures	3146.41	3147.76	3146.13	3147.49	2163.0
2019-08-19 01:00:00	ES	Futures	3147.49	3151.55	3146.95	3149.92	11247.0
2019-08-19 02:00:00	ES	Futures	3149.65	3159.4	3148.84	3159.13	22238.0
2019-08-19 03:00:00	ES	Futures	3159.13	3162.92	3155.07	3156.96	39328.0
2019-08-19 04:00:00	ES	Futures	3156.69	3158.59	3152.09	3152.9	24400.0
2019-08-19 05:00:00	ES	Futures	3152.9	3158.86	3152.63	3158.05	18809.0
2019-08-19 06:00:00	ES	Futures	3158.32	3165.35	3156.15	3161.29	31414.0
2019-08-19 07:00:00	ES	Futures	3161.29	3171.04	3159.4	3164.81	49173.0
2019-08-19 08:00:00	ES	Futures	3164.81	3167.79	3159.94	3165.35	48965.0
2019-08-19 09:00:00	ES	Futures	3165.63	3168.33	3160.75	3163.46	158928.0
2019-08-19 10:00:00	ES	Futures	3163.46	3165.9	3156.96	3164.0	163557.0
2019-08-19 11:00:00	ES	Futures	3164.0	3171.04	3164.0	3167.25	123464.0
2019-08-19 12:00:00	ES	Futures	3167.25	3171.04	3164.81	3170.5	86538.0
2019-08-19 13:00:00	ES	Futures	3170.77	3175.1	3169.41	3170.5	77239.0
2019-08-19 14:00:00	ES	Futures	3170.5	3172.66	3167.52	3169.69	78958.0
2019-08-19 15:00:00	ES	Futures	3169.96	3173.2	3165.35	3166.71	176997.0
2019-08-19 16:00:00	ES	Futures	3166.71	3166.98	3162.92	3164.27	68704.0
2019-08-19 18:00:00	ES	Futures	3163.19	3165.35	3161.29	3164.54	5937.0
2019-08-19 19:00:00	ES	Futures	3164.54	3165.08	3159.4	3160.48	5793.0
2019-08-19 20:00:00	ES	Futures	3160.48	3161.84	3157.77	3158.59	12548.0
2019-08-19 21:00:00	ES	Futures	3158.86	3163.73	3157.5	3163.73	10282.0
2019-08-19 22:00:00	ES	Futures	3163.73	3169.14	3163.46	3168.87	10249.0
2019-08-19 23:00:00	ES	Futures	3169.14	3171.04	3166.71	3169.14	6666.0
2019-08-19 00:00:00	NQ	Futures	8885.03	8893.16	8884.45	8892.29	1548.0
2019-08-19 01:00:00	NQ	Futures	8892.58	8905.05	8890.25	8898.38	4760.0
2019-08-19 02:00:00	NQ	Futures	8898.38	8927.97	8893.74	8926.52	8962.0
2019-08-19 03:00:00	NQ	Futures	8926.81	8939.58	8911.43	8915.21	15796.0
2019-08-19 04:00:00	NQ	Futures	8914.92	8924.49	8899.83	8904.18	11233.0
2019-08-19 05:00:00	NQ	Futures	8904.47	8927.39	8902.73	8921.88	7271.0
2019-08-19 06:00:00	NQ	Futures	8922.17	8947.41	8914.63	8936.97	11540.0
2019-08-19 07:00:00	NQ	Futures	8936.97	8963.08	8927.97	8950.02	15566.0
2019-08-19 08:00:00	NQ	Futures	8950.31	8961.63	8936.39	8955.54	14164.0
2019-08-19 09:00:00	NQ	Futures	8955.83	8988.32	8949.44	8960.18	59876.0
2019-08-19 10:00:00	NQ	Futures	8960.18	8971.49	8930.87	8965.11	58753.0
2019-08-19 11:00:00	NQ	Futures	8965.11	8990.64	8964.53	8977.01	39024.0
2019-08-19 12:00:00	NQ	Futures	8977.3	8984.84	8968.3	8983.68	25899.0
2019-08-19 13:00:00	NQ	Futures	8983.39	8994.42	8979.33	8983.39	20088.0
2019-08-19 14:00:00	NQ	Futures	8983.39	8984.55	8968.3	8973.24	23950.0
2019-08-19 15:00:00	NQ	Futures	8973.53	8982.81	8963.66	8968.88	37809.0
2019-08-19 16:00:00	NQ	Futures	8968.59	8974.4	8954.67	8960.18	11284.0
2019-08-19 18:00:00	NQ	Futures	8956.41	8964.53	8951.76	8961.34	3245.0
2019-08-19 19:00:00	NQ	Futures	8961.34	8963.66	8944.22	8949.73	3323.0
2019-08-19 20:00:00	NQ	Futures	8949.73	8951.76	8938.13	8941.32	6242.0
2019-08-19 21:00:00	NQ	Futures	8941.32	8957.86	8936.97	8957.86	5745.0
2019-08-19 22:00:00	NQ	Futures	8958.15	8980.2	8957.86	8978.17	6424.0
2019-08-19 23:00:00	NQ	Futures	8978.17	8985.42	8971.49	8979.04	3883.0
2019-08-19 00:00:00	YM	Futures	28318.5	28323.9	28308.7	28320.7	692.0
2019-08-19 01:00:00	YM	Futures	28321.8	28353.3	28318.5	28342.4	2515.0
2019-08-19 02:00:00	YM	Futures	28342.4	28431.6	28340.3	28429.4	4518.0
2019-08-19 03:00:00	YM	Futures	28429.4	28459.9	28393.5	28407.7	5031.0

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

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