PREVIEW / futures_1hour / 2010-09-27

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-09-27.parquet
  size:    44 KB
  rows:    1,356

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-09-27 00:00:00	ES	Futures	1127.89	1131.34	1127.89	1131.09	4933.0
2010-09-27 01:00:00	ES	Futures	1130.85	1131.34	1129.37	1130.11	3926.0
2010-09-27 02:00:00	ES	Futures	1129.86	1130.85	1127.64	1128.87	10130.0
2010-09-27 03:00:00	ES	Futures	1128.87	1130.35	1127.39	1128.87	28208.0
2010-09-27 04:00:00	ES	Futures	1128.87	1129.61	1126.16	1126.41	18542.0
2010-09-27 05:00:00	ES	Futures	1126.41	1128.87	1125.92	1128.38	17023.0
2010-09-27 06:00:00	ES	Futures	1128.13	1128.63	1126.41	1128.13	11015.0
2010-09-27 07:00:00	ES	Futures	1128.13	1128.87	1127.39	1127.89	16077.0
2010-09-27 08:00:00	ES	Futures	1127.89	1128.87	1126.9	1128.87	41626.0
2010-09-27 09:00:00	ES	Futures	1128.63	1129.86	1123.45	1124.44	203434.0
2010-09-27 10:00:00	ES	Futures	1124.44	1127.39	1123.2	1126.65	190808.0
2010-09-27 11:00:00	ES	Futures	1126.41	1126.65	1122.46	1123.7	144906.0
2010-09-27 12:00:00	ES	Futures	1123.7	1124.68	1122.96	1123.7	81335.0
2010-09-27 13:00:00	ES	Futures	1123.7	1127.64	1122.46	1126.9	110062.0
2010-09-27 14:00:00	ES	Futures	1126.9	1129.12	1126.41	1127.39	107378.0
2010-09-27 15:00:00	ES	Futures	1127.39	1127.64	1120.99	1122.22	218907.0
2010-09-27 16:00:00	ES	Futures	1122.46	1123.2	1121.23	1122.22	89718.0
2010-09-27 17:00:00	ES	Futures	1122.22	1123.2	1122.22	1122.71	1575.0
2010-09-27 18:00:00	ES	Futures	1122.71	1122.96	1121.23	1121.73	3175.0
2010-09-27 19:00:00	ES	Futures	1121.73	1121.97	1121.23	1121.97	1765.0
2010-09-27 20:00:00	ES	Futures	1121.73	1123.7	1121.48	1123.45	4611.0
2010-09-27 21:00:00	ES	Futures	1123.45	1123.7	1122.71	1123.7	2663.0
2010-09-27 22:00:00	ES	Futures	1123.45	1123.94	1122.71	1123.2	2897.0
2010-09-27 23:00:00	ES	Futures	1123.2	1123.94	1122.46	1122.96	3116.0
2010-09-27 00:00:00	NQ	Futures	2319.32	2324.77	2319.32	2324.48	213.0
2010-09-27 01:00:00	NQ	Futures	2324.48	2325.06	2321.62	2323.62	188.0
2010-09-27 02:00:00	NQ	Futures	2323.34	2324.77	2318.46	2321.04	834.0
2010-09-27 03:00:00	NQ	Futures	2320.75	2325.06	2317.89	2322.76	3119.0
2010-09-27 04:00:00	NQ	Futures	2322.48	2323.05	2316.45	2317.31	1348.0
2010-09-27 05:00:00	NQ	Futures	2317.31	2320.75	2316.16	2319.89	1050.0
2010-09-27 06:00:00	NQ	Futures	2319.89	2320.18	2316.45	2319.03	826.0
2010-09-27 07:00:00	NQ	Futures	2319.32	2320.47	2317.31	2318.17	1560.0
2010-09-27 08:00:00	NQ	Futures	2318.46	2321.04	2317.6	2320.75	7463.0
2010-09-27 09:00:00	NQ	Futures	2320.75	2322.76	2309.85	2311.57	37156.0
2010-09-27 10:00:00	NQ	Futures	2311.57	2318.17	2309.28	2314.44	33463.0
2010-09-27 11:00:00	NQ	Futures	2314.16	2314.16	2307.27	2310.14	26876.0
2010-09-27 12:00:00	NQ	Futures	2310.43	2313.01	2308.7	2310.43	16826.0
2010-09-27 13:00:00	NQ	Futures	2310.14	2319.89	2308.99	2318.17	24276.0
2010-09-27 14:00:00	NQ	Futures	2318.46	2323.05	2317.31	2317.89	26994.0
2010-09-27 15:00:00	NQ	Futures	2317.89	2318.46	2304.4	2306.41	38636.0
2010-09-27 16:00:00	NQ	Futures	2306.12	2307.56	2302.97	2304.97	9601.0
2010-09-27 17:00:00	NQ	Futures	2304.97	2306.7	2304.97	2305.26	166.0
2010-09-27 18:00:00	NQ	Futures	2305.55	2306.7	2303.54	2304.69	265.0
2010-09-27 19:00:00	NQ	Futures	2304.11	2305.26	2303.83	2305.26	144.0
2010-09-27 20:00:00	NQ	Futures	2304.4	2308.7	2304.4	2307.84	289.0
2010-09-27 21:00:00	NQ	Futures	2307.84	2308.13	2306.7	2307.84	128.0
2010-09-27 22:00:00	NQ	Futures	2308.13	2308.42	2306.7	2307.27	145.0
2010-09-27 23:00:00	NQ	Futures	2306.98	2308.42	2305.55	2306.98	187.0
2010-09-27 00:00:00	YM	Futures	10289.6	10315.3	10289.6	10313.4	261.0
2010-09-27 01:00:00	YM	Futures	10312.5	10316.3	10301.0	10302.9	444.0

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

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