PREVIEW / futures_1hour / 2019-03-04

all futures 1-hour files

  file:    by_date/futures_1hour/2019/2019-03-04.parquet
  size:    55 KB
  rows:    1,731

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
2019-03-04 00:00:00	ES	Futures	3060.49	3061.3	3058.59	3059.13	4373.0
2019-03-04 01:00:00	ES	Futures	3059.13	3060.21	3056.96	3059.67	7280.0
2019-03-04 02:00:00	ES	Futures	3059.94	3059.94	3056.14	3057.5	7821.0
2019-03-04 03:00:00	ES	Futures	3057.5	3058.86	3054.24	3058.59	15686.0
2019-03-04 04:00:00	ES	Futures	3058.31	3058.86	3052.88	3052.88	17767.0
2019-03-04 05:00:00	ES	Futures	3052.88	3055.6	3052.07	3053.7	8840.0
2019-03-04 06:00:00	ES	Futures	3053.7	3055.87	3052.61	3055.33	7715.0
2019-03-04 07:00:00	ES	Futures	3055.05	3056.68	3055.05	3055.87	8166.0
2019-03-04 08:00:00	ES	Futures	3055.87	3058.59	3055.33	3057.77	17290.0
2019-03-04 09:00:00	ES	Futures	3058.04	3061.3	3054.24	3058.59	156750.0
2019-03-04 10:00:00	ES	Futures	3058.31	3059.4	3047.99	3048.27	201653.0
2019-03-04 11:00:00	ES	Futures	3048.27	3049.35	3015.13	3018.66	353866.0
2019-03-04 12:00:00	ES	Futures	3018.66	3023.82	3006.98	3012.42	293886.0
2019-03-04 13:00:00	ES	Futures	3012.42	3025.18	3006.44	3024.37	160147.0
2019-03-04 14:00:00	ES	Futures	3024.37	3030.61	3021.38	3026.81	122028.0
2019-03-04 15:00:00	ES	Futures	3026.54	3035.77	3023.28	3034.41	226074.0
2019-03-04 16:00:00	ES	Futures	3034.69	3034.96	3031.7	3032.24	50975.0
2019-03-04 18:00:00	ES	Futures	3031.43	3031.97	3028.44	3031.7	6952.0
2019-03-04 19:00:00	ES	Futures	3031.97	3033.6	3028.71	3030.61	9740.0
2019-03-04 20:00:00	ES	Futures	3030.88	3032.78	3025.72	3026.27	16369.0
2019-03-04 21:00:00	ES	Futures	3026.27	3031.7	3026.27	3031.16	9376.0
2019-03-04 22:00:00	ES	Futures	3031.16	3034.14	3029.25	3031.97	11187.0
2019-03-04 23:00:00	ES	Futures	3031.97	3032.51	3030.61	3031.16	3520.0
2019-03-04 00:00:00	NQ	Futures	8417.97	8421.48	8409.79	8413.3	2231.0
2019-03-04 01:00:00	NQ	Futures	8413.3	8415.35	8407.46	8413.3	2287.0
2019-03-04 02:00:00	NQ	Futures	8413.3	8413.3	8403.66	8407.46	2453.0
2019-03-04 03:00:00	NQ	Futures	8407.16	8411.25	8398.69	8411.25	4640.0
2019-03-04 04:00:00	NQ	Futures	8411.25	8414.18	8396.64	8397.23	4830.0
2019-03-04 05:00:00	NQ	Futures	8397.23	8403.95	8393.14	8396.35	3764.0
2019-03-04 06:00:00	NQ	Futures	8395.77	8402.78	8392.55	8399.86	2996.0
2019-03-04 07:00:00	NQ	Futures	8399.86	8405.99	8399.27	8405.12	6059.0
2019-03-04 08:00:00	NQ	Futures	8404.83	8413.01	8401.9	8410.38	8114.0
2019-03-04 09:00:00	NQ	Futures	8410.38	8428.49	8403.95	8422.94	48497.0
2019-03-04 10:00:00	NQ	Futures	8423.23	8426.74	8384.08	8384.37	69866.0
2019-03-04 11:00:00	NQ	Futures	8384.67	8389.34	8284.74	8294.67	109279.0
2019-03-04 12:00:00	NQ	Futures	8294.38	8313.37	8268.37	8297.3	101532.0
2019-03-04 13:00:00	NQ	Futures	8297.3	8336.45	8276.85	8333.53	61312.0
2019-03-04 14:00:00	NQ	Futures	8333.24	8346.1	8318.05	8335.29	44367.0
2019-03-04 15:00:00	NQ	Futures	8335.29	8364.5	8328.56	8362.46	50591.0
2019-03-04 16:00:00	NQ	Futures	8362.46	8363.04	8348.14	8349.89	9812.0
2019-03-04 18:00:00	NQ	Futures	8350.19	8350.19	8339.08	8346.97	2852.0
2019-03-04 19:00:00	NQ	Futures	8346.97	8354.86	8339.08	8344.64	4208.0
2019-03-04 20:00:00	NQ	Futures	8344.93	8353.11	8328.27	8331.19	5437.0
2019-03-04 21:00:00	NQ	Futures	8331.49	8349.6	8331.19	8348.14	3418.0
2019-03-04 22:00:00	NQ	Futures	8348.43	8357.49	8343.17	8351.36	4122.0
2019-03-04 23:00:00	NQ	Futures	8351.65	8353.4	8346.97	8349.6	1127.0
2019-03-04 00:00:00	YM	Futures	28396.7	28406.4	28372.8	28382.5	1324.0
2019-03-04 01:00:00	YM	Futures	28381.5	28386.9	28363.0	28380.4	1495.0
2019-03-04 02:00:00	YM	Futures	28381.5	28382.5	28347.8	28360.8	1872.0
2019-03-04 03:00:00	YM	Futures	28359.7	28369.5	28330.4	28366.3	3183.0

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

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