PREVIEW / futures_1hour / 2008-04-21

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-04-21.parquet
  size:    41 KB
  rows:    1,186

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-04-21 00:00:00	ES	Futures	1295.31	1295.31	1293.91	1294.84	844.0
2008-04-21 01:00:00	ES	Futures	1294.84	1295.54	1292.98	1295.31	1572.0
2008-04-21 02:00:00	ES	Futures	1295.31	1297.41	1295.08	1296.94	5353.0
2008-04-21 03:00:00	ES	Futures	1296.94	1298.34	1295.08	1296.24	12717.0
2008-04-21 04:00:00	ES	Futures	1296.24	1296.94	1293.45	1293.68	10444.0
2008-04-21 05:00:00	ES	Futures	1293.91	1295.08	1292.75	1295.08	6745.0
2008-04-21 06:00:00	ES	Futures	1295.31	1295.54	1292.05	1292.05	8283.0
2008-04-21 07:00:00	ES	Futures	1292.05	1292.28	1287.86	1290.65	28398.0
2008-04-21 08:00:00	ES	Futures	1290.65	1292.05	1289.95	1290.89	19294.0
2008-04-21 09:00:00	ES	Futures	1291.12	1293.68	1288.32	1291.82	162774.0
2008-04-21 10:00:00	ES	Futures	1292.05	1292.05	1286.23	1286.69	266770.0
2008-04-21 11:00:00	ES	Futures	1286.46	1291.58	1286.0	1290.89	185798.0
2008-04-21 12:00:00	ES	Futures	1290.65	1291.58	1289.49	1290.89	90666.0
2008-04-21 13:00:00	ES	Futures	1290.89	1292.98	1288.79	1289.72	93847.0
2008-04-21 14:00:00	ES	Futures	1289.49	1292.75	1288.56	1292.05	116752.0
2008-04-21 15:00:00	ES	Futures	1292.05	1296.71	1292.05	1294.61	186943.0
2008-04-21 16:00:00	ES	Futures	1294.61	1295.31	1290.42	1291.35	56431.0
2008-04-21 17:00:00	ES	Futures	1290.89	1291.58	1289.26	1289.72	3117.0
2008-04-21 18:00:00	ES	Futures	1289.72	1290.42	1289.49	1290.42	1601.0
2008-04-21 19:00:00	ES	Futures	1290.19	1290.42	1289.26	1289.26	1434.0
2008-04-21 20:00:00	ES	Futures	1289.26	1289.72	1287.63	1288.32	2526.0
2008-04-21 21:00:00	ES	Futures	1288.56	1288.56	1287.16	1287.39	1507.0
2008-04-21 22:00:00	ES	Futures	1287.39	1287.86	1286.93	1287.63	1216.0
2008-04-21 23:00:00	ES	Futures	1287.63	1287.86	1286.69	1287.16	742.0
2008-04-21 00:00:00	NQ	Futures	2157.98	2158.55	2155.72	2156.57	104.0
2008-04-21 01:00:00	NQ	Futures	2157.42	2157.42	2153.17	2156.29	64.0
2008-04-21 02:00:00	NQ	Futures	2156.85	2160.25	2154.87	2157.13	754.0
2008-04-21 03:00:00	NQ	Futures	2157.7	2162.22	2153.46	2156.85	1088.0
2008-04-21 04:00:00	NQ	Futures	2156.85	2157.42	2152.04	2154.31	836.0
2008-04-21 05:00:00	NQ	Futures	2154.59	2156.0	2150.63	2153.46	498.0
2008-04-21 06:00:00	NQ	Futures	2153.46	2153.74	2146.95	2147.52	1267.0
2008-04-21 07:00:00	NQ	Futures	2147.23	2150.35	2141.58	2148.93	3056.0
2008-04-21 08:00:00	NQ	Futures	2149.21	2152.89	2147.23	2149.21	2249.0
2008-04-21 09:00:00	NQ	Futures	2148.65	2157.7	2146.1	2155.72	26854.0
2008-04-21 10:00:00	NQ	Futures	2155.44	2155.72	2145.54	2148.08	35700.0
2008-04-21 11:00:00	NQ	Futures	2147.8	2159.96	2146.95	2157.98	26296.0
2008-04-21 12:00:00	NQ	Futures	2157.98	2161.66	2156.57	2159.4	20362.0
2008-04-21 13:00:00	NQ	Futures	2159.4	2164.77	2154.02	2156.85	19603.0
2008-04-21 14:00:00	NQ	Futures	2156.57	2167.32	2153.46	2164.77	21998.0
2008-04-21 15:00:00	NQ	Futures	2164.77	2172.69	2164.2	2170.71	36093.0
2008-04-21 16:00:00	NQ	Futures	2170.99	2171.84	2159.96	2161.38	10448.0
2008-04-21 17:00:00	NQ	Futures	2161.66	2161.94	2157.7	2158.55	1076.0
2008-04-21 18:00:00	NQ	Futures	2158.55	2158.55	2158.27	2158.27	335.0
2008-04-21 19:00:00	NQ	Futures	2158.27	2158.55	2156.57	2156.57	199.0
2008-04-21 20:00:00	NQ	Futures	2156.57	2157.13	2154.87	2155.15	167.0
2008-04-21 21:00:00	NQ	Futures	2155.15	2155.72	2152.89	2152.89	303.0
2008-04-21 22:00:00	NQ	Futures	2153.17	2153.74	2152.89	2153.74	60.0
2008-04-21 23:00:00	NQ	Futures	2153.46	2153.74	2153.17	2153.17	18.0
2008-04-21 00:00:00	YM	Futures	11658.9	11660.7	11651.6	11655.3	124.0
2008-04-21 01:00:00	YM	Futures	11655.3	11658.9	11646.2	11658.9	78.0

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

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