PREVIEW / futures_1hour / 2020-04-06

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-04-06.parquet
  size:    62 KB
  rows:    1,847

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-06 00:00:00	ES	Futures	2817.14	2826.19	2813.02	2819.88	10307.0
2020-04-06 01:00:00	ES	Futures	2819.88	2839.36	2814.39	2833.05	18851.0
2020-04-06 02:00:00	ES	Futures	2833.05	2839.36	2823.45	2825.64	27924.0
2020-04-06 03:00:00	ES	Futures	2825.64	2839.36	2821.53	2834.7	29865.0
2020-04-06 04:00:00	ES	Futures	2834.7	2836.07	2817.41	2830.03	31227.0
2020-04-06 05:00:00	ES	Futures	2830.31	2837.17	2822.63	2832.5	19177.0
2020-04-06 06:00:00	ES	Futures	2832.78	2834.97	2821.8	2829.76	13658.0
2020-04-06 07:00:00	ES	Futures	2829.76	2830.58	2822.63	2826.19	18981.0
2020-04-06 08:00:00	ES	Futures	2826.19	2830.58	2814.39	2827.57	36079.0
2020-04-06 09:00:00	ES	Futures	2827.57	2852.54	2814.39	2849.79	195805.0
2020-04-06 10:00:00	ES	Futures	2850.07	2861.32	2838.54	2845.4	225416.0
2020-04-06 11:00:00	ES	Futures	2845.4	2866.53	2840.46	2861.87	141470.0
2020-04-06 12:00:00	ES	Futures	2862.14	2879.98	2859.67	2879.15	167798.0
2020-04-06 13:00:00	ES	Futures	2879.15	2885.74	2870.65	2884.37	128141.0
2020-04-06 14:00:00	ES	Futures	2884.09	2884.64	2867.36	2879.98	134902.0
2020-04-06 15:00:00	ES	Futures	2879.7	2929.1	2871.75	2905.22	432490.0
2020-04-06 16:00:00	ES	Futures	2905.22	2909.89	2896.44	2906.05	121941.0
2020-04-06 18:00:00	ES	Futures	2903.85	2907.97	2892.33	2896.99	14868.0
2020-04-06 19:00:00	ES	Futures	2896.99	2924.98	2895.35	2923.88	17901.0
2020-04-06 20:00:00	ES	Futures	2923.88	2928.55	2906.32	2913.73	23461.0
2020-04-06 21:00:00	ES	Futures	2913.73	2918.67	2894.8	2896.72	16117.0
2020-04-06 22:00:00	ES	Futures	2896.99	2906.87	2890.13	2906.6	19309.0
2020-04-06 23:00:00	ES	Futures	2906.32	2907.69	2879.7	2884.37	26125.0
2020-04-06 00:00:00	NQ	Futures	8900.28	8924.84	8882.0	8900.85	4411.0
2020-04-06 01:00:00	NQ	Futures	8900.85	8962.83	8881.14	8942.27	7214.0
2020-04-06 02:00:00	NQ	Futures	8941.41	8991.97	8927.41	8938.27	9228.0
2020-04-06 03:00:00	NQ	Futures	8939.12	8972.54	8928.27	8954.83	6634.0
2020-04-06 04:00:00	NQ	Futures	8953.69	8957.4	8905.7	8953.41	7263.0
2020-04-06 05:00:00	NQ	Futures	8953.12	8967.12	8926.56	8952.26	5121.0
2020-04-06 06:00:00	NQ	Futures	8952.55	8961.4	8924.56	8941.41	4062.0
2020-04-06 07:00:00	NQ	Futures	8941.12	8941.12	8904.56	8919.7	7473.0
2020-04-06 08:00:00	NQ	Futures	8919.41	8933.98	8889.42	8925.7	8259.0
2020-04-06 09:00:00	NQ	Futures	8925.98	8976.54	8854.86	8970.83	46538.0
2020-04-06 10:00:00	NQ	Futures	8970.54	9004.82	8946.84	8974.26	44002.0
2020-04-06 11:00:00	NQ	Futures	8973.97	9024.24	8962.26	9014.25	29294.0
2020-04-06 12:00:00	NQ	Futures	9014.25	9069.09	9005.11	9067.38	26291.0
2020-04-06 13:00:00	NQ	Futures	9067.66	9095.94	9045.67	9095.08	21459.0
2020-04-06 14:00:00	NQ	Futures	9094.8	9097.37	9040.24	9088.51	23222.0
2020-04-06 15:00:00	NQ	Futures	9088.51	9253.61	9068.8	9201.63	63763.0
2020-04-06 16:00:00	NQ	Futures	9201.34	9201.34	9161.35	9181.35	13563.0
2020-04-06 18:00:00	NQ	Futures	9179.63	9181.92	9141.07	9143.93	5096.0
2020-04-06 19:00:00	NQ	Futures	9143.93	9237.05	9137.64	9232.76	6561.0
2020-04-06 20:00:00	NQ	Futures	9234.19	9251.04	9169.35	9189.63	8343.0
2020-04-06 21:00:00	NQ	Futures	9191.06	9201.34	9137.93	9142.79	5851.0
2020-04-06 22:00:00	NQ	Futures	9143.36	9151.35	9114.79	9149.64	6673.0
2020-04-06 23:00:00	NQ	Futures	9150.21	9153.93	9081.09	9095.65	6496.0
2020-04-06 00:00:00	YM	Futures	23710.3	23782.6	23680.8	23732.2	2317.0
2020-04-06 01:00:00	YM	Futures	23733.3	23918.4	23693.9	23859.3	4873.0
2020-04-06 02:00:00	YM	Futures	23860.4	23920.6	23787.0	23808.9	5378.0
2020-04-06 03:00:00	YM	Futures	23806.7	23917.4	23772.8	23884.5	7554.0

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

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