PREVIEW / futures_1hour / 2019-01-15

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-15.parquet
  size:    57 KB
  rows:    1,779

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-01-15 00:00:00	ES	Futures	2820.13	2824.75	2819.05	2821.76	8075.0
2019-01-15 01:00:00	ES	Futures	2821.49	2823.66	2820.41	2820.68	5545.0
2019-01-15 02:00:00	ES	Futures	2820.95	2822.31	2816.88	2818.23	8331.0
2019-01-15 03:00:00	ES	Futures	2818.23	2821.49	2814.16	2814.97	19001.0
2019-01-15 04:00:00	ES	Futures	2814.97	2815.25	2808.18	2809.0	20848.0
2019-01-15 05:00:00	ES	Futures	2809.27	2813.34	2807.91	2811.99	13203.0
2019-01-15 06:00:00	ES	Futures	2812.26	2815.52	2804.38	2806.01	25735.0
2019-01-15 07:00:00	ES	Futures	2806.01	2809.0	2804.11	2806.55	23947.0
2019-01-15 08:00:00	ES	Futures	2806.55	2809.54	2803.02	2806.01	29659.0
2019-01-15 09:00:00	ES	Futures	2806.28	2825.29	2805.2	2822.04	195560.0
2019-01-15 10:00:00	ES	Futures	2822.31	2832.08	2816.6	2826.65	346268.0
2019-01-15 11:00:00	ES	Futures	2826.38	2835.07	2822.04	2833.44	146749.0
2019-01-15 12:00:00	ES	Futures	2833.44	2839.42	2830.73	2832.9	119103.0
2019-01-15 13:00:00	ES	Futures	2832.9	2835.07	2830.18	2833.17	58389.0
2019-01-15 14:00:00	ES	Futures	2833.17	2836.97	2817.96	2828.55	155137.0
2019-01-15 15:00:00	ES	Futures	2828.28	2838.06	2827.2	2835.89	171440.0
2019-01-15 16:00:00	ES	Futures	2835.89	2835.89	2828.82	2830.73	71490.0
2019-01-15 18:00:00	ES	Futures	2830.73	2836.7	2829.91	2836.43	8042.0
2019-01-15 19:00:00	ES	Futures	2836.43	2836.7	2830.18	2832.36	14300.0
2019-01-15 20:00:00	ES	Futures	2832.63	2834.8	2827.2	2832.08	19673.0
2019-01-15 21:00:00	ES	Futures	2832.36	2835.89	2830.18	2835.61	8374.0
2019-01-15 22:00:00	ES	Futures	2835.34	2837.79	2834.53	2835.34	7592.0
2019-01-15 23:00:00	ES	Futures	2835.34	2838.33	2835.07	2837.24	4778.0
2019-01-15 00:00:00	NQ	Futures	7705.91	7720.81	7700.65	7712.34	3819.0
2019-01-15 01:00:00	NQ	Futures	7711.46	7721.69	7710.0	7712.05	2966.0
2019-01-15 02:00:00	NQ	Futures	7712.63	7716.14	7697.73	7703.28	4004.0
2019-01-15 03:00:00	NQ	Futures	7703.57	7711.17	7689.55	7693.35	7805.0
2019-01-15 04:00:00	NQ	Futures	7693.05	7694.51	7672.89	7676.98	7271.0
2019-01-15 05:00:00	NQ	Futures	7677.27	7690.72	7672.02	7687.79	4549.0
2019-01-15 06:00:00	NQ	Futures	7688.09	7698.6	7671.14	7676.4	8918.0
2019-01-15 07:00:00	NQ	Futures	7676.11	7684.29	7668.8	7682.83	10351.0
2019-01-15 08:00:00	NQ	Futures	7682.53	7692.76	7670.85	7680.2	9935.0
2019-01-15 09:00:00	NQ	Futures	7679.9	7769.9	7677.27	7765.81	82825.0
2019-01-15 10:00:00	NQ	Futures	7766.1	7794.44	7750.32	7770.48	100609.0
2019-01-15 11:00:00	NQ	Futures	7770.78	7803.79	7757.63	7800.29	47936.0
2019-01-15 12:00:00	NQ	Futures	7800.29	7817.82	7795.61	7800.58	39996.0
2019-01-15 13:00:00	NQ	Futures	7800.87	7812.85	7797.66	7804.96	18943.0
2019-01-15 14:00:00	NQ	Futures	7804.67	7814.31	7747.69	7783.05	53034.0
2019-01-15 15:00:00	NQ	Futures	7783.05	7812.56	7779.25	7809.34	42633.0
2019-01-15 16:00:00	NQ	Futures	7809.34	7812.56	7798.53	7805.55	13364.0
2019-01-15 18:00:00	NQ	Futures	7800.87	7821.32	7799.41	7819.86	4049.0
2019-01-15 19:00:00	NQ	Futures	7820.45	7820.74	7794.73	7806.42	6568.0
2019-01-15 20:00:00	NQ	Futures	7806.42	7814.31	7788.6	7804.67	6963.0
2019-01-15 21:00:00	NQ	Futures	7804.96	7815.19	7799.12	7813.14	4703.0
2019-01-15 22:00:00	NQ	Futures	7812.85	7821.03	7809.05	7811.39	3813.0
2019-01-15 23:00:00	NQ	Futures	7811.68	7818.99	7810.81	7816.36	1777.0
2019-01-15 00:00:00	YM	Futures	26078.7	26130.8	26066.7	26104.7	2830.0
2019-01-15 01:00:00	YM	Futures	26103.6	26116.7	26083.0	26088.4	1631.0
2019-01-15 02:00:00	YM	Futures	26089.5	26098.2	26048.3	26057.0	2729.0
2019-01-15 03:00:00	YM	Futures	26057.0	26092.8	26028.7	26034.2	5475.0

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

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