PREVIEW / futures_1hour / 2010-11-19

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-19.parquet
  size:    40 KB
  rows:    1,159

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
2010-11-19 00:00:00	ES	Futures	1178.42	1178.91	1177.43	1178.17	4054.0
2010-11-19 01:00:00	ES	Futures	1178.17	1182.11	1177.92	1181.62	6847.0
2010-11-19 02:00:00	ES	Futures	1181.62	1182.85	1181.37	1181.87	8990.0
2010-11-19 03:00:00	ES	Futures	1181.87	1182.11	1178.91	1180.14	28995.0
2010-11-19 04:00:00	ES	Futures	1179.89	1180.14	1177.92	1178.66	20688.0
2010-11-19 05:00:00	ES	Futures	1178.42	1179.15	1175.95	1177.18	54381.0
2010-11-19 06:00:00	ES	Futures	1177.43	1178.66	1175.95	1177.92	34862.0
2010-11-19 07:00:00	ES	Futures	1177.92	1178.42	1173.73	1174.96	47595.0
2010-11-19 08:00:00	ES	Futures	1174.72	1177.68	1174.23	1175.95	57914.0
2010-11-19 09:00:00	ES	Futures	1175.95	1177.43	1170.77	1172.99	317993.0
2010-11-19 10:00:00	ES	Futures	1172.99	1176.94	1170.77	1175.46	301801.0
2010-11-19 11:00:00	ES	Futures	1175.46	1178.17	1174.72	1176.44	192021.0
2010-11-19 12:00:00	ES	Futures	1176.69	1178.91	1175.7	1178.42	91660.0
2010-11-19 13:00:00	ES	Futures	1178.42	1179.65	1177.68	1178.91	82623.0
2010-11-19 14:00:00	ES	Futures	1178.91	1180.63	1178.42	1179.15	87861.0
2010-11-19 15:00:00	ES	Futures	1179.4	1181.87	1177.68	1181.13	215473.0
2010-11-19 16:00:00	ES	Futures	1180.88	1183.1	1180.39	1181.13	109618.0
2010-11-19 00:00:00	NQ	Futures	2444.12	2444.12	2441.83	2442.97	772.0
2010-11-19 01:00:00	NQ	Futures	2442.97	2450.15	2442.97	2450.15	1108.0
2010-11-19 02:00:00	NQ	Futures	2450.15	2451.87	2449.29	2450.72	545.0
2010-11-19 03:00:00	NQ	Futures	2450.43	2450.72	2443.26	2445.27	2490.0
2010-11-19 04:00:00	NQ	Futures	2445.27	2445.56	2442.11	2443.55	1339.0
2010-11-19 05:00:00	NQ	Futures	2443.26	2446.7	2438.67	2444.12	4892.0
2010-11-19 06:00:00	NQ	Futures	2443.84	2445.56	2441.54	2442.97	2650.0
2010-11-19 07:00:00	NQ	Futures	2442.97	2443.55	2436.09	2438.38	3761.0
2010-11-19 08:00:00	NQ	Futures	2438.38	2443.84	2437.52	2441.25	5105.0
2010-11-19 09:00:00	NQ	Futures	2440.97	2444.98	2433.51	2437.52	48771.0
2010-11-19 10:00:00	NQ	Futures	2437.52	2446.42	2432.65	2443.26	38509.0
2010-11-19 11:00:00	NQ	Futures	2443.26	2447.28	2438.96	2444.7	22156.0
2010-11-19 12:00:00	NQ	Futures	2444.98	2449.86	2442.11	2449.86	15039.0
2010-11-19 13:00:00	NQ	Futures	2449.86	2451.87	2448.71	2451.3	11937.0
2010-11-19 14:00:00	NQ	Futures	2451.3	2454.45	2450.15	2451.01	12928.0
2010-11-19 15:00:00	NQ	Futures	2451.01	2452.44	2444.12	2447.57	31040.0
2010-11-19 16:00:00	NQ	Futures	2447.28	2452.44	2446.42	2448.71	8520.0
2010-11-19 00:00:00	YM	Futures	10621.1	10628.7	10615.4	10624.9	240.0
2010-11-19 01:00:00	YM	Futures	10624.0	10650.6	10624.0	10649.7	556.0
2010-11-19 02:00:00	YM	Futures	10647.8	10656.3	10645.9	10652.5	676.0
2010-11-19 03:00:00	YM	Futures	10651.6	10652.5	10628.7	10634.4	1170.0
2010-11-19 04:00:00	YM	Futures	10634.4	10635.4	10618.2	10624.0	1215.0
2010-11-19 05:00:00	YM	Futures	10624.0	10627.8	10603.0	10612.5	1490.0
2010-11-19 06:00:00	YM	Futures	10612.5	10624.9	10605.9	10621.1	1200.0
2010-11-19 07:00:00	YM	Futures	10621.1	10623.0	10583.0	10597.3	1663.0
2010-11-19 08:00:00	YM	Futures	10598.2	10618.2	10592.5	10605.9	2724.0
2010-11-19 09:00:00	YM	Futures	10604.9	10623.0	10568.7	10592.5	18526.0
2010-11-19 10:00:00	YM	Futures	10591.6	10619.2	10573.5	10607.8	16157.0
2010-11-19 11:00:00	YM	Futures	10607.8	10625.9	10600.1	10613.5	9944.0
2010-11-19 12:00:00	YM	Futures	10614.4	10625.9	10605.9	10624.9	5398.0
2010-11-19 13:00:00	YM	Futures	10624.0	10631.6	10616.3	10624.0	4958.0
2010-11-19 14:00:00	YM	Futures	10624.9	10643.0	10619.2	10632.5	5663.0
2010-11-19 15:00:00	YM	Futures	10631.6	10652.5	10620.1	10647.8	10941.0

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

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