PREVIEW / futures_1hour / 2020-06-04

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-06-04.parquet
  size:    61 KB
  rows:    1,835

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
2020-06-04 00:00:00	ES	Futures	3413.99	3417.01	3413.17	3415.91	7249.0
2020-06-04 01:00:00	ES	Futures	3416.18	3418.93	3412.89	3414.81	9358.0
2020-06-04 02:00:00	ES	Futures	3415.09	3418.65	3408.77	3408.77	17976.0
2020-06-04 03:00:00	ES	Futures	3408.77	3414.54	3408.23	3412.89	30412.0
2020-06-04 04:00:00	ES	Futures	3413.17	3416.46	3409.05	3409.6	27086.0
2020-06-04 05:00:00	ES	Futures	3409.32	3410.7	3401.91	3402.74	36444.0
2020-06-04 06:00:00	ES	Futures	3402.74	3406.58	3401.64	3406.3	21829.0
2020-06-04 07:00:00	ES	Futures	3406.58	3416.73	3403.56	3413.44	48722.0
2020-06-04 08:00:00	ES	Futures	3413.17	3415.63	3396.43	3403.84	77800.0
2020-06-04 09:00:00	ES	Futures	3403.56	3423.87	3402.74	3422.22	199861.0
2020-06-04 10:00:00	ES	Futures	3422.22	3432.1	3419.75	3429.63	238344.0
2020-06-04 11:00:00	ES	Futures	3429.36	3431.0	3410.97	3416.46	277066.0
2020-06-04 12:00:00	ES	Futures	3416.46	3418.38	3404.66	3404.93	126282.0
2020-06-04 13:00:00	ES	Futures	3404.93	3417.56	3403.56	3415.63	108787.0
2020-06-04 14:00:00	ES	Futures	3415.63	3417.83	3400.82	3400.82	115174.0
2020-06-04 15:00:00	ES	Futures	3400.82	3413.99	3389.02	3413.71	290805.0
2020-06-04 16:00:00	ES	Futures	3413.44	3420.85	3411.79	3417.83	57842.0
2020-06-04 18:00:00	ES	Futures	3417.28	3421.95	3415.36	3418.1	7457.0
2020-06-04 19:00:00	ES	Futures	3418.1	3420.3	3411.79	3412.34	6841.0
2020-06-04 20:00:00	ES	Futures	3412.07	3420.3	3409.87	3417.56	14655.0
2020-06-04 21:00:00	ES	Futures	3417.28	3423.32	3414.81	3419.2	15209.0
2020-06-04 22:00:00	ES	Futures	3419.2	3427.16	3418.1	3424.14	13418.0
2020-06-04 23:00:00	ES	Futures	3424.42	3431.83	3424.14	3429.9	11047.0
2020-06-04 00:00:00	NQ	Futures	11044.3	11054.86	11041.72	11049.72	3067.0
2020-06-04 01:00:00	NQ	Futures	11050.29	11059.72	11039.44	11047.15	3803.0
2020-06-04 02:00:00	NQ	Futures	11047.44	11057.43	11039.44	11040.01	4369.0
2020-06-04 03:00:00	NQ	Futures	11040.3	11067.72	11034.87	11066.86	9354.0
2020-06-04 04:00:00	NQ	Futures	11066.86	11076.86	11042.87	11044.58	7215.0
2020-06-04 05:00:00	NQ	Futures	11044.87	11052.86	11025.73	11030.87	5702.0
2020-06-04 06:00:00	NQ	Futures	11030.87	11051.72	11022.59	11047.44	6091.0
2020-06-04 07:00:00	NQ	Futures	11046.87	11062.58	11034.58	11052.86	10322.0
2020-06-04 08:00:00	NQ	Futures	11052.01	11065.43	11018.87	11036.58	19654.0
2020-06-04 09:00:00	NQ	Futures	11036.58	11131.42	11033.73	11110.28	56531.0
2020-06-04 10:00:00	NQ	Futures	11110.85	11129.7	11085.14	11093.43	54875.0
2020-06-04 11:00:00	NQ	Futures	11093.43	11099.71	11011.16	11044.3	68969.0
2020-06-04 12:00:00	NQ	Futures	11044.3	11059.15	10994.88	10998.02	42544.0
2020-06-04 13:00:00	NQ	Futures	10998.02	11049.72	10996.02	11041.44	29823.0
2020-06-04 14:00:00	NQ	Futures	11041.15	11049.72	10963.17	10963.46	33989.0
2020-06-04 15:00:00	NQ	Futures	10963.46	11002.59	10936.89	11000.02	61449.0
2020-06-04 16:00:00	NQ	Futures	11000.02	11024.87	10993.74	11019.44	7985.0
2020-06-04 18:00:00	NQ	Futures	11018.3	11018.59	10996.31	11005.73	2433.0
2020-06-04 19:00:00	NQ	Futures	11005.73	11012.3	10989.17	10990.59	2261.0
2020-06-04 20:00:00	NQ	Futures	10990.31	11012.02	10981.17	11004.59	4905.0
2020-06-04 21:00:00	NQ	Futures	11005.16	11019.44	10994.02	11007.16	5321.0
2020-06-04 22:00:00	NQ	Futures	11008.3	11026.87	11004.59	11015.73	4110.0
2020-06-04 23:00:00	NQ	Futures	11015.45	11040.58	11013.16	11032.58	3506.0
2020-06-04 00:00:00	YM	Futures	28692.9	28719.2	28684.2	28713.7	1756.0
2020-06-04 01:00:00	YM	Futures	28714.8	28747.7	28698.4	28715.9	2111.0
2020-06-04 02:00:00	YM	Futures	28717.0	28751.0	28628.3	28634.9	4010.0
2020-06-04 03:00:00	YM	Futures	28636.0	28678.7	28614.1	28660.1	6405.0

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

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