PREVIEW / futures_1hour / 2010-01-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-19.parquet
  size:    47 KB
  rows:    1,419

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-19 00:00:00	ES	Futures	1104.39	1104.64	1103.91	1104.39	2547.0
2010-01-19 01:00:00	ES	Futures	1104.64	1105.37	1103.91	1104.88	2584.0
2010-01-19 02:00:00	ES	Futures	1104.88	1105.85	1104.39	1105.61	5331.0
2010-01-19 03:00:00	ES	Futures	1105.61	1105.61	1102.45	1102.94	22795.0
2010-01-19 04:00:00	ES	Futures	1102.69	1103.18	1099.53	1100.75	29199.0
2010-01-19 05:00:00	ES	Futures	1100.75	1101.96	1099.77	1100.26	16998.0
2010-01-19 06:00:00	ES	Futures	1100.26	1100.99	1098.56	1099.77	17064.0
2010-01-19 07:00:00	ES	Futures	1100.02	1100.5	1098.56	1098.8	17005.0
2010-01-19 08:00:00	ES	Futures	1098.8	1102.21	1095.88	1100.26	98245.0
2010-01-19 09:00:00	ES	Futures	1100.26	1108.04	1100.02	1106.83	276461.0
2010-01-19 10:00:00	ES	Futures	1107.07	1111.94	1106.83	1110.96	321609.0
2010-01-19 11:00:00	ES	Futures	1110.96	1110.96	1109.5	1110.23	174197.0
2010-01-19 12:00:00	ES	Futures	1110.23	1114.13	1109.99	1113.15	189637.0
2010-01-19 13:00:00	ES	Futures	1113.15	1113.64	1112.18	1113.4	98071.0
2010-01-19 14:00:00	ES	Futures	1113.4	1114.13	1112.91	1113.4	94954.0
2010-01-19 15:00:00	ES	Futures	1113.15	1116.07	1112.18	1115.34	266811.0
2010-01-19 16:00:00	ES	Futures	1115.34	1115.58	1112.91	1113.64	158937.0
2010-01-19 17:00:00	ES	Futures	1113.4	1114.13	1113.15	1113.64	1898.0
2010-01-19 18:00:00	ES	Futures	1113.64	1114.13	1113.15	1113.64	4722.0
2010-01-19 19:00:00	ES	Futures	1113.4	1115.58	1113.4	1115.34	3633.0
2010-01-19 20:00:00	ES	Futures	1115.58	1115.58	1112.67	1112.91	8513.0
2010-01-19 21:00:00	ES	Futures	1113.15	1114.61	1111.94	1114.13	11515.0
2010-01-19 22:00:00	ES	Futures	1114.37	1114.61	1113.64	1114.13	3846.0
2010-01-19 23:00:00	ES	Futures	1114.13	1114.61	1112.67	1112.91	3392.0
2010-01-19 00:00:00	NQ	Futures	2137.93	2138.51	2137.08	2138.51	211.0
2010-01-19 01:00:00	NQ	Futures	2138.22	2139.08	2137.08	2138.22	380.0
2010-01-19 02:00:00	NQ	Futures	2137.93	2138.79	2137.36	2138.51	837.0
2010-01-19 03:00:00	NQ	Futures	2138.51	2138.51	2133.36	2133.94	2710.0
2010-01-19 04:00:00	NQ	Futures	2134.22	2135.65	2128.22	2130.79	2403.0
2010-01-19 05:00:00	NQ	Futures	2130.51	2132.79	2129.08	2129.08	1534.0
2010-01-19 06:00:00	NQ	Futures	2128.79	2129.94	2125.37	2127.65	2306.0
2010-01-19 07:00:00	NQ	Futures	2127.94	2129.08	2125.94	2126.51	1275.0
2010-01-19 08:00:00	NQ	Futures	2126.51	2135.36	2122.22	2130.51	7882.0
2010-01-19 09:00:00	NQ	Futures	2130.22	2150.22	2130.22	2147.07	55811.0
2010-01-19 10:00:00	NQ	Futures	2147.07	2159.07	2146.79	2157.07	68604.0
2010-01-19 11:00:00	NQ	Futures	2156.79	2158.21	2153.64	2155.07	36283.0
2010-01-19 12:00:00	NQ	Futures	2154.79	2164.5	2154.79	2161.93	35344.0
2010-01-19 13:00:00	NQ	Futures	2161.93	2163.36	2159.93	2161.64	19731.0
2010-01-19 14:00:00	NQ	Futures	2161.93	2163.64	2161.07	2162.5	14921.0
2010-01-19 15:00:00	NQ	Futures	2162.5	2165.93	2159.36	2162.5	41467.0
2010-01-19 16:00:00	NQ	Futures	2162.78	2163.36	2155.07	2156.5	20275.0
2010-01-19 17:00:00	NQ	Futures	2156.5	2158.21	2155.93	2157.36	443.0
2010-01-19 18:00:00	NQ	Futures	2157.36	2158.5	2156.79	2157.64	297.0
2010-01-19 19:00:00	NQ	Futures	2157.36	2161.93	2157.36	2161.64	430.0
2010-01-19 20:00:00	NQ	Futures	2161.64	2161.64	2156.21	2156.79	675.0
2010-01-19 21:00:00	NQ	Futures	2157.07	2159.36	2155.07	2158.79	696.0
2010-01-19 22:00:00	NQ	Futures	2159.07	2159.36	2157.36	2157.93	387.0
2010-01-19 23:00:00	NQ	Futures	2157.93	2159.07	2153.64	2155.64	393.0
2010-01-19 00:00:00	YM	Futures	9901.8	9905.6	9898.1	9905.6	168.0
2010-01-19 01:00:00	YM	Futures	9905.6	9911.2	9900.9	9909.3	309.0

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

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