PREVIEW / futures_1hour / 2017-10-27

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-10-27.parquet
  size:    46 KB
  rows:    1,359

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
2017-10-27 00:00:00	ES	Futures	2805.07	2805.62	2803.98	2804.52	2301.0
2017-10-27 01:00:00	ES	Futures	2804.8	2805.34	2803.98	2804.25	3975.0
2017-10-27 02:00:00	ES	Futures	2804.25	2805.34	2803.43	2804.52	10478.0
2017-10-27 03:00:00	ES	Futures	2804.52	2810.54	2803.16	2809.99	43012.0
2017-10-27 04:00:00	ES	Futures	2809.72	2809.99	2806.16	2808.9	25362.0
2017-10-27 05:00:00	ES	Futures	2808.9	2811.36	2808.63	2810.81	25844.0
2017-10-27 06:00:00	ES	Futures	2810.81	2810.81	2808.9	2809.99	14807.0
2017-10-27 07:00:00	ES	Futures	2809.99	2810.54	2808.63	2809.45	19846.0
2017-10-27 08:00:00	ES	Futures	2809.17	2809.45	2806.98	2808.63	41161.0
2017-10-27 09:00:00	ES	Futures	2808.35	2810.27	2804.8	2808.63	206151.0
2017-10-27 10:00:00	ES	Futures	2808.35	2814.92	2808.35	2813.28	247572.0
2017-10-27 11:00:00	ES	Futures	2813.0	2819.57	2813.0	2819.02	179726.0
2017-10-27 12:00:00	ES	Futures	2819.02	2822.3	2818.75	2820.39	125628.0
2017-10-27 13:00:00	ES	Futures	2820.66	2821.76	2819.02	2821.21	89308.0
2017-10-27 14:00:00	ES	Futures	2821.48	2823.95	2820.12	2820.94	103341.0
2017-10-27 15:00:00	ES	Futures	2821.21	2822.3	2818.47	2821.76	242062.0
2017-10-27 16:00:00	ES	Futures	2821.76	2822.03	2819.57	2820.12	116802.0
2017-10-27 00:00:00	NQ	Futures	7259.04	7260.53	7255.47	7258.45	1241.0
2017-10-27 01:00:00	NQ	Futures	7258.45	7259.94	7254.58	7255.18	1314.0
2017-10-27 02:00:00	NQ	Futures	7254.88	7256.66	7251.91	7253.69	2087.0
2017-10-27 03:00:00	NQ	Futures	7253.39	7271.83	7249.53	7269.75	6821.0
2017-10-27 04:00:00	NQ	Futures	7269.45	7270.05	7262.02	7268.56	3911.0
2017-10-27 05:00:00	NQ	Futures	7268.56	7276.0	7267.37	7275.7	2847.0
2017-10-27 06:00:00	NQ	Futures	7275.7	7282.54	7275.1	7277.78	3643.0
2017-10-27 07:00:00	NQ	Futures	7277.48	7284.32	7272.43	7282.24	4238.0
2017-10-27 08:00:00	NQ	Futures	7282.24	7303.95	7280.75	7299.79	14223.0
2017-10-27 09:00:00	NQ	Futures	7299.79	7326.56	7290.27	7319.72	67929.0
2017-10-27 10:00:00	NQ	Futures	7319.72	7353.32	7317.63	7334.88	79836.0
2017-10-27 11:00:00	NQ	Futures	7335.18	7378.6	7334.88	7372.66	53270.0
2017-10-27 12:00:00	NQ	Futures	7372.36	7392.88	7370.28	7383.07	47282.0
2017-10-27 13:00:00	NQ	Futures	7383.36	7398.53	7378.9	7397.34	25561.0
2017-10-27 14:00:00	NQ	Futures	7397.34	7405.37	7387.82	7394.67	33470.0
2017-10-27 15:00:00	NQ	Futures	7394.67	7406.56	7388.72	7391.1	52331.0
2017-10-27 16:00:00	NQ	Futures	7391.1	7399.13	7389.31	7393.18	11572.0
2017-10-27 00:00:00	YM	Futures	25410.5	25414.8	25400.7	25407.2	649.0
2017-10-27 01:00:00	YM	Futures	25407.2	25411.6	25397.4	25402.9	1012.0
2017-10-27 02:00:00	YM	Futures	25402.9	25415.9	25399.6	25407.2	1442.0
2017-10-27 03:00:00	YM	Futures	25406.1	25449.6	25396.3	25445.3	4323.0
2017-10-27 04:00:00	YM	Futures	25445.3	25445.3	25419.2	25436.6	3112.0
2017-10-27 05:00:00	YM	Futures	25435.5	25455.1	25430.1	25445.3	2208.0
2017-10-27 06:00:00	YM	Futures	25444.2	25454.0	25435.5	25454.0	1614.0
2017-10-27 07:00:00	YM	Futures	25452.9	25460.5	25430.1	25433.3	2056.0
2017-10-27 08:00:00	YM	Futures	25432.2	25438.8	25399.6	25415.9	5534.0
2017-10-27 09:00:00	YM	Futures	25415.9	25425.7	25339.8	25376.8	25227.0
2017-10-27 10:00:00	YM	Futures	25376.8	25430.1	25374.6	25393.1	22009.0
2017-10-27 11:00:00	YM	Futures	25393.1	25435.5	25393.1	25423.5	11247.0
2017-10-27 12:00:00	YM	Futures	25423.5	25445.3	25415.9	25423.5	7726.0
2017-10-27 13:00:00	YM	Futures	25423.5	25432.2	25408.3	25426.8	6602.0
2017-10-27 14:00:00	YM	Futures	25426.8	25443.1	25420.3	25425.7	6243.0
2017-10-27 15:00:00	YM	Futures	25425.7	25436.6	25396.3	25427.9	12587.0

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

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