PREVIEW / futures_1hour / 2018-03-12

all futures 1-hour files

  file:    by_date/futures_1hour/2018/2018-03-12.parquet
  size:    49 KB
  rows:    1,566

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-12 00:00:00	ES	Futures	3055.26	3057.99	3051.71	3054.44	4662.0
2018-03-12 01:00:00	ES	Futures	3054.44	3056.9	3053.35	3056.9	3427.0
2018-03-12 02:00:00	ES	Futures	3056.9	3061.0	3056.08	3059.91	5712.0
2018-03-12 03:00:00	ES	Futures	3059.91	3061.82	3058.54	3060.73	5674.0
2018-03-12 04:00:00	ES	Futures	3060.45	3060.73	3051.16	3054.17	11939.0
2018-03-12 05:00:00	ES	Futures	3054.44	3056.08	3051.98	3053.89	6358.0
2018-03-12 06:00:00	ES	Futures	3054.17	3056.63	3052.53	3054.44	6946.0
2018-03-12 07:00:00	ES	Futures	3054.44	3055.26	3049.52	3051.43	10135.0
2018-03-12 08:00:00	ES	Futures	3051.43	3051.71	3048.15	3048.43	10320.0
2018-03-12 09:00:00	ES	Futures	3048.7	3058.27	3047.61	3054.44	45813.0
2018-03-12 10:00:00	ES	Futures	3054.44	3055.26	3043.51	3043.51	55591.0
2018-03-12 11:00:00	ES	Futures	3043.51	3046.79	3038.31	3044.6	67956.0
2018-03-12 12:00:00	ES	Futures	3044.6	3048.7	3042.41	3044.6	32423.0
2018-03-12 13:00:00	ES	Futures	3044.6	3049.52	3044.33	3044.6	21831.0
2018-03-12 14:00:00	ES	Futures	3044.87	3047.88	3038.59	3040.5	29990.0
2018-03-12 15:00:00	ES	Futures	3040.5	3052.53	3040.23	3042.41	74435.0
2018-03-12 16:00:00	ES	Futures	3042.69	3044.87	3041.87	3042.69	22927.0
2018-03-12 18:00:00	ES	Futures	3041.87	3044.33	3041.05	3043.23	1413.0
2018-03-12 19:00:00	ES	Futures	3043.51	3043.51	3041.05	3042.41	790.0
2018-03-12 20:00:00	ES	Futures	3042.41	3043.23	3041.59	3043.23	1134.0
2018-03-12 21:00:00	ES	Futures	3042.96	3044.6	3041.59	3043.23	2344.0
2018-03-12 22:00:00	ES	Futures	3043.23	3043.23	3041.87	3042.96	890.0
2018-03-12 23:00:00	ES	Futures	3042.69	3043.78	3042.41	3043.23	792.0
2018-03-12 00:00:00	NQ	Futures	8465.69	8478.74	8458.87	8464.5	1056.0
2018-03-12 01:00:00	NQ	Futures	8465.1	8472.81	8463.02	8469.55	904.0
2018-03-12 02:00:00	NQ	Futures	8470.14	8478.15	8468.66	8474.29	1229.0
2018-03-12 03:00:00	NQ	Futures	8474.59	8483.19	8470.73	8479.33	1283.0
2018-03-12 04:00:00	NQ	Futures	8479.93	8479.93	8461.83	8471.03	2684.0
2018-03-12 05:00:00	NQ	Futures	8471.33	8477.55	8464.5	8470.14	1867.0
2018-03-12 06:00:00	NQ	Futures	8470.73	8475.48	8465.99	8470.44	736.0
2018-03-12 07:00:00	NQ	Futures	8471.03	8471.92	8458.87	8463.32	1457.0
2018-03-12 08:00:00	NQ	Futures	8463.32	8463.61	8449.67	8449.67	2047.0
2018-03-12 09:00:00	NQ	Futures	8449.97	8474.59	8441.96	8468.06	13679.0
2018-03-12 10:00:00	NQ	Futures	8468.66	8480.52	8453.83	8454.42	19582.0
2018-03-12 11:00:00	NQ	Futures	8454.72	8474.29	8434.25	8472.21	17243.0
2018-03-12 12:00:00	NQ	Futures	8472.51	8486.45	8469.55	8477.85	10895.0
2018-03-12 13:00:00	NQ	Futures	8478.15	8492.98	8469.84	8470.14	7866.0
2018-03-12 14:00:00	NQ	Futures	8470.14	8478.44	8449.67	8463.32	10477.0
2018-03-12 15:00:00	NQ	Futures	8463.61	8490.01	8460.35	8462.43	12716.0
2018-03-12 16:00:00	NQ	Futures	8463.02	8472.21	8460.05	8466.28	3327.0
2018-03-12 18:00:00	NQ	Futures	8466.88	8472.51	8461.83	8464.8	351.0
2018-03-12 19:00:00	NQ	Futures	8464.8	8465.69	8454.12	8459.16	682.0
2018-03-12 20:00:00	NQ	Futures	8459.16	8462.43	8456.5	8462.13	414.0
2018-03-12 21:00:00	NQ	Futures	8462.43	8464.8	8455.31	8456.5	430.0
2018-03-12 22:00:00	NQ	Futures	8457.39	8457.68	8453.53	8456.2	225.0
2018-03-12 23:00:00	NQ	Futures	8455.9	8461.54	8455.31	8460.65	260.0
2018-03-12 00:00:00	YM	Futures	27659.9	27688.2	27631.7	27652.3	1753.0
2018-03-12 01:00:00	YM	Futures	27653.4	27678.4	27649.1	27675.1	1876.0
2018-03-12 02:00:00	YM	Futures	27675.1	27717.5	27666.4	27708.8	1975.0
2018-03-12 03:00:00	YM	Futures	27711.0	27731.6	27694.7	27712.1	1673.0

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

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