PREVIEW / futures_1hour / 2019-09-13

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-13.parquet
  size:    49 KB
  rows:    1,446

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-09-13 00:00:00	ES	Futures	3264.97	3267.68	3264.7	3267.14	2595.0
2019-09-13 01:00:00	ES	Futures	3267.14	3268.76	3266.87	3267.41	4734.0
2019-09-13 02:00:00	ES	Futures	3267.41	3267.95	3265.52	3266.06	6388.0
2019-09-13 03:00:00	ES	Futures	3266.06	3270.66	3265.24	3268.49	11964.0
2019-09-13 04:00:00	ES	Futures	3268.22	3271.74	3265.79	3266.33	18240.0
2019-09-13 05:00:00	ES	Futures	3266.06	3271.2	3265.24	3269.58	20846.0
2019-09-13 06:00:00	ES	Futures	3269.85	3273.64	3269.85	3273.64	9277.0
2019-09-13 07:00:00	ES	Futures	3273.37	3274.18	3269.58	3270.93	11900.0
2019-09-13 08:00:00	ES	Futures	3270.66	3272.01	3266.33	3266.6	19845.0
2019-09-13 09:00:00	ES	Futures	3266.87	3267.14	3260.64	3263.08	98592.0
2019-09-13 10:00:00	ES	Futures	3262.81	3266.33	3259.02	3265.24	92470.0
2019-09-13 11:00:00	ES	Futures	3265.24	3268.76	3261.45	3262.27	62566.0
2019-09-13 12:00:00	ES	Futures	3262.27	3265.52	3259.29	3260.37	44577.0
2019-09-13 13:00:00	ES	Futures	3260.37	3262.54	3256.31	3257.66	35687.0
2019-09-13 14:00:00	ES	Futures	3257.39	3260.37	3256.58	3258.48	35670.0
2019-09-13 15:00:00	ES	Futures	3258.48	3260.91	3252.25	3256.58	115870.0
2019-09-13 16:00:00	ES	Futures	3256.58	3258.75	3254.42	3256.04	38033.0
2019-09-13 00:00:00	NQ	Futures	9209.12	9220.73	9208.25	9217.54	1630.0
2019-09-13 01:00:00	NQ	Futures	9217.83	9222.47	9216.37	9217.83	917.0
2019-09-13 02:00:00	NQ	Futures	9217.83	9217.83	9208.25	9209.41	1850.0
2019-09-13 03:00:00	NQ	Futures	9209.41	9227.4	9204.48	9218.12	4417.0
2019-09-13 04:00:00	NQ	Futures	9218.41	9226.24	9206.8	9208.54	3602.0
2019-09-13 05:00:00	NQ	Futures	9208.54	9226.53	9205.35	9225.08	3790.0
2019-09-13 06:00:00	NQ	Futures	9225.08	9236.39	9219.86	9234.36	3949.0
2019-09-13 07:00:00	NQ	Futures	9234.07	9235.52	9217.54	9219.57	3713.0
2019-09-13 08:00:00	NQ	Futures	9219.28	9223.63	9191.42	9192.58	7464.0
2019-09-13 09:00:00	NQ	Futures	9192.58	9195.19	9153.99	9177.79	37112.0
2019-09-13 10:00:00	NQ	Futures	9176.63	9194.03	9152.25	9184.46	30030.0
2019-09-13 11:00:00	NQ	Futures	9184.46	9200.42	9166.18	9171.11	20409.0
2019-09-13 12:00:00	NQ	Futures	9171.11	9184.17	9156.32	9161.83	14472.0
2019-09-13 13:00:00	NQ	Futures	9161.54	9172.56	9150.8	9153.7	12159.0
2019-09-13 14:00:00	NQ	Futures	9153.99	9173.43	9153.41	9168.5	11042.0
2019-09-13 15:00:00	NQ	Futures	9169.08	9175.17	9147.32	9162.12	18243.0
2019-09-13 16:00:00	NQ	Futures	9161.54	9170.53	9151.09	9154.57	5104.0
2019-09-13 00:00:00	YM	Futures	29626.0	29645.6	29620.6	29644.5	518.0
2019-09-13 01:00:00	YM	Futures	29644.5	29657.6	29640.2	29648.9	807.0
2019-09-13 02:00:00	YM	Futures	29648.9	29653.2	29627.1	29632.6	1582.0
2019-09-13 03:00:00	YM	Futures	29632.6	29683.7	29623.9	29665.2	2331.0
2019-09-13 04:00:00	YM	Futures	29665.2	29703.3	29648.9	29657.6	2839.0
2019-09-13 05:00:00	YM	Futures	29656.5	29696.8	29645.6	29688.1	2272.0
2019-09-13 06:00:00	YM	Futures	29689.2	29717.5	29685.9	29715.3	1308.0
2019-09-13 07:00:00	YM	Futures	29714.2	29725.1	29692.4	29702.2	1902.0
2019-09-13 08:00:00	YM	Futures	29701.1	29714.2	29664.1	29669.6	2492.0
2019-09-13 09:00:00	YM	Futures	29669.6	29681.5	29627.1	29653.2	15903.0
2019-09-13 10:00:00	YM	Futures	29652.2	29688.1	29616.2	29660.9	10486.0
2019-09-13 11:00:00	YM	Futures	29662.0	29695.7	29638.0	29642.4	9329.0
2019-09-13 12:00:00	YM	Futures	29642.4	29665.2	29616.2	29636.9	6274.0
2019-09-13 13:00:00	YM	Futures	29636.9	29662.0	29617.3	29631.5	4690.0
2019-09-13 14:00:00	YM	Futures	29631.5	29668.5	29631.5	29655.4	5761.0
2019-09-13 15:00:00	YM	Futures	29656.5	29663.0	29608.6	29628.2	9697.0

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

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