PREVIEW / futures_1hour / 2010-04-16

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-04-16.parquet
  size:    39 KB
  rows:    1,117

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-04-16 00:00:00	ES	Futures	1174.96	1176.18	1174.96	1175.69	3009.0
2010-04-16 01:00:00	ES	Futures	1175.69	1176.18	1175.2	1175.69	2536.0
2010-04-16 02:00:00	ES	Futures	1175.93	1176.42	1174.96	1175.45	9534.0
2010-04-16 03:00:00	ES	Futures	1175.45	1177.16	1174.96	1176.91	16172.0
2010-04-16 04:00:00	ES	Futures	1177.16	1179.36	1176.67	1179.11	16326.0
2010-04-16 05:00:00	ES	Futures	1179.11	1180.09	1178.62	1179.6	14612.0
2010-04-16 06:00:00	ES	Futures	1179.6	1179.85	1177.65	1178.38	25059.0
2010-04-16 07:00:00	ES	Futures	1178.62	1180.58	1178.13	1179.11	40306.0
2010-04-16 08:00:00	ES	Futures	1178.87	1179.6	1176.67	1177.4	55731.0
2010-04-16 09:00:00	ES	Futures	1177.4	1179.11	1173.25	1173.73	345395.0
2010-04-16 10:00:00	ES	Futures	1173.98	1179.11	1165.91	1168.85	735351.0
2010-04-16 11:00:00	ES	Futures	1169.09	1171.05	1159.31	1161.02	774760.0
2010-04-16 12:00:00	ES	Futures	1161.27	1162.0	1156.38	1161.51	404212.0
2010-04-16 13:00:00	ES	Futures	1161.51	1162.98	1159.8	1161.76	217850.0
2010-04-16 14:00:00	ES	Futures	1162.0	1166.89	1161.51	1162.74	282716.0
2010-04-16 15:00:00	ES	Futures	1162.98	1166.89	1161.51	1162.25	435493.0
2010-04-16 16:00:00	ES	Futures	1162.25	1164.94	1162.25	1163.22	142738.0
2010-04-16 00:00:00	NQ	Futures	2319.62	2321.34	2319.05	2321.05	302.0
2010-04-16 01:00:00	NQ	Futures	2320.76	2322.2	2320.19	2321.62	125.0
2010-04-16 02:00:00	NQ	Futures	2321.34	2321.62	2318.47	2319.62	1068.0
2010-04-16 03:00:00	NQ	Futures	2319.9	2323.91	2319.33	2323.34	1240.0
2010-04-16 04:00:00	NQ	Futures	2323.63	2326.78	2323.05	2326.2	1083.0
2010-04-16 05:00:00	NQ	Futures	2326.49	2327.92	2325.63	2327.35	939.0
2010-04-16 06:00:00	NQ	Futures	2327.06	2327.35	2323.63	2324.77	1436.0
2010-04-16 07:00:00	NQ	Futures	2325.06	2327.35	2323.63	2325.35	3266.0
2010-04-16 08:00:00	NQ	Futures	2325.06	2326.78	2322.77	2323.63	3599.0
2010-04-16 09:00:00	NQ	Futures	2323.63	2327.35	2315.61	2318.76	50049.0
2010-04-16 10:00:00	NQ	Futures	2318.76	2331.36	2312.17	2316.47	93491.0
2010-04-16 11:00:00	NQ	Futures	2316.47	2319.33	2299.29	2302.44	89345.0
2010-04-16 12:00:00	NQ	Futures	2302.44	2302.44	2288.4	2299.57	64513.0
2010-04-16 13:00:00	NQ	Futures	2299.29	2304.44	2295.56	2299.86	35951.0
2010-04-16 14:00:00	NQ	Futures	2299.86	2309.59	2299.0	2302.15	34446.0
2010-04-16 15:00:00	NQ	Futures	2302.15	2309.59	2298.71	2303.58	49289.0
2010-04-16 16:00:00	NQ	Futures	2303.87	2306.16	2301.0	2301.86	14918.0
2010-04-16 00:00:00	YM	Futures	10397.8	10404.4	10396.9	10402.5	144.0
2010-04-16 01:00:00	YM	Futures	10401.6	10408.2	10399.7	10405.4	343.0
2010-04-16 02:00:00	YM	Futures	10405.4	10406.3	10398.8	10400.7	673.0
2010-04-16 03:00:00	YM	Futures	10401.6	10417.6	10398.8	10414.8	1769.0
2010-04-16 04:00:00	YM	Futures	10414.8	10431.7	10412.9	10430.8	1015.0
2010-04-16 05:00:00	YM	Futures	10430.8	10435.5	10425.1	10433.6	720.0
2010-04-16 06:00:00	YM	Futures	10433.6	10433.6	10420.4	10424.2	1224.0
2010-04-16 07:00:00	YM	Futures	10424.2	10439.2	10424.2	10428.9	1857.0
2010-04-16 08:00:00	YM	Futures	10429.8	10437.3	10417.6	10422.3	3507.0
2010-04-16 09:00:00	YM	Futures	10422.3	10434.5	10401.6	10407.2	24545.0
2010-04-16 10:00:00	YM	Futures	10407.2	10444.9	10361.1	10381.8	46926.0
2010-04-16 11:00:00	YM	Futures	10381.8	10394.1	10299.0	10312.2	54641.0
2010-04-16 12:00:00	YM	Futures	10311.3	10318.8	10273.6	10304.7	26991.0
2010-04-16 13:00:00	YM	Futures	10304.7	10316.9	10292.4	10314.1	16346.0
2010-04-16 14:00:00	YM	Futures	10313.1	10352.7	10311.3	10321.6	19193.0
2010-04-16 15:00:00	YM	Futures	10321.6	10358.3	10313.1	10318.8	25330.0

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

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