PREVIEW / futures_1hour / 2019-03-01

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-01.parquet
  size:    48 KB
  rows:    1,445

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-03-01 00:00:00	ES	Futures	3037.13	3038.49	3036.32	3037.94	4344.0
2019-03-01 01:00:00	ES	Futures	3037.94	3040.12	3037.4	3039.3	6054.0
2019-03-01 02:00:00	ES	Futures	3039.57	3040.12	3037.4	3039.85	7501.0
2019-03-01 03:00:00	ES	Futures	3039.85	3043.38	3036.59	3042.29	21751.0
2019-03-01 04:00:00	ES	Futures	3042.56	3044.46	3041.75	3042.29	16159.0
2019-03-01 05:00:00	ES	Futures	3042.56	3043.38	3041.2	3042.83	10285.0
2019-03-01 06:00:00	ES	Futures	3042.83	3044.19	3041.75	3043.92	12024.0
2019-03-01 07:00:00	ES	Futures	3043.65	3045.28	3043.11	3044.46	17438.0
2019-03-01 08:00:00	ES	Futures	3044.19	3045.28	3041.48	3042.83	23932.0
2019-03-01 09:00:00	ES	Futures	3042.83	3050.71	3042.29	3049.62	170859.0
2019-03-01 10:00:00	ES	Futures	3049.62	3049.62	3035.77	3039.03	245883.0
2019-03-01 11:00:00	ES	Futures	3039.03	3040.39	3028.17	3031.43	161470.0
2019-03-01 12:00:00	ES	Futures	3031.16	3038.49	3030.61	3037.67	87628.0
2019-03-01 13:00:00	ES	Futures	3037.67	3039.85	3036.86	3038.22	54962.0
2019-03-01 14:00:00	ES	Futures	3038.22	3046.09	3037.67	3044.73	101264.0
2019-03-01 15:00:00	ES	Futures	3044.73	3049.35	3041.75	3046.64	167218.0
2019-03-01 16:00:00	ES	Futures	3046.36	3049.89	3045.28	3049.35	50752.0
2019-03-01 00:00:00	NQ	Futures	8342.01	8350.19	8339.08	8347.85	2225.0
2019-03-01 01:00:00	NQ	Futures	8348.14	8354.28	8347.26	8352.52	2206.0
2019-03-01 02:00:00	NQ	Futures	8352.52	8353.4	8344.93	8351.06	2767.0
2019-03-01 03:00:00	NQ	Futures	8351.06	8365.97	8342.01	8363.04	7433.0
2019-03-01 04:00:00	NQ	Futures	8363.04	8367.72	8358.95	8361.0	4970.0
2019-03-01 05:00:00	NQ	Futures	8360.41	8362.46	8354.86	8360.71	2789.0
2019-03-01 06:00:00	NQ	Futures	8360.71	8365.09	8356.32	8363.34	2652.0
2019-03-01 07:00:00	NQ	Futures	8363.04	8365.67	8358.37	8362.46	6687.0
2019-03-01 08:00:00	NQ	Futures	8362.17	8365.67	8351.94	8355.74	6446.0
2019-03-01 09:00:00	NQ	Futures	8355.45	8370.64	8350.48	8359.54	53357.0
2019-03-01 10:00:00	NQ	Futures	8359.24	8359.24	8320.68	8339.67	75783.0
2019-03-01 11:00:00	NQ	Futures	8339.38	8342.01	8302.56	8315.12	54196.0
2019-03-01 12:00:00	NQ	Futures	8315.42	8341.42	8312.79	8338.79	33923.0
2019-03-01 13:00:00	NQ	Futures	8338.5	8350.77	8335.58	8348.14	22813.0
2019-03-01 14:00:00	NQ	Futures	8348.43	8372.98	8344.34	8363.04	34420.0
2019-03-01 15:00:00	NQ	Futures	8363.34	8373.56	8353.11	8363.04	36753.0
2019-03-01 16:00:00	NQ	Futures	8363.04	8369.18	8359.83	8366.84	7659.0
2019-03-01 17:00:00	NQ	Futures	8367.43	8367.43	8367.43	8367.43	2.0
2019-03-01 00:00:00	YM	Futures	28239.2	28245.7	28228.4	28238.1	1383.0
2019-03-01 01:00:00	YM	Futures	28238.1	28270.7	28236.0	28259.9	2002.0
2019-03-01 02:00:00	YM	Futures	28260.9	28266.4	28237.1	28260.9	2103.0
2019-03-01 03:00:00	YM	Futures	28260.9	28307.6	28236.0	28293.5	4593.0
2019-03-01 04:00:00	YM	Futures	28294.6	28316.3	28290.3	28301.1	3040.0
2019-03-01 05:00:00	YM	Futures	28301.1	28312.0	28293.5	28309.8	2171.0
2019-03-01 06:00:00	YM	Futures	28309.8	28328.3	28301.1	28328.3	2306.0
2019-03-01 07:00:00	YM	Futures	28327.2	28340.2	28319.6	28333.7	3216.0
2019-03-01 08:00:00	YM	Futures	28332.6	28339.1	28300.0	28308.7	3881.0
2019-03-01 09:00:00	YM	Futures	28309.8	28383.6	28307.6	28363.0	23825.0
2019-03-01 10:00:00	YM	Futures	28363.0	28363.0	28199.1	28231.6	37590.0
2019-03-01 11:00:00	YM	Futures	28231.6	28239.2	28129.6	28161.1	23680.0
2019-03-01 12:00:00	YM	Futures	28161.1	28215.3	28153.5	28211.0	14356.0
2019-03-01 13:00:00	YM	Futures	28212.1	28229.5	28204.5	28213.2	11548.0
2019-03-01 14:00:00	YM	Futures	28214.3	28276.1	28207.7	28253.3	10864.0

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

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