PREVIEW / futures_1hour / 2011-01-06

all futures 1-hour files

  file:    by_date/futures_1hour/2011/2011-01-06.parquet
  size:    48 KB
  rows:    1,464

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
2011-01-06 00:00:00	ES	Futures	1258.17	1258.41	1257.42	1258.41	1713.0
2011-01-06 01:00:00	ES	Futures	1258.41	1258.91	1257.92	1258.17	1337.0
2011-01-06 02:00:00	ES	Futures	1258.41	1258.91	1257.42	1258.17	7204.0
2011-01-06 03:00:00	ES	Futures	1258.17	1260.39	1257.92	1259.65	21513.0
2011-01-06 04:00:00	ES	Futures	1259.65	1260.39	1258.66	1260.39	14101.0
2011-01-06 05:00:00	ES	Futures	1260.39	1262.13	1260.15	1262.13	18779.0
2011-01-06 06:00:00	ES	Futures	1261.88	1263.36	1261.38	1262.62	23405.0
2011-01-06 07:00:00	ES	Futures	1262.62	1263.86	1261.88	1262.37	20354.0
2011-01-06 08:00:00	ES	Futures	1262.37	1263.36	1260.15	1260.39	46398.0
2011-01-06 09:00:00	ES	Futures	1260.39	1260.89	1258.17	1258.17	180581.0
2011-01-06 10:00:00	ES	Futures	1258.17	1261.38	1257.42	1258.17	246669.0
2011-01-06 11:00:00	ES	Futures	1258.41	1258.66	1253.22	1255.69	305667.0
2011-01-06 12:00:00	ES	Futures	1255.44	1257.18	1254.21	1256.43	139093.0
2011-01-06 13:00:00	ES	Futures	1256.43	1258.41	1254.46	1258.41	106543.0
2011-01-06 14:00:00	ES	Futures	1258.17	1259.16	1254.21	1255.44	145163.0
2011-01-06 15:00:00	ES	Futures	1255.2	1257.92	1253.47	1257.18	217691.0
2011-01-06 16:00:00	ES	Futures	1257.18	1258.17	1256.43	1256.68	73457.0
2011-01-06 17:00:00	ES	Futures	1256.68	1256.68	1255.69	1255.69	2102.0
2011-01-06 18:00:00	ES	Futures	1256.43	1256.43	1254.7	1256.19	5788.0
2011-01-06 19:00:00	ES	Futures	1256.43	1256.93	1255.69	1256.19	3437.0
2011-01-06 20:00:00	ES	Futures	1256.19	1256.43	1255.2	1255.2	3790.0
2011-01-06 21:00:00	ES	Futures	1255.2	1256.93	1255.2	1255.94	2557.0
2011-01-06 22:00:00	ES	Futures	1255.94	1257.18	1255.69	1256.68	2366.0
2011-01-06 23:00:00	ES	Futures	1256.93	1257.92	1256.68	1257.92	2084.0
2011-01-06 00:00:00	NQ	Futures	2606.54	2606.83	2605.11	2606.83	98.0
2011-01-06 01:00:00	NQ	Futures	2606.83	2607.12	2605.97	2606.25	144.0
2011-01-06 02:00:00	NQ	Futures	2606.25	2607.69	2605.11	2606.54	326.0
2011-01-06 03:00:00	NQ	Futures	2606.25	2610.85	2605.97	2608.84	1445.0
2011-01-06 04:00:00	NQ	Futures	2608.84	2609.99	2606.83	2609.7	1535.0
2011-01-06 05:00:00	NQ	Futures	2609.7	2612.86	2609.7	2612.57	1585.0
2011-01-06 06:00:00	NQ	Futures	2612.86	2616.01	2612.0	2614.87	1824.0
2011-01-06 07:00:00	NQ	Futures	2614.87	2616.87	2612.28	2612.86	1699.0
2011-01-06 08:00:00	NQ	Futures	2612.57	2614.87	2608.55	2609.12	4591.0
2011-01-06 09:00:00	NQ	Futures	2609.12	2611.13	2603.67	2606.54	25270.0
2011-01-06 10:00:00	NQ	Futures	2606.54	2615.15	2606.25	2608.84	29357.0
2011-01-06 11:00:00	NQ	Futures	2609.12	2611.71	2603.1	2609.41	27969.0
2011-01-06 12:00:00	NQ	Futures	2609.7	2611.42	2605.97	2610.27	13576.0
2011-01-06 13:00:00	NQ	Futures	2609.99	2614.29	2607.4	2614.29	15696.0
2011-01-06 14:00:00	NQ	Futures	2614.29	2616.01	2606.25	2609.7	20772.0
2011-01-06 15:00:00	NQ	Futures	2609.41	2615.44	2606.83	2614.29	24117.0
2011-01-06 16:00:00	NQ	Futures	2614.29	2616.01	2612.86	2614.0	6162.0
2011-01-06 17:00:00	NQ	Futures	2613.72	2614.0	2612.28	2612.28	141.0
2011-01-06 18:00:00	NQ	Futures	2612.86	2613.14	2610.85	2612.86	310.0
2011-01-06 19:00:00	NQ	Futures	2613.14	2613.72	2612.0	2613.14	163.0
2011-01-06 20:00:00	NQ	Futures	2613.43	2613.72	2610.85	2611.42	289.0
2011-01-06 21:00:00	NQ	Futures	2611.42	2613.72	2610.85	2612.28	179.0
2011-01-06 22:00:00	NQ	Futures	2612.57	2614.29	2611.71	2614.29	165.0
2011-01-06 23:00:00	NQ	Futures	2614.29	2615.15	2614.0	2614.87	99.0
2011-01-06 00:00:00	YM	Futures	11167.7	11169.7	11162.0	11166.8	145.0
2011-01-06 01:00:00	YM	Futures	11166.8	11172.5	11166.8	11166.8	91.0

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

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