PREVIEW / futures_1hour / 2014-06-06

all futures 1-hour files

  file:    by_date/futures_1hour/2014/2014-06-06.parquet
  size:    41 KB
  rows:    1,246

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
2014-06-06 00:00:00	ES	Futures	2016.87	2017.13	2015.83	2015.83	3100.0
2014-06-06 01:00:00	ES	Futures	2015.83	2016.61	2015.31	2015.57	3835.0
2014-06-06 02:00:00	ES	Futures	2015.31	2016.35	2014.79	2015.31	9383.0
2014-06-06 03:00:00	ES	Futures	2015.31	2015.83	2013.75	2013.75	19880.0
2014-06-06 04:00:00	ES	Futures	2014.01	2015.31	2013.23	2015.05	13490.0
2014-06-06 05:00:00	ES	Futures	2015.05	2016.61	2014.79	2015.31	9624.0
2014-06-06 06:00:00	ES	Futures	2015.57	2016.61	2015.05	2016.09	11632.0
2014-06-06 07:00:00	ES	Futures	2016.09	2016.35	2014.01	2014.53	18072.0
2014-06-06 08:00:00	ES	Futures	2014.53	2018.94	2013.49	2018.16	93543.0
2014-06-06 09:00:00	ES	Futures	2018.16	2021.28	2016.61	2021.02	202083.0
2014-06-06 10:00:00	ES	Futures	2021.28	2022.32	2019.72	2021.8	183517.0
2014-06-06 11:00:00	ES	Futures	2022.06	2023.36	2021.02	2021.54	113811.0
2014-06-06 12:00:00	ES	Futures	2021.8	2023.62	2021.28	2022.58	75376.0
2014-06-06 13:00:00	ES	Futures	2022.84	2023.36	2021.54	2022.84	76527.0
2014-06-06 14:00:00	ES	Futures	2022.58	2023.36	2021.54	2021.8	47717.0
2014-06-06 15:00:00	ES	Futures	2021.54	2023.36	2020.24	2023.36	184987.0
2014-06-06 16:00:00	ES	Futures	2023.36	2024.92	2022.84	2024.66	90458.0
2014-06-06 17:00:00	ES	Futures	2024.92	2025.18	2024.66	2025.18	4369.0
2014-06-06 00:00:00	NQ	Futures	4407.36	4408.23	4405.32	4405.61	318.0
2014-06-06 01:00:00	NQ	Futures	4405.32	4407.07	4405.03	4405.61	492.0
2014-06-06 02:00:00	NQ	Futures	4405.61	4405.9	4402.99	4403.86	879.0
2014-06-06 03:00:00	NQ	Futures	4403.57	4405.9	4399.79	4400.95	2501.0
2014-06-06 04:00:00	NQ	Futures	4400.66	4402.99	4398.62	4402.12	1634.0
2014-06-06 05:00:00	NQ	Futures	4402.12	4406.19	4401.53	4402.99	1299.0
2014-06-06 06:00:00	NQ	Futures	4402.99	4407.36	4402.99	4406.19	1721.0
2014-06-06 07:00:00	NQ	Futures	4406.19	4406.19	4400.66	4401.82	2746.0
2014-06-06 08:00:00	NQ	Futures	4401.82	4414.64	4399.2	4414.06	17730.0
2014-06-06 09:00:00	NQ	Futures	4414.06	4416.39	4404.74	4415.22	45092.0
2014-06-06 10:00:00	NQ	Futures	4415.22	4416.39	4404.74	4414.35	30725.0
2014-06-06 11:00:00	NQ	Futures	4414.35	4419.88	4413.47	4414.35	21750.0
2014-06-06 12:00:00	NQ	Futures	4414.06	4418.72	4412.89	4416.09	14223.0
2014-06-06 13:00:00	NQ	Futures	4416.39	4416.68	4409.11	4413.18	12617.0
2014-06-06 14:00:00	NQ	Futures	4413.18	4417.84	4411.44	4416.09	8715.0
2014-06-06 15:00:00	NQ	Futures	4415.8	4421.92	4411.44	4421.34	26911.0
2014-06-06 16:00:00	NQ	Futures	4421.34	4425.41	4420.46	4425.12	6718.0
2014-06-06 17:00:00	NQ	Futures	4424.83	4426.87	4424.83	4426.58	473.0
2014-06-06 00:00:00	YM	Futures	17357.3	17364.5	17353.1	17355.2	1264.0
2014-06-06 01:00:00	YM	Futures	17353.1	17362.4	17342.8	17350.0	3205.0
2014-06-06 02:00:00	YM	Futures	17350.0	17357.3	17341.8	17351.1	1745.0
2014-06-06 03:00:00	YM	Futures	17351.1	17359.3	17339.7	17342.8	2717.0
2014-06-06 04:00:00	YM	Futures	17341.8	17353.1	17337.7	17350.0	1776.0
2014-06-06 05:00:00	YM	Futures	17349.0	17361.4	17348.0	17353.1	1467.0
2014-06-06 06:00:00	YM	Futures	17353.1	17359.3	17349.0	17357.3	1872.0
2014-06-06 07:00:00	YM	Futures	17356.2	17356.2	17342.8	17344.9	1980.0
2014-06-06 08:00:00	YM	Futures	17345.9	17378.9	17337.7	17371.7	8730.0
2014-06-06 09:00:00	YM	Futures	17372.7	17396.4	17355.2	17394.3	18185.0
2014-06-06 10:00:00	YM	Futures	17394.3	17407.7	17386.1	17400.5	15517.0
2014-06-06 11:00:00	YM	Futures	17400.5	17405.7	17391.2	17395.4	7439.0
2014-06-06 12:00:00	YM	Futures	17396.4	17413.9	17395.4	17406.7	6598.0
2014-06-06 13:00:00	YM	Futures	17407.7	17422.1	17402.6	17416.0	6088.0

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

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