PREVIEW / futures_1hour / 2013-10-21

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-10-21.parquet
  size:    46 KB
  rows:    1,504

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-10-21 00:00:00	ES	Futures	1793.6	1794.63	1793.6	1794.11	1408.0
2013-10-21 01:00:00	ES	Futures	1794.11	1795.15	1793.6	1794.89	2946.0
2013-10-21 02:00:00	ES	Futures	1794.89	1796.69	1794.37	1794.37	9705.0
2013-10-21 03:00:00	ES	Futures	1794.63	1794.63	1791.79	1793.08	19445.0
2013-10-21 04:00:00	ES	Futures	1792.82	1793.86	1792.57	1793.08	7020.0
2013-10-21 05:00:00	ES	Futures	1793.34	1793.34	1792.05	1792.31	8562.0
2013-10-21 06:00:00	ES	Futures	1792.31	1792.82	1791.02	1791.54	9013.0
2013-10-21 07:00:00	ES	Futures	1791.28	1793.34	1790.5	1792.57	11726.0
2013-10-21 08:00:00	ES	Futures	1792.82	1794.37	1792.31	1794.11	21016.0
2013-10-21 09:00:00	ES	Futures	1794.11	1797.21	1792.57	1796.18	164151.0
2013-10-21 10:00:00	ES	Futures	1796.44	1797.98	1791.28	1792.31	205149.0
2013-10-21 11:00:00	ES	Futures	1792.31	1794.37	1791.79	1793.86	127311.0
2013-10-21 12:00:00	ES	Futures	1793.86	1795.15	1793.34	1795.15	79646.0
2013-10-21 13:00:00	ES	Futures	1794.89	1795.4	1793.6	1794.63	80226.0
2013-10-21 14:00:00	ES	Futures	1794.63	1794.63	1789.99	1791.02	115884.0
2013-10-21 15:00:00	ES	Futures	1791.02	1794.63	1790.76	1794.37	152202.0
2013-10-21 16:00:00	ES	Futures	1794.37	1795.15	1792.57	1793.34	67247.0
2013-10-21 17:00:00	ES	Futures	1793.34	1793.34	1792.82	1793.08	493.0
2013-10-21 18:00:00	ES	Futures	1793.08	1793.6	1792.57	1792.82	2694.0
2013-10-21 19:00:00	ES	Futures	1792.82	1793.6	1792.31	1793.6	1654.0
2013-10-21 20:00:00	ES	Futures	1793.6	1793.6	1792.05	1792.05	3907.0
2013-10-21 21:00:00	ES	Futures	1792.05	1792.57	1791.28	1791.54	4262.0
2013-10-21 22:00:00	ES	Futures	1791.54	1792.82	1791.54	1792.82	2150.0
2013-10-21 23:00:00	ES	Futures	1792.82	1792.82	1791.54	1792.31	2741.0
2013-10-21 00:00:00	NQ	Futures	3888.31	3890.92	3888.02	3890.05	357.0
2013-10-21 01:00:00	NQ	Futures	3890.34	3892.09	3889.18	3891.8	566.0
2013-10-21 02:00:00	NQ	Futures	3891.8	3895.86	3890.63	3891.51	1609.0
2013-10-21 03:00:00	NQ	Futures	3891.8	3891.8	3885.7	3889.76	3421.0
2013-10-21 04:00:00	NQ	Futures	3889.47	3891.51	3888.89	3890.34	1397.0
2013-10-21 05:00:00	NQ	Futures	3890.34	3891.8	3888.02	3890.34	1391.0
2013-10-21 06:00:00	NQ	Futures	3890.34	3891.21	3888.02	3888.6	1457.0
2013-10-21 07:00:00	NQ	Futures	3888.6	3892.96	3886.86	3890.92	1708.0
2013-10-21 08:00:00	NQ	Futures	3890.63	3894.12	3890.05	3893.54	3277.0
2013-10-21 09:00:00	NQ	Futures	3893.54	3904.28	3888.02	3902.25	33385.0
2013-10-21 10:00:00	NQ	Futures	3902.83	3906.03	3891.21	3893.83	34491.0
2013-10-21 11:00:00	NQ	Futures	3894.12	3899.35	3892.67	3898.48	16062.0
2013-10-21 12:00:00	NQ	Futures	3898.48	3901.67	3896.44	3900.51	11408.0
2013-10-21 13:00:00	NQ	Futures	3900.51	3900.8	3895.57	3897.89	10377.0
2013-10-21 14:00:00	NQ	Futures	3897.6	3897.6	3883.95	3887.73	19137.0
2013-10-21 15:00:00	NQ	Futures	3887.73	3896.73	3887.15	3894.41	26279.0
2013-10-21 16:00:00	NQ	Futures	3894.99	3898.48	3893.83	3896.15	5135.0
2013-10-21 17:00:00	NQ	Futures	3896.44	3896.44	3895.28	3895.86	180.0
2013-10-21 18:00:00	NQ	Futures	3895.28	3897.02	3894.12	3895.57	465.0
2013-10-21 19:00:00	NQ	Futures	3895.28	3897.89	3894.7	3897.89	409.0
2013-10-21 20:00:00	NQ	Futures	3897.89	3897.89	3894.41	3894.99	439.0
2013-10-21 21:00:00	NQ	Futures	3894.7	3896.44	3893.83	3894.41	801.0
2013-10-21 22:00:00	NQ	Futures	3894.7	3897.31	3894.41	3897.31	371.0
2013-10-21 23:00:00	NQ	Futures	3896.73	3897.02	3894.99	3895.28	314.0
2013-10-21 00:00:00	YM	Futures	15663.9	15669.0	15663.9	15667.0	205.0
2013-10-21 01:00:00	YM	Futures	15667.0	15672.1	15663.9	15672.1	482.0

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

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