PREVIEW / futures_1hour / 2014-06-24

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-24.parquet
  size:    49 KB
  rows:    1,531

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
2014-06-24 00:00:00	ES	Futures	2033.05	2034.09	2033.05	2033.83	1927.0
2014-06-24 01:00:00	ES	Futures	2034.09	2034.35	2033.31	2033.57	2778.0
2014-06-24 02:00:00	ES	Futures	2033.57	2035.92	2033.31	2035.92	7637.0
2014-06-24 03:00:00	ES	Futures	2035.66	2036.18	2034.09	2034.61	19365.0
2014-06-24 04:00:00	ES	Futures	2034.61	2035.4	2032.53	2033.05	19868.0
2014-06-24 05:00:00	ES	Futures	2033.31	2033.57	2029.66	2030.44	23017.0
2014-06-24 06:00:00	ES	Futures	2030.44	2032.53	2030.18	2032.27	11736.0
2014-06-24 07:00:00	ES	Futures	2032.53	2032.79	2031.23	2032.27	18848.0
2014-06-24 08:00:00	ES	Futures	2032.01	2034.35	2032.01	2033.57	21177.0
2014-06-24 09:00:00	ES	Futures	2033.83	2036.7	2032.79	2034.09	142521.0
2014-06-24 10:00:00	ES	Futures	2034.35	2042.43	2034.09	2041.91	240262.0
2014-06-24 11:00:00	ES	Futures	2042.17	2043.21	2041.13	2041.65	111145.0
2014-06-24 12:00:00	ES	Futures	2041.91	2041.91	2039.04	2039.57	65945.0
2014-06-24 13:00:00	ES	Futures	2039.3	2039.57	2033.31	2033.83	184391.0
2014-06-24 14:00:00	ES	Futures	2033.83	2035.92	2030.18	2031.23	152794.0
2014-06-24 15:00:00	ES	Futures	2030.96	2031.23	2022.1	2024.19	389441.0
2014-06-24 16:00:00	ES	Futures	2024.19	2026.27	2024.19	2024.97	85006.0
2014-06-24 17:00:00	ES	Futures	2024.71	2025.49	2024.45	2024.45	2670.0
2014-06-24 18:00:00	ES	Futures	2024.71	2025.49	2023.41	2024.19	4285.0
2014-06-24 19:00:00	ES	Futures	2024.45	2024.97	2023.67	2024.71	1693.0
2014-06-24 20:00:00	ES	Futures	2024.97	2025.49	2024.45	2025.23	3096.0
2014-06-24 21:00:00	ES	Futures	2025.23	2025.75	2024.19	2025.49	3991.0
2014-06-24 22:00:00	ES	Futures	2025.49	2025.49	2023.93	2024.45	4658.0
2014-06-24 23:00:00	ES	Futures	2024.45	2024.45	2022.36	2022.89	5167.0
2014-06-24 00:00:00	NQ	Futures	4428.11	4428.99	4428.11	4428.99	219.0
2014-06-24 01:00:00	NQ	Futures	4428.99	4430.45	4428.11	4429.28	547.0
2014-06-24 02:00:00	NQ	Futures	4429.28	4433.95	4429.28	4433.66	734.0
2014-06-24 03:00:00	NQ	Futures	4433.37	4434.24	4430.74	4431.61	2721.0
2014-06-24 04:00:00	NQ	Futures	4431.32	4433.37	4426.07	4427.53	3160.0
2014-06-24 05:00:00	NQ	Futures	4427.53	4428.4	4419.64	4420.52	4937.0
2014-06-24 06:00:00	NQ	Futures	4420.81	4425.19	4420.52	4424.61	1959.0
2014-06-24 07:00:00	NQ	Futures	4424.9	4431.03	4423.44	4431.03	4472.0
2014-06-24 08:00:00	NQ	Futures	4431.03	4434.54	4431.03	4434.24	3942.0
2014-06-24 09:00:00	NQ	Futures	4433.95	4449.72	4432.49	4445.05	38943.0
2014-06-24 10:00:00	NQ	Futures	4445.05	4469.87	4444.17	4468.7	49286.0
2014-06-24 11:00:00	NQ	Futures	4468.7	4471.33	4467.53	4469.58	20004.0
2014-06-24 12:00:00	NQ	Futures	4469.28	4471.04	4464.9	4466.95	12607.0
2014-06-24 13:00:00	NQ	Futures	4466.95	4467.24	4452.64	4454.98	34551.0
2014-06-24 14:00:00	NQ	Futures	4454.98	4460.23	4447.38	4450.6	26237.0
2014-06-24 15:00:00	NQ	Futures	4450.3	4450.3	4416.72	4428.69	67030.0
2014-06-24 16:00:00	NQ	Futures	4428.99	4432.78	4428.69	4430.15	6712.0
2014-06-24 17:00:00	NQ	Futures	4430.15	4430.74	4429.28	4429.28	362.0
2014-06-24 18:00:00	NQ	Futures	4429.57	4429.86	4426.07	4428.11	617.0
2014-06-24 19:00:00	NQ	Futures	4428.11	4430.15	4426.94	4430.15	311.0
2014-06-24 20:00:00	NQ	Futures	4429.86	4431.91	4429.28	4431.03	440.0
2014-06-24 21:00:00	NQ	Futures	4431.61	4431.91	4427.53	4429.28	1420.0
2014-06-24 22:00:00	NQ	Futures	4429.28	4429.28	4426.65	4428.11	599.0
2014-06-24 23:00:00	NQ	Futures	4427.82	4428.11	4422.56	4422.85	1312.0
2014-06-24 00:00:00	YM	Futures	17402.5	17409.7	17402.5	17409.7	363.0
2014-06-24 01:00:00	YM	Futures	17409.7	17412.8	17403.5	17405.6	567.0

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

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