PREVIEW / futures_1hour / 2010-08-02

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-02.parquet
  size:    44 KB
  rows:    1,338

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-08-02 00:00:00	ES	Futures	1086.3	1087.03	1085.07	1085.8	3015.0
2010-08-02 01:00:00	ES	Futures	1085.8	1086.54	1084.58	1084.82	2738.0
2010-08-02 02:00:00	ES	Futures	1084.82	1086.05	1084.82	1085.07	5860.0
2010-08-02 03:00:00	ES	Futures	1085.07	1088.75	1084.33	1088.5	28769.0
2010-08-02 04:00:00	ES	Futures	1088.5	1090.96	1088.01	1089.49	26578.0
2010-08-02 05:00:00	ES	Futures	1089.49	1091.45	1089.24	1090.96	11415.0
2010-08-02 06:00:00	ES	Futures	1090.96	1091.2	1089.98	1090.22	8089.0
2010-08-02 07:00:00	ES	Futures	1090.22	1091.94	1090.22	1090.71	21883.0
2010-08-02 08:00:00	ES	Futures	1090.47	1091.69	1089.73	1090.96	36181.0
2010-08-02 09:00:00	ES	Futures	1091.2	1094.88	1089.73	1091.94	276455.0
2010-08-02 10:00:00	ES	Futures	1091.94	1099.05	1091.45	1098.32	311983.0
2010-08-02 11:00:00	ES	Futures	1098.07	1101.02	1097.09	1100.53	185596.0
2010-08-02 12:00:00	ES	Futures	1100.53	1100.53	1096.85	1098.56	115036.0
2010-08-02 13:00:00	ES	Futures	1098.32	1100.04	1097.34	1099.3	79785.0
2010-08-02 14:00:00	ES	Futures	1099.3	1102.74	1098.56	1102.0	117061.0
2010-08-02 15:00:00	ES	Futures	1102.24	1103.47	1100.77	1101.51	247134.0
2010-08-02 16:00:00	ES	Futures	1101.51	1102.0	1100.28	1100.77	105439.0
2010-08-02 17:00:00	ES	Futures	1101.02	1101.26	1100.77	1101.26	1088.0
2010-08-02 18:00:00	ES	Futures	1101.02	1101.26	1100.28	1100.77	1739.0
2010-08-02 19:00:00	ES	Futures	1100.77	1101.51	1100.77	1101.26	3143.0
2010-08-02 20:00:00	ES	Futures	1101.02	1101.51	1100.28	1101.02	3185.0
2010-08-02 21:00:00	ES	Futures	1101.02	1101.51	1098.81	1099.79	5780.0
2010-08-02 22:00:00	ES	Futures	1099.55	1099.55	1098.07	1098.56	6243.0
2010-08-02 23:00:00	ES	Futures	1098.56	1099.3	1098.32	1098.81	1858.0
2010-08-02 00:00:00	NQ	Futures	2149.82	2150.96	2147.81	2149.25	330.0
2010-08-02 01:00:00	NQ	Futures	2148.96	2150.1	2146.38	2147.53	217.0
2010-08-02 02:00:00	NQ	Futures	2146.95	2150.1	2146.95	2147.53	751.0
2010-08-02 03:00:00	NQ	Futures	2147.53	2153.83	2145.52	2153.54	2452.0
2010-08-02 04:00:00	NQ	Futures	2153.83	2158.99	2152.68	2154.98	1952.0
2010-08-02 05:00:00	NQ	Futures	2155.26	2158.7	2154.98	2158.13	800.0
2010-08-02 06:00:00	NQ	Futures	2157.84	2158.7	2155.84	2156.7	877.0
2010-08-02 07:00:00	NQ	Futures	2156.7	2159.85	2155.84	2156.12	1712.0
2010-08-02 08:00:00	NQ	Futures	2156.12	2158.7	2155.55	2156.98	5602.0
2010-08-02 09:00:00	NQ	Futures	2156.98	2162.14	2152.68	2160.13	47433.0
2010-08-02 10:00:00	NQ	Futures	2159.85	2176.18	2159.56	2173.03	54096.0
2010-08-02 11:00:00	NQ	Futures	2173.03	2177.62	2171.31	2175.61	27944.0
2010-08-02 12:00:00	NQ	Futures	2175.9	2176.47	2168.16	2171.02	18804.0
2010-08-02 13:00:00	NQ	Futures	2171.02	2174.18	2169.3	2171.88	13763.0
2010-08-02 14:00:00	NQ	Futures	2171.88	2179.91	2171.02	2177.62	19953.0
2010-08-02 15:00:00	NQ	Futures	2177.62	2179.33	2173.03	2174.18	34882.0
2010-08-02 16:00:00	NQ	Futures	2174.18	2174.75	2170.16	2171.02	10171.0
2010-08-02 17:00:00	NQ	Futures	2171.31	2171.6	2171.02	2171.02	47.0
2010-08-02 18:00:00	NQ	Futures	2170.74	2171.88	2170.45	2171.31	115.0
2010-08-02 19:00:00	NQ	Futures	2171.88	2172.46	2171.02	2172.17	125.0
2010-08-02 20:00:00	NQ	Futures	2171.88	2172.46	2170.45	2171.88	306.0
2010-08-02 21:00:00	NQ	Futures	2171.31	2172.17	2167.3	2169.88	399.0
2010-08-02 22:00:00	NQ	Futures	2169.3	2169.3	2167.3	2168.45	356.0
2010-08-02 23:00:00	NQ	Futures	2168.16	2169.02	2167.59	2168.73	168.0
2010-08-02 00:00:00	YM	Futures	9923.3	9929.0	9916.7	9923.3	175.0
2010-08-02 01:00:00	YM	Futures	9922.3	9926.1	9914.8	9914.8	222.0

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

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