PREVIEW / futures_1hour / 2009-04-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	800.62	803.25	800.62	802.53	3779.0
2009-04-23 01:00:00	ES	Futures	802.53	806.85	802.05	806.37	7650.0
2009-04-23 02:00:00	ES	Futures	806.13	809.24	806.13	807.81	12221.0
2009-04-23 03:00:00	ES	Futures	807.81	809.96	806.85	809.72	21343.0
2009-04-23 04:00:00	ES	Futures	809.72	810.92	808.52	810.44	15993.0
2009-04-23 05:00:00	ES	Futures	810.44	811.88	808.52	810.44	15047.0
2009-04-23 06:00:00	ES	Futures	810.68	811.88	807.81	809.48	17208.0
2009-04-23 07:00:00	ES	Futures	809.48	812.84	807.57	809.96	35442.0
2009-04-23 08:00:00	ES	Futures	809.72	811.88	807.33	809.72	52987.0
2009-04-23 09:00:00	ES	Futures	809.72	810.2	803.49	803.97	245108.0
2009-04-23 10:00:00	ES	Futures	803.73	807.57	798.94	800.62	390649.0
2009-04-23 11:00:00	ES	Futures	800.62	802.53	796.78	798.46	294115.0
2009-04-23 12:00:00	ES	Futures	798.22	803.97	797.74	803.49	134153.0
2009-04-23 13:00:00	ES	Futures	803.49	809.0	803.25	807.57	244391.0
2009-04-23 14:00:00	ES	Futures	807.33	811.88	803.97	808.05	308868.0
2009-04-23 15:00:00	ES	Futures	808.05	814.75	802.05	814.04	538276.0
2009-04-23 16:00:00	ES	Futures	813.8	818.59	811.16	814.99	115383.0
2009-04-23 17:00:00	ES	Futures	815.23	816.43	814.99	814.99	1948.0
2009-04-23 18:00:00	ES	Futures	815.71	816.67	814.75	814.99	2664.0
2009-04-23 19:00:00	ES	Futures	814.99	815.23	813.8	813.8	2708.0
2009-04-23 20:00:00	ES	Futures	813.56	813.56	809.24	810.92	9113.0
2009-04-23 21:00:00	ES	Futures	810.92	811.4	808.05	809.72	8553.0
2009-04-23 22:00:00	ES	Futures	809.72	810.92	809.24	809.96	3285.0
2009-04-23 23:00:00	ES	Futures	809.96	811.64	809.24	811.16	2700.0
2009-04-23 00:00:00	NQ	Futures	1511.91	1515.03	1511.91	1515.03	229.0
2009-04-23 01:00:00	NQ	Futures	1513.9	1518.44	1513.33	1517.88	455.0
2009-04-23 02:00:00	NQ	Futures	1517.31	1521.57	1516.74	1521.0	471.0
2009-04-23 03:00:00	NQ	Futures	1521.28	1522.99	1515.32	1520.43	2496.0
2009-04-23 04:00:00	NQ	Futures	1520.43	1524.13	1519.01	1522.99	1352.0
2009-04-23 05:00:00	NQ	Futures	1523.27	1528.39	1520.43	1525.83	1488.0
2009-04-23 06:00:00	NQ	Futures	1526.12	1528.39	1522.71	1524.69	1209.0
2009-04-23 07:00:00	NQ	Futures	1524.98	1530.66	1523.56	1527.54	3169.0
2009-04-23 08:00:00	NQ	Futures	1527.54	1531.23	1523.27	1529.81	9368.0
2009-04-23 09:00:00	NQ	Futures	1529.81	1530.66	1511.62	1514.18	45153.0
2009-04-23 10:00:00	NQ	Futures	1514.18	1524.98	1506.79	1508.5	55551.0
2009-04-23 11:00:00	NQ	Futures	1508.78	1511.06	1499.12	1502.53	39258.0
2009-04-23 12:00:00	NQ	Futures	1502.82	1517.31	1502.25	1515.32	25955.0
2009-04-23 13:00:00	NQ	Futures	1515.32	1523.27	1514.18	1520.72	34364.0
2009-04-23 14:00:00	NQ	Futures	1520.72	1524.98	1512.76	1517.31	40277.0
2009-04-23 15:00:00	NQ	Futures	1517.59	1530.66	1508.21	1528.96	71107.0
2009-04-23 16:00:00	NQ	Futures	1529.24	1541.17	1513.04	1530.38	22503.0
2009-04-23 17:00:00	NQ	Futures	1530.38	1534.36	1530.09	1530.09	597.0
2009-04-23 18:00:00	NQ	Futures	1531.51	1532.65	1528.96	1529.24	411.0
2009-04-23 19:00:00	NQ	Futures	1529.52	1530.09	1527.82	1528.67	476.0
2009-04-23 20:00:00	NQ	Futures	1528.1	1528.39	1521.85	1523.84	478.0
2009-04-23 21:00:00	NQ	Futures	1524.13	1525.26	1520.72	1522.71	314.0
2009-04-23 22:00:00	NQ	Futures	1522.42	1524.41	1521.0	1522.99	189.0
2009-04-23 23:00:00	NQ	Futures	1522.99	1526.12	1522.71	1524.69	129.0
2009-04-23 00:00:00	YM	Futures	7167.8	7191.7	7166.9	7182.5	264.0
2009-04-23 01:00:00	YM	Futures	7182.5	7211.9	7177.9	7211.0	538.0

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

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