PREVIEW / futures_1hour / 2010-09-16

all futures 1-hour files

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

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-16 00:00:00	ES	Futures	1102.5	1102.5	1100.53	1101.51	4152.0
2010-09-16 01:00:00	ES	Futures	1101.51	1101.76	1099.54	1099.79	6918.0
2010-09-16 02:00:00	ES	Futures	1100.04	1102.75	1098.8	1102.25	14405.0
2010-09-16 03:00:00	ES	Futures	1102.5	1104.47	1101.51	1102.25	26864.0
2010-09-16 04:00:00	ES	Futures	1102.25	1102.99	1100.04	1101.51	17566.0
2010-09-16 05:00:00	ES	Futures	1101.76	1103.49	1101.02	1102.99	12015.0
2010-09-16 06:00:00	ES	Futures	1103.24	1103.98	1102.01	1102.25	13138.0
2010-09-16 07:00:00	ES	Futures	1102.25	1102.5	1101.02	1101.76	19256.0
2010-09-16 08:00:00	ES	Futures	1101.76	1102.99	1098.31	1100.04	94288.0
2010-09-16 09:00:00	ES	Futures	1100.04	1102.5	1097.82	1100.28	213099.0
2010-09-16 10:00:00	ES	Futures	1100.04	1102.75	1097.08	1100.77	376881.0
2010-09-16 11:00:00	ES	Futures	1101.02	1102.01	1098.56	1099.3	142442.0
2010-09-16 12:00:00	ES	Futures	1099.3	1101.76	1097.82	1101.51	108085.0
2010-09-16 13:00:00	ES	Futures	1101.51	1101.76	1098.56	1099.79	101270.0
2010-09-16 14:00:00	ES	Futures	1099.54	1102.75	1099.54	1101.76	113841.0
2010-09-16 15:00:00	ES	Futures	1101.76	1104.72	1101.27	1104.47	224529.0
2010-09-16 16:00:00	ES	Futures	1104.47	1108.66	1104.23	1107.68	122878.0
2010-09-16 17:00:00	ES	Futures	1107.43	1107.68	1106.44	1106.94	2442.0
2010-09-16 18:00:00	ES	Futures	1107.18	1108.66	1106.94	1108.17	3672.0
2010-09-16 19:00:00	ES	Futures	1108.17	1108.91	1107.92	1108.66	2360.0
2010-09-16 20:00:00	ES	Futures	1108.42	1109.89	1108.42	1108.91	6879.0
2010-09-16 21:00:00	ES	Futures	1108.66	1109.4	1108.17	1108.91	3682.0
2010-09-16 22:00:00	ES	Futures	1108.91	1110.88	1108.17	1109.89	7155.0
2010-09-16 23:00:00	ES	Futures	1110.14	1112.11	1109.89	1111.62	7462.0
2010-09-16 00:00:00	NQ	Futures	2220.63	2220.63	2217.47	2219.76	334.0
2010-09-16 01:00:00	NQ	Futures	2219.76	2220.05	2216.32	2216.61	470.0
2010-09-16 02:00:00	NQ	Futures	2216.32	2221.49	2214.89	2220.91	1602.0
2010-09-16 03:00:00	NQ	Futures	2220.91	2224.07	2218.62	2220.63	1577.0
2010-09-16 04:00:00	NQ	Futures	2220.63	2221.77	2216.9	2219.76	1867.0
2010-09-16 05:00:00	NQ	Futures	2220.34	2222.92	2218.62	2221.2	1044.0
2010-09-16 06:00:00	NQ	Futures	2221.49	2223.49	2220.05	2221.49	1020.0
2010-09-16 07:00:00	NQ	Futures	2221.49	2222.06	2218.9	2220.63	932.0
2010-09-16 08:00:00	NQ	Futures	2220.63	2223.78	2215.17	2218.62	9455.0
2010-09-16 09:00:00	NQ	Futures	2218.62	2224.07	2214.6	2220.34	35614.0
2010-09-16 10:00:00	NQ	Futures	2220.34	2224.36	2214.31	2221.49	55204.0
2010-09-16 11:00:00	NQ	Futures	2221.49	2223.78	2216.61	2217.76	32487.0
2010-09-16 12:00:00	NQ	Futures	2218.04	2223.49	2214.6	2222.35	26026.0
2010-09-16 13:00:00	NQ	Futures	2222.06	2222.63	2216.03	2218.62	26010.0
2010-09-16 14:00:00	NQ	Futures	2218.62	2227.8	2218.04	2226.36	31756.0
2010-09-16 15:00:00	NQ	Futures	2226.36	2234.68	2224.93	2233.25	47970.0
2010-09-16 16:00:00	NQ	Futures	2233.25	2244.44	2232.39	2242.72	17345.0
2010-09-16 17:00:00	NQ	Futures	2242.14	2243.0	2241.28	2241.28	286.0
2010-09-16 18:00:00	NQ	Futures	2241.0	2243.58	2241.0	2243.29	311.0
2010-09-16 19:00:00	NQ	Futures	2243.29	2243.86	2242.43	2243.29	181.0
2010-09-16 20:00:00	NQ	Futures	2243.0	2245.87	2243.0	2245.01	528.0
2010-09-16 21:00:00	NQ	Futures	2245.01	2246.73	2244.15	2245.59	348.0
2010-09-16 22:00:00	NQ	Futures	2245.3	2249.03	2243.86	2247.31	915.0
2010-09-16 23:00:00	NQ	Futures	2247.59	2251.32	2247.59	2250.75	524.0
2010-09-16 00:00:00	YM	Futures	9987.6	9987.6	9975.3	9982.9	240.0
2010-09-16 01:00:00	YM	Futures	9982.9	9982.9	9967.6	9969.5	369.0

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

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