PREVIEW / futures_1hour / 2009-03-03

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-03-03.parquet
  size:    43 KB
  rows:    1,256

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
2009-03-03 00:00:00	ES	Futures	677.64	678.59	675.74	676.45	6209.0
2009-03-03 01:00:00	ES	Futures	676.45	677.4	674.79	676.69	7630.0
2009-03-03 02:00:00	ES	Futures	676.45	677.88	674.08	676.93	12755.0
2009-03-03 03:00:00	ES	Futures	676.93	678.59	675.74	677.64	25250.0
2009-03-03 04:00:00	ES	Futures	677.4	678.35	670.76	671.47	23198.0
2009-03-03 05:00:00	ES	Futures	671.23	672.89	669.34	671.71	21112.0
2009-03-03 06:00:00	ES	Futures	671.71	673.13	667.2	669.81	19980.0
2009-03-03 07:00:00	ES	Futures	669.81	674.79	669.81	671.23	34447.0
2009-03-03 08:00:00	ES	Futures	671.23	677.88	670.52	675.74	78748.0
2009-03-03 09:00:00	ES	Futures	675.98	677.4	668.63	670.76	290507.0
2009-03-03 10:00:00	ES	Futures	670.76	672.89	664.59	665.54	451445.0
2009-03-03 11:00:00	ES	Futures	665.54	667.2	655.82	657.0	430988.0
2009-03-03 12:00:00	ES	Futures	657.0	666.97	656.77	661.27	297104.0
2009-03-03 13:00:00	ES	Futures	661.27	664.59	657.0	662.93	285157.0
2009-03-03 14:00:00	ES	Futures	662.93	673.13	662.46	671.47	445990.0
2009-03-03 15:00:00	ES	Futures	671.47	671.47	657.71	659.61	488313.0
2009-03-03 16:00:00	ES	Futures	659.61	660.09	646.57	650.6	153639.0
2009-03-03 17:00:00	ES	Futures	650.6	651.31	649.65	650.6	1952.0
2009-03-03 18:00:00	ES	Futures	650.84	654.87	650.36	654.39	5248.0
2009-03-03 19:00:00	ES	Futures	654.39	655.58	652.26	653.21	6071.0
2009-03-03 20:00:00	ES	Futures	653.21	656.05	651.31	655.82	5028.0
2009-03-03 21:00:00	ES	Futures	655.82	657.48	654.63	657.0	5311.0
2009-03-03 22:00:00	ES	Futures	657.0	660.32	656.53	659.38	8106.0
2009-03-03 23:00:00	ES	Futures	659.61	660.56	658.43	659.61	3744.0
2009-03-03 00:00:00	NQ	Futures	1238.24	1238.52	1234.29	1236.54	308.0
2009-03-03 01:00:00	NQ	Futures	1235.98	1237.39	1234.29	1236.83	115.0
2009-03-03 02:00:00	NQ	Futures	1236.83	1237.39	1231.18	1235.98	552.0
2009-03-03 03:00:00	NQ	Futures	1235.7	1238.52	1234.57	1237.11	1795.0
2009-03-03 04:00:00	NQ	Futures	1236.83	1238.52	1228.07	1229.2	1919.0
2009-03-03 05:00:00	NQ	Futures	1228.92	1230.9	1226.94	1228.64	1631.0
2009-03-03 06:00:00	NQ	Futures	1228.36	1231.18	1222.99	1228.92	1042.0
2009-03-03 07:00:00	NQ	Futures	1228.64	1235.98	1228.64	1230.61	2406.0
2009-03-03 08:00:00	NQ	Futures	1230.61	1238.52	1229.77	1237.11	7086.0
2009-03-03 09:00:00	NQ	Futures	1237.11	1237.96	1226.38	1228.92	39489.0
2009-03-03 10:00:00	NQ	Futures	1228.64	1233.16	1221.01	1223.27	53899.0
2009-03-03 11:00:00	NQ	Futures	1222.99	1226.1	1210.57	1213.95	47445.0
2009-03-03 12:00:00	NQ	Futures	1214.24	1230.61	1213.39	1220.45	37027.0
2009-03-03 13:00:00	NQ	Futures	1221.01	1229.49	1216.5	1227.51	35559.0
2009-03-03 14:00:00	NQ	Futures	1227.51	1245.02	1226.1	1239.93	61853.0
2009-03-03 15:00:00	NQ	Futures	1239.93	1239.93	1220.17	1220.17	57842.0
2009-03-03 16:00:00	NQ	Futures	1220.73	1221.01	1199.55	1205.77	18139.0
2009-03-03 17:00:00	NQ	Futures	1205.77	1206.33	1202.38	1204.92	387.0
2009-03-03 18:00:00	NQ	Futures	1204.07	1210.28	1204.07	1209.44	743.0
2009-03-03 19:00:00	NQ	Futures	1209.44	1211.7	1206.05	1208.02	495.0
2009-03-03 20:00:00	NQ	Futures	1208.02	1212.54	1205.48	1212.26	158.0
2009-03-03 21:00:00	NQ	Futures	1212.26	1214.8	1210.28	1213.67	263.0
2009-03-03 22:00:00	NQ	Futures	1214.24	1219.04	1213.11	1218.47	228.0
2009-03-03 23:00:00	NQ	Futures	1217.91	1219.6	1216.78	1218.19	168.0
2009-03-03 00:00:00	YM	Futures	6258.6	6266.8	6242.2	6248.6	321.0
2009-03-03 01:00:00	YM	Futures	6246.8	6253.2	6236.8	6248.6	256.0

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

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