PREVIEW / futures_1hour / 2010-11-17

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-17.parquet
  size:    48 KB
  rows:    1,452

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-17 00:00:00	ES	Futures	1162.64	1162.89	1161.65	1162.64	4101.0
2010-11-17 01:00:00	ES	Futures	1162.64	1163.13	1160.67	1160.92	6880.0
2010-11-17 02:00:00	ES	Futures	1160.67	1161.16	1157.22	1157.46	20756.0
2010-11-17 03:00:00	ES	Futures	1157.46	1160.42	1156.73	1160.18	36574.0
2010-11-17 04:00:00	ES	Futures	1160.18	1163.13	1159.68	1162.15	38273.0
2010-11-17 05:00:00	ES	Futures	1162.15	1164.37	1161.65	1163.87	30498.0
2010-11-17 06:00:00	ES	Futures	1163.87	1164.37	1160.18	1160.67	25288.0
2010-11-17 07:00:00	ES	Futures	1160.92	1163.13	1158.7	1161.41	45923.0
2010-11-17 08:00:00	ES	Futures	1161.65	1164.12	1159.19	1160.67	85368.0
2010-11-17 09:00:00	ES	Futures	1160.67	1162.15	1156.97	1161.41	286462.0
2010-11-17 10:00:00	ES	Futures	1161.41	1165.35	1161.16	1162.15	348429.0
2010-11-17 11:00:00	ES	Futures	1162.15	1164.61	1160.92	1163.87	259766.0
2010-11-17 12:00:00	ES	Futures	1163.87	1164.61	1161.9	1162.15	111100.0
2010-11-17 13:00:00	ES	Futures	1162.15	1164.86	1161.41	1163.13	113475.0
2010-11-17 14:00:00	ES	Futures	1163.13	1163.87	1161.65	1162.39	114906.0
2010-11-17 15:00:00	ES	Futures	1162.15	1162.89	1157.22	1160.42	367553.0
2010-11-17 16:00:00	ES	Futures	1160.67	1161.41	1160.18	1160.67	66219.0
2010-11-17 17:00:00	ES	Futures	1160.67	1160.92	1160.42	1160.92	1437.0
2010-11-17 18:00:00	ES	Futures	1161.16	1163.13	1160.92	1162.64	6851.0
2010-11-17 19:00:00	ES	Futures	1162.64	1164.86	1162.64	1164.37	6401.0
2010-11-17 20:00:00	ES	Futures	1164.12	1167.57	1164.12	1165.35	17427.0
2010-11-17 21:00:00	ES	Futures	1165.6	1168.06	1165.35	1167.08	19416.0
2010-11-17 22:00:00	ES	Futures	1166.83	1169.79	1166.83	1169.05	18357.0
2010-11-17 23:00:00	ES	Futures	1169.05	1170.04	1168.06	1169.54	5579.0
2010-11-17 00:00:00	NQ	Futures	2409.12	2409.12	2407.69	2407.97	98.0
2010-11-17 01:00:00	NQ	Futures	2408.55	2409.12	2405.39	2406.25	182.0
2010-11-17 02:00:00	NQ	Futures	2406.54	2406.54	2397.64	2399.08	822.0
2010-11-17 03:00:00	NQ	Futures	2398.79	2404.82	2397.64	2404.53	1924.0
2010-11-17 04:00:00	NQ	Futures	2404.53	2411.42	2403.38	2410.27	3301.0
2010-11-17 05:00:00	NQ	Futures	2409.98	2412.85	2409.12	2412.56	2055.0
2010-11-17 06:00:00	NQ	Futures	2412.56	2412.85	2404.82	2405.96	1768.0
2010-11-17 07:00:00	NQ	Futures	2405.96	2411.42	2400.8	2407.97	2993.0
2010-11-17 08:00:00	NQ	Futures	2407.97	2411.7	2402.81	2405.1	6412.0
2010-11-17 09:00:00	NQ	Futures	2405.1	2409.98	2397.64	2407.69	42287.0
2010-11-17 10:00:00	NQ	Futures	2407.69	2419.45	2407.4	2415.72	40900.0
2010-11-17 11:00:00	NQ	Futures	2415.72	2419.16	2410.84	2416.87	31222.0
2010-11-17 12:00:00	NQ	Futures	2417.15	2418.59	2412.85	2414.57	14892.0
2010-11-17 13:00:00	NQ	Futures	2414.57	2420.6	2412.28	2417.44	16284.0
2010-11-17 14:00:00	NQ	Futures	2417.44	2420.31	2413.71	2414.28	22094.0
2010-11-17 15:00:00	NQ	Futures	2414.57	2415.43	2396.21	2408.26	61036.0
2010-11-17 16:00:00	NQ	Futures	2408.26	2408.55	2404.24	2405.68	8231.0
2010-11-17 17:00:00	NQ	Futures	2405.68	2406.54	2405.1	2406.54	108.0
2010-11-17 18:00:00	NQ	Futures	2407.11	2410.55	2406.83	2410.55	234.0
2010-11-17 19:00:00	NQ	Futures	2409.98	2415.43	2409.98	2414.28	601.0
2010-11-17 20:00:00	NQ	Futures	2414.28	2419.45	2413.42	2415.72	857.0
2010-11-17 21:00:00	NQ	Futures	2416.29	2422.89	2416.01	2419.45	813.0
2010-11-17 22:00:00	NQ	Futures	2419.45	2424.33	2419.16	2422.32	533.0
2010-11-17 23:00:00	NQ	Futures	2422.32	2423.47	2420.31	2423.18	300.0
2010-11-17 00:00:00	YM	Futures	10495.4	10501.1	10491.5	10500.1	159.0
2010-11-17 01:00:00	YM	Futures	10500.1	10502.0	10480.1	10481.1	337.0

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

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