PREVIEW / futures_1hour / 2018-04-11

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-04-11.parquet
  size:    53 KB
  rows:    1,674

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
2018-04-11 00:00:00	ES	Futures	2884.91	2885.73	2883.27	2884.37	3075.0
2018-04-11 01:00:00	ES	Futures	2884.64	2885.73	2883.55	2884.37	3432.0
2018-04-11 02:00:00	ES	Futures	2884.37	2886.0	2883.55	2885.18	6916.0
2018-04-11 03:00:00	ES	Futures	2885.18	2886.28	2883.27	2884.37	9115.0
2018-04-11 04:00:00	ES	Futures	2884.09	2885.18	2878.91	2883.27	11272.0
2018-04-11 05:00:00	ES	Futures	2883.27	2885.46	2882.45	2883.0	7560.0
2018-04-11 06:00:00	ES	Futures	2883.27	2884.09	2870.45	2874.54	40628.0
2018-04-11 07:00:00	ES	Futures	2874.81	2876.18	2866.63	2876.18	58268.0
2018-04-11 08:00:00	ES	Futures	2875.9	2877.27	2871.54	2873.99	46008.0
2018-04-11 09:00:00	ES	Futures	2874.27	2893.1	2872.08	2892.01	216873.0
2018-04-11 10:00:00	ES	Futures	2892.01	2898.01	2885.73	2885.73	194579.0
2018-04-11 11:00:00	ES	Futures	2886.0	2900.47	2882.18	2897.46	186465.0
2018-04-11 12:00:00	ES	Futures	2897.19	2905.11	2891.46	2894.19	165030.0
2018-04-11 13:00:00	ES	Futures	2894.19	2898.28	2888.46	2895.01	135460.0
2018-04-11 14:00:00	ES	Futures	2895.01	2898.28	2886.55	2892.55	154725.0
2018-04-11 15:00:00	ES	Futures	2892.28	2893.92	2880.54	2884.64	221778.0
2018-04-11 16:00:00	ES	Futures	2884.64	2885.46	2881.91	2884.64	56816.0
2018-04-11 18:00:00	ES	Futures	2884.64	2889.55	2883.82	2888.19	4732.0
2018-04-11 19:00:00	ES	Futures	2888.19	2890.64	2887.91	2889.82	3260.0
2018-04-11 20:00:00	ES	Futures	2889.82	2893.64	2885.18	2892.01	7344.0
2018-04-11 21:00:00	ES	Futures	2892.28	2894.74	2887.37	2888.19	7178.0
2018-04-11 22:00:00	ES	Futures	2888.19	2891.46	2886.28	2887.64	6175.0
2018-04-11 23:00:00	ES	Futures	2887.91	2889.28	2886.28	2887.91	3984.0
2018-04-11 00:00:00	NQ	Futures	7797.91	7801.16	7791.7	7795.55	1186.0
2018-04-11 01:00:00	NQ	Futures	7795.84	7802.34	7792.59	7795.55	1177.0
2018-04-11 02:00:00	NQ	Futures	7795.25	7799.98	7791.41	7797.91	1627.0
2018-04-11 03:00:00	NQ	Futures	7798.5	7804.41	7792.3	7797.62	2114.0
2018-04-11 04:00:00	NQ	Futures	7797.62	7799.68	7783.43	7793.48	2996.0
2018-04-11 05:00:00	NQ	Futures	7793.77	7801.75	7792.89	7794.36	1899.0
2018-04-11 06:00:00	NQ	Futures	7794.07	7795.84	7749.15	7765.4	9068.0
2018-04-11 07:00:00	NQ	Futures	7766.29	7771.9	7743.83	7771.31	15245.0
2018-04-11 08:00:00	NQ	Futures	7771.31	7776.34	7758.31	7768.95	9416.0
2018-04-11 09:00:00	NQ	Futures	7768.95	7824.8	7763.92	7822.14	66304.0
2018-04-11 10:00:00	NQ	Futures	7821.85	7853.77	7793.18	7814.46	70285.0
2018-04-11 11:00:00	NQ	Futures	7814.46	7859.09	7797.02	7845.49	49182.0
2018-04-11 12:00:00	NQ	Futures	7845.49	7876.82	7822.14	7827.76	46819.0
2018-04-11 13:00:00	NQ	Futures	7827.76	7849.63	7815.05	7841.35	34428.0
2018-04-11 14:00:00	NQ	Futures	7841.65	7854.36	7810.03	7823.92	41782.0
2018-04-11 15:00:00	NQ	Futures	7823.92	7829.24	7784.32	7795.55	57088.0
2018-04-11 16:00:00	NQ	Futures	7795.55	7796.73	7785.79	7796.73	6452.0
2018-04-11 18:00:00	NQ	Futures	7797.62	7810.62	7795.25	7808.25	1409.0
2018-04-11 19:00:00	NQ	Futures	7808.25	7820.08	7807.66	7817.12	1439.0
2018-04-11 20:00:00	NQ	Futures	7816.83	7830.72	7799.98	7825.99	3028.0
2018-04-11 21:00:00	NQ	Futures	7826.87	7836.03	7815.35	7816.53	3542.0
2018-04-11 22:00:00	NQ	Futures	7817.12	7828.35	7808.85	7818.3	3145.0
2018-04-11 23:00:00	NQ	Futures	7818.6	7826.87	7811.8	7817.71	2039.0
2018-04-11 00:00:00	YM	Futures	26371.9	26378.4	26352.4	26357.8	1066.0
2018-04-11 01:00:00	YM	Futures	26358.9	26382.8	26353.4	26370.8	1401.0
2018-04-11 02:00:00	YM	Futures	26369.7	26377.3	26358.9	26371.9	1582.0
2018-04-11 03:00:00	YM	Futures	26374.1	26386.0	26350.2	26355.6	2121.0

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

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