PREVIEW / futures_1hour / 2012-10-01

all futures 1-hour files

  file:    by_date/futures_1hour/2012/2012-10-01.parquet
  size:    47 KB
  rows:    1,469

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
2012-10-01 00:00:00	ES	Futures	1459.98	1460.23	1458.95	1459.46	2245.0
2012-10-01 01:00:00	ES	Futures	1459.46	1461.51	1459.21	1461.0	3619.0
2012-10-01 02:00:00	ES	Futures	1460.74	1462.79	1460.74	1462.02	5488.0
2012-10-01 03:00:00	ES	Futures	1462.02	1470.45	1461.76	1469.94	47128.0
2012-10-01 04:00:00	ES	Futures	1469.68	1472.49	1468.92	1471.98	28848.0
2012-10-01 05:00:00	ES	Futures	1471.98	1473.51	1471.47	1471.73	22662.0
2012-10-01 06:00:00	ES	Futures	1471.73	1472.49	1470.7	1471.73	19954.0
2012-10-01 07:00:00	ES	Futures	1471.98	1472.24	1470.19	1470.96	23916.0
2012-10-01 08:00:00	ES	Futures	1470.96	1473.26	1470.19	1472.75	36507.0
2012-10-01 09:00:00	ES	Futures	1472.49	1475.05	1470.19	1473.0	187367.0
2012-10-01 10:00:00	ES	Futures	1473.0	1483.22	1473.0	1479.39	352458.0
2012-10-01 11:00:00	ES	Futures	1479.39	1481.69	1476.58	1477.6	220958.0
2012-10-01 12:00:00	ES	Futures	1477.35	1479.39	1473.0	1474.79	159026.0
2012-10-01 13:00:00	ES	Futures	1474.79	1475.05	1469.68	1474.28	200191.0
2012-10-01 14:00:00	ES	Futures	1474.28	1475.56	1471.98	1474.79	105041.0
2012-10-01 15:00:00	ES	Futures	1474.79	1474.79	1465.6	1468.66	365672.0
2012-10-01 16:00:00	ES	Futures	1468.66	1469.43	1467.38	1468.15	79464.0
2012-10-01 17:00:00	ES	Futures	1468.15	1468.92	1467.89	1468.41	2083.0
2012-10-01 18:00:00	ES	Futures	1468.15	1469.17	1468.15	1468.66	1784.0
2012-10-01 19:00:00	ES	Futures	1468.41	1468.92	1467.64	1468.41	1821.0
2012-10-01 20:00:00	ES	Futures	1468.41	1470.45	1468.15	1469.17	6636.0
2012-10-01 21:00:00	ES	Futures	1469.17	1469.43	1467.89	1469.17	4712.0
2012-10-01 22:00:00	ES	Futures	1468.92	1470.45	1468.15	1469.94	4339.0
2012-10-01 23:00:00	ES	Futures	1470.19	1470.19	1469.17	1469.43	2131.0
2012-10-01 00:00:00	NQ	Futures	3232.37	3232.95	3229.47	3231.5	465.0
2012-10-01 01:00:00	NQ	Futures	3231.79	3236.44	3231.79	3235.28	522.0
2012-10-01 02:00:00	NQ	Futures	3234.99	3239.64	3234.7	3238.47	900.0
2012-10-01 03:00:00	NQ	Futures	3238.18	3258.23	3238.18	3256.78	3915.0
2012-10-01 04:00:00	NQ	Futures	3256.49	3263.17	3255.04	3262.88	2553.0
2012-10-01 05:00:00	NQ	Futures	3262.59	3266.08	3262.01	3262.3	2304.0
2012-10-01 06:00:00	NQ	Futures	3262.3	3264.34	3260.56	3263.75	1516.0
2012-10-01 07:00:00	NQ	Futures	3264.04	3264.34	3260.56	3262.01	1824.0
2012-10-01 08:00:00	NQ	Futures	3261.72	3266.66	3260.56	3264.92	5058.0
2012-10-01 09:00:00	NQ	Futures	3264.63	3267.82	3255.04	3256.78	30900.0
2012-10-01 10:00:00	NQ	Futures	3257.36	3280.61	3257.36	3266.37	46406.0
2012-10-01 11:00:00	NQ	Futures	3266.37	3273.63	3260.56	3262.3	22948.0
2012-10-01 12:00:00	NQ	Futures	3262.01	3264.04	3245.45	3250.39	27556.0
2012-10-01 13:00:00	NQ	Futures	3250.39	3252.71	3233.82	3251.84	32922.0
2012-10-01 14:00:00	NQ	Futures	3251.55	3253.29	3244.58	3251.55	17524.0
2012-10-01 15:00:00	NQ	Futures	3251.55	3251.84	3228.59	3239.64	51100.0
2012-10-01 16:00:00	NQ	Futures	3239.64	3242.54	3238.47	3240.22	7196.0
2012-10-01 17:00:00	NQ	Futures	3240.22	3241.96	3239.93	3240.8	260.0
2012-10-01 18:00:00	NQ	Futures	3240.8	3242.25	3240.8	3240.8	250.0
2012-10-01 19:00:00	NQ	Futures	3241.09	3241.67	3238.47	3240.22	257.0
2012-10-01 20:00:00	NQ	Futures	3239.93	3244.58	3239.64	3242.25	624.0
2012-10-01 21:00:00	NQ	Futures	3242.54	3243.41	3239.93	3241.67	464.0
2012-10-01 22:00:00	NQ	Futures	3241.38	3243.99	3239.93	3243.41	476.0
2012-10-01 23:00:00	NQ	Futures	3243.41	3243.99	3241.09	3241.38	307.0
2012-10-01 00:00:00	YM	Futures	13329.9	13331.9	13322.9	13324.9	429.0
2012-10-01 01:00:00	YM	Futures	13324.9	13342.9	13324.9	13339.9	393.0

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

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