PREVIEW / futures_1hour / 2019-01-21

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-01-21.parquet
  size:    41 KB
  rows:    1,318

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-01-21 00:00:00	ES	Futures	2896.45	2897.26	2892.38	2894.82	5217.0
2019-01-21 01:00:00	ES	Futures	2894.55	2895.63	2894.01	2895.36	2254.0
2019-01-21 02:00:00	ES	Futures	2895.09	2895.91	2893.73	2894.82	5470.0
2019-01-21 03:00:00	ES	Futures	2894.82	2895.63	2891.02	2891.29	9928.0
2019-01-21 04:00:00	ES	Futures	2891.29	2891.83	2887.22	2888.03	9447.0
2019-01-21 05:00:00	ES	Futures	2888.3	2892.38	2886.67	2891.29	7473.0
2019-01-21 06:00:00	ES	Futures	2891.29	2891.56	2888.03	2891.29	5457.0
2019-01-21 07:00:00	ES	Futures	2891.29	2894.01	2890.75	2892.38	7555.0
2019-01-21 08:00:00	ES	Futures	2892.38	2894.01	2891.02	2893.46	7684.0
2019-01-21 09:00:00	ES	Futures	2893.46	2893.73	2885.04	2888.3	22244.0
2019-01-21 10:00:00	ES	Futures	2888.3	2890.75	2888.03	2888.85	13219.0
2019-01-21 11:00:00	ES	Futures	2889.12	2892.65	2889.12	2892.38	11685.0
2019-01-21 12:00:00	ES	Futures	2892.65	2894.82	2891.56	2893.19	6948.0
2019-01-21 18:00:00	ES	Futures	2888.3	2894.01	2888.3	2893.19	7406.0
2019-01-21 19:00:00	ES	Futures	2893.19	2896.45	2886.13	2887.22	9784.0
2019-01-21 20:00:00	ES	Futures	2887.22	2890.75	2885.04	2885.59	8162.0
2019-01-21 21:00:00	ES	Futures	2885.86	2887.22	2882.6	2884.23	9343.0
2019-01-21 22:00:00	ES	Futures	2884.23	2885.31	2880.43	2881.51	7091.0
2019-01-21 23:00:00	ES	Futures	2881.51	2883.41	2880.97	2882.6	4187.0
2019-01-21 00:00:00	NQ	Futures	7916.87	7919.21	7903.72	7910.44	2172.0
2019-01-21 01:00:00	NQ	Futures	7910.15	7913.95	7907.23	7913.07	1161.0
2019-01-21 02:00:00	NQ	Futures	7913.36	7915.41	7906.64	7911.9	2291.0
2019-01-21 03:00:00	NQ	Futures	7912.49	7914.24	7898.46	7900.51	3993.0
2019-01-21 04:00:00	NQ	Futures	7900.51	7901.09	7885.31	7891.45	3996.0
2019-01-21 05:00:00	NQ	Futures	7892.62	7906.64	7888.53	7903.14	2751.0
2019-01-21 06:00:00	NQ	Futures	7903.14	7905.77	7896.42	7904.31	2366.0
2019-01-21 07:00:00	NQ	Futures	7904.6	7910.73	7901.38	7905.47	2588.0
2019-01-21 08:00:00	NQ	Futures	7905.47	7914.53	7902.84	7912.19	2415.0
2019-01-21 09:00:00	NQ	Futures	7912.19	7913.36	7878.89	7886.48	11972.0
2019-01-21 10:00:00	NQ	Futures	7886.19	7898.46	7885.9	7891.16	7816.0
2019-01-21 11:00:00	NQ	Futures	7891.45	7904.89	7889.7	7899.63	5361.0
2019-01-21 12:00:00	NQ	Futures	7899.92	7908.69	7894.37	7902.55	3057.0
2019-01-21 18:00:00	NQ	Futures	7895.54	7914.24	7892.03	7912.49	3629.0
2019-01-21 19:00:00	NQ	Futures	7913.07	7922.13	7885.9	7889.99	5488.0
2019-01-21 20:00:00	NQ	Futures	7890.28	7901.09	7879.47	7881.81	4445.0
2019-01-21 21:00:00	NQ	Futures	7882.1	7887.94	7872.17	7878.01	4410.0
2019-01-21 22:00:00	NQ	Futures	7878.01	7882.98	7866.91	7869.54	3673.0
2019-01-21 23:00:00	NQ	Futures	7869.54	7875.09	7863.98	7870.7	3557.0
2019-01-21 00:00:00	YM	Futures	26741.0	26746.4	26699.7	26723.6	1434.0
2019-01-21 01:00:00	YM	Futures	26722.5	26732.3	26714.9	26730.1	787.0
2019-01-21 02:00:00	YM	Futures	26729.0	26735.5	26711.6	26723.6	1501.0
2019-01-21 03:00:00	YM	Futures	26723.6	26726.8	26694.3	26705.1	3193.0
2019-01-21 04:00:00	YM	Futures	26706.2	26706.2	26657.4	26669.3	3782.0
2019-01-21 05:00:00	YM	Futures	26670.4	26708.4	26657.4	26697.5	2386.0
2019-01-21 06:00:00	YM	Futures	26697.5	26697.5	26666.0	26692.1	1872.0
2019-01-21 07:00:00	YM	Futures	26694.3	26716.0	26689.9	26704.0	2006.0
2019-01-21 08:00:00	YM	Futures	26705.1	26710.6	26674.7	26704.0	2741.0
2019-01-21 09:00:00	YM	Futures	26705.1	26706.2	26630.2	26665.0	4714.0
2019-01-21 10:00:00	YM	Futures	26663.9	26689.9	26663.9	26678.0	2642.0
2019-01-21 11:00:00	YM	Futures	26680.2	26704.0	26676.9	26697.5	2133.0

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

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