PREVIEW / futures_1hour / 2017-07-12

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-07-12.parquet
  size:    53 KB
  rows:    1,605

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
2017-07-12 00:00:00	ES	Futures	2649.2	2650.02	2649.2	2649.75	871.0
2017-07-12 01:00:00	ES	Futures	2650.02	2650.84	2649.75	2650.02	2656.0
2017-07-12 02:00:00	ES	Futures	2650.02	2650.84	2648.93	2650.3	5532.0
2017-07-12 03:00:00	ES	Futures	2650.02	2652.21	2649.48	2651.39	14290.0
2017-07-12 04:00:00	ES	Futures	2651.39	2651.94	2650.84	2651.66	6374.0
2017-07-12 05:00:00	ES	Futures	2651.39	2654.94	2650.57	2654.12	15721.0
2017-07-12 06:00:00	ES	Futures	2654.12	2656.04	2653.85	2655.49	13777.0
2017-07-12 07:00:00	ES	Futures	2655.49	2656.04	2654.12	2654.4	12613.0
2017-07-12 08:00:00	ES	Futures	2654.4	2663.96	2654.12	2662.6	69265.0
2017-07-12 09:00:00	ES	Futures	2662.87	2669.98	2661.78	2668.34	204919.0
2017-07-12 10:00:00	ES	Futures	2668.34	2670.8	2665.33	2665.6	163354.0
2017-07-12 11:00:00	ES	Futures	2665.88	2668.34	2664.78	2667.52	90972.0
2017-07-12 12:00:00	ES	Futures	2667.52	2669.43	2664.51	2668.34	102542.0
2017-07-12 13:00:00	ES	Futures	2668.34	2670.52	2666.97	2670.25	65966.0
2017-07-12 14:00:00	ES	Futures	2670.52	2671.89	2668.88	2670.25	62329.0
2017-07-12 15:00:00	ES	Futures	2669.98	2671.89	2668.06	2669.16	177912.0
2017-07-12 16:00:00	ES	Futures	2669.43	2669.7	2666.97	2668.61	95456.0
2017-07-12 18:00:00	ES	Futures	2669.16	2669.7	2668.06	2669.7	4336.0
2017-07-12 19:00:00	ES	Futures	2669.7	2669.7	2668.34	2669.7	2946.0
2017-07-12 20:00:00	ES	Futures	2669.43	2671.07	2669.16	2669.7	5038.0
2017-07-12 21:00:00	ES	Futures	2669.7	2670.52	2669.43	2669.7	3701.0
2017-07-12 22:00:00	ES	Futures	2669.98	2670.25	2669.43	2669.98	1697.0
2017-07-12 23:00:00	ES	Futures	2669.7	2669.98	2668.88	2668.88	3200.0
2017-07-12 00:00:00	NQ	Futures	6807.49	6810.17	6806.89	6810.17	369.0
2017-07-12 01:00:00	NQ	Futures	6810.46	6813.14	6809.87	6811.66	846.0
2017-07-12 02:00:00	NQ	Futures	6811.66	6811.95	6807.19	6808.38	945.0
2017-07-12 03:00:00	NQ	Futures	6808.38	6815.82	6807.49	6814.63	1899.0
2017-07-12 04:00:00	NQ	Futures	6814.93	6815.82	6809.27	6811.36	1603.0
2017-07-12 05:00:00	NQ	Futures	6811.36	6824.76	6809.57	6822.08	2529.0
2017-07-12 06:00:00	NQ	Futures	6822.08	6836.37	6821.18	6832.5	4005.0
2017-07-12 07:00:00	NQ	Futures	6832.5	6837.26	6828.33	6828.63	4839.0
2017-07-12 08:00:00	NQ	Futures	6828.63	6867.63	6827.44	6864.36	17238.0
2017-07-12 09:00:00	NQ	Futures	6864.36	6871.8	6849.47	6856.32	54722.0
2017-07-12 10:00:00	NQ	Futures	6856.32	6874.18	6851.55	6859.3	41709.0
2017-07-12 11:00:00	NQ	Futures	6859.3	6873.59	6858.4	6870.01	25093.0
2017-07-12 12:00:00	NQ	Futures	6870.31	6877.16	6862.27	6872.69	23484.0
2017-07-12 13:00:00	NQ	Futures	6872.99	6881.92	6867.93	6880.44	17320.0
2017-07-12 14:00:00	NQ	Futures	6880.73	6887.28	6876.27	6883.71	17694.0
2017-07-12 15:00:00	NQ	Futures	6883.71	6893.54	6882.22	6886.99	33649.0
2017-07-12 16:00:00	NQ	Futures	6886.99	6895.92	6883.41	6892.35	9222.0
2017-07-12 18:00:00	NQ	Futures	6892.05	6895.03	6889.67	6895.03	897.0
2017-07-12 19:00:00	NQ	Futures	6894.73	6897.41	6888.77	6897.41	807.0
2017-07-12 20:00:00	NQ	Futures	6897.11	6915.27	6896.51	6904.85	3167.0
2017-07-12 21:00:00	NQ	Futures	6904.85	6911.7	6904.85	6907.23	1409.0
2017-07-12 22:00:00	NQ	Futures	6907.23	6909.91	6903.66	6905.45	1052.0
2017-07-12 23:00:00	NQ	Futures	6905.74	6907.53	6903.06	6903.96	613.0
2017-07-12 00:00:00	YM	Futures	23256.5	23261.9	23256.5	23260.9	224.0
2017-07-12 01:00:00	YM	Futures	23260.9	23267.4	23259.8	23261.9	327.0
2017-07-12 02:00:00	YM	Futures	23261.9	23266.3	23254.3	23261.9	861.0
2017-07-12 03:00:00	YM	Futures	23261.9	23272.8	23258.7	23266.3	1849.0

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

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