PREVIEW / futures_1hour / 2010-11-23

all futures 1-hour files

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

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-23 00:00:00	ES	Futures	1176.44	1177.43	1175.95	1176.69	5047.0
2010-11-23 01:00:00	ES	Futures	1176.69	1176.69	1169.3	1171.02	33798.0
2010-11-23 02:00:00	ES	Futures	1171.27	1172.99	1169.79	1170.77	22235.0
2010-11-23 03:00:00	ES	Futures	1171.02	1173.24	1168.31	1172.75	42258.0
2010-11-23 04:00:00	ES	Futures	1172.5	1174.72	1171.76	1172.5	26010.0
2010-11-23 05:00:00	ES	Futures	1172.75	1172.99	1170.53	1172.75	18645.0
2010-11-23 06:00:00	ES	Futures	1172.75	1174.96	1171.02	1172.01	32084.0
2010-11-23 07:00:00	ES	Futures	1172.01	1172.75	1166.34	1166.83	57766.0
2010-11-23 08:00:00	ES	Futures	1166.83	1169.79	1165.85	1167.57	97277.0
2010-11-23 09:00:00	ES	Futures	1167.82	1169.3	1160.92	1161.9	358229.0
2010-11-23 10:00:00	ES	Futures	1161.65	1166.34	1160.42	1165.6	355454.0
2010-11-23 11:00:00	ES	Futures	1165.6	1165.6	1158.2	1161.41	338570.0
2010-11-23 12:00:00	ES	Futures	1161.41	1164.86	1159.93	1164.61	208435.0
2010-11-23 13:00:00	ES	Futures	1164.61	1165.6	1161.16	1161.9	160381.0
2010-11-23 14:00:00	ES	Futures	1161.9	1163.87	1159.93	1161.9	201096.0
2010-11-23 15:00:00	ES	Futures	1161.65	1163.87	1161.16	1162.39	333821.0
2010-11-23 16:00:00	ES	Futures	1162.64	1163.38	1159.44	1160.18	120249.0
2010-11-23 17:00:00	ES	Futures	1160.18	1160.42	1159.19	1160.18	4088.0
2010-11-23 18:00:00	ES	Futures	1160.42	1165.11	1160.42	1164.61	19881.0
2010-11-23 19:00:00	ES	Futures	1164.37	1166.09	1163.87	1165.6	27919.0
2010-11-23 20:00:00	ES	Futures	1165.35	1167.57	1165.11	1167.32	16694.0
2010-11-23 21:00:00	ES	Futures	1167.57	1168.56	1166.58	1167.32	11794.0
2010-11-23 22:00:00	ES	Futures	1167.32	1167.82	1166.09	1166.58	8058.0
2010-11-23 23:00:00	ES	Futures	1166.34	1167.32	1165.6	1167.32	2950.0
2010-11-23 00:00:00	NQ	Futures	2465.07	2466.79	2464.21	2465.64	451.0
2010-11-23 01:00:00	NQ	Futures	2465.64	2465.64	2456.46	2457.89	3413.0
2010-11-23 02:00:00	NQ	Futures	2458.18	2459.62	2456.46	2457.61	2390.0
2010-11-23 03:00:00	NQ	Futures	2457.61	2461.05	2452.44	2458.75	4844.0
2010-11-23 04:00:00	NQ	Futures	2459.33	2462.77	2457.61	2459.62	1535.0
2010-11-23 05:00:00	NQ	Futures	2459.62	2460.19	2455.6	2459.62	1306.0
2010-11-23 06:00:00	NQ	Futures	2459.62	2463.92	2456.75	2458.18	1685.0
2010-11-23 07:00:00	NQ	Futures	2458.47	2460.19	2445.27	2446.99	5032.0
2010-11-23 08:00:00	NQ	Futures	2446.7	2454.16	2445.56	2449.57	10770.0
2010-11-23 09:00:00	NQ	Futures	2449.86	2453.59	2428.92	2430.64	56947.0
2010-11-23 10:00:00	NQ	Futures	2430.64	2439.25	2426.62	2435.23	52444.0
2010-11-23 11:00:00	NQ	Futures	2435.23	2435.23	2415.43	2421.17	52423.0
2010-11-23 12:00:00	NQ	Futures	2421.17	2426.33	2416.87	2425.76	29656.0
2010-11-23 13:00:00	NQ	Futures	2426.05	2428.06	2421.46	2422.32	24880.0
2010-11-23 14:00:00	NQ	Futures	2422.03	2427.2	2419.45	2424.61	28993.0
2010-11-23 15:00:00	NQ	Futures	2424.33	2431.79	2423.18	2429.78	49777.0
2010-11-23 16:00:00	NQ	Futures	2429.78	2433.51	2426.05	2426.91	11595.0
2010-11-23 17:00:00	NQ	Futures	2426.91	2428.06	2424.9	2427.48	122.0
2010-11-23 18:00:00	NQ	Futures	2427.77	2436.38	2427.77	2435.8	659.0
2010-11-23 19:00:00	NQ	Futures	2435.52	2437.81	2434.65	2436.95	1019.0
2010-11-23 20:00:00	NQ	Futures	2436.66	2441.25	2436.09	2440.97	905.0
2010-11-23 21:00:00	NQ	Futures	2440.97	2443.26	2439.25	2440.97	554.0
2010-11-23 22:00:00	NQ	Futures	2440.68	2441.54	2438.38	2439.53	483.0
2010-11-23 23:00:00	NQ	Futures	2439.25	2440.97	2437.81	2440.97	197.0
2010-11-23 00:00:00	YM	Futures	10600.1	10608.7	10597.3	10603.9	177.0
2010-11-23 01:00:00	YM	Futures	10601.1	10601.1	10549.7	10563.0	1567.0

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

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