PREVIEW / futures_1hour / 2010-03-16

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-16.parquet
  size:    44 KB
  rows:    1,354

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-03-16 00:00:00	ES	Futures	1120.94	1121.67	1120.69	1121.43	1971.0
2010-03-16 01:00:00	ES	Futures	1121.43	1121.67	1120.94	1121.43	960.0
2010-03-16 02:00:00	ES	Futures	1121.18	1121.92	1120.45	1121.18	2226.0
2010-03-16 03:00:00	ES	Futures	1121.18	1121.43	1119.47	1119.72	8168.0
2010-03-16 04:00:00	ES	Futures	1119.72	1121.43	1118.98	1121.18	14496.0
2010-03-16 05:00:00	ES	Futures	1121.18	1122.65	1120.94	1121.92	8900.0
2010-03-16 06:00:00	ES	Futures	1121.92	1123.14	1121.18	1122.89	13256.0
2010-03-16 07:00:00	ES	Futures	1122.65	1123.14	1121.67	1121.92	12262.0
2010-03-16 08:00:00	ES	Futures	1121.92	1123.38	1121.18	1122.16	30835.0
2010-03-16 09:00:00	ES	Futures	1122.16	1123.87	1119.96	1122.16	205536.0
2010-03-16 10:00:00	ES	Futures	1121.92	1126.32	1121.18	1125.83	245648.0
2010-03-16 11:00:00	ES	Futures	1125.58	1127.29	1124.85	1125.83	198592.0
2010-03-16 12:00:00	ES	Futures	1125.83	1126.32	1124.36	1124.85	97397.0
2010-03-16 13:00:00	ES	Futures	1124.85	1125.34	1123.63	1124.61	53922.0
2010-03-16 14:00:00	ES	Futures	1124.36	1128.27	1122.89	1126.56	329321.0
2010-03-16 15:00:00	ES	Futures	1126.81	1129.98	1125.58	1129.0	328078.0
2010-03-16 16:00:00	ES	Futures	1129.0	1129.49	1128.27	1128.76	88539.0
2010-03-16 17:00:00	ES	Futures	1128.76	1129.25	1128.76	1128.76	1512.0
2010-03-16 18:00:00	ES	Futures	1128.76	1129.25	1128.76	1128.76	1863.0
2010-03-16 19:00:00	ES	Futures	1128.76	1129.25	1128.52	1129.0	2246.0
2010-03-16 20:00:00	ES	Futures	1128.76	1129.49	1128.76	1129.25	1817.0
2010-03-16 21:00:00	ES	Futures	1129.0	1129.25	1128.52	1128.52	1530.0
2010-03-16 22:00:00	ES	Futures	1128.76	1129.0	1128.52	1128.76	1502.0
2010-03-16 23:00:00	ES	Futures	1128.76	1131.45	1128.76	1130.47	4582.0
2010-03-16 00:00:00	NQ	Futures	2197.05	2198.48	2197.05	2198.2	141.0
2010-03-16 01:00:00	NQ	Futures	2198.2	2198.48	2197.91	2198.48	40.0
2010-03-16 02:00:00	NQ	Futures	2198.2	2200.77	2197.62	2199.34	304.0
2010-03-16 03:00:00	NQ	Futures	2199.06	2199.34	2197.34	2197.62	375.0
2010-03-16 04:00:00	NQ	Futures	2197.62	2198.48	2196.48	2197.34	821.0
2010-03-16 05:00:00	NQ	Futures	2197.34	2200.49	2197.34	2199.91	619.0
2010-03-16 06:00:00	NQ	Futures	2200.49	2200.77	2198.77	2200.49	484.0
2010-03-16 07:00:00	NQ	Futures	2200.49	2201.35	2199.91	2199.91	955.0
2010-03-16 08:00:00	NQ	Futures	2200.2	2202.78	2198.48	2199.34	3762.0
2010-03-16 09:00:00	NQ	Futures	2199.34	2203.35	2195.91	2199.91	29711.0
2010-03-16 10:00:00	NQ	Futures	2199.91	2207.93	2195.91	2207.36	35707.0
2010-03-16 11:00:00	NQ	Futures	2207.65	2209.65	2204.78	2207.36	33507.0
2010-03-16 12:00:00	NQ	Futures	2207.65	2209.08	2205.64	2206.5	16751.0
2010-03-16 13:00:00	NQ	Futures	2206.5	2207.36	2204.5	2205.64	9994.0
2010-03-16 14:00:00	NQ	Futures	2205.36	2213.37	2199.91	2206.79	46428.0
2010-03-16 15:00:00	NQ	Futures	2207.07	2212.51	2204.5	2210.51	33330.0
2010-03-16 16:00:00	NQ	Futures	2210.51	2211.08	2207.93	2208.51	9841.0
2010-03-16 17:00:00	NQ	Futures	2208.51	2209.08	2208.22	2209.08	177.0
2010-03-16 18:00:00	NQ	Futures	2208.79	2209.08	2208.22	2208.51	191.0
2010-03-16 19:00:00	NQ	Futures	2208.51	2209.08	2208.22	2208.51	77.0
2010-03-16 20:00:00	NQ	Futures	2208.79	2209.65	2208.51	2209.65	182.0
2010-03-16 21:00:00	NQ	Futures	2209.65	2209.65	2207.93	2207.93	278.0
2010-03-16 22:00:00	NQ	Futures	2208.22	2208.79	2207.65	2208.79	140.0
2010-03-16 23:00:00	NQ	Futures	2208.79	2212.23	2208.79	2210.8	443.0
2010-03-16 00:00:00	YM	Futures	9955.6	9958.4	9951.8	9957.4	175.0
2010-03-16 01:00:00	YM	Futures	9958.4	9959.3	9954.6	9957.4	97.0

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

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