PREVIEW / futures_1hour / 2019-06-18

all futures 1-hour files

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

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-06-18 00:00:00	ES	Futures	3135.85	3135.85	3134.22	3135.58	3092.0
2019-06-18 01:00:00	ES	Futures	3135.58	3136.12	3132.6	3133.68	6309.0
2019-06-18 02:00:00	ES	Futures	3133.68	3135.85	3133.14	3135.58	6100.0
2019-06-18 03:00:00	ES	Futures	3135.58	3135.85	3128.27	3131.25	21329.0
2019-06-18 04:00:00	ES	Futures	3131.25	3148.84	3130.16	3145.05	51132.0
2019-06-18 05:00:00	ES	Futures	3145.05	3146.95	3143.16	3144.24	21213.0
2019-06-18 06:00:00	ES	Futures	3144.51	3153.71	3143.7	3152.63	28817.0
2019-06-18 07:00:00	ES	Futures	3152.36	3156.42	3150.47	3155.07	30014.0
2019-06-18 08:00:00	ES	Futures	3155.34	3157.5	3153.71	3155.07	53139.0
2019-06-18 09:00:00	ES	Futures	3155.07	3175.37	3151.28	3170.5	346322.0
2019-06-18 10:00:00	ES	Futures	3170.77	3178.89	3168.6	3177.27	242983.0
2019-06-18 11:00:00	ES	Futures	3177.27	3179.7	3165.9	3166.17	196205.0
2019-06-18 12:00:00	ES	Futures	3166.17	3170.23	3164.54	3168.33	105988.0
2019-06-18 13:00:00	ES	Futures	3168.33	3168.33	3161.02	3167.25	111269.0
2019-06-18 14:00:00	ES	Futures	3166.98	3171.31	3166.71	3167.79	74041.0
2019-06-18 15:00:00	ES	Futures	3167.79	3168.87	3161.29	3165.63	184857.0
2019-06-18 16:00:00	ES	Futures	3165.63	3169.69	3165.08	3168.33	55286.0
2019-06-18 18:00:00	ES	Futures	3166.98	3169.96	3165.9	3168.87	4969.0
2019-06-18 19:00:00	ES	Futures	3169.14	3172.39	3168.6	3171.31	4125.0
2019-06-18 20:00:00	ES	Futures	3171.04	3173.2	3169.69	3171.04	12960.0
2019-06-18 21:00:00	ES	Futures	3170.77	3171.85	3166.44	3168.6	17153.0
2019-06-18 22:00:00	ES	Futures	3168.87	3170.23	3166.98	3169.14	10365.0
2019-06-18 23:00:00	ES	Futures	3169.14	3170.5	3168.87	3170.23	4255.0
2019-06-18 00:00:00	NQ	Futures	8781.45	8782.32	8775.65	8780.29	1443.0
2019-06-18 01:00:00	NQ	Futures	8780.29	8783.19	8769.27	8774.2	2267.0
2019-06-18 02:00:00	NQ	Futures	8774.2	8782.9	8772.75	8781.16	1918.0
2019-06-18 03:00:00	NQ	Futures	8781.16	8782.61	8752.73	8761.43	5817.0
2019-06-18 04:00:00	NQ	Futures	8761.14	8836.29	8757.37	8819.75	17004.0
2019-06-18 05:00:00	NQ	Futures	8820.04	8827.87	8815.98	8820.62	5097.0
2019-06-18 06:00:00	NQ	Futures	8820.91	8864.72	8816.85	8858.05	9685.0
2019-06-18 07:00:00	NQ	Futures	8857.76	8867.91	8845.28	8863.56	9978.0
2019-06-18 08:00:00	NQ	Futures	8863.27	8876.91	8861.24	8869.94	14550.0
2019-06-18 09:00:00	NQ	Futures	8869.94	8945.96	8849.63	8928.84	97843.0
2019-06-18 10:00:00	NQ	Futures	8928.84	8961.63	8925.94	8953.8	80177.0
2019-06-18 11:00:00	NQ	Futures	8953.8	8961.05	8909.98	8911.14	47389.0
2019-06-18 12:00:00	NQ	Futures	8911.14	8925.65	8905.34	8913.18	27058.0
2019-06-18 13:00:00	NQ	Futures	8913.47	8913.47	8889.38	8911.43	23557.0
2019-06-18 14:00:00	NQ	Futures	8911.14	8925.07	8909.11	8912.31	19033.0
2019-06-18 15:00:00	NQ	Futures	8912.31	8916.95	8887.93	8898.09	38608.0
2019-06-18 16:00:00	NQ	Futures	8897.8	8912.02	8894.32	8904.47	9353.0
2019-06-18 18:00:00	NQ	Futures	8899.25	8913.76	8899.25	8910.56	2147.0
2019-06-18 19:00:00	NQ	Futures	8910.85	8922.46	8909.69	8920.43	1266.0
2019-06-18 20:00:00	NQ	Futures	8919.85	8925.94	8915.21	8920.72	4021.0
2019-06-18 21:00:00	NQ	Futures	8920.43	8923.33	8904.47	8911.14	5260.0
2019-06-18 22:00:00	NQ	Futures	8910.85	8913.18	8904.76	8909.11	2734.0
2019-06-18 23:00:00	NQ	Futures	8908.53	8912.6	8906.79	8911.14	1311.0
2019-06-18 00:00:00	YM	Futures	28420.7	28421.8	28407.7	28420.7	693.0
2019-06-18 01:00:00	YM	Futures	28419.6	28425.1	28394.6	28406.6	1231.0
2019-06-18 02:00:00	YM	Futures	28406.6	28422.9	28402.2	28421.8	1384.0
2019-06-18 03:00:00	YM	Futures	28421.8	28425.1	28355.5	28382.7	3887.0

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

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