PREVIEW / futures_1hour / 2010-11-08

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-08.parquet
  size:    46 KB
  rows:    1,418

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-11-08 00:00:00	ES	Futures	1201.09	1202.57	1200.85	1202.57	3825.0
2010-11-08 01:00:00	ES	Futures	1202.32	1202.82	1200.11	1200.35	5409.0
2010-11-08 02:00:00	ES	Futures	1200.35	1203.31	1200.11	1203.06	12690.0
2010-11-08 03:00:00	ES	Futures	1203.06	1203.8	1201.58	1202.57	31001.0
2010-11-08 04:00:00	ES	Futures	1202.57	1203.06	1200.11	1202.08	26587.0
2010-11-08 05:00:00	ES	Futures	1201.83	1203.06	1199.37	1199.61	32254.0
2010-11-08 06:00:00	ES	Futures	1199.61	1201.58	1199.37	1201.34	19662.0
2010-11-08 07:00:00	ES	Futures	1201.58	1202.82	1200.85	1201.34	23381.0
2010-11-08 08:00:00	ES	Futures	1201.09	1202.32	1200.85	1201.09	30371.0
2010-11-08 09:00:00	ES	Futures	1201.34	1202.82	1198.38	1199.12	210911.0
2010-11-08 10:00:00	ES	Futures	1199.12	1201.83	1198.13	1198.87	256052.0
2010-11-08 11:00:00	ES	Futures	1198.87	1202.32	1197.64	1201.83	196744.0
2010-11-08 12:00:00	ES	Futures	1201.83	1203.56	1200.85	1202.08	116047.0
2010-11-08 13:00:00	ES	Futures	1202.08	1204.05	1201.09	1202.08	89426.0
2010-11-08 14:00:00	ES	Futures	1202.32	1204.3	1201.34	1201.58	114669.0
2010-11-08 15:00:00	ES	Futures	1201.83	1204.79	1201.34	1203.31	226264.0
2010-11-08 16:00:00	ES	Futures	1203.56	1203.8	1201.09	1201.09	69226.0
2010-11-08 17:00:00	ES	Futures	1201.34	1201.34	1200.35	1201.09	2139.0
2010-11-08 18:00:00	ES	Futures	1200.85	1201.58	1199.37	1199.61	7262.0
2010-11-08 19:00:00	ES	Futures	1199.61	1199.61	1198.13	1198.63	10443.0
2010-11-08 20:00:00	ES	Futures	1198.87	1200.11	1198.38	1199.86	5758.0
2010-11-08 21:00:00	ES	Futures	1199.86	1200.11	1198.87	1199.37	7278.0
2010-11-08 22:00:00	ES	Futures	1199.12	1201.34	1199.12	1200.6	6371.0
2010-11-08 23:00:00	ES	Futures	1200.6	1200.85	1199.12	1199.37	3356.0
2010-11-08 00:00:00	NQ	Futures	2498.92	2501.79	2498.92	2501.79	90.0
2010-11-08 01:00:00	NQ	Futures	2502.08	2502.08	2498.63	2498.63	154.0
2010-11-08 02:00:00	NQ	Futures	2498.63	2503.8	2498.35	2503.51	389.0
2010-11-08 03:00:00	NQ	Futures	2503.22	2504.66	2500.64	2502.94	958.0
2010-11-08 04:00:00	NQ	Futures	2502.94	2503.51	2497.2	2501.5	1423.0
2010-11-08 05:00:00	NQ	Futures	2501.5	2503.51	2497.2	2497.2	1420.0
2010-11-08 06:00:00	NQ	Futures	2497.2	2500.64	2497.2	2500.36	995.0
2010-11-08 07:00:00	NQ	Futures	2500.64	2502.65	2499.78	2500.36	697.0
2010-11-08 08:00:00	NQ	Futures	2500.36	2502.65	2499.49	2500.93	2340.0
2010-11-08 09:00:00	NQ	Futures	2500.93	2504.95	2494.33	2497.49	32847.0
2010-11-08 10:00:00	NQ	Futures	2497.49	2510.97	2495.19	2505.52	43504.0
2010-11-08 11:00:00	NQ	Futures	2505.81	2510.11	2502.65	2509.25	29205.0
2010-11-08 12:00:00	NQ	Futures	2509.25	2512.41	2507.53	2509.25	17655.0
2010-11-08 13:00:00	NQ	Futures	2509.25	2512.12	2505.52	2506.95	14385.0
2010-11-08 14:00:00	NQ	Futures	2506.95	2511.54	2505.52	2505.81	17185.0
2010-11-08 15:00:00	NQ	Futures	2505.81	2511.26	2504.66	2508.1	28596.0
2010-11-08 16:00:00	NQ	Futures	2508.1	2509.25	2502.36	2504.37	6518.0
2010-11-08 17:00:00	NQ	Futures	2503.8	2504.09	2502.36	2503.51	59.0
2010-11-08 18:00:00	NQ	Futures	2502.94	2504.95	2501.22	2501.5	191.0
2010-11-08 19:00:00	NQ	Futures	2501.5	2501.5	2498.35	2500.07	474.0
2010-11-08 20:00:00	NQ	Futures	2500.07	2502.65	2499.78	2502.08	192.0
2010-11-08 21:00:00	NQ	Futures	2501.79	2502.65	2500.64	2500.93	293.0
2010-11-08 22:00:00	NQ	Futures	2501.22	2503.51	2501.22	2501.22	457.0
2010-11-08 23:00:00	NQ	Futures	2501.79	2503.22	2500.07	2500.64	185.0
2010-11-08 00:00:00	YM	Futures	10813.5	10824.0	10813.5	10824.0	109.0
2010-11-08 01:00:00	YM	Futures	10823.0	10823.0	10806.8	10807.8	158.0

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

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