PREVIEW / futures_1hour / 2010-09-15

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-15.parquet
  size:    46 KB
  rows:    1,409

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-09-15 00:00:00	ES	Futures	1101.02	1102.25	1100.77	1101.51	7205.0
2010-09-15 01:00:00	ES	Futures	1101.51	1101.76	1100.04	1100.77	6880.0
2010-09-15 02:00:00	ES	Futures	1100.53	1101.76	1099.79	1101.02	6413.0
2010-09-15 03:00:00	ES	Futures	1100.77	1102.01	1098.56	1101.27	22477.0
2010-09-15 04:00:00	ES	Futures	1101.27	1102.25	1099.79	1100.04	15251.0
2010-09-15 05:00:00	ES	Futures	1099.79	1100.04	1097.32	1097.82	15871.0
2010-09-15 06:00:00	ES	Futures	1097.57	1097.57	1095.85	1096.09	23026.0
2010-09-15 07:00:00	ES	Futures	1095.85	1099.05	1095.6	1097.82	24505.0
2010-09-15 08:00:00	ES	Futures	1097.82	1097.82	1093.63	1096.09	89435.0
2010-09-15 09:00:00	ES	Futures	1096.09	1097.82	1093.38	1097.82	275110.0
2010-09-15 10:00:00	ES	Futures	1097.57	1101.76	1097.32	1101.51	348436.0
2010-09-15 11:00:00	ES	Futures	1101.51	1102.75	1097.82	1101.76	193729.0
2010-09-15 12:00:00	ES	Futures	1101.76	1102.99	1100.53	1101.51	87164.0
2010-09-15 13:00:00	ES	Futures	1101.51	1103.98	1101.27	1102.75	114253.0
2010-09-15 14:00:00	ES	Futures	1102.99	1103.49	1099.54	1101.51	127435.0
2010-09-15 15:00:00	ES	Futures	1101.51	1105.7	1101.02	1104.72	251544.0
2010-09-15 16:00:00	ES	Futures	1104.72	1105.95	1104.23	1104.47	88765.0
2010-09-15 17:00:00	ES	Futures	1104.72	1105.21	1104.23	1104.96	1418.0
2010-09-15 18:00:00	ES	Futures	1104.96	1105.21	1104.23	1104.72	3327.0
2010-09-15 19:00:00	ES	Futures	1104.72	1105.21	1103.98	1104.23	2508.0
2010-09-15 20:00:00	ES	Futures	1104.23	1104.47	1102.5	1102.99	7556.0
2010-09-15 21:00:00	ES	Futures	1102.75	1103.24	1102.01	1102.75	6286.0
2010-09-15 22:00:00	ES	Futures	1102.75	1102.99	1101.51	1101.51	4625.0
2010-09-15 23:00:00	ES	Futures	1101.51	1102.75	1100.77	1102.5	5996.0
2010-09-15 00:00:00	NQ	Futures	2210.58	2212.59	2210.3	2212.31	218.0
2010-09-15 01:00:00	NQ	Futures	2212.31	2213.17	2209.15	2210.87	420.0
2010-09-15 02:00:00	NQ	Futures	2210.58	2213.17	2210.01	2211.16	341.0
2010-09-15 03:00:00	NQ	Futures	2211.44	2213.17	2207.43	2212.02	1751.0
2010-09-15 04:00:00	NQ	Futures	2212.31	2213.45	2209.15	2209.72	699.0
2010-09-15 05:00:00	NQ	Futures	2209.44	2209.72	2204.56	2205.13	922.0
2010-09-15 06:00:00	NQ	Futures	2204.85	2205.71	2201.4	2202.55	1114.0
2010-09-15 07:00:00	NQ	Futures	2202.55	2208.29	2201.69	2205.13	1540.0
2010-09-15 08:00:00	NQ	Futures	2205.13	2205.13	2196.81	2201.4	7001.0
2010-09-15 09:00:00	NQ	Futures	2201.4	2208.58	2197.96	2207.71	45276.0
2010-09-15 10:00:00	NQ	Futures	2207.71	2214.31	2205.42	2214.03	47482.0
2010-09-15 11:00:00	NQ	Futures	2214.03	2217.18	2207.71	2215.75	30832.0
2010-09-15 12:00:00	NQ	Futures	2216.03	2220.34	2216.03	2218.04	24459.0
2010-09-15 13:00:00	NQ	Futures	2218.33	2221.77	2217.18	2220.05	26179.0
2010-09-15 14:00:00	NQ	Futures	2220.05	2221.2	2214.6	2220.05	26368.0
2010-09-15 15:00:00	NQ	Futures	2220.05	2226.65	2218.33	2224.64	41545.0
2010-09-15 16:00:00	NQ	Futures	2224.36	2227.8	2222.92	2224.93	7824.0
2010-09-15 17:00:00	NQ	Futures	2225.22	2226.08	2225.22	2225.79	42.0
2010-09-15 18:00:00	NQ	Futures	2226.08	2226.36	2223.78	2224.36	346.0
2010-09-15 19:00:00	NQ	Futures	2224.36	2226.08	2224.07	2224.07	112.0
2010-09-15 20:00:00	NQ	Futures	2224.36	2224.64	2221.77	2222.06	490.0
2010-09-15 21:00:00	NQ	Futures	2222.06	2222.63	2220.34	2221.49	230.0
2010-09-15 22:00:00	NQ	Futures	2221.49	2222.06	2218.9	2219.48	319.0
2010-09-15 23:00:00	NQ	Futures	2219.19	2221.49	2218.62	2220.91	278.0
2010-09-15 00:00:00	YM	Futures	9977.2	9985.7	9973.4	9978.1	248.0
2010-09-15 01:00:00	YM	Futures	9978.1	9980.0	9968.6	9970.5	229.0

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

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