PREVIEW / futures_1hour / 2010-01-05

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-05.parquet
  size:    46 KB
  rows:    1,379

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
2010-01-05 00:00:00	ES	Futures	1097.58	1097.83	1096.85	1097.34	3004.0
2010-01-05 01:00:00	ES	Futures	1097.34	1098.07	1097.1	1097.83	1341.0
2010-01-05 02:00:00	ES	Futures	1097.83	1098.56	1097.58	1098.56	6756.0
2010-01-05 03:00:00	ES	Futures	1098.56	1098.56	1096.12	1097.1	16874.0
2010-01-05 04:00:00	ES	Futures	1097.1	1098.31	1096.61	1097.58	9152.0
2010-01-05 05:00:00	ES	Futures	1097.83	1099.29	1097.1	1098.56	9699.0
2010-01-05 06:00:00	ES	Futures	1098.56	1099.29	1097.34	1098.31	10995.0
2010-01-05 07:00:00	ES	Futures	1098.56	1100.26	1098.07	1099.77	16420.0
2010-01-05 08:00:00	ES	Futures	1100.02	1100.26	1097.83	1098.07	34484.0
2010-01-05 09:00:00	ES	Futures	1098.31	1099.04	1094.91	1094.91	176074.0
2010-01-05 10:00:00	ES	Futures	1094.91	1102.21	1094.66	1100.75	278572.0
2010-01-05 11:00:00	ES	Futures	1100.75	1101.48	1097.58	1098.56	160283.0
2010-01-05 12:00:00	ES	Futures	1098.8	1100.26	1098.07	1098.8	94841.0
2010-01-05 13:00:00	ES	Futures	1098.8	1099.04	1096.61	1097.83	111101.0
2010-01-05 14:00:00	ES	Futures	1097.83	1099.04	1095.64	1098.8	145027.0
2010-01-05 15:00:00	ES	Futures	1098.8	1101.96	1098.56	1101.23	214305.0
2010-01-05 16:00:00	ES	Futures	1101.48	1102.45	1100.99	1101.23	70565.0
2010-01-05 17:00:00	ES	Futures	1101.23	1101.48	1100.99	1100.99	1345.0
2010-01-05 18:00:00	ES	Futures	1100.99	1101.23	1100.5	1100.5	1815.0
2010-01-05 19:00:00	ES	Futures	1100.5	1100.99	1100.02	1100.99	2616.0
2010-01-05 20:00:00	ES	Futures	1100.75	1101.23	1099.29	1099.53	6217.0
2010-01-05 21:00:00	ES	Futures	1099.29	1099.53	1098.56	1099.29	4525.0
2010-01-05 22:00:00	ES	Futures	1099.53	1100.26	1099.04	1100.02	2921.0
2010-01-05 23:00:00	ES	Futures	1099.77	1100.5	1099.04	1099.53	4108.0
2010-01-05 00:00:00	NQ	Futures	2153.93	2154.5	2153.07	2153.93	411.0
2010-01-05 01:00:00	NQ	Futures	2153.93	2155.36	2153.93	2155.36	88.0
2010-01-05 02:00:00	NQ	Futures	2155.36	2156.21	2154.21	2156.21	1100.0
2010-01-05 03:00:00	NQ	Futures	2155.93	2156.21	2150.22	2151.07	2423.0
2010-01-05 04:00:00	NQ	Futures	2151.07	2153.93	2150.79	2152.5	969.0
2010-01-05 05:00:00	NQ	Futures	2152.22	2155.93	2151.93	2153.93	1152.0
2010-01-05 06:00:00	NQ	Futures	2153.64	2156.21	2151.36	2154.79	1494.0
2010-01-05 07:00:00	NQ	Futures	2154.79	2157.64	2154.79	2156.79	1720.0
2010-01-05 08:00:00	NQ	Futures	2157.07	2159.64	2152.5	2153.36	3774.0
2010-01-05 09:00:00	NQ	Futures	2153.07	2156.5	2148.22	2149.64	34270.0
2010-01-05 10:00:00	NQ	Futures	2149.36	2159.07	2147.93	2157.64	38600.0
2010-01-05 11:00:00	NQ	Futures	2157.64	2158.21	2151.36	2153.07	21664.0
2010-01-05 12:00:00	NQ	Futures	2153.07	2155.36	2150.22	2152.5	14489.0
2010-01-05 13:00:00	NQ	Futures	2152.5	2153.07	2148.5	2149.36	17226.0
2010-01-05 14:00:00	NQ	Futures	2149.36	2152.22	2143.36	2151.64	24711.0
2010-01-05 15:00:00	NQ	Futures	2151.93	2155.93	2151.07	2155.07	29831.0
2010-01-05 16:00:00	NQ	Futures	2155.07	2157.64	2152.79	2153.07	11616.0
2010-01-05 17:00:00	NQ	Futures	2153.07	2153.64	2153.07	2153.36	35.0
2010-01-05 18:00:00	NQ	Futures	2153.07	2153.36	2152.22	2152.5	94.0
2010-01-05 19:00:00	NQ	Futures	2152.79	2152.79	2151.36	2152.79	254.0
2010-01-05 20:00:00	NQ	Futures	2152.79	2153.07	2149.64	2150.22	276.0
2010-01-05 21:00:00	NQ	Futures	2149.93	2150.79	2147.65	2150.79	362.0
2010-01-05 22:00:00	NQ	Futures	2150.5	2152.79	2150.22	2151.64	280.0
2010-01-05 23:00:00	NQ	Futures	2151.93	2152.5	2149.93	2150.5	150.0
2010-01-05 00:00:00	YM	Futures	9840.1	9841.9	9836.3	9841.0	169.0
2010-01-05 01:00:00	YM	Futures	9840.1	9847.5	9840.1	9847.5	74.0

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

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