PREVIEW / futures_1hour / 2010-03-22

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-03-22.parquet
  size:    44 KB
  rows:    1,319

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-03-22 00:00:00	ES	Futures	1124.12	1125.58	1123.87	1125.34	2828.0
2010-03-22 01:00:00	ES	Futures	1125.09	1125.34	1124.85	1125.09	858.0
2010-03-22 02:00:00	ES	Futures	1125.34	1126.07	1124.85	1125.34	2932.0
2010-03-22 03:00:00	ES	Futures	1125.09	1126.07	1123.87	1125.83	7529.0
2010-03-22 04:00:00	ES	Futures	1125.83	1126.07	1122.41	1124.12	22117.0
2010-03-22 05:00:00	ES	Futures	1124.36	1124.85	1121.43	1122.16	19631.0
2010-03-22 06:00:00	ES	Futures	1121.92	1123.14	1121.18	1123.14	19494.0
2010-03-22 07:00:00	ES	Futures	1123.14	1123.38	1121.92	1122.16	21306.0
2010-03-22 08:00:00	ES	Futures	1122.16	1124.36	1121.92	1122.65	40983.0
2010-03-22 09:00:00	ES	Futures	1122.41	1129.74	1122.16	1128.52	274236.0
2010-03-22 10:00:00	ES	Futures	1128.52	1134.14	1127.78	1132.67	370885.0
2010-03-22 11:00:00	ES	Futures	1132.92	1134.38	1131.69	1133.4	217163.0
2010-03-22 12:00:00	ES	Futures	1133.4	1134.63	1131.69	1133.89	192488.0
2010-03-22 13:00:00	ES	Futures	1134.14	1136.58	1133.89	1134.87	155737.0
2010-03-22 14:00:00	ES	Futures	1134.87	1137.32	1133.4	1136.09	198066.0
2010-03-22 15:00:00	ES	Futures	1136.34	1137.32	1134.63	1135.12	227006.0
2010-03-22 16:00:00	ES	Futures	1135.36	1137.07	1134.63	1136.83	106456.0
2010-03-22 17:00:00	ES	Futures	1136.58	1137.07	1136.34	1136.83	1811.0
2010-03-22 18:00:00	ES	Futures	1136.58	1137.8	1136.58	1137.32	3231.0
2010-03-22 19:00:00	ES	Futures	1137.32	1137.56	1136.83	1137.32	4229.0
2010-03-22 20:00:00	ES	Futures	1137.32	1137.56	1136.09	1136.09	3326.0
2010-03-22 21:00:00	ES	Futures	1136.09	1136.58	1135.85	1136.09	2913.0
2010-03-22 22:00:00	ES	Futures	1136.34	1136.83	1135.85	1135.85	2185.0
2010-03-22 23:00:00	ES	Futures	1135.85	1136.34	1135.85	1136.09	1373.0
2010-03-22 00:00:00	NQ	Futures	2201.63	2203.06	2201.63	2202.78	210.0
2010-03-22 01:00:00	NQ	Futures	2203.06	2203.35	2202.21	2203.06	103.0
2010-03-22 02:00:00	NQ	Futures	2203.06	2204.78	2202.78	2203.92	129.0
2010-03-22 03:00:00	NQ	Futures	2203.64	2204.21	2200.49	2203.92	783.0
2010-03-22 04:00:00	NQ	Futures	2203.92	2204.5	2199.91	2203.06	1726.0
2010-03-22 05:00:00	NQ	Futures	2203.06	2204.78	2198.77	2199.63	1465.0
2010-03-22 06:00:00	NQ	Futures	2199.91	2201.63	2198.2	2201.63	1372.0
2010-03-22 07:00:00	NQ	Futures	2201.63	2202.49	2199.34	2199.91	862.0
2010-03-22 08:00:00	NQ	Futures	2199.63	2203.64	2199.34	2199.91	2882.0
2010-03-22 09:00:00	NQ	Futures	2199.91	2222.54	2198.77	2219.67	64351.0
2010-03-22 10:00:00	NQ	Futures	2219.96	2227.98	2216.52	2225.69	52371.0
2010-03-22 11:00:00	NQ	Futures	2225.4	2228.84	2223.97	2227.69	28654.0
2010-03-22 12:00:00	NQ	Futures	2227.41	2229.98	2223.4	2229.98	26261.0
2010-03-22 13:00:00	NQ	Futures	2229.98	2234.57	2229.98	2229.98	23893.0
2010-03-22 14:00:00	NQ	Futures	2229.98	2238.57	2228.55	2235.42	29491.0
2010-03-22 15:00:00	NQ	Futures	2235.71	2237.43	2228.27	2229.41	32610.0
2010-03-22 16:00:00	NQ	Futures	2229.12	2232.85	2228.55	2231.99	11315.0
2010-03-22 17:00:00	NQ	Futures	2231.99	2232.27	2231.7	2232.27	63.0
2010-03-22 18:00:00	NQ	Futures	2231.99	2233.99	2231.99	2232.85	234.0
2010-03-22 19:00:00	NQ	Futures	2232.85	2233.42	2232.27	2232.85	159.0
2010-03-22 20:00:00	NQ	Futures	2232.85	2232.85	2230.56	2231.13	300.0
2010-03-22 21:00:00	NQ	Futures	2230.84	2231.7	2230.84	2231.13	193.0
2010-03-22 22:00:00	NQ	Futures	2230.84	2231.99	2229.98	2230.27	205.0
2010-03-22 23:00:00	NQ	Futures	2230.27	2230.84	2229.98	2229.98	488.0
2010-03-22 00:00:00	YM	Futures	10012.0	10021.4	10010.1	10019.6	267.0
2010-03-22 01:00:00	YM	Futures	10019.6	10023.3	10018.6	10023.3	182.0

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

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