PREVIEW / futures_1hour / 2010-10-28

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-28.parquet
  size:    47 KB
  rows:    1,445

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-10-28 00:00:00	ES	Futures	1164.12	1164.86	1163.63	1163.87	3868.0
2010-10-28 01:00:00	ES	Futures	1163.87	1164.61	1163.13	1163.87	3103.0
2010-10-28 02:00:00	ES	Futures	1163.87	1165.6	1163.13	1164.12	14027.0
2010-10-28 03:00:00	ES	Futures	1164.12	1165.35	1162.39	1163.38	30695.0
2010-10-28 04:00:00	ES	Futures	1163.38	1164.61	1162.89	1164.37	15199.0
2010-10-28 05:00:00	ES	Futures	1164.37	1166.09	1164.12	1165.35	18273.0
2010-10-28 06:00:00	ES	Futures	1165.11	1165.35	1164.12	1164.12	14217.0
2010-10-28 07:00:00	ES	Futures	1164.37	1164.61	1162.89	1164.12	25536.0
2010-10-28 08:00:00	ES	Futures	1163.87	1170.77	1163.87	1168.56	111976.0
2010-10-28 09:00:00	ES	Futures	1168.8	1169.79	1165.85	1166.83	197290.0
2010-10-28 10:00:00	ES	Futures	1166.58	1167.82	1158.94	1161.16	430527.0
2010-10-28 11:00:00	ES	Futures	1161.41	1163.87	1159.93	1159.93	213350.0
2010-10-28 12:00:00	ES	Futures	1159.93	1160.18	1156.97	1157.71	202300.0
2010-10-28 13:00:00	ES	Futures	1157.96	1163.87	1157.22	1160.67	209792.0
2010-10-28 14:00:00	ES	Futures	1160.67	1163.38	1160.42	1162.15	138082.0
2010-10-28 15:00:00	ES	Futures	1162.15	1165.6	1160.42	1163.13	266879.0
2010-10-28 16:00:00	ES	Futures	1163.38	1164.37	1162.15	1163.13	87022.0
2010-10-28 17:00:00	ES	Futures	1163.38	1163.38	1162.39	1162.89	1221.0
2010-10-28 18:00:00	ES	Futures	1162.64	1163.13	1162.15	1162.89	2473.0
2010-10-28 19:00:00	ES	Futures	1163.13	1163.13	1161.65	1162.39	2401.0
2010-10-28 20:00:00	ES	Futures	1162.64	1162.64	1158.2	1158.7	8721.0
2010-10-28 21:00:00	ES	Futures	1158.7	1159.44	1156.97	1159.19	9671.0
2010-10-28 22:00:00	ES	Futures	1159.19	1159.44	1156.73	1156.97	6273.0
2010-10-28 23:00:00	ES	Futures	1156.97	1159.19	1156.73	1159.19	3394.0
2010-10-28 00:00:00	NQ	Futures	2438.38	2438.96	2437.81	2438.1	138.0
2010-10-28 01:00:00	NQ	Futures	2438.1	2439.25	2436.95	2438.67	372.0
2010-10-28 02:00:00	NQ	Futures	2438.67	2440.68	2438.1	2438.96	2214.0
2010-10-28 03:00:00	NQ	Futures	2438.96	2442.69	2437.24	2439.82	3337.0
2010-10-28 04:00:00	NQ	Futures	2439.53	2442.4	2438.96	2441.54	1149.0
2010-10-28 05:00:00	NQ	Futures	2441.83	2444.98	2441.54	2442.97	1228.0
2010-10-28 06:00:00	NQ	Futures	2443.26	2443.26	2440.39	2440.39	824.0
2010-10-28 07:00:00	NQ	Futures	2440.68	2440.97	2438.1	2440.11	930.0
2010-10-28 08:00:00	NQ	Futures	2440.39	2452.16	2439.82	2446.7	9447.0
2010-10-28 09:00:00	NQ	Futures	2446.7	2449.29	2437.52	2439.82	40377.0
2010-10-28 10:00:00	NQ	Futures	2439.82	2443.26	2425.19	2429.78	60249.0
2010-10-28 11:00:00	NQ	Futures	2429.78	2435.8	2428.06	2428.34	31601.0
2010-10-28 12:00:00	NQ	Futures	2428.06	2428.34	2422.03	2423.47	31369.0
2010-10-28 13:00:00	NQ	Futures	2423.47	2436.95	2420.6	2432.65	37487.0
2010-10-28 14:00:00	NQ	Futures	2432.36	2442.69	2431.79	2439.53	26445.0
2010-10-28 15:00:00	NQ	Futures	2439.53	2446.42	2435.52	2442.11	43986.0
2010-10-28 16:00:00	NQ	Futures	2442.11	2445.27	2438.96	2444.7	11572.0
2010-10-28 17:00:00	NQ	Futures	2444.12	2444.12	2442.4	2442.4	107.0
2010-10-28 18:00:00	NQ	Futures	2442.69	2442.69	2440.68	2442.11	172.0
2010-10-28 19:00:00	NQ	Futures	2441.83	2444.41	2440.68	2443.84	635.0
2010-10-28 20:00:00	NQ	Futures	2443.55	2443.55	2434.37	2434.94	644.0
2010-10-28 21:00:00	NQ	Futures	2435.23	2435.23	2432.07	2434.37	782.0
2010-10-28 22:00:00	NQ	Futures	2434.37	2434.65	2430.92	2431.21	403.0
2010-10-28 23:00:00	NQ	Futures	2431.21	2433.51	2430.64	2433.51	187.0
2010-10-28 00:00:00	YM	Futures	10560.1	10563.9	10557.3	10557.3	183.0
2010-10-28 01:00:00	YM	Futures	10558.2	10563.0	10554.4	10558.2	151.0

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

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