PREVIEW / stock_1hour / 2017-08-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-08-14.parquet
  size:    1.0 MB
  rows:    48,265
  symbols: 2,994

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-08-14 04:00:00	AAPL	Stock	39.65	39.6625	39.5875	39.65	68840.0
2017-08-14 05:00:00	AAPL	Stock	39.6525	39.725	39.65	39.7075	31828.0
2017-08-14 06:00:00	AAPL	Stock	39.7	39.7325	39.6725	39.705	49940.0
2017-08-14 07:00:00	AAPL	Stock	39.7125	39.785	39.69	39.72	195088.0
2017-08-14 08:00:00	AAPL	Stock	39.7175	39.7875	39.6275	39.7375	534044.0
2017-08-14 09:00:00	AAPL	Stock	39.75	39.9075	39.6875	39.816	16000976.0
2017-08-14 10:00:00	AAPL	Stock	39.815	39.9325	39.8013	39.875	11077308.0
2017-08-14 11:00:00	AAPL	Stock	39.8755	39.8768	39.7875	39.8295	6912236.0
2017-08-14 12:00:00	AAPL	Stock	39.83	39.855	39.7625	39.835	4838908.0
2017-08-14 13:00:00	AAPL	Stock	39.8375	40.01	39.8075	39.975	11715460.0
2017-08-14 14:00:00	AAPL	Stock	39.975	40.0375	39.865	39.9012	7861148.0
2017-08-14 15:00:00	AAPL	Stock	39.9002	40.0525	39.8875	39.945	13758516.0
2017-08-14 16:00:00	AAPL	Stock	39.9475	40.025	39.9475	40.0	8091748.0
2017-08-14 17:00:00	AAPL	Stock	40.0175	40.025	40.0025	40.005	81140.0
2017-08-14 18:00:00	AAPL	Stock	40.0	40.0125	39.975	39.975	66380.0
2017-08-14 19:00:00	AAPL	Stock	39.975	40.035	39.975	40.035	78060.0
2017-08-14 04:00:00	MSFT	Stock	72.71	73.13	72.71	73.13	200.0
2017-08-14 07:00:00	MSFT	Stock	73.0	73.06	72.95	73.06	3971.0
2017-08-14 08:00:00	MSFT	Stock	73.14	73.18	73.02	73.1	13916.0
2017-08-14 09:00:00	MSFT	Stock	73.1	73.54	72.95	73.32	2782050.0
2017-08-14 10:00:00	MSFT	Stock	73.32	73.67	73.32	73.535	2375753.0
2017-08-14 11:00:00	MSFT	Stock	73.53	73.61	73.47	73.5	1564906.0
2017-08-14 12:00:00	MSFT	Stock	73.5	73.6	73.48	73.56	1187539.0
2017-08-14 13:00:00	MSFT	Stock	73.57	73.7	73.56	73.63	1332344.0
2017-08-14 14:00:00	MSFT	Stock	73.625	73.72	73.525	73.59	1813304.0
2017-08-14 15:00:00	MSFT	Stock	73.6	73.72	73.47	73.59	4129769.0
2017-08-14 16:00:00	MSFT	Stock	73.59	73.59	73.5	73.56	2723154.0
2017-08-14 17:00:00	MSFT	Stock	73.56	73.57	73.55	73.55	1278.0
2017-08-14 18:00:00	MSFT	Stock	73.57	73.57	73.51	73.56	4454.0
2017-08-14 19:00:00	MSFT	Stock	73.56	73.59	73.56	73.59	2757.0
2017-08-14 04:00:00	NVDA	Stock	3.975	3.975	3.95	3.95	294880.0
2017-08-14 05:00:00	NVDA	Stock	3.9502	3.9648	3.9502	3.9648	25640.0
2017-08-14 06:00:00	NVDA	Stock	3.9648	3.9648	3.9515	3.9625	181960.0
2017-08-14 07:00:00	NVDA	Stock	3.9625	3.9648	3.9325	3.945	1757880.0
2017-08-14 08:00:00	NVDA	Stock	3.938	3.965	3.915	3.9425	7604600.0
2017-08-14 09:00:00	NVDA	Stock	3.9468	4.0518	3.945	4.0312	232052240.0
2017-08-14 10:00:00	NVDA	Stock	4.031	4.0673	4.0258	4.0468	190844840.0
2017-08-14 11:00:00	NVDA	Stock	4.0472	4.1175	4.0472	4.11	175481520.0
2017-08-14 12:00:00	NVDA	Stock	4.11	4.1452	4.1015	4.1255	166396200.0
2017-08-14 13:00:00	NVDA	Stock	4.125	4.1495	4.118	4.1415	101446520.0
2017-08-14 14:00:00	NVDA	Stock	4.141	4.1688	4.1345	4.1498	114196760.0
2017-08-14 15:00:00	NVDA	Stock	4.15	4.2138	4.1478	4.2112	220643120.0
2017-08-14 16:00:00	NVDA	Stock	4.2108	4.2163	4.2028	4.215	13652440.0
2017-08-14 17:00:00	NVDA	Stock	4.2128	4.2148	4.21	4.2125	1316440.0
2017-08-14 18:00:00	NVDA	Stock	4.2125	4.2148	4.2095	4.2098	1705480.0
2017-08-14 19:00:00	NVDA	Stock	4.2102	4.2178	4.2102	4.215	1099680.0
2017-08-14 05:00:00	AMZN	Stock	48.9845	48.9845	48.92	48.92	10100.0
2017-08-14 06:00:00	AMZN	Stock	48.85	48.897	48.85	48.8505	33160.0
2017-08-14 07:00:00	AMZN	Stock	48.875	48.875	48.71	48.71	53640.0
2017-08-14 08:00:00	AMZN	Stock	48.7335	48.85	48.67	48.67	300380.0

> showing 50 of 48,265 rows — these rows as CSV

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