PREVIEW / futures_1hour / 2019-12-02

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-12-02.parquet
  size:    60 KB
  rows:    1,878

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-12-02 00:00:00	ES	Futures	3426.08	3426.35	3424.99	3425.81	5600.0
2019-12-02 01:00:00	ES	Futures	3426.08	3426.08	3424.45	3424.72	4296.0
2019-12-02 02:00:00	ES	Futures	3424.72	3424.99	3423.09	3423.91	10631.0
2019-12-02 03:00:00	ES	Futures	3423.91	3431.24	3422.82	3429.61	28660.0
2019-12-02 04:00:00	ES	Futures	3429.61	3430.16	3426.62	3427.71	15592.0
2019-12-02 05:00:00	ES	Futures	3427.98	3429.88	3427.17	3427.17	13863.0
2019-12-02 06:00:00	ES	Futures	3427.17	3427.71	3418.48	3421.19	35703.0
2019-12-02 07:00:00	ES	Futures	3420.92	3421.74	3418.75	3420.92	21158.0
2019-12-02 08:00:00	ES	Futures	3420.92	3421.19	3415.49	3418.48	32475.0
2019-12-02 09:00:00	ES	Futures	3418.48	3419.56	3400.28	3400.55	225773.0
2019-12-02 10:00:00	ES	Futures	3400.28	3400.28	3380.18	3382.89	482074.0
2019-12-02 11:00:00	ES	Futures	3382.89	3388.87	3379.36	3387.78	217299.0
2019-12-02 12:00:00	ES	Futures	3387.78	3391.31	3380.99	3382.35	170754.0
2019-12-02 13:00:00	ES	Futures	3382.08	3390.23	3381.81	3388.87	81509.0
2019-12-02 14:00:00	ES	Futures	3388.6	3394.84	3387.78	3392.4	80421.0
2019-12-02 15:00:00	ES	Futures	3392.67	3393.21	3382.89	3383.98	277829.0
2019-12-02 16:00:00	ES	Futures	3384.25	3386.42	3381.81	3382.35	82251.0
2019-12-02 18:00:00	ES	Futures	3383.71	3384.79	3376.92	3381.53	17552.0
2019-12-02 19:00:00	ES	Futures	3381.53	3387.24	3379.09	3386.15	19259.0
2019-12-02 20:00:00	ES	Futures	3385.88	3388.32	3382.35	3386.15	20319.0
2019-12-02 21:00:00	ES	Futures	3385.88	3389.41	3385.34	3387.78	11690.0
2019-12-02 22:00:00	ES	Futures	3387.78	3391.86	3387.24	3389.95	12112.0
2019-12-02 23:00:00	ES	Futures	3389.95	3391.31	3389.68	3390.5	3667.0
2019-12-02 00:00:00	NQ	Futures	9817.19	9817.77	9813.99	9816.61	3178.0
2019-12-02 01:00:00	NQ	Futures	9816.61	9816.9	9811.09	9811.67	3650.0
2019-12-02 02:00:00	NQ	Futures	9811.38	9811.67	9802.66	9805.28	5671.0
2019-12-02 03:00:00	NQ	Futures	9805.28	9827.06	9802.08	9820.96	9531.0
2019-12-02 04:00:00	NQ	Futures	9821.25	9823.29	9809.34	9813.12	8582.0
2019-12-02 05:00:00	NQ	Futures	9812.83	9818.93	9808.47	9808.47	3134.0
2019-12-02 06:00:00	NQ	Futures	9808.76	9810.8	9782.62	9791.91	9628.0
2019-12-02 07:00:00	NQ	Futures	9791.91	9793.95	9784.65	9791.62	5547.0
2019-12-02 08:00:00	NQ	Futures	9791.62	9792.21	9769.26	9782.04	10893.0
2019-12-02 09:00:00	NQ	Futures	9782.04	9783.2	9691.99	9692.28	81379.0
2019-12-02 10:00:00	NQ	Futures	9692.28	9692.28	9617.04	9626.92	143043.0
2019-12-02 11:00:00	NQ	Futures	9627.21	9659.16	9617.04	9656.55	65527.0
2019-12-02 12:00:00	NQ	Futures	9656.84	9667.0	9629.53	9641.44	51374.0
2019-12-02 13:00:00	NQ	Futures	9641.44	9673.1	9640.28	9668.16	36686.0
2019-12-02 14:00:00	NQ	Futures	9668.16	9686.18	9665.55	9680.08	26372.0
2019-12-02 15:00:00	NQ	Futures	9680.08	9682.69	9659.74	9662.94	56328.0
2019-12-02 16:00:00	NQ	Futures	9662.65	9669.91	9655.09	9655.96	10016.0
2019-12-02 18:00:00	NQ	Futures	9660.32	9663.23	9635.34	9649.57	7949.0
2019-12-02 19:00:00	NQ	Futures	9648.99	9663.23	9640.28	9662.06	7584.0
2019-12-02 20:00:00	NQ	Futures	9661.77	9669.91	9649.86	9663.23	11966.0
2019-12-02 21:00:00	NQ	Futures	9663.23	9675.72	9660.9	9669.91	6180.0
2019-12-02 22:00:00	NQ	Futures	9670.49	9685.3	9669.04	9679.49	7164.0
2019-12-02 23:00:00	NQ	Futures	9679.49	9684.72	9677.46	9679.49	1755.0
2019-12-02 00:00:00	YM	Futures	30645.8	30648.0	30634.9	30644.7	889.0
2019-12-02 01:00:00	YM	Futures	30644.7	30644.7	30631.7	30632.8	933.0
2019-12-02 02:00:00	YM	Futures	30631.7	30636.0	30619.7	30626.2	1951.0
2019-12-02 03:00:00	YM	Futures	30626.2	30688.3	30618.6	30677.4	6266.0

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

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