PREVIEW / futures_1hour / 2010-10-06

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-06.parquet
  size:    47 KB
  rows:    1,436

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-10-06 00:00:00	ES	Futures	1140.21	1140.7	1139.72	1140.21	2585.0
2010-10-06 01:00:00	ES	Futures	1139.96	1140.7	1139.72	1139.72	2723.0
2010-10-06 02:00:00	ES	Futures	1139.72	1140.95	1139.23	1140.46	9884.0
2010-10-06 03:00:00	ES	Futures	1140.46	1141.94	1139.96	1141.2	32401.0
2010-10-06 04:00:00	ES	Futures	1141.2	1142.68	1140.46	1142.43	24113.0
2010-10-06 05:00:00	ES	Futures	1142.43	1143.66	1142.18	1143.17	21494.0
2010-10-06 06:00:00	ES	Futures	1143.17	1143.66	1140.95	1141.44	17543.0
2010-10-06 07:00:00	ES	Futures	1141.69	1143.17	1139.23	1143.17	40055.0
2010-10-06 08:00:00	ES	Futures	1142.92	1143.66	1137.01	1138.24	105101.0
2010-10-06 09:00:00	ES	Futures	1138.24	1141.94	1138.24	1140.46	239769.0
2010-10-06 10:00:00	ES	Futures	1140.46	1142.43	1137.99	1139.23	293504.0
2010-10-06 11:00:00	ES	Futures	1139.47	1141.69	1137.75	1140.21	174030.0
2010-10-06 12:00:00	ES	Futures	1140.46	1141.2	1136.76	1137.25	152248.0
2010-10-06 13:00:00	ES	Futures	1137.25	1137.5	1134.79	1137.5	159661.0
2010-10-06 14:00:00	ES	Futures	1137.5	1138.49	1135.28	1137.75	141771.0
2010-10-06 15:00:00	ES	Futures	1137.75	1139.72	1136.02	1139.23	180884.0
2010-10-06 16:00:00	ES	Futures	1139.23	1140.7	1139.23	1139.96	89015.0
2010-10-06 17:00:00	ES	Futures	1140.21	1140.46	1137.99	1138.49	3533.0
2010-10-06 18:00:00	ES	Futures	1138.49	1139.23	1138.24	1138.49	1307.0
2010-10-06 19:00:00	ES	Futures	1138.73	1139.47	1138.24	1138.73	1758.0
2010-10-06 20:00:00	ES	Futures	1138.49	1140.7	1138.49	1139.96	5642.0
2010-10-06 21:00:00	ES	Futures	1139.96	1140.46	1138.98	1139.23	3517.0
2010-10-06 22:00:00	ES	Futures	1138.98	1139.96	1138.73	1139.47	2515.0
2010-10-06 23:00:00	ES	Futures	1139.47	1139.72	1138.49	1138.73	1695.0
2010-10-06 00:00:00	NQ	Futures	2319.89	2320.75	2317.31	2318.75	646.0
2010-10-06 01:00:00	NQ	Futures	2318.75	2320.47	2318.46	2318.46	251.0
2010-10-06 02:00:00	NQ	Futures	2318.75	2319.03	2314.44	2317.02	3332.0
2010-10-06 03:00:00	NQ	Futures	2317.02	2320.47	2317.02	2319.03	2641.0
2010-10-06 04:00:00	NQ	Futures	2319.03	2322.48	2317.6	2321.9	1299.0
2010-10-06 05:00:00	NQ	Futures	2322.19	2323.34	2321.04	2322.76	1496.0
2010-10-06 06:00:00	NQ	Futures	2322.76	2323.34	2318.46	2319.61	1294.0
2010-10-06 07:00:00	NQ	Futures	2319.32	2322.19	2314.73	2322.19	3331.0
2010-10-06 08:00:00	NQ	Futures	2322.19	2323.34	2311.0	2313.01	13099.0
2010-10-06 09:00:00	NQ	Futures	2313.01	2321.04	2310.43	2313.01	50237.0
2010-10-06 10:00:00	NQ	Futures	2313.01	2319.03	2296.37	2300.96	61992.0
2010-10-06 11:00:00	NQ	Futures	2301.24	2309.28	2297.23	2303.83	32875.0
2010-10-06 12:00:00	NQ	Futures	2303.83	2307.27	2293.79	2295.22	32749.0
2010-10-06 13:00:00	NQ	Futures	2294.93	2294.93	2284.03	2293.79	43602.0
2010-10-06 14:00:00	NQ	Futures	2293.79	2297.52	2287.19	2294.93	34625.0
2010-10-06 15:00:00	NQ	Futures	2294.93	2299.81	2288.91	2299.52	36266.0
2010-10-06 16:00:00	NQ	Futures	2299.52	2302.97	2299.24	2302.39	11104.0
2010-10-06 17:00:00	NQ	Futures	2302.39	2303.25	2298.95	2299.81	355.0
2010-10-06 18:00:00	NQ	Futures	2299.81	2301.82	2299.24	2300.1	504.0
2010-10-06 19:00:00	NQ	Futures	2300.67	2302.68	2299.52	2300.1	224.0
2010-10-06 20:00:00	NQ	Futures	2299.81	2304.4	2299.81	2302.97	253.0
2010-10-06 21:00:00	NQ	Futures	2302.68	2302.68	2299.52	2299.52	291.0
2010-10-06 22:00:00	NQ	Futures	2299.24	2301.82	2299.24	2300.38	192.0
2010-10-06 23:00:00	NQ	Futures	2300.96	2301.53	2299.24	2300.1	91.0
2010-10-06 00:00:00	YM	Futures	10363.9	10366.8	10358.2	10363.9	110.0
2010-10-06 01:00:00	YM	Futures	10363.9	10367.7	10362.0	10362.0	128.0

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

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