PREVIEW / futures_1hour / 2018-03-14

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-14.parquet
  size:    53 KB
  rows:    1,613

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-03-14 00:00:00	ES	Futures	3019.45	3023.0	3018.91	3021.91	2758.0
2018-03-14 01:00:00	ES	Futures	3022.18	3023.0	3020.0	3021.64	2600.0
2018-03-14 02:00:00	ES	Futures	3021.91	3023.82	3021.36	3023.0	2943.0
2018-03-14 03:00:00	ES	Futures	3023.0	3032.83	3023.0	3032.83	12659.0
2018-03-14 04:00:00	ES	Futures	3032.55	3037.19	3030.64	3034.46	22045.0
2018-03-14 05:00:00	ES	Futures	3034.46	3037.47	3033.37	3035.83	8721.0
2018-03-14 06:00:00	ES	Futures	3035.56	3038.56	3033.1	3033.65	9561.0
2018-03-14 07:00:00	ES	Futures	3033.65	3036.92	3033.65	3035.83	8588.0
2018-03-14 08:00:00	ES	Futures	3035.83	3037.47	3031.46	3033.65	32335.0
2018-03-14 09:00:00	ES	Futures	3033.37	3037.47	3025.46	3029.28	136734.0
2018-03-14 10:00:00	ES	Futures	3029.28	3032.83	3019.73	3024.09	190371.0
2018-03-14 11:00:00	ES	Futures	3024.09	3025.46	3004.17	3007.72	241985.0
2018-03-14 12:00:00	ES	Futures	3007.72	3014.82	3002.26	3009.36	175763.0
2018-03-14 13:00:00	ES	Futures	3009.36	3020.82	3002.26	3017.0	147668.0
2018-03-14 14:00:00	ES	Futures	3016.73	3018.64	3000.62	3009.36	145376.0
2018-03-14 15:00:00	ES	Futures	3009.36	3010.18	3000.08	3006.63	242414.0
2018-03-14 16:00:00	ES	Futures	3006.63	3008.81	3004.17	3007.72	58684.0
2018-03-14 18:00:00	ES	Futures	3007.17	3010.99	3006.36	3010.72	6191.0
2018-03-14 19:00:00	ES	Futures	3010.45	3010.99	3004.99	3009.08	7726.0
2018-03-14 20:00:00	ES	Futures	3009.08	3012.36	2996.8	2997.62	20376.0
2018-03-14 21:00:00	ES	Futures	2997.35	3002.81	2996.53	3000.9	8439.0
2018-03-14 22:00:00	ES	Futures	3000.9	3015.36	3000.9	3011.81	12554.0
2018-03-14 23:00:00	ES	Futures	3012.09	3013.18	3008.81	3010.72	4721.0
2018-03-14 00:00:00	NQ	Futures	8335.19	8348.78	8334.89	8346.71	1524.0
2018-03-14 01:00:00	NQ	Futures	8347.31	8350.26	8340.21	8346.12	1484.0
2018-03-14 02:00:00	NQ	Futures	8346.71	8353.51	8346.42	8349.37	1343.0
2018-03-14 03:00:00	NQ	Futures	8350.26	8388.38	8348.78	8388.38	5357.0
2018-03-14 04:00:00	NQ	Futures	8388.68	8412.03	8381.59	8406.12	9738.0
2018-03-14 05:00:00	NQ	Futures	8406.12	8413.5	8403.75	8407.3	4474.0
2018-03-14 06:00:00	NQ	Futures	8407.3	8418.53	8404.34	8406.12	4284.0
2018-03-14 07:00:00	NQ	Futures	8406.41	8414.69	8405.53	8406.41	3539.0
2018-03-14 08:00:00	NQ	Futures	8406.41	8412.32	8393.41	8401.98	10305.0
2018-03-14 09:00:00	NQ	Futures	8401.68	8407.89	8363.86	8376.86	46681.0
2018-03-14 10:00:00	NQ	Futures	8377.15	8401.68	8356.76	8385.13	61898.0
2018-03-14 11:00:00	NQ	Futures	8385.13	8389.57	8319.82	8334.6	63806.0
2018-03-14 12:00:00	NQ	Futures	8334.3	8374.49	8318.05	8362.67	51872.0
2018-03-14 13:00:00	NQ	Futures	8362.38	8402.57	8342.87	8387.5	40610.0
2018-03-14 14:00:00	NQ	Futures	8387.5	8392.82	8336.67	8362.08	43674.0
2018-03-14 15:00:00	NQ	Futures	8362.08	8364.15	8336.08	8353.51	54080.0
2018-03-14 16:00:00	NQ	Futures	8353.22	8355.28	8340.51	8346.12	11151.0
2018-03-14 18:00:00	NQ	Futures	8346.71	8356.47	8343.76	8356.17	1688.0
2018-03-14 19:00:00	NQ	Futures	8355.88	8357.35	8340.8	8349.67	3223.0
2018-03-14 20:00:00	NQ	Futures	8349.37	8362.97	8309.48	8313.61	7588.0
2018-03-14 21:00:00	NQ	Futures	8313.32	8327.8	8307.11	8323.37	4231.0
2018-03-14 22:00:00	NQ	Futures	8323.66	8362.38	8323.07	8356.76	4801.0
2018-03-14 23:00:00	NQ	Futures	8357.06	8360.6	8347.01	8354.69	2265.0
2018-03-14 00:00:00	YM	Futures	27161.4	27192.9	27159.3	27178.8	1540.0
2018-03-14 01:00:00	YM	Futures	27179.9	27187.5	27157.1	27174.5	1383.0
2018-03-14 02:00:00	YM	Futures	27175.6	27190.8	27168.0	27178.8	846.0
2018-03-14 03:00:00	YM	Futures	27181.0	27279.8	27178.8	27279.8	3186.0

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

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