PREVIEW / stock_1hour / 2019-10-25

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-10-25.parquet
  size:    1.1 MB
  rows:    48,927
  symbols: 2,501

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-10-25 05:00:00	AAPL	Stock	60.75	60.75	60.75	60.75	800.0
2019-10-25 06:00:00	AAPL	Stock	60.85	60.9275	60.85	60.895	15584.0
2019-10-25 07:00:00	AAPL	Stock	60.93	60.94	60.84	60.84	38508.0
2019-10-25 08:00:00	AAPL	Stock	60.935	60.95	60.745	60.765	218360.0
2019-10-25 09:00:00	AAPL	Stock	60.7875	61.025	60.72	60.87	6632304.0
2019-10-25 10:00:00	AAPL	Stock	60.865	61.1725	60.81	61.1315	9448748.0
2019-10-25 11:00:00	AAPL	Stock	61.1325	61.463	61.085	61.3425	10813912.0
2019-10-25 12:00:00	AAPL	Stock	61.3432	61.42	61.265	61.315	5279104.0
2019-10-25 13:00:00	AAPL	Stock	61.3202	61.39	61.275	61.315	3477300.0
2019-10-25 14:00:00	AAPL	Stock	61.3175	61.37	61.175	61.3525	5095292.0
2019-10-25 15:00:00	AAPL	Stock	61.3475	61.6825	61.335	61.645	13826036.0
2019-10-25 16:00:00	AAPL	Stock	61.645	61.75	61.63	61.7125	7099548.0
2019-10-25 17:00:00	AAPL	Stock	61.7125	61.72	61.675	61.7	61732.0
2019-10-25 18:00:00	AAPL	Stock	61.69	61.7075	61.655	61.675	50488.0
2019-10-25 19:00:00	AAPL	Stock	61.675	61.6875	61.65	61.6875	115956.0
2019-10-25 05:00:00	MSFT	Stock	139.31	139.8	139.31	139.8	799.0
2019-10-25 06:00:00	MSFT	Stock	139.85	139.94	139.85	139.94	400.0
2019-10-25 07:00:00	MSFT	Stock	139.82	139.94	139.76	139.78	9378.0
2019-10-25 08:00:00	MSFT	Stock	139.85	140.28	139.4	139.51	24199.0
2019-10-25 09:00:00	MSFT	Stock	139.46	140.38	139.2	140.315	2886239.0
2019-10-25 10:00:00	MSFT	Stock	140.31	141.07	140.29	140.77	4313500.0
2019-10-25 11:00:00	MSFT	Stock	140.78	141.14	140.6	140.86	2784307.0
2019-10-25 12:00:00	MSFT	Stock	140.86	140.93	140.5	140.62	1610622.0
2019-10-25 13:00:00	MSFT	Stock	140.635	140.87	140.5	140.56	1417116.0
2019-10-25 14:00:00	MSFT	Stock	140.56	140.62	140.18	140.44	1500516.0
2019-10-25 15:00:00	MSFT	Stock	140.43	140.814	140.31	140.73	3581334.0
2019-10-25 16:00:00	MSFT	Stock	140.74	140.8	140.63	140.75	3955121.0
2019-10-25 17:00:00	MSFT	Stock	140.71	140.75	140.66	140.75	3431.0
2019-10-25 18:00:00	MSFT	Stock	140.79	141.4	140.69	141.4	58106.0
2019-10-25 19:00:00	MSFT	Stock	141.38	144.98	141.38	144.95	543068.0
2019-10-25 04:00:00	NVDA	Stock	4.9775	5.0	4.9775	4.99	50520.0
2019-10-25 05:00:00	NVDA	Stock	4.9905	4.9975	4.9905	4.9925	33400.0
2019-10-25 06:00:00	NVDA	Stock	4.99	5.0075	4.99	5.0075	136160.0
2019-10-25 07:00:00	NVDA	Stock	5.0013	5.015	4.9932	4.999	360480.0
2019-10-25 08:00:00	NVDA	Stock	5.0125	5.0175	4.9092	4.9875	1708160.0
2019-10-25 09:00:00	NVDA	Stock	4.9862	5.082	4.9862	5.053	83423960.0
2019-10-25 10:00:00	NVDA	Stock	5.0527	5.0873	5.033	5.085	60215800.0
2019-10-25 11:00:00	NVDA	Stock	5.0855	5.1345	5.0852	5.1196	61679400.0
2019-10-25 12:00:00	NVDA	Stock	5.1195	5.1245	5.0852	5.0883	37038360.0
2019-10-25 13:00:00	NVDA	Stock	5.0885	5.124	5.0883	5.1104	20800280.0
2019-10-25 14:00:00	NVDA	Stock	5.1106	5.1151	5.0775	5.0955	27639440.0
2019-10-25 15:00:00	NVDA	Stock	5.0952	5.123	5.088	5.1135	50318680.0
2019-10-25 16:00:00	NVDA	Stock	5.1135	5.1172	5.1025	5.1078	3720720.0
2019-10-25 17:00:00	NVDA	Stock	5.1108	5.1188	5.108	5.1125	2950000.0
2019-10-25 18:00:00	NVDA	Stock	5.1125	5.1163	5.1125	5.1135	80440.0
2019-10-25 19:00:00	NVDA	Stock	5.1135	5.1188	5.1135	5.1188	301520.0
2019-10-25 04:00:00	AMZN	Stock	83.5315	84.3035	83.5	84.3035	114820.0
2019-10-25 05:00:00	AMZN	Stock	84.325	84.4	83.95	84.25	67900.0
2019-10-25 06:00:00	AMZN	Stock	84.15	84.15	83.965	84.0	69220.0
2019-10-25 07:00:00	AMZN	Stock	84.013	84.0235	83.325	83.45	618660.0

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

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