PREVIEW / futures_1hour / 2019-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-19.parquet
  size:    59 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-11-19 00:00:00	ES	Futures	3394.03	3395.39	3392.13	3394.3	5895.0
2019-11-19 01:00:00	ES	Futures	3394.3	3397.02	3393.49	3396.2	5562.0
2019-11-19 02:00:00	ES	Futures	3395.93	3396.75	3394.57	3394.84	8105.0
2019-11-19 03:00:00	ES	Futures	3394.57	3400.0	3394.3	3397.56	25873.0
2019-11-19 04:00:00	ES	Futures	3397.29	3402.99	3397.02	3402.72	30765.0
2019-11-19 05:00:00	ES	Futures	3402.72	3403.26	3401.36	3401.63	14057.0
2019-11-19 06:00:00	ES	Futures	3401.36	3403.54	3399.46	3400.82	21534.0
2019-11-19 07:00:00	ES	Futures	3400.82	3401.09	3399.19	3400.82	14329.0
2019-11-19 08:00:00	ES	Futures	3400.82	3401.09	3397.56	3398.38	21204.0
2019-11-19 09:00:00	ES	Futures	3398.1	3400.28	3390.5	3391.31	139059.0
2019-11-19 10:00:00	ES	Futures	3391.04	3392.13	3382.08	3383.71	203007.0
2019-11-19 11:00:00	ES	Futures	3383.71	3395.66	3383.16	3392.13	183110.0
2019-11-19 12:00:00	ES	Futures	3392.13	3392.67	3386.42	3389.41	94052.0
2019-11-19 13:00:00	ES	Futures	3389.68	3392.13	3387.24	3389.95	47157.0
2019-11-19 14:00:00	ES	Futures	3389.95	3394.84	3389.68	3391.04	72885.0
2019-11-19 15:00:00	ES	Futures	3391.04	3394.03	3388.6	3389.41	154420.0
2019-11-19 16:00:00	ES	Futures	3389.14	3390.23	3386.42	3386.7	38247.0
2019-11-19 18:00:00	ES	Futures	3386.15	3386.42	3379.36	3380.72	17648.0
2019-11-19 19:00:00	ES	Futures	3380.99	3386.15	3380.45	3383.71	13862.0
2019-11-19 20:00:00	ES	Futures	3383.98	3384.52	3377.19	3378.27	25641.0
2019-11-19 21:00:00	ES	Futures	3378.55	3382.08	3377.46	3380.72	15040.0
2019-11-19 22:00:00	ES	Futures	3380.72	3382.62	3379.9	3380.99	7800.0
2019-11-19 23:00:00	ES	Futures	3380.99	3383.71	3380.72	3383.44	6255.0
2019-11-19 00:00:00	NQ	Futures	9699.54	9701.86	9689.95	9698.38	3164.0
2019-11-19 01:00:00	NQ	Futures	9697.8	9707.09	9695.76	9702.44	2402.0
2019-11-19 02:00:00	NQ	Futures	9702.73	9703.61	9696.34	9697.8	2925.0
2019-11-19 03:00:00	NQ	Futures	9697.5	9719.29	9696.63	9709.12	10230.0
2019-11-19 04:00:00	NQ	Futures	9708.54	9726.55	9706.8	9724.52	7907.0
2019-11-19 05:00:00	NQ	Futures	9724.81	9728.01	9720.45	9723.36	4348.0
2019-11-19 06:00:00	NQ	Futures	9723.36	9736.14	9721.33	9724.52	7226.0
2019-11-19 07:00:00	NQ	Futures	9724.81	9726.84	9719.58	9725.68	4286.0
2019-11-19 08:00:00	NQ	Futures	9725.68	9727.43	9716.97	9719.29	6273.0
2019-11-19 09:00:00	NQ	Futures	9719.0	9725.97	9688.79	9691.4	57409.0
2019-11-19 10:00:00	NQ	Futures	9691.69	9700.99	9658.87	9664.68	69993.0
2019-11-19 11:00:00	NQ	Futures	9664.68	9711.45	9663.81	9706.22	55874.0
2019-11-19 12:00:00	NQ	Futures	9706.22	9709.41	9687.63	9698.96	33665.0
2019-11-19 13:00:00	NQ	Futures	9698.96	9704.48	9690.53	9699.54	18373.0
2019-11-19 14:00:00	NQ	Futures	9699.25	9717.55	9699.25	9703.02	26014.0
2019-11-19 15:00:00	NQ	Futures	9703.02	9709.41	9692.28	9695.47	35073.0
2019-11-19 16:00:00	NQ	Futures	9695.47	9696.92	9684.14	9684.14	7788.0
2019-11-19 18:00:00	NQ	Futures	9682.69	9683.85	9662.94	9664.97	5110.0
2019-11-19 19:00:00	NQ	Futures	9665.26	9682.98	9663.81	9673.39	5555.0
2019-11-19 20:00:00	NQ	Futures	9673.39	9675.43	9646.67	9648.7	10880.0
2019-11-19 21:00:00	NQ	Futures	9648.7	9657.13	9643.47	9652.19	6579.0
2019-11-19 22:00:00	NQ	Futures	9652.19	9660.32	9650.44	9655.67	4088.0
2019-11-19 23:00:00	NQ	Futures	9655.96	9665.26	9655.67	9664.39	3139.0
2019-11-19 00:00:00	YM	Futures	30513.0	30523.9	30493.5	30514.1	1375.0
2019-11-19 01:00:00	YM	Futures	30513.0	30537.0	30508.7	30528.3	1098.0
2019-11-19 02:00:00	YM	Futures	30529.4	30535.9	30509.8	30518.5	1861.0
2019-11-19 03:00:00	YM	Futures	30518.5	30572.9	30515.2	30550.0	5651.0

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

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