PREVIEW / futures_1hour / 2013-12-12

all futures 1-hour files

  file:    by_date/futures_1hour/2013/2013-12-12.parquet
  size:    49 KB
  rows:    1,512

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-12-12 00:00:00	ES	Futures	1833.84	1835.39	1833.07	1835.13	6970.0
2013-12-12 01:00:00	ES	Futures	1835.39	1835.65	1833.84	1834.1	4124.0
2013-12-12 02:00:00	ES	Futures	1833.84	1837.71	1833.84	1837.45	9282.0
2013-12-12 03:00:00	ES	Futures	1837.45	1839.52	1836.42	1839.52	21966.0
2013-12-12 04:00:00	ES	Futures	1839.52	1840.55	1838.74	1839.52	19419.0
2013-12-12 05:00:00	ES	Futures	1839.52	1839.77	1834.87	1836.16	16915.0
2013-12-12 06:00:00	ES	Futures	1836.16	1836.42	1833.84	1834.61	16303.0
2013-12-12 07:00:00	ES	Futures	1834.87	1836.94	1834.36	1836.68	25099.0
2013-12-12 08:00:00	ES	Futures	1836.42	1840.81	1834.36	1840.29	79180.0
2013-12-12 09:00:00	ES	Futures	1840.29	1840.55	1833.84	1835.39	194989.0
2013-12-12 10:00:00	ES	Futures	1835.39	1837.19	1831.78	1835.39	194116.0
2013-12-12 11:00:00	ES	Futures	1835.65	1838.48	1832.81	1833.58	137051.0
2013-12-12 12:00:00	ES	Futures	1833.58	1834.36	1828.17	1831.0	174827.0
2013-12-12 13:00:00	ES	Futures	1831.0	1835.39	1830.75	1834.1	72381.0
2013-12-12 14:00:00	ES	Futures	1834.36	1839.52	1834.1	1838.23	101165.0
2013-12-12 15:00:00	ES	Futures	1838.23	1838.74	1831.0	1832.55	190275.0
2013-12-12 16:00:00	ES	Futures	1832.55	1832.81	1829.97	1830.23	80614.0
2013-12-12 17:00:00	ES	Futures	1830.23	1830.23	1829.71	1829.97	2258.0
2013-12-12 18:00:00	ES	Futures	1829.97	1832.29	1829.71	1830.75	7920.0
2013-12-12 19:00:00	ES	Futures	1831.0	1832.03	1829.97	1831.52	4031.0
2013-12-12 20:00:00	ES	Futures	1831.52	1833.84	1830.75	1833.84	3505.0
2013-12-12 21:00:00	ES	Futures	1833.58	1834.36	1833.32	1833.58	1961.0
2013-12-12 22:00:00	ES	Futures	1833.58	1836.42	1833.32	1836.16	4419.0
2013-12-12 23:00:00	ES	Futures	1836.16	1836.42	1834.87	1835.9	1918.0
2013-12-12 00:00:00	NQ	Futures	4027.43	4031.49	4025.98	4030.62	908.0
2013-12-12 01:00:00	NQ	Futures	4031.2	4032.07	4028.01	4028.59	208.0
2013-12-12 02:00:00	NQ	Futures	4028.59	4035.56	4028.01	4035.56	866.0
2013-12-12 03:00:00	NQ	Futures	4035.27	4036.72	4029.75	4035.85	3439.0
2013-12-12 04:00:00	NQ	Futures	4035.85	4037.88	4033.53	4035.27	2600.0
2013-12-12 05:00:00	NQ	Futures	4034.98	4036.72	4025.69	4029.17	2319.0
2013-12-12 06:00:00	NQ	Futures	4029.17	4030.33	4025.39	4027.72	3179.0
2013-12-12 07:00:00	NQ	Futures	4028.01	4030.62	4026.27	4030.04	3347.0
2013-12-12 08:00:00	NQ	Futures	4030.33	4039.63	4026.85	4037.88	9666.0
2013-12-12 09:00:00	NQ	Futures	4037.88	4042.24	4025.69	4031.49	37421.0
2013-12-12 10:00:00	NQ	Futures	4030.91	4040.21	4022.78	4036.43	33133.0
2013-12-12 11:00:00	NQ	Futures	4036.43	4040.79	4025.1	4025.1	20695.0
2013-12-12 12:00:00	NQ	Futures	4025.1	4028.59	4017.26	4024.52	22135.0
2013-12-12 13:00:00	NQ	Futures	4024.52	4033.24	4023.65	4030.91	11779.0
2013-12-12 14:00:00	NQ	Futures	4030.62	4038.46	4029.46	4035.56	16484.0
2013-12-12 15:00:00	NQ	Futures	4035.85	4036.43	4019.3	4020.46	29964.0
2013-12-12 16:00:00	NQ	Futures	4020.75	4021.33	4014.36	4014.94	5810.0
2013-12-12 17:00:00	NQ	Futures	4015.23	4016.68	4014.36	4016.1	182.0
2013-12-12 18:00:00	NQ	Futures	4016.1	4022.78	4015.52	4021.62	574.0
2013-12-12 19:00:00	NQ	Futures	4019.88	4021.91	4018.71	4021.04	285.0
2013-12-12 20:00:00	NQ	Futures	4021.04	4025.98	4019.01	4025.98	257.0
2013-12-12 21:00:00	NQ	Futures	4025.69	4028.59	4025.39	4027.72	328.0
2013-12-12 22:00:00	NQ	Futures	4027.72	4031.2	4027.72	4031.2	387.0
2013-12-12 23:00:00	NQ	Futures	4030.91	4031.49	4028.88	4030.04	177.0
2013-12-12 00:00:00	YM	Futures	16148.0	16159.3	16147.0	16157.3	64.0
2013-12-12 01:00:00	YM	Futures	16157.3	16160.4	16148.0	16150.1	271.0

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

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