PREVIEW / futures_1hour / 2013-01-28

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-01-28.parquet
  size:    49 KB
  rows:    1,520

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
2013-01-28 00:00:00	ES	Futures	1536.47	1537.24	1535.95	1537.24	3371.0
2013-01-28 01:00:00	ES	Futures	1537.24	1537.49	1536.47	1536.72	6185.0
2013-01-28 02:00:00	ES	Futures	1536.72	1536.98	1535.18	1535.44	5927.0
2013-01-28 03:00:00	ES	Futures	1535.44	1535.95	1534.67	1534.93	22980.0
2013-01-28 04:00:00	ES	Futures	1534.67	1536.47	1534.67	1535.95	16550.0
2013-01-28 05:00:00	ES	Futures	1535.7	1536.47	1535.7	1535.7	12172.0
2013-01-28 06:00:00	ES	Futures	1535.7	1536.21	1535.44	1535.95	6221.0
2013-01-28 07:00:00	ES	Futures	1535.95	1538.01	1535.7	1537.75	24661.0
2013-01-28 08:00:00	ES	Futures	1537.75	1539.55	1535.44	1538.78	62243.0
2013-01-28 09:00:00	ES	Futures	1538.78	1539.29	1534.67	1534.67	162162.0
2013-01-28 10:00:00	ES	Futures	1534.67	1535.44	1530.57	1534.67	226813.0
2013-01-28 11:00:00	ES	Futures	1534.67	1537.75	1533.64	1536.98	139192.0
2013-01-28 12:00:00	ES	Futures	1536.98	1537.75	1534.93	1535.44	118630.0
2013-01-28 13:00:00	ES	Futures	1535.44	1536.21	1533.39	1535.7	68228.0
2013-01-28 14:00:00	ES	Futures	1535.7	1537.75	1535.44	1536.98	54550.0
2013-01-28 15:00:00	ES	Futures	1537.24	1538.01	1534.41	1535.95	177447.0
2013-01-28 16:00:00	ES	Futures	1536.21	1537.75	1534.93	1535.18	70366.0
2013-01-28 17:00:00	ES	Futures	1535.18	1535.95	1534.93	1535.18	2198.0
2013-01-28 18:00:00	ES	Futures	1534.93	1535.44	1534.16	1534.41	4874.0
2013-01-28 19:00:00	ES	Futures	1534.41	1534.93	1533.9	1534.16	4990.0
2013-01-28 20:00:00	ES	Futures	1534.41	1536.98	1534.16	1536.21	8589.0
2013-01-28 21:00:00	ES	Futures	1536.47	1536.98	1536.21	1536.21	3572.0
2013-01-28 22:00:00	ES	Futures	1536.47	1537.49	1536.21	1537.24	4247.0
2013-01-28 23:00:00	ES	Futures	1537.24	1537.24	1536.72	1537.24	2025.0
2013-01-28 00:00:00	NQ	Futures	3180.51	3181.97	3179.64	3181.39	265.0
2013-01-28 01:00:00	NQ	Futures	3181.39	3182.26	3179.35	3180.22	431.0
2013-01-28 02:00:00	NQ	Futures	3179.93	3179.93	3176.73	3177.6	393.0
2013-01-28 03:00:00	NQ	Futures	3177.6	3178.18	3175.27	3176.44	2066.0
2013-01-28 04:00:00	NQ	Futures	3175.85	3178.77	3174.98	3176.73	1866.0
2013-01-28 05:00:00	NQ	Futures	3177.02	3178.18	3176.15	3176.15	1065.0
2013-01-28 06:00:00	NQ	Futures	3176.44	3177.6	3175.27	3177.31	999.0
2013-01-28 07:00:00	NQ	Futures	3177.6	3182.84	3177.02	3182.55	3349.0
2013-01-28 08:00:00	NQ	Futures	3182.84	3183.71	3177.89	3181.97	5260.0
2013-01-28 09:00:00	NQ	Futures	3181.68	3190.7	3179.06	3189.24	30837.0
2013-01-28 10:00:00	NQ	Futures	3188.66	3193.32	3177.02	3190.7	41887.0
2013-01-28 11:00:00	NQ	Futures	3190.7	3198.85	3187.79	3197.39	25644.0
2013-01-28 12:00:00	NQ	Futures	3197.39	3197.98	3190.7	3190.99	17251.0
2013-01-28 13:00:00	NQ	Futures	3190.99	3190.99	3181.39	3188.95	20943.0
2013-01-28 14:00:00	NQ	Futures	3188.66	3195.36	3187.5	3193.32	12196.0
2013-01-28 15:00:00	NQ	Futures	3193.61	3196.52	3185.17	3187.21	25942.0
2013-01-28 16:00:00	NQ	Futures	3186.62	3189.53	3183.13	3183.42	9892.0
2013-01-28 17:00:00	NQ	Futures	3183.42	3185.17	3182.55	3184.3	441.0
2013-01-28 18:00:00	NQ	Futures	3184.0	3185.17	3182.26	3183.42	485.0
2013-01-28 19:00:00	NQ	Futures	3183.71	3184.0	3182.26	3182.84	399.0
2013-01-28 20:00:00	NQ	Futures	3183.13	3187.79	3181.97	3186.04	722.0
2013-01-28 21:00:00	NQ	Futures	3186.04	3186.92	3185.75	3186.33	253.0
2013-01-28 22:00:00	NQ	Futures	3186.33	3188.08	3186.04	3187.5	413.0
2013-01-28 23:00:00	NQ	Futures	3187.5	3188.08	3187.21	3188.08	282.0
2013-01-28 00:00:00	YM	Futures	13913.3	13919.4	13911.3	13917.3	218.0
2013-01-28 01:00:00	YM	Futures	13917.3	13921.4	13914.3	13914.3	326.0

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

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