PREVIEW / futures_1hour / 2018-03-13

all futures 1-hour files

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

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-13 00:00:00	ES	Futures	3043.23	3045.42	3042.96	3045.15	1500.0
2018-03-13 01:00:00	ES	Futures	3044.87	3045.97	3044.05	3045.42	1422.0
2018-03-13 02:00:00	ES	Futures	3045.42	3045.97	3044.6	3044.87	796.0
2018-03-13 03:00:00	ES	Futures	3044.87	3048.43	3044.87	3047.33	2173.0
2018-03-13 04:00:00	ES	Futures	3047.61	3049.52	3046.79	3048.43	3370.0
2018-03-13 05:00:00	ES	Futures	3048.7	3051.43	3048.15	3049.52	3964.0
2018-03-13 06:00:00	ES	Futures	3049.79	3051.71	3049.25	3050.61	3051.0
2018-03-13 07:00:00	ES	Futures	3050.61	3051.43	3048.97	3049.79	3649.0
2018-03-13 08:00:00	ES	Futures	3050.07	3061.27	3047.33	3055.53	44234.0
2018-03-13 09:00:00	ES	Futures	3055.53	3064.01	3052.53	3058.27	35498.0
2018-03-13 10:00:00	ES	Futures	3058.27	3060.18	3048.43	3048.7	50812.0
2018-03-13 11:00:00	ES	Futures	3048.97	3049.25	3037.49	3039.41	62678.0
2018-03-13 12:00:00	ES	Futures	3039.41	3041.32	3027.93	3039.41	53289.0
2018-03-13 13:00:00	ES	Futures	3039.13	3043.23	3032.57	3033.39	32336.0
2018-03-13 14:00:00	ES	Futures	3033.39	3036.4	3025.47	3028.47	34352.0
2018-03-13 15:00:00	ES	Futures	3028.75	3031.48	3015.9	3023.01	86004.0
2018-03-13 16:00:00	ES	Futures	3023.01	3027.93	3021.64	3021.64	19173.0
2018-03-13 18:00:00	ES	Futures	3020.82	3021.64	3015.63	3021.09	2729.0
2018-03-13 19:00:00	ES	Futures	3021.09	3023.01	3019.18	3021.91	2147.0
2018-03-13 20:00:00	ES	Futures	3021.91	3024.65	3021.64	3021.64	3035.0
2018-03-13 21:00:00	ES	Futures	3021.91	3022.46	3017.81	3019.45	3249.0
2018-03-13 22:00:00	ES	Futures	3019.73	3021.09	3016.72	3017.27	1668.0
2018-03-13 23:00:00	ES	Futures	3017.54	3020.55	3015.9	3019.45	1512.0
2018-03-13 00:00:00	NQ	Futures	8460.94	8469.84	8460.94	8468.36	575.0
2018-03-13 01:00:00	NQ	Futures	8468.66	8472.21	8464.8	8469.84	429.0
2018-03-13 02:00:00	NQ	Futures	8468.66	8470.73	8465.99	8466.58	203.0
2018-03-13 03:00:00	NQ	Futures	8468.36	8475.77	8468.36	8473.99	733.0
2018-03-13 04:00:00	NQ	Futures	8474.29	8478.74	8470.73	8474.59	698.0
2018-03-13 05:00:00	NQ	Futures	8476.07	8483.19	8472.81	8475.77	1041.0
2018-03-13 06:00:00	NQ	Futures	8476.37	8481.41	8474.29	8480.82	788.0
2018-03-13 07:00:00	NQ	Futures	8480.52	8483.78	8477.55	8480.82	924.0
2018-03-13 08:00:00	NQ	Futures	8480.82	8514.03	8473.1	8501.87	5302.0
2018-03-13 09:00:00	NQ	Futures	8502.76	8528.27	8495.94	8508.1	12665.0
2018-03-13 10:00:00	NQ	Futures	8508.7	8521.45	8461.54	8464.21	15884.0
2018-03-13 11:00:00	NQ	Futures	8464.21	8465.39	8407.56	8422.09	25995.0
2018-03-13 12:00:00	NQ	Futures	8421.79	8425.65	8369.89	8417.34	16537.0
2018-03-13 13:00:00	NQ	Futures	8417.94	8434.25	8398.96	8401.63	7920.0
2018-03-13 14:00:00	NQ	Futures	8400.74	8411.41	8365.44	8379.97	11583.0
2018-03-13 15:00:00	NQ	Futures	8380.86	8391.24	8335.19	8359.81	20097.0
2018-03-13 16:00:00	NQ	Futures	8359.51	8376.12	8357.14	8357.73	2904.0
2018-03-13 18:00:00	NQ	Futures	8351.5	8354.17	8330.15	8353.28	535.0
2018-03-13 19:00:00	NQ	Futures	8354.47	8357.43	8346.16	8351.2	560.0
2018-03-13 20:00:00	NQ	Futures	8352.09	8356.25	8339.04	8340.23	396.0
2018-03-13 21:00:00	NQ	Futures	8340.82	8343.2	8326.29	8331.93	817.0
2018-03-13 22:00:00	NQ	Futures	8331.93	8339.04	8326.59	8328.66	471.0
2018-03-13 23:00:00	NQ	Futures	8328.37	8338.45	8326.29	8335.19	294.0
2018-03-13 00:00:00	YM	Futures	27422.1	27450.3	27419.9	27441.6	1474.0
2018-03-13 01:00:00	YM	Futures	27442.7	27479.6	27432.9	27452.5	2400.0
2018-03-13 02:00:00	YM	Futures	27451.4	27454.7	27444.9	27449.2	754.0
2018-03-13 03:00:00	YM	Futures	27449.2	27482.9	27449.2	27463.4	2543.0

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

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