PREVIEW / futures_1hour / 2020-03-27

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-03-27.parquet
  size:    53 KB
  rows:    1,504

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-03-27 00:00:00	ES	Futures	2829.49	2830.86	2806.98	2810.0	16834.0
2020-03-27 01:00:00	ES	Futures	2810.0	2840.74	2799.57	2840.19	19404.0
2020-03-27 02:00:00	ES	Futures	2839.91	2855.01	2828.11	2836.9	19762.0
2020-03-27 03:00:00	ES	Futures	2837.17	2837.99	2811.92	2816.86	21655.0
2020-03-27 04:00:00	ES	Futures	2816.86	2832.78	2810.0	2811.65	31922.0
2020-03-27 05:00:00	ES	Futures	2811.92	2823.72	2799.03	2799.3	35301.0
2020-03-27 06:00:00	ES	Futures	2799.3	2820.16	2787.23	2789.15	45147.0
2020-03-27 07:00:00	ES	Futures	2789.42	2808.63	2775.98	2779.54	51952.0
2020-03-27 08:00:00	ES	Futures	2779.54	2805.34	2771.04	2772.41	69476.0
2020-03-27 09:00:00	ES	Futures	2772.41	2794.09	2749.91	2774.33	233511.0
2020-03-27 10:00:00	ES	Futures	2774.33	2789.97	2760.61	2774.33	206562.0
2020-03-27 11:00:00	ES	Futures	2774.33	2808.36	2766.37	2768.84	199777.0
2020-03-27 12:00:00	ES	Futures	2768.84	2797.38	2763.35	2796.28	156767.0
2020-03-27 13:00:00	ES	Futures	2796.28	2819.88	2780.09	2801.77	178712.0
2020-03-27 14:00:00	ES	Futures	2802.04	2825.1	2792.99	2823.72	146105.0
2020-03-27 15:00:00	ES	Futures	2824.0	2859.4	2768.84	2779.27	455336.0
2020-03-27 16:00:00	ES	Futures	2778.99	2786.95	2761.71	2766.1	107634.0
2020-03-27 00:00:00	NQ	Futures	8874.28	8878.0	8805.16	8823.15	2816.0
2020-03-27 01:00:00	NQ	Futures	8821.73	8888.85	8781.16	8887.71	4772.0
2020-03-27 02:00:00	NQ	Futures	8885.71	8919.7	8839.44	8872.57	6397.0
2020-03-27 03:00:00	NQ	Futures	8873.14	8876.57	8792.3	8806.87	6120.0
2020-03-27 04:00:00	NQ	Futures	8808.87	8863.43	8793.45	8814.87	7481.0
2020-03-27 05:00:00	NQ	Futures	8814.87	8850.0	8767.17	8772.31	9216.0
2020-03-27 06:00:00	NQ	Futures	8773.17	8829.72	8741.46	8751.74	9086.0
2020-03-27 07:00:00	NQ	Futures	8753.17	8810.59	8713.18	8727.75	11529.0
2020-03-27 08:00:00	NQ	Futures	8727.46	8792.88	8704.9	8734.32	14164.0
2020-03-27 09:00:00	NQ	Futures	8733.18	8789.16	8658.34	8722.32	44982.0
2020-03-27 10:00:00	NQ	Futures	8721.18	8753.17	8667.19	8696.61	44774.0
2020-03-27 11:00:00	NQ	Futures	8697.19	8794.3	8682.9	8685.76	46404.0
2020-03-27 12:00:00	NQ	Futures	8685.47	8745.46	8661.48	8742.32	35944.0
2020-03-27 13:00:00	NQ	Futures	8742.89	8819.15	8710.04	8775.74	40588.0
2020-03-27 14:00:00	NQ	Futures	8776.02	8838.58	8750.89	8834.86	34271.0
2020-03-27 15:00:00	NQ	Futures	8835.44	8912.27	8637.77	8652.91	73053.0
2020-03-27 16:00:00	NQ	Futures	8651.77	8680.05	8627.78	8638.92	14262.0
2020-03-27 00:00:00	YM	Futures	24231.7	24237.2	24057.6	24078.4	1579.0
2020-03-27 01:00:00	YM	Futures	24078.4	24316.0	23962.3	24302.9	2750.0
2020-03-27 02:00:00	YM	Futures	24301.8	24448.6	24208.7	24287.6	3565.0
2020-03-27 03:00:00	YM	Futures	24287.6	24294.1	24046.6	24124.4	5705.0
2020-03-27 04:00:00	YM	Futures	24120.0	24236.1	24055.4	24068.5	5996.0
2020-03-27 05:00:00	YM	Futures	24068.5	24155.0	23925.0	23930.5	6594.0
2020-03-27 06:00:00	YM	Futures	23927.2	24102.5	23808.9	23824.3	9250.0
2020-03-27 07:00:00	YM	Futures	23826.4	24002.8	23716.9	23741.0	9694.0
2020-03-27 08:00:00	YM	Futures	23731.1	23959.0	23658.9	23692.8	9318.0
2020-03-27 09:00:00	YM	Futures	23687.3	23818.8	23347.8	23549.3	32125.0
2020-03-27 10:00:00	YM	Futures	23552.6	23726.8	23466.1	23581.1	24619.0
2020-03-27 11:00:00	YM	Futures	23581.1	23903.1	23550.4	23575.6	22676.0
2020-03-27 12:00:00	YM	Futures	23577.8	23819.9	23550.4	23808.9	18436.0
2020-03-27 13:00:00	YM	Futures	23808.9	24037.8	23674.2	23865.9	17567.0
2020-03-27 14:00:00	YM	Futures	23869.2	23986.4	23780.4	23977.6	14507.0
2020-03-27 15:00:00	YM	Futures	23979.8	24299.6	23494.6	23536.2	44916.0

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

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