PREVIEW / futures_1hour / 2010-11-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-11-29.parquet
  size:    47 KB
  rows:    1,386

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-29 00:00:00	ES	Futures	1172.75	1173.49	1171.76	1173.24	4820.0
2010-11-29 01:00:00	ES	Futures	1173.24	1173.98	1172.25	1172.25	2536.0
2010-11-29 02:00:00	ES	Futures	1172.25	1175.95	1171.76	1175.46	14899.0
2010-11-29 03:00:00	ES	Futures	1175.46	1176.94	1173.98	1174.96	46005.0
2010-11-29 04:00:00	ES	Futures	1174.72	1176.44	1170.77	1172.99	54866.0
2010-11-29 05:00:00	ES	Futures	1172.99	1172.99	1167.57	1169.05	62815.0
2010-11-29 06:00:00	ES	Futures	1169.05	1171.51	1167.57	1170.53	29588.0
2010-11-29 07:00:00	ES	Futures	1170.28	1170.77	1162.89	1165.35	65442.0
2010-11-29 08:00:00	ES	Futures	1165.6	1166.58	1163.63	1163.87	47268.0
2010-11-29 09:00:00	ES	Futures	1163.87	1165.85	1156.73	1158.45	360687.0
2010-11-29 10:00:00	ES	Futures	1158.45	1163.38	1155.74	1159.68	410389.0
2010-11-29 11:00:00	ES	Futures	1159.68	1162.64	1156.97	1158.7	318730.0
2010-11-29 12:00:00	ES	Futures	1158.94	1162.89	1158.45	1162.15	169046.0
2010-11-29 13:00:00	ES	Futures	1162.15	1162.15	1158.7	1160.67	118321.0
2010-11-29 14:00:00	ES	Futures	1160.92	1169.79	1160.42	1169.54	283670.0
2010-11-29 15:00:00	ES	Futures	1169.54	1173.24	1169.3	1170.04	327020.0
2010-11-29 16:00:00	ES	Futures	1170.28	1170.53	1168.8	1170.28	91251.0
2010-11-29 17:00:00	ES	Futures	1170.28	1170.77	1169.79	1170.04	1812.0
2010-11-29 18:00:00	ES	Futures	1170.04	1170.77	1169.05	1169.3	5213.0
2010-11-29 19:00:00	ES	Futures	1169.3	1171.27	1168.8	1170.28	6221.0
2010-11-29 20:00:00	ES	Futures	1170.28	1171.02	1169.54	1171.02	4263.0
2010-11-29 21:00:00	ES	Futures	1171.02	1171.51	1168.06	1168.06	6233.0
2010-11-29 22:00:00	ES	Futures	1168.06	1168.31	1166.34	1167.08	8925.0
2010-11-29 23:00:00	ES	Futures	1166.83	1167.08	1165.35	1165.85	7312.0
2010-11-29 00:00:00	NQ	Futures	2471.09	2473.39	2470.52	2472.81	238.0
2010-11-29 01:00:00	NQ	Futures	2472.53	2474.53	2472.24	2472.81	244.0
2010-11-29 02:00:00	NQ	Futures	2472.53	2478.26	2471.67	2477.4	831.0
2010-11-29 03:00:00	NQ	Futures	2477.4	2479.12	2472.81	2475.11	2879.0
2010-11-29 04:00:00	NQ	Futures	2475.39	2478.55	2467.65	2472.24	3577.0
2010-11-29 05:00:00	NQ	Futures	2472.24	2472.24	2460.48	2463.92	3685.0
2010-11-29 06:00:00	NQ	Futures	2463.63	2468.22	2460.19	2465.93	1440.0
2010-11-29 07:00:00	NQ	Futures	2465.93	2465.93	2451.58	2455.89	2741.0
2010-11-29 08:00:00	NQ	Futures	2456.17	2461.62	2454.74	2458.47	4889.0
2010-11-29 09:00:00	NQ	Futures	2458.18	2463.63	2434.65	2438.38	55987.0
2010-11-29 10:00:00	NQ	Futures	2438.67	2446.99	2430.35	2436.95	54351.0
2010-11-29 11:00:00	NQ	Futures	2437.24	2444.12	2431.79	2433.79	35001.0
2010-11-29 12:00:00	NQ	Futures	2433.79	2443.26	2432.65	2440.39	20235.0
2010-11-29 13:00:00	NQ	Futures	2440.39	2440.39	2434.37	2437.81	15124.0
2010-11-29 14:00:00	NQ	Futures	2438.1	2460.48	2436.95	2459.62	34852.0
2010-11-29 15:00:00	NQ	Futures	2459.62	2468.22	2458.18	2460.76	43282.0
2010-11-29 16:00:00	NQ	Futures	2460.76	2462.2	2456.75	2461.05	9586.0
2010-11-29 17:00:00	NQ	Futures	2461.05	2461.62	2461.05	2461.05	72.0
2010-11-29 18:00:00	NQ	Futures	2461.62	2461.91	2459.33	2459.33	173.0
2010-11-29 19:00:00	NQ	Futures	2459.9	2464.49	2459.04	2463.06	422.0
2010-11-29 20:00:00	NQ	Futures	2462.77	2463.92	2461.34	2463.63	502.0
2010-11-29 21:00:00	NQ	Futures	2463.63	2464.49	2457.32	2457.32	238.0
2010-11-29 22:00:00	NQ	Futures	2457.61	2457.89	2451.3	2452.44	685.0
2010-11-29 23:00:00	NQ	Futures	2452.16	2454.16	2450.72	2452.73	397.0
2010-11-29 00:00:00	YM	Futures	10555.4	10560.1	10549.7	10560.1	193.0
2010-11-29 01:00:00	YM	Futures	10556.3	10564.9	10551.6	10551.6	87.0

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

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