PREVIEW / futures_1hour / 2020-10-09

all futures 1-hour files

  file:    by_date/futures_1hour/2020/2020-10-09.parquet
  size:    51 KB
  rows:    1,513

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-10-09 00:00:00	ES	Futures	3872.59	3872.87	3870.35	3871.75	3490.0
2020-10-09 01:00:00	ES	Futures	3871.47	3872.03	3866.42	3866.42	6421.0
2020-10-09 02:00:00	ES	Futures	3866.7	3867.82	3859.98	3861.66	14447.0
2020-10-09 03:00:00	ES	Futures	3861.94	3868.39	3861.66	3866.14	18129.0
2020-10-09 04:00:00	ES	Futures	3866.42	3869.79	3863.9	3866.42	13614.0
2020-10-09 05:00:00	ES	Futures	3866.14	3868.11	3864.18	3866.7	11202.0
2020-10-09 06:00:00	ES	Futures	3866.42	3872.31	3862.22	3862.78	16832.0
2020-10-09 07:00:00	ES	Futures	3862.78	3870.91	3861.66	3868.39	13183.0
2020-10-09 08:00:00	ES	Futures	3868.39	3876.23	3867.26	3874.55	33468.0
2020-10-09 09:00:00	ES	Futures	3874.27	3878.19	3866.98	3872.03	139213.0
2020-10-09 10:00:00	ES	Futures	3872.03	3873.99	3864.74	3872.31	148364.0
2020-10-09 11:00:00	ES	Futures	3872.03	3890.51	3872.03	3887.99	180761.0
2020-10-09 12:00:00	ES	Futures	3887.99	3892.19	3882.67	3884.63	126727.0
2020-10-09 13:00:00	ES	Futures	3884.35	3887.43	3881.27	3887.15	63790.0
2020-10-09 14:00:00	ES	Futures	3887.43	3887.43	3876.23	3880.99	86650.0
2020-10-09 15:00:00	ES	Futures	3880.99	3888.27	3878.75	3886.31	152386.0
2020-10-09 16:00:00	ES	Futures	3886.59	3898.92	3884.91	3894.99	55689.0
2020-10-09 00:00:00	NQ	Futures	13426.72	13428.74	13419.77	13424.11	1911.0
2020-10-09 01:00:00	NQ	Futures	13423.82	13424.4	13407.03	13413.11	3121.0
2020-10-09 02:00:00	NQ	Futures	13413.4	13414.85	13376.35	13385.03	6851.0
2020-10-09 03:00:00	NQ	Futures	13385.03	13404.43	13383.59	13393.14	6680.0
2020-10-09 04:00:00	NQ	Futures	13392.56	13413.98	13387.64	13405.58	5649.0
2020-10-09 05:00:00	NQ	Futures	13405.01	13407.9	13394.01	13396.9	4204.0
2020-10-09 06:00:00	NQ	Futures	13396.32	13411.95	13377.22	13380.98	4748.0
2020-10-09 07:00:00	NQ	Futures	13381.27	13420.93	13379.24	13412.82	5733.0
2020-10-09 08:00:00	NQ	Futures	13413.11	13450.74	13401.53	13444.95	17182.0
2020-10-09 09:00:00	NQ	Futures	13444.66	13477.08	13417.74	13469.27	56945.0
2020-10-09 10:00:00	NQ	Futures	13468.98	13500.53	13446.11	13493.58	54133.0
2020-10-09 11:00:00	NQ	Futures	13493.87	13532.08	13487.5	13521.66	50497.0
2020-10-09 12:00:00	NQ	Futures	13521.37	13545.11	13501.98	13531.79	40443.0
2020-10-09 13:00:00	NQ	Futures	13532.08	13553.5	13514.71	13537.58	26967.0
2020-10-09 14:00:00	NQ	Futures	13538.16	13545.69	13506.32	13516.16	34420.0
2020-10-09 15:00:00	NQ	Futures	13515.87	13563.92	13509.5	13560.16	41082.0
2020-10-09 16:00:00	NQ	Futures	13560.16	13592.29	13553.21	13579.27	11826.0
2020-10-09 00:00:00	YM	Futures	31460.4	31465.9	31441.6	31450.4	1024.0
2020-10-09 01:00:00	YM	Futures	31449.3	31454.9	31410.6	31410.6	1615.0
2020-10-09 02:00:00	YM	Futures	31411.8	31420.6	31354.3	31373.1	3270.0
2020-10-09 03:00:00	YM	Futures	31375.3	31443.8	31373.1	31415.1	5573.0
2020-10-09 04:00:00	YM	Futures	31415.1	31439.4	31385.2	31408.4	4834.0
2020-10-09 05:00:00	YM	Futures	31407.3	31427.2	31395.2	31419.5	2180.0
2020-10-09 06:00:00	YM	Futures	31419.5	31472.6	31383.0	31393.0	3755.0
2020-10-09 07:00:00	YM	Futures	31391.9	31457.1	31384.1	31426.1	2733.0
2020-10-09 08:00:00	YM	Futures	31426.1	31482.5	31419.5	31467.0	4747.0
2020-10-09 09:00:00	YM	Futures	31467.0	31501.3	31353.2	31388.5	21286.0
2020-10-09 10:00:00	YM	Futures	31389.6	31417.3	31315.6	31408.4	21661.0
2020-10-09 11:00:00	YM	Futures	31410.6	31582.0	31408.4	31545.5	25654.0
2020-10-09 12:00:00	YM	Futures	31545.5	31577.6	31471.5	31480.3	17960.0
2020-10-09 13:00:00	YM	Futures	31480.3	31494.7	31441.6	31493.6	9991.0
2020-10-09 14:00:00	YM	Futures	31492.5	31493.6	31387.4	31449.3	13016.0
2020-10-09 15:00:00	YM	Futures	31449.3	31511.3	31417.3	31482.5	13522.0

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

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