PREVIEW / futures_1hour / 2019-09-18

all futures 1-hour files

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

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-18 00:00:00	ES	Futures	3263.92	3264.46	3263.65	3263.65	2240.0
2019-09-18 01:00:00	ES	Futures	3263.92	3264.19	3262.29	3263.92	3450.0
2019-09-18 02:00:00	ES	Futures	3263.92	3264.73	3262.83	3263.92	4758.0
2019-09-18 03:00:00	ES	Futures	3263.92	3265.82	3262.02	3265.28	12187.0
2019-09-18 04:00:00	ES	Futures	3265.0	3267.18	3263.65	3264.19	13023.0
2019-09-18 05:00:00	ES	Futures	3263.92	3264.46	3263.37	3263.92	7281.0
2019-09-18 06:00:00	ES	Futures	3264.19	3264.46	3262.29	3264.19	7187.0
2019-09-18 07:00:00	ES	Futures	3264.19	3265.0	3259.84	3262.02	14319.0
2019-09-18 08:00:00	ES	Futures	3262.02	3265.55	3261.47	3264.73	17886.0
2019-09-18 09:00:00	ES	Futures	3264.73	3265.28	3256.86	3260.11	113333.0
2019-09-18 10:00:00	ES	Futures	3259.84	3264.46	3259.3	3261.2	108200.0
2019-09-18 11:00:00	ES	Futures	3260.93	3261.47	3258.49	3260.39	63298.0
2019-09-18 12:00:00	ES	Futures	3260.11	3260.93	3258.21	3258.49	44258.0
2019-09-18 13:00:00	ES	Futures	3258.21	3260.66	3254.14	3259.84	64539.0
2019-09-18 14:00:00	ES	Futures	3260.11	3265.0	3238.66	3247.35	358956.0
2019-09-18 15:00:00	ES	Futures	3247.35	3271.25	3244.9	3269.89	298020.0
2019-09-18 16:00:00	ES	Futures	3269.62	3274.51	3268.26	3270.17	76505.0
2019-09-18 18:00:00	ES	Futures	3270.44	3271.25	3268.54	3269.08	5761.0
2019-09-18 19:00:00	ES	Futures	3269.08	3269.62	3266.36	3266.63	5819.0
2019-09-18 20:00:00	ES	Futures	3266.63	3271.25	3265.28	3267.99	11813.0
2019-09-18 21:00:00	ES	Futures	3267.99	3269.62	3262.29	3262.83	11364.0
2019-09-18 22:00:00	ES	Futures	3262.56	3263.92	3260.39	3260.93	11243.0
2019-09-18 23:00:00	ES	Futures	3261.2	3261.74	3256.58	3259.03	12465.0
2019-09-18 00:00:00	NQ	Futures	9180.72	9183.33	9178.69	9181.3	1280.0
2019-09-18 01:00:00	NQ	Futures	9181.3	9183.91	9175.2	9183.62	1523.0
2019-09-18 02:00:00	NQ	Futures	9183.62	9184.2	9176.94	9181.88	1873.0
2019-09-18 03:00:00	NQ	Futures	9181.3	9189.43	9173.46	9185.95	5211.0
2019-09-18 04:00:00	NQ	Futures	9185.95	9192.63	9182.17	9182.75	4233.0
2019-09-18 05:00:00	NQ	Futures	9182.46	9185.37	9178.69	9183.62	2611.0
2019-09-18 06:00:00	NQ	Futures	9183.62	9186.53	9177.23	9183.62	2731.0
2019-09-18 07:00:00	NQ	Futures	9183.91	9187.98	9164.74	9172.59	5983.0
2019-09-18 08:00:00	NQ	Futures	9172.29	9189.72	9170.55	9184.79	5592.0
2019-09-18 09:00:00	NQ	Futures	9184.79	9187.4	9159.22	9168.81	37219.0
2019-09-18 10:00:00	NQ	Futures	9168.81	9178.69	9166.19	9173.75	24073.0
2019-09-18 11:00:00	NQ	Futures	9173.46	9175.78	9165.9	9168.81	17833.0
2019-09-18 12:00:00	NQ	Futures	9168.81	9172.0	9154.87	9155.16	13181.0
2019-09-18 13:00:00	NQ	Futures	9155.45	9155.45	9134.82	9155.45	19965.0
2019-09-18 14:00:00	NQ	Futures	9153.99	9169.1	9079.05	9113.91	99855.0
2019-09-18 15:00:00	NQ	Futures	9113.62	9198.73	9103.45	9194.37	78852.0
2019-09-18 16:00:00	NQ	Futures	9194.37	9213.83	9192.63	9205.7	14695.0
2019-09-18 18:00:00	NQ	Futures	9208.61	9209.48	9197.57	9198.15	2111.0
2019-09-18 19:00:00	NQ	Futures	9198.15	9200.76	9186.82	9187.4	2441.0
2019-09-18 20:00:00	NQ	Futures	9187.69	9202.51	9180.43	9191.18	5908.0
2019-09-18 21:00:00	NQ	Futures	9191.18	9198.15	9171.42	9171.71	5407.0
2019-09-18 22:00:00	NQ	Futures	9171.42	9174.62	9160.09	9162.71	5393.0
2019-09-18 23:00:00	NQ	Futures	9163.0	9165.61	9144.7	9150.22	5964.0
2019-09-18 00:00:00	YM	Futures	29468.2	29471.5	29462.8	29462.8	508.0
2019-09-18 01:00:00	YM	Futures	29462.8	29463.9	29446.5	29462.8	882.0
2019-09-18 02:00:00	YM	Futures	29461.7	29467.1	29450.8	29458.4	1325.0
2019-09-18 03:00:00	YM	Futures	29458.4	29480.2	29442.1	29471.5	2684.0

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

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