PREVIEW / futures_1hour / 2010-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-21.parquet
  size:    48 KB
  rows:    1,426

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-21 00:00:00	ES	Futures	1158.45	1158.94	1157.22	1157.71	2570.0
2010-10-21 01:00:00	ES	Futures	1157.96	1158.45	1156.48	1157.71	4367.0
2010-10-21 02:00:00	ES	Futures	1157.71	1158.7	1156.23	1156.48	8847.0
2010-10-21 03:00:00	ES	Futures	1156.48	1161.65	1155.49	1160.92	34036.0
2010-10-21 04:00:00	ES	Futures	1160.92	1162.39	1160.92	1161.16	22438.0
2010-10-21 05:00:00	ES	Futures	1161.16	1162.64	1160.92	1161.41	16533.0
2010-10-21 06:00:00	ES	Futures	1161.16	1164.12	1161.16	1163.63	24435.0
2010-10-21 07:00:00	ES	Futures	1163.87	1165.85	1163.38	1163.87	42651.0
2010-10-21 08:00:00	ES	Futures	1164.12	1165.35	1161.65	1163.13	75942.0
2010-10-21 09:00:00	ES	Futures	1163.38	1165.11	1160.67	1164.86	205584.0
2010-10-21 10:00:00	ES	Futures	1164.61	1169.54	1161.9	1169.05	407851.0
2010-10-21 11:00:00	ES	Futures	1169.05	1169.54	1159.44	1163.13	360837.0
2010-10-21 12:00:00	ES	Futures	1163.13	1163.63	1158.2	1159.68	237064.0
2010-10-21 13:00:00	ES	Futures	1159.68	1162.15	1151.3	1152.29	275200.0
2010-10-21 14:00:00	ES	Futures	1152.29	1157.46	1150.81	1156.73	264603.0
2010-10-21 15:00:00	ES	Futures	1156.73	1160.92	1155.74	1159.93	288202.0
2010-10-21 16:00:00	ES	Futures	1159.93	1160.42	1157.71	1158.45	79528.0
2010-10-21 17:00:00	ES	Futures	1158.45	1159.19	1158.2	1158.94	2433.0
2010-10-21 18:00:00	ES	Futures	1158.94	1159.68	1158.45	1158.94	2880.0
2010-10-21 19:00:00	ES	Futures	1159.19	1159.44	1158.7	1159.44	2449.0
2010-10-21 20:00:00	ES	Futures	1159.44	1160.67	1159.19	1160.18	8103.0
2010-10-21 21:00:00	ES	Futures	1160.18	1160.67	1159.44	1159.68	3502.0
2010-10-21 22:00:00	ES	Futures	1159.93	1160.42	1159.44	1160.18	1499.0
2010-10-21 23:00:00	ES	Futures	1160.18	1160.92	1160.18	1160.18	1494.0
2010-10-21 00:00:00	NQ	Futures	2392.48	2393.34	2391.05	2392.48	164.0
2010-10-21 01:00:00	NQ	Futures	2392.19	2394.49	2390.76	2393.63	353.0
2010-10-21 02:00:00	NQ	Futures	2393.63	2395.92	2391.33	2391.33	689.0
2010-10-21 03:00:00	NQ	Futures	2391.33	2401.37	2389.04	2400.8	2254.0
2010-10-21 04:00:00	NQ	Futures	2400.51	2403.1	2400.23	2401.66	1867.0
2010-10-21 05:00:00	NQ	Futures	2401.09	2403.67	2400.8	2402.23	1063.0
2010-10-21 06:00:00	NQ	Futures	2401.66	2407.4	2401.37	2407.11	1803.0
2010-10-21 07:00:00	NQ	Futures	2407.11	2412.28	2406.54	2409.41	3068.0
2010-10-21 08:00:00	NQ	Futures	2409.12	2410.55	2402.52	2405.96	7111.0
2010-10-21 09:00:00	NQ	Futures	2405.96	2411.42	2399.37	2409.41	31099.0
2010-10-21 10:00:00	NQ	Futures	2409.41	2414.28	2401.66	2412.85	44778.0
2010-10-21 11:00:00	NQ	Futures	2413.14	2415.15	2393.05	2401.09	48071.0
2010-10-21 12:00:00	NQ	Futures	2401.09	2401.37	2390.47	2394.2	34398.0
2010-10-21 13:00:00	NQ	Futures	2394.49	2399.94	2372.97	2375.84	43356.0
2010-10-21 14:00:00	NQ	Futures	2375.84	2387.6	2371.82	2386.74	45190.0
2010-10-21 15:00:00	NQ	Futures	2386.74	2397.07	2384.45	2394.78	45384.0
2010-10-21 16:00:00	NQ	Futures	2394.78	2395.35	2386.17	2388.75	12786.0
2010-10-21 17:00:00	NQ	Futures	2389.04	2390.18	2387.32	2388.75	604.0
2010-10-21 18:00:00	NQ	Futures	2388.75	2390.47	2388.18	2388.46	248.0
2010-10-21 19:00:00	NQ	Futures	2389.32	2389.61	2387.89	2388.18	275.0
2010-10-21 20:00:00	NQ	Futures	2388.75	2391.62	2387.6	2390.76	509.0
2010-10-21 21:00:00	NQ	Futures	2390.76	2391.33	2389.61	2389.9	184.0
2010-10-21 22:00:00	NQ	Futures	2390.18	2391.05	2389.61	2390.76	140.0
2010-10-21 23:00:00	NQ	Futures	2391.05	2392.48	2391.05	2391.33	267.0
2010-10-21 00:00:00	YM	Futures	10537.3	10538.2	10527.7	10536.3	295.0
2010-10-21 01:00:00	YM	Futures	10536.3	10536.3	10523.9	10532.5	265.0

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

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