PREVIEW / futures_1hour / 2009-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-04-16.parquet
  size:    42 KB
  rows:    1,254

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-04-16 00:00:00	ES	Futures	812.84	813.8	809.48	810.2	5010.0
2009-04-16 01:00:00	ES	Futures	810.2	811.64	809.72	810.44	3868.0
2009-04-16 02:00:00	ES	Futures	810.44	813.32	809.72	810.68	7266.0
2009-04-16 03:00:00	ES	Futures	810.44	811.16	806.13	806.37	20534.0
2009-04-16 04:00:00	ES	Futures	806.13	809.72	805.41	809.72	13369.0
2009-04-16 05:00:00	ES	Futures	809.72	811.16	808.28	808.76	12422.0
2009-04-16 06:00:00	ES	Futures	808.52	816.67	807.57	809.24	44972.0
2009-04-16 07:00:00	ES	Futures	809.24	811.4	807.57	811.16	25802.0
2009-04-16 08:00:00	ES	Futures	811.16	819.55	809.72	818.83	82984.0
2009-04-16 09:00:00	ES	Futures	818.83	819.55	811.16	814.52	278217.0
2009-04-16 10:00:00	ES	Futures	814.75	815.95	808.28	810.2	388647.0
2009-04-16 11:00:00	ES	Futures	810.2	816.19	809.48	815.23	227298.0
2009-04-16 12:00:00	ES	Futures	815.23	819.07	814.04	817.39	155870.0
2009-04-16 13:00:00	ES	Futures	817.63	819.31	813.8	816.67	181929.0
2009-04-16 14:00:00	ES	Futures	816.67	827.46	816.43	826.5	404948.0
2009-04-16 15:00:00	ES	Futures	826.5	831.05	824.58	825.06	531394.0
2009-04-16 16:00:00	ES	Futures	825.3	827.46	822.66	822.66	153200.0
2009-04-16 17:00:00	ES	Futures	822.9	823.14	820.99	822.18	6108.0
2009-04-16 18:00:00	ES	Futures	822.42	823.86	822.18	823.86	2680.0
2009-04-16 19:00:00	ES	Futures	823.86	823.86	822.9	823.62	1427.0
2009-04-16 20:00:00	ES	Futures	823.38	824.82	821.7	822.42	3239.0
2009-04-16 21:00:00	ES	Futures	822.42	824.34	821.7	823.14	2999.0
2009-04-16 22:00:00	ES	Futures	823.14	823.38	821.7	822.18	2198.0
2009-04-16 23:00:00	ES	Futures	822.18	822.9	821.7	822.42	2024.0
2009-04-16 00:00:00	NQ	Futures	1498.27	1501.11	1492.87	1493.72	216.0
2009-04-16 01:00:00	NQ	Futures	1494.58	1497.13	1492.59	1494.58	223.0
2009-04-16 02:00:00	NQ	Futures	1495.14	1499.69	1492.59	1494.86	502.0
2009-04-16 03:00:00	NQ	Futures	1494.86	1496.0	1487.19	1487.47	1482.0
2009-04-16 04:00:00	NQ	Futures	1487.47	1493.72	1485.77	1493.72	824.0
2009-04-16 05:00:00	NQ	Futures	1493.72	1495.71	1490.31	1491.73	770.0
2009-04-16 06:00:00	NQ	Futures	1491.73	1504.8	1490.03	1494.29	3631.0
2009-04-16 07:00:00	NQ	Futures	1494.01	1501.11	1492.3	1500.26	3006.0
2009-04-16 08:00:00	NQ	Futures	1499.97	1520.72	1497.99	1518.44	14690.0
2009-04-16 09:00:00	NQ	Futures	1518.44	1519.58	1505.94	1513.61	42134.0
2009-04-16 10:00:00	NQ	Futures	1513.9	1517.59	1501.11	1504.8	53095.0
2009-04-16 11:00:00	NQ	Futures	1504.52	1515.6	1503.95	1513.61	24318.0
2009-04-16 12:00:00	NQ	Futures	1513.61	1522.42	1512.19	1519.3	25843.0
2009-04-16 13:00:00	NQ	Futures	1519.3	1522.14	1514.47	1519.58	25564.0
2009-04-16 14:00:00	NQ	Futures	1519.3	1540.61	1519.3	1537.2	58715.0
2009-04-16 15:00:00	NQ	Futures	1536.91	1543.73	1532.93	1534.36	70490.0
2009-04-16 16:00:00	NQ	Futures	1534.36	1538.9	1524.98	1526.12	29338.0
2009-04-16 17:00:00	NQ	Futures	1525.55	1525.83	1520.72	1524.98	1224.0
2009-04-16 18:00:00	NQ	Futures	1526.12	1528.39	1525.26	1528.1	277.0
2009-04-16 19:00:00	NQ	Futures	1527.82	1529.52	1527.82	1528.1	158.0
2009-04-16 20:00:00	NQ	Futures	1528.39	1530.09	1522.42	1522.99	495.0
2009-04-16 21:00:00	NQ	Futures	1523.56	1526.68	1522.71	1525.26	217.0
2009-04-16 22:00:00	NQ	Futures	1525.26	1525.26	1522.99	1523.84	99.0
2009-04-16 23:00:00	NQ	Futures	1523.56	1524.98	1522.99	1523.84	77.0
2009-04-16 00:00:00	YM	Futures	7329.5	7338.7	7304.7	7306.6	390.0
2009-04-16 01:00:00	YM	Futures	7314.8	7320.3	7307.5	7310.2	208.0

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

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