PREVIEW / futures_1hour / 2008-01-24

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-24.parquet
  size:    32 KB
  rows:    792

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
2008-01-24 00:00:00	ES	Futures	1257.41	1257.41	1252.98	1253.91	2510.0
2008-01-24 01:00:00	ES	Futures	1253.68	1256.94	1250.65	1256.25	4020.0
2008-01-24 02:00:00	ES	Futures	1256.48	1258.81	1249.72	1249.95	25059.0
2008-01-24 03:00:00	ES	Futures	1249.72	1255.08	1245.52	1252.28	44531.0
2008-01-24 04:00:00	ES	Futures	1252.28	1255.08	1243.66	1245.05	34900.0
2008-01-24 05:00:00	ES	Futures	1245.29	1254.15	1243.42	1253.21	23632.0
2008-01-24 06:00:00	ES	Futures	1253.21	1262.77	1252.75	1259.04	45835.0
2008-01-24 07:00:00	ES	Futures	1259.28	1259.74	1253.45	1254.15	44079.0
2008-01-24 08:00:00	ES	Futures	1253.91	1258.34	1249.95	1257.41	63306.0
2008-01-24 09:00:00	ES	Futures	1257.18	1261.61	1250.88	1256.71	269833.0
2008-01-24 10:00:00	ES	Futures	1256.48	1263.71	1245.29	1251.58	508035.0
2008-01-24 11:00:00	ES	Futures	1251.58	1261.14	1248.09	1256.48	278605.0
2008-01-24 12:00:00	ES	Futures	1256.48	1258.81	1247.85	1256.48	175461.0
2008-01-24 13:00:00	ES	Futures	1256.48	1260.68	1249.25	1257.64	199056.0
2008-01-24 14:00:00	ES	Futures	1257.41	1265.8	1252.05	1255.31	276370.0
2008-01-24 15:00:00	ES	Futures	1255.31	1262.77	1253.68	1261.61	271723.0
2008-01-24 16:00:00	ES	Futures	1261.61	1268.84	1259.74	1268.6	98129.0
2008-01-24 17:00:00	ES	Futures	1268.37	1270.47	1267.44	1269.07	12065.0
2008-01-24 18:00:00	ES	Futures	1268.37	1269.07	1266.97	1267.9	4825.0
2008-01-24 19:00:00	ES	Futures	1267.9	1267.9	1265.57	1266.74	3207.0
2008-01-24 20:00:00	ES	Futures	1266.5	1268.6	1266.04	1267.44	2526.0
2008-01-24 21:00:00	ES	Futures	1267.2	1267.2	1266.5	1266.74	1604.0
2008-01-24 22:00:00	ES	Futures	1266.74	1266.97	1264.64	1265.57	2212.0
2008-01-24 23:00:00	ES	Futures	1265.34	1265.57	1263.24	1263.94	3915.0
2008-01-24 00:00:00	NQ	Futures	2063.83	2065.81	2060.99	2062.41	482.0
2008-01-24 01:00:00	NQ	Futures	2062.41	2062.98	2057.02	2061.84	480.0
2008-01-24 02:00:00	NQ	Futures	2061.84	2068.08	2053.33	2053.33	1713.0
2008-01-24 03:00:00	NQ	Futures	2053.33	2064.39	2047.65	2056.45	2040.0
2008-01-24 04:00:00	NQ	Futures	2056.45	2061.27	2045.09	2048.22	2075.0
2008-01-24 05:00:00	NQ	Futures	2048.78	2060.42	2045.66	2058.15	1326.0
2008-01-24 06:00:00	NQ	Futures	2058.15	2075.18	2058.15	2066.95	3849.0
2008-01-24 07:00:00	NQ	Futures	2066.1	2067.23	2058.72	2059.57	2928.0
2008-01-24 08:00:00	NQ	Futures	2059.57	2065.25	2046.23	2057.58	7309.0
2008-01-24 09:00:00	NQ	Futures	2057.58	2080.29	2046.23	2072.34	81332.0
2008-01-24 10:00:00	NQ	Futures	2072.34	2082.28	2041.97	2059.0	117248.0
2008-01-24 11:00:00	NQ	Futures	2059.29	2071.49	2049.35	2063.83	55932.0
2008-01-24 12:00:00	NQ	Futures	2063.83	2068.08	2047.65	2059.0	38454.0
2008-01-24 13:00:00	NQ	Futures	2059.29	2062.98	2047.93	2057.87	33207.0
2008-01-24 14:00:00	NQ	Futures	2057.87	2077.17	2055.03	2064.68	58015.0
2008-01-24 15:00:00	NQ	Futures	2063.83	2082.28	2059.57	2081.71	63297.0
2008-01-24 16:00:00	NQ	Futures	2081.71	2108.11	2079.72	2108.11	19841.0
2008-01-24 17:00:00	NQ	Futures	2108.11	2108.67	2102.15	2103.85	1697.0
2008-01-24 18:00:00	NQ	Futures	2103.0	2104.42	2101.01	2103.57	540.0
2008-01-24 19:00:00	NQ	Futures	2103.57	2103.85	2101.86	2103.57	235.0
2008-01-24 20:00:00	NQ	Futures	2103.28	2105.84	2102.71	2104.42	316.0
2008-01-24 21:00:00	NQ	Futures	2104.13	2105.55	2102.71	2104.7	115.0
2008-01-24 22:00:00	NQ	Futures	2104.98	2104.98	2102.43	2103.0	277.0
2008-01-24 23:00:00	NQ	Futures	2103.0	2103.28	2100.44	2101.58	96.0
2008-01-24 00:00:00	YM	Futures	11205.4	11205.4	11160.9	11175.4	201.0
2008-01-24 01:00:00	YM	Futures	11169.1	11195.4	11149.1	11190.9	255.0

> showing 50 of 792 rows — these rows as CSV

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