PREVIEW / futures_1hour / 2019-11-28

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-11-28.parquet
  size:    40 KB
  rows:    1,303

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-11-28 00:00:00	ES	Futures	3417.12	3417.39	3416.03	3416.3	3966.0
2019-11-28 01:00:00	ES	Futures	3416.57	3417.39	3415.22	3417.39	3163.0
2019-11-28 02:00:00	ES	Futures	3417.39	3419.02	3416.57	3417.39	6064.0
2019-11-28 03:00:00	ES	Futures	3417.39	3417.93	3414.67	3416.57	11322.0
2019-11-28 04:00:00	ES	Futures	3416.85	3417.12	3415.76	3416.85	4255.0
2019-11-28 05:00:00	ES	Futures	3416.57	3418.2	3416.3	3417.93	5650.0
2019-11-28 06:00:00	ES	Futures	3417.93	3421.19	3417.93	3420.38	6187.0
2019-11-28 07:00:00	ES	Futures	3420.38	3422.01	3420.38	3420.65	6654.0
2019-11-28 08:00:00	ES	Futures	3420.92	3421.19	3419.29	3419.83	5852.0
2019-11-28 09:00:00	ES	Futures	3419.56	3420.92	3418.48	3420.38	7841.0
2019-11-28 10:00:00	ES	Futures	3420.38	3422.01	3419.83	3420.65	7357.0
2019-11-28 11:00:00	ES	Futures	3420.65	3422.82	3420.65	3422.01	7581.0
2019-11-28 12:00:00	ES	Futures	3422.28	3423.64	3421.74	3422.82	4332.0
2019-11-28 18:00:00	ES	Futures	3422.55	3424.45	3422.28	3423.91	4053.0
2019-11-28 19:00:00	ES	Futures	3423.64	3424.18	3421.19	3421.46	5680.0
2019-11-28 20:00:00	ES	Futures	3421.46	3421.74	3417.93	3418.48	11507.0
2019-11-28 21:00:00	ES	Futures	3418.48	3420.38	3417.93	3419.56	6629.0
2019-11-28 22:00:00	ES	Futures	3419.29	3419.56	3416.3	3417.93	6925.0
2019-11-28 23:00:00	ES	Futures	3418.2	3418.2	3416.57	3417.39	3141.0
2019-11-28 00:00:00	NQ	Futures	9794.24	9795.11	9788.72	9791.33	1504.0
2019-11-28 01:00:00	NQ	Futures	9791.62	9793.66	9787.56	9792.79	1017.0
2019-11-28 02:00:00	NQ	Futures	9792.79	9800.92	9790.75	9796.85	2447.0
2019-11-28 03:00:00	NQ	Futures	9796.85	9799.18	9790.46	9796.85	5141.0
2019-11-28 04:00:00	NQ	Futures	9797.14	9797.43	9792.21	9794.53	1981.0
2019-11-28 05:00:00	NQ	Futures	9794.53	9798.31	9793.66	9797.72	1735.0
2019-11-28 06:00:00	NQ	Futures	9797.72	9806.15	9797.72	9804.41	2478.0
2019-11-28 07:00:00	NQ	Futures	9804.7	9811.67	9804.7	9809.34	2641.0
2019-11-28 08:00:00	NQ	Futures	9809.34	9809.63	9802.66	9803.82	2380.0
2019-11-28 09:00:00	NQ	Futures	9803.82	9810.8	9800.63	9806.44	3621.0
2019-11-28 10:00:00	NQ	Futures	9806.44	9808.18	9802.08	9803.53	3200.0
2019-11-28 11:00:00	NQ	Futures	9803.24	9811.96	9802.95	9810.8	2955.0
2019-11-28 12:00:00	NQ	Futures	9811.38	9816.03	9810.22	9812.25	2145.0
2019-11-28 18:00:00	NQ	Futures	9810.22	9818.35	9809.34	9818.06	1977.0
2019-11-28 19:00:00	NQ	Futures	9817.48	9819.8	9809.63	9809.63	1990.0
2019-11-28 20:00:00	NQ	Futures	9809.93	9810.8	9790.75	9793.37	6377.0
2019-11-28 21:00:00	NQ	Futures	9793.37	9799.47	9789.88	9793.95	2884.0
2019-11-28 22:00:00	NQ	Futures	9793.95	9793.95	9784.36	9789.3	3068.0
2019-11-28 23:00:00	NQ	Futures	9789.3	9789.3	9784.65	9788.43	1541.0
2019-11-28 00:00:00	YM	Futures	30551.1	30551.1	30537.0	30540.3	854.0
2019-11-28 01:00:00	YM	Futures	30541.3	30553.3	30530.5	30553.3	648.0
2019-11-28 02:00:00	YM	Futures	30553.3	30562.0	30545.7	30545.7	1195.0
2019-11-28 03:00:00	YM	Futures	30547.9	30550.0	30522.8	30533.7	3303.0
2019-11-28 04:00:00	YM	Futures	30534.8	30534.8	30522.8	30529.4	1133.0
2019-11-28 05:00:00	YM	Futures	30529.4	30543.5	30525.0	30542.4	1399.0
2019-11-28 06:00:00	YM	Futures	30542.4	30564.2	30542.4	30555.5	1149.0
2019-11-28 07:00:00	YM	Futures	30556.6	30570.7	30554.4	30569.6	1674.0
2019-11-28 08:00:00	YM	Futures	30568.6	30568.6	30552.2	30559.8	1230.0
2019-11-28 09:00:00	YM	Futures	30559.8	30572.9	30549.0	30567.5	1891.0
2019-11-28 10:00:00	YM	Futures	30567.5	30581.6	30558.8	30575.1	1730.0
2019-11-28 11:00:00	YM	Futures	30574.0	30597.9	30572.9	30595.8	2336.0

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

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