PREVIEW / futures_1hour / 2010-10-29

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-10-29.parquet
  size:    40 KB
  rows:    1,147

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-10-29 00:00:00	ES	Futures	1158.94	1159.44	1157.96	1157.96	2476.0
2010-10-29 01:00:00	ES	Futures	1158.2	1159.19	1157.96	1157.96	5019.0
2010-10-29 02:00:00	ES	Futures	1157.96	1159.68	1157.46	1158.94	9658.0
2010-10-29 03:00:00	ES	Futures	1158.94	1160.67	1157.46	1159.68	27135.0
2010-10-29 04:00:00	ES	Futures	1159.44	1159.68	1155.74	1156.73	30063.0
2010-10-29 05:00:00	ES	Futures	1156.97	1157.71	1155.49	1156.23	16628.0
2010-10-29 06:00:00	ES	Futures	1156.23	1158.7	1155.74	1158.45	14060.0
2010-10-29 07:00:00	ES	Futures	1158.2	1158.45	1155.99	1157.96	24919.0
2010-10-29 08:00:00	ES	Futures	1157.96	1162.64	1155.74	1161.41	76194.0
2010-10-29 09:00:00	ES	Futures	1161.65	1164.12	1159.93	1160.42	211166.0
2010-10-29 10:00:00	ES	Futures	1160.67	1165.85	1159.68	1163.38	284710.0
2010-10-29 11:00:00	ES	Futures	1163.63	1164.61	1159.19	1161.65	249431.0
2010-10-29 12:00:00	ES	Futures	1161.41	1164.37	1161.41	1163.87	151685.0
2010-10-29 13:00:00	ES	Futures	1163.63	1165.35	1162.39	1164.86	101190.0
2010-10-29 14:00:00	ES	Futures	1164.86	1165.85	1162.15	1162.39	123383.0
2010-10-29 15:00:00	ES	Futures	1162.39	1165.6	1161.9	1163.63	275691.0
2010-10-29 16:00:00	ES	Futures	1163.63	1163.87	1161.9	1163.87	109126.0
2010-10-29 00:00:00	NQ	Futures	2433.51	2435.23	2433.51	2433.51	186.0
2010-10-29 01:00:00	NQ	Futures	2433.79	2435.23	2433.22	2433.22	109.0
2010-10-29 02:00:00	NQ	Futures	2433.22	2436.09	2432.65	2434.65	587.0
2010-10-29 03:00:00	NQ	Futures	2434.65	2437.52	2432.93	2436.38	1519.0
2010-10-29 04:00:00	NQ	Futures	2435.8	2436.09	2429.2	2431.21	1379.0
2010-10-29 05:00:00	NQ	Futures	2431.5	2432.93	2429.49	2430.06	811.0
2010-10-29 06:00:00	NQ	Futures	2429.78	2434.94	2429.78	2434.65	903.0
2010-10-29 07:00:00	NQ	Futures	2434.37	2434.37	2431.21	2433.79	1636.0
2010-10-29 08:00:00	NQ	Futures	2433.51	2442.11	2430.64	2440.11	8137.0
2010-10-29 09:00:00	NQ	Futures	2440.11	2449.57	2437.52	2442.69	37178.0
2010-10-29 10:00:00	NQ	Futures	2442.4	2450.72	2436.95	2442.11	46652.0
2010-10-29 11:00:00	NQ	Futures	2442.11	2444.98	2435.8	2439.82	32270.0
2010-10-29 12:00:00	NQ	Futures	2439.82	2448.14	2439.82	2444.98	19758.0
2010-10-29 13:00:00	NQ	Futures	2445.27	2447.28	2440.39	2446.42	15441.0
2010-10-29 14:00:00	NQ	Futures	2446.13	2446.7	2438.96	2439.53	16395.0
2010-10-29 15:00:00	NQ	Futures	2439.53	2443.84	2435.8	2436.38	35376.0
2010-10-29 16:00:00	NQ	Futures	2436.66	2438.38	2430.64	2436.95	10361.0
2010-10-29 00:00:00	YM	Futures	10496.3	10500.1	10487.7	10490.6	205.0
2010-10-29 01:00:00	YM	Futures	10491.5	10497.3	10489.6	10491.5	115.0
2010-10-29 02:00:00	YM	Futures	10487.7	10501.1	10484.9	10495.4	323.0
2010-10-29 03:00:00	YM	Futures	10495.4	10512.5	10486.8	10503.0	1068.0
2010-10-29 04:00:00	YM	Futures	10502.0	10504.9	10475.4	10483.9	1150.0
2010-10-29 05:00:00	YM	Futures	10483.9	10489.6	10474.4	10477.3	660.0
2010-10-29 06:00:00	YM	Futures	10478.2	10499.2	10477.3	10496.3	644.0
2010-10-29 07:00:00	YM	Futures	10496.3	10497.3	10482.0	10494.4	810.0
2010-10-29 08:00:00	YM	Futures	10494.4	10529.6	10487.7	10523.9	3885.0
2010-10-29 09:00:00	YM	Futures	10524.9	10546.8	10505.8	10509.6	13833.0
2010-10-29 10:00:00	YM	Futures	10510.6	10557.3	10502.0	10537.3	21491.0
2010-10-29 11:00:00	YM	Futures	10538.2	10545.8	10502.0	10518.2	15894.0
2010-10-29 12:00:00	YM	Futures	10518.2	10545.8	10518.2	10542.0	9408.0
2010-10-29 13:00:00	YM	Futures	10543.0	10550.6	10528.7	10547.7	6069.0
2010-10-29 14:00:00	YM	Futures	10547.7	10550.6	10520.1	10523.0	7140.0
2010-10-29 15:00:00	YM	Futures	10522.0	10556.3	10518.2	10545.8	16265.0

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

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