PREVIEW / futures_1hour / 2019-09-09

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-09-09.parquet
  size:    58 KB
  rows:    1,800

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-09 00:00:00	ES	Futures	3233.3	3234.93	3233.03	3234.38	2330.0
2019-09-09 01:00:00	ES	Futures	3234.11	3235.2	3233.03	3233.84	3371.0
2019-09-09 02:00:00	ES	Futures	3233.84	3235.47	3231.68	3234.93	9255.0
2019-09-09 03:00:00	ES	Futures	3234.65	3236.01	3232.49	3233.3	15921.0
2019-09-09 04:00:00	ES	Futures	3233.3	3234.65	3231.68	3233.84	13040.0
2019-09-09 05:00:00	ES	Futures	3233.84	3237.09	3233.3	3236.55	14311.0
2019-09-09 06:00:00	ES	Futures	3236.55	3237.36	3235.2	3235.74	8987.0
2019-09-09 07:00:00	ES	Futures	3235.74	3237.36	3234.38	3237.36	13935.0
2019-09-09 08:00:00	ES	Futures	3237.36	3239.26	3237.09	3237.9	20303.0
2019-09-09 09:00:00	ES	Futures	3238.17	3239.26	3227.89	3227.89	169859.0
2019-09-09 10:00:00	ES	Futures	3227.89	3234.11	3227.62	3233.84	162083.0
2019-09-09 11:00:00	ES	Futures	3233.84	3234.38	3228.97	3230.32	106762.0
2019-09-09 12:00:00	ES	Futures	3230.32	3230.86	3215.43	3223.56	165935.0
2019-09-09 13:00:00	ES	Futures	3223.56	3224.37	3217.87	3222.2	84023.0
2019-09-09 14:00:00	ES	Futures	3222.2	3223.56	3218.14	3220.04	81570.0
2019-09-09 15:00:00	ES	Futures	3220.04	3227.08	3218.68	3225.99	163672.0
2019-09-09 16:00:00	ES	Futures	3225.99	3226.8	3224.1	3225.72	50519.0
2019-09-09 18:00:00	ES	Futures	3225.99	3228.7	3225.45	3228.43	4358.0
2019-09-09 19:00:00	ES	Futures	3228.43	3229.78	3227.35	3229.24	4008.0
2019-09-09 20:00:00	ES	Futures	3229.51	3232.22	3228.16	3230.86	14242.0
2019-09-09 21:00:00	ES	Futures	3230.59	3231.68	3224.64	3227.08	12436.0
2019-09-09 22:00:00	ES	Futures	3226.8	3227.08	3221.39	3222.74	14249.0
2019-09-09 23:00:00	ES	Futures	3222.74	3224.37	3221.93	3223.29	5205.0
2019-09-09 00:00:00	NQ	Futures	9135.42	9142.39	9133.97	9138.62	1755.0
2019-09-09 01:00:00	NQ	Futures	9138.62	9143.26	9133.39	9138.33	2022.0
2019-09-09 02:00:00	NQ	Futures	9138.62	9141.81	9127.59	9140.07	4337.0
2019-09-09 03:00:00	NQ	Futures	9139.78	9146.45	9130.78	9134.55	6827.0
2019-09-09 04:00:00	NQ	Futures	9134.55	9138.91	9129.33	9137.75	4506.0
2019-09-09 05:00:00	NQ	Futures	9138.33	9145.58	9133.1	9144.42	4423.0
2019-09-09 06:00:00	NQ	Futures	9144.71	9146.45	9138.04	9138.91	3505.0
2019-09-09 07:00:00	NQ	Futures	9139.2	9140.65	9133.97	9137.46	5077.0
2019-09-09 08:00:00	NQ	Futures	9137.46	9147.9	9134.55	9145.29	7264.0
2019-09-09 09:00:00	NQ	Futures	9145.58	9152.25	9111.34	9113.08	58749.0
2019-09-09 10:00:00	NQ	Futures	9112.79	9140.07	9103.8	9137.17	55703.0
2019-09-09 11:00:00	NQ	Futures	9137.17	9142.1	9119.47	9125.27	29873.0
2019-09-09 12:00:00	NQ	Futures	9125.56	9127.3	9055.35	9087.84	51063.0
2019-09-09 13:00:00	NQ	Futures	9087.84	9092.19	9060.57	9077.4	27637.0
2019-09-09 14:00:00	NQ	Futures	9077.4	9078.85	9050.7	9062.02	27917.0
2019-09-09 15:00:00	NQ	Futures	9062.02	9100.9	9055.93	9095.97	43534.0
2019-09-09 16:00:00	NQ	Futures	9096.26	9098.87	9086.1	9091.32	7367.0
2019-09-09 18:00:00	NQ	Futures	9091.9	9102.35	9089.0	9099.16	1800.0
2019-09-09 19:00:00	NQ	Futures	9099.16	9105.25	9094.8	9103.51	1572.0
2019-09-09 20:00:00	NQ	Futures	9103.51	9119.47	9099.45	9113.37	7364.0
2019-09-09 21:00:00	NQ	Futures	9113.08	9119.18	9091.9	9101.19	6537.0
2019-09-09 22:00:00	NQ	Futures	9101.19	9101.19	9075.66	9082.62	7540.0
2019-09-09 23:00:00	NQ	Futures	9082.33	9088.13	9079.72	9083.49	2504.0
2019-09-09 00:00:00	YM	Futures	29200.5	29219.0	29198.3	29210.3	977.0
2019-09-09 01:00:00	YM	Futures	29209.2	29221.1	29198.3	29208.1	919.0
2019-09-09 02:00:00	YM	Futures	29209.2	29221.1	29192.9	29215.7	1867.0
2019-09-09 03:00:00	YM	Futures	29214.6	29230.9	29195.0	29203.7	3372.0

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

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