PREVIEW / futures_1hour / 2009-11-13

all futures 1-hour files

  file:    by_date/futures_1hour/2009/2009-11-13.parquet
  size:    36 KB
  rows:    1,057

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
2009-11-13 00:00:00	ES	Futures	1054.39	1054.88	1052.94	1054.63	3845.0
2009-11-13 01:00:00	ES	Futures	1054.63	1055.36	1053.42	1055.12	2799.0
2009-11-13 02:00:00	ES	Futures	1055.12	1055.84	1054.39	1055.6	6484.0
2009-11-13 03:00:00	ES	Futures	1055.84	1057.54	1054.15	1057.3	24221.0
2009-11-13 04:00:00	ES	Futures	1057.3	1057.54	1056.09	1056.81	10362.0
2009-11-13 05:00:00	ES	Futures	1056.57	1056.81	1055.6	1055.84	8281.0
2009-11-13 06:00:00	ES	Futures	1056.09	1058.02	1056.09	1057.54	11142.0
2009-11-13 07:00:00	ES	Futures	1057.78	1057.78	1054.88	1055.6	17632.0
2009-11-13 08:00:00	ES	Futures	1055.36	1057.06	1054.39	1056.33	30357.0
2009-11-13 09:00:00	ES	Futures	1056.57	1057.06	1049.06	1050.27	265107.0
2009-11-13 10:00:00	ES	Futures	1050.27	1059.72	1049.3	1057.78	303361.0
2009-11-13 11:00:00	ES	Futures	1057.54	1059.72	1056.33	1056.57	124580.0
2009-11-13 12:00:00	ES	Futures	1056.57	1061.9	1056.57	1060.45	120849.0
2009-11-13 13:00:00	ES	Futures	1060.69	1061.17	1058.02	1058.51	82915.0
2009-11-13 14:00:00	ES	Futures	1058.75	1059.72	1053.18	1053.42	148948.0
2009-11-13 15:00:00	ES	Futures	1053.42	1058.51	1052.45	1057.54	221117.0
2009-11-13 16:00:00	ES	Futures	1057.54	1058.02	1056.81	1057.54	67451.0
2009-11-13 00:00:00	NQ	Futures	2026.02	2026.59	2023.17	2026.59	226.0
2009-11-13 01:00:00	NQ	Futures	2026.3	2028.02	2023.74	2027.45	266.0
2009-11-13 02:00:00	NQ	Futures	2027.16	2028.02	2026.02	2028.02	549.0
2009-11-13 03:00:00	NQ	Futures	2027.73	2030.87	2025.73	2030.87	2227.0
2009-11-13 04:00:00	NQ	Futures	2030.58	2030.87	2028.3	2029.44	1061.0
2009-11-13 05:00:00	NQ	Futures	2029.44	2029.73	2027.73	2028.3	537.0
2009-11-13 06:00:00	NQ	Futures	2028.3	2032.58	2028.3	2030.87	1190.0
2009-11-13 07:00:00	NQ	Futures	2030.58	2030.87	2025.45	2027.73	2072.0
2009-11-13 08:00:00	NQ	Futures	2027.45	2030.58	2025.45	2029.73	2736.0
2009-11-13 09:00:00	NQ	Futures	2029.73	2032.86	2021.46	2024.02	41882.0
2009-11-13 10:00:00	NQ	Futures	2024.02	2038.0	2022.31	2034.58	52147.0
2009-11-13 11:00:00	NQ	Futures	2034.58	2038.85	2033.43	2033.72	24086.0
2009-11-13 12:00:00	NQ	Futures	2034.0	2044.84	2033.72	2041.42	26171.0
2009-11-13 13:00:00	NQ	Futures	2041.42	2043.13	2037.43	2038.57	16657.0
2009-11-13 14:00:00	NQ	Futures	2038.57	2041.7	2030.01	2030.3	33137.0
2009-11-13 15:00:00	NQ	Futures	2030.3	2039.71	2028.87	2039.14	36602.0
2009-11-13 16:00:00	NQ	Futures	2038.85	2040.85	2038.28	2038.85	9711.0
2009-11-13 00:00:00	YM	Futures	9485.1	9488.8	9473.9	9488.8	228.0
2009-11-13 01:00:00	YM	Futures	9487.9	9492.5	9479.5	9490.7	172.0
2009-11-13 02:00:00	YM	Futures	9490.7	9495.3	9483.2	9494.4	748.0
2009-11-13 03:00:00	YM	Futures	9494.4	9504.6	9481.4	9504.6	1443.0
2009-11-13 04:00:00	YM	Futures	9505.6	9505.6	9494.4	9499.0	648.0
2009-11-13 05:00:00	YM	Futures	9500.0	9500.9	9491.6	9493.5	503.0
2009-11-13 06:00:00	YM	Futures	9493.5	9509.3	9493.5	9507.4	856.0
2009-11-13 07:00:00	YM	Futures	9507.4	9507.4	9487.0	9490.7	830.0
2009-11-13 08:00:00	YM	Futures	9491.6	9498.1	9480.4	9495.3	1786.0
2009-11-13 09:00:00	YM	Futures	9494.4	9500.0	9448.8	9460.0	22305.0
2009-11-13 10:00:00	YM	Futures	9459.0	9540.0	9451.6	9526.0	25732.0
2009-11-13 11:00:00	YM	Futures	9526.0	9540.0	9516.7	9516.7	11408.0
2009-11-13 12:00:00	YM	Futures	9516.7	9553.9	9516.7	9545.6	10561.0
2009-11-13 13:00:00	YM	Futures	9545.6	9552.1	9527.0	9529.7	6545.0
2009-11-13 14:00:00	YM	Futures	9530.7	9540.9	9489.7	9491.6	13409.0
2009-11-13 15:00:00	YM	Futures	9491.6	9531.6	9483.2	9525.1	14943.0

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

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