PREVIEW / futures_1hour / 2010-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-01-14.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-14 00:00:00	ES	Futures	1113.64	1113.88	1113.15	1113.4	1236.0
2010-01-14 01:00:00	ES	Futures	1113.4	1113.64	1112.67	1113.4	1786.0
2010-01-14 02:00:00	ES	Futures	1113.4	1113.64	1112.18	1113.15	7592.0
2010-01-14 03:00:00	ES	Futures	1113.15	1113.4	1110.72	1111.69	23724.0
2010-01-14 04:00:00	ES	Futures	1111.69	1112.18	1110.48	1111.21	14167.0
2010-01-14 05:00:00	ES	Futures	1111.21	1111.94	1110.72	1111.69	11439.0
2010-01-14 06:00:00	ES	Futures	1111.69	1112.42	1109.75	1110.72	16784.0
2010-01-14 07:00:00	ES	Futures	1110.72	1111.45	1108.77	1110.96	21414.0
2010-01-14 08:00:00	ES	Futures	1110.96	1112.91	1107.56	1108.29	89137.0
2010-01-14 09:00:00	ES	Futures	1108.29	1111.94	1108.04	1110.72	156586.0
2010-01-14 10:00:00	ES	Futures	1110.96	1114.86	1110.48	1110.48	261493.0
2010-01-14 11:00:00	ES	Futures	1110.48	1112.67	1109.26	1111.21	147608.0
2010-01-14 12:00:00	ES	Futures	1110.96	1113.15	1110.96	1112.42	79794.0
2010-01-14 13:00:00	ES	Futures	1112.42	1114.13	1111.69	1113.15	76363.0
2010-01-14 14:00:00	ES	Futures	1113.15	1114.86	1112.91	1114.37	103782.0
2010-01-14 15:00:00	ES	Futures	1114.13	1116.07	1113.4	1114.13	239006.0
2010-01-14 16:00:00	ES	Futures	1113.88	1116.31	1113.15	1115.83	89955.0
2010-01-14 17:00:00	ES	Futures	1115.58	1116.07	1115.58	1115.83	2185.0
2010-01-14 18:00:00	ES	Futures	1115.58	1115.58	1113.64	1114.13	5060.0
2010-01-14 19:00:00	ES	Futures	1114.13	1115.1	1113.88	1114.61	2522.0
2010-01-14 20:00:00	ES	Futures	1114.86	1114.86	1111.69	1112.18	6861.0
2010-01-14 21:00:00	ES	Futures	1112.18	1112.67	1111.45	1112.18	4781.0
2010-01-14 22:00:00	ES	Futures	1112.18	1113.4	1112.18	1112.67	1798.0
2010-01-14 23:00:00	ES	Futures	1112.67	1112.67	1110.96	1111.45	5594.0
2010-01-14 00:00:00	NQ	Futures	2155.07	2155.64	2154.5	2154.5	156.0
2010-01-14 01:00:00	NQ	Futures	2154.5	2155.36	2153.64	2154.79	119.0
2010-01-14 02:00:00	NQ	Futures	2154.5	2154.5	2152.22	2153.93	549.0
2010-01-14 03:00:00	NQ	Futures	2154.21	2154.21	2147.93	2149.64	3006.0
2010-01-14 04:00:00	NQ	Futures	2149.93	2151.36	2147.93	2149.64	1207.0
2010-01-14 05:00:00	NQ	Futures	2149.64	2150.79	2148.22	2150.5	844.0
2010-01-14 06:00:00	NQ	Futures	2150.5	2151.93	2146.5	2148.79	1341.0
2010-01-14 07:00:00	NQ	Futures	2149.07	2150.5	2145.65	2149.93	1474.0
2010-01-14 08:00:00	NQ	Futures	2149.93	2153.36	2143.36	2144.22	6702.0
2010-01-14 09:00:00	NQ	Futures	2143.93	2154.5	2143.93	2150.79	29924.0
2010-01-14 10:00:00	NQ	Futures	2150.79	2159.07	2147.93	2148.5	39540.0
2010-01-14 11:00:00	NQ	Futures	2148.22	2153.36	2145.93	2149.36	22857.0
2010-01-14 12:00:00	NQ	Futures	2149.07	2155.36	2149.07	2153.07	18294.0
2010-01-14 13:00:00	NQ	Futures	2153.07	2154.79	2150.5	2152.79	17986.0
2010-01-14 14:00:00	NQ	Futures	2152.79	2157.07	2152.5	2156.21	16295.0
2010-01-14 15:00:00	NQ	Futures	2155.93	2159.64	2152.22	2153.07	34743.0
2010-01-14 16:00:00	NQ	Futures	2153.07	2163.93	2152.5	2161.07	9411.0
2010-01-14 17:00:00	NQ	Futures	2161.07	2162.78	2160.78	2161.93	312.0
2010-01-14 18:00:00	NQ	Futures	2161.07	2161.07	2145.65	2153.93	1440.0
2010-01-14 19:00:00	NQ	Futures	2153.93	2156.79	2153.93	2156.21	359.0
2010-01-14 20:00:00	NQ	Futures	2156.21	2156.21	2149.93	2151.36	568.0
2010-01-14 21:00:00	NQ	Futures	2151.36	2152.79	2150.22	2151.36	261.0
2010-01-14 22:00:00	NQ	Futures	2151.36	2154.21	2151.36	2152.22	217.0
2010-01-14 23:00:00	NQ	Futures	2152.22	2152.22	2149.36	2150.22	363.0
2010-01-14 00:00:00	YM	Futures	9965.5	9967.3	9963.6	9966.4	82.0
2010-01-14 01:00:00	YM	Futures	9966.4	9966.4	9960.8	9963.6	95.0

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

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