PREVIEW / futures_1hour / 2010-08-31

all futures 1-hour files

  file:    by_date/futures_1hour/2010/2010-08-31.parquet
  size:    46 KB
  rows:    1,342

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
2010-08-31 00:00:00	ES	Futures	1025.44	1025.44	1023.97	1024.95	4504.0
2010-08-31 01:00:00	ES	Futures	1024.7	1025.69	1022.74	1023.48	8490.0
2010-08-31 02:00:00	ES	Futures	1023.48	1023.72	1018.32	1020.29	32536.0
2010-08-31 03:00:00	ES	Futures	1020.04	1022.74	1019.31	1021.27	40312.0
2010-08-31 04:00:00	ES	Futures	1021.27	1023.97	1020.53	1022.74	19083.0
2010-08-31 05:00:00	ES	Futures	1022.5	1023.97	1021.02	1023.72	19112.0
2010-08-31 06:00:00	ES	Futures	1023.72	1024.21	1021.51	1021.76	10425.0
2010-08-31 07:00:00	ES	Futures	1021.76	1022.99	1019.8	1022.5	21993.0
2010-08-31 08:00:00	ES	Futures	1022.74	1022.74	1019.8	1021.51	44655.0
2010-08-31 09:00:00	ES	Futures	1021.27	1028.14	1020.04	1026.91	373777.0
2010-08-31 10:00:00	ES	Futures	1026.91	1033.29	1026.91	1031.82	434725.0
2010-08-31 11:00:00	ES	Futures	1031.82	1034.77	1028.39	1032.8	279291.0
2010-08-31 12:00:00	ES	Futures	1033.05	1034.03	1028.88	1028.88	105358.0
2010-08-31 13:00:00	ES	Futures	1028.88	1033.05	1028.63	1031.58	78888.0
2010-08-31 14:00:00	ES	Futures	1031.33	1033.54	1023.23	1024.7	302890.0
2010-08-31 15:00:00	ES	Futures	1024.7	1031.08	1023.72	1029.12	513267.0
2010-08-31 16:00:00	ES	Futures	1028.88	1033.54	1028.88	1033.29	189455.0
2010-08-31 17:00:00	ES	Futures	1033.54	1033.78	1032.56	1032.8	2273.0
2010-08-31 18:00:00	ES	Futures	1032.56	1033.54	1032.31	1033.54	2687.0
2010-08-31 19:00:00	ES	Futures	1033.54	1033.54	1031.82	1032.56	2810.0
2010-08-31 20:00:00	ES	Futures	1032.56	1033.54	1031.33	1032.8	6100.0
2010-08-31 21:00:00	ES	Futures	1032.8	1037.96	1032.8	1036.24	18278.0
2010-08-31 22:00:00	ES	Futures	1035.99	1039.18	1035.99	1038.2	7986.0
2010-08-31 23:00:00	ES	Futures	1037.96	1038.94	1036.97	1037.96	6703.0
2010-08-31 00:00:00	NQ	Futures	2026.88	2027.45	2024.59	2026.88	274.0
2010-08-31 01:00:00	NQ	Futures	2026.31	2027.45	2022.01	2022.87	416.0
2010-08-31 02:00:00	NQ	Futures	2022.87	2023.73	2012.84	2015.42	2255.0
2010-08-31 03:00:00	NQ	Futures	2015.42	2019.43	2011.98	2014.27	4243.0
2010-08-31 04:00:00	NQ	Futures	2014.27	2020.58	2013.13	2018.0	1381.0
2010-08-31 05:00:00	NQ	Futures	2018.28	2021.15	2015.13	2020.86	1159.0
2010-08-31 06:00:00	NQ	Futures	2020.86	2021.44	2015.71	2016.57	1436.0
2010-08-31 07:00:00	NQ	Futures	2016.85	2019.43	2013.41	2019.14	1618.0
2010-08-31 08:00:00	NQ	Futures	2019.14	2019.43	2013.7	2016.28	4729.0
2010-08-31 09:00:00	NQ	Futures	2016.57	2030.89	2011.12	2028.6	55653.0
2010-08-31 10:00:00	NQ	Futures	2027.17	2042.36	2025.74	2031.75	66132.0
2010-08-31 11:00:00	NQ	Futures	2031.47	2036.91	2023.73	2034.05	40156.0
2010-08-31 12:00:00	NQ	Futures	2034.33	2036.34	2026.02	2026.31	22656.0
2010-08-31 13:00:00	NQ	Futures	2026.31	2036.91	2025.16	2032.33	19671.0
2010-08-31 14:00:00	NQ	Futures	2032.33	2036.34	2014.56	2018.0	52206.0
2010-08-31 15:00:00	NQ	Futures	2018.28	2028.89	2014.56	2026.02	69913.0
2010-08-31 16:00:00	NQ	Futures	2026.31	2036.34	2026.02	2034.05	16173.0
2010-08-31 17:00:00	NQ	Futures	2033.76	2035.19	2033.47	2034.33	319.0
2010-08-31 18:00:00	NQ	Futures	2033.76	2034.62	2032.04	2034.05	496.0
2010-08-31 19:00:00	NQ	Futures	2033.76	2034.33	2032.04	2033.19	500.0
2010-08-31 20:00:00	NQ	Futures	2033.47	2035.19	2030.89	2034.05	313.0
2010-08-31 21:00:00	NQ	Futures	2034.33	2049.23	2034.33	2042.93	1912.0
2010-08-31 22:00:00	NQ	Futures	2042.93	2048.09	2042.64	2046.65	761.0
2010-08-31 23:00:00	NQ	Futures	2046.37	2047.23	2043.79	2046.08	370.0
2010-08-31 00:00:00	YM	Futures	9445.2	9445.2	9434.8	9440.5	479.0
2010-08-31 01:00:00	YM	Futures	9439.6	9444.3	9419.7	9426.3	634.0

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

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