PREVIEW / futures_1hour / 2008-01-14

all futures 1-hour files

  file:    by_date/futures_1hour/2008/2008-01-14.parquet
  size:    28 KB
  rows:    746

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-14 00:00:00	ES	Futures	1316.17	1316.4	1313.84	1314.07	1967.0
2008-01-14 01:00:00	ES	Futures	1313.84	1314.53	1313.14	1314.53	1107.0
2008-01-14 02:00:00	ES	Futures	1314.53	1315.93	1305.44	1313.14	27544.0
2008-01-14 03:00:00	ES	Futures	1312.9	1318.03	1312.44	1317.33	15393.0
2008-01-14 04:00:00	ES	Futures	1317.33	1318.73	1314.3	1315.23	11327.0
2008-01-14 05:00:00	ES	Futures	1315.0	1318.73	1315.0	1317.57	8172.0
2008-01-14 06:00:00	ES	Futures	1317.33	1317.33	1314.3	1315.0	10911.0
2008-01-14 07:00:00	ES	Futures	1315.0	1322.93	1314.53	1321.53	36604.0
2008-01-14 08:00:00	ES	Futures	1321.53	1323.16	1320.83	1322.93	25345.0
2008-01-14 09:00:00	ES	Futures	1322.93	1324.09	1316.17	1318.27	200583.0
2008-01-14 10:00:00	ES	Futures	1318.27	1322.93	1315.93	1322.69	207857.0
2008-01-14 11:00:00	ES	Futures	1322.46	1324.79	1319.9	1319.9	158048.0
2008-01-14 12:00:00	ES	Futures	1320.13	1320.83	1316.87	1319.43	111513.0
2008-01-14 13:00:00	ES	Futures	1319.43	1324.33	1318.27	1323.39	121389.0
2008-01-14 14:00:00	ES	Futures	1323.39	1326.43	1320.13	1326.43	166347.0
2008-01-14 15:00:00	ES	Futures	1326.43	1328.52	1322.46	1326.19	235634.0
2008-01-14 16:00:00	ES	Futures	1326.19	1326.43	1324.09	1325.03	71722.0
2008-01-14 17:00:00	ES	Futures	1325.03	1325.49	1324.56	1325.26	995.0
2008-01-14 18:00:00	ES	Futures	1325.73	1326.66	1325.03	1325.26	1847.0
2008-01-14 19:00:00	ES	Futures	1325.03	1325.03	1322.93	1323.86	3275.0
2008-01-14 20:00:00	ES	Futures	1323.86	1324.33	1323.39	1323.86	1642.0
2008-01-14 21:00:00	ES	Futures	1323.86	1324.09	1322.69	1322.69	1480.0
2008-01-14 22:00:00	ES	Futures	1322.46	1322.69	1320.13	1320.36	4348.0
2008-01-14 23:00:00	ES	Futures	1320.36	1321.06	1319.66	1319.9	2646.0
2008-01-14 00:00:00	NQ	Futures	2192.98	2194.11	2190.14	2190.14	95.0
2008-01-14 01:00:00	NQ	Futures	2191.27	2191.56	2188.72	2190.42	137.0
2008-01-14 02:00:00	NQ	Futures	2191.27	2196.67	2164.02	2189.0	2226.0
2008-01-14 03:00:00	NQ	Futures	2189.0	2194.11	2188.72	2193.26	1430.0
2008-01-14 04:00:00	NQ	Futures	2193.26	2194.68	2187.87	2190.14	787.0
2008-01-14 05:00:00	NQ	Futures	2190.42	2195.25	2190.42	2194.11	543.0
2008-01-14 06:00:00	NQ	Futures	2193.26	2193.26	2185.88	2186.45	1026.0
2008-01-14 07:00:00	NQ	Futures	2186.45	2211.71	2185.88	2208.87	7639.0
2008-01-14 08:00:00	NQ	Futures	2208.59	2221.64	2208.3	2212.56	9594.0
2008-01-14 09:00:00	NQ	Futures	2212.56	2221.08	2198.09	2207.74	53047.0
2008-01-14 10:00:00	NQ	Futures	2207.45	2218.24	2201.49	2215.97	57788.0
2008-01-14 11:00:00	NQ	Futures	2216.25	2225.9	2211.14	2211.71	51350.0
2008-01-14 12:00:00	NQ	Futures	2211.71	2212.56	2203.76	2210.01	34702.0
2008-01-14 13:00:00	NQ	Futures	2210.29	2221.36	2206.88	2220.23	37487.0
2008-01-14 14:00:00	NQ	Futures	2220.23	2227.04	2213.41	2225.9	40523.0
2008-01-14 15:00:00	NQ	Futures	2225.9	2230.73	2219.37	2226.75	60635.0
2008-01-14 16:00:00	NQ	Futures	2226.19	2226.75	2219.37	2221.64	14370.0
2008-01-14 17:00:00	NQ	Futures	2222.21	2222.21	2221.36	2221.93	25.0
2008-01-14 18:00:00	NQ	Futures	2222.5	2224.48	2221.93	2222.5	190.0
2008-01-14 19:00:00	NQ	Futures	2222.5	2223.63	2218.52	2222.5	485.0
2008-01-14 20:00:00	NQ	Futures	2222.5	2224.77	2221.36	2223.35	519.0
2008-01-14 21:00:00	NQ	Futures	2223.63	2223.92	2221.36	2222.5	566.0
2008-01-14 22:00:00	NQ	Futures	2220.79	2220.79	2216.54	2217.39	197.0
2008-01-14 23:00:00	NQ	Futures	2216.82	2217.39	2215.12	2216.25	100.0
2008-01-14 00:00:00	YM	Futures	11523.4	11527.0	11503.4	11506.1	95.0
2008-01-14 01:00:00	YM	Futures	11506.1	11510.7	11500.7	11508.9	180.0

> showing 50 of 746 rows — these rows as CSV

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