PREVIEW / futures_1hour / 2019-11-18

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-18.parquet
  size:    59 KB
  rows:    1,883

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-11-18 00:00:00	ES	Futures	3386.42	3388.6	3385.61	3388.32	7298.0
2019-11-18 01:00:00	ES	Futures	3388.6	3389.41	3388.05	3388.6	4894.0
2019-11-18 02:00:00	ES	Futures	3388.32	3398.38	3388.05	3394.84	32766.0
2019-11-18 03:00:00	ES	Futures	3394.57	3396.75	3392.13	3392.67	24829.0
2019-11-18 04:00:00	ES	Futures	3392.4	3394.3	3391.86	3393.21	11004.0
2019-11-18 05:00:00	ES	Futures	3393.21	3394.84	3392.4	3392.67	9050.0
2019-11-18 06:00:00	ES	Futures	3392.67	3394.84	3391.86	3394.03	8503.0
2019-11-18 07:00:00	ES	Futures	3394.03	3395.93	3393.21	3395.66	10821.0
2019-11-18 08:00:00	ES	Futures	3395.39	3395.66	3382.89	3386.7	67144.0
2019-11-18 09:00:00	ES	Futures	3386.7	3387.51	3380.72	3384.52	142781.0
2019-11-18 10:00:00	ES	Futures	3384.52	3388.32	3380.18	3386.7	158753.0
2019-11-18 11:00:00	ES	Futures	3386.7	3390.77	3384.79	3389.95	134808.0
2019-11-18 12:00:00	ES	Futures	3389.95	3390.5	3387.24	3389.68	47967.0
2019-11-18 13:00:00	ES	Futures	3389.68	3393.21	3388.87	3392.4	39453.0
2019-11-18 14:00:00	ES	Futures	3392.13	3393.76	3390.23	3392.13	53687.0
2019-11-18 15:00:00	ES	Futures	3392.4	3392.94	3386.97	3391.04	132550.0
2019-11-18 16:00:00	ES	Futures	3390.77	3392.94	3390.23	3391.58	43171.0
2019-11-18 18:00:00	ES	Futures	3391.58	3391.86	3389.14	3389.14	5580.0
2019-11-18 19:00:00	ES	Futures	3389.41	3390.23	3385.34	3387.24	9943.0
2019-11-18 20:00:00	ES	Futures	3387.51	3393.21	3385.61	3391.58	13017.0
2019-11-18 21:00:00	ES	Futures	3391.86	3395.39	3391.04	3392.94	9834.0
2019-11-18 22:00:00	ES	Futures	3392.94	3393.49	3391.86	3392.13	4217.0
2019-11-18 23:00:00	ES	Futures	3392.4	3394.84	3392.13	3394.03	2974.0
2019-11-18 00:00:00	NQ	Futures	9661.48	9667.0	9659.16	9666.42	4860.0
2019-11-18 01:00:00	NQ	Futures	9666.71	9671.36	9665.55	9667.58	2562.0
2019-11-18 02:00:00	NQ	Futures	9667.58	9722.2	9666.71	9696.63	15379.0
2019-11-18 03:00:00	NQ	Futures	9696.63	9700.99	9681.82	9685.01	10053.0
2019-11-18 04:00:00	NQ	Futures	9685.3	9691.4	9681.53	9688.79	4263.0
2019-11-18 05:00:00	NQ	Futures	9688.79	9694.6	9682.4	9683.56	4405.0
2019-11-18 06:00:00	NQ	Futures	9683.27	9694.02	9681.82	9690.53	3430.0
2019-11-18 07:00:00	NQ	Futures	9690.53	9697.8	9687.92	9695.76	3630.0
2019-11-18 08:00:00	NQ	Futures	9695.76	9696.05	9653.35	9663.52	21724.0
2019-11-18 09:00:00	NQ	Futures	9663.52	9665.84	9620.23	9639.99	59240.0
2019-11-18 10:00:00	NQ	Futures	9639.7	9660.9	9626.04	9653.64	54195.0
2019-11-18 11:00:00	NQ	Futures	9653.64	9672.81	9644.34	9669.62	49239.0
2019-11-18 12:00:00	NQ	Futures	9669.62	9671.07	9655.96	9664.39	19105.0
2019-11-18 13:00:00	NQ	Futures	9664.39	9685.3	9661.19	9680.95	19826.0
2019-11-18 14:00:00	NQ	Futures	9680.95	9697.5	9675.72	9691.11	21755.0
2019-11-18 15:00:00	NQ	Futures	9690.82	9692.28	9669.91	9683.27	35753.0
2019-11-18 16:00:00	NQ	Futures	9683.27	9686.76	9677.75	9684.14	7557.0
2019-11-18 18:00:00	NQ	Futures	9685.01	9685.01	9676.01	9676.59	1651.0
2019-11-18 19:00:00	NQ	Futures	9676.88	9678.33	9665.55	9669.91	3380.0
2019-11-18 20:00:00	NQ	Futures	9670.2	9694.89	9664.39	9688.79	5588.0
2019-11-18 21:00:00	NQ	Futures	9688.79	9702.44	9685.59	9694.02	4805.0
2019-11-18 22:00:00	NQ	Futures	9694.02	9695.47	9689.95	9692.28	1815.0
2019-11-18 23:00:00	NQ	Futures	9692.28	9702.15	9691.4	9699.25	2069.0
2019-11-18 00:00:00	YM	Futures	30418.4	30434.7	30411.8	30433.6	1057.0
2019-11-18 01:00:00	YM	Futures	30434.7	30444.5	30430.3	30434.7	1047.0
2019-11-18 02:00:00	YM	Futures	30433.6	30538.1	30431.4	30498.9	8595.0
2019-11-18 03:00:00	YM	Futures	30500.0	30520.7	30479.3	30483.7	4450.0

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

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