PREVIEW / futures_1hour / 2020-01-10

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-01-10.parquet
  size:    49 KB
  rows:    1,502

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-01-10 00:00:00	ES	Futures	3558.9	3560.0	3557.8	3560.0	4010.0
2020-01-10 01:00:00	ES	Futures	3560.3	3561.1	3558.9	3559.7	7814.0
2020-01-10 02:00:00	ES	Futures	3559.5	3560.5	3557.8	3559.7	10008.0
2020-01-10 03:00:00	ES	Futures	3559.5	3559.7	3554.9	3556.7	19047.0
2020-01-10 04:00:00	ES	Futures	3556.5	3559.2	3555.7	3559.2	12248.0
2020-01-10 05:00:00	ES	Futures	3559.2	3560.5	3558.6	3558.9	12294.0
2020-01-10 06:00:00	ES	Futures	3558.9	3563.0	3558.6	3561.1	11422.0
2020-01-10 07:00:00	ES	Futures	3560.8	3561.1	3558.1	3559.2	14070.0
2020-01-10 08:00:00	ES	Futures	3559.2	3559.7	3552.7	3557.3	66011.0
2020-01-10 09:00:00	ES	Futures	3557.3	3559.2	3549.7	3556.2	232226.0
2020-01-10 10:00:00	ES	Futures	3556.2	3559.5	3553.5	3556.7	190657.0
2020-01-10 11:00:00	ES	Futures	3557.0	3557.8	3548.1	3550.0	150658.0
2020-01-10 12:00:00	ES	Futures	3550.0	3550.5	3542.9	3548.9	160762.0
2020-01-10 13:00:00	ES	Futures	3549.2	3553.2	3548.6	3551.6	65510.0
2020-01-10 14:00:00	ES	Futures	3551.9	3552.4	3544.0	3546.4	103141.0
2020-01-10 15:00:00	ES	Futures	3546.4	3547.0	3534.5	3539.9	282786.0
2020-01-10 16:00:00	ES	Futures	3539.9	3540.5	3537.2	3537.5	58164.0
2020-01-10 00:00:00	NQ	Futures	10452.75	10456.79	10448.99	10456.22	2256.0
2020-01-10 01:00:00	NQ	Futures	10456.51	10460.84	10453.04	10454.19	3454.0
2020-01-10 02:00:00	NQ	Futures	10454.19	10459.4	10449.85	10455.93	4495.0
2020-01-10 03:00:00	NQ	Futures	10455.64	10456.51	10438.58	10445.23	7217.0
2020-01-10 04:00:00	NQ	Futures	10445.52	10457.95	10443.78	10456.79	4892.0
2020-01-10 05:00:00	NQ	Futures	10457.37	10463.73	10455.06	10457.66	4295.0
2020-01-10 06:00:00	NQ	Futures	10457.66	10474.43	10457.08	10466.34	5922.0
2020-01-10 07:00:00	NQ	Futures	10466.34	10468.36	10462.58	10464.31	3749.0
2020-01-10 08:00:00	NQ	Futures	10464.31	10471.83	10440.89	10455.93	28637.0
2020-01-10 09:00:00	NQ	Futures	10455.93	10462.29	10415.44	10445.23	75784.0
2020-01-10 10:00:00	NQ	Futures	10444.94	10459.4	10437.42	10451.3	61871.0
2020-01-10 11:00:00	NQ	Futures	10451.59	10458.82	10422.09	10429.61	47559.0
2020-01-10 12:00:00	NQ	Futures	10430.19	10430.48	10397.51	10416.89	57709.0
2020-01-10 13:00:00	NQ	Futures	10416.89	10432.79	10415.44	10424.99	23473.0
2020-01-10 14:00:00	NQ	Futures	10425.27	10429.32	10396.07	10411.97	30884.0
2020-01-10 15:00:00	NQ	Futures	10411.39	10413.13	10371.2	10390.28	67867.0
2020-01-10 16:00:00	NQ	Futures	10390.28	10392.6	10381.9	10385.08	10651.0
2020-01-10 00:00:00	YM	Futures	31574.6	31587.7	31564.8	31585.5	992.0
2020-01-10 01:00:00	YM	Futures	31586.6	31597.5	31572.4	31579.0	1833.0
2020-01-10 02:00:00	YM	Futures	31579.0	31589.9	31559.4	31572.4	2543.0
2020-01-10 03:00:00	YM	Futures	31571.4	31573.5	31527.8	31546.3	4486.0
2020-01-10 04:00:00	YM	Futures	31545.2	31562.6	31533.2	31561.6	2957.0
2020-01-10 05:00:00	YM	Futures	31561.6	31571.4	31551.8	31552.8	2484.0
2020-01-10 06:00:00	YM	Futures	31552.8	31583.3	31552.8	31567.0	3177.0
2020-01-10 07:00:00	YM	Futures	31567.0	31568.1	31543.0	31552.8	2022.0
2020-01-10 08:00:00	YM	Futures	31551.8	31555.0	31493.0	31524.5	10955.0
2020-01-10 09:00:00	YM	Futures	31524.5	31538.7	31454.9	31516.9	29636.0
2020-01-10 10:00:00	YM	Futures	31518.0	31544.1	31483.2	31501.7	21093.0
2020-01-10 11:00:00	YM	Futures	31502.8	31503.9	31387.4	31402.6	19394.0
2020-01-10 12:00:00	YM	Futures	31402.6	31430.9	31352.5	31415.7	19657.0
2020-01-10 13:00:00	YM	Futures	31415.7	31460.3	31410.2	31441.8	8443.0
2020-01-10 14:00:00	YM	Futures	31442.9	31447.2	31377.6	31391.7	10470.0
2020-01-10 15:00:00	YM	Futures	31390.6	31393.9	31302.4	31348.2	27099.0

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

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