PREVIEW / futures_1hour / 2010-11-09

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-09.parquet
  size:    50 KB
  rows:    1,463

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-09 00:00:00	ES	Futures	1199.37	1199.37	1198.13	1198.63	4769.0
2010-11-09 01:00:00	ES	Futures	1198.87	1199.86	1198.87	1199.37	2574.0
2010-11-09 02:00:00	ES	Futures	1199.12	1199.61	1198.13	1198.63	12840.0
2010-11-09 03:00:00	ES	Futures	1198.38	1200.35	1197.64	1200.35	29355.0
2010-11-09 04:00:00	ES	Futures	1200.11	1202.82	1199.37	1202.57	31435.0
2010-11-09 05:00:00	ES	Futures	1202.57	1204.79	1202.32	1204.54	30152.0
2010-11-09 06:00:00	ES	Futures	1204.3	1206.02	1203.8	1205.77	26802.0
2010-11-09 07:00:00	ES	Futures	1206.02	1206.76	1205.04	1205.28	43187.0
2010-11-09 08:00:00	ES	Futures	1205.53	1205.77	1204.3	1205.04	32122.0
2010-11-09 09:00:00	ES	Futures	1205.28	1206.27	1201.83	1204.54	202036.0
2010-11-09 10:00:00	ES	Futures	1204.3	1207.5	1202.82	1204.3	305503.0
2010-11-09 11:00:00	ES	Futures	1204.05	1204.54	1199.61	1199.61	205231.0
2010-11-09 12:00:00	ES	Futures	1199.61	1201.34	1199.12	1199.86	147472.0
2010-11-09 13:00:00	ES	Futures	1199.86	1202.32	1195.18	1196.65	301495.0
2010-11-09 14:00:00	ES	Futures	1196.65	1199.86	1196.41	1198.38	201746.0
2010-11-09 15:00:00	ES	Futures	1198.13	1198.38	1189.26	1193.94	587955.0
2010-11-09 16:00:00	ES	Futures	1194.19	1194.68	1192.46	1193.45	111857.0
2010-11-09 17:00:00	ES	Futures	1193.45	1193.45	1192.71	1192.71	2701.0
2010-11-09 18:00:00	ES	Futures	1192.71	1194.44	1191.48	1194.44	9689.0
2010-11-09 19:00:00	ES	Futures	1194.19	1195.18	1192.96	1194.93	9992.0
2010-11-09 20:00:00	ES	Futures	1194.93	1195.18	1194.19	1194.44	4628.0
2010-11-09 21:00:00	ES	Futures	1194.44	1195.18	1192.22	1192.96	5534.0
2010-11-09 22:00:00	ES	Futures	1192.71	1192.96	1190.99	1191.23	8625.0
2010-11-09 23:00:00	ES	Futures	1191.48	1193.7	1190.99	1193.2	5524.0
2010-11-09 00:00:00	NQ	Futures	2500.36	2501.22	2499.78	2500.64	138.0
2010-11-09 01:00:00	NQ	Futures	2500.64	2502.94	2500.64	2502.08	235.0
2010-11-09 02:00:00	NQ	Futures	2502.08	2502.08	2499.78	2500.07	326.0
2010-11-09 03:00:00	NQ	Futures	2500.36	2504.37	2499.78	2504.09	1971.0
2010-11-09 04:00:00	NQ	Futures	2503.8	2511.54	2503.8	2510.97	2564.0
2010-11-09 05:00:00	NQ	Futures	2510.97	2516.13	2510.4	2514.99	2298.0
2010-11-09 06:00:00	NQ	Futures	2514.41	2517.0	2513.84	2517.0	1248.0
2010-11-09 07:00:00	NQ	Futures	2517.0	2519.29	2516.13	2516.13	2222.0
2010-11-09 08:00:00	NQ	Futures	2516.13	2517.0	2513.55	2515.56	4093.0
2010-11-09 09:00:00	NQ	Futures	2515.56	2519.0	2506.09	2510.68	30998.0
2010-11-09 10:00:00	NQ	Futures	2510.68	2522.45	2509.82	2516.13	40243.0
2010-11-09 11:00:00	NQ	Futures	2516.13	2516.42	2502.36	2502.65	30656.0
2010-11-09 12:00:00	NQ	Futures	2502.65	2507.24	2502.65	2504.95	20739.0
2010-11-09 13:00:00	NQ	Futures	2505.23	2509.82	2494.62	2500.07	37501.0
2010-11-09 14:00:00	NQ	Futures	2500.36	2505.23	2499.49	2502.94	19400.0
2010-11-09 15:00:00	NQ	Futures	2502.94	2502.94	2483.71	2494.33	63093.0
2010-11-09 16:00:00	NQ	Futures	2494.33	2497.77	2494.33	2495.48	9414.0
2010-11-09 17:00:00	NQ	Futures	2495.76	2495.76	2494.33	2494.9	104.0
2010-11-09 18:00:00	NQ	Futures	2494.62	2496.34	2492.04	2496.34	560.0
2010-11-09 19:00:00	NQ	Futures	2496.34	2498.35	2494.62	2497.77	617.0
2010-11-09 20:00:00	NQ	Futures	2498.06	2498.92	2497.2	2498.06	306.0
2010-11-09 21:00:00	NQ	Futures	2497.2	2498.92	2492.9	2493.76	378.0
2010-11-09 22:00:00	NQ	Futures	2493.47	2494.33	2490.89	2491.75	346.0
2010-11-09 23:00:00	NQ	Futures	2491.75	2496.63	2491.46	2495.76	438.0
2010-11-09 00:00:00	YM	Futures	10795.4	10796.4	10787.8	10794.5	183.0
2010-11-09 01:00:00	YM	Futures	10794.5	10800.2	10793.5	10799.2	81.0

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

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