PREVIEW / futures_1hour / 2017-03-30

all futures 1-hour files

  file:    by_date/futures_1hour/2017/2017-03-30.parquet
  size:    53 KB
  rows:    1,643

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
2017-03-30 00:00:00	ES	Futures	2576.83	2578.2	2576.56	2577.65	1731.0
2017-03-30 01:00:00	ES	Futures	2577.65	2577.65	2576.28	2577.1	4073.0
2017-03-30 02:00:00	ES	Futures	2577.1	2578.2	2576.56	2577.38	5745.0
2017-03-30 03:00:00	ES	Futures	2577.38	2577.65	2575.47	2576.01	11574.0
2017-03-30 04:00:00	ES	Futures	2576.28	2576.56	2571.91	2572.73	12625.0
2017-03-30 05:00:00	ES	Futures	2572.73	2573.28	2571.91	2572.73	8263.0
2017-03-30 06:00:00	ES	Futures	2572.73	2572.73	2571.37	2571.91	6166.0
2017-03-30 07:00:00	ES	Futures	2571.91	2572.73	2571.09	2572.19	9214.0
2017-03-30 08:00:00	ES	Futures	2572.19	2574.92	2571.91	2573.83	17140.0
2017-03-30 09:00:00	ES	Futures	2573.83	2577.92	2571.91	2576.83	129185.0
2017-03-30 10:00:00	ES	Futures	2576.83	2585.57	2576.83	2584.75	195630.0
2017-03-30 11:00:00	ES	Futures	2584.75	2585.84	2580.65	2580.93	138720.0
2017-03-30 12:00:00	ES	Futures	2580.93	2582.29	2577.38	2579.29	113482.0
2017-03-30 13:00:00	ES	Futures	2579.29	2584.21	2578.74	2582.84	91671.0
2017-03-30 14:00:00	ES	Futures	2582.57	2585.57	2581.2	2582.57	92440.0
2017-03-30 15:00:00	ES	Futures	2582.84	2585.03	2581.75	2583.39	207265.0
2017-03-30 16:00:00	ES	Futures	2583.39	2584.48	2582.57	2584.21	82808.0
2017-03-30 18:00:00	ES	Futures	2584.48	2584.75	2583.11	2583.39	4053.0
2017-03-30 19:00:00	ES	Futures	2583.39	2583.93	2581.75	2582.29	3646.0
2017-03-30 20:00:00	ES	Futures	2582.02	2582.29	2579.56	2581.2	7901.0
2017-03-30 21:00:00	ES	Futures	2581.2	2583.11	2580.38	2580.93	8714.0
2017-03-30 22:00:00	ES	Futures	2580.93	2580.93	2579.29	2580.65	5672.0
2017-03-30 23:00:00	ES	Futures	2580.65	2581.2	2579.84	2580.65	2788.0
2017-03-30 00:00:00	NQ	Futures	6489.92	6492.0	6487.83	6489.62	629.0
2017-03-30 01:00:00	NQ	Futures	6489.92	6490.21	6487.53	6489.62	1098.0
2017-03-30 02:00:00	NQ	Futures	6489.62	6490.81	6488.13	6488.72	859.0
2017-03-30 03:00:00	NQ	Futures	6489.02	6490.21	6485.44	6486.34	1683.0
2017-03-30 04:00:00	NQ	Futures	6486.64	6486.64	6476.2	6477.99	2127.0
2017-03-30 05:00:00	NQ	Futures	6477.99	6480.67	6476.5	6478.88	1264.0
2017-03-30 06:00:00	NQ	Futures	6478.88	6479.18	6476.5	6476.8	1072.0
2017-03-30 07:00:00	NQ	Futures	6476.8	6479.78	6474.41	6478.29	1378.0
2017-03-30 08:00:00	NQ	Futures	6478.59	6482.76	6476.2	6480.08	4511.0
2017-03-30 09:00:00	NQ	Futures	6480.08	6489.92	6471.43	6486.93	28229.0
2017-03-30 10:00:00	NQ	Futures	6486.93	6496.18	6483.95	6495.28	28683.0
2017-03-30 11:00:00	NQ	Futures	6494.98	6496.77	6479.78	6480.08	17552.0
2017-03-30 12:00:00	NQ	Futures	6479.78	6486.34	6472.62	6478.88	19073.0
2017-03-30 13:00:00	NQ	Futures	6478.59	6492.6	6477.1	6486.64	11834.0
2017-03-30 14:00:00	NQ	Futures	6486.93	6493.2	6481.27	6485.44	12984.0
2017-03-30 15:00:00	NQ	Futures	6485.15	6491.7	6483.65	6489.02	14802.0
2017-03-30 16:00:00	NQ	Futures	6489.02	6491.41	6484.25	6488.43	6229.0
2017-03-30 18:00:00	NQ	Futures	6488.43	6488.72	6484.25	6485.15	507.0
2017-03-30 19:00:00	NQ	Futures	6485.15	6485.44	6480.97	6481.87	628.0
2017-03-30 20:00:00	NQ	Futures	6481.87	6482.76	6476.5	6480.67	1088.0
2017-03-30 21:00:00	NQ	Futures	6480.38	6483.65	6477.69	6478.29	1456.0
2017-03-30 22:00:00	NQ	Futures	6477.99	6479.48	6475.9	6478.59	1401.0
2017-03-30 23:00:00	NQ	Futures	6478.29	6479.78	6476.8	6477.99	532.0
2017-03-30 00:00:00	YM	Futures	22404.2	22414.0	22399.9	22407.5	420.0
2017-03-30 01:00:00	YM	Futures	22409.6	22409.6	22397.7	22403.1	781.0
2017-03-30 02:00:00	YM	Futures	22403.1	22411.8	22399.9	22405.3	691.0
2017-03-30 03:00:00	YM	Futures	22406.4	22408.5	22391.2	22397.7	1137.0

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

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